o uvXj @sLddlZddlZddlmZddlmZmZddlmZGdddeZ dS)N)settings) BaseCommand CommandError) signalcommandcs4eZdZdZdZdZfddZeddZZ S)Commanda$Generates the SQL to create your database for you, as specified in settings.py The envisioned use case is something like this: ./manage.py sqlcreate [--router=] | mysql -u -p ./manage.py sqlcreate [--router=] | psql -U -WFTcs@tt|||jddddddd|jdd d d d d ddS)Nz-Rz--routerstorerouterdefaultz:Use this router-database other then defined in settings.py)actiondestr helpz-Dz--drop store_truedropFzCIf given, includes commands to drop any existing user and database.)superr add_arguments add_argument)selfparser __class__l/var/www/html/myproject/venv/lib/python3.10/site-packages/django_extensions/management/commands/sqlcreate.pyrs   zCommand.add_argumentsc OsT|d}tj|}|durtd||ddd}|d}|d}|d}|d } t} | s:d } |d krVtj d t d |t d||| |fdS|dvr|drlt d|ft d|ft d||ft d||ft d||fdS|dkrtj ddStj d|t d|t d||fdS)NrzUnknown database router %sENGINE.USERPASSWORDNAMEHOST localhostmysqlz-- 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;z=GRANT ALL PRIVILEGES ON %s.* to '%s'@'%s' identified by '%s';) postgresqlpostgresql_psycopg2postgisrzDROP DATABASE IF EXISTS %s;zDROP USER IF EXISTS %s;z5CREATE USER %s WITH ENCRYPTED PASSWORD '%s' CREATEDB;z4CREATE DATABASE %s WITH ENCODING 'UTF-8' OWNER "%s";z*GRANT ALL PRIVILEGES ON DATABASE %s TO %s;sqlite3zG-- manage.py syncdb will automatically create a sqlite3 database file. z6-- Don't know how to handle '%s' falling back to SQL. zCREATE DATABASE %s;z*GRANT ALL PRIVILEGES ON DATABASE %s to %s;) r DATABASESgetrsplitsocket gethostnamesysstderrwriteprint) rargsoptionsrdbinfoenginedbuserdbpassdbnamedbhostdbclientrrrhandle s<          zCommand.handle) __name__ __module__ __qualname__r requires_system_checkscan_import_settingsrrr7 __classcell__rrrrr s  r) r(r* django.confrdjango.core.management.baserr"django_extensions.management.utilsrrrrrrs