readme.txt 3.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192
  1. 
  2. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------. .----------------.
  3. | .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. || .--------------. |
  4. | | ___ | || | _____ | || | _____ | || | ______ | || | _________ | || | _______ | || | __ | || | ______ | || | _________ | |
  5. | | .' '. | || | |_ _| | || | |_ _| | || | |_ _ \ | || | |_ ___ | | || | |_ __ \ | || | / \ | || | .' ___ | | || | |_ ___ | | |
  6. | | / .-. \ | || | | | | || | | | | || | | |_) | | || | | |_ \_| | || | | |__) | | || | / /\ \ | || | / .' \_| | || | | |_ \_| | |
  7. | | | | | | | || | | | _ | || | | | | || | | __'. | || | | _| _ | || | | __ / | || | / ____ \ | || | | | | || | | _| _ | |
  8. | | \ `-' \_ | || | _| |__/ | | || | _| |_ | || | _| |__) | | || | _| |___/ | | || | _| | \ \_ | || | _/ / \ \_ | || | \ `.___.'\ | || | _| |___/ | | |
  9. | | `.___.\__| | || | |________| | || | |_____| | || | |_______/ | || | |_________| | || | |____| |___| | || ||____| |____|| || | `._____.' | || | |_________| | |
  10. | | | || | | || | | || | | || | | || | | || | | || | | || | | |
  11. | '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' || '--------------' |
  12. '----------------' '----------------' '----------------' '----------------' '----------------' '----------------' '----------------' '----------------' '----------------'
  13. CONSOLE v.0.0.0
  14. Modified: 18.9.2022
  15. Commands list:
  16. * Testing *
  17. workbench - Runs worbench code
  18. * Database *
  19. db_install - Install application database (even if not exists)
  20. db_update - Install application database updates (must exists)
  21. db_clear - Clears all data in database (reset to factory defaults)
  22. db_uninstall - Drop database
  23. db_install
  24. ----------
  25. description:
  26. Creates a brand new QLiberace database with initial schemas, depends on connection string definition (.config)
  27. arguments mandatory:
  28. arguments optional:
  29. -latest - call db_update after create database (migrate to latest version)
  30. exit codes:
  31. 0 Ok
  32. 1 Database already axists
  33. 10 Cannot connect to server
  34. 100 Other unhandled exception
  35. db_update
  36. ----------
  37. description:
  38. Install all pending updates to existing database (database must exists, keeps existing data)
  39. arguments mandatory:
  40. -list - list all pendings updates, nothing will be applied (just list)
  41. arguments optional:
  42. exit codes:
  43. 0 Ok
  44. 1 Database doesn't exists
  45. 10 Cannot connect to server
  46. 100 Other unhandled exception
  47. db_clear
  48. ----------
  49. description:
  50. Clears all data in database (reset to factory defaults), deletes and create database during the process.
  51. arguments mandatory:
  52. arguments optional:
  53. exit codes:
  54. 0 Ok
  55. 10 Cannot connect to server
  56. 100 Other unhandled exception
  57. db_uninstall
  58. ----------
  59. description:
  60. Delete database if exists.
  61. arguments mandatory:
  62. arguments optional:
  63. exit codes:
  64. 0 Ok
  65. 1 Database doesn't exists
  66. 10 Cannot connect to server
  67. 100 Other unhandled exception