execute sql script on database

wgoris

Hi,

Is it possible to launch a database script in sahi? I've seen the functions to execute an update or select on a db, but after my test is finished, I would like to reset my database to the initial status by performing a delete and load.

Thank you in advance.

Best regards,
Werner

Sumitra

Hi wgoris,

You can use delete instead of update to delete or reset the database.

For more details you can follow the below link:

http://sahi.co.in/w/_getDB

Let me know if this solves your issue.

Regards
Sumitra

wgoris

Hi,

Actually I need to execute several sql statements to restore my database to the start sitatuation.

Statements like:
- create procedure...
- drop trigger...
- truncate table...
- load from <file> insert into <table>

All these statements are grouped in a sql file and I would like to launch/execute these statements on the db within sahi.

Sumitra

Hi wgoris,

You can do this:

$contents = _readFile("queries.sql");
rs = _getDB();// connect to ur database
rs.update($contents);

For more details to connect to db:

http://sahi.co.in/w/_getDB

Let me know if this solves your issue.

Regards
Sumitra

wgoris

Hi,

It's not possible to execute the sql statements in the file this way. But I noticed that it's possible to start a stored procedure (routine) on the database with db.update(). So this solves my problem.

I have one last question: in case there goes something wrong, an exception message is send to the console (example: java.sql.SQLException: Routine (restore_dbtest) can not be resolved.) Can I catch this messsage in the code? The command var $string = db.update("Execute procedure restore_dbtest();"); returns null.