ormico / dbpatchmanager

Database development tool for change control.
MIT License
6 stars 3 forks source link

codefiles - add undecorated sql to list #10

Open ormico opened 7 years ago

ormico commented 7 years ago

Story: #60

The codefiles section in patches.json lists the file extensions and the order they should be processed in. For example:

  "CodeFiles": [
    "*.view.sql",
    "*.udf.sql",
    "*.view2.sql",
    "*.udf2.sql",
    "*.view3.sql",
    "*.udf3.sql",
    "*.sproc.sql",
    "*.sproc2.sql",
    "*.sproc3.sql",
    "*.trigger.sql",
    "*.trigger2.sql",
    "*.trigger3.sql"
  ],

however we often forget to name a file with the extra decoration and just name it *.sql

  1. would be good to Log files in the Code folder that are skipped b/c they don't match a pattern.
  2. would be nice if we could included .sql. We can't add it now b/c it would include all of the extensions that we already included. For example if you had a file named blah.sproc.sql and you had .sproc.sql and *.sql, blah.sproc.sql would get included twice.

would be better if we kept track of files already processed by earlier patterns and not include them twice.

ormico commented 6 months ago

this list should really come from the plugin