3 g@sddlZddlZddlZddlmZddlmZddlmZm Z ddl m Z ddl m Z ddlmZddlmZmZmZGd d d eZdS) N)List)settings) BaseCommand CommandError)DEFAULT_DB_ALIAS) signalcommand)RemovedInNextVersionWarning)SQLITE_ENGINESPOSTGRESQL_ENGINES MYSQL_ENGINEScs>eZdZUdZgZeedZfddZe ddZ 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 [--database=] | mysql -u -p ./manage.py sqlcreate [--database=] | psql -U -WTcsPtj||jddddtdd|jdtdtd |jd d d d ddddS)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__m/var/www/tester-filtro-web/env/lib/python3.6/site-packages/django_extensions/management/commands/sqlcreate.pyrs    zCommand.add_argumentsc Os|d}|dtkr,tjdtdd|d}tjj|}|dkrLtd||jd}|jd}|jd }|jd }|jd } tj } | sd } |t krt j j d n|tkrt j j dtd|td||| |fn|tkrf|drtd|f|rtd|f|rN|rNtd||ftd||ftd||fntdtd|fn,t j j d|td|td||fdS)Ndatabaserz2--router is deprecated. You should use --database.) stacklevelzUnknown database %sZENGINEUSERZPASSWORDNAMEZHOST 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;z=GRANT ALL PRIVILEGES ON %s.* to '%s'@'%s' identified by '%s';rzDROP 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;z-- Assuming that unix domain socket connection mode is being used because -- USER or PASSWORD are blank in Django DATABASES configuration.z)CREATE DATABASE %s WITH ENCODING 'UTF-8';z6-- Don't know how to handle '%s' falling back to SQL. zCREATE DATABASE %s;z*GRANT ALL PRIVILEGES ON DATABASE %s to %s;)rwarningswarnrrZ DATABASESgetrsocket gethostnamer sysstderrwriter printr ) rargsoptionsrZdbinfoZengineZdbuserZdbpassZdbnameZdbhostZdbclientrrrhandle)sL             zCommand.handle) __name__ __module__ __qualname__rZrequires_system_checksrstrZcan_import_settingsrrr. __classcell__rr)rrr s   r )r&r(r#typingrZ django.confrZdjango.core.management.baserrZ django.dbrZ"django_extensions.management.utilsrZ#django_extensions.utils.deprecationrZdjango_extensions.settingsr r r r rrrrs