Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/storage/Mysql.py – Rev 17085 → 17142



 
def fetchResult(query, *params):
    try:
        conn = getDbConnection()
        cursor = conn.cursor()
        cursor.execute(query, params)
        result = cursor.fetchall()
        return result
    finally:
        conn.close() 
 

Rev 17085	Rev 17142
Line 147...	Line 147...
147		147
148	`def fetchResult(query, *params):`	148	`def fetchResult(query, *params):`
149	`try:`	149	`try:`
150	`conn = getDbConnection()`	150	`conn = getDbConnection()`
151	`cursor = conn.cursor()`	151	`cursor = conn.cursor()`
152	`cursor.execute(query.format(params))`	152	`cursor.execute(query, params)`
153	`result = cursor.fetchall()`	153	`result = cursor.fetchall()`
154	`return result`	154	`return result`
155	`finally:`	155	`finally:`
156	`conn.close()`	156	`conn.close()`
157		157