In one of the modules that I was working on , I needed to delete the previous data from a table then load up the data into those tables again and then manipulate code through the ‘id’s’ on those tables.
\nSo this is what I was doing …<\/p>\n
[groovy] This made realise that truncate was a better option … But unfortunately<\/strong> the GORM layer does not support the ‘ truncate ‘ queries that I was looking for. So with some help from ‘ Mr. Google ‘ and my fellow colleagues , i realised that there was another way to do this .. [groovy] def session = sessionFactory.getCurrentSession() The getCurrentSession()<\/strong> method looks at the current context to see if a session is stored in there. If there is one, it uses it, and if there isn’t a session in the current context, it creates a new one and saves it in there. Hope this helps .. \ud83d\ude00<\/p>\n Cheers<\/p>\n Manoj Mohan In one of the modules that I was working on , I needed to delete the previous data from a table then load up the data into those tables again and then manipulate code through the ‘id’s’ on those tables. So this is what I was doing … [groovy] Event.executeUpdate(‘delete from Event’) EventInstance.executeUpdate(‘delete from EventInstance’) […]<\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":4},"categories":[7],"tags":[4843,844,4840,843],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/3611"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=3611"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/3611\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=3611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=3611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=3611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nEvent.executeUpdate(‘delete from Event’)
\nEventInstance.executeUpdate(‘delete from EventInstance’)
\n[\/groovy]
\n<\/br>
\nBut the problem<\/strong> was that when I deleted the events, the ‘id’s’ on those tables would remain intact and the new Events that would load up would continue upon the earlier present ‘ id’s ‘ .i.e if the last present id was 24 before deleting , the new load-ups would continue from 25 onwards..<\/p>\n
\nSo in effect this query would give an error
\n<\/br>
\n[groovy]
\nEvent.executeUpdate(‘truncate table Event’)
\nEventInstance.executeUpdate(‘truncate table EventInstance’)
\n[\/groovy]<\/p>\n
\n Session Factory …<\/strong>
\nSession Factory allowed me to truncate those tables through\u00a0 createSQLQuery() method
\nSo my new approach was
\n<\/br><\/p>\n
\n def sessionFactory<\/p>\n
\n Query query = session.createSQLQuery(‘truncate table event’)
\n[\/groovy]<\/p>\n
\nThen all I did was use the query to truncate the tables… and presto !! .. my work was done ..
\n<\/br><\/p>\n
\nManoj (at) Intelligrape (dot) com<\/p>\n","protected":false},"excerpt":{"rendered":"