16 lines
534 B
Python
16 lines
534 B
Python
import sqlite3
|
|
|
|
conn = sqlite3.connect("/workspace/personal/blu/saman_bank_all_transactions.sqlite")
|
|
cur = conn.cursor()
|
|
|
|
cur.execute("""
|
|
SELECT jdate, deposit_toman, description
|
|
FROM saman_transactions
|
|
WHERE deposit_toman > 0
|
|
AND (description LIKE '%برگشت%' OR description LIKE '%عودت%' OR description LIKE '%ناموفق%')
|
|
ORDER BY jdate ASC
|
|
""")
|
|
rows = cur.fetchall()
|
|
print(f"Total returned deposits in Saman: {len(rows)}")
|
|
for r in rows:
|
|
print(f"Date: {r[0]} | Deposit: {r[1]:,.1f} Toman | Desc: {r[2][:120]}")
|