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

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

Fixed .xql files.

Initial Commit of .xql files.

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

    • -0
    • +41
    /openacs-4/packages/ecommerce/www/account-oracle.xql
    • -0
    • +20
    /openacs-4/packages/ecommerce/www/account-postgresql.xql
    • -0
    • +45
    /openacs-4/packages/ecommerce/www/account.xql
    • -0
    • +86
    /openacs-4/packages/ecommerce/www/category-browse.xql
    • -0
    • +28
    /openacs-4/packages/ecommerce/www/checkout-2-oracle.xql
    • -0
    • +70
    /openacs-4/packages/ecommerce/www/checkout-2.xql
    • -0
    • +20
    /openacs-4/packages/ecommerce/www/checkout-3-oracle.xql
    • -0
    • +20
    /openacs-4/packages/ecommerce/www/checkout-3-postgresql.xql
    • -0
    • +46
    /openacs-4/packages/ecommerce/www/checkout-3.xql
    • -0
    • +20
    /openacs-4/packages/ecommerce/www/checkout-oracle.xql
    • -0
    • +20
    /openacs-4/packages/ecommerce/www/checkout-postgresql.xql
    • -0
    • +35
    /openacs-4/packages/ecommerce/www/checkout.xql
  1. … 76 more files in changeset.

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

    • -0
    • +26
    /openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs.xql
    • -0
    • +15
    /openacs-4/packages/ecommerce/tcl/ec-style-procs.xql
    • -0
    • +50
    /openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs.xql
    • -0
    • +49
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql
    • -0
    • +49
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql
    • -0
    • +190
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql
    • -0
    • +20
    /openacs-4/packages/ecommerce/tcl/ecommerce-money-computations-procs-oracle.xql
    • -0
    • +20
    /openacs-4/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
    • +13
    /openacs-4/packages/ecommerce/www/register/banned-user.xql
    • -0
    • +13
    /openacs-4/packages/ecommerce/www/register/deleted-user.xql
    • -0
    • +22
    /openacs-4/packages/ecommerce/www/register/email-confirm.xql
    • -0
    • +24
    /openacs-4/packages/ecommerce/www/register/restore-user.xql
    • -0
    • +14
    /openacs-4/packages/ecommerce/www/register/user-login.xql
    • -0
    • +11
    /openacs-4/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
    • +50
    /openacs-4/packages/ecommerce/www/admin/index.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.

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

ported to PostgreSQL, loads without error, not tested in any other way

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

removed aD code

improved comments

re-enabled acs-messaging snippet

Cleaned datamodel (number->numeric)

initial revision

updated with vinods patches

workaround for content_item__delete problem related to pg RI problems

fixed acs_objects__get_attribute so that it works with all return types. Problems were encountered with returning integer and timestamp types

fixed context bar query as suggested by Luke Pond

add tree_sortkey to acs_messages to enable hierarchical queries on the reply_to field

took out the join to the acs_objects table. used acs_object__get_attribute to get the necessary queries.

Porting forms-procs. Not done yet (it's a big one). Committing for historic purposes.

    • -0
    • +173
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -0
    • +165
    /openacs-4/packages/cms/tcl/form-procs-postgresql.xql
    • -0
    • +39
    /openacs-4/packages/cms/tcl/form-procs.xql
Still porting. Not done with this file yet (it's a big

one). Committing for history purposes.

    • -42
    • +19
    /openacs-4/packages/cms/tcl/form-procs.tcl
Working my way through porting.

    • -88
    • +38
    /openacs-4/packages/cms/tcl/form-procs.tcl