def initsystem():
strQuery = "DROP TABLE FileNames;"
print("Dropping table FileNames")
retVal = db.executeQuery(strQuery)
strQuery = "DROP TABLE Extentions;"
print("Dropping table Extentions")
retVal = db.executeQuery(strQuery)
db.sql_table()
return "Database Created"
def whipefiles():
print("Clearing out database")
strQuery = "delete from FileNames"
retVal = db.executeQuery(strQuery)
strPath = os.path.dirname(__file__) + vars._DoneFile
return mw.getTemplate(strPath).replace("%MESSAGE%", str(retVal))
def dostuff():
debug.debugPrint("Testing")
#strFooterPath=os.path.dirname(__file__) + vars._TestFile
#print("Generated Test1: " + strFooterPath)
#return mw.doStuff(strFooterPath)
#strQuery="insert into Extentions(Ext, count)values('" + str(strExt) + "','1')"
strQuery = "insert into Extentions(Ext, count)values('gif','1')"
strRet = db.executeQuery(strQuery)
return str(strRet)
def whipefiles():
print("Clearing out database")
strQuery = "delete from FileNames"
retVal = db.executeQuery(strQuery)
return "Data Cleared"