xmarcosx/data-import

Data Import in Google Cloud

gcloud config set project $GOOGLE_CLOUD_PROJECT;

gcloud sql databases create 'EdFi_DataImport' --instance=edfi-ods-db;

gcloud services enable artifactregistry.googleapis.com;

# create artifact registry repository
gcloud artifacts repositories create dataimport \
    --project=$GOOGLE_CLOUD_PROJECT \
    --repository-format=docker \
    --location=us-central1 \
    --description="Docker repository";

gcloud builds submit \
    --tag us-central1-docker.pkg.dev/$GOOGLE_CLOUD_PROJECT/dataimport/dataimport data_import/.;

gcloud beta run deploy edfi-data-import \
    --image us-central1-docker.pkg.dev/$GOOGLE_CLOUD_PROJECT/dataimport/dataimport \
    --add-cloudsql-instances "$GOOGLE_CLOUD_PROJECT":us-central1:edfi-ods-db \
    --port 80 \
    --region us-central1 \
    --cpu 2 \
    --memory 1Gi \
    --concurrency 50 \
    --min-instances 0 \
    --max-instances 1 \
    --allow-unauthenticated \
    --update-env-vars PROJECT_ID="$GOOGLE_CLOUD_PROJECT" \
    --set-secrets=POSTGRES_PASSWORD=ods-password:latest,ENCRYPTION_KEY=admin-app-encryption-key:latest \
    --service-account edfi-cloud-run@"$GOOGLE_CLOUD_PROJECT".iam.gserviceaccount.com \
    --platform managed;