qliberace/qdr.app.qlbrc.console


.----------------. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------.
| .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. |
| | ___ | || | _____ | || | _____ | || | ______ | || | _________ | || | _______ | || | __ | || | ______ | || | _________ | |
| | .' '. | || | |_ _| | || | |_ _| | || | |_ _ \ | || | |_ ___ | | || | |_ __ \ | || | / \ | || | .' ___ | | || | |_ ___ | | |
| | / .-. \ | || | | | | || | | | | || | | |_) | | || | | |_ \_| | || | | |__) | | || | / /\ \ | || | / .' \_| | || | | |_ \_| | |
| | | | | | | || | | | _ | || | | | | || | | __'. | || | | _| _ | || | | __ / | || | / ____ \ | || | | | | || | | _| _ | |
| | \ `-' \_ | || | _| |__/ | | || | _| |_ | || | _| |__) | | || | _| |___/ | | || | _| | \ \_ | || | _/ / \ \_ | || | \ `.___.'\ | || | _| |___/ | | |
| | `.___.\__| | || | |________| | || | |_____| | || | |_______/ | || | |_________| | || | |____| |___| | || ||____| |____|| || | `._____.' | || | |_________| | |
| | | || | | || | | || | | || | | || | | || | | || | | || | | |
| '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' |
'----------------' '----------------' '----------------' '----------------' '----------------' '----------------' '----------------' '----------------' '----------------'
CONSOLE v.0.0.0
Modified: 18.9.2022

Commands list:
* Testing *

workbench - Runs worbench code

* Database *
db_install - Install application database (even if not exists)
db_update - Install application database updates (must exists)
db_clear - Clears all data in database (reset to factory defaults)
db_uninstall - Drop database



db_install
----------
description:
Creates a brand new QLiberace database with initial schemas, depends on connection string definition (.config)

arguments mandatory:

arguments optional:
-latest - call db_update after create database (migrate to latest version)

exit codes:
0 Ok
1 Database already axists
10 Cannot connect to server
100 Other unhandled exception


db_update
----------
description:
Install all pending updates to existing database (database must exists, keeps existing data)

arguments mandatory:
-list - list all pendings updates, nothing will be applied (just list)

arguments optional:


exit codes:
0 Ok
1 Database doesn't exists
10 Cannot connect to server
100 Other unhandled exception

db_clear
----------
description:
Clears all data in database (reset to factory defaults), deletes and create database during the process.

arguments mandatory:

arguments optional:


exit codes:
0 Ok
10 Cannot connect to server
100 Other unhandled exception

db_uninstall
----------
description:
Delete database if exists.

arguments mandatory:

arguments optional:


exit codes:
0 Ok
1 Database doesn't exists
10 Cannot connect to server
100 Other unhandled exception