Run this command in WSL while having docker desktop up.
docker build -f Dockerfile -t zeeguu/api .
Run this after to create the container
docker run --name=zeeguu-mysql -p 8080:3306 -d zeeguu/zeeguu-mysql
Run these commands to populate the database
NEW VERSION OF DB AVAILABLE
- Run this in wsl, remember to have the db_dump in the same folder that you are running this command from:
docker cp <name_of_db_dump> zeeguu-mysql:<name_of_db_dump>
- Enter docker interactive env:
docker exec -it zeeguu-mysql /bin/bash
- Open mysql:
mysql -u zeeguu_test -p zeeguu_test
- Enter password:
zeeguu_test
- Choose which db to copy to
USE zeeguu_test
- Give which source to copy from:
source <name_of_db_dump>
It's going to take a while, let it run..
Migrations docker cp <name_of_migration> zeeguu-mysql:<name_of_migration> mysql -u zeeguu_test -p zeeguu_test < /<name_of_migration>
Run this to run the server
docker-compose up dev_server
Go to this URL to check that the server is running
http://localhost:9001/available_languages
Should get an input similar to
["de", "es", "fr", "nl", "en", "it", "da", "pl", "sv", "ru", "no", "hu", "pt"]
run with docker-compose up dev_play
docker cp zeeguu-anonymized-zeeguu_test-202401300908.sql zeeguu-mysql:zeeguu-anonymized-zeeguu_test-202401300908.sql
**NEW VERSION OF DB AVAILABLE**
docker cp zeeguu-anonymized-24-03-01.sql zeeguu-mysql:zeeguu-anonymized-24-03-01.sql
docker exec -it zeeguu-mysql /bin/bash
mysql -u zeeguu_test -p zeeguu_test
zeeguu_test
USE zeeguu_test
source zeeguu-anonymized-24-03-01.sql
(https://mermaid.live/edit#pako:eNqtWEtvqzgU_ivI0t21VZKmnSbbmfVsZjeqhBx8SKyAjWyTm0yS_z7GYMDYQNp7s4jKeTjn8Z3vmF5RwgmgLQLxF8V7gfNPFunPjx_R3zwiWOH6uf7GQtEkg-jaPFcfylRESVQcXZGQMk4BSKx16XFgX4osKM8w25d4D2GnIuOYgPCUUgnK9pGiKgNPikt14EJ68oQzBUx58oPKsz9HdLLMcywublg_uSBxwsu-va4bKJpDVJS7jMqDLkP16Dqmx5jQNKVJmanBmTvBj8BcGYEMFBBXeKIEeC269xtVShDR7fb8zK-2ab0fM43Z4eQYbaMDlm5vv-UVNLsGQDLsqQz0s1LYc40uUNjqj0F9_AjawkxmqHhBkzjHhc5LfzeJGeljpr72OpaMK68drNRrYFxBK7rrEG5dCAZuIxF8xbZVXgNwHlR9pCFtYTu03aId50c9JA5IumRudYA9o0_EBd1Tpvspo1Tw_BM94qQEZjIzTopbFwVnZVvWszanGoNW6EEzCEtXWMfpN7GJhPKATgfkCFv8unSgKLtU9lJhIfozbhUpVXHKRSxVSS6B4zLAgnksY70b7aBrlmwnanHCIjlgETHcP9ZKq83hnumTjwQpdWX6aLCi79JDlzSWKtYmg7zc7GwgBhvjdDdUm-cZlPS2VWi9zXNAV8jBvhkoYh3WYZBlzU8P9K63FiuGGRmuHoq_NJRDv-Bc9gEx6kCi3SU0yBMOlLUOndF19mrSDrJHcu4se-oOjsExD2-qL066M6u_RgHepNuSmn5UtdS40rOt6AlsISdNbWz9ts6Xu_6B2L3bDSapiX3KJuH6HueV2aIcckyzR4mrwFKaPSdxpsbVvoayE1U1PHzyc2BuoIITnTnVF5LqHh0kH_6AcUA7X_QxqDprPJqFa0ciISmcgqx1wlkZsj7r8Yq7V4o-uHWy8ZAhJ-ralG-uor6ZI_er-L0yBqrIC3CGuFWMzz09Apm5yZto2gmtprIZnB51hgbY9aHNIOs3GofWW6NfubdPvsERSDIsqjnXyMninLJpPT4PImEpiAn_ob7vb-ssABOdeczgp_S1hFc6OINIqL6nDBgIUlEf3QPoSJfszwTuPyGoTpgH9b-JAEYAqgJvq6QUhvjG7mEVQWlaDG87KmsCe2Qx1deLBqjdhu9U87mPrRHLRC65G1RgZsFqgkNPKAehdwpBW2R-UF88DqBzQ1VkRL9DVIHdtR0uFf_nwhK0VaKEJ1QWVWGaf6ZYYYHZv5zrxxRnsn5G2ys6o-3zevH6slovluv12-pt9bFYvj6hC9qulpuX9fv7-n213ry9bhZvq_sT-s-csXxZLDbrzcfq433xx2K5WN7_B9VSoeo)