def save_data(group_id, picture_id):
id = genUUID()
dic = dict()
dic['group_id'] = group_id
dic['picture_id'] = picture_id
dis = ""
for key in dic:
dis += key
dis += "='"
dis += str(dic[key])
dis += "',"
dis = dis[0:len(dis) - 1]
mysql = MysqlHelper(Configs())
sql = "insert into "
sql += tableName
sql += " set id=%s,"
sql += dis
mysql.save(sql, id)
return id
def save_data(self, url):
id = genUUID()
name = genUUID() + ".jpg"
dic = dict()
dic['filename'] = name
dic['min_path'] = url
dic['normal_path'] = url
dic['origin_filename'] = name
dic['valid'] = 1
dis = ""
for key in dic:
dis += key
dis += "='"
dis += str(dic[key])
dis += "',"
dis = dis[0:len(dis) - 1]
mysql = MysqlHelper(Configs())
sql = "insert into "
sql += tableName
sql += " set id=%s,"
sql += dis
mysql.save(sql, id)
return id
def save_data_insert(dic):
id = genUUID()
mysql = MysqlHelper(Configs())
_sql = "INSERT INTO news(`id`, "
_val = " VALUES (%s,"
_par = [
id,
]
for key in dic:
_sql += "`"
_sql += key
_sql += "`,"
if type(dic[key]) == type(str):
_val += "%s,"
elif type(dic[key]) == type(int):
_val += "%i,"
else:
_val += "%s,"
_par.append(dic[key])
_sql = _sql[0:len(_sql) - 1]
_sql += ")"
_val = _val[0:len(_val) - 1]
_val += ")"
_sql += _val
mysql.save(_sql, _par)
sql = "insert into "
sql += article_table_name
sql += " set id=%s"
mysql.save(sql, id)
def save_data(dic):
dis = ""
id = genUUID()
for key in dic:
dis += key
dis += "='"
dis += str(dic[key])
dis += "',"
dis = dis[0:len(dis) - 1]
mysql = MysqlHelper(Configs())
sql = "insert into news set id=%s,"
sql += dis
mysql.save(sql, id)
sql = "insert into "
sql += article_table_name
sql += " set id=%s"
mysql.save(sql, id)