Metadata-Version: 2.1
Name: yak-server
Version: 0.2.0
Summary: Football bet rest/graphql server
Home-page: https://github.com/yak-toto/yak-server
License: MIT
Keywords: mysql,api,rest,graphql
Author: Guillaume Le Pape
Author-email: gui.lepape25@gmail.com
Requires-Python: >=3.9,<4.0
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Requires-Dist: Flask-SQLAlchemy (>=3.0.3,<4.0.0)
Requires-Dist: PyJWT (>=2.6.0,<3.0.0)
Requires-Dist: PyMySQL (>=1.0.2,<2.0.0)
Requires-Dist: flask-cors (>=3.0.10,<4.0.0)
Requires-Dist: python-dotenv (>=0.21.1,<0.22.0)
Requires-Dist: requests (>=2.28.2,<3.0.0)
Requires-Dist: strawberry-graphql (>=0.155.3,<0.156.0)
Project-URL: Repository, https://github.com/yak-toto/yak-server
Description-Content-Type: text/markdown

# Yak-toto

## Requisites

- Ubuntu 22.04
- Python 3.10.4
- MySQL 8.0.30

## How to build the project

### Database

Install and start mysql server on port 3306. Add a database named `yak_toto`. In root folder, create a dotenv file named `.flaskenv` and fill your MySQL user name, password and database. When backend start, this configuration is automaticaly loaded.

```text
MYSQL_USER_NAME=my_user_name
MYSQL_PASSWORD=my_password
MYSQL_DB=my_database_name
```

You can also set MySQL port by adding `MYSQL_PORT=my_port` to `.flaskenv` file. If not set, it will be 3306 by default.

### Backend

Run your project in a Python env is highly recommend. You can use `venv` with the following command:

```bash
python3 -m venv <my_env_name>
```

Then activate it with:

```bash
source <my_env_name>/bin/activate
```

Fetch all packages using poetry with the following command:

```bash
poetry install
```

Before starting the backend, add `JWT_SECRET_KEY` in `.flaskenv` same as the MySQL user name and password. As
login system is using JSON Web Token, a secret key is required. To generate one, you can use the python built-in `secrets` module.

```py
>>> import secrets
>>> secrets.token_hex(16)
'9292f79e10ed7ed03ffad66d196217c4'
```

```text
JWT_SECRET_KEY=9292f79e10ed7ed03ffad66d196217c4
```

Also, automatic backup can be done through `yak_server/cli/backup_database` script and is able to send notification to Telegram bot. It can be run using `flask db backup`. To do so, please add a Telegram bot token and chat id to `.flaskenv`.

```text
BOT_TOKEN=my_bot_token
CHAT_ID=my_chat_id
```

If the variables are not set, no telegram will be send.

Finally, flask needs some configuration to start. Please add `FLASK_APP=yak_server` variable to indicate main location. Last thing, for development environment, debug needs to be activated with a addditional environment variable:

```text
FLASK_DEBUG=1
```

And then start backend with:

```bash
flask run
```

### Data initialization

To run local testing, you can use the script `create_database.py`, `initialize_database.py` and `create_admin.py` located in `yak_server/cli` folder. To select, set `COMPETITION` environment variable in `.flaskenv`. It will read data from `yak_server/data/{COMPETITION}/`.

### Testing

To set up test, please add a MySQL database named `yak_toto_test`. It will contain all the records created during unit tests. This database is cleaned everytime you run test. That's why a different database is created to avoid deleting records you use for your local testing.

Yak-server is using `pytest` to run tests and can run them using `poetry run pytest` command into root folder.

To generate xml report, run `pytest --cov-report=xml --cov=yak_server tests/ -vv`.

