[Jc @ s
d Z d d k Z d d k Z d d k Z d d k Z d d k Z d d k l Z d d k l Z l
Z
l Z l Z l
Z
d d k l Z d d k l Z d d k l Z d d k l Z l Z d d k l Z d
d d d
d d d d d d d d d d d d d d d d d d d d! d" d# d$ d% d& d' d( d) f Z e d* d+ d, d- d. d/ d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 d: d; d< d= d> d? d@ dA dB dC dD dE dF dG dH dI dJ dK dL dM dN dO dP dQ dR dS dT dU dV dW dX dY dZ d[ d\ d] d^ d_ d` da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz d{ d| d} d~ d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d ddddddddd d
d d d
ddd* d d d d d g Z e i de i e i B Z e i de i e i B Z! de" f d YZ# de" f d YZ$ d e i% e# f d YZ& d e& f d YZ' d e i( e# f d YZ) de) f d YZ* d e i( e# f d YZ+ d e i, e# f d YZ- d
e- f d YZ. d e- f d YZ/ d& e- f d YZ0 d e i1 e- f d YZ2 d
e i3 f d! YZ4 d e i5 f d" YZ6 d e i7 f d# YZ8 d# e i9 f d$ YZ: d$ e i; f d% YZ< d) e i3 f d& YZ= d" e$ e i> f d' YZ? d' e? f d( YZ@ d e? f d) YZA d e? f d* YZB d! e$ e iC f d+ YZD d e$ e iE f d, YZF d e$ e iC f d- YZG d e$ e iE f d. YZH d/e iI f d0 YZJ d( eJ f d1 YZK d eJ f d2 YZL d eJ f d3 YZM d% eM f d4 YZN d eM f d5 YZO d eM f d6 YZP d eD f d7 YZQ d eD f d8 YZR d e iS f d9 YZT h e- e i, 6e2 e i1 6e& e i% 6e+ e i( 6e6 e i5 6e8 e i7 6e: e i9 6eD e iC 6eM e iI 6eT e iS 6e? e i> 6eF e iE 6eH e iU 6e< e i; 6eM e iV 6e) e) 6e* e* 6eJ eJ 6ZW h" e. d5 6eL d6 6e4 d:6eM d7 6eT d;6eF d> 6e8 d<6e6 d=6e' dU 6e) d` 6eQ d>6e' d?6e+ dm 6e- d 6e- d 6eP d 6eB d 6eO d 6e/ d 6eA d 6eH d@6eG dA6e& d 6eR d 6e2 d 6e? dB6e: dC6e< dD6eN d 6e0 d 6e@ d 6eK d 6eD d 6e= dE6ZX dFe iY f dG YZZ dHe i[ f dI YZ\ dJe" f dK YZ] dLe i^ f dM YZ_ dNe i` f dO YZa dPe ib f dQ YZc dRe" f dS YZd e
ie ed dTe if f dU YZg dVeg f dW YZh dXeg f dY YZi ej dZ Zk ej d[ Zl ej d\ Zm d] Zn e\ Zo e_ eo _p ea eo _q ec eo _r eZ eo _s d S(^ s Support for the MySQL database.
Overview
--------
For normal SQLAlchemy usage, importing this module is unnecessary. It will be
loaded on-demand when a MySQL connection is needed. The generic column types
like :class:`~sqlalchemy.String` and :class:`~sqlalchemy.Integer` will
automatically be adapted to the optimal matching MySQL column type.
But if you would like to use one of the MySQL-specific or enhanced column
types when creating tables with your :class:`~sqlalchemy.Table` definitions,
then you will need to import them from this module::
from sqlalchemy.databases import mysql
Table('mytable', metadata,
Column('id', Integer, primary_key=True),
Column('ittybittyblob', mysql.MSTinyBlob),
Column('biggy', mysql.MSBigInteger(unsigned=True)))
All standard MySQL column types are supported. The OpenGIS types are
available for use via table reflection but have no special support or mapping
to Python classes. If you're using these types and have opinions about how
OpenGIS can be smartly integrated into SQLAlchemy please join the mailing
list!
Supported Versions and Features
-------------------------------
SQLAlchemy supports 6 major MySQL versions: 3.23, 4.0, 4.1, 5.0, 5.1 and 6.0,
with capabilities increasing with more modern servers.
Versions 4.1 and higher support the basic SQL functionality that SQLAlchemy
uses in the ORM and SQL expressions. These versions pass the applicable tests
in the suite 100%. No heroic measures are taken to work around major missing
SQL features- if your server version does not support sub-selects, for
example, they won't work in SQLAlchemy either.
Currently, the only DB-API driver supported is `MySQL-Python` (also referred to
as `MySQLdb`). Either 1.2.1 or 1.2.2 are recommended. The alpha, beta and
gamma releases of 1.2.1 and 1.2.2 should be avoided. Support for Jython and
IronPython is planned.
===================================== ===============
Feature Minimum Version
===================================== ===============
sqlalchemy.orm 4.1.1
Table Reflection 3.23.x
DDL Generation 4.1.1
utf8/Full Unicode Connections 4.1.1
Transactions 3.23.15
Two-Phase Transactions 5.0.3
Nested Transactions 5.0.3
===================================== ===============
See the official MySQL documentation for detailed information about features
supported in any given server release.
Character Sets
--------------
Many MySQL server installations default to a ``latin1`` encoding for client
connections. All data sent through the connection will be converted into
``latin1``, even if you have ``utf8`` or another character set on your tables
and columns. With versions 4.1 and higher, you can change the connection
character set either through server configuration or by including the
``charset`` parameter in the URL used for ``create_engine``. The ``charset``
option is passed through to MySQL-Python and has the side-effect of also
enabling ``use_unicode`` in the driver by default. For regular encoded
strings, also pass ``use_unicode=0`` in the connection arguments::
# set client encoding to utf8; all strings come back as unicode
create_engine('mysql:///mydb?charset=utf8')
# set client encoding to utf8; all strings come back as utf8 str
create_engine('mysql:///mydb?charset=utf8&use_unicode=0')
Storage Engines
---------------
Most MySQL server installations have a default table type of ``MyISAM``, a
non-transactional table type. During a transaction, non-transactional storage
engines do not participate and continue to store table changes in autocommit
mode. For fully atomic transactions, all participating tables must use a
transactional engine such as ``InnoDB``, ``Falcon``, ``SolidDB``, `PBXT`, etc.
Storage engines can be elected when creating tables in SQLAlchemy by supplying
a ``mysql_engine='whatever'`` to the ``Table`` constructor. Any MySQL table
creation option can be specified in this syntax::
Table('mytable', metadata,
Column('data', String(32)),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
Keys
----
Not all MySQL storage engines support foreign keys. For ``MyISAM`` and
similar engines, the information loaded by table reflection will not include
foreign keys. For these tables, you may supply a
:class:`~sqlalchemy.ForeignKeyConstraint` at reflection time::
Table('mytable', metadata,
ForeignKeyConstraint(['other_id'], ['othertable.other_id']),
autoload=True
)
When creating tables, SQLAlchemy will automatically set ``AUTO_INCREMENT``` on
an integer primary key column::
>>> t = Table('mytable', metadata,
... Column('mytable_id', Integer, primary_key=True)
... )
>>> t.create()
CREATE TABLE mytable (
id INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
)
You can disable this behavior by supplying ``autoincrement=False`` to the
:class:`~sqlalchemy.Column`. This flag can also be used to enable
auto-increment on a secondary column in a multi-column key for some storage
engines::
Table('mytable', metadata,
Column('gid', Integer, primary_key=True, autoincrement=False),
Column('id', Integer, primary_key=True)
)
SQL Mode
--------
MySQL SQL modes are supported. Modes that enable ``ANSI_QUOTES`` (such as
``ANSI``) require an engine option to modify SQLAlchemy's quoting style.
When using an ANSI-quoting mode, supply ``use_ansiquotes=True`` when
creating your ``Engine``::
create_engine('mysql://localhost/test', use_ansiquotes=True)
This is an engine-wide option and is not toggleable on a per-connection basis.
SQLAlchemy does not presume to ``SET sql_mode`` for you with this option. For
the best performance, set the quoting style server-wide in ``my.cnf`` or by
supplying ``--sql-mode`` to ``mysqld``. You can also use a
:class:`sqlalchemy.pool.Pool` listener hook to issue a ``SET SESSION
sql_mode='...'`` on connect to configure each connection.
If you do not specify ``use_ansiquotes``, the regular MySQL quoting style is
used by default.
If you do issue a ``SET sql_mode`` through SQLAlchemy, the dialect must be
updated if the quoting style is changed. Again, this change will affect all
connections::
connection.execute('SET sql_mode="ansi"')
connection.dialect.use_ansiquotes = True
MySQL SQL Extensions
--------------------
Many of the MySQL SQL extensions are handled through SQLAlchemy's generic
function and operator support::
table.select(table.c.password==func.md5('plaintext'))
table.select(table.c.username.op('regexp')('^[a-d]'))
And of course any valid MySQL statement can be executed as a string as well.
Some limited direct support for MySQL extensions to SQL is currently
available.
* SELECT pragma::
select(..., prefixes=['HIGH_PRIORITY', 'SQL_SMALL_RESULT'])
* UPDATE with LIMIT::
update(..., mysql_limit=10)
Troubleshooting
---------------
If you have problems that seem server related, first check that you are
using the most recent stable MySQL-Python package available. The Database
Notes page on the wiki at http://www.sqlalchemy.org is a good resource for
timely information affecting MySQL in SQLAlchemy.
iN( t array( t exct logt schemat sqlt util( t operators( t functions( t compiler( t baset default( t typest MSBigIntegert MSMediumIntegert MSBinaryt MSBitt MSBlobt MSBooleant MSChart MSDatet
MSDateTimet MSDecimalt MSDoublet MSEnumt MSFloatt MSIntegert
MSLongBlobt
MSLongTextt MSMediumBlobt MSMediumTextt MSNChart
MSNVarChart MSNumerict MSSett MSSmallIntegert MSStringt MSTextt MSTimet MSTimeStampt
MSTinyBlobt
MSTinyIntegert
MSTinyTextt MSVarBinaryt MSYeart
accessiblet addt allt altert analyzet andt ast asct
asensitivet beforet betweent bigintt binaryt blobt botht byt callt cascadet caset changet chart charactert checkt collatet columnt conditiont
constraintt continuet convertt createt crosst current_datet current_timet current_timestampt current_usert cursort databaset databasest day_hourt day_microsecondt
day_minutet
day_secondt dect decimalt declareR
t delayedt deletet desct describet
deterministict distinctt distinctrowt divt doublet dropt dualt eacht elset elseift enclosedt escapedt existst exitt explaint falset fetcht floatt float4t float8t fort forcet foreignt fromt fulltextt grantt groupt havingt
high_priorityt hour_microsecondt hour_minutet hour_secondt ift ignoret int indext infilet innert inoutt insensitivet insertt intt int1t int2t int3t int4t int8t integert intervalt intot ist iteratet joint keyt keyst killt leadingt leavet leftt liket limitt lineart linest loadt localtimet localtimestampt lockt longt longblobt longtextt loopt low_priorityt master_ssl_verify_server_certt matcht
mediumblobt mediumintt
mediumtextt middleintt minute_microsecondt
minute_secondt modt modifiest naturalt nott no_write_to_binlogt nullt numerict ont optimizet optiont
optionallyt ort ordert outt outert outfilet precisiont primaryt proceduret purget ranget readt readst read_onlyt
read_writet realt
referencest regexpt releaset renamet repeatt replacet requiret restrictt returnt revoket rightt rlikeR t schemast second_microsecondt selectt sensitivet separatort sett showt smallintt spatialt specificR t sqlexceptiont sqlstatet
sqlwarningt sql_big_resultt sql_calc_found_rowst sql_small_resultt sslt startingt
straight_joint tablet
terminatedt thent tinyblobt tinyintt tinytextt tot trailingt triggert truet undot uniont uniquet unlockt unsignedt updatet usaget uset usingt utc_datet utc_timet
utc_timestampt valuest varbinaryt varchart varcharactert varyingt whent wheret whilet witht writet x509t xort
year_montht zerofillt columnst fieldst
privilegest sonamet tabless@ \s*(?:UPDATE|INSERT|CREATE|DELETE|DROP|ALTER|LOAD +DATA|REPLACE)s% \s*SET\s+(?:(?:GLOBAL|SESSION)\s+)?\wt _NumericTypec B s e Z d Z d Z d Z RS( s Base for MySQL numeric types.c C s. | i d t | _ | i d t | _ d S( NR R ( t popt FalseR R ( t selft kw( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt __init__ s c C s4 | i o | d 7} n | i o | d 7} n | S( sA Extend a numeric-type declaration with MySQL specific extensions.s UNSIGNEDs ZEROFILL( R R ( R t spec( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt _extend s
( t __name__t
__module__t __doc__R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s t _StringTypec B s; e Z d Z d d e e e e d Z d Z d Z RS( s Base for MySQL string types.c K sF | | _ | i d | | _ | | _ | | _ | | _ | | _ d S( NRC ( t charsett gett collationt asciit unicodeR8 t national( R R R R R R8 R t kwargs( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR # s c C s
| i o d | i } n/ | i o
d } n | i o
d } n d } | i o d | i } n | i o
d } n d } | i oC d i g } d | | f D] } | d j o | | q q ~ Sd i g } | | | f D] } | d j o | | q q ~ S( s Extend a string-type declaration with standard SQL CHARACTER SET /
COLLATE annotations and MySQL specific extensions.
s CHARACTER SET %st ASCIIt UNICODEs
COLLATE %st BINARYt t NATIONALN( R R R t NoneR R8 R R ( R R R R t _[1]t ct _[2]( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR . s"
# c C s t i | i d d } | i t i t i d d h } xE | D]= } t | | } | d j o | t j o | | | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt __repr__J s ! N( R R R R' R R R R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s; e Z d Z d d e d Z d Z d Z d Z RS( s MySQL NUMERIC type.i
i c K s3 t i | | t i i | | | d | | d S( s# Construct a NUMERIC.
:param precision: Total digits in this number. If scale and precision
are both None, values are stored to limits allowed by the server.
:param scale: The number of digits after the decimal point.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
t asdecimalN( R R t sqltypest Numeric( R R t scaleR6 R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR [ s c C sG | i d j o | i d S| i d h | i d 6| i d 6 Sd S( Nt NUMERICs! NUMERIC(%(precision)s, %(scale)s)R R9 ( R R' R R9 ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt get_col_specn s c C s d S( N( R' ( R t dialect( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt bind_processort s c C s | i p d } | Sd Sd S( Nc S s& t | t i o t | S| Sd S( N( t
isinstanceRW t DecimalRn ( t value( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt processy s ( R6 R' ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt result_processorw s
( R R R t TrueR R; R= RB ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR X s
c B s) e Z d Z d d e d Z d Z RS( s MySQL DECIMAL type.i
i c K s& t t | i | | d | | d S( s# Construct a DECIMAL.
:param precision: Total digits in this number. If scale and precision
are both None, values are stored to limits allowed by the server.
:param scale: The number of digits after the decimal point.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
R6 N( t superR R ( R R R9 R6 R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C ss | i d j o | i d S| i d j o | i d h | i d 6 S| i d h | i d 6| i d 6 Sd S( Nt DECIMALs DECIMAL(%(precision)s)R s! DECIMAL(%(precision)s, %(scale)s)R9 ( R R' R R9 ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
( R R R RC R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s) e Z d Z d d e d Z d Z RS( s MySQL DOUBLE type.c K s | d j o
| d j p | d j o | d j o t i d n t i | | t i i | d | | | | _ | | _ d S( s" Construct a DOUBLE.
:param precision: Total digits in this number. If scale and precision
are both None, values are stored to limits allowed by the server.
:param scale: The number of digits after the decimal point.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
sB You must specify both precision and scale or omit both altogether.R6 N( R' R t
ArgumentErrorR R R7 t FloatR9 R ( R R R9 R6 R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C sW | i d j o6 | i d j o& | i d h | i d 6| i d 6 S| i d Sd S( Ns DOUBLE(%(precision)s, %(scale)s)R R9 t DOUBLE( R R' R9 R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
N( R R R R' RC R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s t MSRealc B s) e Z d Z d d e d Z d Z RS( s MySQL REAL type.c K s t i | | | | | d S( s Construct a REAL.
:param precision: Total digits in this number. If scale and precision
are both None, values are stored to limits allowed by the server.
:param scale: The number of digits after the decimal point.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
N( R R ( R R R9 R6 R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C sW | i d j o6 | i d j o& | i d h | i d 6| i d 6 S| i d Sd S( Ns REAL(%(precision)s, %(scale)s)R R9 t REAL( R R' R9 R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
N( R R R R' RC R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRI s c B s2 e Z d Z d d e d Z d Z d Z RS( s MySQL FLOAT type.c K s? t i | | t i i | d | | | | _ | | _ d S( s! Construct a FLOAT.
:param precision: Total digits in this number. If scale and precision
are both None, values are stored to limits allowed by the server.
:param scale: The number of digits after the decimal point.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
R6 N( R R R7 RG R9 R ( R R R9 R6 R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C sw | i d j o. | i d j o | i d | i | i f S| i d j o | i d | i f S| i d Sd S( Ns
FLOAT(%s, %s)s FLOAT(%s)t FLOAT( R9 R' R R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
c C s d S( N( R' ( R R< ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR= s N( R R R R' R R R; R= ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s# e Z d Z d d Z d Z RS( s MySQL INTEGER type.c K s` d | j o# t i d | i d | _ n
| | _ t i | | t i i | | d S( s Construct an INTEGER.
:param display_width: Optional, maximum display width for this number.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
t lengthsJ 'length' is deprecated for MSInteger and subclasses. Use 'display_width'.N( R t warn_deprecatedR t
display_widthR R R7 t Integer( R RN R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s
c C s= | i d j o | i d h | i d 6 S| i d Sd S( Ns INTEGER(%(display_width)s)RN t INTEGER( RN R' R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; " s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s c B s# e Z d Z d d Z d Z RS( s MySQL BIGINTEGER type.c K s t t | i | | d S( s Construct a BIGINTEGER.
:param display_width: Optional, maximum display width for this number.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
N( RD R R ( R RN R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR , s
c C s= | i d j o | i d h | i d 6 S| i d Sd S( Ns BIGINT(%(display_width)s)RN t BIGINT( RN R' R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; ; s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR ) s c B s# e Z d Z d d Z d Z RS( s MySQL MEDIUMINTEGER type.c K s t t | i | | d S( s Construct a MEDIUMINTEGER
:param display_width: Optional, maximum display width for this number.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
N( RD R
R ( R RN R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR E s
c C s= | i d j o | i d h | i d 6 S| i d Sd S( Ns MEDIUMINT(%(display_width)s)RN t MEDIUMINT( RN R' R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; T s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
B s c B s# e Z d Z d d Z d Z RS( s MySQL TINYINT type.c K s t t | i | | d S( s6 Construct a TINYINT.
Note: following the usual MySQL conventions, TINYINT(1) columns
reflected during Table(..., autoload=True) are treated as
Boolean columns.
:param display_width: Optional, maximum display width for this number.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
N( RD R( R ( R RN R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR _ s c C s6 | i d j o | i d | i S| i d Sd S( Ns TINYINT(%s)t TINYINT( RN R' R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; r s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR( \ s c B s# e Z d Z d d Z d Z RS( s MySQL SMALLINTEGER type.c K s0 | | _ t i | | t i i | | d S( s Construct a SMALLINTEGER.
:param display_width: Optional, maximum display width for this number.
:param unsigned: a boolean, optional.
:param zerofill: Optional. If true, values will be stored as strings
left-padded with zeros. Note that this does not effect the values
returned by the underlying database API, which continue to be
numeric.
N( RN R R R7 t SmallInteger( R RN R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR | s
c C s= | i d j o | i d h | i d 6 S| i d Sd S( Ns SMALLINT(%(display_width)s)RN t SMALLINT( RN R' R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR" y s c B s, e Z d Z d d Z d Z d Z RS( s MySQL BIT type.
This type is for MySQL 5.0.3 or greater for MyISAM, and 5.0.5 or greater for
MyISAM, MEMORY, InnoDB and BDB. For older versions, use a MSTinyInteger()
type.
c C s
| | _ d S( sL Construct a BIT.
:param length: Optional, number of bits.
N( RL ( R RL ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s
d } | S( sB Convert a MySQL's 64 bit, variable length binary string to a long.c S sI | d j o8 d } x% t t | D] } | d >| B} q# W| } n | S( Nl i ( R' t mapt ord( R@ t vt i( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB s c C s$ | i d j o d | i Sd Sd S( Ns BIT(%s)t BIT( RL R' ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s N( R R R R' R RB R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s e Z d Z d Z RS( s MySQL DATETIME type.c C s d S( Nt DATETIME( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s ( R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s e Z d Z d Z RS( s MySQL DATE type.c C s d S( Nt DATE( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s ( R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s e Z d Z d Z d Z RS( s MySQL TIME type.c C s d S( Nt TIME( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s c C s
d } | S( Nc S sQ | d j o< t i | i d d | i d d | i | i d d Sd Sd S( Ni< ( R' t datetimet timet seconds( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA s
<( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB s ( R R R R; RB ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR% s c B s e Z d Z d Z RS( s- MySQL TIMESTAMP type.
To signal the orm to automatically re-select modified rows to retrieve the
updated timestamp, add a ``server_default`` to your
:class:`~sqlalchemy.Column` specification::
from sqlalchemy.databases import mysql
Column('updated', mysql.MSTimeStamp,
server_default=sql.text('CURRENT_TIMESTAMP')
)
The full range of MySQL 4.1+ TIMESTAMP defaults can be specified in
the the default::
server_default=sql.text('CURRENT TIMESTAMP ON UPDATE CURRENT_TIMESTAMP')
c C s d S( Nt TIMESTAMP( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s ( R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR& s c B s# e Z d Z d d Z d Z RS( s< MySQL YEAR type, for single byte storage of years 1901-2155.c C s
| | _ d S( N( RN ( R RN ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s$ | i d j o d Sd | i Sd S( Nt YEARs YEAR(%s)( RN R' ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR+ s c B s# e Z d Z d d Z d Z RS( s0 MySQL TEXT type, for text up to 2^16 characters.c K sE t i | | t i i | | | i d t | i d d d S( sc Construct a TEXT.
:param length: Optional, if provided the server may optimize storage
by substituting the smallest TEXT type sufficient to store
``length`` characters.
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param national: Optional. If true, use the server's configured
national character set.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
t convert_unicodet assert_unicodeN( R R R7 t TextR R R' ( R RL R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s0 | i o | i d | i S| i d Sd S( Ns TEXT(%d)t TEXT( RL R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR$ s c B s e Z d Z d Z d Z RS( s3 MySQL TINYTEXT type, for text up to 2^8 characters.c K s t t | i | d S( s Construct a TINYTEXT.
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param national: Optional. If true, use the server's configured
national character set.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
N( RD R) R ( R R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR $ s c C s
| i d S( Nt TINYTEXT( R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; ? s ( R R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR) ! s c B s e Z d Z d Z d Z RS( s6 MySQL MEDIUMTEXT type, for text up to 2^24 characters.c K s t t | i | d S( s Construct a MEDIUMTEXT.
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param national: Optional. If true, use the server's configured
national character set.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
N( RD R R ( R R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR F s c C s
| i d S( Nt
MEDIUMTEXT( R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; ` s ( R R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR C s c B s e Z d Z d Z d Z RS( s4 MySQL LONGTEXT type, for text up to 2^32 characters.c K s t t | i | d S( s Construct a LONGTEXT.
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param national: Optional. If true, use the server's configured
national character set.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
N( RD R R ( R R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR g s c C s
| i d S( Nt LONGTEXT( R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s ( R R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR d s c B s# e Z d Z d d Z d Z RS( s7 MySQL VARCHAR type, for variable-length character data.c K sE t i | | t i i | | | i d t | i d d d S( s Construct a VARCHAR.
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param national: Optional. If true, use the server's configured
national character set.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
Rc Rd N( R R R7 t StringR R R' ( R RL R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s0 | i o | i d | i S| i d Sd S( Ns VARCHAR(%d)t VARCHAR( RL R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR# s c B s e Z d Z d Z d Z RS( s1 MySQL CHAR type, for fixed-length character data.c K s6 t i | | t i i | | | i d t d S( s Construct an NCHAR.
:param length: Maximum data length, in characters.
:param binary: Optional, use the default binary collation for the
national character set. This does not affect the type of data
stored, use a BINARY type for binary data.
:param collation: Optional, request a particular collation. Must be
compatible with the national character set.
Rc N( R R R7 t CHARR R ( R RL R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C s | i d h | i d 6 S( Ns CHAR(%(length)s)RL ( R RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s ( R R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s# e Z d Z d d Z d Z RS( sx MySQL NVARCHAR type.
For variable-length character data in the server's configured national
character set.
c K s@ t | d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C s | i d h | i d 6 S( Ns VARCHAR(%(length)s)RL ( R RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c B s# e Z d Z d d Z d Z RS( sr MySQL NCHAR type.
For fixed-length character data in the server's configured national
character set.
c K s@ t | d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C s | i d h | i d 6 S( Ns CHAR(%(length)s)RL ( R RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s t _BinaryTypec B s e Z d Z d Z d Z RS( s Base for MySQL binary types.c C s | i o d | i Sd Sd S( Ns BLOB(%d)t BLOB( RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
c C s
d } | S( Nc S s# | d j o d St i | Sd S( N( R' R t buffer( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB s ( R R R R; RB ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRm s c B s# e Z d Z d d Z d Z RS( s6 MySQL VARBINARY type, for variable length binary data.c K s t t | i | | d S( sl Construct a VARBINARY. Arguments are:
:param length: Maximum data length, in characters.
N( RD R* R ( R RL R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s | i o d | i Sd Sd S( Ns
VARBINARY(%d)Rn ( RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
N( R R R R' R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR* s c B s, e Z d Z d d Z d Z d Z RS( s/ MySQL BINARY type, for fixed length binary datac K s t t | i | | d S( s/ Construct a BINARY.
This is a fixed length type, and short values will be right-padded
with a server-version-specific pad value.
:param length: Maximum data length, in bytes. If length is not
specified, this will generate a BLOB. This usage is deprecated.
N( RD R R ( R RL R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR % s
c C s | i o d | i Sd Sd S( Ns
BINARY(%d)Rn ( RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; 1 s
c C s
d } | S( Nc S s# | d j o d St i | Sd S( N( R' R Ro ( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA 8 s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB 7 s N( R R R R' R R; RB ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR " s c B s5 e Z d Z d d Z d Z d Z d Z RS( s1 MySQL BLOB type, for binary data up to 2^16 bytesc K s t t | i | | d S( s Construct a BLOB. Arguments are:
:param length: Optional, if provided the server may optimize storage
by substituting the smallest TEXT type sufficient to store
``length`` characters.
N( RD R R ( R RL R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR B s c C s | i o d | i Sd Sd S( Ns BLOB(%d)Rn ( RL ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; L s
c C s
d } | S( Nc S s# | d j o d St i | Sd S( N( R' R Ro ( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA S s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB R s c C s d | i i S( Ns %s()( R/ R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR5 Z s N( R R R R' R R; RB R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR ? s
c B s e Z d Z d Z RS( s5 MySQL TINYBLOB type, for binary data up to 2^8 bytes.c C s d S( Nt TINYBLOB( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; a s ( R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR' ^ s c B s e Z d Z d Z RS( s8 MySQL MEDIUMBLOB type, for binary data up to 2^24 bytes.c C s d S( Nt
MEDIUMBLOB( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; h s ( R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR e s c B s e Z d Z d Z RS( s6 MySQL LONGBLOB type, for binary data up to 2^32 bytes.c C s d S( Nt LONGBLOB( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; o s ( R R R R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR l s c B s) e Z d Z d Z d Z d Z RS( s MySQL ENUM type.c
O s | i d d | _ | i d j o d
} x | D]r } t | d j o d | _ Pn | d
j o | d } n | d | j p | d | j o d | _ Pq2 q2 Wd | _ n | i d j o t i d g } xl | D]d } | d d !d j p | d d !d
j o) | d d !i | d d | d } n | i | q W| | _ n t | | _ | i d t
| _ t g } | i D] } | t | q~ d g } t
t | i | | d
S( s Construct an ENUM.
Example:
Column('myenum', MSEnum("foo", "bar", "baz"))
Arguments are:
:param enums: The range of valid values for this ENUM. Values will be
quoted when generating the schema according to the quoting flag (see
below).
:param strict: Defaults to False: ensure that a given value is in this
ENUM's range of permissible values when inserting or updating rows.
Note that MySQL will not raise a fatal error if you attempt to store
an out of range value- an alternate value will be stored instead.
(See MySQL ENUM documentation.)
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
:param quoting: Defaults to 'auto': automatically determine enum value
quoting. If all enum values are surrounded by the same quoting
character, then use 'quoted' mode. Otherwise, use 'unquoted' mode.
'quoted': values in enums are already quoted, they will be used
directly when generating the schema.
'unquoted': values in enums are not quoted, they will be escaped and
surrounded by single quotes when generating the schema.
Previous versions of this type always required manually quoted
values to be supplied; future versions will always quote the string
literals for you. This is a transitional option.
t quotingt autoi t unquotedit quoteds~ Manually quoting ENUM value literals is deprecated. Supply unquoted values and use the quoting= option in cases of ambiguity.i t "t 'i t strictN( R Rs R' t lenR t warn_pending_deprecationR t appendt enumst listR Ry t maxRD R R (
R R} R t qt et strip_enumst aR( RX RL ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR v s8 3
"
()
7c s. t t i | f d } | S( Nc sX i o4 | d j o' | i j o t i d | n o | S| Sd S( Ns$ "%s" not a valid value for this enum( Ry R' R} R t InvalidRequestError( R@ ( R t
super_convert( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA s ' ( RD R R= ( R R< RA ( ( R R s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR= s c C sQ g } x. | i D]# } | i d | i d d q W| i d d i | S( Ns '%s'Rx s ''s ENUM(%s)t ,( R} R| R R R ( R t quoted_enumsR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; s
!( R R R R R= R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s s X c B s2 e Z d Z d Z d Z d Z d Z RS( s MySQL SET type.c O s | | _ g } xl | D]d } | d d !d j p | d d !d j o) | d d !i | d d | d } n | i | q W| | _ t g } | D] } | t | q ~ d g } t t | i | | d S( s Construct a SET.
Example::
Column('myset', MSSet("'foo'", "'bar'", "'baz'"))
Arguments are:
:param values: The range of valid values for this SET. Values will be
used exactly as they appear when generating schemas. Strings must
be quoted, as in the example above. Single-quotes are suggested for
ANSI compatibility and are required for portability to servers with
ANSI_QUOTES enabled.
:param charset: Optional, a column-level character set for this string
value. Takes precedence to 'ascii' or 'unicode' short-hand.
:param collation: Optional, a column-level collation for this string
value. Takes precedence to 'binary' short-hand.
:param ascii: Defaults to False: short-hand for the ``latin1``
character set, generates ASCII in schema.
:param unicode: Defaults to False: short-hand for the ``ucs2``
character set, generates UNICODE in schema.
:param binary: Defaults to False: short-hand, pick the binary
collation type that matches the column's character set. Generates
BINARY in schema. This does not affect the type of data stored,
only the collation of character data.
i i Rw Rx ii N( t _MSSet__ddl_valuesR R| R R Rz RD R! R ( R R R t strip_valuesR R( RX RL ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s ! () 4c C s
d } | S( Nc S sy t | t i o= | p | i d n t | t p t | } n | S| d j o t | i d S| Sd S( Nt R ( R> R t set_typesR- R R' t split( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB s c s+ t t | i | f d } | S( Nc s | d j p t | t t t f o nG d | j o* t | } | i d | i d n d i | } o | S| Sd S( NR R ( R' R> R R t
basestringR t removeR- R ( R@ ( R ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA ( s &
( RD R! R= ( R R< RA ( ( R s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR= & s
c C s | i d d i | i S( Ns SET(%s)R ( R R R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; 7 s ( R R R R RB R= R; ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR! s
. c B s) e Z d Z d Z d Z d Z RS( s MySQL BOOLEAN type.c C s d S( Nt BOOL( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR; > s c C s
d } | S( Nc S s$ | d j o d S| o t p t S( N( R' RC R ( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA B s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRB A s c C s
d } | S( Nc S sL | t j o d S| t j o d S| d j o d S| o t p t Sd S( Ni i ( RC R R' ( R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRA I s
( ( R R< RA ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR= H s ( R R R R; RB R= ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR ; s t bitt booleant dateR^ t enumt fixedt nchart nvarchart textR_ t timestampt yeart MySQLExecutionContextc B s e Z d Z d Z RS( c C s | i i oU | i oJ t | i p | i d d j o! | i i g | i d | _ q nN | i oB | i o7 | i
o- t i | i
o | i
i i d d n d S( Ni i t mysqlR ( s mysqls charset( t compiledt isinsertt executemanyRz t _last_inserted_idsR' RO t lastrowidt isupdatet should_autocommitt statementt SET_RER t
connectiont infoR ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt post_exec s c C s
t i | S( N( t
AUTOCOMMIT_RER ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt should_autocommit_text s ( R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s t MySQLDialectc B s e Z d Z d Z e Z e Z d Z e Z d Z
d* d Z d Z
e e
Z
d Z d Z d* d Z d Z d
Z d Z d Z d
Z e e d Z e e d Z d Z d Z d Z d Z e i d+ e Z d Z d* d Z d Z e i d, e Z d Z! d Z" d* d Z# d Z$ e i d- e$ Z$ d Z% e i d. e% Z% d! Z& e i d/ e& Z& d# Z' e( d$ e' d% d& Z' d* d' Z) d* d* d( Z* d* d* d) Z+ RS(0 sE Details of the MySQL dialect. Not used directly in application code.R i t formatc K s | | _ t i i | | d S( N( t use_ansiquotesR
t DefaultDialectR ( R R R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s d d k } | S( Ni( t MySQLdb( t clsR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt dbapi s c C s | i d d d d d d } | i | i t i | d t t i | d t t i | d t t i | d
t t i | d t t i | d t h } x^ d
d d d d g D]G } | | j o4 | | | | d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt create_connect_args s6
c C s t i | t S( N( R7 t
adapt_typet colspecs( R t typeobj( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt type_descriptor s c C s0 | i | | } | d j o
| | _ n d S( N( R R' t _rowcount( R RO R t
parameterst contextt rowcount( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_executemany s
c C s t S( N( RC ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt supports_unicode_statements s c C si y | i WnT | i | d j o4 t i d i } | o | d d j o d Sn n Xd S( s Execute a COMMIT.i i i i i i( N( i i i ( t committ _server_version_infot syst exc_infot args( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_commit s c C si y | i WnT | i | d j o4 t i d i } | o | d d j o d Sn n Xd S( s Execute a ROLLBACK.i i i i i i( N( i i i ( t rollbackR R R R ( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_rollback s c C s | i d | d S( Ns XA BEGIN %s( t execute( R R t xid( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_begin_twophase s c C s$ | i d | | i d | d S( Ns XA END %ss
XA PREPARE %s( R ( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_prepare_twophase s c C s/ | p | i d | n | i d | d S( Ns XA END %ss XA ROLLBACK %s( R ( R R R t is_preparedt recover( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_rollback_twophase
s c C s/ | p | i | | n | i d | d S( Ns XA COMMIT %s( R R ( R R R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_commit_twophase s c C s= | i d } g } | D] } | | d d | d !q ~ S( Ns
XA RECOVERt datai t gtrid_length( R ( R R t resultsetR( t row( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_recover_twophase s c C s | i d S( N( t ping( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt do_ping s c C sW t | | i i o | i d d j St | | i i o d t | j St Sd S( Ni i i i i i s (0, '')( i i i i i ( R> R t OperationalErrorR t InterfaceErrorR R ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt
is_disconnect s
c C s | i d i S( Ns SELECT DATABASE()( R t scalar( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt get_default_schema_name% s R< t default_schema_namec C sj | i | } | i | | i d | i i | } g } t | d | D] } | | d qR ~ S( s1 Return a Unicode SHOW TABLES from a given schema.s SHOW TABLES FROM %sR i ( t _detect_charsett _autoset_identifier_styleR t identifier_preparert quote_identifiert _compat_fetchall( R R R R t rpR( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt table_names* s
c C s | i | d i | i i | | } d | } d } zn y0 | i | } | i d j } | i | SWn7 t i j
o( } | i
i d d j o t S n XWd | o | i n Xd S( Nt .s DESCRIBE %si iz (
R R R t _quote_free_identifiersR' R R t closeR t SQLErrort origR R ( R R t
table_nameR t full_namet stt rst haveR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt has_table3 s"
c C s | i | i i S( s A tuple of the database server version.
Formats the remote server version as a tuple of version values,
e.g. ``(5, 0, 44)``. If there are strings in the version number
they will be in the tuple too, so don't count on these all being
``int`` values.
This is a fast check that does not require a round trip. It is also
cached per-Connection.
( R R ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt server_version_infoS s R c C sy g } t i d } xW | i | i D]@ } y | i t | Wq+ t j
o | i | q+ Xq+ Wt | S( s7 Convert a MySQL-python server_info string into a tuple.s [.\-]( t ret compileR t get_server_infoR| R t
ValueErrort tuple( R t dbapi_cont versiont rt n( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR c s c
C s | i | } | i | y
| i } Wn_ t j
oS | i } | i | d j o | i o t | } n t | | _ } n X| i | | | } | i
d o+ | i | | | } | i | | } n | i
| | | i | | | | d | S( s( Load column definitions from the server.i i s CREATE ALGORITHMt only( i i ( R R t reflectort AttributeErrorR R R t MySQLIdentifierPreparert MySQLSchemaReflectort _show_create_tablet
startswitht _describe_tablet _describe_to_createt _adjust_casingt reflect( R R R t include_columnsR R t preparerR R
( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt reflecttableo s"
c C sw | i | } | d j oW | i | i i j o> | i i | _ t i | i | i } | | i i | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
&c
C s d | i j o | i d
S| i | d j o+ y | i i SWq] t j
o q] Xn | i d } t g } t | D] } | | d | d f q ~ } d | j o | d Sy | i i SWn: t j
o. d | j o | d St i d d
Sn Xd S( s: Sniff out the character set in use for connection results.R t
force_charseti i i s% SHOW VARIABLES LIKE 'character_set%%'t character_set_resultst
character_sets Could not detect the connection character set with this combination of MySQL server and MySQL-python. MySQL-python >= 1.2.2 is recommended. Assuming latin1.t latin1N( s mysqlR% ( s mysqlR% ( i i i (
R R R t character_set_nameR R t dictR R t warn( R R R R( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s& ;
R c C s | i | } t | i d d | } | p
d } nQ | d d j o
d } n, | d d j o
d } n t | d } | i | S( s Sniff out identifier case sensitivity.
Cached per-connection. This value can not change without a server
restart.
s, SHOW VARIABLES LIKE 'lower_case_table_names'R i i t OFFt ON( R t _compat_fetchoneR R R ( R R R R t cs( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
t lower_case_table_namesc C sn h } | i | d j o nK | i | } | i d } x) t | | D] } | d | | d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt _detect_collations s R1 c C sj | | _ | o
t | _ n
t | _ t | d o | i | | _ n t | d o
| ` n d S( NR R ( t _use_ansiquotest MySQLANSIIdentifierPreparerR R t hasattrR R ( R t useansi( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C s | i S( ( R3 ( t s( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt s t docs! True if ANSI_QUOTES is in effect.c C s | i d j o d St | i d d | } | p
d } nM | d p d } | i o. t | } | d B| j o d p d } n d | j | _ d S( s Detect and adjust for the ANSI_QUOTES sql mode.
If the dialect's use_ansiquotes is unset, query the server's sql mode
and reset the identifier style.
Note that this currently *only* runs during reflection. Ideally this
would run the first time a connection pool connects to the database,
but the infrastructure for that is not yet in place.
Ns SHOW VARIABLES LIKE 'sql_mode'R R i i t ANSI_QUOTES( R R' R. R t isdigitR ( R R R R t modet mode_no( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
"c
C s | d j o | i i | } n d | } d } z y | i | } WnE t i j
o6 } | i i d d j o t i | q n Xt | d | } | p t i | n | d i
SWd | o | i n Xt S( s& Run SHOW CREATE TABLE for a ``Table``.s SHOW CREATE TABLE %si iz R i N(
R' R t format_tableR R R R R t NoSuchTableErrorR. t stripR R ( R R R R R R R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s$
c
C s | d j o | i i | } n d | } d \ } } zq y | i | } WnE t i j
o6 } | i i d d j o t i | q n Xt | d | } Wd | o | i
n X| S( s7 Run DESCRIBE for a ``Table`` and return processed rows.s DESCRIBE %si iz R N( NN( R' R R> R R R R R R? R R ( R R R R R R R t rowsR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR 8 s
N( s dialectR ( s mysqls server_version_info( s mysqls charset( s mysqlR0 ( s mysqls
collations(, R R R R RC t supports_alterR R t max_identifier_lengtht supports_sane_rowcountt default_paramstyleR' R R t classmethodR R R R R R R R R R R R R t engine_baset connection_memoizeR R R R R R R R R2 R t propertyR R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR sj '
( t _MySQLPythonRowProxyc B s) e Z d Z d Z d Z d Z RS( s Return consistent column values for all versions of MySQL-python.
Smooth over data type issues (esp. with alpha driver versions) and
normalize strings as Unicode regardless of user-configured driver
encoding settings.
c C s | | _ | | _ d S( N( t rowproxyR ( R RK R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR [ s c C s` | i | } t | t o | i } n | i o! t | t o | i | i S| Sd S( N( RK R> t _arrayt tostringR R t decode( R R t item( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt __getitem__^ s
c C se t | i | } t | t o | i } n | i o! t | t o | i | i S| Sd S( N( R. RK R> RL RM R R RN ( R R2 RO ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt __getattr__f s ( R R R R RP RQ ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRJ O s t
MySQLCompilerc B s e Z e i i i Z e i h d e i 6d e i 6d e i
6 e i i i Z e i h d e i
6d d 6 e i i i Z e i h d d 6 d Z d Z d
Z d Z e d Z d
Z d Z d Z RS( c C s d | | f S( s concat(%s, %s)( ( t xt y( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR8 s s s %%c C s d | | f S( s' MATCH (%s) AGAINST (%s IN BOOLEAN MODE)( ( RS RT ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR8 u s s rand%(expr)st
UTC_TIMESTAMPR t millisecondt millisecondsc C sI | i i | i } t | t o t | d t o d Sd Snt | t t t t
f o | i St | t o d St | t
o; t | t t f o$ t | d o d | i Sd Snz t | t o d St | t o | i i d d St | t o d
St | t t t
f o | i Sd Sd S( NR s UNSIGNED INTEGERs SIGNED INTEGERRl RL s CHAR(%s)R$ R: RE R[ ( t typet dialect_implR< R> R R. R R R R R% R; R$ R R R! RL Rm R R R& R' ( R t
typeclauset type_( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt visit_typeclause s. c K sJ | i | i } | d j o | i | i Sd | i | i | f S( Ns CAST(%s AS %s)( RA RZ R' t clause( R t castR! R[ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt
visit_cast s
c C s. d | j o t i d n | i d d S( Ns %%s[ The SQLAlchemy MySQLDB dialect now automatically escapes '%' in text() expressions to '%%'.t %( R R+ R ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt post_process_text s
c C s< t | i t o | i i d S| i o d Sd Sd S( NR% s DISTINCT R ( R> t _distinctR t upper( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt get_select_precolumns s
c K s] d i | i | i d t | i o d p d | i | i d t d | i | i f S( NR t asfroms LEFT OUTER JOIN s INNER JOIN s ON ( R RA R RC t isouterR t onclause( R R Re R! ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt
visit_join s c C s/ | i d j o d St t | i | Sd S( NR s LOCK IN SHARE MODE( t
for_updateRD RR t for_update_clause( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRj s c C sm | i | i } } | | f d j o d S| d j o& | d j o
d } n d | | f Sd | f Sd S( NR l s
LIMIT %s, %ss
LIMIT %s( NN( t _limitt _offsetR' ( R R R t offset( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt limit_clause s
c C s | i i h t | i g d 6 t | _ | i | } d | i i | i d d i g } | D]+ } | d | i i
| d | d f qf ~ } | i o | d | i | i 7} n | i
i d d } | o | d
| 7} n | i i d | S( NRt s UPDATE s SET s , s %s=%si i s WHERE t mysql_limits LIMIT %si( t stackR| R R RC R t _get_colparamsR R> R t
format_columnt _whereclauseRA R! R R' R ( R t update_stmtt colparamsR( R) R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt visit_update s # c
( R R R t DefaultCompilerR t copyR t
sql_operatorst concat_opR t match_opR t
sql_functionst randomt extract_mapR\ R_ Ra Rd R Rh Rj Rn Rv ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyRR p s(
t MySQLSchemaGeneratorc B s e Z e d Z d Z RS( c C s8 | i i | | i i | i i g } | i | } | d j o | i d | n | i p | i d n | i
o | i o y g } | i i
i
D]< } | i o, t | i t i o | i o | | q q ~ i d } | | j o | i d n Wq+t j
o q+Xn d i | S( s Builds column DDL.s DEFAULT s NOT NULLi t AUTO_INCREMENTR% N( R Rr RX RY R< R; t get_column_default_stringR' R| t nullablet primary_keyt
autoincrementR R
R> R7 RO t foreign_keysR t
IndexErrorR ( R RD t first_pkt colspecR
R( R) t first( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt get_column_specification s$
(
c C s g } xu | i D]j } | i d oT | d i } d } | d j o
d } n | i | i | | i | f q q Wd i | S(
s9 Build table-level CREATE options like ENGINE and COLLATE.t mysql_i t =t
TABLESPACEs DEFAULT CHARACTER SETs
CHARACTER SETt COLLATER% ( R s DEFAULT CHARACTER SETs
CHARACTER SETR ( R! R Rc R| R ( R R t
table_optsR4 t optt joiner( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt post_create_table s
+( R R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s t MySQLSchemaDropperc B s e Z d Z d Z RS( c C sU | i d | i i | i | i t | i | i i | i f | i d S( Ns
DROP INDEX %s ON %s( R| R t quotet _validate_identifierR R R> R R ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt visit_index" s $c C s@ | i d | i i | i | i i | f | i d S( Ns" ALTER TABLE %s DROP FOREIGN KEY %s( R| R R> R t format_constraintR ( R RF ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt drop_foreignkey( s ( R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR ! s R c B s e Z d Z d Z d d Z d Z d d Z d Z d Z d Z
d Z d Z d
Z
d Z d Z d
Z d Z d Z d Z d Z RS( s Parses SHOW CREATE TABLE output.c C s | | _ | i d S( s Construct a MySQLSchemaReflector.
identifier_preparer
An ANSIIdentifierPreparer type, used to determine the identifier
quoting style in effect.
N( R t
_prep_regexes( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR 2 s c C sy g g } } | o t | } n x%t i d | D]} | i d | i i o | i | | | | q7 | i d o | i | | q7 | d j o q7 | i d o | i | | q7 | p q7 | i | \ } }
| d j o t i d | q7 | d j o | i
|
q7 | d j o | i
|
q7 q7 W| i | | | | i | | | | d S(
s1 Parse MySQL SHOW CREATE TABLE and fill in a ''Table''.
show_create
Unicode output of SHOW CREATE TABLE
table
A ''Table'', to be loaded with Columns, Indexes, etc.
table.name will be set if not already
charset
FIXME, some constructed values (like column defaults)
currently can't be Unicode. ''charset'' will convert them
into the connection character set.
only
An optional sequence of column names. If provided, only
these columns will be reflected, and any keys or constraints
that include columns outside this set will also be omitted.
That means that if ``only`` includes only one column in a
2 part primary key, the entire primary key will be omitted.
s \r?\ns s ) t )s CREATE s Unknown schema content: %rR RF N( R R R R R t
initial_quotet _add_columnt _set_optionst _set_namet parse_constraintsR' R R+ R| t _set_keyst _set_constraints( R R R t show_createR R R t constraintst lineR[ R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR = s2
c C s* | i d j o | i | | _ n d S( s Override a Table name with the reflected name.
table
A ``Table``
line
The first line of SHOW CREATE TABLE output.
N( R R' t
parse_name( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR u s c C sy | i | } | p t i d | d S| d p t i d | n | d | d | d | d f \ } } } } | o/ | | j o" | i i d | i | f d S| d j o | d
j o d } d } n y t | }
Wn3 t j
o' t i d | | f t i
}
n X| d j p
| d
j o
g } nl | d d j o' | d d j o | i i | } n4 g } | i
i | D] }
| t |
q~ } h } x/ d D]' } | i | t o t | | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR sl .
"3
c C s x| D]} | d } g } | d D] } | | d q& ~ } | oX t | i | oA | d j o
d } n | i i d | d i | f q n t } | d j o t i }
t } nv | d j o t i
| d d
t }
nL | d j o t i
| d }
n( | i i d
| t i
| d }
x= g } | D] } | | i | qK~ D] }
|
i |
qfW| o | i
|
q q Wd S( s Add ``Index`` and ``PrimaryKeyConstraint`` items to a ``Table``.
Most of the information gets dropped here- more is reflected than
the schema objects can currently represent.
table
A ``Table``
keys
A sequence of key specifications produced by `constraints`
only
Optional `set` of column names. If provided, keys covering
columns not in this set will be omitted.
RX R
i R s6 Omitting %s KEY for (%s), key covers ommitted columns.s , t PRIMARYt UNIQUER R t FULLTEXTt SPATIALs- Converting unknown KEY type %s to a plain KEYN( NR R ( R t issubsetR' R R R R R t PrimaryKeyConstraintRC t IndexR) R t append_constraint( R R R R R t flavorR( R7 t col_namesRF R R* R t col( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s6
)
) c C s+ d } x | D]} | d d } t | d d j o | d d p | i } | pD | d j o | i i | } n | i | j o
| i } q n | d } | o; t | i | o$ | i i d d i | q
n t i
| | }
|
| i i j o | i i |
} n( t i
| | i d | d t d
| } | d } | o7 g }
| D] } |
d i | | | g qc~
} n1 g } | D] } | d i | | g q~ } h } x3 d D]+ } | i | t o | | | | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR sD /
70 c C sb | i | } x d D] } | i | d q Wx+ | i D] \ } } | | i d | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR 0 s
c C s g | _ g | _ h | _ | i i } t t d, g } | i i | | i i | f D] } | t i
| qV ~ } t d | | i i | _
t d | | _ t d | _ t d | _ t d | | _ t d | | _ t d
| | _ | i } d | d (?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +\($sF (?:(?:%(iq)s((?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)(?:\((\d+)\))?(?=\,|$))+s \x27(?:\x27\x27|[^\x27])*\x27s \d+s- %(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P\w+)(?:\((?P(?:\d+|\d+,\d+|(?:\x27(?:\x27\x27|[^\x27])*\x27,?)+))\))?(?: +(?PUNSIGNED))?(?: +(?PZEROFILL))?(?: +CHARACTER SET +(?P\w+))?(?: +COLLATE +(P\w+))?(?: +(?PNOT NULL))?(?: +DEFAULT +(?P(?:NULL|\x27(?:\x27\x27|[^\x27])*\x27|\w+)(?:ON UPDATE \w+)?))?(?: +(?PAUTO_INCREMENT))?(?: +COMMENT +(P(?:\x27\x27|[^\x27])+))?(?: +COLUMN_FORMAT +(?P\w+))?(?: +STORAGE +(?P\w+))?(?: +(?P.*))?,?$s %(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P\w+)(?:\((?P(?:\d+|\d+,\d+|\x27(?:\x27\x27|[^\x27])+\x27))\))?.*?(?PNOT NULL)?s (?:(?P\S+) )?KEY(?: +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)?(?: +USING +(?P\S+))? +\((?P.+?)\)(?: +USING +(?P\S+))?(?: +KEY_BLOCK_SIZE +(?P\S+))?(?: +WITH PARSER +(?P\S+))?,?$s# RESTRICT|CASCASDE|SET NULL|NOACTIONR s, CONSTRAINT +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +FOREIGN KEY +\((?P[^\)]+?)\) REFERENCES +(?P%(iq)s[^%(fq)s]+%(fq)s(?:\.%(iq)s[^%(fq)s]+%(fq)s)?) +\((?P[^\)]+?)\)(?: +(?PMATCH \w+))?(?: +ON DELETE (?P%(on)s))?(?: +ON UPDATE (?P%(on)s))?s (?:SUB)?PARTITIONt ENGINEt TYPER t AVG_ROW_LENGTHs
CHARACTER SETs DEFAULT CHARSETt CHECKSUMR t DELAY_KEY_WRITEt
INSERT_METHODt MAX_ROWSt MIN_ROWSt PACK_KEYSt
ROW_FORMATt KEY_BLOCK_SIZEt COMMENTt DATA_DIRECTORYt INDEX_DIRECTORYt PASSWORDt
CONNECTIONt UNIONs
\([^\)]+\)R s .*? STORAGE DISKt RAID_TYPEs4 \w+\s+RAID_CHUNKS\s*\=\s*\w+RAID_CHUNKSIZE\s*=\s*\w+s \s*=\s*$R N( R R R ( R R s AUTO_INCREMENTR s
CHARACTER SETs DEFAULT CHARSETR s COLLATER R R R R R R ( R R R R R ( t _re_columnst _pr_optionst _re_options_utilR t final_quoteR* t zipR t _escape_identifierR t escapet _pr_compilet _unescape_identifiert _pr_namet _re_compilet _re_keyexprsR R t
_re_columnt _re_column_looset _re_keyRx t _re_constraintt
_re_partitiont _add_option_wordt _add_option_stringt _add_option_regex( R t _finalR( R7 t quotesR R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR A sf 8
c C s3 d t i | } | i i t | d d S( NsB (?P%s\s*(?:=\s*)?)(?:\x27.(?P.*?)\x27(?!\x27)\x27)c S s | i d d S( s ''Rx ( R ( RX ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR8 s ( R R R R| R ( R t directivet regex( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s c C s- d t i | } | i i t | d S( Ns) (?P%s\s*(?:=\s*)?)(?P\w+)( R R R R| R ( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s3 d t i | | f } | i i t | d S( Ns( (?P%s\s*(?:=\s*)?)(?P%s)( R R R R| R ( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s c C s= | i \ } } | i | } | p d S| | i d S( s\ Extract the table name.
line
The first line of SHOW CREATE TABLE
R N( R R R' Rw ( R R R t cleanupt m( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C sl | i i | } | o | i } t | d <| S| i i | } | o | i } t | d <| Sd S( s Extract column details.
Falls back to a 'minimal support' variant if full parse fails.
line
Any column-bearing line from SHOW CREATE TABLE
R N( R R t groupdictRC R R R' ( R R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
c C s+ | i i | } | o. | i } | i | d | d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s$ // c C s h } | p
| d j o | S| i d } x | i D] \ } } | i | } | p q7 n | i d | i d } } | i d | i } | o | | } n | | | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR $
s
c
C s g } xf| D]^} g } d D] } | | | q ~ \ } } } }
} d g } | i | i i | | i | | p | i d n |
o d |
j o q=| i d o. |
i d
o | i d | i |
q=|
d j o | i d | i |
q=| i d | i d
|
i d d n | o | i | n | i d i | q
Wd i d | i i | i d i | d g S( s Re-format DESCRIBE output as a SHOW CREATE TABLE string.
DESCRIBE is a much simpler reflection and is sufficient for
reflecting views for runtime use. This method formats DDL
for columns only- keys are omitted.
`columns` is a sequence of DESCRIBE or SHOW COLUMNS 6-tuples.
SHOW FULL COLUMNS FROM rows must be rearranged for use with
this function.
i i i i i R% s NOT NULLR R t Ct DEFAULTR s '%s'Rx s ''R s CREATE TABLE %s (
s ,
s
) ( i i i i i ( R| R R R R R R (
R R R
Ro R R( RY R R R R
t extraR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR >
s8 4
! c C s | i i | S( s8 Unpack '"col"(2),"col" ASC'-ish strings into components.( R R ( R t identifiers( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR k
s N( R R R R R' R R R R R R R R
R R R R R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR / s$ 8 N 0 /
$ -t _MySQLIdentifierPreparerc B s& e Z d Z e Z d Z d Z RS( s/ MySQL-specific schema identifier configuration.c K s t t | i | | d S( N( RD R R ( R R< R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR x
s c G s? t g } | D]' } | d j o | | i | q q ~ S( s4 Unilaterally identifier-quote any number of strings.N( R R' R ( R t idsR( RY ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR {
s ( R R R t RESERVED_WORDSt reserved_wordsR R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR s
s R c B s) e Z d Z d Z d Z d Z RS( s; Traditional MySQL-specific schema identifier configuration.c C s t t | i | d d d S( NR t `( RD R R ( R R< ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s c C s | i d d S( NR! s ``( R ( R R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s c C s | i d d S( Ns ``R! ( R ( R R@ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s ( R R R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s R4 c B s e Z d Z RS( s2 ANSI_QUOTES MySQL schema identifier configuration.( R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR4
s c C s. g } | i D] } | t | | q ~ S( sE Proxy result rows to smooth over MySQL-Python driver inconsistencies.( t fetchallRJ ( R R R( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s c C s t | i | S( sF Proxy a result row to smooth over MySQL-Python driver inconsistencies.( RJ t fetchone( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR.
s c C s t | | f S( s1 Prepare a 2-tuple of compiled regex and callable.( R ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s c C s t i | t i t i B S( s) Compile a string to regex, I and UNICODE.( R R t IR# ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyR
s (t R R^ RW R+ R R R RL t
sqlalchemyR R R R R t sqlalchemy.sqlR Ry R R| R t sqlalchemy.engineR RG R
R R7 t __all__R R R R$ R# R R t objectR R R8 R R RG R RI R RO R R R
R( t SmallintegerR" t
TypeEngineR t DateTimeR t DateR t TimeR% Ra R& R+ Re R$ R) R R Rj R# Rl R R R t BinaryRm R* R R R' R R R R! t BooleanR t NCHARRn R R t DefaultExecutionContextR R R RJ Rw RR t SchemaGeneratorR t
SchemaDropperR R t class_loggert IdentifierPreparerR R R4 R' R R. R R R< t statement_compilert schemageneratort
schemadroppert execution_ctx_cls( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mysql.pyt s\ <( 8 + ' $ # *"!! & m[
!+ C