﻿
 .----------------.  .----------------.  .----------------.  .----------------.  .----------------.  .----------------.  .----------------.  .----------------.  .----------------. 
| .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. |
| |    ___       | || |   _____      | || |     _____    | || |   ______     | || |  _________   | || |  _______     | || |      __      | || |     ______   | || |  _________   | |
| |  .'   '.     | || |  |_   _|     | || |    |_   _|   | || |  |_   _ \    | || | |_   ___  |  | || | |_   __ \    | || |     /  \     | || |   .' ___  |  | || | |_   ___  |  | |
| | /  .-.  \    | || |    | |       | || |      | |     | || |    | |_) |   | || |   | |_  \_|  | || |   | |__) |   | || |    / /\ \    | || |  / .'   \_|  | || |   | |_  \_|  | |
| | | |   | |    | || |    | |   _   | || |      | |     | || |    |  __'.   | || |   |  _|  _   | || |   |  __ /    | || |   / ____ \   | || |  | |         | || |   |  _|  _   | |
| | \  `-'  \_   | || |   _| |__/ |  | || |     _| |_    | || |   _| |__) |  | || |  _| |___/ |  | || |  _| |  \ \_  | || | _/ /    \ \_ | || |  \ `.___.'\  | || |  _| |___/ |  | |
| |  `.___.\__|  | || |  |________|  | || |    |_____|   | || |  |_______/   | || | |_________|  | || | |____| |___| | || ||____|  |____|| || |   `._____.'  | || | |_________|  | |
| |              | || |              | || |              | || |              | || |              | || |              | || |              | || |              | || |              | |
| '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' |
 '----------------'  '----------------'  '----------------'  '----------------'  '----------------'  '----------------'  '----------------'  '----------------'  '----------------' 
																					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