The Lexitrail application is built using React, a popular JavaScript library for building user interfaces. The frontend is structured into components, each responsible for specific parts of the UI. The game logic is handled in React components, which manage state and user interactions.

Create .env file inside /ui/ folder. This file will not be saved to git.

cd ui/
npm install
npm start

cd terraform/
gcloud auth login
gcloud auth application-default login

• Go to APs & Services => OAuth consent screen
• Follow the prompts

• Go to APIs & Services => Credentials
• Create OAuth client ID
• Application Type => Web Application
• Name => Lexitrail UI
• Click Create
• Save the client_id field, update it in the .env file

  REACT_APP_CLIENT_ID=<YOUR_CLIENT_ID>
  

Here is your updated schema with improved descriptions where necessary:

These descriptions should help clarify the purpose of each column in the schema, making your README more informative and easier to understand.

PROJECT_ID=alexbu-gke-dev-d
gcloud container clusters get-credentials lexitrail-cluster --location=us-central1
gcloud iam service-accounts get-iam-policy [email protected]
gcloud projects get-iam-policy alexbu-gke-dev-d --flatten="bindings[].members" --filter="bindings.members:serviceAccount:[email protected]"

kubectl run -it --rm   debug-gcs1   --namespace=mysql   --image=google/cloud-sdk:slim   --restart=Never --timeout=5m   --overrides='{
    "spec": {
      "serviceAccountName": "default"
    }
  }'   -- sh

Then after getting in:

gsutil ls gs://alexbu-gke-dev-d-lexitrail-mysql-files
gcloud auth list

This Flask API provides CRUD functionality for users, wordsets, words, and userwords, as well as recall state updates with automatic recall history tracking.

1. Install the dependencies:

   pip install -r requirements.txt

2. Set up the .env file in the root directory:

   DATABASE_URL=mysql://username:password@localhost/dbname
   SECRET_KEY=your_secret_key_here

3. Run the app:

   python run.py

1. Create and Activate a Virtual Environment
   Create a virtual environment and activate it:

cd backend
python3 -m venv venv
source venv/bin/activate

2. Install Dependencies
   Install the required dependencies:

pip install -r requirements.txt

3. Port-forward to connect to mysql db

gcloud auth login
gcloud container clusters get-credentials lexitrail-cluster --location=us-central1
kubectl port-forward svc/mysql 3306:3306 -n mysql

4. Ensure connection to db

# Load environment variables from the parent directory's .env file
if [ -f ../.env ]; then
   echo "Loading environment variables from ../.env file..."
   export $(grep -v '^#' ../.env | xargs)
else
   echo "Error: .env file not found in the parent directory!"
   exit 1
fi

# Check if db_root_password is set
if [ -z "$DB_ROOT_PASSWORD" ]; then
   echo "Error: db_root_password not set in the .env file!"
   exit 1
fi
mysql -u root -p"$DB_ROOT_PASSWORD" -h 127.0.0.1 -P 3306 -e "SHOW DATABASES;"

3. Run Unit Tests
   With the .env file already set up at the root level, run the tests:

pytest
# or other examples:
pytest tests/test_users.py::UserTests::test_create_user
pytest tests/test_userwords.py::UserWordTests
pytest tests/test_words.py::WordTests
pytest tests/test_wordsets.py::WordSetTests

4. Deactivate the Virtual Environment
   Once finished, deactivate the virtual environment:

deactivate

1. Port-forward to connect to mysql db

gcloud auth login
gcloud container clusters get-credentials lexitrail-cluster --location=us-central1
kubectl port-forward svc/mysql 3306:3306 -n mysql

2. Launch python backend locally

cd backend
python3 -m venv venv
source venv/bin/activate
python run.py

# validate
curl -v http://localhost:5001/wordsets

2. Launch UI locally

cd UI
npm start

# validate
curl -v http://localhost:5001/wordsets

PROJECT_ID= CLUSTER_NAME= DB_ROOT_PASSWORD= MYSQL_FILES_BUCKET= SQL_NAMESPACE= DATABASE_NAME= GOOGLE_CLIENT_ID= PROJECT_ID= LOCATION=

• Step 1: Port-forward to connect to MySQL database

gcloud auth login
gcloud auth application-default login
gcloud container clusters get-credentials lexitrail-cluster --location=us-central1
kubectl port-forward svc/mysql 3306:3306 -n mysql

• Step 2: Launch Python backend locally

cd backend
python3 -m venv venv
source venv/bin/activate
python scripts/lexitrailcmd.py [function]