[SM-DEVEL] Re: Auto migration of file prefs and abooks to a Database

[Daniel W. <d...@ni...>]

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
>>Hi,
>>
>>
>>I can't find it but I'm sure I read about this.
>>
>>
>>Is it true or not that if you have been using files for userprefs and
>>addressbook that if you give squirrelmail a database table to now use that
>>it will move all the data into the table?
>>
>>If not - would this not be rather sensible?
>>
>>
>>I understand that this is DEFINTIELY the case for a hashed data_dir - if
>>you change the hashing level then new files are moved into the correct
>>place automatically.
>>
>>It wouldn't be too hard to see if that particular user has any entries
>>in the database table, if not look for a file in the data_dir and if not
>>then load in the defaults. Same for both abook and prefs.
>>
>>Perhaps deleting the old file or perhaps not - some might want the old
>>info preserved whilst they make sure the db system works ok.
>>
>>In the event the above is not the case and is not going to be
>>implemented anytime soon in stable (I'm on the 1.4.4 branch) does any
>>helpful person out there have a script that will migrate the data into the
>>db? Hopefully one that will avoid overwriting, creating duplicates etc?
> 
> 
> it would require loading two conflicting function libraries.

Is it not worth making the libraries non-conflicting? Or are you trying 
to avoid the overhead from having a program that can handle files and 
databases at the same time? surely it's not that big a deal - most of 
the time the DSNs are not set so the db stuff can be ignored. Once the 
DSNs are set it will eventually come down to a quick check of the 
data_dir to see if it is empty. If not then it slurps it up. From then 
on you are looking at one extra check upon login.

> 
> Search for flat2sql perl script in SquirrelMail gmane archives.
> 
> http://search.gmane.org/search.php?query=flat2sql&email=&group=gmane.mail.squirrelmail.user&sort=date

Thank you.
Daniel