Pawel Sztromwasser wrote: > Hi, > > While testing migration I found out that items deleted in BASE1 are > migrated to BASE2. As I understand from documentation, BASE1 doesn't > delete items from the database unless purgeDatabase.php script is > executed. They are just flagged as deleted by setting remove value=2 (or > > 1 maybe). Those that have removed flag set to 1 are marked for > deletion (something equivalent to moving to trashcan). Other items have > removed=0. > > Migration code uses ResultSet.getBoolean() method to retrieve 'removed' > value (which is smallint) and as I checked, it returns true only when > removed==1. The consequence is that items marked for deletion go to > trashcan as they suppose to, but those actually deleted get removed flag > set to false and appear in BASE2 as not deleted. > > This could be due to postgres JDBC driver handling type mapping in > different way than mysql driver, but I couldn't find any information on > that. The quick solution is to run purgeDatabase.php before migration to > remove deleted items from the database.
I didn't know that. I simply assumed that the removed flag only could be 0 or 1. Kind of like in BASE2. In any case, the 2.6 release was the latest release of the migration program. It will still be included in future releases, but we will not test or actively maintain it anymore. The reason for this is that we are moving our servers to BASE 2, and at some time in the future we will not have a BASE 1 server to use for testing the migration. Should any remaining critical bugs appear we will of course assist in fixing it. /Nicklas ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ basedb-devel mailing list basedb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/basedb-devel
