Hi Max
As I try to program putting rowid, more things break so I'm thinking that is
not the way to go.
I now think that the select call to the database needs to sort the results but
I can't seem to follow how that is done in the exportDB function.
Dave
----- Original Message -----
From: blainedw
Sent: 08/08/2014 01:52 PM AST
To: "Users' Help and Suggestions" <openca-users@lists.sourceforge.net>
Subject: Re: [Openca-Users] Backup and restore from OpenCA 1.0.2 to 1.5.1 -
sort order problems
Hi Max
>I think you are right. I just checked the code and it seems that the
export function does not keep the same order as the original db, but it
saves the objects by using the serial as >their prefix in the filesystem
(from export-import.lib):
>
> my $serial = $object->getSerial ($datatype [0]);
>
>That means when the objects are re-read to be imported, the order of
insertion is derived from the serials' sorting (when readdir is used on
the different object's sub-directories).
>
>This is definitely the origin of the error.
>
>To fix that, we need to write a patch that adds, in front of the
filename, the rowid - this should naturally provide the same order in
import and export, thus obtaining the same >relative rowid order (not the
same rowid as that is an auto-increment field).
I have tried programming this patch to no avail. Any help would be
appreciated.
Dave
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
