Difference between revisions of "CDash:Database"

From KitwarePublic
Jump to: navigation, search
Line 1: Line 1:
 +
= Adding/Changing database fields =
 +
 +
 +
 +
 +
= Automatic translation to PGSQL =
 
The postgres layer in cdash relies on some of the features of the mysqlcompat  
 
The postgres layer in cdash relies on some of the features of the mysqlcompat  
 
package: http://pgfoundry.org/projects/mysqlcompat
 
package: http://pgfoundry.org/projects/mysqlcompat

Revision as of 17:04, 1 August 2010

Adding/Changing database fields

Automatic translation to PGSQL

The postgres layer in cdash relies on some of the features of the mysqlcompat package: http://pgfoundry.org/projects/mysqlcompat

The following patch to the mysqlcompat package is required to use it with recent versions of PostgreSQL: http://public.kitware.com/Wiki/images/d/d0/Mysqlcompat.txt

(Note that this *is* actually a patch file, but the CDash wiki doesn't allow upload of files ending with ".patch".)

Installation on Ubuntu

 apt-get install libsql-translator-perl

Then run the script

 CDash/sql/convert.sh

Warning The indexes generated by the script are all the same so you would need to pre-append the table name.