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)
