grails delete all data from table / domain class, i.e. "deleteAll"

grails gorm
Ray picture Ray · Nov 17, 2011 · Viewed 20.8k times · Source

I've got a domain class, Widget, that I need to delete all instances out of -- clear it out. After that, I will load in fresh data. What do you suggest as a mechanism to do this?

P.S. Note this is not at bootstrap time, but at "run-time".

Answer

ataylor picture ataylor · Nov 17, 2011

The easiest way is to use HQL directly:

DomainClass.executeUpdate('delete from DomainClass')

Related questions

Why do I get a "Null value was assigned to a property of primitive type setter of" error message when using HibernateCriteriaBuilder in Grails

I get the following error when using a primitive attribute in my grails domain object: Null value was assigned to a property of primitive type setter of MyDomain.myAttribute org.hibernate.PropertyAccessException: Null value was assigned to a property of …

Read More
Found shared references to a collection org.hibernate.HibernateException

I got this error message: error: Found shared references to a collection: Person.relatedPersons When I tried to execute addToRelatedPersons(anotherPerson): person.addToRelatedPersons(anotherPerson); anotherPerson.addToRelatedPersons(person); anotherPerson.save(); person.save(); My domain: Person { static hasMany = [relatedPersons:Person]; } any idea …

Read More
How to order by more than one field in Grails?

Is there a way to get a list ordered by two fields, say last and first names? I know .listOrderByLastAndFirst and .list(sort:'last, first') won't work.

Read More