def _insert_new_user_to_db(self, user): sql = "INSERT INTO users(username, password) VALUES(%s, %s)" values = (user.get_username(), user.get_password()) db = Database() db.commit_to_db(sql, values) print("You account is successfully registered, " + user.get_username().title() + "!") return self._get_user_id_from_db(user)
class BuildMySql: def __init__(self): self._dbconn = Database() def create_database(self, name): sql = "CREATE DATABASE %s" self._dbconn.commit_to_db(sql, (name, )) self._dbconn.close() def create_table_users(self): sql = """CREATE TABLE users( user_id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) UNIQUE NOT NULL, password VARCHAR(50) NOT NULL )""" self._dbconn.commit_to_db(sql) self._dbconn.close() def drop_table(self, name): sql = "DROP TABLE %s" self._dbconn.commit_to_db(sql, (name, )) self._dbconn.close() def truncate_table(self, name): sql = "TRUNCATE TABLE %s" self._dbconn.commit_to_db(sql, (name, )) self._dbconn.close()
def create_new_task(self, user_id): sql = "INSERT INTO tasks(user_id, task_description, due_date, due_time) " \ "VALUES(%s, %s, %s, %s)" print( "To save a new task, you will have to enter its description and date and time when the task is due." ) self._task.set_description() self._task.set_due_date() self._task.set_due_time() db = Database() values = (user_id, self._task.get_description(), self._task.get_due_date(), self._task.get_due_time()) db.commit_to_db(sql, values) print("Task successfully saved.\n")