xhergz / mymngr Goto Github PK

Create a full backup of the database into the backups file in the MyMNGR directory.

Acceptance Criteria:

• Creates a full .bak backup file of the database

Bonus:

• Doesn't use individual inserts for restoring data like it does currently because this takes forever

I was trying to just reload a profile. There is no option to reload and no option to close. I would have to either open the same profile again (works fine) or close the whole app and re open.

Add a close profile option to the file menu + toolbar
Add a reload profile option to the file menu + toolbar

When creating tables there will be a specific order that we need to deploy in as some tables depend on other tables. Parse the table files and check for foreign key constraints. Foreign key constraints will determine the order that tables are created in.

Acceptance Criteria:

• Parse SQL table files
• Pick up single dependencies
• Pick up multiple dependencies

Bonus:

• Store other table information for future use (name, columns, column types, etc)

Reproduce:
Use the add new alias button in the top right, enter info, click save. Crash.

Expected Result:
Displays an error in the console, possibly suggesting to make sure it's included in the path

Actual Result:
It crashes

Data will be split into multiple files but it would make it easier to reference variables if all data files were combined by the program into one string/file to be ran (so variables are all in the same scope).

Be able to deploy a database to the target server. Files need to be deployed in the following order: Tables, Views, Functions, Stored Procs, Data.

Acceptance Criteria:

• Deploys all components in the correct order with dependencies

I was trying to change the alias used for a profile but there is no way to do it.

Add an option to the toolbar to edit the profile

Trying to deploy the HergBot Auth Server, the database name field in the profile was set to null. This caused the deploy to fail.

Currently it just runs data files in order. Spec should be look for <Table>Data.sql to apply files in that order.

Add a new group of buttons to the right of the database buttons to create the common database folder structure:

• Data
• Functions
• StoredProcedures
• Tables
• Views

Restore a database from a .bak file.

Acceptance Criteria:

• Restores a database from a .bak file
• Doesn't block the whole program? (See what the behaviour is like with a large file)