khddlZddlZddlZddlmZddlmZddlmZm Z ddl m Z ddl m Z ddlmZddlmZmZmZGd d eZdS) N)List)settings) BaseCommand CommandError)DEFAULT_DB_ALIAS) signalcommand)RemovedInNextVersionWarning)SQLITE_ENGINESPOSTGRESQL_ENGINES MYSQL_ENGINEScXeZdZUdZgZeeed<dZfdZ e dZ xZ S)Commanda0Generates the SQL to create your database for you, as specified in settings.py The envisioned use case is something like this: ./manage.py sqlcreate [--database=] | mysql -u -p ./manage.py sqlcreate [--database=] | psql -U -W requires_system_checksTc t||ddddtd|dtdtz |d d d d dddS)Nz-Rz--routerstorerouterz:Use this router-database other then defined in settings.py)actiondestdefaulthelpz --databasezGNominates a database to run command for. Defaults to the "%s" database.)rrz-Dz--drop store_truedropFzCIf given, includes commands to drop any existing user and database.)super add_arguments add_argumentr)selfparser __class__s f/var/www/histauto/venv/lib/python3.11/site-packages/django_extensions/management/commands/sqlcreate.pyrzCommand.add_argumentss f%%%  $M      $1        V      c |d}|dtkr$tjdtd|d}tj|}|td|z|d}|d}|d }|d }|d } tj } | sd } |tvr!tj d dS|tvrOtj dtd|ztd|d|d| d|d dS|t vr|dr(td|d|rtd|d|rF|rDtd|d|dtd|d|dtd|d |ddStd!td|d"dStj d#|ztd$|ztd|d%|ddS)&Ndatabaserz2--router is deprecated. You should use --database.) stacklevelzUnknown database %sENGINEUSERPASSWORDNAMEHOST localhostzH-- manage.py migrate will automatically create a sqlite3 database file. z-- WARNING!: https://docs.djangoproject.com/en/dev/ref/databases/#collation-settings -- Please read this carefully! Collation will be set to utf8_bin to have case-sensitive data. z7CREATE DATABASE %s CHARACTER SET utf8 COLLATE utf8_bin;zGRANT ALL PRIVILEGES ON z.* to 'z'@'z' identified by 'z';rzDROP DATABASE IF EXISTS ;zDROP USER IF EXISTS z CREATE USER z WITH ENCRYPTED PASSWORD 'z ' CREATEDB;zCREATE DATABASE z WITH ENCODING 'UTF-8' OWNER "z";z!GRANT ALL PRIVILEGES ON DATABASE z TO z-- Assuming that unix domain socket connection mode is being used because -- USER or PASSWORD are blank in Django DATABASES configuration.z WITH ENCODING 'UTF-8';z6-- Don't know how to handle '%s' falling back to SQL. zCREATE DATABASE %s;z to )rwarningswarnr r DATABASESgetrsocket gethostnamer sysstderrwriter printr ) rargsoptionsr"dbinfoenginedbuserdbpassdbnamedbhostdbclients rhandlezCommand.handle7s:& 8  0 0 0 MD+     x(H#''11 >4x?@@ @H%%F##J''F##F##%'' ! F ^ # # J  [     } $ $ J      KfT U U U E66666888VVV5     ) ) )v Avvv?@@@AEvvv?@@@ O& Ovvvvv'vvvvv'ffffffUVVVVVWVVVMNNNNN J  IFR    '&0 1 1 1 E&&&&&&Q R R R R Rr ) __name__ __module__ __qualname__rrrstr__annotations__can_import_settingsrrr? __classcell__)rs@rrrs D)+DI***     8ESES]ESESESESESr r)r0r2r,typingr django.confrdjango.core.management.baserr django.dbr"django_extensions.management.utilsr#django_extensions.utils.deprecationr django_extensions.settingsr r r rr rrOs  AAAAAAAA&&&&&&<<<<<<KKKKKKXXXXXXXXXXmSmSmSmSmSkmSmSmSmSmSr