a 8¤Xh¦ã@sŒddlZddlZddlZddlmZddlmZddlmZm Z ddl m Z ddl m Z ddlmZddlmZmZmZGd d „d eƒZdS) éN)ÚList)Úsettings)Ú BaseCommandÚ CommandError)ÚDEFAULT_DB_ALIAS)Ú signalcommand)ÚRemovedInNextVersionWarning)ÚSQLITE_ENGINESÚPOSTGRESQL_ENGINESÚ MYSQL_ENGINEScsBeZdZUdZgZeeed<dZ‡fdd„Z e dd„ƒZ ‡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 -WÚrequires_system_checksTcsPtƒ |¡|jddddtdd|jdtdtd |jd d d d ddddS)Nz-Rz--routerÚstoreÚrouterz:Use this router-database other then defined in settings.py)ÚactionÚdestÚdefaultÚhelpz --databasezGNominates a database to run command for. Defaults to the "%s" database.)rrz-Dz--dropÚ store_trueÚdropFzCIf given, includes commands to drop any existing user and database.)ÚsuperÚ add_argumentsÚ add_argumentr)ÚselfÚparser©Ú __class__©út/var/www/viveiro_mudafortebrasil/venv/lib/python3.9/site-packages/django_extensions/management/commands/sqlcreate.pyrs  þþ þzCommand.add_argumentsc Os–|d}|dtkr,tjdtdd|d}tj |¡}|durLtd|ƒ‚| d¡}| d¡}| d ¡}| d ¡}| d ¡} t  ¡} | sŽd } |t vr¤t j   d ¡nî|tvrÚt j   d¡td|ƒtd||| |fƒn¸|tvrf|drtd|fƒ|rtd|fƒ|rN|rNtd||fƒtd||fƒtd||fƒntdƒtd|fƒn,t j   d|¡td|ƒtd||fƒdS)NÚdatabaserz2--router is deprecated. You should use --database.é)Ú stacklevelzUnknown database %sZENGINEÚUSERZPASSWORDÚNAMEZHOSTÚ 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;)rÚwarningsÚwarnrrZ DATABASESÚgetrÚsocketÚ gethostnamer ÚsysÚstderrÚwriter Úprintr ) rÚargsÚoptionsrZdbinfoZengineZdbuserZdbpassZdbnameZdbhostZdbclientrrrÚhandle)sN          ÿ    ÿ zCommand.handle) Ú__name__Ú __module__Ú __qualname__rr rÚstrÚ__annotations__Zcan_import_settingsrrr0Ú __classcell__rrrrr 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 rrrrÚs