Advertisement
wojcieszek

sql python

Dec 9th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.25 KB | None | 0 0
  1. import sqlite3
  2. conn = sqlite3.connect(':zadanko:')
  3. nazwa_tabeli = 'zadanko'
  4. integery = 'wiek'
  5. teksty = 'imie'
  6. klucz = 'ID'
  7.  
  8. def zakladanie_tabelki(nazwa_tabelki, klucz, tekst1, numery1):
  9.     conn.execute("CREATE TABLE IF NOT EXISTS" + str(nazwa_tabelki) + "," + str(klucz) +
  10.                  "INTEGER PRIMARY KEY NOT NULL," + str(tekst1) +
  11.                  "NAME TEXT NOT NULL," + str(numery1) +
  12.                  "INTEGER NOT NULL;")
  13.  
  14. # conn.execute('''CREATE TABLE IF NOT EXISTS EXPLOYEES
  15. # (ID INTEGER PRIMARY KEY NOT NULL,
  16. # NAME TEXT NOT NULL,
  17. # AGE INTEGER NOT NULL,
  18. # ADDRESS CHAR(50),
  19. # SALARY REAL);''')
  20.  
  21. # conn.execute("INSERT INTO EXPLOYEES VALUES(1, 'Marek', 22, 'Radom', 211111.00)")
  22. # conn.execute("INSERT INTO EXPLOYEES VALUES(?, ?, ?, ?, ?);", (3, 'Adam', 34, 'Warszawa', 235654.00))
  23. # conn.commit()
  24.  
  25. # update = conn.execute("UPDATE EXPLOYEES SET SALARY = 20000000 WHERE id = 1")
  26. # delete = conn.execute("DELETE FROM EXPLOYEES WHERE name = 'Adam'")
  27. # cursor = conn.execute("SELECT id, name, address, salary FROM EXPLOYEES")
  28. # for row in cursor:
  29. #     print("ID = ", row[0])
  30. #     print("NAME = ", row[1])
  31. #     print("ADDRESS = ", row[2])
  32. #     print("SALARY = ", row[3], '\n')
  33.  
  34. zakladanie_tabelki(nazwa_tabeli, )
  35. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement