def delete(self, tablename, id):
db = Database()
template = "delete from {0} where id=?"
params = [
id,
]
sql = template.format(tablename)
db.run(sql, params)
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 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 delete(self,tablename,id):
db = Database()
template = "delete from {0} where id=?"
params = [id,]
sql = template.format(tablename)
db.run(sql,params)
