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: / rezatahirkheli
PP: https://www.paypal.com/paypalme/rezat...
BTC: 3EUQBWZKX9Vcwdffd3cUGATQopxrAQQxJ9
LTC: MBXE6hJgxxFYSD8SjmR7sHCHGTqFXmNGoU
GFM: https://gofund.me/7d6500bd
Watch video Python’s SQLITE3 Delete Table Data(and Tables) and Getting Data online without registration, duration hours minute second in high quality. This video was added by user ZeroLife 25 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 142 once and liked it 4 people.