neveratdennys / postgresqlmigration Goto Github PK

Prior to /releases/tag/v.1.4 , UpdateScript has prioritized compiling folder contents with .sql files before subfolders.

This behaviour is now corrected in v.1.4, which now prioritize subfolder contents before files in the same level. This is the same as file manager display ordering (usually folders are ranked above files regardless of their names).

However, since this program is meant to order all content according to a 3 digit ascending code to ensure correct ordering, it should be considered a missing feature to correctly rank folder contents.

EXECUTE statements are not handled by AWS except the most simple cases. This addition should handle exec (sp name) (dynamic sql var) USING (var1...), and replace var1... etc with $1... etc in the proceeding string respectively.

"dbo." should only be added to tables under the dbo schema, where as WITH name_for_summary_data AS is a temporary non tables name.
Encountering a WITH block should be tracked and have tracker reset on detecting ";" ; or alternatively the name_for_summary_data keyword should be recorded and specifically look to avoid adding dbo to the keyword.

In sql server, it is typically written as SELECT A = B FROM (...), but this would be seen as a if A equal to B condition and return True or False instead. Some mind of SET A = B syntax needs to be implemented instead and be able to recognize simple (and ONLY simple) cases and automatically add / replace / delete respective items.

Sql server if syntax simply can end, postgres if needs to terminate with end if;. In the future, end case; and end loop; for CASE ... WHEN and loops will also need to be handled.

Setting variable value is completed with a := 0; instead of set a = 0, this means check for set word = words and if ; already terminates the line in case some processing has already happened.

When there are many folders at the same level as the program, the UI runs out of room to display all folders and also pushes the run button to the very bottom where it's not longer accessible. A simple scroll bar should solve this issue.

some utf-8 encoded characters have issues with decoding/encoding with the script, including some invalid characters, this would break the script.

UpdateScript should find files recursively in order to reach all levels under the selected folders.