How it work

This is dotnet core web application with background worker is based on webhost and uses Kestrel web server and Swagger UI. Kestrel work only by https protocol. Certificate must be stored in “cfg” folder in the file named “aspncert.pfx”. Background worker periodically(see Timeout parameter) polls you database and stores stored procedures and functions into files in local folders (respectively ProjectFolder/P and ProjectFolder/FN). After storing files worker calls git, adds all changes and commits it. If you settings have remote repo worker pushs changes there. Swagger UI is a small and simply interface for manage this application. SCM controller has several actions:

• /api/SCM/GitExec - Execute git command. Has only one parameter – command. Type command and get result. All commands execute on Project folder. For example git status – type status. Strongly not recommended use this action if background service is up.
• /api/SCM/Init GetFull Reload all watching objects from database and reinit repository.(Only in 1.X version)
• /api/SCM/Stop Stop service – stop background worker.
• /api/SCM/Start Start service – start background worker.
• /api/SCM/IsUp Get bgworker status – return true if UP. !!!Important. I do not test ssh features for windows os. Best way for use – Docker.
• /api/SCM/GetSSHKeyPair Get current ssh keypair – copy to cfg folder current keypayr.
• /api/SCM/SSHGen SSH generate new keypair – generate new ssh keypair to %HOME%.ssh folder.
• /api/SCM/LoadSSHKeys Load and copy id_rsa and id_rsa.pub from cfg directory to ./ssh/ Existing files replaced.