def createTable(choosenDB): if request.GET.get('create_table_btn', '').strip(): dbmanager = databaseManager() dbNames = dbmanager.getDatabaseNames() message = "" index = 1 AllCols = [] while (True): if request.GET.get('ColName%s' % index, '').strip(): columnAtr = [] columnAtr.append( request.GET.get('ColName%s' % index, '').strip()) columnAtr.append( request.GET.get('colType%s' % index, '').strip()) columnAtr.append( request.GET.get('isNull%s' % index, '').strip()) columnAtr.append( request.GET.get('defaultValue%s' % index, '').strip()) columnAtr.append( request.GET.get('isAI%s' % index, '').strip()) columnAtr.append( request.GET.get('isPK%s' % index, '').strip()) index = index + 1 AllCols.append(columnAtr) else: break t1 = database1(choosenDB) message = t1.createTable( request.GET.get('tableName', '').strip(), AllCols) t1 = database1(choosenDB) tablesList = t1.getTablesNames() output = template('./templates/createTable/createtableconf', dbNames=dbNames, message=message, choosenDB=choosenDB, tablesList=tablesList) return output else: dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") dbNames = dbmanager.getDatabaseNames() t1 = database1(choosenDB) tablesList = t1.getTablesNames() output = template('./templates/createTable/createtable', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList) return output
def manageDataInsert(choosenDB, tableName): message = "Succesfull" dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB, tableName) tablesList = t1.getTablesNames() dbNames = dbmanager.getDatabaseNames() tableColNames = table1.getColNames() if request.GET.get('addRow', '').strip(): rowData = [] for colName in tableColNames: rowData.append(request.GET.get("%s" % colName, '').strip()) message = table1.insertRow(rowData) if message == "Succesfull": redirect("../%s" % tableName) output = template('./templates/manageData/insertRow', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, tableName=tableName, message=message, tableColNames=tableColNames) return output
def updateRow(choosenDB,tableName,rowID): message = "" dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB,tableName); tablesList = t1.getTablesNames(); dbNames = dbmanager.getDatabaseNames(); tableColNames = table1.getColNames() rowData = table1.getRowData(rowID) if request.GET.get('updateRow','').strip(): rowData = [] for colName in tableColNames: rowData.append([colName,request.GET.get("%s" %colName,'').strip()]) message = table1.updateRow(rowData,rowID) #return message if message == "Succesfull": message = "The record was updated successfully" output = template('./templates/manageData/editRow',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList,tableName=tableName,message=message,rowData=rowData,rowID=rowID) return output;
def manageDataInsert(choosenDB,tableName): message = "Succesfull" dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB,tableName); tablesList = t1.getTablesNames(); dbNames = dbmanager.getDatabaseNames(); tableColNames = table1.getColNames() if request.GET.get('addRow','').strip(): rowData = [] for colName in tableColNames: rowData.append(request.GET.get("%s" %colName,'').strip()) message = table1.insertRow(rowData) if message == "Succesfull": redirect("../%s" %tableName) output = template('./templates/manageData/insertRow',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList,tableName=tableName,message=message,tableColNames=tableColNames) return output;
def manageData(choosenDB,tableName): message = "Succesfull" dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB,tableName); if request.GET.get('deleteCol','').strip(): rowID = int(request.GET.get('deleteCol','').strip()) table1.deleteRow(rowID) tablesList = t1.getTablesNames(); dbNames = dbmanager.getDatabaseNames(); tableColNames = table1.getColNames() pageNo = request.GET.get('pageNo','').strip() if pageNo: pageNo = int(pageNo) tableData = table1.getData((pageNo-1)*30); else: pageNo = 1 tableData = table1.getData(0); noOfPages = (table1.getNumberofPages()/30) + 1 output = template('./templates/manageData/manageData',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList,tableName=tableName,message=message,tableColNames=tableColNames,tableData=tableData,noOfPages=noOfPages,pageNo=pageNo) return output;
def do_upload(choosenDB, tableName): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") dbNames = dbmanager.getDatabaseNames() tablesList = t1.getTablesNames() table1 = table(choosenDB, tableName) data = request.files.data if data and data.file: raw = data.file.read() filename = data.filename with open("./temp/importFiles/%s" % (filename), 'w') as open_file: open_file.write(raw) message = table1.importCSV("./temp/importFiles/%s" % (filename)) else: message = "You missed a field." output = template('./templates/importData/importDataUpload', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, message=message) return output
def manageTable(choosenDB,tableName): message = "Succesfull" dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB,tableName); if request.GET.get('deleteCol','').strip(): message = table1.deleteCol(request.GET.get('deleteCol','').strip()) if request.GET.get('add_col_btn','').strip(): ColName = request.GET.get('ColName','').strip() colType = request.GET.get('colType','').strip() isNull = request.GET.get('isNull','').strip() isAI = request.GET.get('isAI','').strip() defaultValue = request.GET.get('defaultValue','').strip() message = table1.addColumn(ColName,colType,isNull,defaultValue) tablesList = t1.getTablesNames(); tColsInfo = table1.getAllColsInfo(); dbNames = dbmanager.getDatabaseNames(); output = template('./templates/manageTable/manageTable',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList,tableName=tableName,tColsInfo=tColsInfo,message=message) return output;
def createIndexConfirm(choosenDB, tableName): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") dbNames = dbmanager.getDatabaseNames() tablesList = t1.getTablesNames() table1 = table(choosenDB, tableName) tableColNames = table1.getColNames() index_name = request.POST.get('IndexName', '').strip() index_tbl_name = request.POST.get('tableN', '').strip() index_col_list = request.POST.getall('col') indexManager1 = indexManager(choosenDB) message = indexManager1.createIndex(index_name, index_tbl_name, index_col_list) output = template('./templates/createIndex/createIndexConf', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, tableName=tableName, tableColNames=tableColNames, message=message) return output
def manageTable(choosenDB, tableName): message = "Succesfull" dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB, tableName) if request.GET.get('deleteCol', '').strip(): message = table1.deleteCol(request.GET.get('deleteCol', '').strip()) if request.GET.get('add_col_btn', '').strip(): ColName = request.GET.get('ColName', '').strip() colType = request.GET.get('colType', '').strip() isNull = request.GET.get('isNull', '').strip() isAI = request.GET.get('isAI', '').strip() defaultValue = request.GET.get('defaultValue', '').strip() message = table1.addColumn(ColName, colType, isNull, defaultValue) tablesList = t1.getTablesNames() tColsInfo = table1.getAllColsInfo() dbNames = dbmanager.getDatabaseNames() output = template('./templates/manageTable/manageTable', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, tableName=tableName, tColsInfo=tColsInfo, message=message) return output
def createTable(choosenDB): if request.GET.get('create_table_btn','').strip(): dbmanager = databaseManager(); dbNames = dbmanager.getDatabaseNames(); message="" index = 1; AllCols = []; while(True): if request.GET.get('ColName%s' %index,'').strip(): columnAtr = [] columnAtr.append(request.GET.get('ColName%s' %index,'').strip()); columnAtr.append(request.GET.get('colType%s' %index,'').strip()); columnAtr.append(request.GET.get('isNull%s' %index,'').strip()); columnAtr.append(request.GET.get('defaultValue%s' %index,'').strip()); columnAtr.append(request.GET.get('isAI%s' %index,'').strip()); columnAtr.append(request.GET.get('isPK%s' %index,'').strip()); index = index + 1; AllCols.append(columnAtr); else: break; t1 = database1(choosenDB) message = t1.createTable(request.GET.get('tableName','').strip(),AllCols) t1 = database1(choosenDB) tablesList = t1.getTablesNames(); output = template('./templates/createTable/createtableconf',dbNames=dbNames,message=message,choosenDB=choosenDB,tablesList=tablesList) return output; else: dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") dbNames = dbmanager.getDatabaseNames(); t1 = database1(choosenDB) tablesList = t1.getTablesNames(); output = template('./templates/createTable/createtable',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList) return output;
def dropTable(choosenDB): if request.GET.get('drop_table_btn', '').strip(): dbmanager = databaseManager() dbNames = dbmanager.getDatabaseNames() message = "" tableName = request.GET.get('tableName', '').strip() if tableName: t1 = database1(choosenDB) message = t1.dropTable(tableName) else: message = "Error, no table was chosen" t1 = database1(choosenDB) tablesList = t1.getTablesNames() output = template('./templates/dropTable/droptableconf', dbNames=dbNames, message=message, choosenDB=choosenDB, tablesList=tablesList) return output else: dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") dbNames = dbmanager.getDatabaseNames() t1 = database1(choosenDB) tablesList = t1.getTablesNames() t1 = database1(choosenDB) tablesList = t1.getTablesNames() output = template('./templates/dropTable/dropTable', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList) return output
def createView(choosenDB): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); tablesList = t1.getTablesNames(); output = template('./templates/createView/createView',dbNames=dbNames,choosenDB=choosenDB,tablesList = tablesList) return output;
def manageDataforntPage(choosenDB): message = "Succesfull" dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) tablesList = t1.getTablesNames(); dbNames = dbmanager.getDatabaseNames(); output = template('./templates/manageData/manageDataFrontPage',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList,message=message) return output;
def createView(choosenDB): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() tablesList = t1.getTablesNames() output = template('./templates/createView/createView', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList) return output
def editView(choosenDB,viewName): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); viewmanager1 = viewManager(choosenDB) message = "start" sqlStat = viewmanager1.getViewSQL(viewName) output = template('./templates/manageView/editView',dbNames=dbNames,choosenDB=choosenDB,sqlStat=sqlStat,message=message,viewName=viewName) return output;
def createView3(choosenDB): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); tablesList = t1.getTablesNames(); Viewquery = request.GET.get('Viewquery','').strip() message = t1.SQLQuery(Viewquery) output = template('./templates/createView/createView3',dbNames=dbNames,choosenDB=choosenDB,Viewquery=Viewquery,message = message) return output;
def createIndexTableChosen(choosenDB,tableName): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") dbNames = dbmanager.getDatabaseNames(); tablesList = t1.getTablesNames(); table1 = table(choosenDB,tableName); tableColNames = table1.getColNames() output = template('./templates/createIndex/createIndexTC',dbNames=dbNames,choosenDB=choosenDB,tablesList = tablesList,tableName=tableName,tableColNames=tableColNames) return output;
def dropTable(choosenDB): if request.GET.get('drop_table_btn','').strip(): dbmanager = databaseManager(); dbNames = dbmanager.getDatabaseNames(); message="" tableName = request.GET.get('tableName','').strip(); if tableName: t1 = database1(choosenDB) message = t1.dropTable(tableName); else: message = "Error, no table was chosen" t1 = database1(choosenDB) tablesList = t1.getTablesNames(); output = template('./templates/dropTable/droptableconf',dbNames=dbNames,message=message,choosenDB=choosenDB,tablesList=tablesList) return output; else: dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") dbNames = dbmanager.getDatabaseNames(); t1 = database1(choosenDB) tablesList = t1.getTablesNames(); t1 = database1(choosenDB) tablesList = t1.getTablesNames(); output = template('./templates/dropTable/dropTable',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList) return output;
def SQLQuery(choosenDB): message = "start" query = "" dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); if request.GET.get('submit','').strip(): query = request.GET.get('query','').strip() if query: message = t1.SQLQuery(query) output = template('./templates/SQLQuery/SQLQuery',dbNames=dbNames,choosenDB=choosenDB,message=message,query=query) return output;
def manageDataforntPage(choosenDB): message = "Succesfull" dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) tablesList = t1.getTablesNames() dbNames = dbmanager.getDatabaseNames() output = template('./templates/manageData/manageDataFrontPage', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, message=message) return output
def manageView(choosenDB): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); viewmanager1 = viewManager(choosenDB) viewName = request.GET.get('dropView','').strip() if viewName: viewmanager1.dropView(viewName) viewNames = viewmanager1.getViewNames() output = template('./templates/manageView/manageView',dbNames=dbNames,choosenDB=choosenDB,viewNames=viewNames) return output;
def dropIndex(choosenDB): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); indexManager1 = indexManager(choosenDB) if(request.GET.get('dropIndex','').strip()): indexManager1.dropIndex(request.GET.get('dropIndex','').strip()) indInfo = indexManager1.getAllIndicesInfo() output = template('./templates/dropIndex/dropIndex',dbNames=dbNames,choosenDB=choosenDB,indInfo=indInfo) return output;
def database(choosenDB): dbmanager = databaseManager(); dbNames = dbmanager.getDatabaseNames(); t1 = database1(choosenDB) if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") isValid = t1.isValidSQliteDatase() if isValid: tablesList = t1.getTablesNames(); output = template('./templates/index/database',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList) return output; else: output = template('./templates/index/indexInvalidDatabase',dbNames=dbNames,choosenDB=choosenDB) return output;
def createView3(choosenDB): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() tablesList = t1.getTablesNames() Viewquery = request.GET.get('Viewquery', '').strip() message = t1.SQLQuery(Viewquery) output = template('./templates/createView/createView3', dbNames=dbNames, choosenDB=choosenDB, Viewquery=Viewquery, message=message) return output
def createView2(choosenDB): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames(); tablesList = t1.getTablesNames(); tableName = request.GET.get('tableN','').strip() viewName = request.GET.get('ViewName','').strip() table1 = table(choosenDB,tableName); tableColNames = ",".join(table1.getColNames()) Viewquery = "CREATE VIEW %s AS \nSELECT %s \nFROM %s" %(viewName,tableColNames,tableName) output = template('./templates/createView/createView2',dbNames=dbNames,choosenDB=choosenDB,Viewquery=Viewquery) return output;
def editView(choosenDB, viewName): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() viewmanager1 = viewManager(choosenDB) message = "start" sqlStat = viewmanager1.getViewSQL(viewName) output = template('./templates/manageView/editView', dbNames=dbNames, choosenDB=choosenDB, sqlStat=sqlStat, message=message, viewName=viewName) return output
def dropIndex(choosenDB): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() indexManager1 = indexManager(choosenDB) if (request.GET.get('dropIndex', '').strip()): indexManager1.dropIndex(request.GET.get('dropIndex', '').strip()) indInfo = indexManager1.getAllIndicesInfo() output = template('./templates/dropIndex/dropIndex', dbNames=dbNames, choosenDB=choosenDB, indInfo=indInfo) return output
def manageView(choosenDB): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() viewmanager1 = viewManager(choosenDB) viewName = request.GET.get('dropView', '').strip() if viewName: viewmanager1.dropView(viewName) viewNames = viewmanager1.getViewNames() output = template('./templates/manageView/manageView', dbNames=dbNames, choosenDB=choosenDB, viewNames=viewNames) return output
def createIndexTableChosen(choosenDB, tableName): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") dbNames = dbmanager.getDatabaseNames() tablesList = t1.getTablesNames() table1 = table(choosenDB, tableName) tableColNames = table1.getColNames() output = template('./templates/createIndex/createIndexTC', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, tableName=tableName, tableColNames=tableColNames) return output
def SQLQuery(choosenDB): message = "start" query = "" dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() if request.GET.get('submit', '').strip(): query = request.GET.get('query', '').strip() if query: message = t1.SQLQuery(query) output = template('./templates/SQLQuery/SQLQuery', dbNames=dbNames, choosenDB=choosenDB, message=message, query=query) return output
def database(choosenDB): dbmanager = databaseManager() dbNames = dbmanager.getDatabaseNames() t1 = database1(choosenDB) if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") isValid = t1.isValidSQliteDatase() if isValid: tablesList = t1.getTablesNames() output = template('./templates/index/database', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList) return output else: output = template('./templates/index/indexInvalidDatabase', dbNames=dbNames, choosenDB=choosenDB) return output
def createView2(choosenDB): dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) dbNames = dbmanager.getDatabaseNames() tablesList = t1.getTablesNames() tableName = request.GET.get('tableN', '').strip() viewName = request.GET.get('ViewName', '').strip() table1 = table(choosenDB, tableName) tableColNames = ",".join(table1.getColNames()) Viewquery = "CREATE VIEW %s AS \nSELECT %s \nFROM %s" % ( viewName, tableColNames, tableName) output = template('./templates/createView/createView2', dbNames=dbNames, choosenDB=choosenDB, Viewquery=Viewquery) return output
def createIndexConfirm(choosenDB,tableName): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB); if not t1.doesTableExist(tableName): redirect("/error") dbNames = dbmanager.getDatabaseNames(); tablesList = t1.getTablesNames(); table1 = table(choosenDB,tableName); tableColNames = table1.getColNames() index_name = request.POST.get('IndexName','').strip() index_tbl_name = request.POST.get('tableN','').strip() index_col_list = request.POST.getall('col') indexManager1 = indexManager(choosenDB) message = indexManager1.createIndex(index_name,index_tbl_name,index_col_list) output = template('./templates/createIndex/createIndexConf',dbNames=dbNames,choosenDB=choosenDB,tablesList = tablesList,tableName=tableName,tableColNames=tableColNames,message = message) return output;
def manageData(choosenDB, tableName): message = "Succesfull" dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB, tableName) if request.GET.get('deleteCol', '').strip(): rowID = int(request.GET.get('deleteCol', '').strip()) table1.deleteRow(rowID) tablesList = t1.getTablesNames() dbNames = dbmanager.getDatabaseNames() tableColNames = table1.getColNames() pageNo = request.GET.get('pageNo', '').strip() if pageNo: pageNo = int(pageNo) tableData = table1.getData((pageNo - 1) * 30) else: pageNo = 1 tableData = table1.getData(0) noOfPages = (table1.getNumberofPages() / 30) + 1 output = template('./templates/manageData/manageData', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, tableName=tableName, message=message, tableColNames=tableColNames, tableData=tableData, noOfPages=noOfPages, pageNo=pageNo) return output
def do_upload(choosenDB,tableName): dbmanager = databaseManager(); if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") dbNames = dbmanager.getDatabaseNames(); tablesList = t1.getTablesNames(); table1 = table(choosenDB,tableName); data = request.files.data if data and data.file: raw = data.file.read() filename = data.filename with open("./temp/importFiles/%s" %(filename),'w') as open_file: open_file.write(raw) message = table1.importCSV("./temp/importFiles/%s" %(filename)) else: message = "You missed a field." output = template('./templates/importData/importDataUpload',dbNames=dbNames,choosenDB=choosenDB,tablesList=tablesList,message = message) return output;
def updateRow(choosenDB, tableName, rowID): message = "" dbmanager = databaseManager() if not dbmanager.doesDBExists(choosenDB.replace('.db', '')): redirect("/error") t1 = database1(choosenDB) if not t1.doesTableExist(tableName): redirect("/error") table1 = table(choosenDB, tableName) tablesList = t1.getTablesNames() dbNames = dbmanager.getDatabaseNames() tableColNames = table1.getColNames() rowData = table1.getRowData(rowID) if request.GET.get('updateRow', '').strip(): rowData = [] for colName in tableColNames: rowData.append( [colName, request.GET.get("%s" % colName, '').strip()]) message = table1.updateRow(rowData, rowID) #return message if message == "Succesfull": message = "The record was updated successfully" output = template('./templates/manageData/editRow', dbNames=dbNames, choosenDB=choosenDB, tablesList=tablesList, tableName=tableName, message=message, rowData=rowData, rowID=rowID) return output