`9Sc@sgdZddlZdZdZdZdZdZdZd Z d Z d Z dS( sDAuxiliary functions to work with Microsoft Access databases via ADO.iNcCs,tjjjd}|jt||S(sOpen an existing Access database file. Return the opened ADO connection object. Raise 'pywintypes.com_error' on failure.sADODB.Connection(twin32comtclienttgencachetEnsureDispatchtOpentgetConnectionString(tfilePatht dbConnection((scode\common\utils\access.pyt openDatabases cCs(tjjjd}|jt|S(sCreate a new empty Access database file. Return the opened ADO connection object. Raise 'pywintypes.com_error' on failure.s ADOX.Catalog(RRRRtCreateR(Rt adoCatalog((scode\common\utils\access.pytcreateDatabase$scCsa|jd}z@g}x3|jsM|j|jjdj|jqWWd|jX|S(s@Return the list of available table names for an opened database.it TABLE_NAMEN(t OpenSchematEOFtappendtFieldstItemtValuetMoveNexttClose(RtrecSett tableNames((scode\common\utils\access.pyt getTableNames/s  cCs|jd}zag}xT|jsn|j}|jdj|kra|j|jdjn|jqWWd|jX|S(s@Return the list of field names of a table in an opened database.iR t COLUMN_NAMEN(R RRRRRRR(Rt tableNameRt fieldNamestfields((scode\common\utils\access.pyt getFieldNames@s   cs}ttko#dkns.tdjfdttD}|jdt||fdS(sCreate a new table in an opened database, given the sequences of its field names and SQL data types. Raise 'pywintypes.com_error' on failure.is, c3s+|]!}t|d|VqdS(t N(t quoteName(t.0ti(RtfieldDataTypes(scode\common\utils\access.pys \ssCREATE TABLE %s (%s)N(tlentAssertionErrortjointrangetExecuteR(RRRR!tfieldsDefinition((R!Rscode\common\utils\access.pyt createTableSs . cCs|dkrdS|dkr dS|dkr0dS|dkr@d S|d krPd S|d kr`d S|dkrpdS|dkrdS|dkrdSdS(sReturn the ADO 'DataTypeEnum' constant for a SQL data type with the given name or 'None' if the data type is not supported. Warning: data type names in different database systems may differ.tDATEtTIMEitINTitSMALLINTitSINGLEitDOUBLEitBITi tVARCHARitLONGTEXTit LONGBINARYi(sDATEsTIMEN(tNone(t sqlDataType((scode\common\utils\access.pytgetDataTypeCodebs&         cCs|dkrdS|dkr dS|dkr0dS|dkr@dS|d krPd S|d kr`d S|d krpdS|dkrdS|dkrdS|dkrdSdS(stReturn a descriptive string for a SQL data type with the given name or 'None' if the data type is not supported.R)tdateR*ttimeR+sfour-byte signed integerR,stwo-byte signed integerR-s&single precision floating point numberR.s&double precision floating point numberR/s boolean valueR0s(null-terminated Unicode character stringR1s-long null-terminated Unicode character stringR2slong binary valueN(R3(R4((scode\common\utils\access.pytgetDataTypeNames*          cCs d|dS(sCReturn a safe SQL representation of a database field or table name.t[t]((t fieldName((scode\common\utils\access.pyRscCs"d|jddd}d|S(swReturn the connection string to be used with an 'ADODB.Connection' object to open an existing Access database file.t"s""s0Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;(treplace(RtquotedFilePath((scode\common\utils\access.pyRs ( t__doc__twin32com.clientRRR RRR(R5R8RR(((scode\common\utils\access.pyts