sscasc@tumkur some of python database functions db close(closes the connection to the database (represented by the db object which is obtained by calling connect(functiondb commit(commits any pending transaction to the databasedoes nothing for databases that don' support transactions db cursor(returns database cursor object through which queries can be executed db rollback(rolls back any pending transaction to the state that existed before the transaction begandoes nothing for databases that don' support transactions db arraysize the (readable/writablenumber of rows that fetchmany(will return if no size is specified db close(closes the cursorcthis is done automatically when the cursor goes out of scope db description( read-only sequence of -tuples (nametype_codedisplay_sizeinternal_sizeprecisionscalenull_ok)describing each successive column of cursor db execute executes the sql query in string sqlreplacing each placeholder with the corresponding parameter from the params sequence or mapping if given (sql,paramsdb executemany (sql,seq_of_paramsexecutes the sql query once for each item in the seq_of_params sequence of sequences or mappingsthis method should not be used for operations that create result sets (such as select statementsdb fetchall(returns sequence of all the rows that have not yet been fetched (which could be all of themdb fetchmany(sizereturns sequence of rows (each row itself being sp_python programming