#! /bin/bash
#Change these configuration settings to match your server, project, and database connection

SERVER=http://localhost:8080/APIServer
USERNAME=admin
PW=Password1
DATABASE_USER=dbtyler_demo
DATABASE_PW=kahuna_local!1
PROJECT=demo_sqlserver

lacadmin login -u $USERNAME -p $PW $SERVER -a $PROJECT
lacadmin use $PROJECT
lacadmin project use --url_name $PROJECT
lacadmin datasource create --db_name HR     --prefix hr   --dbasetype sqlserver --active true --url "jdbc:sqlserver://192.168.50.4:1433;databaseName=AdventureWorks2008R2" --catalog_name AdventureWorks2008R2 --schema_name HumanResources --user_name $DATABASE_USER --password $DATABASE_PW --schema_editable false
lacadmin datasource create --db_name Person --prefix person --dbasetype sqlserver --active true --url "jdbc:sqlserver://192.168.50.4:1433;databaseName=AdventureWorks2008R2" --catalog_name AdventureWorks2008R2 --schema_name Person --user_name $DATABASE_USER --password $DATABASE_PW --schema_editable false
lacadmin datasource create --db_name Sales --prefix sales --dbasetype sqlserver --active true --url "jdbc:sqlserver://192.168.50.4:1433;databaseName=AdventureWorks2008R2" --catalog_name AdventureWorks2008R2 --schema_name Sales --user_name $DATABASE_USER --password $DATABASE_PW --schema_editable false
lacadmin datasource create --db_name Production --prefix prod --dbasetype sqlserver --active true --url "jdbc:sqlserver://192.168.50.4:1433;databaseName=AdventureWorks2008R2" --catalog_name AdventureWorks2008R2 --schema_name Production --user_name $DATABASE_USER --password $DATABASE_PW --schema_editable false
lacadmin datasource create --db_name Purchasing --prefix purch --dbasetype sqlserver --active true --url "jdbc:sqlserver://192.168.50.4:1433;databaseName=AdventureWorks2008R2" --catalog_name AdventureWorks2008R2 --schema_name Purchasing --user_name $DATABASE_USER --password $DATABASE_PW --schema_editable false

lacadmin logout $PROJECT