|Problems? Is your data what you think it is?|
Perl DBI: problems inserting data to a tableby homeveg (Acolyte)
|on Nov 20, 2013 at 16:57 UTC||Need Help??|
homeveg has asked for the
wisdom of the Perl Monks concerning the following question:
I am currently trying to use a perl DBI module to store my data in dbi:DBM:mldbm=Storable database.
Original data is loaded from a text file using RegExps. The resulting table contains about 5k rows and several columns and does not have any missing values.
My problem is that while I am parsing the data to a database, only some rows from my original table are converted to a DB entree and, unfortunately, I don't see the reason for that.
I will be very grateful for any help or ideas how to overcome this obstacle.
Here is simplified code I am having problems with:
In the result, I've got only 107 from 4800 rows parsed and I did not get any warning or error message.
Thanks in advance for your help!
UPDATEI have found a problem - in my case it was the Storable driver. I created new SQLite DB and my code works now.
Thanks to everybody for your help!