From ee9dd0699794b60e4f1b421e23f9d5d7c497f049 Mon Sep 17 00:00:00 2001 From: Navan Chauhan Date: Thu, 10 Sep 2020 13:35:36 +0530 Subject: added automatic table craetion --- tests/dbTestFiller.py | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'tests') diff --git a/tests/dbTestFiller.py b/tests/dbTestFiller.py index 02d51de..6971553 100644 --- a/tests/dbTestFiller.py +++ b/tests/dbTestFiller.py @@ -10,6 +10,11 @@ mycon = con.connect(host=config['DATABASE']['HOST'],user=config['DATABASE']['USE mycursor = mycon.cursor() done = 1 +try: + mycursor.execute("create table curieweb ( id varchar(16) primary key, email nvarchar(255) NOT NULL, protein LONGBLOB NOT NULL, protein_name VARCHAR(255), ligand_pdbqt LONGBLOB, ligand_smile VARCHAR(255), ligand_name VARCHAR(255), config LONGBLOB NOT NULL, date DATE, description VARCHAR(255), done TINYINT DEFAULT 0, pdb VARCHAR(4),csv longblob)") +except con.ProgrammingError: + print("Table Already Exists!") + def convertToBinaryData(filename): with open(filename, 'rb') as file: binaryData = file.read() -- cgit v1.2.3