Online listing status checker by Salmon Fit
cp .env-template .env
# Then update variables accordinglyFor the database I use https://neon.tech/
go run .
# Get History API used by salmonfit.com
curl -H "Origin: https://localhost:5173" https://localhost:8080/api/history
# Ping API
curl -H "X-API-Key: api_key" https://localhost:8080/api/ping- Modify schema.sql or query.sql
- Run
sqlc generate - Files in
dbdir should be updated
- Create a telegram bot: https://core.telegram.org/bots/tutorial to retrieve a bot token, store it as env "TELEGRAM_BOT_TOKEN"
- Create a group chat
- Invite your bot into the group chat
- Run
curl https://api.telegram.org/bot[TELEGRAM_BOT_TOKEN]/getUpdatesto get the chat_id, store it as env "TELEGRAM_CHAT_ID". If it returns empty you can try removing the bot from group chat & add it again.
Install https://github.com/swaggo/gin-swagger#usage
swag init --parseDependency
# Doc should be accessible on https://localhost:8080/swagger/index.html# Prepare secrets, this requires Secret Manager API to be enabled
echo -n "PUT_THE_API_KEY_HERE" | \
gcloud secrets create "salmonping_API_KEY" --replication-policy "automatic" --data-file -
echo -n "PUT_THE_DATABASE_URL_HERE" | \
gcloud secrets create "salmonping_DATABASE_URL" --replication-policy "automatic" --data-file -
# Optional
echo -n "PUT_TELEGRAM_BOT_TOKEN" | \
gcloud secrets create "salmonping_TELEGRAM_BOT_TOKEN" --replication-policy "automatic" --data-file -
echo -n "PUT_TELEGRAM_CHAT_ID" | \
gcloud secrets create "salmonping_TELEGRAM_CHAT_ID" --replication-policy "automatic" --data-file -
# https://developer.gobiz.com/docs/api/webhooks/receiving-notifications
echo -n "PUT_GOFOOD_NOTIFICATION_SECRET_KEY" | \
gcloud secrets create "salmonping_GOFOOD_NOTIFICATION_SECRET_KEY" --replication-policy "automatic" --data-file -
# Create a service account and allow access to secret manager & cloud storage
gcloud iam service-accounts create SERVICE_ACCOUNT_NAME
gcloud projects add-iam-policy-binding PROJECT_ID \
--member='serviceAccount:SERVICE_ACCOUNT_NAME@PROJECT_ID.iam.gserviceaccount.com' \
--role='roles/secretmanager.secretAccessor' \
--role='roles/storage.objectCreator'
# Deploy cloud run
gcloud run deploy salmonping --source . \
--allow-unauthenticated \
--concurrency 16 \
--cpu 1 \
--max-instances 5 \
--memory 128Mi \
--min-instances 0 \
--region=asia-southeast2 \
--service-account SERVICE_ACCOUNT_NAME@PROJECT_ID.iam.gserviceaccount.com \
--set-env-vars GIN_MODE=release \
--set-secrets API_KEY=salmonping_API_KEY:latest \
--set-secrets DATABASE_URL=salmonping_DATABASE_URL:latest \
# Uncomment if you choose to enable Gofood integration
# --set-secrets GOFOOD_NOTIFICATION_SECRET_KEY=salmonping_GOFOOD_NOTIFICATION_SECRET_KEY:latest \
# Uncomment if you choose to enable Telegram alert
# --set-secrets TELEGRAM_BOT_TOKEN=salmonping_TELEGRAM_BOT_TOKEN:latest \
# --set-secrets TELEGRAM_CHAT_ID=salmonping_TELEGRAM_CHAT_ID:latest \
--tag=main \
--timeout 15s \
--update-labels service=salmonping
# Create a google cloud schedulers
gcloud scheduler jobs create http salmonping_ping --schedule="2,11,21,31,41,51,59 9-20 * * 1-6" --location="asia-southeast2" --time-zone="Asia/Jakarta" --uri=ENDPOINT_URL --http-method=GET --headers="X-API-Key=API_KEY"
# Create a cloud storage to debug html
gsutil mb -l asia-southeast2 gs:https://YOUR_BUCKET_NAME/
gsutil lifecycle set gcs-lifecycle-config.json gs:https://YOUR_BUCKET_NAME/
# Verify
gsutil lifecycle get gs:https://YOUR_BUCKET_NAME/