Configuring for Local Deployment - SMS-Staging-Management-System/UserService GitHub Wiki

SQL Script

The database table data can be automatically created on your local or RDS Oracle database. First, create a user and grant it permission to create tables. Use the SQL script SMS.sql found in the SMS-Staging-Management-System/UserService repository to create the tables for the User Service. Before using the script make a schema called 'sms' then run the SMS.sql file. To populate some test data for the users, cohorts, and users-cohorts tables, use the setup.sql file found in the SMS-Staging-Management-System/UserService repository.

Environment Variables

db_password (your database password)

db_username: (your database username)

db_url: jdbc:postgresql://znc.anorexicseal.com:5432/userservice

db_schema: sms

DEPLOYMENT_STAGE: dev

cognito_url: https://t4o3pxu8dj.execute-api.us-west-2.amazonaws.com/dev