Python 2.7.5 (default, May 15 2013, 22:43:36) [MSC v.1500 32bit (Intel)] on win32
Type"copyright", "credits" or "license()" formore information.>>>help()
Welcome to Python2.7! This isthe online help utility.
If thisisyour first time using Python, you should definitely check out
the tutorial on the Internet at http://docs.python.org/2.7/tutorial/.
Enter the name of any module, keyword,ortopic to get help on writing
Python programsand using Python modules. To quit this help utility and
return to the interpreter, just type "quit".
To get a list of available modules, keywords,or topics, type "modules","keywords", or "topics". Each module also comes with a one-line summary
of what it does; to list the modules whose summaries contain a given word
such as"spam", type "modules spam".
help>MySQLdb
Help on package MySQLdb:
NAME
MySQLdb- MySQLdb -A DB API v2.0 compatible interface to MySQL.
FILE
e:\python2.7.5\lib\site-packages\mysqldb\__init__.py
DESCRIPTION
This packageisa wrapper around _mysql, which mostly implements the
MySQL C API.
connect()--connects to server
See the C API specificationand the MySQL documentation formore info
on other items.
For information on how MySQLdb handles type conversion, see the
MySQLdb.converters module.
PACKAGE CONTENTS
connections
constants (package)
converters
cursors
release
times
SUBMODULES
FIELD_TYPE
CLASSES__builtin__.frozenset(__builtin__.object)
DBAPISet__builtin__.object
datetime.date
datetime.datetime
datetime.time
exceptions.StandardError(exceptions.Exception)
_mysql_exceptions.MySQLError
_mysql_exceptions.Error
_mysql_exceptions.DatabaseError
_mysql_exceptions.DataError
_mysql_exceptions.IntegrityError
_mysql_exceptions.InternalError
_mysql_exceptions.NotSupportedError
_mysql_exceptions.OperationalError
_mysql_exceptions.ProgrammingError
_mysql_exceptions.InterfaceError
_mysql_exceptions.Warning(exceptions.Warning, _mysql_exceptions.MySQLError)
exceptions.Warning(exceptions.Exception)
_mysql_exceptions.Warning(exceptions.Warning, _mysql_exceptions.MySQLError)class DBAPISet(__builtin__.frozenset)| A special type of set for which A == x is true if A isa| DBAPISet and x isa member of that set.|
|Method resolution order:|DBAPISet| __builtin__.frozenset| __builtin__.object|
|Methods defined here:|
| __eq__(self, other)|
| ----------------------------------------------------------------------
|Data descriptors defined here:|
| __dict__
| dictionary for instance variables (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited from __builtin__.frozenset:|
| __and__(...)| x.__and__(y) <==> x&y|
| __cmp__(...)| x.__cmp__(y) <==>cmp(x,y)|
| __contains__(...)| x.__contains__(y) <==> y inx.|
| __ge__(...)| x.__ge__(y) <==> x>=y|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __gt__(...)| x.__gt__(y) <==> x>y|
| __hash__(...)| x.__hash__() <==>hash(x)|
| __iter__(...)| x.__iter__() <==>iter(x)|
| __le__(...)| x.__le__(y) <==> x<=y|
| __len__(...)| x.__len__() <==>len(x)|
| __lt__(...)| x.__lt__(y) <==> x
| __ne__(...)| x.__ne__(y) <==> x!=y|
| __or__(...)| x.__or__(y) <==> x|y|
| __rand__(...)| x.__rand__(y) <==> y&x|
| __reduce__(...)| Return state information forpickling.|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __ror__(...)| x.__ror__(y) <==> y|x|
| __rsub__(...)| x.__rsub__(y) <==> y-x|
| __rxor__(...)| x.__rxor__(y) <==> y^x|
| __sizeof__(...)| S.__sizeof__() -> size of S in memory, inbytes|
| __sub__(...)| x.__sub__(y) <==> x-y|
| __xor__(...)| x.__xor__(y) <==> x^y|
|copy(...)|Return a shallow copy of a set.|
|difference(...)| Return the difference of two ormore sets as a new set.|
| (i.e. all elements that are in this set but notthe others.)|
|intersection(...)| Return the intersection of two ormore sets as a new set.|
|(i.e. elements that are common to all of the sets.)|
|isdisjoint(...)| Return True iftwo sets have a null intersection.|
|issubset(...)|Report whether another set contains this set.|
|issuperset(...)|Report whether this set contains another set.|
|symmetric_difference(...)|Return the symmetric difference of two sets as a new set.|
| (i.e. all elements that are inexactly one of the sets.)|
|union(...)|Return the union of sets as a new set.|
| (i.e. all elements that are ineither set.)|
| ----------------------------------------------------------------------
| Data and other attributes inherited from __builtin__.frozenset:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of TclassDataError(DatabaseError)| Exception raised forerrors that are due to problems with the|processed data like division by zero, numeric value out of range,|etc.|
|Method resolution order:|DataError|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassDatabaseError(Error)| Exception raised forerrors that are related to the|database.|
|Method resolution order:|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|message
Date= class date(__builtin__.object)| date(year, month, day) -->date object|
|Methods defined here:|
| __add__(...)| x.__add__(y) <==> x+y|
| __eq__(...)| x.__eq__(y) <==> x==y|
| __format__(...)|Formats self with strftime.|
| __ge__(...)| x.__ge__(y) <==> x>=y|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __gt__(...)| x.__gt__(y) <==> x>y|
| __hash__(...)| x.__hash__() <==>hash(x)|
| __le__(...)| x.__le__(y) <==> x<=y|
| __lt__(...)| x.__lt__(y) <==> x
| __ne__(...)| x.__ne__(y) <==> x!=y|
| __radd__(...)| x.__radd__(y) <==> y+x|
| __reduce__(...)| __reduce__() ->(cls, state)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __rsub__(...)| x.__rsub__(y) <==> y-x|
| __str__(...)| x.__str__() <==>str(x)|
| __sub__(...)| x.__sub__(y) <==> x-y|
|ctime(...)|Return ctime() style string.|
|fromordinal(...)| int ->date corresponding to a proleptic Gregorian ordinal.|
|fromtimestamp(...)| timestamp -> local date froma POSIX timestamp (like time.time()).|
|isocalendar(...)| Return a 3-tuple containing ISO year, week number, andweekday.|
|isoformat(...)| Return string in ISO 8601 format, YYYY-MM-DD.|
|isoweekday(...)|Return the day of the week represented by the date.| Monday == 1 ... Sunday == 7
|
|replace(...)|Return date with new specified fields.|
|strftime(...)| format ->strftime() style string.|
|timetuple(...)|Return time tuple, compatible with time.localtime().|
|today(...)| Current date or datetime: same as self.__class__.fromtimestamp(time.time()).|
|toordinal(...)| Return proleptic Gregorian ordinal. January 1 of year 1 is day 1.|
|weekday(...)|Return the day of the week represented by the date.| Monday == 0 ... Sunday == 6
|
| ----------------------------------------------------------------------
|Data descriptors defined here:|
|day|
|month|
|year|
| ----------------------------------------------------------------------
| Data andother attributes defined here:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| max = datetime.date(9999, 12, 31)|
| min = datetime.date(1, 1, 1)|
| resolution = datetime.timedelta(1)classError(MySQLError)| Exception that is the base classof all other error exceptions| (notWarning).|
|Method resolution order:|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassIntegrityError(DatabaseError)|Exception raised when the relational integrity of the database| isaffected, e.g. a foreign key check fails, duplicate key,|etc.|
|Method resolution order:|IntegrityError|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassInterfaceError(Error)| Exception raised forerrors that are related to the database|interface rather than the database itself.|
|Method resolution order:|InterfaceError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassInternalError(DatabaseError)|Exception raised when the database encounters an internal| error, e.g. the cursor is not valid anymore, the transaction is
|out of sync, etc.|
|Method resolution order:|InternalError|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassMySQLError(exceptions.StandardError)|Exception related to operation with MySQL.|
|Method resolution order:|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
|Data descriptors defined here:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassNotSupportedError(DatabaseError)| Exception raised in case a method ordatabase API was used| which is notsupported by the database, e.g. requesting a| .rollback() on a connection that does not support transaction or
|has transactions turned off.|
|Method resolution order:|NotSupportedError|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassOperationalError(DatabaseError)| Exception raised for errors that are related to the database's
| operation and notnecessarily under the control of the programmer,| e.g. an unexpected disconnect occurs, the data source name is not
| found, a transaction could notbe processed, a memory allocation|error occurred during processing, etc.|
|Method resolution order:|OperationalError|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|messageclassProgrammingError(DatabaseError)| Exception raised for programming errors, e.g. table notfound| or already exists, syntax error inthe SQL statement, wrong number|of parameters specified, etc.|
|Method resolution order:|ProgrammingError|DatabaseError|Error|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
| Data descriptors inherited fromMySQLError:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.StandardError:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.StandardError:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|message
Time= class time(__builtin__.object)| time([hour[, minute[, second[, microsecond[, tzinfo]]]]]) -->a time object|
| All arguments are optional. tzinfo may be None, oran instance of| a tzinfo subclass. The remaining arguments may be ints orlongs.|
|Methods defined here:|
| __eq__(...)| x.__eq__(y) <==> x==y|
| __format__(...)|Formats self with strftime.|
| __ge__(...)| x.__ge__(y) <==> x>=y|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __gt__(...)| x.__gt__(y) <==> x>y|
| __hash__(...)| x.__hash__() <==>hash(x)|
| __le__(...)| x.__le__(y) <==> x<=y|
| __lt__(...)| x.__lt__(y) <==> x
| __ne__(...)| x.__ne__(y) <==> x!=y|
| __nonzero__(...)| x.__nonzero__() <==> x !=0|
| __reduce__(...)| __reduce__() ->(cls, state)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __str__(...)| x.__str__() <==>str(x)|
|dst(...)|Return self.tzinfo.dst(self).|
|isoformat(...)| Return string in ISO 8601 format, HH:MM:SS[.mmmmmm][+HH:MM].|
|replace(...)|Return time with new specified fields.|
|strftime(...)| format ->strftime() style string.|
|tzname(...)|Return self.tzinfo.tzname(self).|
|utcoffset(...)|Return self.tzinfo.utcoffset(self).|
| ----------------------------------------------------------------------
|Data descriptors defined here:|
|hour|
|microsecond|
|minute|
|second|
|tzinfo|
| ----------------------------------------------------------------------
| Data andother attributes defined here:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| max = datetime.time(23, 59, 59, 999999)|
| min =datetime.time(0, 0)|
| resolution = datetime.timedelta(0, 0, 1)
Timestamp= classdatetime(date)|datetime(year, month, day[, hour[, minute[, second[, microsecond[,tzinfo]]]]])|
| The year, month and day arguments are required. tzinfo may be None, oran| instance of a tzinfo subclass. The remaining arguments may be ints orlongs.|
|Method resolution order:|datetime|date| __builtin__.object|
|Methods defined here:|
| __add__(...)| x.__add__(y) <==> x+y|
| __eq__(...)| x.__eq__(y) <==> x==y|
| __ge__(...)| x.__ge__(y) <==> x>=y|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __gt__(...)| x.__gt__(y) <==> x>y|
| __hash__(...)| x.__hash__() <==>hash(x)|
| __le__(...)| x.__le__(y) <==> x<=y|
| __lt__(...)| x.__lt__(y) <==> x
| __ne__(...)| x.__ne__(y) <==> x!=y|
| __radd__(...)| x.__radd__(y) <==> y+x|
| __reduce__(...)| __reduce__() ->(cls, state)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __rsub__(...)| x.__rsub__(y) <==> y-x|
| __str__(...)| x.__str__() <==>str(x)|
| __sub__(...)| x.__sub__(y) <==> x-y|
|astimezone(...)| tz -> convert to local time innew timezone tz|
|combine(...)| date, time -> datetime with same date andtime fields|
|ctime(...)|Return ctime() style string.|
|date(...)| Return date object with same year, month andday.|
|dst(...)|Return self.tzinfo.dst(self).|
|fromtimestamp(...)| timestamp[, tz] -> tz's local time from POSIX timestamp.
|
|isoformat(...)| [sep] -> string in ISO 8601 format, YYYY-MM-DDTHH:MM:SS[.mmmmmm][+HH:MM].|
| sep is used to separate the year from the time, and defaults to 'T'.|
|now(...)| [tz] -> new datetime with tz's local day and time.
|
|replace(...)|Return datetime with new specified fields.|
|strptime(...)| string, format -> new datetime parsed froma string (like time.strptime()).|
|time(...)| Return time object with same time but with tzinfo=None.|
|timetuple(...)|Return time tuple, compatible with time.localtime().|
|timetz(...)| Return time object with same time andtzinfo.|
|tzname(...)|Return self.tzinfo.tzname(self).|
|utcfromtimestamp(...)| timestamp -> UTC datetime froma POSIX timestamp (like time.time()).|
|utcnow(...)| Return a new datetime representing UTC day andtime.|
|utcoffset(...)|Return self.tzinfo.utcoffset(self).|
|utctimetuple(...)|Return UTC time tuple, compatible with time.localtime().|
| ----------------------------------------------------------------------
|Data descriptors defined here:|
|hour|
|microsecond|
|minute|
|second|
|tzinfo|
| ----------------------------------------------------------------------
| Data andother attributes defined here:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| max = datetime.datetime(9999, 12, 31, 23, 59, 59, 999999)|
| min = datetime.datetime(1, 1, 1, 0, 0)|
| resolution = datetime.timedelta(0, 0, 1)|
| ----------------------------------------------------------------------
| Methods inherited fromdate:|
| __format__(...)|Formats self with strftime.|
|fromordinal(...)| int ->date corresponding to a proleptic Gregorian ordinal.|
|isocalendar(...)| Return a 3-tuple containing ISO year, week number, andweekday.|
|isoweekday(...)|Return the day of the week represented by the date.| Monday == 1 ... Sunday == 7
|
|strftime(...)| format ->strftime() style string.|
|today(...)| Current date or datetime: same as self.__class__.fromtimestamp(time.time()).|
|toordinal(...)| Return proleptic Gregorian ordinal. January 1 of year 1 is day 1.|
|weekday(...)|Return the day of the week represented by the date.| Monday == 0 ... Sunday == 6
|
| ----------------------------------------------------------------------
| Data descriptors inherited fromdate:|
|day|
|month|
|yearclassWarning(exceptions.Warning, MySQLError)| Exception raised forimportant warnings like data truncations| whileinserting, etc.|
|Method resolution order:|Warning|exceptions.Warning|MySQLError|exceptions.StandardError|exceptions.Exception|exceptions.BaseException| __builtin__.object|
|Data descriptors defined here:|
| __weakref__
| list of weak references to the object (ifdefined)|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.Warning:|
| __init__(...)| x.__init__(...) initializes x; see help(type(x)) forsignature|
| ----------------------------------------------------------------------
| Data and other attributes inherited fromexceptions.Warning:|
| __new__ =
| T.__new__(S, ...) ->a new object with type S, a subtype of T|
| ----------------------------------------------------------------------
| Methods inherited fromexceptions.BaseException:|
| __delattr__(...)| x.__delattr__('name') <==> delx.name|
| __getattribute__(...)| x.__getattribute__('name') <==>x.name|
| __getitem__(...)| x.__getitem__(y) <==>x[y]|
| __getslice__(...)| x.__getslice__(i, j) <==>x[i:j]|
| Use of negative indices is notsupported.|
| __reduce__(...)|
| __repr__(...)| x.__repr__() <==>repr(x)|
| __setattr__(...)| x.__setattr__('name', value) <==> x.name =value|
| __setstate__(...)|
| __str__(...)| x.__str__() <==>str(x)|
| __unicode__(...)|
| ----------------------------------------------------------------------
| Data descriptors inherited fromexceptions.BaseException:|
| __dict__
|
|args|
|message
FUNCTIONS
Binary(x)
Connect(*args, **kwargs)
Factory functionforconnections.Connection.
Connection= Connect(*args, **kwargs)
Factory functionforconnections.Connection.
DateFromTicks(ticks)
Convert UNIX ticks into a date instance.
TimeFromTicks(ticks)
Convert UNIX ticks into a time instance.
TimestampFromTicks(ticks)
Convert UNIX ticks into a datetime instance.
connect= Connect(*args, **kwargs)
Factory functionforconnections.Connection.
debug(...)
Does a DBUG_PUSH with the given string.
mysql_debug() uses the Fred Fish debug library.
To use this function, you must compile the client library to
support debugging.
escape(...)
escape(obj, dict)-- escape any special characters inobject obj
using mapping dict to provide quoting functionsforeach type.
Returns a SQL literal string.
escape_dict(...)
escape_sequence(d, dict)-- escape any special characters indictionary d using mapping dict to provide quoting functionsforeach type.
Returns a dictionary of escaped items.
escape_sequence(...)
escape_sequence(seq, dict)-- escape any special characters insequence
seq using mapping dict to provide quoting functionsforeach type.
Returns a tuple of escaped items.
escape_string(...)
escape_string(s)-- quote any SQL-interpreted characters instring s.
Use connection.escape_string(s),ifyou use it at all.
_mysql.escape_string(s) cannot handle character sets. You are
probably better off using connection.escape(o) instead, since
it will escape entire sequences as well as strings.
get_client_info(...)
get_client_info()--Returns a string that represents
the client library version.
string_literal(...)
string_literal(obj)--converts object obj into a SQL string literal.
This means, any special SQL characters are escaped,and it isenclosed
within single quotes. In other words, it performs:"'%s'" %escape_string(str(obj))
Use connection.string_literal(obj),ifyou use it at all.
_mysql.string_literal(obj) cannot handle character sets.
DATA
BINARY= DBAPISet([249, 250, 251, 252])
DATE= DBAPISet([10, 14])
NULL= 'NULL'NUMBER= DBAPISet([0, 1, 3, 4, 5, 8, 9, 13])
ROWID=DBAPISet([])
STRING= DBAPISet([253, 254, 247])
TIME= DBAPISet([11])
TIMESTAMP= DBAPISet([12, 7])__all__ = ['BINARY', 'Binary', 'Connect', 'Connection', 'DATE', 'Date'...__author__ = 'Andy Dustman '
__revision__ = ''
__version__ = '1.2.4b4'apilevel= '2.0'paramstyle= 'format'threadsafety= 1version_info= (1, 2, 4, 'beta', 4)
VERSION1.2.4b4
AUTHOR
Andy Dustmanhelp>