isql.py

isql for acess,sqlite , mysql etc

import sqlite
class isql:
    def __init__(self):
        self.database=None
    def dbConnect(self,directory,db):
        if self.database!=None:
            self.database.close()
        # open the new connection
        self.database =sqlite.connect(directory+"\\"+db)
    def getTables(self):
        cur=self.database.cursor()
	cur.execute("select tbl_name from sqlite_master where type='table' order by tbl_name")
	tables = []
	for row in cur.fetchall():
	        tables.append(row.tbl_name)
	return(tables)
    def execQuery(self,str1):
        curs = self.database.cursor()
        curs.execute(str1)
        r=self.pp(curs)
        self.database.commit()
        return(r)
    def pp(self,cursor):
        try:
            rows = cursor.fetchall()
        except:
            return "No description"
        desc = cursor.description
        i=0
        n=len(desc)
        r=[]
        r1=[]
        while i<n:
            r1.append(desc[i][0])
            i=i+1
        r.append(r1)
        i=0
        n=len(desc)
        m=len(rows)
        while i<m:
            j=0
            r1=[]
            while j<n:
                r1.append(rows[i][j])
                j=j+1
            r.append(r1)
            i=i+1
        return r
if __name__ == "__main__":
    i=isql()
    i.dbConnect(r"E:\ma\python\isql","trac.db")
    print i.getTables()
    print i.execQuery("select * from ma")