Table of Contents
command line tool to execute sql in an ordered way.
-
advanced-super-extra-special feature xyz
-
OSS and license
-
works as designed
-
no bugs
- some more or less usefull Github Actions for GH-repo, GH-pages, GH-wiki, CI/CD-Pipelines
- Packagemanager (CPack)
- Installation routine (IFW;DEB;ZIP;TBZ2;RPM)
- portable application
- logrotation included (100KiB)
- runs on DOS/Windows
- runs on MacOS
- runs on Linux
- runs on iOS
- runs on Android
- runs on HarmonyOS
- DB connections for different environments are managed in an (db system) Inifile (e.g.: dev, test, int, prod)
- SQL are defined in an (db sql) Inifile, divided into sections
- each section has an
active-attribute so the section can be de-activated - each section has a
type-definition (e.g.: schema, fdw, db-links, triggers) - each section has an
idso sections with sametype-definition will be sorted ascending for execution - each section has an attribute
sql_stringwhich will be executed in this section first - each section has an attribute
sql_filewhich will executed in this section as second (the sql-file will be parsed and each sql-statement within this file will be executed) - each section has an attribute
sql_pathwhich will executed in this section as third (all sql-files in the defined folder, starting with<number>_<filename>.sqlwill be sorted ascending, parsed and each sql-statement within this file will be executed). SQL-files in this folder without prefix<number>_will be ignored.
- each section has an
Warning
please keep in mind about case sensitivity
Caution
it's highly recommended to encrypt your DB system Inifile.
Encrypt before upload to Git repository
Decrypt before using and encrypt after using
see also: qt-cli_file_encryption-decryption
DB deployments
command line tool to execute sql in an ordered manner
Usage:
db_deploy [OPTION...]
-c, --connect arg <path/to/db_system.ini> with DB connect data
-d, --debug optional: run logging in debug mode
-e, --env arg environment to use, e.g.: dev, int, prod
-s, --sql arg <path/to/sql.ini> with sql instructions
-t, --type arg which type in sql.ini to work on, e.g.: schema, db-links
-v print program version and exit
--version print program information and exit
-h, --help Print help and exitrun the tool and deploy schema definitions in dev environment
./db_deploy -c /iac/photo_gallery/db/db_system.ini -s /iac/photo_gallery/db/deploy/db_sql.ini --env dev --type schema
Caution
it's highly recommended to encrypt your DB system Inifile.
Encrypt before upload to Git repository
Decrypt before using and encrypt after using
see also: qt-cli_file_encryption-decryption
[dev]
id=0
type=system
dbname=photo_gallery
hostname=192.168.178.19
password=IchBinRoot
port=1111
username=postgres
use_proxy=false
db_proxy=
db_proxy_port=
logfile_path=/tmp
[test]
id=1
type=system
dbname=t_photo_gallery
hostname=192.168.178.19
password=photo_gallery
port=1112
username=photo_gallery
use_proxy=false
db_proxy=
db_proxy_port=
logfile_path=/tmp/
[int]
id=2
type=system
dbname=i_photo_gallery
hostname=
password=Top$ecret?
port=
username=master
use_proxy=true
db_proxy=dbproxy-li52y.eu-central-1.aws.cloud
db_proxy_port=5555
logfile_path=/var/log/
[prod]
id=3
type=system
dbname=p_photo_gallery
hostname=
password=2hot4U!
port=
username=master
use_proxy=true
db_proxy=dbproxy-mh81h.eu-central-1.aws.cloud
db_proxy_port=8888
logfile_path=/var/log/Warning
please keep in mind about case sensitivity
[tab1]
id=1
type=schema
name=base
active=true
sql_string=CREATE TABLE IF NOT EXISTS test_users (id INT PRIMARY KEY, name VARCHAR(100));
sql_file=./sql/schemas/base/base_starter.sql
sql_path=./sql/schemas/base
[othertab2]
id=1
type=trigger
name=triggers
active=true
sql_string=
sql_file=./sql/schemas/trigger/trigger_starter.sql
sql_path=
[notab3]
id=2
type=schema
name=base_extended
active=true
sql_string=
sql_file=
sql_path=./sql/schemas/
[betab4]
id=5
type=fdw
name=foreign_data_wrapper
active=false
sql_string=CREATE USER MAPPING FOR master SERVER geoapi OPTIONS (user 'apiuser', password 'admin1234');
sql_file=#./sql/schemas/fdw/geoapi.sql
sql_path=
[istab5]
id=3
type=data
name=test_data
active=true
sql_string=INSERT INTO photo_location(id,continent, country, country_code, province, city, district) VALUES (10,'EU', 'Germoney', 'de', 'Bavaria', 'Munich', 'gma');
sql_file=
sql_path=./sql/data/photo_gallery
[mytab6]
id=3
type=schema
name=mytable3
active=false
sql_string=
sql_file=./test/create_table.sql
sql_path=
[othername]
id=39
type=schema
name=mytable3
active=false
sql_string=
sql_file=
sql_path=#./test
[dotab8]
id=23
type=schema
name=mytable3
active=false
sql_string=
sql_file=
sql_path=./schemasSeveral installation packages are available, depending on your Linux system (deb, rpm, zip, AppImage).
Note
see (latest) Release for packages
Note
All licenses are therefore Open Source.
Conan, software package manager for C and C++ developers
CMake: A Powerful Software Build System
Code Documentation. Automated.
Doxygen Awesome is a custom CSS theme for Doxygen HTML documentation.
This theme is an attempt to update the visuals of Doxygen without changing its overall layout too much.
a lightweight C++ option parser library, supporting the standard GNU style syntax for options.
Note
managed via the package manager
inifile-cpp is a simple and easy to use single header-only ini file en- and decoder for C++.
Note
included in src/includes
Plog - portable, simple and extensible C++ logging library
Note
managed via the package manager
tbd
.
├── .github
│ ├── actions
│ │ └── doctoc
│ │ ├── README.md
│ │ ├── action.yml
│ │ └── dist
│ │ ├── index.js
│ │ ├── index.js.map
│ │ ├── licenses.txt
│ │ └── sourcemap-register.js
│ └── workflows
│ ├── ghp-call_Readme.yml
│ ├── ghp-create_doctoc.yml
│ ├── ghp-markdown_index.yml
│ ├── repo-actions_docu.yml
│ ├── repo-call_Readme.yml
│ ├── repo-create_doctoc.yml_
│ ├── repo-create_doctoc_md.yml
│ └── repo-create_tree_readme.yml
├── .gitignore
├── LICENSE
├── README.md
├── do_compile.sh
├── docs
│ ├── .gitkeep
│ └── img
│ └── console_logs.png
├── src
│ ├── CMakeLists.txt
│ ├── conanfile.txt
│ ├── configure
│ │ ├── ClangTidy.cmake
│ │ ├── Doxygen.cmake
│ │ ├── extra_headers
│ │ └── rz_config.h.in
│ ├── includes
│ │ ├── dotenv.h
│ │ ├── inicpp.h
│ │ ├── rz_config.h
│ │ ├── rz_db.h
│ │ ├── rz_fs.cpp
│ │ ├── rz_fs.h
│ │ ├── rz_inifile.cpp
│ │ ├── rz_inifile.h
│ │ ├── rz_logpath.h
│ │ ├── rz_options.h
│ │ ├── rz_parse_sqlfile.h
│ │ ├── rz_snippets.cpp
│ │ ├── rz_snippets.h
│ │ └── rz_strings.h
│ └── main.cpp
└── tree.bak
11 directories, 42 files
Copyright (c) 2025 ZHENG Robert
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
https://choosealicense.com/licenses/mit/
🖖