db_init.py

import sqlite3

from models.user import User
from models.post import Post
from models.colonne import Colonne
from models.tableaux import Tableau

def make_dicts(cursor, row):
    return dict((cursor.description[idx][0], value)
                for idx, value in enumerate(row))

  
db = sqlite3.connect('.data/db.sqlite')
db.row_factory = make_dicts

cur = db.cursor()

User.create_table(cur)
Post.create_table(cur)
Colonne.create_table(cur)
Tableau.create_table(cur)

users = [
    User("Ford", "test@test.test", "12345"),
    User("Arthur", "arthur@earth.planet", "12345"),
]

#posts = [
#    Post(content="Hi!", author_id="ford@betelgeuse.star"),
#    Post(content="Don't destroy the earth please!", author_id="arthur@earth.planet"),
#]

for user in users:
    user.insert(cur)

#for post in posts:
#    post.insert(cur)

db.commit()

print("The following users has been inserted into the DB"
      " (all the passwords are 12345):")

for user in users:
    # uses the magic __repr__ method
    print("\t", user)
    
print()
print("Here are the posts inserted:")
#for post in posts:
#    print("\t", post)