From 6a67fd7e8b7e3244fb009e7101e5c501bf2439d8 Mon Sep 17 00:00:00 2001 From: Navan Chauhan Date: Tue, 7 Jul 2020 12:22:30 +0530 Subject: removed extra files and changed zi to zipArchive --- app/create_table.py | 17 ----------------- 1 file changed, 17 deletions(-) delete mode 100644 app/create_table.py (limited to 'app/create_table.py') diff --git a/app/create_table.py b/app/create_table.py deleted file mode 100644 index a431ba4..0000000 --- a/app/create_table.py +++ /dev/null @@ -1,17 +0,0 @@ -import mysql.connector as con - -mycon = con.connect(host="sql12.freesqldatabase.com",user="sql12352288",password="7X35JENbK3",port=3306,database="sql12352288") - -mycursor = mycon.cursor() - -try: - mycursor.execute("create table curie (id INT PRIMARY KEY, email VARCHAR(255), receptor VARCHAR(255), ligand VARCHAR(255), config VARCHAR(255), date DATE, description VARCHAR(255),done TINYINT DEFAULT 0)") -except con.ProgrammingError: - print("Table Already Exists!") - -try: - mycursor.execute("insert into curie values (1,'navanchauhan@gmail.com','lu.pdbqt','test.pdbqt','owo.txt',CURDATE(),'CURIE WEB TASK',0)") -except con.IntegrityError: - print("Duplicate Entry For Primary Key!") - -mycon.commit() \ No newline at end of file -- cgit v1.2.3