create sqlite database and table in 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)Are there any code examples left?
New code examples in category SQL
Relative searches
python sqlite make table
sqlite make new database python
python create a sqlite database store dataframe as a table
create sqlite in python
create new table sqlite python
how to create a table in sqlite using python
make tables sqlite python
create sqlite table python
python sqlite create table
python sqlite3 create database
python create Sqlite database with tables
how to create sqlite database in python
create a table in sqlite3 python
sqlite3 create table python
sqlite3 python create database
sqlite create table python
create sqlite table pytohn
python create sqlite database
python sqlite3 create table
create sqlite3 table python
making a new database sqlite pyhton
how to create table in sqlite3 python
how to make a sqlite database in python
create sqlite3 database in python
HOW TO CREATE SQLLITE DB IN PYTHON
sqlite3 python create table
python sqlite create database
sqlite python create table
python code to create sqlite database
create database sqlite pyhton
create table sqlite python
create sqlite database python
create table in sqlite3 python
create an sqlite database python
sqlite create db python
how to create sql table in python sqlite3
create sqlite database in python
