cteate table sqlite3

mDocument.py

@classmethod
    def create_table(self):
        # TODO 1. Автоматично формувати SQL-команду створення таблиці
        print("Creating document table")
        path = os.path.expanduser(
            "~/python/virtualenv/python3/virt_Python3/home/data.db")
        try:
            connection = sqlite3.connect(path)
            cursor = connection.cursor()
            cursor.execute(
                """
                create table t_document(
                i_id        integer not null primary key autoincrement,
                f_status    integer     null
                );
                """
            )
            connection.commit()
            connection.close()
            print("Database creating success")
        except sqlite3.OperationalError as Exc:
            print("Database already exists. ", *Exc.args)