This is a personal record of my python programming experiences. It will allow me to see how I am progressing as I learn a new language.
Friday, November 12, 2010
SQLite and Python
I created a table using SQLite, and then I wrote a simple function in python to list the data. I made a GUI button to execute the function too. It's not much, but it is a start.
Wednesday, November 10, 2010
Executing SQL commands in python
#database code for learning purposes
import sqlite3
connectdb=sqlite3.connect('mydata.db') #Create data base named mydata.db on disk
c=conn.cursor() #Create a cursor object so SQL commands can be executed
#Create a table named deedrecord
c.execute("create table deedrecord (deed text,grantor text,grantee text,deeddate text)")
#Add some records to the table
c.execute("insert into deedrecord values ('1234123','mickey mouse','donald duck','111010')")
c.execute("insert into deedrecord values ('3456345','steve atchison','ronald regan','110910')")
therows=c.execute("select * from deedrecord")
for rows in therows:
print(rows[0])
print(rows[1])
print(rows[2])
print(rows[3])
Subscribe to:
Posts (Atom)
Followers
Blog Archive
- June (1)
- March (3)
- February (1)
- July (3)
- May (1)
- April (1)
- March (1)
- January (1)
- December (1)
- November (4)
- July (3)
- May (2)
- April (1)
- March (6)
- February (2)
- December (1)
- November (1)
- September (3)
- August (3)
- July (1)
- March (3)
- January (1)
- December (5)
- November (2)
- October (1)
- September (2)
- August (1)
- July (4)
- May (3)
- February (1)
- January (1)
- December (1)
- November (2)
- October (2)
- September (9)
- August (2)
- May (1)
- April (1)
- March (6)
- February (5)
- January (3)
- August (2)