StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPrevention of partial database operation
primarykey
Id
16160991
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
2013-04-23T23:53:00.107
CommentCount
8
CommunityOwnedDate
CreationDate
2013-04-23T04:29:49.037
FavoriteCount
0
LastActivityDate
2013-04-23T08:36:55.650
LastEditDate
2013-04-23T08:36:55.650
LastEditorUserId
472495
OwnerUserId
988268
ParentId
0
PostTypeId
1
Score
1
ViewCount
60
LastEditorDisplayName
text
Body
I made some functions in PHP which perform some or the other database operation like insertion, deletion, updating, etc. and I call the functions every time I want to do some operation. Now, lets say, I have the need to do the following: <ul> <li>Call function 1 which does a Database operation, wait for the return message then</li> <li>Call function 2 which does another Database operation, wait for the return message then</li> <li>Call function 3 which does some other Database operation, wait for the return message</li> </ul> If DB operation executed successfully in function1 and function2 but not in function3, then the complete operation is a failure since all three functions must be successful. In this case I would like to rollback the changes made by function1 and function2 since the operation is unsuccessful. I thought of stacking the queries and executing them all together at once but the problem is I don't know when I have to execute the query stack. eg. <pre><code>if I call $obj->deletethread(); it calls $obj->deletemsg(); and $obj->deleteattachments(); and $obj->deletetags(); gets called </code></pre> but this may not be the case all the time i.e. <pre><code>if I call $obj->deletemsg(); $obj->deleteattachments(); and $obj->deletetags(); gets called </code></pre> What I am trying to say is these functions can be called in any order by any other function. Is there any way to achieve this? Why I need this: if a database operation is unsuccessful at any point, partial data is inserted in the tables where database operation was successful which I do not want since it will cause improper records.
Tags
<php><mysql><database><database-design><mysqli>
Title
Prevention of partial database operation
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UShalfer
UserOwnerUserId
1. USVignesh T.V.
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTDuplicate
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPrevention of partial database operation
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTClose
2. VO
 singulars
 PostPostId
 POPrevention of partial database operation
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTClose
3. VO
 singulars
 PostPostId
 POPrevention of partial database operation
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTClose
CommentsPostId

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.