Advertisement
Guest User

Untitled

a guest
Dec 14th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. def zapisz_do_bazy(self):
  2. con = sqlite3.connect("konto.db")
  3.  
  4. with con:
  5. cur = con.cursor()
  6. cur.execute("DROP TABLE IF EXISTS transakcje")
  7. cur.execute(
  8. "CREATE TABLE transakcje(id INT, waluta TEXT, ilosc FLOAT)"
  9. )
  10. for i, t in enumerate(self._transakcje):
  11. cur.execute(
  12. f"INSERT INTO transakcje VALUES({i}, '{t['waluta']}', {t['ilosc']})"
  13. )
  14.  
  15. def wczytaj_z_bazy(self):
  16. con = sqlite3.connect("konto.db")
  17.  
  18. with con:
  19. cur = con.cursor()
  20. cur.execute("SELECT * FROM transakcje")
  21.  
  22. rows = cur.fetchall()
  23.  
  24. for row in rows:
  25. self.zatwierdz(row[2], row[1])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement