U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

PostgreSQL Support Classes [Experimental] [message #9037]

Sun, 15 April 2007 00:28

zsolt is currently offline

zsolt
Messages: 697
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 422 times)

Report message to a moderator

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Mon Apr 29 02:39:24 CEST 2024

Total time taken to generate the page: 0.04310 seconds