Baze in python

branje.py

import sqlite3

# Povezemo se na bazo
conn = sqlite3.connect("baza.sqlite")

cursor = conn.cursor()

cursor.execute("""
    SELECT COUNT(*), cas_vpisa FROM MERITVE
    GROUP BY cas_vpisa
    """)

for st, cas in cursor:
    print(st, cas)

# Zapremo povezavo
conn.close()

vpisovanje.py

import sqlite3

# Povezemo se na bazo
conn = sqlite3.connect("baza.sqlite")

cursor = conn.cursor()

cursor.execute("""
    CREATE TABLE IF NOT EXISTS MERITVE(
        id INTEGER PRIMARY KEY,
        vrednost INTEGER,
        id_senzorja INTEGER,
        cas_vpisa TEXT DEFAULT (DATETIME('now'))
    )
""")


for j in range(10):
    cursor.execute("""
        INSERT INTO MERITVE (ime, id_senzorja)
        VALUES (?,?)
     """, (j*2, 1))
    

# Shranimo rezultate
conn.commit()

# Zapremo povezavo
conn.close()