I have a lot of data in a MySQL database, I wish to import all this data into the native DBMS of Symbian (e32db). I couldn't find a direct solution for injecting these SQL statements right into the DB so I created a database dump of my MySQL data. Now I'm trying to load all these SQL statements from the dumpfile into e32db but the DBMS just won't import them.
But in my textfile the data is stored as a complete query (no %d notations and stuff).
This doesn't work for instance:
self.db.execute("INSERT INTO cells (country_id, network, cell, cell_range, postcode, plaats, land, latitude, longitude) VALUES ('204','815', '7294606', '0', '6816', 'Arnhem', 'Netherlands', '52.0',5.8)")
Is there another way I can solve this problem? I guess I'm getting a bit lazy since i'm already working on this for two days or so. Is there maybe a direct way to import these queries into e32db?