ehsan-dashboards/dashboards/summary_bank_returns.py

14 lines
533 B
Python

import sqlite3
conn = sqlite3.connect("/workspace/personal/blu/saman_bank_all_transactions.sqlite")
cur = conn.cursor()
print("--- SHAHAB SHAHLAEI ---")
cur.execute("SELECT jdate, deposit_toman, description FROM saman_transactions WHERE description LIKE '%شهاب%شهلائ%'")
for r in cur.fetchall():
print(r)
print("\n--- AMIRHOSSEIN BAGHERI ---")
cur.execute("SELECT jdate, deposit_toman, description FROM saman_transactions WHERE description LIKE '%اميرحسين%باقري%'")
for r in cur.fetchall():
print(r)