Total members 11864 |It is currently Thu Dec 09, 2021 5:44 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





In this article we talk about how to use SQLite with Python, SQLite is a SQL database engine that has these features: self-contained, serverless, zero-configuration and transactional. SQLite library included in from version 2.5, follow part is the start with SQLite/ Python, how to access SQLite database? Following Python code how to connect and selecting data/creating schema:

Code:


import sqlite3 as sdb

myConnection 
= sdb.connect('/tmp/test.db')
cursorObj = myConnection.cursor()
cursorObj.execute('SELECT SQLITE_VERSION()')
## printing the version value
Vdata = cursorObj.fetchone()
print "SQLite version: %s" % Vdata
## create a user table
cursorObj.execute('CREATE TABLE IF NOT EXISTS user( firstname VARCHAR(43), age INTEGER)')
##  add data to table user
cursorObj.execute('insert into user values (?,?)', ('sam',43) )
## get tables' info from sqlite_master
 

You also insert values from array:
Code:
my_data = (
    ('Jim','Sead'),
    ('Tom','Fadi'),
    ('Kely','Noras'),
    ('Eid','Esa')
)

cursorObj.executemany('INSERT INTO user(firstname,lastname) VALUES(?,?)',my_data)

myConnection .commit()
 

You can also get fields by it name like this
Code:

cursorObj
.execute("SELECT * FROM user")

FetchedData = cursorObj.fetchall()

for record in FetchedData:
    print "%-2s %-10s " % (record ["firstname"], record ["lastname"])
 




_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : usage of SQLite database from Python
 hashing in python     -  
 how to use GeoIP with Python     -  
 Python Module for MySQL     -  
 Reading email in Python     -  
 How to read and write to CSV file from python     -  
 exception handling try and catch in Python     -  
 Python Training from Certified Experts (ap2v.com)     -  
 Build Linear Regression in Python - Supervised Learning     -  
 2 different database     -  
 database connection     -  



Topic Tags

Python Database
cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com