Express JS rest-api for D-jahit application
Built with :
- Node v18 (Express js)
- MySql RDBMS
- Google App Engine
- Google Cloud Storage
- Google Cloud SQL
npm install
npm start
runtime: nodejs18 env_variables: INSTANCE_UNIX_SOCKET: /cloudsql/{your-sql-instance-connection-name} DB_USER: {your-db-user} DB_NAME: {your-database-name} GCLOUD_STORAGE_BUCKET: {your-bucket}
- Setup Google App Engine standard environment
- Setup Google Cloud SQL Instance, create the database named "d-jahit-db"
- Configure App Engine Standard Environment to connect to Google Cloud SQL Instance
- Deploy Expressjs rest-api to App Engine
- After App Engine Deployment, the schema and data migration will auto migrate
- Connect from App Engine standard environment : https://cloud.google.com/sql/docs/mysql/connect-app-engine-standard#node.js
- Connect to Cloud SQL : https://cloud.google.com/sql/docs/mysql/connect-instance-cloud-shell
- For detailed API documentation, install this vscode extension : https://marketplace.visualstudio.com/items?itemName=42Crunch.vscode-openapi
- Open api-spec.yaml file and then open preview on your computer, or you can use online swagger editor : https://editor.swagger.io/
- Use 'dev-v1' branch