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")