Styjun

Why is prior to creation called holy?

Why tighten down in a criss-cross pattern?

What's currently blocking the construction of the wall between Mexico and the US?

Silly doubt about tidal effects and Einstein Field Equations

Unusual mail headers, evidence of an attempted attack. Have I been pwned?

What does it mean to "control target player"?

Is this proposal by U.S. presidential candidate Pete Buttigieg to change the composition of the Supreme Court constitutional?

Did the CIA blow up a Siberian pipeline in 1982?

Heavily limited premature compiler translates text into excecutable python code

Minor traveling without parents from USA to Sweden

Why is it recommended to mix yogurt starter with a small amount of milk before adding to the entire batch?

What exactly is the 'online' in OLAP and OLTP?

Is it damaging to turn off a small fridge for two days every week?

How do I professionally let my manager know I'll quit over smoking in the office?

Can White Castle?

Is there a term for the belief that "if it's legal, it's moral"?

How does DC work with natural 20?

What was the Shuttle Carrier Aircraft escape tunnel?

What did River say when she woke from her proto-comatose state?

How is hair tissue mineral analysis performed?

Improving triangulation on AutoCAD-generated stl files

Why do even high-end cameras often still include normal (non-cross-type) AF sensors?

Loss of power when I remove item from the outlet

Why don't countries like Japan just print more money?

How to use DB [ transaction , comit, rollback ] in adonis js

How do JavaScript closures work?How do I check if an element is hidden in jQuery?How do I remove a property from a JavaScript object?How do I redirect to another webpage?How do I include a JavaScript file in another JavaScript file?How to check whether a string contains a substring in JavaScript?How do I pass command line arguments to a Node.js program?How to decide when to use Node.js?How do I remove a particular element from an array in JavaScript?How do I return the response from an asynchronous call?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I want to use try catch with DB transaction for if I get something error I want the database rollback all of my query in try function

Here is my try. I comment const empImg because I want to test. It's not rollback await emp.save(); after the query error unknown empImg

 const trx = await Database.beginTransaction()
 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save();
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save();
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Of course I can just put

emp.delete(); in catch but I've to check which query error and delete it.

How can I do something like this If something error I want to rollback my emp and empImg?

javascript node.js adonis.js

share|improve this question

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

asked Mar 25 at 8:11

TryHardTryHard

918

add a comment | 

0

I want to use try catch with DB transaction for if I get something error I want the database rollback all of my query in try function

Here is my try. I comment const empImg because I want to test. It's not rollback await emp.save(); after the query error unknown empImg

 const trx = await Database.beginTransaction()
 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save();
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save();
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Of course I can just put

emp.delete(); in catch but I've to check which query error and delete it.

How can I do something like this If something error I want to rollback my emp and empImg?

javascript node.js adonis.js

share|improve this question

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

asked Mar 25 at 8:11

TryHardTryHard

918

add a comment | 

I want to use try catch with DB transaction for if I get something error I want the database rollback all of my query in try function

Here is my try. I comment const empImg because I want to test. It's not rollback await emp.save(); after the query error unknown empImg

 const trx = await Database.beginTransaction()
 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save();
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save();
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Of course I can just put

emp.delete(); in catch but I've to check which query error and delete it.

How can I do something like this If something error I want to rollback my emp and empImg?

javascript node.js adonis.js

share|improve this question

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

asked Mar 25 at 8:11

TryHardTryHard

918

 const trx = await Database.beginTransaction()
 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save();
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save();
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

share|improve this question

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

asked Mar 25 at 8:11

TryHardTryHard

918

share|improve this question

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

asked Mar 25 at 8:11

TryHardTryHard

918

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

edited Mar 25 at 8:18

Ahmed Ashour

3,639102643

asked Mar 25 at 8:11

TryHardTryHard

918

asked Mar 25 at 8:11

TryHardTryHard

918

1 Answer
1

active

oldest

votes

0

You can send trx object to Lucid functions for working with transactions mechanism, e.g. await emp.save(trx);

 const trx = await Database.beginTransaction()

 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save(trx);
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save(trx);
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Transactions in AdonisJS Docs

share|improve this answer

answered Apr 1 at 19:10

alvisxalvisx

411

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55333574%2fhow-to-use-db-transaction-comit-rollback-in-adonis-js%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can send trx object to Lucid functions for working with transactions mechanism, e.g. await emp.save(trx);

 const trx = await Database.beginTransaction()

 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save(trx);
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save(trx);
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Transactions in AdonisJS Docs

share|improve this answer

answered Apr 1 at 19:10

alvisxalvisx

411

add a comment | 

0

You can send trx object to Lucid functions for working with transactions mechanism, e.g. await emp.save(trx);

 const trx = await Database.beginTransaction()

 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save(trx);
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save(trx);
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Transactions in AdonisJS Docs

share|improve this answer

answered Apr 1 at 19:10

alvisxalvisx

411

add a comment | 

You can send trx object to Lucid functions for working with transactions mechanism, e.g. await emp.save(trx);

 const trx = await Database.beginTransaction()

 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save(trx);
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save(trx);
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

Transactions in AdonisJS Docs

share|improve this answer

answered Apr 1 at 19:10

alvisxalvisx

411

 const trx = await Database.beginTransaction()

 try 
 const user = await auth.getUser();
 const emp = new Employee();
 emp.fill(empData);
 emp.merge( update_by: user.name )
 await emp.save(trx);
 // const empImg = new EmployeePhoto();
 empImg.name = user.name;
 await empImg.save(trx);
 await trx.commit()
 catch (error) 
 await trx.rollback()
 throw new InvalidAccessException();
 

share|improve this answer

answered Apr 1 at 19:10

alvisxalvisx

411

answered Apr 1 at 19:10

alvisxalvisx

411

answered Apr 1 at 19:10

alvisxalvisx

411