Servoy Forum

hi!

I am writing an method to restore the database tables. my input is a zip file that contains the data(insert scripts). I am not allowed to use pgAdmin. What is the best approach insert these data in the database and synchronize the sequences?

e.g.
table:address
column:
idaddress (servoy_seq)
street
city

script to execeute:
INSERT INTO address (idaddress, street, city) VALUES (8, '2 Rawson Street', 'Sydney');
where 8 is from the idaddress when the backup was performed.

rogel wrote:script to execeute:
INSERT INTO address (idaddress, street, city) VALUES (8, '2 Rawson Street', 'Sydney');
where 8 is from the idaddress when the backup was performed.

you can execute this SQL directly via the RawSQL plugin (shipped by default)
Be careful when reading the textfile: huge textfiles can make you hit the max of memory available.

As for synchronizing the sequences: I'm not familiar with that, as I never use the servoy sequences...
Anyone else on this?

mboegem wrote:

rogel wrote:script to execeute:
INSERT INTO address (idaddress, street, city) VALUES (8, '2 Rawson Street', 'Sydney');
where 8 is from the idaddress when the backup was performed.

you can execute this SQL directly via the RawSQL plugin (shipped by default)
Be careful when reading the textfile: huge textfiles can make you hit the max of memory available.

As for synchronizing the sequences: I'm not familiar with that, as I never use the servoy sequences...
Anyone else on this?

Thanks Marc. What would you suggest a better way to read the SQL file than readTextFile?

rogel wrote:What would you suggest a better way to read the SQL file than readTextFile?

Take a look at this old post.
viewtopic.php?f=3&t=6485


Hope this helps.

ROCLASI wrote:

rogel wrote:What would you suggest a better way to read the SQL file than readTextFile?

Take a look at this old post.
https://forum.servoy.com/viewtopic.php?f=3&t=6485


Hope this helps.

Helpful. Thanks! =)

What if the file is in XML format with nodes of tablename and columns? I am stuck with using readTxtFile(). Any other suggestion?

Code: Select all

<statelist><state><id>1</id><code>nsw</code><name>new south wales</name></state></statelist>