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

Staring work with query porter and xql files. Done queries in tcl, and index files in www...

    • -0
    • +49
    /openacs-4/packages/bookmarks/tcl/bookmarks-init-oracle.xql
    • -0
    • +14
    /openacs-4/packages/bookmarks/tcl/bookmarks-init.xql
    • -0
    • +87
    /openacs-4/packages/bookmarks/tcl/bookmarks-procs-oracle.xql
    • -0
    • +20
    /openacs-4/packages/bookmarks/tcl/bookmarks-procs.xql
    • -0
    • +49
    /openacs-4/packages/bookmarks/www/index-oracle.xql
    • -0
    • +58
    /openacs-4/packages/bookmarks/www/index-postgresql.xql
    • -0
    • +18
    /openacs-4/packages/bookmarks/www/index.xql

Initial data model changes for OpenACS (Postgres added). bookmark.info

also updated. www files not yet touched

Changed parameters to use the new "p_" convention, for the most part.

fixed bug that disallowed html input

fixed ttl_v_users view that i had mistakenly changed

first attempt at doing XML parsing using ns_xml instead of the Tcl XML stuff. Not sure yet if this is faster, although we expect that it will be. Note also that there seems to be a bug right now in ns_xml where an XML comment will screw things up, so I've added a quick prepare function that takes out comments before XML parsing... I'm not happy about that.

    • -31
    • +94
    /openacs-4/packages/acs-tcl/tcl/apm-xml-procs.tcl
more cleanup

fixed logging to be more configurable within the QD and default to not so verbose.

took out fixme comments that were completed

fixed outer join

1. Fixed a couple of .info files

2. Got rid of Ben's hack to always reload query files before doing a query

mapping. He did this so you wouldn't have to reboot AOLserver every

time you change query files. It was a short-term hack but unfortunately

it looped virgin installs.

3. Added code to the APM to make the "watch" feature work with query files

as well as library files. This makes Ben's hack mentioned above

unnecessary.

fixed parameter overlap

fixed typo

Some notes on general-comments porting progres

updated .info file

Fully ported postgresql datamodel

Not much testing was done

ported queries

  1. … 48 more files in changeset.
ported datamodel to pg

more cleanup of template queries

    • -2
    • +2
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -1
    • +1
    /openacs-4/packages/cms/tcl/publish-procs.tcl
    • -3
    • +3
    /openacs-4/packages/cms/tcl/user-procs.tcl
    • -1
    • +1
    /openacs-4/packages/cms/tcl/widget-procs.tcl
    • -3
    • +3
    /openacs-4/packages/cms/www/register.tcl
    • -1
    • +1
    /openacs-4/packages/cms/www/signin.tcl
  1. … 13 more files in changeset.
cleanup of db api queries

    • -1
    • +0
    /openacs-4/packages/cms/www/register.tcl
    • -19
    • +15
    /openacs-4/packages/cms/www/signin.tcl
  1. … 11 more files in changeset.
ported dynamic queries and general cleanup

  1. … 5 more files in changeset.
forces reload of query file every time a query is executed; slow for now, but more correct for development

ported dynamic queries

added new queryfiles

    • -0
    • +25
    /openacs-4/packages/cms/www/modules/search/index.xql
    • -0
    • +15
    /openacs-4/packages/cms/www/modules/search/search-results.xql
    • -0
    • +13
    /openacs-4/packages/cms/www/modules/sitemap/attributes.xql
    • -0
    • +52
    /openacs-4/packages/cms/www/modules/sitemap/copy-oracle.xql
    • -0
    • +45
    /openacs-4/packages/cms/www/modules/sitemap/create-oracle.xql
  1. … 122 more files in changeset.
new queryfiles

    • -0
    • +18
    /openacs-4/packages/cms/www/modules/items/attributes-edit.xql
    • -0
    • +20
    /openacs-4/packages/cms/www/modules/items/attributes.xql
    • -0
    • +36
    /openacs-4/packages/cms/www/modules/items/comments-oracle.xql
    • -0
    • +20
    /openacs-4/packages/cms/www/modules/items/content-add-1.xql
    • -0
    • +18
    /openacs-4/packages/cms/www/modules/items/content-add-2.xql
  1. … 69 more files in changeset.
new queryfiles

    • -0
    • +31
    /openacs-4/packages/cms/www/modules/categories/edit-oracle.xql
    • -0
    • +17
    /openacs-4/packages/cms/www/modules/categories/index.xql
    • -0
    • +25
    /openacs-4/packages/cms/www/modules/categories/move.xql
new queryfiles

    • -0
    • +27
    /openacs-4/packages/cms/www/item/create-oracle.xql
    • -0
    • +51
    /openacs-4/packages/cms/www/item/create-postgresql.xql
new queryfiles

    • -0
    • +13
    /openacs-4/packages/cms/www/head.xql
    • -0
    • +18
    /openacs-4/packages/cms/www/index.xql
    • -0
    • +51
    /openacs-4/packages/cms/www/register-oracle.xql
    • -0
    • +52
    /openacs-4/packages/cms/www/register-postgresql.xql
    • -0
    • +14
    /openacs-4/packages/cms/www/register.xql
more porting of templating queries and raw db api queries

    • -21
    • +21
    /openacs-4/packages/cms/www/register.tcl
    • -9
    • +6
    /openacs-4/packages/cms/www/item/create.tcl
  1. … 15 more files in changeset.
converted template db api queries

  1. … 39 more files in changeset.