Gist Me

get_this_gist

#!/bin/sh

#  _   _           __       _
# | | | |___  ___ / _|_   _| |
# | | | / __|/ _ \ |_| | | | |
# | |_| \__ \  __/  _| |_| | |
#  \___/|___/\___|_|  \__,_|_|
# BC id: 5430e7bc5cdc2e0300dd8b78
# http://localhost:3000/admiin/historical-opportunity-imports/5430e7bc5cdc2e0300dd8b78


# See: https://unix.stackexchange.com/questions/122845/using-a-b-for-variable-assignment-in-scripts
MONGO_CONNECTION_URI=${MONGO_OPPS_CONNECTION_STRING:-"mongodb://localhost:27017/bc-local-opps"}

function insertTemplateDoc(){
    echo "$1 | Inserting templateSheetId: $2"
    read -r -d '' VVVVV <<- EOM
    db.HistoricalImports.insert({
        _id: new ObjectId('$3'),
        companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'),
        officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'),
        startedBy: ObjectId('58ed681b195f9a0b00708c4b'),
        onTrial: false,
        state: 'DRAFT',
        templateSheetId: '$2'
    })
EOM
    docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "$VVVVV"
}

function insertSummaryDoc(){
    echo "$1 | Inserting summarySheetId: $2"
    read -r -d '' VVVVV <<- EOM
    db.HistoricalImports.insert({
        _id: new ObjectId('$3'),
        companyId: ObjectId('5430e7bc5cdc2e0300dd8b78'),
        officeId: ObjectId('5430e7bc5cdc2e0300dd8b7b'),
        startedBy: ObjectId('58ed681b195f9a0b00708c4b'),
        onTrial: false,
        state: 'DRAFT',
        templateSheetId: '1iYG59mD3wXTa5RDn0vPQ-VjYDnuJybkNDnplXjyKUKY',
        summarySheetId: '$2'
    })
EOM
    docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "$VVVVV"
}

function processTemplates () {
    # See: https://stackoverflow.com/questions/11776468/create-associative-array-in-bash-3
    declare -a listOfValsToLoop=("${!1}")
    for val in "${listOfValsToLoop[@]}"; do
        IFS=':' read -ra MY_SWEET_ARRAY <<< "$val"
        # See: https://www.thegeekstuff.com/2010/07/bash-string-manipulation
        insertTemplateDoc ${MY_SWEET_ARRAY[0]} ${MY_SWEET_ARRAY[1]} ${MY_SWEET_ARRAY[2]}
    done
}

function processSummaries () {
    # See: https://stackoverflow.com/questions/11776468/create-associative-array-in-bash-3
    declare -a listOfValsToLoop=("${!1}")
    for val in "${listOfValsToLoop[@]}"; do
        IFS=':' read -ra MY_SWEET_ARRAY <<< "$val"
        # See: https://www.thegeekstuff.com/2010/07/bash-string-manipulation
        insertSummaryDoc ${MY_SWEET_ARRAY[0]} ${MY_SWEET_ARRAY[1]} ${MY_SWEET_ARRAY[2]}
    done
}

#  _____ _____ ____ _____ ___ _   _  ____   ____    _  _____  _
# |_   _| ____/ ___|_   _|_ _| \ | |/ ___| |  _ \  / \|_   _|/ \
#   | | |  _| \___ \ | |  | ||  \| | |  _  | | | |/ _ \ | | / _ \
#   | | | |___ ___) || |  | || |\  | |_| | | |_| / ___ \| |/ ___ \
#   |_| |_____|____/ |_| |___|_| \_|\____| |____/_/   \_\_/_/   \_\ woot.

# echo "function ccc () { git commit -m \"\$*\" }" >> ~/.bashrc && bash

TEMPLATE_TESTING_SHEETS=(
    # "BLOCKING_ERRORS_EMPTY_PROJECT_NAME:1ZaSAGUoJ8p0kdgbSnqckAcTnD6oDs8yxpKKVI3EqOEE:aaaaaaaaaaaaaaaaaaaaaa00"
    # "BLOCKING_ERRORS_INVALID_CLIENT_EMAIL:1G3L_jg4XGGTgqDhbND3pLI428wR-WuWiiC3PBjRPhXY:aaaaaaaaaaaaaaaaaaaaaa01"
    # "BLOCKING_ERRORS_EMPTY_SHEET:1kp-xa04_LF5ExPx4QM1KkhwqDojSm0KJr_70Atb-GSI:aaaaaaaaaaaaaaaaaaaaaa02"
    # "TEMPLATE_ERRORS_NO_FALLBACK:1_Ve09eyGIjSZHbXlyRgK9dVc1TMtX1RoaqaEd06kM5Q:aaaaaaaaaaaaaaaaaaaaaa03"
    # "TEMPLATE_ERRORS_FALLBACK:1Y3edGY-k0NtP3Z5oJp3K8FWOR6Pt0QT9UIeo8qc6ZUc:aaaaaaaaaaaaaaaaaaaaaa04"
    # "BLOCKING_ERRORS_BAD_COLUMN_NAME:1-x3HzFOLK061SrDjmQ9xKddfzbfda2t6K_PlZsLmsy4:aaaaaaaaaaaaaaaaaaaaaa05"
    # "TEMPLATE_ERRORS_MISSING_OUTCOME_DATE:1kbU1rJtUR3N8iFzc-2aY_SbkdBUarHN8DqbyQJ7kQ94:aaaaaaaaaaaaaaaaaaaaaa06"
    # "TEMPLATE_ERRORS_BAD_OUTCOME_DATE:1dVDovcIQRsTRps7zC9o9ONgAQWqgGPbgRi3J_Qd_uSs:aaaaaaaaaaaaaaaaaaaaaa07"
    # #edge cases
    # "TEMPLATE_SHEET_EDGE_CASE_TEST_FORMULAS:1ZeVKDTP3WXsWZP_QqRCFVEyViRHvT2-HWlXpnjn4PEc:aaaaaaaaaaaaaaaaaaaaaa08"
    "TEMPLATE_ERRORS_BLOCKING_DATE_ERRORS:1IlVaWuZJXUcNM5JTYt3e6QFIH6NyQgkz0dqZuU-VI6Y:aaaaaaaaaaaaaaaaaaaaaa09"
    "TEMPLATE_ERRORS_NO_BLOCKING_DATE_ERRORS:1e0y_A6exEaCIEfsQoGG2ftbjsd_JjLpavoV8s5TbvdY:aaaaaaaaaaaaaaaaaaaaaa10"
)

SUMMARY_TESTING_SHEETS=(
    # "SUMMARY_SHEET_PRISTINE:15FME8nf1UOonwbPJI2LIuEpQj0z0yz3myicHk1Qi3GM:ffffffffffffffffffffff01"
    # "SUMMARY_SHEET_ID_1:1zC45HEMiSXv_7pIBzMMimena85Vxg8OTfKp3Dym44Ng:ffffffffffffffffffffff02"
    # "SUMMARY_SHEET_ID_2:1VIDaRzlADyRLw0mkKRRBaYvXcAcklfaoR0jDX3yE1r4:ffffffffffffffffffffff03"
    # "SUMMARY_SHEET_ID_3:1_Ef9vL9U4VkBGYf4j3HU7Reh8cMjr15M8DhUvqEwKns:ffffffffffffffffffffff04"
    # "SUMMARY_SHEET_ID_4:1hvUBUAKJJcNxovVX6Rgc40a_EtGbkPoUP_QQmvTD2uo:ffffffffffffffffffffff05"
    # "SUMMARY_SHEET_ID_5:1O3vXajmi9mhVQkx04kz_5F1ilKvwJU8rAWl7MV4UWCk:ffffffffffffffffffffff06"
    # "SUMMARY_SHEET_ID_6:1DOaUZikB_XZutIvznEe1Xti3QiQPOd54Lg-8T9yovYM:ffffffffffffffffffffff07"
    # "SUMMARY_SHEET_ID_7:1zhbDOcjk0U_QjG08L7XA3kqeGaHqJKYUG9KpRNrMLXw:ffffffffffffffffffffff08"
    # "SUMMARY_SHEET_ID_8:1CWOsdqrtYYiQoFkod0Ch40X8a6J8qnZO6AvUD6qgh9k:ffffffffffffffffffffff09"
    # "SUMMARY_SHEET_ID_9:1CWOsdqrtYYiQoFkod0Ch40X8a6J8qnZO6AvUD6qgh9k:ffffffffffffffffffffff10"
    # "SUMMARY_SHEET_ID_10:1aySBavD3jTWqo9_YV9646L002Q4xuwAMMlBx6N-U1ws:ffffffffffffffffffffff11"
    # #random sheet for cory
    # "CORYS_SPECIAL_QA_SHEET:15IeDRth0NNdVesjAhNA7UwmkfZwyLLVT9yjaRZuIGiY:ffffffffffffffffffffff12"
    # "SUMMARY_SHEET_INTRO_OUTCOME_DATE:1iYG59mD3wXTa5RDn0vPQ-VjYDnuJybkNDnplXjyKUKY:ffffffffffffffffffffff13"
    # "TEST_FOR_NETWORKING_ERRORS:16QaT4IM9AvTHNnUOsLpqwogx4sKH2TurZgS6XZY-XIA:ffffffffffffffffffffff14"
)

docker exec -i bc_mongo mongo $MONGO_CONNECTION_URI --eval "db.HistoricalImports.remove({})" &&
# See: https://stackoverflow.com/questions/11776468/create-associative-array-in-bash-3
processTemplates TEMPLATE_TESTING_SHEETS[@] &&
processSummaries SUMMARY_TESTING_SHEETS[@]