Skip to content

Latest commit

 

History

History
99 lines (67 loc) · 2.51 KB

README.md

File metadata and controls

99 lines (67 loc) · 2.51 KB
Raw

rmatics-back

Deploying via Ansible

ansible-playbook -i 'ansible/hosts' \
--extra-vars "target_server=stage" \
ansible/main.yml

Configuring app

Settings

Global environment should be passed in different ways depending on boot method:

  1. WSGI via wsgi.py reads FLASK_ENV variable and selects appropriate config class.
  2. flask run via console or PyCharm configuration reads FLASK_APP var, which should point to app with running config module e.g informatics_front:create_app('informatics_front.config.DevConfig')
  3. pytest automaticaly runs base informatics_front.config.TestConfig.

App-specific settings should be provided as env vars along with FLASK_ENV and FLASK_APP. A complete list of supported ones can be found in informatics_front/config.py.

App should be set as pointer to factory method with appropriate config:

FLASK_APP=informatics_front.app_factory:create_app('informatics_front.config.DevConfig')

Database schemas

  • ejudge;
  • moodle;
  • pynformatics — primary;
  • informatics.

Database migration

Ensure DB connection string points to primary migration DB. Note /pynformatics at the end.

SQLALCHEMY_DATABASE_URI=mysql+pymysql://root:@localhost/pynformatics

Remove any pre-existing tables:

drop database refresh_token;

We use utf8 character set. Any previously created DB with different charset should be converted:

ALTER DATABASE pynformatics CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Then update to current schema:

flask db upgrade

After modifying models:

# generate new migrations
flask db migrate


# ensure corresponing pkeys and migrate
flask db upgrade

Deprecated

  1. Convert moodle.mdl_statements to InnoDB (refrenced by contest_instance):

    ALTER TABLE moodle.mdl_statements ENGINE = InnoDB;

    Refrenced tables should be the same engine type (InnoDB) as parent;

  2. Ensure all FKey refs are described with correspnding types in migrations:

    from sqlalchemy.dialects.mysql import BIGINT
...
sa.Column('contest_id', BIGINT(display_width=10, unsigned=True), nullable=True), # <-> for

    or similar. FKey types should be the same type as PKeys e.g. (bigint(10) unsigned);

Running tests

Docker

Build and run tests container with provided docker-compose file:

docker-compose --file docker/docker-compose.yml up --force-recreate --abort-on-container-exit --build

If all tests are passed, the Docker process will exit with code 0.jkkkk