Forum OpenACS Q&A: Calendar question

Collapse
1: Calendar question
Posted by Andrew Zeon on 09/23/02 11:35 AM
cal-item-procs.tcl seems to use plsql (Oracle) to interact with the
db. However, I'm using Postgres so where can I find the equivalent
file that uses pl/pgsql?

Thanks.

Collapse
2: Response to Calendar question (response to 1)
Posted by Jeff Davis on 09/23/02 11:46 AM
the sql you see in the .tcl file is not actually used.  The query
is looked up in one of the cal-item-procs*.xql (the actual query
invoked is either in cal-item-procs-postgresql.xql or, if it is DB
independent, cal-item-procs.xql).  I think yanking the queries out
of the tcl is planned but it has not happened yet (and their existence
is generally a source of great confusion for anyone new to openacs).
Collapse
3: Response to Calendar question (response to 1)
Posted by James Darwin on 09/23/02 12:41 PM
Then how are the queries in the cal-item-procs.tcl ignored? Is the
file used at all?

Thanks.

Collapse
4: Response to Calendar question (response to 1)
Posted by Jeff Davis on 09/23/02 01:00 PM
the tcl code is executed and when database calls are made the query dispatcher substitutes the query from the .xql file and if it does not find anything to substitute it will use the query you see in the .tcl file. This is how it supports multiple databases. Ultimately I think the intent is to remove the query text from the tcl files (although I don't know when that will happen).

You can read more in this thread... https://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0005OL&topic_id=12