MSSQL.create_cursor

MSSQL.create_cursor(database_name=None)

Create a pyodbc cursor.

Parameters

database_name (str or None) – name of a database, defaults to the name of the currently-connected database when database=None

Returns

a pyodbc cursor

Return type

pyodbc.Cursor

Examples:

>>> from pyhelpers.dbms import MSSQL

>>> mssql = MSSQL()
Connecting <server_name>@localhost:1433/master ... Successfully.

>>> db_cur = mssql.create_cursor()

>>> # Get information about all tables in the database [master]
>>> tables_in_db = db_cur.tables(schema='dbo', tableType='TABLE')
>>> list(tables_in_db)
[('master', 'dbo', 'MSreplication_options', 'TABLE', None),
 ('master', 'dbo', 'spt_fallback_db', 'TABLE', None),
 ('master', 'dbo', 'spt_fallback_dev', 'TABLE', None),
 ('master', 'dbo', 'spt_fallback_usg', 'TABLE', None),
 ('master', 'dbo', 'spt_monitor', 'TABLE', None)]

>>> db_cur.close()