added automatic table craetion

1 files changed, 5 insertions, 0 deletions

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()