def delete_item(item_id: UUID4):
item = None
with db_connection() as db:
db.execute(f"select * from items where id = '{item_id}'")
item = db.fetchone()
if not item:
raise HTTPException(status_code=400, detail="Item not found.")
with db_connection() as db:
db.execute(f"delete from items where id = '{item_id}'")
return {"detail": f"Deleted item with id {item_id}"}
def get_item(item_id: UUID4):
with db_connection() as db:
db.execute(f"select * from items where id = '{item_id}'")
item = db.fetchone()
if item:
return item
raise HTTPException(status_code=400, detail="Item not found.")
def main():
connection = db.db_connection('crypto.db')
coins = get_coins_links(cryptocurrencies)
data_coin = get_history(coins, connection)
db.data_record(data_coin, connection)
connection.commit()
connection.close()
def data_status():
sql = """SELECT web FROM polls_search GROUP BY web"""
results = db.db_select(sql)
list_web = {}
for result in results:
list_web[result[0]] = {}
list_status = {"not-read": 0, "applied": 0, "inadequate": 0, "expired": 0, "other": 0}
for web in list_web:
list_web[web].update(list_status)
sql = """SELECT status, COUNT(status), polls_search.web FROM polls_ad
LEFT JOIN polls_search ON polls_ad.site_id = polls_search.id
GROUP BY status, polls_search.web"""
results = db.db_select(sql)
for result in results:
list_web[result[2]][result[0]] = result[1]
conn = db.db_connection()
for data in list_web:
total = list_web[data]["not-read"] + list_web[data]["applied"] + list_web[data]["inadequate"] + list_web[data]["expired"] + list_web[data]["other"]
sql = """INSERT INTO polls_stat (web, not_read, applied, inadequate, expired, other, total)
VALUES ('{}', {}, {}, {}, {}, {}, {})"""\
.format(data, list_web[data]["not-read"], list_web[data]["applied"], list_web[data]["inadequate"], list_web[data]["expired"], list_web[data]["other"], total)
insert = db.injection_sql(conn, sql)
if insert == "update":
sql = """UPDATE polls_stat SET not_read={}, applied={}, inadequate={}, expired={}, other={}, total={}
WHERE web = '{}'"""\
.format(list_web[data]["not-read"], list_web[data]["applied"], list_web[data]["inadequate"], list_web[data]["expired"], list_web[data]["other"], total, data)
db.injection_sql(conn, sql)
db.db_close(conn)
def __init__(self, *args, **kwargs):
Page.__init__(self, *args, **kwargs)
label = tk.Label(self, text="This is all exercises")
label.grid(row=0, column=0)
all_done_acts_query = "SELECT * FROM done_acts"
all_done = db_connection(all_done_acts_query, receive=True)
page_list = ListViewer(self)
for record in all_done:
page_list.populate_list(record)
def get_items(response: Response, offset: int = 0, limit: int = 100):
with db_connection() as db:
db.execute(
f"select * from items order by name offset {offset} limit {limit}")
items = db.fetchall()
if items:
response.headers["Content-Range"] = str(len(items))
return items
response.headers["Content-Range"] = "0"
return []
def lk(result):
req = requests.get(result[2])
soup = BeautifulSoup(req.content, "html.parser")
ads = soup.find_all('li', class_="result-card")
conn = db.db_connection()
for ad in ads:
link = ad.a['href'].split("?")[0]
title = ad.h3.text.capitalize()
location = ad.find('span', class_="job-result-card__location").text
check_status(result[0], title, location, link, description, conn)
db.db_close(conn)
def entry_db(business_name, address, contact):
db, cursor = db_connection()
cursor.execute(
"SELECT * from bangalore_ayurvedic_doctors where business_name = %s and address = %s and mobile_number = %s",
(business_name, address, contact))
record = cursor.fetchall()
if record == []:
cursor.execute(
"INSERT INTO bangalore_ayurvedic_doctors (business_name,address,mobile_number) VALUES (%s,%s,%s)",
(business_name, address, contact))
db.commit()
db.close()
def update_item(item_id: UUID4,
item_update: ItemUpdate = Body(
...,
example={
"name": "An Updated Item",
"description": "What it is now."
})):
item = None
with db_connection() as db:
db.execute(f"select * from items where id = '{item_id}'")
item = db.fetchone()
if not item:
raise HTTPException(status_code=400, detail="Item not found.")
with db_connection() as db:
db.execute(
f"update items set name = '{item_update.name}', "
f"description = '{item_update.description}', "
f"updated_at = '{item_update.updated_at}' where id = '{item_id}'")
return item_update
def ep(result):
req = requests.get(result[2])
soup = BeautifulSoup(req.content, "html.parser")
ads = soup.find_all('li', class_="result")
conn = db.db_connection()
for ad in ads:
link = "{}{}".format("https://candidat.pole-emploi.fr", ad.a['href'])
title = ad.h2.text.replace("\n", "").capitalize()
location = ad.find('p', class_="subtext").text.replace("\n", "")
description = ad.find('p', class_="description").text.replace('"', "")
check_status(result[0], title, location, link, description, conn)
db.db_close(conn)
def create_item(item_create: ItemCreate = Body(
...,
example={
"name": "An Item",
"description": "What it is."
},
)):
dict_item = item_create.dict()
keys, values = ', '.join(dict_item.keys()), ', '.join(
map(lambda v: f"'{str(v)}'", dict_item.values()))
with db_connection() as db:
db.execute(f"insert into items ({keys}) values ({values})")
return item_create
def __init__(self):
# Error/Info log. not to be confused with message logger
self.log = logging.getLogger(__name__)
self.log.info("Initializing...")
self.r = database.db_connection()
self.parse_config()
self.deferred = defer.Deferred()
self.logger = database.MessageLogger()
self.log.info("Getting Commands...")
self.commands = {"!chattiness": self.set_chattiness}
self.log.info("Generating model...")
self.get_model()
self.log.info("...Initialized.")
def __init__(self, curWin, uiMan, entryBox, s):
super().__init__('Submit Score',
center_x=480,
center_y=_height / 2 - 20,
width=250,
height=40)
self.curWindow = curWin
self.ui_manager = uiMan
self.entry = entryBox
self.score = s
self.dbCon = database.db_connection()
#button colors, set them to whatever
self.set_style_attrs(
font_color=arcade.color.BLACK,
font_color_hover=arcade.color.BLACK,
font_color_press=arcade.color.BLACK,
bg_color=(128, 128, 128), #Gray
bg_color_hover=(211, 211, 211), #Light Gray
bg_color_press=(255, 255, 255), #White
border_color=(64, 224, 208), #Turquoise
border_color_hover=arcade.color.BLACK,
border_color_press=arcade.color.BLACK)
Returns Binary
"""
flag = False
if card_number == source_card_number:
print("\nYou can't transfer money to the same account!")
elif self.get_checksum(card_number[:-1]) != card_number[-1]:
print("\nProbably you made a mistake in the card number. Please try again!")
elif not database.validate_card(connection, card_number):
print("\nSuch a card does not exist.")
else:
flag = True
return flag
bank = Bank()
connection = database.db_connection()
database.create_table(connection)
while True:
choice = input(INPUT_PROMPT)
if choice == "1":
card_number = bank.generate_card_number()
pin = bank.generate_pin()
database.insert_record(connection, card_number, pin)
elif choice == "2":
login_card_number = input("\nEnter your card number:\n")
login_pin = input("Enter your PIN:\n")
if database.validate_login(connection, login_card_number, login_pin):
print("\nYou have successfully logged in!")
bank.login_choices(connection, login_card_number)
else:
def __init__(self):
self.db_connection = database.db_connection()
self.token_validator = None
def update_sql():
conn = db.db_connection()
for id_ad in list_id_expired:
sql = """UPDATE polls_ad SET status='expired' WHERE id={}""".format(id_ad)
db.injection_sql(conn, sql)
db.db_close(conn)
bg='green')
b1.pack(side="left")
b2.pack(side="left")
l1.pack(side="left")
p1.show()
if __name__ == "__main__":
name = ['acts', 'made', 'days', 'reps', 'avg']
percentage = []
for item in get_all_stats():
for ins in item:
percentage.append(ins)
all_acts_querry = "SELECT * FROM acts"
all_acts = db_connection(all_acts_querry, receive=True)
all_acts_list = []
for item in all_acts:
all_acts_list.append(item[1])
domain = [[act[1] for act in all_acts], ['total acts made'],
['total days with action'], ['total reps'], ['avg reps pro act']]
root = tk.Tk()
root.title('Exercise counter')
main = MainView(root)
main.pack(side="top", fill="both", expand=True)
root.wm_geometry("400x350+340+350")
root.mainloop()
def insert_done_acts_test_data():
for line in test_db_record(350):
add_done_act(line[0], line[1], line[2], line[3])
print('Finished')
if __name__ == "__main__":
if not os.path.isfile("exercise.db"):
print('No database detected, creating...')
first_time_db()
print(get_column_names())
else:
print('database detected with, \nTable name: ',
db_connection(sql_command_dict['table_name_sql'], receive=True))
print()
if not get_acts():
print('Adding acts....')
insert_first_acts()
print(get_acts())
else:
print('Table "acts" items', get_acts())
if not get_done_acts():
print('Table "done_acts items :', get_done_acts(),
'\nempty table, need data...')
print('inserting test data for "done_acts" table')
insert_done_acts_test_data()
else:
print("***** Current done acts ***")
#print(db_connection(sql_command_dict['all_done_acts_sql'], receive=True))