sql_db.py

import pymysql

pswd = input('Insert password:')
params = {
    'user': 'root',
    'password' : pswd,
    'host' : 'localhost',
    'database' : 'to_do_list',
    'use_unicode' : True
}


sql_insert = 'INSERT INTO todo_list (todo) VALUES (%s)'
sql_get = 'SELECT todo ' \
      'FROM todo_list ' \
      'WHERE todo = %s'
sql_showall = 'SELECT * FROM todo_list'
sql_delete = 'DELETE FROM todo_list WHERE todo = %s'
sql_match = 'SELECT * FROM todo_list WHERE todo LIKE %s'
sql_remove_all = 'DELETE FROM todo_list WHERE todo LIKE %s'


def insert(name):
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    cursor.execute(sql_insert,(name,))
    conn.commit()
    cursor.close()
    conn.close()

def remove(name):
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    cursor.execute(sql_get, (name,))
    if cursor.fetchone() == None:
        print("Not in the database")
    else:
        cursor.execute(sql_delete,(name,))
        conn.commit()
    cursor.close()
    conn.close()

def check(name):
    res = False
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    cursor.execute(sql_get, (name,))
    if cursor.fetchone() != None:
        res = True
    cursor.close()
    conn.close()
    return res

def match(name):
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    name = "%"+name+"%"
    cursor.execute(sql_match, (name,))
    result = cursor.fetchall()
    cursor.close()
    conn.close()
    return result

def removeAll(name):
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    name = "%" + name + "%"
    cursor.execute(sql_remove_all, (name,))
    conn.commit()
    cursor.close()
    conn.close()


def showAll():
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    cursor.execute(sql_showall)
    result = cursor.fetchall()
    cursor.close()
    conn.close()
    return result

def get(name):
    conn = pymysql.connect(**params)
    cursor = conn.cursor()
    cursor.execute(sql_get, (name,))
    result = cursor.fetchall()
    cursor.close()
    conn.close()
    return result