Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- conn = sqlite3.connect(':zadanko:')
- nazwa_tabeli = 'zadanko'
- integery = 'wiek'
- teksty = 'imie'
- klucz = 'ID'
- def zakladanie_tabelki(nazwa_tabelki, klucz, tekst1, numery1):
- conn.execute("CREATE TABLE IF NOT EXISTS" + str(nazwa_tabelki) + "," + str(klucz) +
- "INTEGER PRIMARY KEY NOT NULL," + str(tekst1) +
- "NAME TEXT NOT NULL," + str(numery1) +
- "INTEGER NOT NULL;")
- # conn.execute('''CREATE TABLE IF NOT EXISTS EXPLOYEES
- # (ID INTEGER PRIMARY KEY NOT NULL,
- # NAME TEXT NOT NULL,
- # AGE INTEGER NOT NULL,
- # ADDRESS CHAR(50),
- # SALARY REAL);''')
- # conn.execute("INSERT INTO EXPLOYEES VALUES(1, 'Marek', 22, 'Radom', 211111.00)")
- # conn.execute("INSERT INTO EXPLOYEES VALUES(?, ?, ?, ?, ?);", (3, 'Adam', 34, 'Warszawa', 235654.00))
- # conn.commit()
- # update = conn.execute("UPDATE EXPLOYEES SET SALARY = 20000000 WHERE id = 1")
- # delete = conn.execute("DELETE FROM EXPLOYEES WHERE name = 'Adam'")
- # cursor = conn.execute("SELECT id, name, address, salary FROM EXPLOYEES")
- # for row in cursor:
- # print("ID = ", row[0])
- # print("NAME = ", row[1])
- # print("ADDRESS = ", row[2])
- # print("SALARY = ", row[3], '\n')
- zakladanie_tabelki(nazwa_tabeli, )
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement