def save(self):
args = (self.username, self.title, self.content, datetime.now())
dbutil.execute_commit(self.SQL_MESSAGE_INSERT, args)
def delete_by_id(cls, id):
dbutil.execute_commit(cls.SQL_USER_DELETE, (id, ))
def delete(self):
dbutil.execute_commit(self.SQL_USER_DELETE, (self.id, ))
def save(self):
args = (self.username, self.age, self.tel, self.password)
dbutil.execute_commit(self.SQL_USER_CREATE, args)
def modify(self):
args = (self.username, self.age, self.tel, self.id)
dbutil.execute_commit(self.SQL_USER_MODIFY, args)
def modify_password(self):
args = (self.password, self.id)
dbutil.execute_commit(self.SQL_USER_MODIFY_PASSWORD, args)
def delete(self):
args = (self.id)
print(args)
dbutil.execute_commit(self.SQL_USER_DELETE, args)
def delete_message(username, title, content):
dbutil.execute_commit(SQL_Delete, (username, title, content))
def update_message(username, title, content):
dbutil.execute_commit(SQL_Update, (title, content, username))
def save_message(username, title, content):
dbutil.execute_commit(SQL_Insert, (username, title, content))
