def addUserDetail(self, user_login_id, gender, img_path, birthday,
province, city, marriage):
#
db = DBUtil()
db.execute_insert(
'insert into `USER_DETAILS` VALUE(id,%s,%s,%s,%s,%s,%s,%s)',
(user_login_id, gender, img_path, birthday, province, city,
marriage))
def addUserCategory(self, user_id, category_name, isDelete):
#USERID INT PRIMARY KEY,USERNAME VARCHAR(20),PASSWORD VARCHAR(32),REGTIME DATETIME,DELFLAG INT
db = DBUtil()
sql = 'insert into `USER_CATEGORY` VALUE(id,%d,"%s",%d)' % (
user_id, category_name, isDelete)
id = db.execute_insert(sql)
return id
def addCategory(self, name):
# USERID INT PRIMARY KEY,USERNAME VARCHAR(20),PASSWORD VARCHAR(32),REGTIME DATETIME,DELFLAG INT
db = DBUtil()
db.execute_insert('insert into Category VALUE(id,%s)', (name))
def addUserImg(self, user_login_id, img_path):
db = DBUtil()
db.execute_insert('insert into user_img VALUE(id,%s,%s)',
(img_path, user_login_id))
def addUserTag(self,userid,daily_id,tag):
#USERID INT PRIMARY KEY,USERNAME VARCHAR(20),PASSWORD VARCHAR(32),REGTIME DATETIME,DELFLAG INT
db = DBUtil()
sql = 'insert into `USER_DAILY_TAGS` VALUE(id,%d,%d,"%s")'%(userid,daily_id,tag)
id = db.execute_insert(sql)
return id
def addDaily(self,title,body,create_time,category,user_id,modified_time,click):
#USERID INT PRIMARY KEY,USERNAME VARCHAR(20),PASSWORD VARCHAR(32),REGTIME DATETIME,DELFLAG INT
db = DBUtil()
print(type(category))
id = db.execute_insert('insert into `DAILY` VALUE(id,"%s","%s","%s","%s",%d,%d,%d)'%(title,body,create_time,modified_time,category,user_id,click))
return id
def addUserDailyDetail(self,category_id,daily_id):
db = DBUtil()
sql = 'insert into `USER_DAILY_DETAILS` VALUE(id,%d,%d)'%(category_id,daily_id)
db.execute_insert(sql)
