""" Django settings for BiApi project. Generated by 'django-admin startproject' using Django 4.1.7. For more information on this file, see https://docs.djangoproject.com/en/4.1/topics/settings/ For the full list of settings and their values, see https://docs.djangoproject.com/en/4.1/ref/settings/ """ from pathlib import Path from datetime import timedelta import os import sys # Build paths inside the project like this: BASE_DIR / 'subdir'. BASE_DIR = Path(__file__).resolve().parent.parent # Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/4.1/howto/deployment/checklist/ # SECURITY WARNING: keep the secret key used in production secret! SECRET_KEY = 'zh`7dJ,`3q#,l*"OCOnZfe%q@,6rpxF0+/N!"Ac2\WzG&qefmW' # SECURITY WARNING: don't run with debug turned on in production! #DEBUG = False DEBUG = os.getenv('DJANGO_DEBUG', 'False') == 'True' # Application definition INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', #'django.contrib.sites', 'siimgroup', #API app 'latina', # API app 'manami', # API app 'vivelevin', # API app 'elianeribeiro', # API app 'argo', # API app 'boulevarddosipes', # API app 'incompany', # API app 'rest_framework', # Django REST framework #'corsheaders', # Django CORS headers 'django_filters', # Django filters 'debug_toolbar', # Django debug toolbar 'rest_framework.authtoken', #'crispy_forms', #'crispy_bootstrap5', 'djoser', 'rest_framework_simplejwt', 'rest_framework_simplejwt.token_blacklist', 'schema_graph', 'django_spaghetti', 'drf_yasg', 'rest_framework_swagger', 'compressor', 'log_viewer', 'django_crontab', 'django_extensions', ] MIDDLEWARE = [ #'corsheaders.middleware.CorsMiddleware', 'django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware', ] ROOT_URLCONF = 'core.urls' TEMPLATES = [ { 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, 'OPTIONS': { 'context_processors': [ 'django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', ], }, }, ] ADMIN_INTERFACE_THEME = "admin_interface.themes.AdminTheme" ADMIN_INTERFACE_THEME_COLORS = { "primary": "#FF0000", "secondary": "#FFFFFF", "third": "#0000FF", } # CRISPY_ALLOWED_TEMPLATE_PACKS = "bootstrap5" # CRISPY_TEMPLATE_PACK = "bootstrap5" WSGI_APPLICATION = 'core.wsgi.application' # Database # https://docs.djangoproject.com/en/4.1/ref/settings/#databases # DATABASES = { # 'default': { # 'ENGINE': 'django.db.backends.sqlite3', # 'NAME': BASE_DIR / 'db.sqlite3', # } # } if DEBUG: HOST = '172.17.0.2' PORT = 3307 else: HOST = 'localhost' PORT = 3306 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_core', 'USER': 'bi_core', 'PASSWORD': 'jURn8j2trR', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_elianeribeiro': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_elianeribeiro', 'USER': 'bi_elianeribeiro', 'PASSWORD': 'BFH@g!-7Qj=s', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_argo': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_argo', 'USER': 'bi_argo', 'PASSWORD': 'KSp$fkDo178m', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_boulevarddosipes': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_boulevarddosipes', 'USER': 'bi_boulevarddosipes', 'PASSWORD': '1;Frrgs};Eiz', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_siimgroup': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_siimgroup', 'USER': 'bi_siimgroup', 'PASSWORD': '&v{Fdu0,kA0Q', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_latina': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_latina', 'USER': 'bi_latina', 'PASSWORD': 'PxOIeMbIH{#s', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_manami': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_manami', 'USER': 'bi_manami', 'PASSWORD': 'r{MYtNTY4tGz', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_vivelevin': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_vivelevin', 'USER': 'bi_vivelevin', 'PASSWORD': '=-P=ts%kA82r', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'db_incompany': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_incompany', 'USER': 'bi_incompany', 'PASSWORD': 'uc=-UQvk@b@N', 'HOST': HOST, 'PORT': PORT, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, 'source_db_production': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'pixcrm_dw', 'USER': 'pixcrm_dw_vw', 'PASSWORD': '29V2Rh1vhTIj', 'HOST': 'pixcrm.com.br', 'PORT': 3306, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, } if DEBUG: DATABASES.update({ 'source_db_development': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'bi_elianeribeiro_source', 'USER': 'bi_elianeribeiro_source', 'PASSWORD': 'BFH@g!-7Qj=s', 'HOST': "172.17.0.2", 'PORT': 3307, 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" } }, }) import pymysql pymysql.install_as_MySQLdb() DATABASE_ROUTERS = ['core.routers.AppRouter'] CACHES = { "default": { "BACKEND": "django_redis.cache.RedisCache", "LOCATION": "redis://127.0.0.1:6379/1", "OPTIONS": { "CLIENT_CLASS": "django_redis.client.DefaultClient", } }, "development": { "BACKEND": "django.core.cache.backends.dummy.DummyCache", }, "locmem": { "BACKEND": "django.core.cache.backends.locmem.LocMemCache", "LOCATION": "unique-snowflake", } } LOGGING = { 'version': 1, 'disable_existing_loggers': False, 'handlers': { 'console': { 'class': 'logging.StreamHandler', }, }, 'root': { 'handlers': ['console'], 'level': 'INFO', }, 'loggers': { 'django': { 'handlers': ['console'], 'level': 'INFO', 'propagate': True, }, 'django.request': { 'handlers': ['console'], 'level': 'ERROR', 'propagate': False, }, 'rest_framework': { 'handlers': ['console'], 'level': 'DEBUG', 'propagate': True, }, }, } # Password validation # https://docs.djangoproject.com/en/4.1/ref/settings/#auth-password-validators AUTH_PASSWORD_VALIDATORS = [ { 'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator', }, { 'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator', }, { 'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator', }, { 'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator', }, ] # Internationalization # https://docs.djangoproject.com/en/4.1/topics/i18n/ LANGUAGE_CODE = 'en-us' TIME_ZONE = 'UTC' USE_I18N = True USE_TZ = True # Static files (CSS, JavaScript, Images) # https://docs.djangoproject.com/en/4.1/howto/static-files/ STATICFILES_FINDERS = ( 'django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder', # other finders.. 'compressor.finders.CompressorFinder', ) # Static files (CSS, JavaScript, Images) # https://docs.djangoproject.com/en/4.2/howto/static-files/ if DEBUG: STATICFILES_DIRS = [ os.path.join(BASE_DIR, 'static'), ] STATIC_URL = 'static/' COMPRESS_ROOT = os.path.join(BASE_DIR, 'static') else: STATIC_URL = '/static/' STATIC_ROOT = os.path.join(BASE_DIR, 'static') # Default primary key field type # https://docs.djangoproject.com/en/4.1/ref/settings/#default-auto-field DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField' INTERNAL_IPS = ['127.0.0.1', 'localhost',] REST_FRAMEWORK = { 'DEFAULT_RENDERER_CLASSES': [ 'rest_framework.renderers.JSONRenderer', 'rest_framework.renderers.BrowsableAPIRenderer', 'rest_framework_xml.renderers.XMLRenderer', 'rest_framework_csv.renderers.CSVRenderer', 'rest_framework_yaml.renderers.YAMLRenderer', ], 'DEFAULT_AUTHENTICATION_CLASSES': ( 'rest_framework.authentication.TokenAuthentication', 'rest_framework_simplejwt.authentication.JWTAuthentication', 'rest_framework.authentication.SessionAuthentication', ), 'DEFAULT_FILTER_BACKENDS': ['django_filters.rest_framework.DjangoFilterBackend', 'rest_framework.filters.OrderingFilter', 'rest_framework.filters.SearchFilter', ], 'DEFAULT_THROTTLE_CLASSES': [ 'rest_framework.throttling.AnonRateThrottle', 'rest_framework.throttling.UserRateThrottle' ], 'DEFAULT_THROTTLE_RATES': { 'anon': '100000000/day', 'user': '100000000/day', 'ten': '10/minute', }, 'DEFAULT_PAGINATION_CLASS': 'rest_framework.pagination.PageNumberPagination', 'PAGE_SIZE': 20, 'PAGE_SIZE_QUERY_PARAM': 'page_size', 'MAX_PAGE_SIZE': 10000, } DJOSER = { "USER_ID_FIELD": "username", #"LOGIN_FIELD":"email", } """SIMPLE_JWT = { 'ACCESS_TOKEN_LIFETIME': timedelta(minutes=5) }""" SIMPLE_JWT = { 'ACCESS_TOKEN_LIFETIME': timedelta(minutes=5), 'REFRESH_TOKEN_LIFETIME': timedelta(days=1), 'ROTATE_REFRESH_TOKENS': False, 'BLACKLIST_AFTER_ROTATION': False, 'UPDATE_LAST_LOGIN': False, 'ALGORITHM': 'HS256', 'SIGNING_KEY': SECRET_KEY, 'VERIFYING_KEY': None, 'AUDIENCE': None, 'ISSUER': None, 'JWK_URL': None, 'LEEWAY': 0, 'AUTH_HEADER_TYPES': ('Bearer',), 'AUTH_HEADER_NAME': 'HTTP_AUTHORIZATION', 'USER_ID_FIELD': 'id', 'USER_ID_CLAIM': 'user_id', 'USER_AUTHENTICATION_RULE': 'rest_framework_simplejwt.authentication.default_user_authentication_rule', 'AUTH_TOKEN_CLASSES': ('rest_framework_simplejwt.tokens.AccessToken',), 'TOKEN_TYPE_CLAIM': 'token_type', 'TOKEN_USER_CLASS': 'rest_framework_simplejwt.models.TokenUser', 'JTI_CLAIM': 'jti', 'SLIDING_TOKEN_REFRESH_EXP_CLAIM': 'refresh_exp', 'SLIDING_TOKEN_LIFETIME': timedelta(hours=2), 'SLIDING_TOKEN_REFRESH_LIFETIME': timedelta(days=1), } SWAGGER_SETTINGS = { 'SECURITY_DEFINITIONS': { 'basic': { 'type': 'basic' } }, 'USE_SESSION_AUTH': True, 'JSON_EDITOR': True, 'DOC_EXPANSION': 'list', 'APIS_SORTER': 'alpha', 'SHOW_REQUEST_HEADERS': True, 'VALIDATOR_URL': None, 'SUPPORTED_SUBMIT_METHODS': [ 'get', 'post', 'put', 'patch', 'delete', 'options', 'head' ], 'OPERATIONS_SORTER': 'alpha', 'DEEP_LINKING': True, 'SHOW_OPERATION_ID': True, 'DEFAULT_MODEL_RENDERING': 'example', 'DEFAULT_MODEL_DEPTH': 0, 'DEFAULT_MODEL_EXPAND_DEPTH': 0, 'DEFAULT_MODEL_RENDERING_EXAMPLES': True, 'DEFAULT_MODEL_RENDERING_SHOW_REQUEST_HEADERS': True, 'DEFAULT_MODEL_RENDERING_SHOW_RESPONSE_HEADERS': True, 'DEFAULT_MODEL_RENDERING_SHOW_COMMON_PROPERTIES': True, 'DEFAULT_MODEL_RENDERING_SHOW_WRITE_ONLY': True, 'DEFAULT_MODEL_RENDERING_SHOW_READ_ONLY': True, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, 'DEFAULT_MODEL_RENDERING_EXAMPLES_VALUE_MAX_LENGTH': 200, } REDOC_SETTINGS = { 'LAZY_RENDERING': False, 'HIDE_HOSTNAME': False, 'EXPAND_RESPONSES': 'all', 'PATH_IN_MIDDLE': False, 'SCROLL_Y_OFFSET': 50, 'REQUIRED_PROPS_FIRST': False, 'NO_AUTO_AUTH': False, 'ONLY_REQUIRED_IN_SAMPLES': False, 'SORT_PROPS_ALPHABETICALLY': False, 'DISABLE_SEARCH': False, 'DISABLE_SORTING': False, 'DISABLE_FILTERING': False, 'SHOW_EXTENSIONS': False, 'PATHS_GROUPS': [], 'SHOW_HTTP_METHOD': True, 'SHOW_COMMON_EXTENSIONS': False, 'MENU_TOGGLE': False, 'JSON_SAMPLE_MAX_LENGTH': 200, 'JSON_SAMPLE_MAX_LINES': 5, 'JSON_SAMPLE_COLLAPSED': True, 'JSON_SAMPLE_SORT_KEYS': False, 'JSON_SAMPLE_HIDE_COMMENTS': True, 'JSON_SAMPLE_EXPAND_BUTTONS': True, 'JSON_SAMPLE_COPY_BUTTONS': True, 'JSON_SAMPLE_DEFAULT_COLLAPSED': False, 'JSON_SAMPLE_MAX_DEPTH': 5, 'JSON_SAMPLE_HIDE_NAVIGATION_BAR': False, 'JSON_SAMPLE_NAVIGATION_BAR_DEPTH': 3, 'JSON_SAMPLE_HIDE_NAVIGATION_BAR_TOP_LEVEL': False, 'JSON_SAMPLE_NAVIGATION_BAR_COLLAPSED': False, 'JSON_SAMPLE_NAVIGATION_BAR_COLLAPSED_DEPTH': 2, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_ONLY_PATHS': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_ONLY_PATHS': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_PATHS': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_PATHS': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_PATHS_REGEX': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_PATHS_REGEX': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_METHODS': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_METHODS': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_TAGS': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_TAGS': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_OPERATION_IDS': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_OPERATION_IDS': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_EXTENSIONS': [], 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_EXTENSIONS': [], 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_SUMMARY': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_SUMMARY': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_DESCRIPTION': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_DESCRIPTION': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_SERVERS': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_SERVERS': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_REQUEST_BODY': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_REQUEST_BODY': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_RESPONSES': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_RESPONSES': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_SECURITY': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_SECURITY': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_DEPRECATED': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_DEPRECATED': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_EXTENSIONS': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_EXTENSIONS': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_SERVERS_URL': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_SERVERS_URL': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_SERVERS_DESCRIPTION': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_SERVERS_DESCRIPTION': False, 'JSON_SAMPLE_NAVIGATION_BAR_HIDE_SERVERS_VARIABLES': False, 'JSON_SAMPLE_NAVIGATION_BAR_SHOW_SERVERS_VARIABLES': False, } if ('runserver' or 'check') in sys.argv: CACHES['default'] = CACHES['default'] if DEBUG: SPAGHETTI_SAUCE = { 'apps': ['auth', 'elianeribeiro'], 'show_fields': True, 'exclude': {'auth': ['user']}, } LOG_VIEWER_FILES = ['sync_data.log',] LOG_VIEWER_FILES_PATTERN = '*.log*' LOG_VIEWER_FILES_DIR = 'logs/' LOG_VIEWER_PAGE_LENGTH = 25 # total log lines per-page LOG_VIEWER_MAX_READ_LINES = 1000 # total log lines will be read LOG_VIEWER_FILE_LIST_MAX_ITEMS_PER_PAGE = 25 # Max log files loaded in Datatable per page LOG_VIEWER_PATTERNS = ['[INFO]', '[DEBUG]', '[WARNING]', '[ERROR]', '[CRITICAL]'] LOG_VIEWER_EXCLUDE_TEXT_PATTERN = None # String regex expression to exclude the log from line # Optionally you can set the next variables in order to customize the admin: #LOG_VIEWER_FILE_LIST_TITLE = "Custom title" #LOG_VIEWER_FILE_LIST_STYLES = "/static/css/my-custom.css" CSRF_COOKIE_SECURE = False SESSION_COOKIE_SECURE = False SECURE_SSL_REDIRECT = False SECURE_HSTS_SECONDS = 0 SECURE_HSTS_INCLUDE_SUBDOMAINS = False SECURE_HSTS_PRELOAD = False ALLOWED_HOSTS = ['*'] from elianeribeiro.cronjobs import * from siimgroup.cronjobs import * from latina.cronjobs import * from argo.cronjobs import * from boulevarddosipes.cronjobs import * from manami.cronjobs import * from vivelevin.cronjobs import * from incompany.cronjobs import * #Cron jobs CRONJOBS = [ ('50 * * * *', 'siimgroup.cronjobs.run_management_command', '>> /var/log/cronjobs/siimgroup.log 2>&1'), ('51 * * * *', 'latina.cronjobs.run_management_command', '>> /var/log/cronjobs/latina.log 2>&1'), ('52 * * * *', 'elianeribeiro.cronjobs.run_management_command', '>> /var/log/cronjobs/elianeribeiro.log 2>&1'), ('53 * * * *', 'argo.cronjobs.run_management_command', '>> /var/log/cronjobs/argo.log 2>&1'), ('54 * * * *', 'boulevarddosipes.cronjobs.run_management_command', '>> /var/log/cronjobs/boulevarddosipes.log 2>&1'), ('55 * * * *', 'manami.cronjobs.run_management_command', '>> /var/log/cronjobs/manami.log 2>&1'), ('56 * * * *', 'vivelevin.cronjobs.run_management_command', '>> /var/log/cronjobs/vivelevin.log 2>&1'), ('57 * * * *', 'incompany.cronjobs.run_management_command', '>> /var/log/cronjobs/incompany.log 2>&1'), ] if DEBUG==False: SECURE_SSL_REDIRECT = True SESSION_COOKIE_SECURE = True CSRF_COOKIE_SECURE = True SECURE_HSTS_SECONDS = 31536000 SECURE_HSTS_INCLUDE_SUBDOMAINS = True SECURE_HSTS_PRELOAD = True ALLOWED_HOSTS = [ 'pixerama.com.br', 'dw.pixerama.com.br', ]