[Tutor] SQLite3 DB Field Alphabetizing

David Hutto smokefloat at gmail.com
Wed Oct 13 07:44:34 CEST 2010


Quick note: forgot to add that the initial db file is setup with the following:

import sqlite3 as lite
class db(object):
	def onNewProjSQLDB(self):
		self.con = lite.connect('/home/david/pythonfiles/pythonscripts/roughdraftapps/dataplot3/db/dpdb.db')
		self.cur = self.con.cursor()
		#rows and columns are singular in project, and position is
individual to graph/overlayed graphs
		self.cur.execute('''create table projectbob(graphname, typeograph )''')
# Save (commit) the changes
		self.con.commit()

		
		self.cur.close()
		self.con.close()
db = db()
db.onNewProjSQLDB()


More information about the Tutor mailing list