Let’s verify if the program has created those tables successfully in the pythonsqlite.db database.įirst, launch the command line and connect to the pythonsqlite.db database: >sqlite3 c:\sqlite\db\pythonsqlite.db
Sqlite list tables python code#
Main() Code language: SQL (Structured Query Language) ( sql )ĭef create_connection (db_file): """ create a database connection to the SQLite databaseĭef create_table (conn, create_table_sql): """ create a table from the create_table_sql statement Print( "Error! cannot create the database connection.")įourth, execute the main() function. Sql_create_tasks_table = """CREATE TABLE IF NOT EXISTS tasks (įOREIGN KEY (project_id) REFERENCES projects (id)Ĭreate_table(conn, sql_create_projects_table)Ĭreate_table(conn, sql_create_tasks_table) Sql_create_projects_table = """ CREATE TABLE IF NOT EXISTS projects ( def main ():ĭatabase = r"C:\sqlite\db\pythonsqlite.db" Third, create a main() function to create the projects and tasks tables. Print(e) Code language: SQL (Structured Query Language) ( sql ) :param create_table_sql: a CREATE TABLE statement """ create a table from the create_table_sql statement def create_table(conn, create_table_sql): Inside the function, we call the execute() method of the Cursor object to execute the CREATE TABLE statement. Second, develop a function named create_table() that accepts a Connection object and an SQL statement. Return conn Code language: Python ( python ) def create_connection (db_file): """ create a database connection to the SQLite database
Sqlite list tables python how to#
Let’s see how to create new tables in Python.įirst, develop a function called create_connection() that returns a Connection object which represents an SQLite database specified by the database file parameter db_file. ) Code language: SQL (Structured Query Language) ( sql ) tasks table CREATE TABLE IF NOT EXISTS tasks (įOREIGN KEY (project_id) REFERENCES projects ( id)
The following CREATE TABLE statements create these two tables: - projects table CREATE TABLE IF NOT EXISTS projects ( Third, pass the CREATE TABLE statement to the execute() method of the Cursor object and execute this method.įor the demonstration, we will create two tables: projects and tasks as shown in the following database diagram:.Second, create a Cursor object by calling the cursor() method of the Connection object.First, create a Connection object using the connect() function of the sqlite3 module.To create a new table in an SQLite database from a Python program, you use the following steps: # Print the tables and indices present in the SQLite main databaseĬursorObject.Summary: in this tutorial, we will show you how to create tables in the SQLite database from the Python program using the sqlite3 module. # Create database connection to a main database which is stored in a fileĬonnectionObject = nnect("info.dbs") The Python example below queries the sqlite_master table and prints the list of tables and indices present in the SQLite main database loaded through the file info.dbs.A SQL statement like a SELECT statement can be executed on the SQLite server by calling the execute() method of the cursor object and passing the SQL statement as parameter.Through the connection object a sqlite3.Cursor object can be obtained.A database connection to an SQLite database can be created by calling the connect() method of the sqlite3 module.The sqlite3 is the python database client for SQLite database.Getting the list of tables and indexes present in a SQLite database using Python: The sql column of the sqlite_master table contains the SQL statement with which a table or index has been created.The type column will hold the value "table" for a database table and the value "index" for a database index. The type column of the sqlite_master table denotes what type of database object the record is about.The sqlite_master table of a database contains the list of tables, indices and other details specific to that database.Every SQLite database has a special table named sqlite_master, which is a system created table.
0 kommentar(er)
