neveratdennys / postgresqlmigration Goto Github PK

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

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

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.

"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.

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.

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.

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.

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.