class sqliteListstore(object): def __init__(self,dbFile,name,tabelType): self.listStore = Gtk.ListStore(self.db.getListStoreCols(tableType)) self.db = DB(dbFile) self.type = tableType self.table = tableType + '_' + name if not self.db._tableExists(self.table): self.db.createNew(self.type,self.table) else: #Fill the liststore with the table values for row in self.db.c.execute("SELECT ? from ?",", ".join(self.db.getListStoreTableMap(self.tableType)),self.table): self.listStore.append(list(row)) def insert(self,dictValues): #This shoud work, not tested tableMap = self.db.getListStoreTableMap(self.tableType) for item in dictValues: v = [] for mapper in tableMap: v.append(item[mapper]) self.db.c.execute("INSERT INTO ? VALUES (?)",self.tableType,item) self.listStore.append(v) return True def update(self,treePath,dictValues): return True def remove(self,treePath): return True def getListstore(self): return self.listStore
def __init__(self,dbFile,name,tabelType): self.listStore = Gtk.ListStore(self.db.getListStoreCols(tableType)) self.db = DB(dbFile) self.type = tableType self.table = tableType + '_' + name if not self.db._tableExists(self.table): self.db.createNew(self.type,self.table) else: #Fill the liststore with the table values for row in self.db.c.execute("SELECT ? from ?",", ".join(self.db.getListStoreTableMap(self.tableType)),self.table): self.listStore.append(list(row))