î à^Q\“ ã@shddlZddlZddlmZddlmZmZddlmZGdd„deƒZ dS)éN)Úsettings)Ú BaseCommandÚ CommandError)Ú signalcommandcsFeZdZdZdZdZ‡fdd†Zedd„ƒZ‡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 -WFTc sjtt|ƒj|ƒ|jdddddddddd ƒ|jd d dd dd ddddƒdS)Nz-Rz--routerÚactionÚstoreÚdestÚrouterÚdefaultÚhelpz:Use this router-database other then defined in settings.pyz-Dz--dropÚ store_trueÚdropFzCIf given, includes commands to drop any existing user and database.)ÚsuperrÚ add_argumentsÚ add_argument)ÚselfÚparser)Ú __class__©ú`/var/www/dbchiro/venv/build/django-extensions/django_extensions/management/commands/sqlcreate.pyrszCommand.add_argumentsc OsÒ|jdƒ}tjj|ƒ}|dkr@td|ƒ‚n|jdƒjdƒd}|jdƒ}|jdƒ}|jdƒ}|jd ƒ} tjƒ} | s³d } n|d krútjj d ƒt d |ƒt d||| |fƒnÔ|dkry|jdƒr:t d|fƒt d|fƒnt d||fƒt d||fƒt d||fƒnU|dkr˜tjj dƒn6tjj d|ƒt d|ƒt d||fƒdS)Nr zUnknown database router %sZENGINEÚ.éÚUSERZPASSWORDÚNAMEZHOSTÚ localhostZmysqlz³-- 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';Ú postgresqlÚpostgresql_psycopg2rzDROP 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;Zsqlite3zG-- 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éÿÿÿÿ)rr) ÚgetrZ DATABASESrÚsplitÚsocketÚ gethostnameÚsysÚstderrÚwriteÚprint) rÚargsÚoptionsr ZdbinfoZengineZdbuserZdbpassZdbnameZdbhostZdbclientrrrÚhandles<       zCommand.handle) Ú__name__Ú __module__Ú __qualname__r Zrequires_system_checksZcan_import_settingsrrr)rr)rrr s  r) r!r#Z django.confrZdjango.core.management.baserrZ"django_extensions.management.utilsrrrrrrÚs