o iL$@sddlZddlmZddlZddlZddlZddlmZddl m Z m Z ddl m Z ddlmZddlmZmZmZddlmZdd lmZdd lmZGd d d e ZdS) Ncount)settings) BaseCommand CommandError)DEFAULT_DB_ALIAS)TEST_DATABASE_PREFIX)SQLITE_ENGINESPOSTGRESQL_ENGINES MYSQL_ENGINES)parse_mysql_cnf) signalcommand)RemovedInNextVersionWarningcs,eZdZdZfddZeddZZS)Commandz%Drops test database for this project.cst||jddddddd|jdd d d dd d|jd dd dddd|jddd dddd|jddd dtdd|jdtdtddS)Nz --noinputz --no-input store_false interactiveTz:Tells Django to NOT prompt the user for input of any kind.)actiondestdefaulthelpz-Uz--userstoreuserz=Use another user for the database then defined in settings.pyz-Pz --passwordpasswordzAUse another password for the database then defined in settings.pyz-Dz--dbnamedbnamez5Use another database name then defined in settings.pyz-Rz--routerrouterz:Use this router-database other then defined in settings.pyz --databasezGNominates a database to run command for. Defaults to the "%s" database.)rr)super add_arguments add_argumentr)selfparser __class__x/var/www/html/formularioweb/env/lib/python3.10/site-packages/django_extensions/management/commands/drop_test_database.pyrs`  zCommand.add_argumentsc s|d}|dtkrtjdtdd|d}tj|}|dur&td||d}d }}}} |d krBt|\}}}} |d pL|d pL|}|d pW|dpW|}z|ddWn t ykdYnwdur{t |dpy|ddusd krtd|dp|}|dp| } |d} |drt dj d} nd} | dkrt ddSfdd} |tvrtd|dd} z| | D]}tj|sn td |t|qWn tyYdSw|tvrNd!dl}||d"}|d#r ||d$<n||d%<| rt| |d&<|jd5i|}|}| d'j D]%}d(|}||}|d)kr9nd*|}td+|d,||q'n|tvrtj d-}|rad!dl!}nd!dl"}dd.i}|rp||d <|rw||d <|r~||d%<| r| |d&<|jd5i|}|rd/|_#n|$d!|}| d'j D]H}d0|}z#|||j%d)krWn4d1|}td+|d,||Wq|j&y}zt'd2t(|WYd}~dSd}~wwntd3|| dks|drt d4dSdS)6z$Drop test database for this project.databaserz2--router is deprecated. You should use --database.) stacklevelNzUnknown database %sENGINEmysqlrUSERrPASSWORDTESTNAMErz?You need to specify DATABASE_NAME in your Django settings file.HOSTPORT verbosityraG You have requested to drop all test databases. This will IRREVERSIBLY DESTROY ALL data in the database "{db_name}" and all cloned test databases generated via the "--parallel" flag (these are sequentially named "{db_name}_1", "{db_name}_2", etc.). Are you sure you want to do this? Type 'yes' to continue, or 'no' to cancel: )db_nameyeszReset cancelled.c3s*VfddtdDEdHdS)a} Return a generator of all possible test database names. e.g., 'test_foo', 'test_foo_1', test_foo_2', etc. formatter: func returning a clone db name given the primary db name and the clone's number, e.g., 'test_foo_1' for mysql/postgres, and 'test_foo_1..sqlite3' for sqlite (re: double dots, see comments). c3s|]}|VqdS)Nr").0n) database_name formatterr"r# sz=Command.handle..get_database_names..Nrr6r5r9r#get_database_namess "z*Command.handle..get_database_nameszUnlinking %s databasescSstj|\}}d|||S)Nz{}_{}.{})ospathsplitextformat)namenumberfilenameextr"r"r#format_filenamesz'Command.handle..format_filenamezUnlinking database named "%s"r)rpasswd/ unix_sockethostportz{}_{}zKSELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='%s';r8zDROP DATABASE IF EXISTS `%s`z Executing: ""psycopg template1Tz>SELECT datname FROM pg_catalog.pg_database WHERE datname='%s';zDROP DATABASE IF EXISTS "%s";z Error: %szUnknown database engine %szReset successful.r"))rwarningswarnrr DATABASESgetrr KeyErrorrinputr?printr logginginfor<r=isfileunlinkOSErrorr MySQLdb startswithintconnectcursorexecuter importlibutil find_specrKpsycopg2 autocommitset_isolation_levelrowcountProgrammingError exceptionstr)rargsoptionsr$dbinfoenginerr database_host database_portr0confirmr;rDr1Databasekwargs connectionr] exists_query row_count drop_query has_psycopg3 conn_paramser"r:r#handleJs                            zCommand.handle)__name__ __module__ __qualname__rrr ry __classcell__r"r"r r#rs  4r)importlib.utilr_ itertoolsrr<rTrM django.confrdjango.core.management.baserr django.dbr django.db.backends.base.creationrdjango_extensions.settingsr r r "django_extensions.management.mysqlr "django_extensions.management.utilsr #django_extensions.utils.deprecationrrr"r"r"r#s