from pathlib import Path
import sqlite3


def initialize_database():
    database = Path('social.db')
    if database.exists():
        return
    with open('schema.sql', encoding='utf-8') as f:
        schema = f.read()
    connection = sqlite3.connect(database)
    connection.executescript(schema)
    connection.close()


if __name__ == '__main__':
    initialize_database()