importtoolseeds

#!/bin/sh
#  _____ _____ ____ _____ ___ _   _  ____   ____    _  _____  _
# |_   _| ____/ ___|_   _|_ _| \ | |/ ___| |  _ \  / \|_   _|/ \
#   | | |  _| \___ \ | |  | ||  \| | |  _  | | | |/ _ \ | | / _ \
#   | | | |___ ___) || |  | || |\  | |_| | | |_| / ___ \| |/ ___ \
#   |_| |_____|____/ |_| |___|_| \_|\____| |____/_/   \_\_/_/   \_\ woot.
MONGO_CONNECTION_URI=${MONGO_OPPS_CONNECTION_STRING:-"mongodb://localhost:27017/bc-local-opps"}

BLOCKING_ERRORS_EMPTY_PROJECT_NAME='1ZaSAGUoJ8p0kdgbSnqckAcTnD6oDs8yxpKKVI3EqOEE'
BLOCKING_ERRORS_INVALID_CLIENT_EMAIL='1G3L_jg4XGGTgqDhbND3pLI428wR-WuWiiC3PBjRPhXY'
BLOCKING_ERRORS_EMPTY_SHEET='1kp-xa04_LF5ExPx4QM1KkhwqDojSm0KJr_70Atb-GSI'
BLOCKING_ERRORS_BAD_COLUMN_NAME='1-x3HzFOLK061SrDjmQ9xKddfzbfda2t6K_PlZsLmsy4'
TEMPLATE_ERRORS_NO_FALLBACK='1_Ve09eyGIjSZHbXlyRgK9dVc1TMtX1RoaqaEd06kM5Q'
TEMPLATE_ERRORS_FALLBACK='1Y3edGY-k0NtP3Z5oJp3K8FWOR6Pt0QT9UIeo8qc6ZUc'
SUMMARY_SHEET_PRISTINE='15FME8nf1UOonwbPJI2LIuEpQj0z0yz3myicHk1Qi3GM'

echo "Clearing HistoricalImports collection" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.remove({})" &&

echo "Inserting BLOCKING_ERRORS_INVALID_CLIENT_EMAIL" &&

echo "Inserting BLOCKING_ERRORS_EMPTY_PROJECT_NAME" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$BLOCKING_ERRORS_EMPTY_PROJECT_NAME'})" &&

echo "Inserting BLOCKING_ERRORS_INVALID_CLIENT_EMAIL" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$BLOCKING_ERRORS_INVALID_CLIENT_EMAIL'})" &&

echo "Inserting BLOCKING_ERRORS_EMPTY_SHEET" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$BLOCKING_ERRORS_EMPTY_SHEET' })" &&

echo "Inserting BLOCKING_ERRORS_BAD_COLUMN_NAME" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$BLOCKING_ERRORS_BAD_COLUMN_NAME'})" &&

echo "Inserting TEMPLATE_ERRORS_NO_FALLBACK" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_NO_FALLBACK' })" &&

echo "Inserting TEMPLATE_ERRORS_FALLBACK" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK'})" &&

echo "Inserting BLOCKING_ERRORS_BAD_COLUMN_NAME" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$BLOCKING_ERRORS_BAD_COLUMN_NAME'})";

echo "Inserting SUMMARY_SHEET_PRISTINE" &&

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_PRISTINE' })";

#  ____ _____  _    ____ _____   _____ _____ ____ _____
# / ___|_   _|/ \  / ___| ____| |_   _| ____/ ___|_   _|
# \___ \ | | / _ \| |  _|  _|     | | |  _| \___ \ | |
#  ___) || |/ ___ \ |_| | |___    | | | |___ ___) || |
# |____/ |_/_/   \_\____|_____|   |_| |_____|____/ |_| This summarySheetIds are for testing in Stage with Cory.

CORYS_SPECIAL_QA_SHEET='15IeDRth0NNdVesjAhNA7UwmkfZwyLLVT9yjaRZuIGiY'
SUMMARY_SHEET_ID_1="1zC45HEMiSXv_7pIBzMMimena85Vxg8OTfKp3Dym44Ng"
SUMMARY_SHEET_ID_2="1VIDaRzlADyRLw0mkKRRBaYvXcAcklfaoR0jDX3yE1r4"
SUMMARY_SHEET_ID_3="1_Ef9vL9U4VkBGYf4j3HU7Reh8cMjr15M8DhUvqEwKns"
SUMMARY_SHEET_ID_4="1hvUBUAKJJcNxovVX6Rgc40a_EtGbkPoUP_QQmvTD2uo"
SUMMARY_SHEET_ID_5="1O3vXajmi9mhVQkx04kz_5F1ilKvwJU8rAWl7MV4UWCk"
SUMMARY_SHEET_ID_6="1DOaUZikB_XZutIvznEe1Xti3QiQPOd54Lg-8T9yovYM"
SUMMARY_SHEET_ID_7="1zhbDOcjk0U_QjG08L7XA3kqeGaHqJKYUG9KpRNrMLXw"
SUMMARY_SHEET_ID_8="1CWOsdqrtYYiQoFkod0Ch40X8a6J8qnZO6AvUD6qgh9k"
SUMMARY_SHEET_ID_9="1CWOsdqrtYYiQoFkod0Ch40X8a6J8qnZO6AvUD6qgh9k"
SUMMARY_SHEET_ID_10="1aySBavD3jTWqo9_YV9646L002Q4xuwAMMlBx6N-U1ws"

echo "Inserting record for  SUMMARY_SHEET_ID_1"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_1' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_2"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
_id: ObjectId('ffffffffffffffffffffffff'), \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_2' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_3"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_3' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_4"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_4' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_5"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_5' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_6"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_6' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_7"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_7' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_8"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_8' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_9"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_9' })" &&
echo "Inserting record for  SUMMARY_SHEET_ID_10"
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$TEMPLATE_ERRORS_FALLBACK', \
summarySheetId: '$SUMMARY_SHEET_ID_10' })" &&

# CORYS SHIT

echo "Inserting CORYS_SPECIAL_QA_SHEET" &&
docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.insert({ \
companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'), \
officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'), \
startedBy: ObjectId('58ed681b195f9a0b00708c4b'), \
onTrial: false, \
state: 'DRAFT', \
templateSheetId: '$CORYS_SPECIAL_QA_SHEET'})";