def __make_update_sqls(self, data_ls):
if not data_ls:
return
strip_dic_list(data_ls)
values_ls = []
for data in data_ls:
assert self.key_field in data
set_str_ls = []
for field, value in data.items():
if field not in self.field_info_dic:
continue
field_info = self.field_info_dic[field]
if field == self.key_field:
continue
if is_db_string(field_info['DATA_TYPE']):
set_str_ls.append(
'%s=\'%s\'' %
(field, MySQLdb.escape_string(str(value))))
else:
set_str_ls.append('%s=%s' % (field, value))
kft = self.field_info_dic[self.key_field]['DATA_TYPE']
key_str = ('%s=\'%s\'' if kft else '%s=%d') % (
self.key_field, MySQLdb.escape_string(str(
data[self.key_field])))
set_str = ','.join(set_str_ls)
values_ls.append('UPDATE %s SET %s WHERE %s' %
(self.table_name, set_str, key_str))
return values_ls
def __make_update_sqls(self, data_ls):
if not data_ls:
return
strip_dic_list(data_ls)
values_ls = []
for data in data_ls:
assert self.key_field in data
set_str_ls = []
for field, value in data.items():
if field not in self.field_info_dic:
continue
field_info = self.field_info_dic[field]
if field == self.key_field:
continue
if is_db_string(field_info['DATA_TYPE']):
set_str_ls.append('%s=\'%s\'' % (field, MySQLdb.escape_string(str(value))))
else:
set_str_ls.append('%s=%s' % (field, value))
kft = self.field_info_dic[self.key_field]['DATA_TYPE']
key_str = ('%s=\'%s\'' if kft else '%s=%d') % (self.key_field, MySQLdb.escape_string(str(data[self.key_field])))
set_str = ','.join(set_str_ls)
values_ls.append('UPDATE %s SET %s WHERE %s' % (self.table_name, set_str, key_str))
return values_ls
def __make_delete_sql(self, data_ls):
if not data_ls:
return
strip_dic_list(data_ls)
sql = "delete from " + self.table_name + " where "
for idx, data in enumerate(data_ls):
assert self.key_field in data
kft = self.field_info_dic[self.key_field]['DATA_TYPE']
key_str = ('%s=\'%s\'' if kft else '%s=%d') % (self.key_field, MySQLdb.escape_string(str(data[self.key_field])))
sql += "%s" % key_str if idx == 0 else "OR %s" % key_str
return sql
def __make_delete_sql(self, data_ls):
if not data_ls:
return
strip_dic_list(data_ls)
sql = "delete from " + self.table_name + " where "
for idx, data in enumerate(data_ls):
assert self.key_field in data
kft = self.field_info_dic[self.key_field]['DATA_TYPE']
key_str = ('%s=\'%s\'' if kft else '%s=%d') % (self.key_field, MySQLdb.escape_string(str(data[self.key_field])))
sql += "%s" % key_str if idx == 0 else "OR %s" % key_str
return sql
def __make_sql_full_values(self, data_ls):
if not data_ls:
return
strip_dic_list(data_ls)
values_ls = []
for data in data_ls:
values = []
for field in self.fields:
field_info = self.field_info_dic[field]
info = data.get(field_info['COLUMN_NAME'], field_info['COLUMN_DEFAULT'])
if is_db_string(field_info['DATA_TYPE']):
if not str(info) or str(info) == 'None':
info = ''
values.append("'" + MySQLdb.escape_string(str(info)) + "'")
else:
if not info:
info = 0
values.append(str(info))
values_ls.append('(' + ','.join(values) + ')')
return values_ls
def __make_sql_full_values(self, data_ls):
if not data_ls:
return
strip_dic_list(data_ls)
values_ls = []
for data in data_ls:
values = []
for field in self.fields:
field_info = self.field_info_dic[field]
info = data.get(field_info['COLUMN_NAME'], field_info['COLUMN_DEFAULT'])
if is_db_string(field_info['DATA_TYPE']):
if not str(info) or str(info) == 'None':
info = ''
values.append("'" + MySQLdb.escape_string(str(info)) + "'")
else:
if not info:
info = 0
values.append(str(info))
values_ls.append('(' + ','.join(values) + ')')
return values_ls
def ajax_recv_param_wapper(self, *args, **kwargs):
ajax_data_ls = ujson.loads(kwargs.pop(AJAX_DATA_LS_KEY, "[]"))
strip_dic_list(ajax_data_ls)
kwargs[AJAX_DATA_LS_KEY] = ajax_data_ls
return fun(self, *args, **kwargs)
def query(self, sql):
data_ls = self.db_instance.read_db(sql)
strip_dic_list(data_ls)
return data_ls
def query_all(self):
sql = "select * from " + self.table_name
data_ls = self.db_instance.read_db(sql)
strip_dic_list(data_ls)
return data_ls
def query(self, sql):
data_ls = self.db_instance.read_db(sql)
strip_dic_list(data_ls)
return data_ls
def query_all(self):
sql = "select * from " + self.table_name
data_ls = self.db_instance.read_db(sql)
strip_dic_list(data_ls)
return data_ls
