| Method Summary |
| |
__init__(self,
*args,
**kwargs)
Create a connection to the database. |
| |
cursor(self,
cursorclass)
Create a cursor on which queries may be performed. |
| |
errorhandler(connection,
cursor,
errorclass,
errorvalue)
If cursor is not None, (errorclass, errorvalue) is appended to
cursor.messages; otherwise it is appended to
connection.messages. |
| |
literal(self,
o)
If o is a single object, returns an SQL literal as a string. |
| Inherited from connection |
| |
__repr__(x)
x.__repr__() <==> repr(x) |
| |
affected_rows(...)
Return number of rows affected by the last query. |
| |
autocommit(...)
Set the autocommit mode. |
| |
change_user(...)
Changes the user and causes the database specified by db to
become the default (current) database on the connection
specified by mysql. |
| |
character_set_name(...)
Returns the default character set for the current connection. |
| |
close(...)
Close the connection. |
| |
commit(...)
Commits the current transaction |
| |
dump_debug_info(...)
Instructs the server to write some debug information to the
log. |
| |
errno(...)
Returns the error code for the most recently invoked API function
that can succeed or fail. |
| |
error(...)
Returns the error message for the most recently invoked API function
that can succeed or fail. |
| |
escape(obj,
dict)
using mapping dict to provide quoting functions for each type. |
| |
escape_string(s)
Use connection.escape_string(s), if you use it at all. |
| |
field_count(...)
Returns the number of columns for the most recent query on the
connection. |
| |
get_host_info(...)
Returns a string that represents the MySQL client library
version. |
| |
get_proto_info(...)
Returns an unsigned integer representing the protocol version
used by the current connection. |
| |
get_server_info(...)
Returns a string that represents the server version number. |
| |
info(...)
Retrieves a string providing information about the most
recently executed query. |
| |
insert_id(...)
Returns the ID generated for an AUTO_INCREMENT column by the previous
query. |
| |
kill(...)
Asks the server to kill the thread specified by pid. |
| |
next_result(...)
If more query results exist, next_result() reads the next query
results and returns the status back to application. |
| |
ping(...)
Checks whether or not the connection to the server is
working. |
| |
query(...)
Execute a query. |
| |
rollback(...)
Rolls backs the current transaction |
| |
select_db(...)
Causes the database specified by db to become the default
(current) database on the connection specified by mysql. |
| |
set_server_option(option)
for the connection. |
| |
shutdown(...)
Asks the database server to shut down. |
| |
sqlstate(...)
Returns a string containing the SQLSTATE error code
for the last error. |
| |
stat(...)
Returns a character string containing information similar to
that provided by the mysqladmin status command. |
| |
store_result(...)
Returns a result object acquired by mysql_store_result
(results stored in the client). |
| |
string_literal(obj)
This means, any special SQL characters are escaped, and it is enclosed
within single quotes. |
| |
thread_id(...)
Returns the thread ID of the current connection. |
| |
use_result(...)
Returns a result object acquired by mysql_use_result
(results stored in the server). |
| |
warning_count(...)
Returns the number of warnings generated during execution
of the previous SQL statement. |
| Inherited from object |
| |
__delattr__(...)
x.__delattr__('name') <==> del x.name |
| |
__getattribute__(...)
x.__getattribute__('name') <==> x.name |
| |
__hash__(x)
x.__hash__() <==> hash(x) |
| |
__reduce__(...)
helper for pickle |
| |
__reduce_ex__(...)
helper for pickle |
| |
__setattr__(...)
x.__setattr__('name', value) <==> x.name = value |
| |
__str__(x)
x.__str__() <==> str(x) |
| Inherited from type |
| |
__new__(T,
S,
...)
T.__new__(S, ...) -> a new object with type S, a subtype of T |