SERVER=http://localhost:8080/APIServer
USERNAME=admin
PW=Password1
DATABASE_USER=abl
DATABASE_PW=kahuna_local!1
PROJECT=foo
PROJECT_URL=bar
MDS_IDENT=2005

lacadmin login -u $USERNAME -p $PW $SERVER
lacadmin managedserver create --server_name 'MDS Mysql' --dbasetype 'mysql' --url 'jdbc:mysql://localhost:3308' --active true --user_name $DATABASE_USER --password $DATABASE_PW --comments 'Managed Server created by lacadmin cli'

#Create a new empty project
lacadmin project create create --project_name $PROJECT --url_name $PROJECT_URL
#OR Import existing project
#lacadmin project import --file PROJECT_filename.json
lacadmin project list
lacadmin project use --url_name $PROJECT_URL
#Use the MDS List to get the IDENT of the server
lacadmin managedserver list
lacadmin datasource createDatabase --managedserver_ident $MDS_IDENT
lacadmin datasource list
#this prefix is created by the Managed Data Server
DS_PREFIX=xxxx
SCHEMA_FILE=SCHEMA_main.json
#IMPORT the Schema to the MDS
lacadmin schema create --prefix $DS_PREFIX --ignoredbcolumntype true --ignoreprimarykeyname true --ignoreconstraintname true --skiprelationships true --skiptablecreation false --file $SCHEMA_FILE
#CREATE rules
#lacadmin rule create --ruletype count --entity_name main:PRODUCT --rule_name null --role_name TICKET_PRODUCT_TICKET_List --attribute_name TotalTicketCnt --clause 'null' --active true --jit false --sqlable true --comments 'null'

#IMPORT DATA HERE
#lac login -u demo -p Password1 http://localhost:8080/APIServer/rest/default/demo/v1
#lac post somejsonendpoint --file somefile.json
#Add Relationships
lacadmin schema create --prefix $DS_PREFIX --ignoredbcolumntype true --ignoreprimarykeyname true --ignoreconstraintname true --skiprelationships false --skiptablecreation true --file $SCHEMA_FILE