Forum OpenACS Development: Query Extractor Question

Collapse
Posted by Dave Bauer on
Should the query extractor look into the www directory? I am working
on the clickthrough module and the admin pages have many queries. I
was just wondering if the extractor would work on the tcl files for
those pages.
Collapse
Posted by Don Baccus on
Yes, it will.  It is meant to extract queries from all .tcl files in a  package.  If it misses some, let me know ASAP so I can fix it.

If you just give it the package name ("acs-subsite", for instance) and  the right package "home" directory, it will walk all the subdirectories for you ... I hope.

Collapse
Posted by Dave Bauer on
Ok. I re-ran the Query Extractor on clickthrough. It reads it fine and
creates the files for the tcl subdirectory. Surprisingly while it is
working it says it found 13 tcl files, but in the output directory
there is only a tcl subdirectory and then
clickthrough-procs-oracle.xql clickthrough-procs-postgresql-xql and
clickthrough-procs.xql.

I only got 1 error in the log saying duplicate query name.

I only specified the clickthrough package in the config file.

Collapse
Posted by Kapil Thangavelu on
the query extractor is primarily for use on tcl pages which use the
db-api. the clickthrough package uses the redundant template db-api,
which the extractor won't touch. the extractor won't create extra
directories unless it has something to write, hence no www subdir
Collapse
Posted by Dave Bauer on
Ok, Good answer.
Collapse
Posted by Dave Bauer on
Clickthrough also has an index.vuh file. It has one query using db_*
api. Will it work with the query dispatcher is I create the xql files?