kh!dZddlZddlZddlZddlZddlmZddlm Z m Z ddl m Z ddl mZmZmZddlmZddlmZdd lmZGd d e ZdS) z] reset_db command originally from https://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 --databasez>Nominates a database to run command for. Defaults to the "%s".)rrz-cz--close-sessionsclose_sessionszXClose database connections before dropping database (currently works on PostgreSQL only))super add_arguments add_argumentr)selfparser __class__s e/var/www/histauto/venv/lib/python3.11/site-packages/django_extensions/management/commands/reset_db.pyr zCommand.add_argumentss f%%%   M      "F       P       (       T       H       $M      $Q      !3      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!<|jd6i|}d"|z}|d#rd nd$}d%|d&|}tj d'|||tj d'|||n|t0vrt2jd(}|rddl}nddl}dd)i}|r||d <|r||d <| r| |d <| r| |d!<|jd6i|}|rd*|_n|d| }|d+r|d,|z}tj d'| |!|n9#|j"$r,}tj#d-tI|Yd}~nd}~wwxYwd.|z}tj d'| |!|n9#|j"$r,}tj#d-tI|Yd}~nd}~wwxYwd/|z}| r|d0| zz }|d1z }tj%r|d2tj%zz }n|d3z }tj d'||!|ntd4|z| dks|drtd5dSdS)7z 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"psycopg template1Trz 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 startswithintconnectquerystripr importlibutil find_specr:psycopg2 autocommitset_isolation_levelcursorexecuteProgrammingError exceptionstrDEFAULT_TABLESPACE)r"argsoptionsr(dbinfoenginerr database_name database_host database_portrr3confirmDatabasekwargs connection drop_query utf8_support create_query has_psycopg3 conn_paramsrUclose_sessions_queryes r%handlezCommand.handleds+:& 8  0 0 0 MD+     x(H#''11 >4x?@@ @H%%JLLLxL-L-- W  '' JT8]M=v<&**V"4"4<:&L&**Z*@*@LH (D)PVZZ-?-?P= B  Q  6**;m  6**;m K( = ! e!==#  GGG 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 ) ) )$>33I>>L ,*****++++#[1K +&* F# 3*2 J' 4&3 F# 4&3 F#))88K88J 2(, %%..q111&&((F'( ; $ $% 02F2L2L2N2NOOO;NN#788880;;;%k3q66::::::::;/>J L,j 9 9 9 7z****, 7 7 7!+s1vv66666666 72MAL > 5 == 0 0L* $ 3h6Q QQ # L,l ; ; ; NN< ( ( ( (;fDEE E >>W]3> % & & & & & >sB)G GG5N O"N<<OO55 P+?"P&&P+)__name__ __module__ __qualname__rr r rm __classcell__)r$s@r%rrse 2DH H H H H TW'W']W'W'W'W'W'r&r)__doc__importlib.utilrOrFrDr> django.confrdjango.core.management.baserr django.dbrdjango_extensions.settingsrrr "django_extensions.management.mysqlr "django_extensions.management.utilsr #django_extensions.utils.deprecationr rr=r&r%r{s   AAAAAAAA&&&&&&XXXXXXXXXX>>>>>><<<<<<KKKKKKe'e'e'e'e'ke'e'e'e'e'r&