§ êَü@”i+nمَع—dZddlZddlmZddlmZddlmZddlmZddlmZd d lm Z d dlm Z Gd„d e¦«ZGd„de¦«ZGd„de¦«Z Gd„de¦«ZeZdS)a .. dialect:: mysql+mysqldb :name: mysqlclient (maintained fork of MySQL-Python) :dbapi: mysqldb :connectstring: mysql+mysqldb://:@[:]/ :url: https://pypi.org/project/mysqlclient/ Driver Status ------------- The mysqlclient DBAPI is a maintained fork of the `MySQL-Python `_ DBAPI that is no longer maintained. `mysqlclient`_ supports Python 2 and Python 3 and is very stable. .. _mysqlclient: https://github.com/PyMySQL/mysqlclient-python .. _mysqldb_unicode: Unicode ------- Please see :ref:`mysql_unicode` for current recommendations on unicode handling. Using MySQLdb with Google Cloud SQL ----------------------------------- Google Cloud SQL now recommends use of the MySQLdb dialect. Connect using a URL like the following:: mysql+mysqldb://root@/?unix_socket=/cloudsql/: Server Side Cursors ------------------- The mysqldb dialect supports server-side cursors. See :ref:`mysql_ss_cursors`. éNé)ع MySQLCompiler)عMySQLDialect)عMySQLExecutionContext)عMySQLIdentifierPreparer)عTEXTé)عsql)عutilcَ$—eZdZed„¦«ZdS)عMySQLExecutionContext_mysqldbcَH—t|d¦«r|jS|jjS)Nع _rowcount)عhasattrrعcursorعrowcount)عselfs ْu/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyrz&MySQLExecutionContext_mysqldb.rowcount>s'€هگ4کر%ش%ً (ط”>ذ!à”;ش'ذ'َN)ع__name__ع __module__ع__qualname__عpropertyr©rrr r =s-€€€€€ط ً(ً(ٌ„Xً(ً(ً(rr cَ—eZdZdS)عMySQLCompiler_mysqldbN©rrrrrrrrFَ€€€€€ط€Drrcَ—eZdZdS)عMySQLIdentifierPreparer_mysqldbNrrrrr r Jrrr cَن‡—eZdZdZdZdZdZdZdZe Z eZe Zdˆfd„ Zd„Zejjd„¦«Zed„¦«Zˆfd „Zd „Zdd„Zˆfd „Zdd„Zd„Zd„Zegd¢¦«Zˆfd„Z ˆxZ!S)عMySQLDialect_mysqldbعmysqldbTعformatFcَع•—tt|¦«jdi|¤ژ||_|jپ4t|jd¦«r| |jj¦«nd|_dS)Nع__version__©rrrr) عsuperr"ع__init__عserver_side_cursorsعdbapirع_parse_dbapi_versionr&ع_mysql_dbapi_version)rr*عkwargsع __class__s €rr)zMySQLDialect_mysqldb.__init__[svّ€ط2چص" Dر)ش)ش2ذ<ذ<°Vذ<ذ<ذ<ط#6ˆش ًŒzذ%'°$´*¸mر*Lش*Lذ%ً ×%ز% d¤jش&<ر=ش=ذ=àً ش!ذ!ذ!rcَگ—tjd|¦«}|r.td„| ddd¦«D¦«¦«SdS)Nz(\d+)\.(\d+)(?:\.(\d+))?c3َ8K—|]}|®t|¦«V—ŒdS©N)عint)ع.0عxs rْ z.gs(èè€ذKذK A¸Q¸]‌کQ™œ¸]¸]¸]¸]ذKذKrrér r')عreعmatchعtupleعgroup)rعversionعms rr,z)MySQLDialect_mysqldb._parse_dbapi_versiondsN€فŒHذ0°'ر:ش:ˆطً فذKذK¨¯ھ°°A°qر)9ش)9ذKرKشKرKشKذKàگ9rcَx— td¦«j}|j|_dS#tt f$rYdSwxYw)NzMySQLdb.cursorsTF)ع __import__عcursorsعSSCursorع _sscursorعImportErrorعAttributeError)rr@s rعsupports_server_side_cursorsz1MySQLDialect_mysqldb.supports_server_side_cursorsksN€ً ف ذ!2ر3ش3ش;ˆGط$ش-ˆDŒNطگ4ّف‌^ذ,ً ً ً طگ5گ5ً ّّّs‚ $¤9¸9cَ —td¦«S)NعMySQLdb)r?)عclss rr+zMySQLDialect_mysqldb.dbapits€هک)ر$ش$ذ$rcَb•‡—tt|¦« ¦«ٹˆfd„}|S)Ncَز•—‰پ‰|¦«| ¦«}|پB| ¦«}| d|z¦«| ¦«dSdS)NzSET NAMES %s)عcharacter_set_namerعexecuteعclose)عconnعcharset_namerعsuper_s €rع on_connectz3MySQLDialect_mysqldb.on_connect..on_connect{sjّ€طذ!طگگt‘”گà×2ز2ر4ش4ˆLàذ'طںڑ™œگط—’ک~°ر<ر=ش=ذ=ط—’‘”گگگً(ذ'r)r(r"rQ)rrQrPr/s @€rrQzMySQLDialect_mysqldb.on_connectxsAّّ€فص+¨Tر2ش2×=ز=ر?ش?ˆً ً ً ً ً ًذrcَœ— | d¦«dS#|jj$r#}| ||d¦«rYd}~dS‚d}~wwxYw)NFT)عpingr+عErrorع is_disconnect)rعdbapi_connectionعerrs rعdo_pingzMySQLDialect_mysqldb.do_pingˆss€ً ط×!ز! %ر(ش(ذ(ًگ4ًّ Œzشً ً ً ط×!ز! #ذ'7¸ر>ش>ً طگuگuگuگuگuàًّّّّ ّّّs‚™A¨AءAءANcَH—| ||¦«}|پ ||_dSdSr2)عexecutemanyr)rrع statementع parametersعcontextrs rعdo_executemanyz#MySQLDialect_mysqldb.do_executemany“s3€ط×%ز% i°ر<ش<ˆطذط (ˆGشذذًذrcَ •—|jdkoK| d|j d¦«›d|j d¦«›d‌¦«}|rJt jt jt jd¦«td¬ ¦«¦«d ¦«g}ng}tt|¦« ||¦«S)N)ézshow collation where عCharsetz = 'utf8mb4' and ع Collationz = 'utf8mb4_bin'z'test collated returns'عutf8mb4)عcharsetعutf8mb4_bin)عserver_version_infoعscalarعidentifier_preparerعquoter عcollateعcastعliteral_columnrr(r"ع_check_unicode_returns)rع connectionعhas_utf8mb4_binعadditional_testsr/s €rrmz+MySQLDialect_mysqldb._check_unicode_returnsکsِّ€ً ش2ً6 ٍ ً à×زذًش(×.ز.¨yر9ش9ذ9ذ9طش(×.ز.¨{ر;ش;ذ;ذ;ً ٌ ô ً ًً "ه”ف”Hفش*ذ+DرEشEف Yذ/ر/ش/ٌôً"ٌôً ذذً "ذفص)¨4ر0ش0×GزGطذ(ٌ ô ً rcَ²—|€tddd¬¦«}|jdi|¤ژ}| |j¦«t j|dt¦«t j|dt¦«t j|dt¦«t j|dt¦«t j|d t¦«t j|d t¦«t j|dt¦«t j|dt¦«i}gd ¢}|D]?}||vr9||||dd…<t j||dd…t¦«||=Œ@|r||d<| d d¦«}|j پU t|j jdz¦«j j}||jz}n#t t"f$r d|_YnwxYw||d <g|gS)Nعdbعuserعpasswd)عdatabaseعusernameعpasswordعcompressعconnect_timeoutعread_timeoutع write_timeoutعclient_flagعlocal_infileعuse_unicoderd)عssl_caعssl_keyعssl_certع ssl_capathع ssl_cipheréعsslrz.constants.CLIENTFr)عdictعtranslate_connect_argsعupdateعqueryrعcoerce_kw_typeعboolr3عstrعgetr+r?rع constantsعCLIENTع FOUND_ROWSrDrCعsupports_sane_rowcount) rعurlع_translate_argsعoptsr…عkeysعkeyr|عCLIENT_FLAGSs rعcreate_connect_argsz(MySQLDialect_mysqldb.create_connect_args¶s€طذ"ف"ط¨¸ًٌôˆOً*ˆsش)ذ<ذ<¨Oذ<ذ<ˆطڈٹگC”IرشذهشکD *dر3ش3ذ3فشکDذ"3µSر9ش9ذ9فشکD .µ#ر6ش6ذ6فشکD /µ3ر7ش7ذ7فشکD -µر5ش5ذ5فشکD .µ#ر6ش6ذ6ُ شکD -µر6ش6ذ6فشکD )Sر1ش1ذ1ً ˆطLذLذLˆطً ً ˆCطگdˆ{ˆ{ط# CœyگگCککک”G‘فش# C¨¨Q¨R¨R¬µ#ر6ش6ذ6طکگIّطً طˆDگ‰Kً—h’hک}¨aر0ش0ˆطŒ:ذ!ً 4ف)ط”Jش'ذ*=ر=ٌ ô نœFًًک|ش6ر6گگّف"¥Kذ0ً 4ً 4ً 4ط.3گش+ذ+ذ+ً 4ّّّà"-ˆDگرطگDˆzذsئ0F2ئ2G اG cَ—|jdS)Nr)عargs)rع exceptions rع_extract_error_codez(MySQLDialect_mysqldb._extract_error_codeوs€طŒ~کaش ذ rcَz— |jj}|¦«S#t$rtjd¦«YdSwxYw)z:Sniff out the character set in use for connection results.zچNo 'character_set_name' can be detected with this MySQL-Python version; please upgrade to a recent version of MySQL-Python. Assuming latin1.عlatin1)rnrKrDrعwarn)rrnع cset_names rع_detect_charsetz$MySQLDialect_mysqldb._detect_charsetésa€ً ً#ش-ش@ˆIًگ9‘;”;ذًُّ ً ً فŒIً#ٌ ô ً ًگ8گ8ً ّّّs‚ک:¹:)عSERIALIZABLEzREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READع AUTOCOMMITcَ¾•—|dkr| d¦«dS| d¦«tt|¦« ||¦«dS)Nr£TF)ع autocommitr(r"ع_set_isolation_level)rrnعlevelr/s €rr¦z)MySQLDialect_mysqldb._set_isolation_levelsnّ€طگLز ذ ط×!ز! $ر'ش'ذ'ذ'ذ'à×!ز! %ر(ش(ذ(فص&¨ر-ش-×BزBطکEٌ ô ً ً ً r)Fr2)"rrrعdriverعsupports_unicode_statementsr‘عsupports_sane_multi_rowcountعsupports_native_decimalعdefault_paramstyler عexecution_ctx_clsrعstatement_compilerr عpreparerr)r,rعlanghelpersعmemoized_propertyrEعclassmethodr+rQrXr^rmrکrœr،عsetع_isolation_lookupr¦ع __classcell__)r/s@rr"r"Nsپّ€€€€€ط €Fط"&ذط!ذط#'ذ à"ذà!ذط5ذط.ذط.€Hً ً ً ً ً ً ًًًً شش'ًًٌ(ش'ًًً%ً%ٌ„[ً%ًًًًًً ً ً ً)ً)ً)ً)ً ً ً ً ً ً<.ً.ً.ً.ً`!ً!ً!ًًًً$کً ً ً ٌôذًًًًًًًًًrr")ع__doc__r8عbaserrrrrعr rr rr r"عdialectrrrْr؛sWًً(ً(ًT € € € àذذذذذطذذذذذط'ذ'ذ'ذ'ذ'ذ'ط)ذ)ذ)ذ)ذ)ذ)طذذذذذطذذذذذطذذذذذً(ً(ً(ً(ً(ذ$9ٌ(ô(ً(ً ً ً ً ً کMٌ ô ً ً ً ً ً ً ذ&=ٌ ô ً ً~ً~ً~ً~ً~ک<ٌ~ô~ً~ًB€€€r