execute ( ''' select id, priority, status, deadline, details from task where project = 'pymotw' order by deadline ''' ) print ' Next 5 tasks:' for row in cursor. fetchone () print 'Project details for %s ( %s ) due %s ' % ( description, name, deadline ) cursor. execute ( ''' select name, description, deadline from project where name = 'pymotw' ''' ) name, description, deadline = cursor. connect ( db_filename ) as conn : # Change the row factory to use Row conn. Import sqlite3 db_filename = 'todo.db' with sqlite3. The sqlite3Ĭommand line program can be used to examine the contents of the execute ( ''' insert into task (details, status, deadline, project) values ('write about sqlite3', 'active', '', 'pymotw') ''' ) else : print 'Database exists, assume schema does, too.'Īfter the tables are created, a few insert statementsĬreate a sample project and related tasks.

execute ( ''' insert into task (details, status, deadline, project) values ('write about random', 'waiting', '', 'pymotw') ''' ) conn. execute ( ''' insert into task (details, status, deadline, project) values ('write about select', 'done', '', 'pymotw') ''' ) conn. execute ( ''' insert into project (name, description, deadline) values ('pymotw', 'Python Module of the Week', '') ''' ) conn. executescript ( schema ) print 'Inserting initial data' conn. connect ( db_filename ) as conn : if db_is_new : print 'Creating schema' with open ( schema_filename, 'rt' ) as f : schema = f. Import os import sqlite3 db_filename = 'todo.db' schema_filename = 'todo_schema.sql' db_is_new = not os. Refer to the PyMOTW-3 section of the site.

If you are looking for examples that work under Python 3, please Of the features described here may not be available in earlier Generated with Python 2.7.8, unless otherwise noted. The output from all the example programs from PyMOTW has been Table of Contents Previous: whichdb – Identify DBM-style database formats Next: Generic Operating System Services This Page

Sqlite 3 insert row python