U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Sqlite: Missing GetTransactionLevel() Method - Implemented

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Sqlite: Missing GetTransactionLevel() Method - Implemented [message #29116]

Wed, 06 October 2010 00:40

zsolt
Messages: 696
Registered: December 2005
Location: Budapest, Hungary

Contributor

It is useful for me:

Sqlite3Session class declaration (plugin/sqlite3/Sqlite3.h):

	virtual int    GetTransactionLevel() const;

Implementation (plugin/sqlite3/Sqlite3upp.cpp):

int Sqlite3Session::GetTransactionLevel() const
{
	int autocommit = sqlite3_get_autocommit(db);
	return (autocommit ? 0 : 1);
}

Report message to a moderator

Re: Sqlite: Missing GetTransactionLevel() Method - Implemented [message #29268 is a reply to message #29116]

Wed, 13 October 2010 19:18

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Applied. Thanks (although I am now pretty uncertain that anybody should develop SQL apps based on this - today I run in autocommit most of time, only activating SINGLE transaction level from time to time...)

Report message to a moderator

Re: Sqlite: Missing GetTransactionLevel() Method - Implemented [message #29282 is a reply to message #29268]

Wed, 13 October 2010 22:02

zsolt
Messages: 696
Registered: December 2005
Location: Budapest, Hungary

Contributor

Me too, but in some functions I want to be sure, that the function is called within a transaction, so I'm using a line:

ASSERT(sql.GetTransactionLevel());

Report message to a moderator

Re: Sqlite: Missing GetTransactionLevel() Method - Implemented [message #29329 is a reply to message #29282]

Fri, 15 October 2010 14:33

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

zsolt wrote on Wed, 13 October 2010 16:02

Me too, but in some functions I want to be sure, that the function is called within a transaction, so I'm using a line:

ASSERT(sql.GetTransactionLevel());

OK, that is reasonable Wink

Report message to a moderator

Previous Topic:	[SQLITE] Enable FTS in compiler options by default
Next Topic:	Select a month in SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 16 18:44:18 CEST 2024

Total time taken to generate the page: 0.02839 seconds