StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to use savepoints in SQLite3 in Objective-C
primarykey
Id
13455733
data
AcceptedAnswerId
13456323
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-11-19T14:22:20.333
FavoriteCount
0
LastActivityDate
2012-11-20T11:57:28.123
LastEditDate
2012-11-20T10:57:34.977
LastEditorUserId
502365
OwnerUserId
502365
ParentId
0
PostTypeId
1
Score
2
ViewCount
842
LastEditorDisplayName
text
Body
I'm working on an iOS app that has a rather large sqlite database that gets at least once a day and I'd like to use savepoints to restore it if something happens while the transactions are running. The statements I've been running are the following: <pre><code>const char *sqlSetSavePoint = @"savepoint updateSavepoint"; const char *sqlRollback = @"Rollback transaction to savepoint updateSavepoint"; </code></pre> I have obviously omitted a lot of code that actually runs these statements, but since I'm running the same method for other statements and they work fine I have confidence that the problem isn't there. I'm setting the savepoint before running my insert transactions (inserting up to 200 thousand lines) and then if something throws an exception or an error I try to do a rollback. My questions is; are these rollback statements correct (and I'm just doing something wrong) or is there some other way of using savepoints in sqlite3 in iOS? EDIT: Just for clarification, I'm trying to set a savepoint before then running a number of transactions and if any of them, or a data fetch from the server, fail I want to do a total rollback to the savepoint. It is simply like this: <pre><code>"savepoint updateSavepoint" ->FetchDatafromServer() -> "Begin exclusive transaction" //sqlite3_bind functions -> "Commit transaction" ->FetchDatafromServer() -> "Begin exclusive transaction" //sqlite3_bind functions -> "Commit transaction" ->FetchDatafromServer() -> "Begin exclusive transaction" //sqlite3_bind functions -> "Commit transaction" ->FetchDatafromServer() -> "Begin exclusive transaction" !!Failure!! "Rollback transaction to savepoint updateSavepoint" </code></pre>
Tags
<objective-c><ios><sqlite><rollback>
Title
How to use savepoints in SQLite3 in Objective-C
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHrafn
UserOwnerUserId
1. USHrafn
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow to use savepoints in SQLite3 in Objective-C
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COJust so you know you are using an `NSString` literal to create an `NSString` to get an UTF-8 string when all you need to do is `const char *sqlSetSavePoint = "savepoint updateSavepoint";`.
 singulars
 PostPostId
 POHow to use savepoints in SQLite3 in Objective-C
 UserUserId
 USJoe
2. COHa, right you are. Guess I need more coffee.
 singulars
 PostPostId
 POHow to use savepoints in SQLite3 in Objective-C
 UserUserId
 USHrafn

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.