XZ@sddlZddlZddlZddlmZddlmZddlmZddl m Z ddl m Z m Z ddlmZddlmZdd lmZGd d d eZdS) N) import_module)settings)ImproperlyConfigured)utils)sixtimezone)parse_duration)RemovedInDjango20Warning) force_textc@sleZdZdZdZidd6dd6dd 6dd 6dd6ZddZddZddZddZ ddZ ddZ ddZ ddZ dd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-d.Zd/d0Zd1d2Zd3d4Zd5d6d7Zd8d9Zd:d;Zd<d=Zd>d?d@ZdAdBZdCdDZdEdFZ dGdHZ!dIdJZ"dKdLZ#dMdNZ$dOdPZ%dQdRZ&dSdTZ'dUdVZ(dWdXZ)dYdZZ*d[d\Z+d]d^Z,d5d_d`Z-dadbZ.dcddZ/dedfZ0dgdhdiZ1d5djdkZ2dldmZ3e3Z4dndoZ5dpdqZ6drdsZ7dtduZ8dvdwZ9d>d>dxdyZ:dzd{Z;d|d}Z<d~dZ=ddZ>ddZ?ddZ@ddZAddZBddZCddZDddZEddZFddZGd>S)BaseDatabaseOperationsz This class encapsulates all backend-specific differences, such as the way a backend performs ordering or calculates the ID of a recently-inserted row. zdjango.db.models.sql.compileriZSmallIntegerFieldlZ IntegerFieldlZBigIntegerFieldrZPositiveSmallIntegerFieldZPositiveIntegerFieldcCs||_d|_dS)N) connection_cache)selfrrP/home/ubuntu/projects/ifolica/build/django/django/db/backends/base/operations.py__init__!s zBaseDatabaseOperations.__init__cCsdS)z Returns 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. Nr)rtablecolumnrrr autoinc_sql%sz"BaseDatabaseOperations.autoinc_sqlcCs t|S)z Returns 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)rfieldsobjsrrrbulk_batch_size.sz&BaseDatabaseOperations.bulk_batch_sizecCsdS)z Returns 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. z>SELECT cache_key FROM %s ORDER BY cache_key LIMIT 1 OFFSET %%sr)rrrrcache_key_culling_sql6sz,BaseDatabaseOperations.cache_key_culling_sqlcCsdS)z Given a field instance, returns the SQL necessary to cast the result of a union to that type. Note that the resulting string should contain a '%s' placeholder for the expression being cast. z%sr)rZ output_fieldrrrunification_cast_sql@sz+BaseDatabaseOperations.unification_cast_sqlcCstddS)z Given a lookup_type of 'year', 'month' or 'day', returns the SQL that extracts a value from the given date field field_name. zLsubclasses of BaseDatabaseOperations may require a date_extract_sql() methodN)NotImplementedError)r lookup_type field_namerrrdate_extract_sqlHsz'BaseDatabaseOperations.date_extract_sqlcCstddS)zL Implements the date interval functionality for expressions zMsubclasses of BaseDatabaseOperations may require a date_interval_sql() methodN)r)r timedeltarrrdate_interval_sqlOsz(BaseDatabaseOperations.date_interval_sqlcCstddS)z Given a lookup_type of 'year', 'month' or 'day', returns the SQL that truncates the given date field field_name to a date object with only the given specificity. zIsubclasses of BaseDatabaseOperations may require a datetrunc_sql() methodN)r)rrr rrrdate_trunc_sqlUsz%BaseDatabaseOperations.date_trunc_sqlcCstddS)zS Returns the SQL necessary to cast a datetime value to date value. zNsubclasses of BaseDatabaseOperations may require a datetime_cast_date() methodN)r)rr tznamerrrdatetime_cast_date_sql]sz-BaseDatabaseOperations.datetime_cast_date_sqlcCstddS)z Given a lookup_type of 'year', 'month', 'day', 'hour', 'minute' or 'second', returns the SQL that extracts a value from the given datetime field field_name, and a tuple of parameters. zPsubclasses of BaseDatabaseOperations may require a datetime_extract_sql() methodN)r)rrr r%rrrdatetime_extract_sqlcsz+BaseDatabaseOperations.datetime_extract_sqlcCstddS)a  Given a lookup_type of 'year', 'month', 'day', 'hour', 'minute' or 'second', returns the SQL that truncates the given datetime field field_name to a datetime object with only the given specificity, and a tuple of parameters. zNsubclasses of BaseDatabaseOperations may require a datetime_trunk_sql() methodN)r)rrr r%rrrdatetime_trunc_sqlksz)BaseDatabaseOperations.datetime_trunc_sqlcCs|j||S)z Given a lookup_type of 'hour', 'minute' or 'second', returns the SQL that extracts a value from the given time field field_name. )r!)rrr rrrtime_extract_sqltsz'BaseDatabaseOperations.time_extract_sqlcCsdS)z~ Returns the SQL necessary to make a constraint "initially deferred" during a CREATE TABLE statement. r)rrrrdeferrable_sql{sz%BaseDatabaseOperations.deferrable_sqlcCs|rtdndSdS)z Returns an SQL DISTINCT clause which removes duplicate rows from the result set. If any fields are given, only the given fields are being checked for duplicates. zBaseDatabaseOperations.last_executed_query..to_unicodec3s|]}|VqdS)Nr).0val)r9rr sz=BaseDatabaseOperations.last_executed_query..Ncs+i|]!\}}||qSrr)r:kv)r9rr s z>BaseDatabaseOperations.last_executed_query..zQUERY = %r - PARAMS = %r) isinstancelisttupleitemsr text_type)rr/sqlparamsZu_paramsr)r9rlast_executed_querys "  z*BaseDatabaseOperations.last_executed_querycCs|jS)a  Given a cursor object that has just performed an INSERT statement into a table that has an auto-incrementing ID, returns the newly created ID. This method also receives the table name and the name of the primary-key column. )Z lastrowid)rr/Z table_nameZpk_namerrrlast_insert_idsz%BaseDatabaseOperations.last_insert_idNcCsdS)z Returns the string to use in a query when performing lookups ("contains", "like", etc.). The resulting string should contain a '%s' placeholder for the column being searched against. z%sr)rrr1rrr lookup_castsz"BaseDatabaseOperations.lookup_castcCsdS)z Returns 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)rrrrmax_in_list_sizesz'BaseDatabaseOperations.max_in_list_sizecCsdS)zm Returns the maximum length of table and column names, or None if there is no limit. Nr)rrrrmax_name_lengthsz&BaseDatabaseOperations.max_name_lengthcCstddS)z Returns the value to use for the LIMIT when we are wanting "LIMIT infinity". Returns None if the limit clause can be omitted in this case. zJsubclasses of BaseDatabaseOperations may require a no_limit_value() methodN)r)rrrrno_limit_valuesz%BaseDatabaseOperations.no_limit_valuecCsdS)z Returns the value to use during an INSERT statement to specify that the field should use its default value. DEFAULTr)rrrrpk_default_valuesz'BaseDatabaseOperations.pk_default_valuec sUyddlWntk r0tdYn!Xfddj|DSdS)ai Takes an SQL script that may contain multiple lines and returns 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. rNzEsqlparse is required if you don't split your SQL statements manually.cs+g|]!}|rj|ddqS)strip_commentsT)format)r: statement)sqlparserr s z=BaseDatabaseOperations.prepare_sql_script..)rR ImportErrorrsplit)rrEr)rRrprepare_sql_script s  z)BaseDatabaseOperations.prepare_sql_scriptcCs|S)z Returns the value of a CLOB column, for backends that return a locator object that requires additional processing. r)rvaluerrr process_clobsz#BaseDatabaseOperations.process_clobcCsdS)a For backends that support returning the last insert ID as part of an insert query, this method returns the SQL and params to append to the INSERT query. The returned fragment should contain a format string to hold the appropriate column. Nr)rrrrreturn_insert_id$sz'BaseDatabaseOperations.return_insert_idcCs4|jdkr$t|j|_nt|j|S)z Returns the SQLCompiler class corresponding to the given name, in the namespace corresponding to the `compiler_module` attribute on this backend. N)rrcompiler_modulegetattr)rZ compiler_namerrrcompiler-szBaseDatabaseOperations.compilercCstddS)z Returns a quoted version of the given table, index or column name. Does not quote the given name if it's already been quoted. zFsubclasses of BaseDatabaseOperations may require a quote_name() methodN)r)rnamerrr quote_name7sz!BaseDatabaseOperations.quote_namecCsdS)zH Returns an SQL expression that returns a random value. zRANDOM()r)rrrrrandom_function_sql>sz*BaseDatabaseOperations.random_function_sqlcCstddS)an Returns the string to use in a query when performing regular expression lookups (using "regex" or "iregex"). The resulting string should contain a '%s' placeholder for the column being searched against. If the feature is not supported (or part of it is not supported), a NotImplementedError exception can be raised. zHsubclasses of BaseDatabaseOperations may require a regex_lookup() methodN)r)rrrrr regex_lookupDs z#BaseDatabaseOperations.regex_lookupcCsd|j|S)z Returns 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 %s)r^)rsidrrrsavepoint_create_sqlOsz+BaseDatabaseOperations.savepoint_create_sqlcCsd|j|S)zE Returns the SQL for committing the given savepoint. zRELEASE SAVEPOINT %s)r^)rrarrrsavepoint_commit_sqlWsz+BaseDatabaseOperations.savepoint_commit_sqlcCsd|j|S)zG Returns the SQL for rolling back the given savepoint. zROLLBACK TO SAVEPOINT %s)r^)rrarrrsavepoint_rollback_sql]sz-BaseDatabaseOperations.savepoint_rollback_sqlcCsdS)z Returns the SQL that will set the connection's time zone. Returns '' if the backend doesn't support time zones. r*r)rrrrset_time_zone_sqlcsz(BaseDatabaseOperations.set_time_zone_sqlcCstddS)a Returns a list of SQL statements required to remove all data from the given database tables (without actually removing the tables themselves). The returned value also includes SQL statements required to reset DB sequences passed in :param sequences:. The `style` argument is a Style object as returned by either color_style() or no_style() in django.core.management.color. The `allow_cascade` argument determines whether truncation may cascade to tables with foreign keys pointing the tables being truncated. PostgreSQL requires a cascade even if these tables are empty. zGsubclasses of BaseDatabaseOperations must provide an sql_flush() methodN)r)rstyleZtables sequencesZ allow_cascaderrr sql_flushksz BaseDatabaseOperations.sql_flushcCsgS)a Returns a list of the SQL statements required to reset sequences passed in :param sequences:. The `style` argument is a Style object as returned by either color_style() or no_style() in django.core.management.color. r)rrfrgrrrsequence_reset_by_name_sql}sz1BaseDatabaseOperations.sequence_reset_by_name_sqlcCsgS)z Returns a list of the SQL statements required to reset sequences for the given models. The `style` argument is a Style object as returned by either color_style() or no_style() in django.core.management.color. r)rrfZ model_listrrrsequence_reset_sqlsz)BaseDatabaseOperations.sequence_reset_sqlcCsdS)zL Returns the SQL statement required to start a transaction. zBEGIN;r)rrrrstart_transaction_sqlsz,BaseDatabaseOperations.start_transaction_sqlTcCs|s dSdS)zJ Returns the SQL statement required to end a transaction. z ROLLBACK;zCOMMIT;r)rsuccessrrrend_transaction_sqlsz*BaseDatabaseOperations.end_transaction_sqlcCsdS)a( Returns the SQL that will be used in a query to define the tablespace. Returns '' if the backend doesn't support tablespaces. If inline is True, the SQL is appended to a row; otherwise it's appended to the entire CREATE TABLE or CREATE INDEX statement. r*r)rZ tablespaceinlinerrrtablespace_sqls z%BaseDatabaseOperations.tablespace_sqlcCs.t|jddjddjddS)z)Prepares a value for use in a LIKE query.\z\\%z\%_z\_)r r7)rxrrrprep_for_like_querysz*BaseDatabaseOperations.prep_for_like_querycCs|S)z Certain backends do not accept some values for "serial" fields (for example zero in MySQL). This method will raise a ValueError if the value is invalid, otherwise returns validated value. r)rrWrrrvalidate_autopk_valuesz,BaseDatabaseOperations.validate_autopk_valuecCst|tjr|j|St|tjr>|j|St|tjr]|j|St|tjr||j |S|SdS)a9 Transforms a value to something compatible with the backend driver. This method only depends on the type of the value. It's designed for cases where the target type isn't known, such as .raw() SQL queries. As a consequence it may not work perfectly in all circumstances. N) r@datetimeadapt_datetimefield_valuedateadapt_datefield_valuetimeadapt_timefield_valuedecimalDecimaladapt_decimalfield_value)rrWrrradapt_unknown_values    z*BaseDatabaseOperations.adapt_unknown_valuecCs|dkrdStj|S)z Transforms a date value to an object compatible with what is expected by the backend driver for date columns. N)rrD)rrWrrrrys z,BaseDatabaseOperations.adapt_datefield_valuecCs|dkrdStj|S)z Transforms a datetime value to an object compatible with what is expected by the backend driver for datetime columns. N)rrD)rrWrrrrws z0BaseDatabaseOperations.adapt_datetimefield_valuecCs;|dkrdStj|r.tdntj|S)z Transforms a time value to an object compatible with what is expected by the backend driver for time columns. Nz-Django does not support timezone-aware times.)rZis_aware ValueErrorrrD)rrWrrrr{s  z,BaseDatabaseOperations.adapt_timefield_valuecCstj|||S)z Transforms a decimal.Decimal value to an object compatible with what is expected by the backend driver for decimal (numeric) columns. )rZ format_number)rrWZ max_digitsZdecimal_placesrrrr~sz/BaseDatabaseOperations.adapt_decimalfield_valuecCs |p dS)z| Transforms a string representation of an IP address into the expected type for the backend driver. Nr)rrWrrradapt_ipaddressfield_valuesz1BaseDatabaseOperations.adapt_ipaddressfield_valuecCsRtj|dd}tj|dd}|j|}|j|}||gS)z Returns a two-elements list with the lower and upper bound to be used with a BETWEEN operator to query a DateField value using a year lookup. `value` is an int, containing the looked-up year.  )rvrxry)rrWfirstsecondrrr!year_lookup_bounds_for_date_fields z8BaseDatabaseOperations.year_lookup_bounds_for_date_fieldcCstj|dd}tj|dddddd}tjrrtj}tj||}tj||}n|j|}|j|}||gS)z Returns 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. rrr;i?B)rvrZUSE_TZrZget_current_timezoneZ make_awarerw)rrWrrtzrrr%year_lookup_bounds_for_datetime_fields!  zs