#!/bin/zsh
#
#   TITLE:          concatSQL.sh
#   VERSION:        1-001
#   FACILITY:       concatenate table-level SQL files
#   AUTHOR(S):      Hlaszny, Edit PhD (+36 30 3116516, edit.hlaszny@gmail.com)
#   SUPERVISED BY:  -
#   CREATION DATE:  15-NOV-2024
#   ENVIRONMENT:    MySQL Server 8.0.30
#                   Version 8.0.31 build 2235049 CE (64 bits) Community
#                   MySQL Workbench 8.0
#                   on macOS Monterey Version 12.5.1
#                   Model Name: iMac
#                   Model Identifier: iMac17,1
#                   Processor Name:	Quad-Core Intel Core i5
#                   (Be careful with MySQL Server and MySQL Workbench.
#                   There are several version incompatibilities)
#
#   DESIGN ISSUES:  The MySQL Server and MySQL Workbench version
#                   incompatibilities mentioned above
#
#   PORTABILITY ISSUES:     none
#   SUBSYSTEM:              none
#
#   MODIFICATION HISTORY:
#       date        modified by version
#       15-NOV-2024 Hlaszny     1-001    first draw
#       18-DEC-2024 Hlaszny     2-001    some cosmetics
#       21-DEC-2024 Hlaszny     2-002    FK constraints: concat order
#
cat create_00_dbfontomaestro.sql              \
    upload_01_BFO_annotations.sql             \
    upload_06_IAO_annotations.sql             \
    upload_14_owl_classes.sql                 \
    upload_02_class_annotations.sql           \
    upload_03_data_properties.sql             \
    upload_04_data_property_annotations.sql   \
    upload_05_disjoint_classes.sql            \
    upload_08_object_properties.sql           \
    upload_07_inverse_object_properties.sql   \
    upload_09_object_property_annotations.sql \
    upload_10_super_object_properties.sql     \
    upload_11_ontology_header_annotations.sql \
    upload_12_ontology_header.sql             \
    upload_13_ontology_trailer.sql            \
    upload_15_triplets.sql > DBFOntoMaestro.sql
#
echo "the result is "
ls -al DBFOntoMaestro.sql
#
#   end of concatSQL.sh
#