Create database tables python

import sqlite3
from sqlite3 import Error


def create_connection(db_file):
    """ create a database connection to the SQLite database
        specified by db_file
    :param db_file: database file
    :return: Connection object or None
    """
    conn = None
    try:
        conn = sqlite3.connect(db_file)
        return conn
    except Error as e:
        print(e)

    return conn


def create_table(conn, create_table_sql):
    """ create a table from the create_table_sql statement
    :param conn: Connection object
    :param create_table_sql: a CREATE TABLE statement
    :return:
    """
    try:
        c = conn.cursor()
        c.execute(create_table_sql)
    except Error as e:
        print(e)


def main():
    database = r"C:\sqlite\db\pythonsqlite.db"

    sql_create_projects_table = """ CREATE TABLE IF NOT EXISTS projects (
                                        id integer PRIMARY KEY,
                                        name text NOT NULL,
                                        begin_date text,
                                        end_date text
                                    ); """

    sql_create_tasks_table = """CREATE TABLE IF NOT EXISTS tasks (
                                    id integer PRIMARY KEY,
                                    name text NOT NULL,
                                    priority integer,
                                    status_id integer NOT NULL,
                                    project_id integer NOT NULL,
                                    begin_date text NOT NULL,
                                    end_date text NOT NULL,
                                    FOREIGN KEY (project_id) REFERENCES projects (id)
                                );"""

    # create a database connection
    conn = create_connection(database)

    # create tables
    if conn is not None:
        # create projects table
        create_table(conn, sql_create_projects_table)

        # create tasks table
        create_table(conn, sql_create_tasks_table)
    else:
        print("Error! cannot create the database connection.")


if __name__ == '__main__':
    main()
Code language: Python (python)

Source: sqlitetutorial.net

Similar codes

13 votes112 views5 answers
How to check if an input is a number in python
Python
0 vote101 views1 answer
Como fazer um bot spamm no discord com python
Python
1 vote122 views1 answer
Pandas change dtype to string
Python
19 votes96 views1 answer
10 minute timer
Python
89 votes105 views6 answers
Import csv file in python
Python
16 votes139 views4 answers
How to create a tkinter window
Python
0 vote108 views1 answer
Reading Custom Delimited file in python
Python
3 votes102 views3 answers
2d array python initialize
Python
5 votes115 views2 answers
Decision tree algorithm
Python
1 vote150 views1 answer
Calcutalte average python
Python