#!/bin/bash
PASSWORD=$CODECEPT_DB_PASSWORD
HOST=$CODECEPT_DB_HOST
USER=$CODECEPT_DB_USER
DATABASE=$CODECEPT_DB_NAME
DB_FILE=dump.sql

EXCLUDED_TABLES=(
    be_sessions
    cache_md5params
    cache_treelist
    cf_cache_hash
    cf_cache_hash_tags
    cf_cache_imagesizes
    cf_cache_imagesizes_tags
    cf_cache_pages
    cf_cache_pages_tags
    cf_cache_pagesection
    cf_cache_pagesection_tags
    cf_cache_rootline
    cf_cache_rootline_tags
    cf_extbase_datamapfactory_datamap
    cf_extbase_datamapfactory_datamap_tags
    cf_extbase_object
    cf_extbase_object_tags
    cf_extbase_reflection
    cf_extbase_reflection_tags
    cf_extbase_typo3dbbackend_queries
    cf_extbase_typo3dbbackend_queries_tags
    cf_lfeditor_select_options_cache
    cf_lfeditor_select_options_cache_tags
    cf_tx_solr
    cf_tx_solr_configuration
    cf_tx_solr_configuration_tags
    cf_tx_solr_tags
    cf_vhs_main
    cf_vhs_main_tags
    cf_vhs_markdown
    cf_vhs_markdown_tags
    sys_history
    sys_log
    tx_rsaauth_keys
    tx_realurl_uniqalias
    tx_realurl_uniqalias_cache_map
    tx_solr_cache
    tx_solr_cache_tags
    tx_solr_indexqueue_indexing_property
    tx_solr_indexqueue_item
    tx_solr_last_searches
    tx_solr_statistics
)

IGNORED_TABLES_STRING=''
for TABLE in "${EXCLUDED_TABLES[@]}"
do :
   IGNORED_TABLES_STRING+=" --ignore-table=${DATABASE}.${TABLE}"
done

echo "structure"
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --single-transaction --no-data ${DATABASE} --ignore-table=${DATABASE}.be_sessions > ${DB_FILE}

echo "be_sessions structure"
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --single-transaction --skip-add-drop-table --no-data ${DATABASE} be_sessions | sed 's/^CREATE TABLE /CREATE TABLE IF NOT EXISTS /' >> ${DB_FILE}

echo "content"
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} ${DATABASE} --no-create-info ${IGNORED_TABLES_STRING} >> ${DB_FILE}