ǷiDdZddlZddlZddlZddlmZddlmZmZddl m Z ddl m Z m Z mZddlmZddlmZdd lmZGd d eZdS) z\ reset_db command originally from http://www.djangosnippets.org/snippets/828/ by dnordberg N)settings) BaseCommand CommandError)DEFAULT_DB_ALIAS)SQLITE_ENGINESPOSTGRESQL_ENGINES MYSQL_ENGINES)parse_mysql_cnf) signalcommand)RemovedInNextVersionWarningc8eZdZdZfdZedZxZS)Commandz%Resets the database for this project.cLt||dddddd|dd d d d |d ddddd|dddddd|dddddd|dddddd|dddd td!|d"td#tz$|d%d&d d'd d(dS))Nz --noinputz --no-input store_false interactiveTz:Tells Django to NOT prompt the user for input of any kind.)actiondestdefaulthelpz --no-utf8 store_trueno_utf8_supportFz3Tells Django to not create a UTF-8 charset databasez-Uz--userstoreuserz=Use another user for the database than defined in settings.pyz-Oz--ownerownerz[Use another owner for creating the database than the user defined in settings or via --userz-Pz --passwordpasswordzAUse another password for the database than defined in settings.pyz-Dz--dbnamedbnamez5Use another database name than defined in settings.pyz-Rz--routerrouterz:Use this router-database other than defined in settings.pyz --databasezGNominates a database to run command for. Defaults to the "%s" database.)rrz-cz--close-sessionsclose_sessionszEClose database connections before dropping database (PostgreSQL only))super add_arguments add_argumentr)selfparser __class__s f/srv/django_bis/venv311/lib/python3.11/site-packages/django_extensions/management/commands/reset_db.pyr zCommand.add_argumentss f%%% mM      3DF     (7P      )G'4n      ,wZT      *W8TH      *W8EUM      "2Z]mm      $\@PZ_X      c( |d}|dtkr$tjdtd|d}tj|}|td|z|d}d x}x}x}x} } |d krt|\}}}} } |d p|d p|}|d p|dp|}|dp|} |dp|dp|}|d krtd|dp| } |dp| } |d} |drtd|d} nd} | dkrtddS|tvr= tj d|tj|n#t $rYnwxYw|t"vrddl}||d}| dr| |d<n| |d <| rt)| |d!<|jd4i|}d"|z}|d#rd nd$}d%|d&|}tj d'|||tj d'|||n|t0vrddl}dd(i}|r||d <|r||d <| r| |d <| r| |d!<|jd4i|}|d|}|d)r|d*|z}tj d'| ||n9#|j$r,}tjd+t?|Yd}~nd}~wwxYwd,|z}tj d'| ||n9#|j$r,}tjd+t?|Yd}~nd}~wwxYwd-|z}| r|d.| zz }|d/z }tj r|d0tj zz }n|d1z }tj d'|||ntd2|z| dks|drtd3dSdS)5z Reset the database for this project. Note: Transaction wrappers are in reverse as a work around for autocommit, anybody know how to do this the right way? databaserz2--router is deprecated. You should use --database.) stacklevelNzUnknown database %sENGINEmysqlrUSERrPASSWORDrrNAMEz?You need to specify DATABASE_NAME in your Django settings file.HOSTPORT verbosityrz_ You have requested a database reset. This will IRREVERSIBLY DESTROY ALL data in the database "zQ". Are you sure you want to do this? Type 'yes' to continue, or 'no' to cancel: yeszReset cancelled.zUnlinking %s databaser)rpasswd/ unix_sockethostportzDROP DATABASE IF EXISTS `%s`rzCHARACTER SET utf8zCREATE DATABASE `z` zExecuting... "%s" template1rz SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '%s'; z Error: %szDROP DATABASE "%s";zCREATE DATABASE "%s"z WITH OWNER = "%s" z ENCODING = 'UTF8'z TABLESPACE = %s;;zUnknown database engine %szReset successful.)!rwarningswarnr r DATABASESgetrr inputprintrlogginginfoosunlinkOSErrorr MySQLdb startswithintconnectquerystriprpsycopg2set_isolation_levelcursorexecuteProgrammingError exceptionstrDEFAULT_TABLESPACE)r"argsoptionsr(dbinfoenginerr database_name database_host database_portrr3confirmDatabasekwargs connection drop_query utf8_support create_query conn_paramsrPclose_sessions_queryes r%handlezCommand.handleAs:& 8  0 0 0 MNPkxy z z z zx(H#''11 >4x?@@ @H%%JLLLxL-L-- W  L[\bLcLc IT8]M=v<&**V"4"4<:&L&**Z*@*@LH (D)PVZZ-?-?P= B  `aa a 6**;m  6**;m K( = ! e 3@-- BCCGGG e   $ % % % F ^ # #  4f=== -((((     } $ $ & & & &"F'',, /(5}%%!.v 4!$]!3!3v))33F33J7-GJ!():!;U22AULL8E ||TL L,j 9 9 9   Z ( ( ( L,l ; ; ;   \//11 2 2 2 2 ) ) ) ' ' ' '%{3K +&* F# 3*2 J' 4&3 F# 4&3 F#))88K88J  * *1 - - -&&((F'( ;($ ($$  02F2L2L2N2NOOO;NN#788880;;;%k3q66::::::::;1=@J L,j 9 9 9 7z****, 7 7 7!+s1vv66666666 74mCL @ 7% ?? 0 0L* $ 3h6Q QQ # L,l ; ; ; NN< ( ( ( (;fDEE E >>W]3> % & & & & & >sB)G GGM N%"N  N/O O;"O66O;)__name__ __module__ __qualname__rr r rg __classcell__)r$s@r%rrs` 2D' ' ' ' ' RA'A']A'A'A'A'A'r&r)__doc__rErCr= django.confrdjango.core.management.baserr django.dbrdjango_extensions.settingsrrr "django_extensions.management.mysqlr "django_extensions.management.utilsr #django_extensions.utils.deprecationr rr<r&r%rts   AAAAAAAA&&&&&&XXXXXXXXXX>>>>>><<<<<<KKKKKKn'n'n'n'n'kn'n'n'n'n'r&