Python’s SQLITE3 Delete Table Data(and Tables) and Getting Data

import sqlite3

DFLT_path = 'C:/Desktop/mydatabase.db'
DFLT_table = 'mytable'
DFLT_data = {'name': "bob",'age':20,'address':'3 something st.'}
DFLT_cat = ["username","score"]
DFLT_search = ["Reza",1]

def db_get(db_name=DFLT_path, table=DFLT_table, cat=DFLT_cat, search=DFLT_search):
table = 'db' + str(table)
conn = sqlite3.connect(db_name)
cursor = conn.cursor()
conn.row_factory = sqlite3.Row

with conn:
# SELECT * FROM dbmytable WHERE username = ? AND score = ?'
if '*' in search and len(search)==1 and '*' in cat and len(cat)==1:
cursor.execute(f'SELECT * FROM {table}')
elif '*' in search and len(search)==1 and len(cat)==1:
one_cat = ''.join(cat)
cursor.execute(f'SELECT * FROM {table} WHERE {one_cat} IS NOT NULL')
elif '?' in search and len(search)==1 and '?' in cat and len(cat)==1:
cursor.execute(f'SELECT * FROM {table}')
items = cursor.fetchone().keys()
return items
else:
temp1 = []
for item in cat:
temp1.append(f'{item} = ?')
categories =' AND '.join(temp1)
string_execute = f'SELECT * FROM {table} WHERE {categories}'
cursor.execute(string_execute,search)

items = []
for item in cursor.fetchall()
items.append(item)

return items

def delete_row(db_name=DFLT_path, table=DFLT_table, cat=DFLT_cat, search=DFLT_search):

table = 'db' + str(table)
conn = sqlite3.connect(db_name)
conn.row_factory = sqlite3.Row
cursor = conn.cursor()

with conn:
# DELETE FROM dbmytable WHERE username = reza OR score = 1
# [(username,reza),(score,1)]
tup1 = zip(cat,search)

match1 = []
for cat1,search1 in tup1:
match1.append(cat1+" = "+search1)
match2 = ' OR '.join(match1)

string_execute = f'DELETE FROM {table} WHERE {match2}'

cursor.execute(string_execute)

return string_execute

def delete_table(db_name=DFLT_path, table=DFLT_table):

table = 'db' + str(table)
conn = sqlite3.connect(db_name)
conn.row_factory = sqlite3.Row
cursor = conn.cursor()

with conn:
# DROP TABLE IF EXISTS table_
string_execute = f'DROP TABLE IF EXISTS {table}'
cursor.execute(string_execute)
return 'table has been deleted'

PAT: https://www.patreon.com/rezatahirkheli
PP: https://www.paypal.com/paypalme/rezatahirkheli1
BTC: 3EUQBWZKX9Vcwdffd3cUGATQopxrAQQxJ9
LTC: MBXE6hJgxxFYSD8SjmR7sHCHGTqFXmNGoU
GFM: https://gofund.me/7d6500bd