• last updated 50 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Bookmark delete is working

    • -1
    • +1
    ./packages/bookmarks/www/bookmark-delete-2.tcl

added .xql files.

    • -54
    • +535
    ./packages/ecommerce/ecommerce.info
Chugging allong in porting. form-procs (huge file!) is 89% done.

    • -6
    • +6
    ./packages/cms/tcl/content-method-procs.tcl
    • -5
    • +65
    ./packages/cms/tcl/form-procs-oracle.xql
    • -6
    • +66
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -82
    • +98
    ./packages/cms/tcl/form-procs.tcl
    • -0
    • +148
    ./packages/cms/tcl/form-procs.xql
Working on bookmark-delete

    • -0
    • +18
    ./packages/bookmarks/www/bookmark-delete-2-oracle.xql
    • -0
    • +19
    ./packages/bookmarks/www/bookmark-delete-2-postgresql.xql
    • -0
    • +15
    ./packages/bookmarks/www/bookmark-delete-oracle.xql
    • -0
    • +20
    ./packages/bookmarks/www/bookmark-delete-postgresql.xql
    • -0
    • +12
    ./packages/bookmarks/www/bookmark-delete.xql
histori commit

    • -1
    • +10
    ./packages/cms/tcl/form-procs-oracle.xql
    • -28
    • +41
    ./packages/cms/tcl/form-procs-postgresql.xql
Historic commit

added missing <queryset> tag

Fixed typo

Fixed typo

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

    • -6
    • +3
    ./packages/ecommerce/tcl/ecommerce-procs.xql
    • -2
    • +3
    ./packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/orders/void-2.tcl

Fixed .xql files.

    • -8
    • +6
    ./packages/ecommerce/www/checkout-2.xql
    • -7
    • +8
    ./packages/ecommerce/www/shopping-cart.xql

Initial Commit of .xql files.

Initial commit of www directory. Admin directory ported but not root directory.

    • -0
    • +41
    ./packages/ecommerce/www/account-oracle.xql
    • -0
    • +20
    ./packages/ecommerce/www/account-postgresql.xql
    • -0
    • +45
    ./packages/ecommerce/www/account.xql
    • -0
    • +89
    ./packages/ecommerce/www/category-browse-subcategory.xql
    • -0
    • +86
    ./packages/ecommerce/www/category-browse-subsubcategory.xql
    • -0
    • +86
    ./packages/ecommerce/www/category-browse.xql
    • -0
    • +28
    ./packages/ecommerce/www/checkout-2-oracle.xql
    • -0
    • +70
    ./packages/ecommerce/www/checkout-2.xql
    • -0
    • +20
    ./packages/ecommerce/www/checkout-3-oracle.xql
    • -0
    • +20
    ./packages/ecommerce/www/checkout-3-postgresql.xql
    • -0
    • +46
    ./packages/ecommerce/www/checkout-3.xql
    • -0
    • +20
    ./packages/ecommerce/www/checkout-oracle.xql
    • -0
    • +20
    ./packages/ecommerce/www/checkout-postgresql.xql
    • -0
    • +35
    ./packages/ecommerce/www/checkout.xql
    • -0
    • +13
    ./packages/ecommerce/www/credit-card-correction-2-oracle.xql
  1. … 76 more files in changeset.

Initial commit of tcl directory. No porting has been done in this directory.

    • -0
    • +19
    ./packages/ecommerce/tcl/ec-audit-trail-procs-oracle.xql
    • -0
    • +19
    ./packages/ecommerce/tcl/ec-audit-trail-procs-postgresql.xql
    • -0
    • +26
    ./packages/ecommerce/tcl/ec-audit-trail-procs.xql
    • -0
    • +15
    ./packages/ecommerce/tcl/ec-style-procs.xql
    • -0
    • +51
    ./packages/ecommerce/tcl/ecommerce-credit-procs-oracle.xql
    • -0
    • +51
    ./packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql
    • -0
    • +50
    ./packages/ecommerce/tcl/ecommerce-credit-procs.xql
    • -0
    • +49
    ./packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql
    • -0
    • +49
    ./packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql
    • -0
    • +37
    ./packages/ecommerce/tcl/ecommerce-customer-service-procs.xql
    • -0
    • +92
    ./packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql
    • -0
    • +92
    ./packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql
    • -0
    • +190
    ./packages/ecommerce/tcl/ecommerce-email-procs.xql
    • -0
    • +20
    ./packages/ecommerce/tcl/ecommerce-money-computations-procs-oracle.xql
    • -0
    • +20
    ./packages/ecommerce/tcl/ecommerce-money-computations-procs-postgresql.xql
  1. … 18 more files in changeset.

Initial commit of root www directory. admin has been completely ported with the exception of dynamic queries and admin/products/add-4-postgresql.xql. No testing has been done yet.

    • -0
    • +20
    ./packages/ecommerce/www/register/awaiting-approval.xql
    • -0
    • +13
    ./packages/ecommerce/www/register/banned-user.xql
    • -0
    • +13
    ./packages/ecommerce/www/register/deleted-user.xql
    • -0
    • +22
    ./packages/ecommerce/www/register/email-confirm.xql
    • -0
    • +27
    ./packages/ecommerce/www/register/email-password-2.xql
    • -0
    • +18
    ./packages/ecommerce/www/register/email-password-3.xql
    • -0
    • +11
    ./packages/ecommerce/www/register/email-password.xql
    • -0
    • +24
    ./packages/ecommerce/www/register/restore-user.xql
    • -0
    • +14
    ./packages/ecommerce/www/register/user-login.xql
    • -0
    • +13
    ./packages/ecommerce/www/register/user-new-2-oracle.xql
    • -0
    • +13
    ./packages/ecommerce/www/register/user-new-2-postgresql.xql
    • -0
    • +11
    ./packages/ecommerce/www/register/user-new-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
    ./packages/ecommerce/www/admin/audit-table-oracle.xql
    • -0
    • +17
    ./packages/ecommerce/www/admin/audit-table-postgresql.xql
    • -0
    • +50
    ./packages/ecommerce/www/admin/index.xql
    • -0
    • +13
    ./packages/ecommerce/www/admin/restore-one-id-oracle.xql
    • -0
    • +13
    ./packages/ecommerce/www/admin/cat/category-add-0.xql
    • -0
    • +16
    ./packages/ecommerce/www/admin/cat/category-add-2-oracle.xql
    • -0
    • +21
    ./packages/ecommerce/www/admin/cat/category-add-2.xql
    • -0
    • +13
    ./packages/ecommerce/www/admin/cat/category-add-oracle.xql
    • -0
    • +13
    ./packages/ecommerce/www/admin/cat/category-add.xql
    • -0
    • +76
    ./packages/ecommerce/www/admin/cat/category-delete-2.xql
    • -0
    • +18
    ./packages/ecommerce/www/admin/cat/category-edit-oracle.xql
  1. … 319 more files in changeset.

Ported data models for PostgreSQL. The data model create and drop scripts load without errors. *-sws not ported because it is not loaded by ecommerce-create.sql.

    • -0
    • +50
    ./packages/ecommerce/sql/postgresql/ec-product-sws-drop.sql
    • -0
    • +288
    ./packages/ecommerce/sql/postgresql/ec-product-sws-setup.sql
    • -0
    • +3344
    ./packages/ecommerce/sql/postgresql/ecommerce-create.sql
    • -0
    • +266
    ./packages/ecommerce/sql/postgresql/ecommerce-defaults.sql
    • -0
    • +267
    ./packages/ecommerce/sql/postgresql/ecommerce-drop.sql
    • -0
    • +4
    ./packages/ecommerce/sql/postgresql/pl-sql-utilities-drop.sql
    • -0
    • +77
    ./packages/ecommerce/sql/postgresql/pl-sql-utilities.sql

oops, I accidently committed the PostgreSQL version of this file into the Oracle sql directory. This commit is to fix my error.

    • -1486
    • +1326
    ./packages/ecommerce/sql/oracle/ecommerce-create.sql
ported to PostgreSQL, loads without error, not tested in any other way

    • -1326
    • +1486
    ./packages/ecommerce/sql/oracle/ecommerce-create.sql

removed logical_negation because it was already defined in utilities-create.sql in acs-kernel

removed definition of logical_negation because it is already defined in utilities-create.sql in acs-kernel

code cleanup

forgot a -

minor bugfixes

added perms assignment to __new

removed a drop fxn statement

removed aD code

    • -2
    • +21
    ./packages/notes/sql/postgresql/notes-drop.sql
removed aD code

improved comments

re-enabled acs-messaging snippet

    • -1
    • +1
    ./packages/download/www/one-archive.tcl
    • -2
    • +1
    ./packages/download/www/one-revision.tcl
Cleaned datamodel (number->numeric)

initial revision