Hi everybody!
Is there a way to remove all objects ( e.g. entries in the db-tables) via NHibernate? This would be useful for my testcode, since it needs the db to be in a known state.
If i query for all objects and try to remove them in a foreach loop, I always encounter foreign key constraint exceptions from the database.

I'm using PostgreSQL 8.2 and NHibernate 1.2.0 GA

Any ideas are welcome.
Thomas

For each mapped class, do this:

You will have to delete the child classes first to avoid violating foreign key constraint; but at least you are managing it at the class level and not on the object level. It's also not the most efficient, since NHibernate loads each object before deleting it. However, it may suffice for testing when you don't have a lot of data.

I use SchemaExport to blast the db and rebuild the schema for testing...

Hi,

For testing, you can simply run a sql script to drop all the tables.
If you need detailed example, let me know.

yeah, that's actually my plan if everything else fails. The drawback is, that you got to bypass NHibernate and directly access the db. But I guess thats ok for test code.

Thomas

Hi Poseidon,

If you use Oracle, you can run the following sql script:

set echo off
set heading off
spool temp.sql;
select 'drop table ' || table_name || ' cascade constraints ;' from user_tables;
spool off;
set echo on
set heading on
@temp
exit;


-- You can run this script from a batch file that can be issued from your
program code.

my batch file looks like this:
sqlplus -S UserName/Passwd@ServerName/DBName @drop_tables.sql

I hope you will find it helpful.