WDK template site branch and trunk installed

[John Iodice]

Two versions, branch and trunk, of the WDK template site are now installed on faraday.pcbi. One uses the api-build-16 branches of WDKTemplate and the projects it uses (namely WDK, WSF, install, and FgpUtil), and the other is on the trunk.

The api-build-16 branch is a copy I made of a version of the template site that Emily made from ErythronDB (which had itself started out as a copy of WDKTemplate):

http://faraday.pcbi.upenn.edu:8080/wdktemplate/

Then Jerric brought the WDKTemplate trunk up to date directly:

http://faraday.pcbi.upenn.edu:8080/trunkTemplate

-- John

[John Iodice]

Jerric and I discussed this yesterday. It's true the DUAL table doesn't come with PostgreSQL (as it does with Oracle), but it can easily be created:

create table dual as select 'X' as dummy;

The WDK install has separate Oracle- and PostgreSQL-specific SQL scripts for the install. The simplest thing would be to add the above to the PostgreSQL version, persistent_tables_postgres.sql. But, since only the template site needs that, and not the WDK itself, it would be cleaner and more correct to add an SQL script to WDKTemplateSite. I'm planning to do that, and have the install script prompt the user to run it.

Would you (or can I) run the above in the PostgreSQL instance(s) that Jenkins is using?

-- John

On Fri, May 24, 2013 at 2:41 PM, Mark Heiges <mhe...@uga.edu> wrote:

Jenkins tracks the trunk code for an integration site , http://integrate.gusdb.org/ . It uses Postgres. The queries don't work now because, glancing at the logs, there are Oracle-specific "select from dual" sql statements being attempted  (we don't have any routine testing in place so I don't know how long it's been in this state).

> _______________________________________________
> ApiDB mailing list
> Ap...@mail.pcbi.upenn.edu
> http://mail.pcbi.upenn.edu/mailman/listinfo/apidb