def get(self,tablename,id): db = Database() template = "select * from {0} where id=?" params = [id,] sql = template.format(tablename) row = db.get_one_record(sql,params) return row
def delete(self, tablename, id): db = Database() template = "delete from {0} where id=?" params = [ id, ] sql = template.format(tablename) db.run(sql, params)
def select(self, tablename, values): db = Database() template = "select * from {0} where {1}" t = self._get_update_parameters(values, " AND ") params = t[0] cols = t[1] sql = template.format(tablename, cols) rows = db.get_records(sql, params) return rows
def get(self, tablename, id): db = Database() template = "select * from {0} where id=?" params = [ id, ] sql = template.format(tablename) row = db.get_one_record(sql, params) return row
def update(self, tablename, values, id): db = Database() template = "update {0} set {1} where id=?" t = self._get_update_parameters(values) params = t[0] params.append(id) cols = t[1] sql = template.format(tablename, cols) db.run(sql, params)
def select(self,tablename,values): db = Database() template = "select * from {0} where {1}" t = self._get_update_parameters(values," AND ") params = t[0] cols = t[1] sql = template.format(tablename,cols) rows = db.get_records(sql,params) return rows
def update(self,tablename,values,id): db = Database() template = "update {0} set {1} where id=?" t = self._get_update_parameters(values) params = t[0] params.append(id) cols = t[1] sql = template.format(tablename,cols) db.run(sql,params)
def insert(self, tablename, values): """values is dictionary - key=column name,value=column value""" db = Database() template = "insert into {0}({1}) values({2})" t = self._get_insert_parameters(values) params = t[0] cols = t[1] question = self._get_questions(values) sql = template.format(tablename, cols, question) db.run(sql, params)
def insert(self,tablename,values): """values is dictionary - key=column name,value=column value""" db = Database() template = "insert into {0}({1}) values({2})" t = self._get_insert_parameters(values) params = t[0] cols = t[1] question = self._get_questions(values) sql = template.format(tablename,cols,question) db.run(sql,params)
def insert_get_id(self, tablename, values): self.insert(tablename, values) sql = "select max(id) as maxid from " + tablename row = Database().get_one_record(sql, []) return int(row["maxid"])
def delete(self,tablename,id): db = Database() template = "delete from {0} where id=?" params = [id,] sql = template.format(tablename) db.run(sql,params)