[Cdash] database support in cdash

[Julien Jomier]

Markus,

This is great.

Here's what I suggest:

1) We transform the classes to make use of PDO
2) We modify the installation to support PostgreSQL
3) We create a Utilities/PDO directory where we put the translation files.

I think we should start first with PostGreSQL and make sure that it 
works, I'm a little bit hesitant to put the other database support 
without testing them first.

If you can start a wiki page describing how to use the sql translator 
that would be great.

I'm going to try to implement the PDO support today or tomorrow.

Thanks again,
Julien

Markus Grabner wrote:
> Am Montag, 30. Juni 2008 schrieb Julien Jomier:
>> Markus,
>>
>> Thanks a lot. I'm going to implement your modifications this week or
>> maybe next week.
>>
>> Could you send me the translated .sql files for PostGres? I want to test
>>   the installation process.
> Here you are! It's the "CDash/trunk/sql" directory including the original and 
> transformed code. Note that the creation of the administrator account 
> (cdashdata.sql) can't be processed in the same way since only data definition 
> statements are translated. Since it is only a single line I do not consider 
> this a serious issue :-)
> 
>> What do you want to check into the CDash repository? I think the best is
>> probably to upload on the Wiki and put a description.
> The transform script (in particular for the PHP code) will probably undergo 
> some modifications until it works properly, so I think it should be in the 
> repository (e.g., in a subdirectory "trunk/pdo"). The translated SQL code 
> could also be stored in the repository, so people can have a look without 
> having to install SQL-Translator themselves (which took me several hours, 
> including all the perl dependencies and the patching). The wiki is certainly 
> a good place to document the transform stuff.
> 
> 	Kind regards,
> 		Markus
> 
>