CDash:Database: Difference between revisions

From KitwarePublic
Jump to navigationJump to search
No edit summary
No edit summary
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 22: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.