import sqlite3import os,sysdatabase = os.path.dirname(__file__) + /sqlite.dbdef test_db():db = sqlite3.connect(database)cur = db.cursor()sql = create table post(id int primary key not null,title char(50),content text,author char(30))data =
import sqlite3import os,sysdatabase = os.path.dirname(__file__) + '/sqlite.db'def test_db(): db = sqlite3.connect(database) cur = db.cursor() sql = ''' create table post( id int primary key not null, title char(50), content text, author char(30) ) ''' data = ''' insert into post(id,title,content,author) values(1,'good news','you win the big prize','admin') ''' print 'run the query' query = select * from post posts = cur.execute(query) for post in posts: print post[1] db.close() if __name__ == '__main__':test_db()