Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Transaction management using REST API [moved] #90

Closed
lvca opened this issue Dec 10, 2012 · 9 comments
Closed

Transaction management using REST API [moved] #90

lvca opened this issue Dec 10, 2012 · 9 comments
Assignees
Milestone

Comments

@lvca
Copy link
Member

lvca commented Dec 10, 2012

This is Issue 90 moved from a Google Code project.
Added by 2010-07-31T10:31:12.000Z by emailmat...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.

Original labels: Type-Enhancement, Priority-Low, v1.4.0

Original description

I miss the possibility to handle transactions through the REST API. It would be great if the SQL commands START TRANSACTION, COMMIT and ROLLBACK were supported.
@odino
Copy link

odino commented Jan 28, 2013

this is THE missing feature

currently everyone that uses the HTTP protocol is bound to a request per query: imagine having the need to update 1k records

@ghost ghost assigned lvca Jan 28, 2013
@lvca
Copy link
Member Author

lvca commented Jan 28, 2013

It's on my todo list!

@lvca
Copy link
Member Author

lvca commented Jan 31, 2013

Execute a batch of commands in one shot. This is useful to reduce network latency issuing multiple commands as multiple request. Batch command supports transactions.
Format: { "transaction" : , "operations" : [ { "type" : "" }* ] }
Where:

type can be:
'c' for create
'u' for update
'd' for delete. The '@Rid' field only is needed.
Example:
{ "transaction" : true,
"operations" : [
{ "type" : "u",
"record" : {
"@Rid" : "#14:122",
"name" : "Luca",
"vehicle" : "Car"
}
}, { "type" : "d",
"record" : {
"@Rid" : "#14:100"
}
}, { "type" : "c",
"record" : {
"@Class" : "City",
"name" : "Venice"
}
}
]
}

@odino
Copy link

odino commented Jan 31, 2013

👍

@odino
Copy link

odino commented Jan 31, 2013

hi @lvca, is this gonna be included in 1.4.0?

@lvca
Copy link
Member Author

lvca commented Jan 31, 2013

Course, look at the "Milestone" field in this issue ;-)

@odino
Copy link

odino commented Jan 31, 2013

ok, when is it scheduled to be released?

@lvca
Copy link
Member Author

lvca commented Jan 31, 2013

We're in late with that. It was planned for end of Jan, but will be released at mid Feb.

@odino
Copy link

odino commented Jan 31, 2013

👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

2 participants