ó i4Vdc@sddlmZddlZddlZddlmZddlmZmZddl m Z ddl m Z ddl mZddlmZmZddlmZmZdd lmZmZmZdd lmZyddlZWnek rÿdZnXd efd „ƒYZdS( iÿÿÿÿ(tunicode_literalsN(tsettings(t FieldErrortImproperlyConfigured(tutils(tBaseDatabaseOperations(t aggregatestfields(tsixttimezone(t parse_datetparse_datetimet parse_time(tduration_stringtDatabaseOperationscBseZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Z d „Z d „Z d „Zd „Zd„Zd„Zd„Zed„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z RS(cCsHt|ƒdkrdnd}t|ƒdkr>|t|ƒSt|ƒS(u SQLite has a compile-time default (SQLITE_LIMIT_VARIABLE_NUMBER) of 999 variables per query. If there is just single field to insert, then we can hit another limit, SQLITE_MAX_COMPOUND_SELECT which defaults to 500. iiçiôi(tlen(tselfRtobjstlimit((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytbulk_batch_sizescCs¢tjtjtjf}tjtjtjtjf}t ||ƒržxV|j ƒD]E}y+|j }t ||ƒr‚t dƒ‚nWqRt k r–qRXqRWndS(Nu{You cannot use Sum, Avg, StdDev, and Variance aggregations on date/time fields in sqlite3 since date/time is saved as text.(Rt DateFieldt DateTimeFieldt TimeFieldRtSumtAvgtVariancetStdDevt isinstancetget_source_expressionst output_fieldtNotImplementedErrorR(Rt expressiont bad_fieldstbad_aggregatestexprR((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytcheck_expression_support"s  cCsd|jƒ|fS(Nudjango_date_extract('%s', %s)(tlower(Rt lookup_typet field_name((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdate_extract_sql4scCsdt|ƒgfS(Nu'%s'(R (Rt timedelta((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdate_interval_sql;scCs|S(u:Do nothing here, we will handle it in the custom function.((Rtsql((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytformat_for_duration_arithmetic>scCsd|jƒ|fS(Nudjango_date_trunc('%s', %s)(R$(RR%R&((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdate_trunc_sqlBscCs(tjr$tdkr$tdƒ‚ndS(Nu1This query requires pytz, but it isn't installed.(RtUSE_TZtpytztNoneR(R((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyt _require_pytzIscCs|jƒd||gfS(Nu"django_datetime_cast_date(%s, %%s)(R0(RR&ttzname((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdatetime_cast_date_sqlMs cCs'|jƒd|jƒ|f|gfS(Nu&django_datetime_extract('%s', %s, %%s)(R0R$(RR%R&R1((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdatetime_extract_sqlQs cCs'|jƒd|jƒ|f|gfS(Nu$django_datetime_trunc('%s', %s, %%s)(R0R$(RR%R&R1((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdatetime_trunc_sqlWs cCsd|jƒ|fS(Nudjango_time_extract('%s', %s)(R$(RR%R&((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyttime_extract_sql]scCsdS(Nu((R((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytdrop_foreignkey_sqldscCsdS(NuNULL((R((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytpk_default_valuegscCsÇd}t|ƒ|krid}xDtdt|ƒ|ƒD]*}||||!}||j|ƒ7}q7W|Sddjdgt|ƒƒ}|jjjƒ}z|j||ƒjƒSWd|jƒXdS(uV Only for last_executed_query! Don't use this to execute SQL queries! içiuSELECT u, uQUOTE(?)N(( Rtranget%_quote_params_for_last_executed_querytjoint connectiontcursortexecutetfetchonetclose(Rtparamst BATCH_SIZEtresultstindextchunkR*R<((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyR9js  cCs|rwt|ttfƒr-|j|ƒ}nB|jƒ}t|jƒƒ}|j|ƒ}tt||ƒƒ}||S|SdS(N(RtlistttupleR9tkeystvaluestdicttzip(RR<R*R@RGRH((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytlast_executed_query…s cCs*|jdƒr"|jdƒr"|Sd|S(Nu"u"%s"(t startswithtendswith(Rtname((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyt quote_name˜scCsdS(Niÿÿÿÿ((R((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytno_limit_valuescCsNg|D]=}d|jdƒ|jdƒ|j|j|ƒƒf^q}|S(Nu %s %s %s;uDELETEuFROM(t SQL_KEYWORDt SQL_FIELDRO(Rtstylettablest sequencest allow_cascadettableR*((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyt sql_flush sGcCs_|dkrdStj|ƒrRtjrCtj||jjƒ}qRtdƒ‚ntj |ƒS(NuNSQLite backend does not support timezone-aware datetimes when USE_TZ is False.( R/R tis_awareRR-t make_naiveR;t ValueErrorRt text_type(Rtvalue((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytadapt_datetimefield_value­s  cCs;|dkrdStj|ƒr.tdƒ‚ntj|ƒS(Nu5SQLite backend does not support timezone-aware times.(R/R RYR[RR\(RR]((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytadapt_timefield_valueºs  cCsÆtt|ƒj|ƒ}|jjƒ}|dkrF|j|jƒn||dkre|j|jƒn]|dkr„|j|jƒn>|dkr£|j|j ƒn|dkrÂ|j|j ƒn|S(Nu DateTimeFieldu DateFieldu TimeFieldu DecimalFieldu UUIDField( tsuperRtget_db_convertersRtget_internal_typetappendtconvert_datetimefield_valuetconvert_datefield_valuetconvert_timefield_valuetconvert_decimalfield_valuetconvert_uuidfield_value(RRt converterst internal_type((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRaÄs     cCsX|dk rTt|tjƒs-t|ƒ}ntjrTtj||jjƒ}qTn|S(N( R/RtdatetimeR RR-R t make_awareR;(RR]RR;tcontext((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRdÓs   cCs4|dk r0t|tjƒs0t|ƒ}q0n|S(N(R/RRktdateR (RR]RR;Rm((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyReÛs cCs4|dk r0t|tjƒs0t|ƒ}q0n|S(N(R/RRkttimeR (RR]RR;Rm((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRfás cCs4|dk r0|jj|ƒ}tj|ƒ}n|S(N(R/Rt format_numbert backend_utilsttypecast_decimal(RR]RR;Rm((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRgçs cCs"|dk rtj|ƒ}n|S(N(R/tuuidtUUID(RR]RR;Rm((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRhís cCsdjd„|DƒƒS(Nu UNION ALL css"|]}ddj|ƒVqdS(u SELECT %su, N(R:(t.0trow((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pys ôs(R:(RRtplaceholder_rows((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytbulk_insert_sqlòscCs6|dkrddj|ƒStt|ƒj||ƒS(Nu^udjango_power(%s)u,(R:R`Rtcombine_expression(Rt connectortsub_expressions((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRyøs cCse|d kr"tjd|ƒ‚nd|g|}t|ƒdkrTtdƒ‚nddj|ƒS( Nu+u-u$Invalid connector for timedelta: %s.u'%s'iu)Too many params for timedelta operations.udjango_format_dtdelta(%s)u, (u+u-(Rt DatabaseErrorRR[R:(RRzR{t fn_params((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytcombine_duration_expressionÿs  cCsdS(N(NN(R/(RRj((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pytinteger_field_ranges(!t__name__t __module__RR#R'R)R+R,R0R2R3R4R5R6R7R9RKRORPtFalseRXR^R_RaRdReRfRgRhRxRyR~R(((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyRs<                         (t __future__RRkRst django.confRtdjango.core.exceptionsRRt django.dbRtdjango.db.backendsRqt"django.db.backends.base.operationsRtdjango.db.modelsRRt django.utilsRR tdjango.utils.dateparseR R R tdjango.utils.durationR R.t ImportErrorR/R(((ss/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/sqlite3/operations.pyts