pymssql
Introduction
Architecture
Project Discussion
Project Status
Current Development
pymssql
examples
Basic features (strict DB-API compliance)
Iterating through results
Rows as dictionaries
Using the
with
statement (context managers)
Calling stored procedures
_mssql
examples
Quickstart usage of various features
An example of exception handling
Release notes
pymssql 2.0.0
FreeTDS configuration
Testing the connection
pymssql
module reference
Module-level symbols
Functions
Connection
class
Cursor
class
_mssql
module reference
Module-level symbols
Functions
MSSQLConnection
class
MSSQLStoredProcedure
class
Module-level exceptions
Migrating from 1.x to 2.x
str
vs.
unicode
Handling of
uniqueidentifier
columns
Arguments to
pymssql.connect
Parameter substitution
Frequently asked questions
Cannot connect to SQL Server
Returned dates are not correct
Queries return no rows
Results are missing columns
pymssql does not unserialize
DATE
and
TIME
columns to
datetime.date
and
datetime.time
instances
Shared object “libsybdb.so.3” not found
“DB-Lib error message 20004, severity 9: Read from SQL server failed” error appears
More troubleshooting
Building and developing pymssql
Building
Testing
FreeTDS and dates
Summary
Details
To-do list
Complete
Partially Complete
Incomplete
Documentation
Change log
Project history
The beginning
Important releases
License change
LGPLed releases
pymssql
Docs
»
Edit on GitHub
Index
_
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
I
|
L
|
M
|
N
|
P
|
Q
|
R
|
S
|
T
_
__iter__() (_mssql.MSSQLConnection method)
(pymssql.Cursor method)
_mssql (module)
A
apilevel (in module pymssql)
autocommit() (pymssql.Connection method)
B
bind() (_mssql.MSSQLStoredProcedure method)
C
cancel() (_mssql.MSSQLConnection method)
charset (_mssql.MSSQLConnection attribute)
close() (_mssql.MSSQLConnection method)
(pymssql.Connection method)
(pymssql.Cursor method)
commit() (pymssql.Connection method)
connect() (in module pymssql)
connected (_mssql.MSSQLConnection attribute)
connection (_mssql.MSSQLStoredProcedure attribute)
Connection (class in pymssql)
connection (pymssql.Cursor attribute)
Cursor (class in pymssql)
cursor() (pymssql.Connection method)
D
debug_queries (_mssql.MSSQLConnection attribute)
E
execute() (_mssql.MSSQLStoredProcedure method)
(pymssql.Cursor method)
execute_non_query() (_mssql.MSSQLConnection method)
execute_query() (_mssql.MSSQLConnection method)
execute_row() (_mssql.MSSQLConnection method)
execute_scalar() (_mssql.MSSQLConnection method)
executemany() (pymssql.Cursor method)
F
fetchall() (pymssql.Cursor method)
fetchmany() (pymssql.Cursor method)
fetchone() (pymssql.Cursor method)
G
get_dbversion() (in module pymssql)
get_header() (_mssql.MSSQLConnection method)
get_max_connections() (in module _mssql)
(in module pymssql)
I
identity (_mssql.MSSQLConnection attribute)
init_procedure() (_mssql.MSSQLConnection method)
L
lastrowid (pymssql.Cursor attribute)
login_timeout (in module _mssql)
M
message (_mssql.MSSQLDatabaseException attribute)
min_error_severity (in module _mssql)
MSSQLConnection (class in _mssql)
MSSQLDatabaseException
MSSQLDriverException
MSSQLStoredProcedure (class in _mssql)
N
name (_mssql.MSSQLStoredProcedure attribute)
next() (_mssql.MSSQLConnection method)
(pymssql.Cursor method)
nextresult() (_mssql.MSSQLConnection method)
nextset() (pymssql.Cursor method)
number (_mssql.MSSQLDatabaseException attribute)
P
parameters (_mssql.MSSQLStoredProcedure attribute)
paramstyle (in module pymssql)
pymssql (module)
Python Enhancement Proposals
PEP 249
PEP 249#operationalerror
,
[1]
,
[2]
Q
query_timeout (_mssql.MSSQLConnection attribute)
R
rollback() (pymssql.Connection method)
rowcount (pymssql.Cursor attribute)
rownumber (pymssql.Cursor attribute)
rows_affected (_mssql.MSSQLConnection attribute)
S
select_db() (_mssql.MSSQLConnection method)
set_max_connections() (in module _mssql)
(in module pymssql)
setinputsizes() (pymssql.Cursor method)
setoutputsize() (pymssql.Cursor method)
severity (_mssql.MSSQLDatabaseException attribute)
state (_mssql.MSSQLDatabaseException attribute)
T
tds_version (_mssql.MSSQLConnection attribute)
threadsafety (in module pymssql)
Read the Docs
v: latest
Versions
latest
Downloads
PDF
HTML
Epub
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.