U++ framework: U++ SQL » PostgreSQL Support Classes [Experimental]

Home » U++ Library support » U++ SQL » PostgreSQL Support Classes [Experimental]

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

PostgreSQL Support Classes [Experimental] [message #9037]

Sun, 15 April 2007 00:28

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

Contributor

I have created experimental PostgreSQL classes and a dumb example.

The problems of it:

it is incomplete yet, you can see the empty method bodies and comments
blobs and reference constraints are untested.
tested on windows only
Auto increment field handling needs some unification in UPP. mysql has some API function to query the last generated value, just like sqlite. But Pg has a different architecture, as it uses per table sequences with names generated from table and field name.
I created SERIAL and BIGSERIAL types in schema

Upp needs a modification to use this:
In Sql/SqlSchema.cpp in SqlSchema::FlushColumn():

			else if (dialect == SQLITE3)
				Upgrade() << Expand("alter table @t add ") << cd << ";\n";
			else if (dialect == POSTGRESS)
				Upgrade() << Expand("alter table @t add \n") << cd << "\n;\n\n";
			else
				Upgrade() << Expand("alter table @t add (\n") << cd << "\n);\n\n";

comments, patches are welcome.

Attachment: PostgreSQLAndTest-01.zip
(Size: 8.13KB, Downloaded 527 times)

Report message to a moderator

[Message index]

		PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 00:28
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 09:11
		Re: PostgreSQL Support Classes [Experimental] By: fallingdutch on Sun, 15 April 2007 09:19
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Sun, 15 April 2007 16:02
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 17:44
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 20:25
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 20:49
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 20:59
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 21:04
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 21:18
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 09:20
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 10:22
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 10:37
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 12:13
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 19:44
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 20:11
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 20:37
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 22:42
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 17 April 2007 00:01
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Mon, 16 April 2007 19:43
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Mon, 16 April 2007 18:46
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Mon, 16 April 2007 19:57
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Tue, 17 April 2007 09:08
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 17 April 2007 11:53
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Wed, 18 April 2007 08:57
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Thu, 01 May 2008 16:53
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Thu, 01 May 2008 22:55
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Sun, 04 May 2008 10:15
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 04 May 2008 11:24
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Mon, 05 May 2008 17:12
		Re: PostgreSQL Support Classes [Experimental] By: mr_ped on Mon, 05 May 2008 20:59
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 05 May 2008 22:14
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Tue, 06 May 2008 17:24
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 06 May 2008 19:45

Previous Topic:	Catch errors with Sql.Execute
Next Topic:	Newbie help with PostgreSQL example

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 26 21:23:49 GMT+2 2026

Total time taken to generate the page: 0.00788 seconds