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