id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
9422,Allow for start transaction/rollback/commit sql statements in WP,Denis-de-Bernardy,,"It would be sweet if WP were to become 100% transaction safe. I wondered if it was, while developing a plugin that required InnoDB tables and transactions for its own tables, as well as InnoDB on the users and posts table in order to enforce foreign key constraints.

Things like:

{{{
do_action('delete_user', $id);

$wpdb->query( $wpdb->prepare(""DELETE FROM $wpdb->users WHERE ID = %d"", $id) );
$wpdb->query( $wpdb->prepare(""DELETE FROM $wpdb->usermeta WHERE user_id = %d"", $id) );
}}}

Should really be:

{{{
do_action('delete_user', $id);

$wpdb->query( $wpdb->prepare(""DELETE FROM $wpdb->usermeta WHERE user_id = %d"", $id) );

$wpdb->query( $wpdb->prepare(""DELETE FROM $wpdb->users WHERE ID = %d"", $id) );
}}}

That way, if one enforces the relevant foreign key and deletes a user as part of a transaction, the database won't complain. Along the same lines, the delete post procedure is particularly ugly...",enhancement,closed,normal,2.9,Optimization,2.8,major,fixed,needs-patch,