[Planner Dev] Migration from libpq to libgda nearly finished

[Alvaro del Castillo <acs barrapunto com>]

Hi guys!

I have find sometime this weekend to do the migration from the libpq
library from Postgres to the more general libgda library in the Planner
database backend.

1. I attach to this email:

1.1. The patch to apply to the current planner CVS
1.2. The document of quality assurance in the migration

2. The work that needs to be done is:

2.1. Complete the error handling in a better way
2.2. Check all the code style
2.3. Check GDA for use UTF8
2.4. Complete the patch with all the ChangeLogs ;-)

Cheers and happy new year!

-- Alvaro

Attachment: planner-gda.diff.gz
Description: GNU Zip compressed data

Testing for the migration from libpq to libgda
----------------------------------------------

To be sure we haven't make any mistakes in the migration
we have followed the next steps:

1. Create a complete project with:
        - Tasks
        - Resources
        - Groups
        - Dependecies
        - Project properties
        - Some modified calendar

2. Save the project, called pq2gda using the XML backend
in a file called "pq2gda.mrproject"

3. Use the libpq backend an save the project in a database called
pq2gda-pq and dump the complete database

4. Use the gda backend and save the project in a database called
pq2gda-gda and dump the complete database

5. Compare the dumps from 3 and 4. The only diffs are the order in
which the registers are saved in the database and that using libpq we
have UTF8 and not with the gda backend for the moment. (pq2gda.diff)

6. Load the pq2gda-pq using the gda backend: OK

7. Load the pq2gda-gda using the libpq backend: OK

< 1	1	Jornada de descanso	Un dםa predeterminado de descanso	f	t
< 2	1	Obra realizבndose	Un dםa de trabajo predeterminado	t	f
> 1	1	Jornada de descanso	Un d?­a predeterminado de descanso	f	t
> 2	1	Obra realiz??ndose	Un d?­a de trabajo predeterminado	t	f
< 2	1	1	t11	(null)	2003-12-28 01:00:00+01	2004-01-01 19:00:00+01	115200	115200	0	f	t	ASAP	\N
< 3	1	1	t12	(null)	2003-12-28 01:00:00+01	2004-01-06 19:00:00+01	201600	201600	0	f	t	ASAP	\N
< 4	\N	1	t2	(null)	2004-01-06 19:00:00+01	2004-01-07 19:00:00+01	28800	28800	0	f	t	ASAP	\N
< 5	\N	1	t3	(null)	2003-12-28 01:00:00+01	2003-12-29 19:00:00+01	28800	28800	0	f	t	ASAP	\N
< 6	5	1	t31	(null)	2003-12-28 01:00:00+01	2003-12-29 19:00:00+01	28800	28800	0	f	t	ASAP	\N
< 7	\N	1	end	(null)	2004-01-07 19:00:00+01	2004-01-13 19:00:00+01	115200	115200	0	f	t	ASAP	\N
> 2	1	1	t11		2003-12-28 01:00:00+01	2004-01-01 19:00:00+01	115200	115200	0	f	t	ASAP	\N
> 3	1	1	t12		2003-12-28 01:00:00+01	2004-01-06 19:00:00+01	201600	201600	0	f	t	ASAP	\N
> 4	\N	1	t2		2004-01-06 19:00:00+01	2004-01-07 19:00:00+01	28800	28800	0	f	t	ASAP	\N
> 5	\N	1	t3		2003-12-28 01:00:00+01	2003-12-29 19:00:00+01	28800	28800	0	f	t	ASAP	\N
> 6	5	1	t31		2003-12-28 01:00:00+01	2003-12-29 19:00:00+01	28800	28800	0	f	t	ASAP	\N
> 7	\N	1	end		2004-01-07 19:00:00+01	2004-01-13 19:00:00+01	115200	115200	0	f	t	ASAP	\N
< 1	1	\N
< 2	2	150
> 1	1	
> 2	2	100
< 4	2	100
> 4	2	150
< 1	1	g2			
< 2	1	g1			
> 1	1	g1			
> 2	1	g2			
< 1	1	1	r3			t	0	0	0	\N
< 2	1	2	r2			t	0	0	0	\N
< 3	1	1	r1	r1 nomail com		t	0	0	0	\N
> 1	1	2	r1	r1 nomail com		t	0	0	0	\N
> 2	1	1	r2			t	0	0	0	\N
> 3	1	2	r3			t	0	0	0	\N
> 1	3	1
< 1	1	1

Attachment: signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente