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)