gvddlZddlZddlZddlZddlmZddlZddlmZddl m Z m Z ddl m Z ddlmZddlmZddlmZdd lmZGd d Zy) N) import_module)settings)NotSupportedError transaction)utilsCol)timezone)RemovedInDjango60Warning force_strc XeZdZdZdZdddddddddd Zd d d d ZiZdZdZ dZ de zZ de zZ dZ dZdZdZdZdZdZdZdZdbdZdZdZdZdZdbdZd Zd!Zd"Zd#Zd$Z d%Z!d&Z"dcd(Z#d)Z$d*Z%d+Z&d,Z'd-Z(dbd.Z)d/Z*d0Z+d1Z,d2Z-d3Z.d4Z/d5Z0d6Z1d7Z2d8Z3d9Z4d:Z5d;Z6d<Z7d'd'd=d>Z8d?Z9d@Z:dAZ;dBZdEZ?e?Z@dFZAdGZBdHZCdIZDdJZEdKZFdfdLZGdMZHdNZIdedOZJdedPZKdQZLdRZMdSZNdTZOdUZPdVZQdWZRdXZSdYZTdZZUd[ZVdfd\ZWdfd]ZXdbd^ZYdbd_ZZd`Z[daZ\y)gBaseDatabaseOperationsz Encapsulate backend-specific differences, such as the way a backend performs ordering or calculates the ID of a recently-inserted row. zdjango.db.models.sql.compiler)i)i)l)rr)rr)rr) SmallIntegerField IntegerFieldBigIntegerFieldPositiveBigIntegerFieldPositiveSmallIntegerFieldPositiveIntegerFieldSmallAutoField AutoField BigAutoFieldUNION INTERSECTEXCEPT)union intersection differenceN PRECEDING FOLLOWINGz UNBOUNDED z CURRENT ROWc ||_d|_yN) connection_cache)selfr&s z/var/www/python.vincentserveurtest.ovh/public_html/venv/lib/python3.12/site-packages/django/db/backends/base/operations.py__init__zBaseDatabaseOperations.__init__=s$ cy)z Return any SQL needed to support auto-incrementing primary keys, or None if no SQL is necessary. This SQL is executed when a table is created. N)r(tablecolumns r) autoinc_sqlz"BaseDatabaseOperations.autoinc_sqlAsr+ct|S)z Return the maximum allowed batch size for the backend. The fields are the fields going to be inserted in the batch, the objs contains all the objects to be inserted. )len)r(fieldsobjss r)bulk_batch_sizez&BaseDatabaseOperations.bulk_batch_sizeJs 4yr+ctd)Nz[subclasses of BaseDatabaseOperations may require a format_for_duration_arithmetic() method.NotImplementedError)r(sqls r)format_for_duration_arithmeticz5BaseDatabaseOperations.format_for_duration_arithmeticRs! 7  r+c6|jd}d|d|dS)z Return an SQL query that retrieves the first cache key greater than the n smallest. This is used by the 'db' cache backend to determine where to start culling. cache_keyzSELECT z FROM %s ORDER BY z LIMIT 1 OFFSET %%s quote_name)r(r<s r)cache_key_culling_sqlz,BaseDatabaseOperations.cache_key_culling_sqlXs)OOK0  #5i[@STTr+cy)z Given a field instance, return the SQL that casts the result of a union to that type. The resulting string should contain a '%s' placeholder for the expression being cast. %sr-)r( output_fields r)unification_cast_sqlz+BaseDatabaseOperations.unification_cast_sqlc r+ctd)z Given a lookup_type of 'year', 'month', or 'day', return the SQL that extracts a value from the given date field field_name. zLsubclasses of BaseDatabaseOperations may require a date_extract_sql() methodr7r( lookup_typer9paramss r)date_extract_sqlz'BaseDatabaseOperations.date_extract_sqlks "   r+ctd)a. Given a lookup_type of 'year', 'month', or 'day', return the SQL that truncates the given date or datetime field field_name to a date object with only the given specificity. If `tzname` is provided, the given value is truncated in a specific timezone. zKsubclasses of BaseDatabaseOperations may require a date_trunc_sql() method.r7r(rGr9rHtznames r)date_trunc_sqlz%BaseDatabaseOperations.date_trunc_sqlus"   r+ctd)zH Return the SQL to cast a datetime value to date value. zSsubclasses of BaseDatabaseOperations may require a datetime_cast_date_sql() method.r7r(r9rHrLs r)datetime_cast_date_sqlz-BaseDatabaseOperations.datetime_cast_date_sqls" /  r+ctd)zH Return the SQL to cast a datetime value to time value. zRsubclasses of BaseDatabaseOperations may require a datetime_cast_time_sql() methodr7rOs r)datetime_cast_time_sqlz-BaseDatabaseOperations.datetime_cast_time_sqls" .  r+ctd)z Given a lookup_type of 'year', 'month', 'day', 'hour', 'minute', or 'second', return the SQL that extracts a value from the given datetime field field_name. zPsubclasses of BaseDatabaseOperations may require a datetime_extract_sql() methodr7rKs r)datetime_extract_sqlz+BaseDatabaseOperations.datetime_extract_sql "   r+ctd)z Given a lookup_type of 'year', 'month', 'day', 'hour', 'minute', or 'second', return the SQL that truncates the given datetime field field_name to a datetime object with only the given specificity. zNsubclasses of BaseDatabaseOperations may require a datetime_trunc_sql() methodr7rKs r)datetime_trunc_sqlz)BaseDatabaseOperations.datetime_trunc_sqlrUr+ctd)a1 Given a lookup_type of 'hour', 'minute' or 'second', return the SQL that truncates the given time or datetime field field_name to a time object with only the given specificity. If `tzname` is provided, the given value is truncated in a specific timezone. zJsubclasses of BaseDatabaseOperations may require a time_trunc_sql() methodr7rKs r)time_trunc_sqlz%BaseDatabaseOperations.time_trunc_sqls" X  r+c(|j|||S)z Given a lookup_type of 'hour', 'minute', or 'second', return the SQL that extracts a value from the given time field field_name. )rIrFs r)time_extract_sqlz'BaseDatabaseOperations.time_extract_sqls $$[#v>>r+cy)zs Return the SQL to make a constraint "initially deferred" during a CREATE TABLE statement. r-r(s r)deferrable_sqlz%BaseDatabaseOperations.deferrable_sqls r+c&|r tddggfS)z Return an SQL DISTINCT clause which removes duplicate rows from the result set. If any fields are given, only check the given fields for duplicates. zz:BaseDatabaseOperations.limit_offset_sql..s!  szLIMIT %dNz OFFSET %d)rrw)r(rrlimitrs r)limit_offset_sqlz'BaseDatabaseOperations.limit_offset_sql sR55h J vxx ).e#4*0v%d   r+cnd|D}dj|Dcgc]}d|d c}}d|Scc}w)Nc3>K|]}dj|yw)ruNrv)rrows r)rz9BaseDatabaseOperations.bulk_insert_sql..sK:J3 #:Jsru()zVALUES rv)r(r3placeholder_rowsplaceholder_rows_sqlr9 values_sqls r)bulk_insert_sqlz&BaseDatabaseOperations.bulk_insert_sqlsIK:JKYY6JK6Js!C5 6JKL  %% Ls 2cdt|ttfrtfd|D}n4|d}n/|jDcic]\}}||}}}d|d|Scc}}w)a Return a string of the query last executed by the given cursor, with placeholders replaced with actual values. `sql` is the raw query containing placeholders and `params` is the sequence of parameters. These are used by default, but this method exists for database backends to provide a better implementation according to their own quoting schemes. ct|ddS)NTreplace) strings_onlyerrorsr )ss r) to_stringz=BaseDatabaseOperations.last_executed_query..to_string(sQT)D Dr+c3.K|] }|ywr%r-)rvalrs r)rz=BaseDatabaseOperations.last_executed_query..,s>vYs^vsr-zQUERY = z - PARAMS = ) isinstancelisttupleitems)r(rer9rHu_paramskvrs @r)last_executed_queryz*BaseDatabaseOperations.last_executed_querysp E ftUm ,>v>>H ^H?E||~N~tq! ! il2~HN-0(;;OsA,c|jS)z Given a cursor object that has just performed an INSERT statement into a table that has an auto-incrementing ID, return the newly created ID. `pk_name` is the name of the primary-key column. ) lastrowid)r(re table_namepk_names r)last_insert_idz%BaseDatabaseOperations.last_insert_id4sr+cy)z Return the string to use in a query when performing lookups ("contains", "like", etc.). It should contain a '%s' placeholder for the column being searched against. rAr-)r(rGrls r) lookup_castz"BaseDatabaseOperations.lookup_cast=rDr+cy)z Return the maximum number of items that can be passed in a single 'IN' list condition, or None if the backend does not impose a limit. Nr-r^s r)max_in_list_sizez'BaseDatabaseOperations.max_in_list_sizeE r+cy)zl Return the maximum length of table and column names, or None if there is no limit. Nr-r^s r)max_name_lengthz&BaseDatabaseOperations.max_name_lengthLrr+ctd)z Return the value to use for the LIMIT when we are wanting "LIMIT infinity". Return None if the limit clause can be omitted in this case. zJsubclasses of BaseDatabaseOperations may require a no_limit_value() methodr7r^s r)rz%BaseDatabaseOperations.no_limit_valueSs " X  r+cy)z Return the value to use during an INSERT statement to specify that the field should use its default value. DEFAULTr-r^s r)pk_default_valuez'BaseDatabaseOperations.pk_default_value\s r+ctj|Dcgc]}|rtj|dc}Scc}w)ag Take an SQL script that may contain multiple lines and return a list of statements to feed to successive cursor.execute() calls. Since few databases are able to process raw SQL scripts in a single cursor.execute() call and PEP 249 doesn't talk about this use case, the default implementation is conservative. T)strip_comments)sqlparsesplitformat)r(r9 statements r)prepare_sql_scriptz)BaseDatabaseOperations.prepare_sql_scriptcs@&^^C0 0  OOId ;0   s ;c|S)z Return the value of a CLOB column, for backends that return a locator object that requires additional processing. r-r(values r) process_clobz#BaseDatabaseOperations.process_clobrs  r+cy)z For backends that support returning columns as part of an insert query, return the SQL and params to append to the INSERT query. The returned fragment should contain a format string to hold the appropriate column. Nr-)r(r3s r)return_insert_columnsz,BaseDatabaseOperations.return_insert_columnsys r+cz|jt|j|_t|j|S)z Return the SQLCompiler class corresponding to the given name, in the namespace corresponding to the `compiler_module` attribute on this backend. )r'rcompiler_modulegetattr)r( compiler_names r)compilerzBaseDatabaseOperations.compilers1 ;; '(<(<=DKt{{M22r+ctd)z Return a quoted version of the given table, index, or column name. Do not quote the given name if it's already been quoted. zFsubclasses of BaseDatabaseOperations may require a quote_name() methodr7)r(names r)r>z!BaseDatabaseOperations.quote_names " T  r+ctd)aG Return the string to use in a query when performing regular expression lookups (using "regex" or "iregex"). It should contain a '%s' placeholder for the column being searched against. If the feature is not supported (or part of it is not supported), raise NotImplementedError. zHsubclasses of BaseDatabaseOperations may require a regex_lookup() methodr7)r(rGs r) regex_lookupz#BaseDatabaseOperations.regex_lookups" V  r+c*d|j|zS)z Return the SQL for starting a new savepoint. Only required if the "uses_savepoints" feature is True. The "sid" parameter is a string for the savepoint id. z SAVEPOINT %sr=r(sids r)savepoint_create_sqlz+BaseDatabaseOperations.savepoint_create_sqls  444r+c*d|j|zS)zD Return the SQL for committing the given savepoint. zRELEASE SAVEPOINT %sr=rs r)savepoint_commit_sqlz+BaseDatabaseOperations.savepoint_commit_sqls&(<<E]]22 1a""*+FMM%A.E]]5"b1F**51++F3vr+c |r]tjj|dd}tjj|dzddtjdz }n2tj|dd}tj|dddddd}tjr@t j }t j||}t j||}|j|}|j|}||gS)a= Return a two-elements list with the lower and upper bound to be used with a BETWEEN operator to query a DateTimeField value using a year lookup. `value` is an int, containing the looked-up year. If `iso_year` is True, return bounds for ISO-8601 week-numbering years. r ) microsecondsr"r#;i?B) rr$r%rUSE_TZr get_current_timezone make_awarer)r(rr&r'r(tzs r)%year_lookup_bounds_for_datetime_fieldzr?s r)combine_duration_expressionz2BaseDatabaseOperations.combine_duration_expressions&&y/BBr+cy)z~ Some backends require special syntax to insert binary content (MySQL for example uses '_binary %s'). rAr-rs r)binary_placeholder_sqlz-BaseDatabaseOperations.binary_placeholder_sqlrr+c|S)zs Allow modification of insert parameters. Needed for Oracle Spatial backend due to #10888. r-)r( placeholderrHs r)modify_insert_paramsz+BaseDatabaseOperations.modify_insert_paramss  r+c |j|S)z Given an integer field internal type (e.g. 'PositiveIntegerField'), return a tuple of the (min_value, max_value) form representing the range of the column type bound to the field. )integer_field_ranges)r(rls r)integer_field_rangez*BaseDatabaseOperations.integer_field_ranges ((77r+c|jjjr|\}}|\}}d|d|dg||fStd|z)Nrz - rz-This backend does not support %s subtraction.)r&rsupports_temporal_subtractionr)r(rllhsrhslhs_sql lhs_paramsrhs_sql rhs_paramss r)subtract_temporalsz)BaseDatabaseOperations.subtract_temporalssY ?? # # A A"% GZ"% GZ")735Oz5OJ5OO O ;m K  r+ct|trA|dk(r |jS|dkrdt||jfzSd||j fzSy)Nrz%d %s)rint CURRENT_ROWabsr"r#rs r)window_frame_valuez)BaseDatabaseOperations.window_frame_valuesW eS !z'''#e*dnn!===%!888 "r+cjt|tr t|tr||kDr td|t|tstd|d|t|tstd|d|j|xs |j}|j|xs |j }||fS)zU Return SQL for start and end points in an OVER clause window frame. z!start cannot be greater than end.z;start argument must be an integer, zero, or None, but got 'z'.z9end argument must be an integer, zero, or None, but got ')rrVrrYUNBOUNDED_PRECEDINGUNBOUNDED_FOLLOWING)r(startendstart_end_s r)window_frame_rows_start_endz2BaseDatabaseOperations.window_frame_rows_start_ends eS !jc&:us{@A A  Zs%;MeWTVW  ?:c3#7KC5PRS ((/K43K3K&&s+Gt/G/Gt|r+c|t|trt|tr|dkDrtd|z|t|trt|tr|dkrtd|z|j|xs |j}|j|xs |j }|j j}|jr0|r|dks|r'|dkDr"td|j jz||fS)NrzGstart argument must be a negative integer, zero, or None, but got '%s'.zEend argument must be a positive integer, zero, or None, but got '%s'.zA%s only supports UNBOUNDED together with PRECEDING and FOLLOWING.) rrVrrYr[r\r&r4only_supports_unbounded_with_preceding_and_followingr display_name)r(r]r^r_r`rs r)window_frame_range_start_endz3BaseDatabaseOperations.window_frame_range_start_ends  j&< uc "uqy "'(  OJsC$8 sC S1WW ((/K43K3K&&s+Gt/G/G??++  H H uqyccAg##;;< t|r+c |jjjs td|r|jjj}|j }||vrZd|z}|r+|ddj t|zz }t||d|jjdz }t||r4tddj t|jz|jS)Nz9This backend does not support explaining query execution.z%s is not a recognized format.z Allowed formats: %srurz does not support any formats.zUnknown options: %s) r&r#supports_explaining_query_executionrsupported_explain_formatsupperrwsortedrdrkeysexplain_prefix)r(roptionssupported_formatsnormalized_formatmsgs r)explain_query_prefixz+BaseDatabaseOperations.explain_query_prefixs''KK#K   $ 8 8 R R  &   (9969JJ$1DIIfEV>W4XXXC !o%DOO8899WXC!o% 2TYYvglln?U5VVW W"""r+cy)Nz INSERT INTOr-)r( on_conflicts r)insert_statementz'BaseDatabaseOperations.insert_statementsr+cy)Nr]r-)r(r3rs update_fields unique_fieldss r)on_conflict_suffix_sqlz-BaseDatabaseOperations.on_conflict_suffix_sqlsr+c:t||}t||}||fSr%r)r( lhs_table lhs_field rhs_table rhs_fieldlhs_exprrhs_exprs r)prepare_join_on_clausez-BaseDatabaseOperations.prepare_join_on_clause"s%y),y),!!r+r%)FFr-F)T)F)NN)]__name__ __module__ __qualname____doc__rrJ set_operatorscast_data_types"cast_char_field_without_max_lengthr"r#r[r\rWrlr*r0r5r:r?rCrIrMrPrRrTrWrYr[r_rbrgrmrorrr|rrrrrrrrrrrrrrr>rrrrrrrrrrrrrprep_for_iexact_queryrr r rrrrrrr)r2r6r8r:r<rArCrErHrKrTrYrarerqrtrxrr-r+r)rrs 6O -1F#;%/ /).C #MO)-&II&2&2KN U           ? $!     & <0     3   5= A ;@u (( T 0& F.*23  *C8 9$6#*"r+r)rrrri importlibrr django.confr django.dbrrdjango.db.backendsrdjango.db.models.expressionsr django.utilsr django.utils.deprecationr django.utils.encodingr rr-r+r)rs8 # 4$,!=+T "T "r+