Y9eaGK5k

1import mysql.connector
2all_sql_tables = [...]
3
4# An example of a single table creation called "articles" in SQL command  
5sql_articles = """CREATE TABLE IF NOT EXISTS articles (ID int AUTO_INCREMENT,
6                                                     doi_link varchar(255) NOT NULL,
7                                                     title varchar(255),
8                                                     abstract TEXT,
9                                                     publication_date varchar(255),
10                                                     citations int,
11                                                     UNIQUE (doi_link),  
12                                                     PRIMARY KEY(ID));"""
13all_sql_tables.append(sql_articles) # list of all sql tables creation