• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

fixed sort key calculation. postgres driver encloses bind variables in ' ' which makes the sort key calculation fail. the key calculation is done in tcl now.

    • -1
    • +1
    ./cat/subsubcategory-add-2-postgresql.xql

fixed sort key calculations. the postgres driver puts ' ' around the bind variable. the old code performed calculations like "and sort_key = (:prev_sort_key + :next_sort_key)/2", which caused postgres to barf. this calculation is now done in tcl.

    • -1
    • +1
    ./cat/subcategory-add-2-postgresql.xql

fixed oracle sign() calls

fixed issues.tcl. used db_map to handle dynamic queries. rewrote order_by bind variable to use a normal variable with a switch statement to verify the contents. for some reason the bind variable version kept enclosing the order_by variable in ' ' which is not correct.

    • -0
    • +83
    ./customer-service/issues-oracle.xql
    • -0
    • +86
    ./customer-service/issues-postgresql.xql

added missing <queryset> tag

fixed .xql files. changed some db_dmls to db_exec_plsql in .tcl files for queries that call functions or package procedures.

  1. … 4 more files in changeset.

Initial Commit of .xql files.

    • -0
    • +15
    ./mailing-lists/member-add.xql
    • -0
    • +25
    ./mailing-lists/member-remove-2.xql

Initial commit of admin directory. All subdirectories in admin have been ported with the exception of products/add-4-postgresql.xql. Dynamic queries have not been ported yet. Files in the root directory of admin have not been ported yet.

    • -0
    • +17
    ./audit-table-oracle.xql
    • -0
    • +17
    ./audit-table-postgresql.xql
    • -0
    • +13
    ./restore-one-id-oracle.xql
    • -0
    • +13
    ./restore-one-id-postgresql.xql
    • -0
    • +13
    ./cat/category-add-0.xql
    • -0
    • +16
    ./cat/category-add-2-oracle.xql
    • -0
    • +16
    ./cat/category-add-2-postgresql.xql
    • -0
    • +21
    ./cat/category-add-2.xql
    • -0
    • +13
    ./cat/category-add-oracle.xql
    • -0
    • +13
    ./cat/category-add-postgresql.xql
    • -0
    • +13
    ./cat/category-add.xql
    • -0
    • +76
    ./cat/category-delete-2.xql
    • -0
    • +18
    ./cat/category-edit-oracle.xql
    • -0
    • +18
    ./cat/category-edit-postgresql.xql
  1. … 319 more files in changeset.

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +112
    ./audit-table.tcl
    • -0
    • +106
    ./restore-one-id.tcl
    • -0
    • +55
    ./cat/category-add-0.tcl
    • -0
    • +64
    ./cat/category-add-2.tcl
    • -0
    • +62
    ./cat/category-add.tcl
    • -0
    • +122
    ./cat/category-delete-2.tcl
    • -0
    • +44
    ./cat/category-delete.tcl
    • -0
    • +37
    ./cat/category-edit.tcl
    • -0
    • +45
    ./cat/category-swap.tcl
    • -0
    • +104
    ./cat/category.tcl
  1. … 2465 more files in changeset.