ruchej

version: '3.4'
services:

  postgres:
    env_file: .env
    container_name: 'postgres_database'
    image: postgres:12.3
    shm_size: '256m'
    volumes:
      - db_data:/var/lib/postgresql/data

ruchej

user  nginx;
worker_processes  2;

events {
    worker_connections  4096;
}

http {
    include /etc/nginx/mime.types;
    client_max_body_size 100m;

ruchej

ALLOWED_HOSTS = ['*']
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'}]
BASE_DIR = PosixPath('/app')  ###
CONCURRENCY_AUTO_CREATE_TRIGGERS = True  ###
CONCURRENCY_CALLBACK = 'concurrency.views.callback'  ###
CONCURRENCY_ENABLED = True  ###
CONCURRENCY_FIELD_SIGNER = 'concurrency.forms.VersionFieldSigner'  ###
CONCURRENCY_HANDLER409 = 'concurrency.views.conflict'  ###
CONCURRENCY_MANUAL_TRIGGERS = False  ###
CONCURRENCY_POLICY = 1  ###

ruchej

2022-10-31 06:26:42,289 ERROR [Timer-Driven Process Thread-9] o.a.nifi.processors.standard.ExecuteSQL ExecuteSQL[id=184880c5-0184-1000-2f62-2cc2fb99ff55] Failed to process session due to java.lang.AbstractMethodError; Processor Administratively Yielded for 1 sec: java.lang.AbstractMethodError
java.lang.AbstractMethodError: null
        at net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)
        at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:897)
        at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:270)
        at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:630)
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:118)
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:665)
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.jav

ruchej

  jupyterhub:
    image: jupyterhub/jupyterhub:2.1.1
    container_name: ${CONTAINER_NAME_PREFIX}jupyterhub
    volumes:
      - ./jupyterhub/jupyterhub_config.py:/etc/jupyterhub/jupyterhub_config.py
      - ./jupyterhub/data:/home
    working_dir: /home/jupyter
    user: root
    environment:
      SERVER_HOST: ${SERVER_HOST}

ruchej

def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('advice_reactions', 'advice_id', new_column_name='advice_reсomendation_id')
    op.drop_constraint('advice_reactions_advice_id_fkey', 'advice_reactions', type_='foreignkey')
    op.create_foreign_key(None, 'advice_reactions', 'advices', ['advice_reсomendation_id'], ['id'], onupdate='CASCADE', ondelete='CASCADE')
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###

ruchej

CREATE OR REPLACE PROCEDURE CREATE_TABLE_TRANSFORMED_DATA()
LANGUAGE 'plpgsql'
AS $$
    CREATE TABLE IF NOT EXISTS public.transformed_data
    (
        value_timestamp timestamp without time zone NOT NULL,
        CONSTRAINT transformed_data_pkey PRIMARY KEY (value_timestamp)
    );

    DECLARE names ARRAY;

ruchej

#-*- coding: utf-8 -*-
import copy
import json
import monotonic


class MyEncoder(json.JSONEncoder):
    def default(self, obj):
        return obj.__dict__

ruchej

2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_METRICS'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-08-13 08:11:14 1 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

ruchej

def parsing_one_group(url: str) -> Dict[str, list[str]]:
    '''
    Парсинг одной группы по букве.
    Возвращает список животных в словаре
    {"А": "Аардоникс"}
    '''
    page = requests.get(url).text
    soup = BeautifulSoup(page, 'lxml')
    group = soup.find(id='mw-pages').find('div', class_='mw-category-group')
    letter = group.find('h3').text