[sqlite] How to detect existing TRANSACTION before performing SAVEPOINT?

[Afriza N. Arief]

Hello,

Currently I am relying on the return code of sqlite3_exec(db,"BEGIN
IMMEDIATE",0,0,0) == SQLITE_ERROR as an indication that there is already a
transaction in progress and then in such cases, I will then call
sqlite3_exec(db,"SAVEPOINT mySavePoint",0,0,0) as a mean of nested
transaction.

Is this good enough? What is the correct way of detecting existing
transaction?

<code>
void func(sqlite3* db) {
  int rc, active = 0, savepoint=0;
  rc=sqlite3_exec(db,"BEGIN IMMEDIATE",0,0,0);
  if (rc==SQLITE_OK) {
    active=1;
  }
  else if (rc==SQLITE_ERROR) { /* is this a good test condition? */
    rc=sqlite3_exec(db,"SAVEPOINT mySavePoint",0,0,0);
    if(rc==SQLITE_OK) {
      savepoint = active = 1;
    }
  }

  /* do something */

  if (active) {
    if (savepoint) {
      rc=sqlite3_exec(db,"RELEASE mySavePoint",0,0,0);
    }
    else {
      rc=sqlite3_exec(db,"END",0,0,0);
    }
  }
}
</code>

Similar functions are called outside and inside TRANSACTIONs as well as
SAVEPOINTs.

Regards,

Afriza N. Arief
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users