diff options
| author | Navan Chauhan <navanchauhan@gmail.com> | 2020-07-07 12:22:30 +0530 |
|---|---|---|
| committer | Navan Chauhan <navanchauhan@gmail.com> | 2020-07-07 12:22:30 +0530 |
| commit | 6a67fd7e8b7e3244fb009e7101e5c501bf2439d8 (patch) | |
| tree | 8a441b173047b57fa4a577e599df0370b86582e9 /app/create_table.py | |
| parent | c74428d94a79087ca5aed2a23e1535864c924124 (diff) | |
removed extra files and changed zi to zipArchive
Diffstat (limited to 'app/create_table.py')
| -rw-r--r-- | app/create_table.py | 17 |
1 files changed, 0 insertions, 17 deletions
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 |