ó ¸9—^c@shddlZddlZddlmZddlmZmZddlmZdefd„ƒYZ dS(i˙˙˙˙N(tsettings(t BaseCommandt CommandError(t signalcommandtCommandcBs2eZdZeZeZd„Zed„ƒZ RS(s$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 -Wc Csjtt|ƒj|ƒ|jdddddddddd ƒ|jd d dd dd dtddƒdS(Ns-Rs--routertactiontstoretdesttroutertdefaultthelps:Use this router-database other then defined in settings.pys-Ds--dropt store_truetdropsCIf given, includes commands to drop any existing user and database.(tsuperRt add_argumentst add_argumenttFalse(tselftparser((sQ/tmp/pip-unpacked-wheel-a0M10Y/django_extensions/management/commands/sqlcreate.pyRsc Os›|d}tjj|ƒ}|dkr;td|ƒ‚n|jdƒjdƒd}|jdƒ}|jdƒ}|jdƒ}|jd ƒ} tjƒ} | sŽd } n|d krëtj j d ƒd |GHd||| |fGHnŹ|dkrL|drd|fGHd|fGHnd||fGHd||fGHd||fGHnK|dkrktj j dƒn,tj j d|ƒd|GHd||fGHdS(NRsUnknown database router %stENGINEt.i˙˙˙˙tUSERtPASSWORDtNAMEtHOSTt localhosttmysqlsł-- 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. s7CREATE DATABASE %s CHARACTER SET utf8 COLLATE utf8_bin;s=GRANT ALL PRIVILEGES ON %s.* to '%s'@'%s' identified by '%s';t postgresqltpostgresql_psycopg2tpostgisR sDROP DATABASE IF EXISTS %s;sDROP USER IF EXISTS %s;s5CREATE USER %s WITH ENCRYPTED PASSWORD '%s' CREATEDB;s4CREATE DATABASE %s WITH ENCODING 'UTF-8' OWNER "%s";s*GRANT ALL PRIVILEGES ON DATABASE %s TO %s;tsqlite3sG-- manage.py syncdb will automatically create a sqlite3 database file. s6-- Don't know how to handle '%s' falling back to SQL. sCREATE DATABASE %s;s*GRANT ALL PRIVILEGES ON DATABASE %s to %s;(RRR( Rt DATABASEStgettNoneRtsplittsockett gethostnametsyststderrtwrite( RtargstoptionsRtdbinfotenginetdbusertdbpasstdbnametdbhosttdbclient((sQ/tmp/pip-unpacked-wheel-a0M10Y/django_extensions/management/commands/sqlcreate.pythandle s<            ( t__name__t __module__R Rtrequires_system_checkstTruetcan_import_settingsRRR1(((sQ/tmp/pip-unpacked-wheel-a0M10Y/django_extensions/management/commands/sqlcreate.pyR s  ( R#R%t django.confRtdjango.core.management.baseRRt"django_extensions.management.utilsRR(((sQ/tmp/pip-unpacked-wheel-a0M10Y/django_extensions/management/commands/sqlcreate.pyts