groovy - Grails .save(flush: true) behaves the same with .save() -


we have been testing different way of saving. however, results weren't expected. have create-survey method, , each survey has multiple questions. tested few cases , committed queries same way. 

@transactional class service {       survey createnewsurvey(newsurveycommand command) {        survey survey = new survey()        survey.properties[] = command.properties        survey.save(flush: true, failonerror: true)  //save survey , flush        (newquestioncommand questioncommand : command.questions) {            question question = new question()            question.properties[] = questioncommand.properties            question.save(flush: true, failonerror: true)  // save each questions , flush        }        return survey    } }

the second removing transactional , saving without flush

 class service {       survey createnewsurvey(newsurveycommand command) {        survey survey = new survey()        survey.properties[] = command.properties        survey.save()  //save survey , flush        (newquestioncommand questioncommand : command.questions) {            question question = new question()            question.properties[] = questioncommand.properties            question.save()  // save each questions , flush        }        return survey    } }

the 3th , 4th, once transactional , once without transactional. 

class service {           survey createnewsurvey(newsurveycommand command) {            survey survey = new survey()            survey.properties[] = command.properties            survey.save()  //save survey , flush            (newquestioncommand questioncommand : command.questions) {                question question = new question()                question.properties[] = questioncommand.properties               survey.addtoquestions()     }            survey.save(flush: true, failonerror: true)            return survey    } }

in end mysql log, checked no matter did inserting happened within 1 commit.

    query    set autocommit=0     query    insert survey (version, brand ,...)     query    insert question (version,..d)     query    insert question (version,..d)     query    commit     query    set autocommit=1

in end didn't see difference between .save(flush: true, failonerror: true), save() ( or without transactional).

could explain how save flush , without flush working.?

grails doc says flush (optional) - when set true flushes persistence context, persisting object immediately. however, in our case saw, didn't happen in doc says. or did misunderstand it?

save() without flush: true doesn't start database connection. after calling save() data persisted in hibernate session. in case, not find related lines in mysql log file.

save(flush: true) starts transaction on database level immediately. after calling save(flush: true) first time should see lines in mysql log file, sth like: 

query    set autocommit=0 query    insert survey (version, brand ,...)

after calling save(flush: true) second time transaction being continued (not started again, no commit happen between 2 saves) on database level. can see lines added mysql log file.


Comments

Post a Comment

Popular posts from this blog

go - serving up pdfs using golang -

Image
just wondering if guys can code. it works serving images not pdf brochure. in advance func main(){ http.handlefunc("/", func(w http.responsewriter, r *http.request){ filename := "/var/www/filedipenser/brochure.pdf" streampdfbytes, err := ioutil.readfile( filename ) if err != nil { fmt.println(err) os.exit(1) } b := bytes.newbuffer(streampdfbytes) w.header().set("content-type", "application/pdf") if _, err := b.writeto(w); err != nil { fmt.fprintf(w, "%s", err) } w.write([]byte("pdf generated")) }) err := http.listenandserve(":4111", nil) if err != nil { log.fatal("listenandserve: ", err) fmt.println(err) } } the code bit inefficient appears working. however, pdf viewers might sensitive extraneous output adding end of http response stream...
Read more

python - Best design pattern for collection of objects -

i have following architecture: +-----------------+ | collection | | | | | | | | | +-----------------+ | ^ | | create() | | | | v | getitem(b) +------------+ | | item | | | | | | +------+ | | +------------+ a class managing collection of items, creates items. , these items may need other items collection. the actual code in python, , collection passes parameter created item . see it, bad practice. improvement can see pass few functions of collection needed item , instead of whole instance. for example: class collection: getitem(self, id): ... createitem(self, id): item = item(id, self) # <-- pass self ... class item: __init__(self, id, col): ... col.getite...
Read more

sharepoint online - C# CSOM SPView ListItemCollection did not update after I add new field in the SP view -

spclientcontext.credentials = new sharepointonlinecredentials(username, securepassword); //https://msdn.microsoft.com/en-us/library/office/ee534956(v=office.14).aspx web spweb = spclientcontext.web; list splist_csv = spweb.lists.getbytitle("supplier master list"); view spview_csv = splist_csv.views.getbytitle("_data pending export csv");//oracle export field spclientcontext.load(spview_csv); spclientcontext.executequery(); camlquery query = new camlquery(); query.viewxml = spview_csv.viewquery; listitemcollection items = splist_csv.getitems(query); spclientcontext.load(items); spclientcontext.executequery(); foreach (var item in items) { //some field/item missing? } hi, using code above retrieve data sharepoint online. @ first, working fine. but, when add in new column view _data pending export csv on sharepoint online, found out new added field missing. idea? ok. found out others issue, lookup field on limit. did fix change lookup field s...
Read more