init_db.py

# init_db.py
from sqlalchemy import create_engine, MetaData
from db import users, events, cars, friends, event_users
import hashlib

db_url = "sqlite:///pooldb.db"


def create_tables(engine):
    meta = MetaData()
    meta.create_all(bind=engine, tables=[users, events, cars, friends, event_users])


def sample_data(engine):
    conn = engine.connect()
    conn.execute(users.insert(), [
        {'name': 'Harris Mirza',
         'lat': 51.371122,
         'lng': -0.258707,
         'email': "mirza.harris@gmail.com",
         'password': hashlib.sha256(b'password').hexdigest()},
        {'name': 'Danial Mirza',
         'lat': 51.371122,
         'lng': -0.258707,
         'email': "danial.mirza96@gmail.com",
         'password': hashlib.sha256(b'password').hexdigest()}
    ])

    conn.close()


if __name__ == '__main__':
    engine = create_engine(db_url)

    create_tables(engine)
    sample_data(engine)