/opt/support/venv/lib/python3.13/site-packages/pymysql/__pycache__
Edit: /opt/support/venv/lib/python3.13/site-packages/pymysql/__pycache__/cursors.cpython-313.pyc (22333B)
i@ S SK r S SKrSSKJr \ R " S\ R
\ R - 5 r " S S5 r " S S5 r " S S
\ \5 r
" S S \5 r " S
S\ \ 5 r g) N )errz|\s*((?:INSERT|REPLACE)\b.+\bVALUES?\s*)(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))(\s*(?:ON DUPLICATE.*)?);?\s*\Zc \ rS rSrSrSrS rS rS rS r S r
S r S
r S r
S rS!S
jrS rS rS"S jrS"S jrS rS rS#S jrS rS"S jrS rS$S jrS rS r S r S r S r S r S r!g)%Cursor z
This is the object used to interact with the database.
Do not create an instance of a Cursor yourself. Call
connections.Connection.cursor().
See `Cursor
`_ in
the specification.
i c Xl SU l S U l SU l SU l SU l S U l S U l S U l g )Nr r )
connection
warning_count description rownumberrowcount arraysize _executed_result_rows)selfr
s A/opt/support/venv/lib/python3.13/site-packages/pymysql/cursors.py__init__Cursor.__init__" sA $
c U R nUc g U R 5 ( a U R 5 ( a M SU l g! SU l f = f)z4
Closing a cursor just exhausts all remaining data.
N)r
nextsetr conns r close Cursor.close- sF < #,,.. ,,.. #DOdDOs +A Ac U $ N r s r __enter__Cursor.__enter__: r c & AU R 5 g r )r )r exc_infos r __exit__Cursor.__exit__= s
r c h U R ( d [ R " S5 eU R $ )Nz
Cursor closed)r
r ProgrammingErrorr! s r _get_dbCursor._get_dbA s$ &&7 7 r c R U R ( d [ R " S5 eg )Nzexecute() first)r r r* r! s r _check_executedCursor._check_executedF s ~~&&'89 9 r c U$ r r r rows r _conv_rowCursor._conv_rowJ
r c gz!Does nothing, required by DB API.Nr r argss r
setinputsizesCursor.setinputsizesM r c gr7 r r8 s r setoutputsizesCursor.setoutputsizesP r< r c U R 5 nU R nUb X2R La gUR ( d gSU l U R 5 UR US9 U R 5 g)zGet the next query set.N
unbufferedT)r+ r has_next
_clear_result next_result_do_get_result)r rB r current_results r _nextsetCursor._nextsetS sg ||~ !^<<%G && J/ r c $ U R S5 $ )NFrH r! s r r Cursor.nextseta s }}U##r c & ^ [ U[ [ 45 ( a [ U4S jU 5 5 $ [ U[ 5 ( a5 UR 5 VVs0 s H u p4UTR U5 _M snn$ TR
U5 $ s snnf )Nc 3 F ># U H nTR U5 v M g 7fr )literal).0argr s r &Cursor._escape_args..f s ;ds c**ds !)
isinstancetuplelistdictitemsrO escape)r r9 r keyvals ` r _escape_argsCursor._escape_argsd st dUDM * *;d;; ;
d
#
#=AZZ\J\zC c**\J J ;;t$ $ Ks B
Nc R U R 5 nUb XR X#5 - nU$ )an
Returns the exact string that would be sent to the database by calling the
execute() method.
:param query: Query to mogrify.
:type query: str
:param args: Parameters used with query. (optional)
:type args: tuple, list or dict
:return: The query with argument binding applied.
:rtype: str
This method follows the extension to the DB API 2.0 followed by Psycopg.
)r+ r\ )r queryr9 r s r mogrifyCursor.mogrifyn s- ||~ - -d 99E r c U R 5 ( a U R 5 ( a M U R X5 nU R U5 nXl U$ )aY Execute a query.
:param query: Query to execute.
:type query: str
:param args: Parameters used with query. (optional)
:type args: tuple, list or dict
:return: Number of affected rows.
:rtype: int
If args is a list or tuple, %s can be used as a placeholder in the query.
If args is a dict, %(name)s can be used as a placeholder in the query.
)r r` _queryr )r r_ r9 results r executeCursor.execute sG llnn llnn U)U#
r c ^ ^ U( d g[ R T5 nU( a UR S5 S- nUR S5 R 5 nUR S5 =( d SnUS S:X a US S
:X d eT R UUUUT R
T R
5 R 5 $ [ UU 4S jU 5 5 T l T R $ ) a Run several data against one query.
:param query: Query to execute.
:type query: str
:param args: Sequence of sequences or mappings. It is used as parameter.
:type args: tuple or list
:return: Number of rows affected, if any.
:rtype: int or None
This method improves performance on multiple-row INSERT and
REPLACE. Otherwise it is equivalent to looping over args with
execute().
Nr r r (r )c 3 H ># U H nTR TU5 v M g 7fr )re )rP rQ r_ r s r rR %Cursor.executemany.. s EDLL 4 4s ")
RE_INSERT_VALUESmatchgrouprstrip_do_execute_manymax_stmt_lengthr+ encodingsumr )r r_ r9 mq_prefixq_values q_postfixs `` r executemanyCursor.executemany s " "5 ) wwqzBHwwqz((*H
(bIA;#%(2,#*= ==(($$ ''
EEE
}} r c U R 5 nU R n[ U[ 5 ( a UR U5 n[ U[ 5 ( a UR U5 n[ U5 n [
U5 nX(" [ U5 U5 - n
[ U
[ 5 ( a U
R US5 n
X-
n Sn U H n X(" X5 - n
[ U
[ 5 ( a U
R US5 n
[ U 5 [ U
5 - [ U5 - S- U: a! XR X- 5 -
n [ U5 n OU S-
n X-
n M XR X- 5 -
n Xl
U $ )Nsurrogateescaper r ,) r+ r\ rT strencode bytearrayiternextlenre r )
r prefixvaluespostfixr9 rt ru r rY sqlvrowsrQ s
r rs Cursor._do_execute_many sH ||~"" fc " "]]8,F gs # # nnX.G Dz VDJ- - a #45A C**A!S!!HHX'893x#a& 3w</!3oE S]33 't HC
S]++
r c ^^ U R 5 mU( aM SU S3mU R SSR UU4S j[ U5 5 5 - 5 U R 5 SR USR [
[ U5 5 Vs/ s H nSX4- PM sn5 5 nU R U5 X@l U$ s snf )a Execute stored procedure procname with args.
:param procname: Name of procedure to execute on server.
:type procname: str
:param args: Sequence of parameters to use with procedure.
:type args: tuple or list
Returns the original args.
Compatibility warning: PEP-249 specifies that any modified
parameters must be returned. This is currently impossible
as they are only available by storing them in a server
variable and then retrieved by a query. Since stored
procedures return zero or more result sets, there is no
reliable way to get at OUT or INOUT parameters via callproc.
The server variables are named @_procname_n, where procname
is the parameter above and n is the position of the parameter
(from zero). Once all result sets generated by the procedure
have been fetched, you can issue a SELECT @_procname_0, ...
query using .execute() to get any OUT or INOUT values.
Compatibility warning: The act of calling a stored procedure
itself creates an empty result set. This appears after any
result sets generated by the procedure. This is non-standard
behavior with respect to the DB-API. Be sure to use nextset()
to advance through all result sets; otherwise you may get
disconnected.
z@_z_%d=%szSET %s,c 3 T ># U H u pTUTR U5 4- v M g 7fr )rY )rP indexrQ r fmts r rR "Cursor.callproc.. s) FU
C5$++c"233os %(z CALL {}({})z@_%s_%d) r+ rc join enumerater formatranger r )r procnamer9 iqr r s @@r callprocCursor.callproc s < ||~ xj'C KK(( FOPTo
LLN HHs4y9IJ9IAi8-/9IJ K
A Ks Cc U R 5 U R b# U R [ U R 5 : a gU R U R nU =R S-
sl U$ )zFetch the next row.Nr r. r r
r r rd s r fetchoneCursor.fetchone sS :: 3tzz?!BDNN+ !
r c U R 5 U R c gU R U=( d U R - nU R U R U n[ U[ U R 5 5 U l U$ )zFetch several rows.r )r. r r
r minr )r sizeendrd s r fetchmanyCursor.fetchmany sc :: nn 67DNNS1 S#djj/2
r c U R 5 U R c / $ U R ( a U R U R S nO U R n[ U R 5 U l U$ )zFetch all the rows.Nr r s r fetchallCursor.fetchall& sV :: I >>ZZ 01FZZF TZZ
r c U R 5 US:X a U R U- nO"US:X a UnO[ R " SU- 5 eSUs=:: a [ U R
5 : d
O [
S5 eX0l g )Nrelativeabsoluteunknown scroll mode %sr z out of range)r. r
r r* r r
IndexError)r valuemoders r scroll
Cursor.scroll2 sm : &A
Z
A&&'?$'FG GQ(TZZ ( ^, ,r c U R 5 nU R 5 UR U5 U R 5 U R $ r r+ rD r_ rF r r r r s r rc
Cursor._query? s: ||~
1
}} r c f SU l S U l SU l SU l S U l S U l S U l g )Nr )r
r r r r lastrowidr r! s r rD Cursor._clear_resultF s5
r c U R 5 nUR =U l nUR U l UR U l UR
U l UR U l UR U l g r )
r+ r
affected_rowsr r r insert_idr r r )r r rd s r rF Cursor._do_get_resultP s^ ||~ $ , v ,,
# 1 1!-- ))[[
r c U $ r r r! s r __iter__Cursor.__iter__[ r$ r c 8 U R 5 nUc [ eU$ r )r
StopIterationr1 s r __next__Cursor.__next__^ s mmo ;
r c x US; a* [ R " S[ SS9 [ [ U5 $ [ U5 e)N)
WarningErrorInterfaceError
DatabaseError DataErrorOperationalErrorIntegrityError
InternalErrorr* NotSupportedErrorz7PyMySQL errors hould be accessed from `pymysql` packagerh )
stacklevel)warningswarnDeprecationWarninggetattrr AttributeError)r names r __getattr__Cursor.__getattr__d sB
MMI"
3% % T""r )
r r r r r
r r r r
r )Fr )r r )"__name__
__module__ __qualname____firstlineno____doc__rt r r r" r' r+ r. r3 r: r> rH r r\ r` re r{ rs r r r r r rc rD rF r r r __static_attributes__r r r r r s O #
:00 $%.0# J [ TU ] 5 / nU R ( aW U R R H7 nUR
nX1; a UR S- U- nUR U5 M9 Xl U( aC U R ( a1 U R Vs/ s H o@R U5 PM snU l g g g s snf )N.) superrF r r fieldsr
table_nameappend_fieldsr r3 )r r fr r __class__s r rF DictCursorMixin._do_get_result s
\\((vv> <<#-4D
d# )
"L djj59ZZ@Z..+Z@DJ !6@s Cc T Uc g U R [ U R U5 5 $ r ) dict_typezipr r1 s r r3 DictCursorMixin._conv_row s$ ;~~c$,, 455r )r r )
r r r r rW r rF r3 r
__classcell__)r s @r r r } s I A 6 6r r c \ rS rSrSrSrg)
DictCursori z.A cursor which returns results as a dictionaryr Nr r r r r r r r r r r s 8r r c ` \ rS rSrSrS rS r\rS rS r S r
S r S r S
r
SS jrSS
jrSrg )SSCursori a
Unbuffered Cursor, mainly useful for queries that return a lot of data,
or for connections to remote servers over a slow network.
Instead of copying every row of data into a buffer, this will fetch
rows as needed. The upside of this is the client uses much less memory,
and rows are returned much faster when traveling over a slow network
or if the result set is very big.
There are limitations, though. The MySQL protocol doesn't support
returning the total number of rows, so the only way to tell how many rows
there are is to iterate over every row returned. Also, it currently isn't
possible to scroll backwards, as only the current row is held in memory.
c U$ r r r1 s r r3 SSCursor._conv_row r5 r c & U R nUc g U R b3 U R UR L a U R R 5 U R 5 ( a U R 5 ( a M S U l g ! S U l f = fr )r
r _finish_unbuffered_queryr r s r r SSCursor.close sm < << # (D LL 1 1 3 #,,.. ,,.. #DOdDOs +B Bc U R 5 nU R 5 UR USS9 U R 5 U R $ NTrA r r s r rc SSCursor._query s? ||~
1
& }} r c U R SS9$ r rK r! s r r SSCursor.nextset s }}}--r c T U R U R R 5 5 $ )zRead next row.)r3 r _read_rowdata_packet_unbufferedr! s r read_nextSSCursor.read_next s ~~dll J J LMMr c U R 5 U R 5 nUc U R R U l gU =R S-
sl U$ )zFetch next row.Nr )r. r r r r
r1 s r r SSCursor.fetchone sG nn ;!% !;!;D !
r c 4 [ U R 5 5 $ )z
Fetch all, as per MySQLdb. Pretty useless for large queries, as
it is buffered. See fetchall_unbuffered(), if you want an unbuffered
generator version of this method.
)rV fetchall_unbufferedr! s r r SSCursor.fetchall s D,,.//r c . [ U R S5 $ )z
Fetch all, implemented as a generator, which isn't to standard,
however, it doesn't make sense to return everything in a list, as that
would use ridiculous memory for large result sets.
N)r r r! s r r SSCursor.fetchall_unbuffered s DMM4((r Nc ( U R 5 Uc U R n/ n[ U5 HY nU R 5 nUc U R R
U l O*UR
U5 U =R S-
sl M[ U( d gU$ )z Fetch many.r r )r. r r r r r r r
)r r r r r2 s r r SSCursor.fetchmany s~ <>>DtA.."C{%)\\%?%?" KK NNa N
r c U R 5 US:X aT US: a [ R " S5 e[ U5 H nU R 5 M U =R
U-
sl g US:X a\ XR
: a [ R " S5 eXR
-
n[ U5 H nU R 5 M Xl g [ R " SU- 5 e)Nr r z0Backwards scrolling not supported by this cursorr r )r. r r r r r
r* )r r r _r s r r SSCursor.scroll s : qy++F 5\ " NNe #N
Z
~~%++F ..(C3Z "N&&'?$'FG Gr )r
r
r r r )r r r r r r3 r __del__rc r r r r r r r r r r r r r sB
# G .N0)(Hr r c \ rS rSrSrSrg) SSDictCursori z;An unbuffered cursor, which returns results as a dictionaryr Nr r r r r r s Er r )
rer rj r compile
IGNORECASEDOTALLro r r r r r r r r r s| ::) MMBII i# i#X 6 609 & 9vHv vHrF?H Fr