PostgreSQL Schema Provider for CodeSmith

COMMENTED ISSUE: GetTableKeys generates errors...

ericwgreene — Wed, 03 Oct 2007 14:17:34 GMT

The GetTableKeys generates error when using it. How to solve this? See following error:

System.InvalidOperationException: Fehler beim Vergleichen von zwei Elementen im Array. ---> System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
bei SchemaExplorer.TableKeySchema..ctor(DatabaseSchema database, String name, String[] foreignKeyMemberColumns, String foreignKeyTableOwner, String foreignKeyTable, String[] primaryKeyMemberColumns, String primaryKeyTableOwner, String primaryKeyTable)
bei SchemaExplorer.PgSqlSchemaProvider.PgSqlSchemaProvider.GetTableKeys(String connectionString, TableSchema table) in C:\DATEN\ClockWorkZ\Projekte\CWZ\SchemaExplorer.PgSqlSchemaProvider\SchemaExplorer.PgSqlSchemaProvider\PgSqlSchemaProvider.cs:Zeile 110.
bei SchemaExplorer.TableSchema.get_Keys()
bei SchemaExplorer.TableSchema.get_ForeignKeys()
bei SchemaExplorer.TableSchema.a(TableSchema A_0, TableSchemaCollection A_1)
bei SchemaExplorer.TableSchema.IsDependantOf(TableSchema table)
bei SchemaExplorer.TableDependancyComparer.Compare(Object x, Object y)
bei System.Array.GetPivotValue(IComparer comparer, Array keys, Int32 left, Int32 right)
--- Ende der internen Ausnahmestapelüberwachung ---
bei System.Array.GetPivotValue(IComparer comparer, Array keys, Int32 left, Int32 right)
bei System.Array.SorterObjectArray.QuickSort(Int32 left, Int32 right)
bei System.Array.Sort(Array keys, Array items, Int32 index, Int32 length, IComparer comparer)
bei System.Array.Sort(Array array, Int32 index, Int32 length, IComparer comparer)
bei SchemaExplorer.TableSchemaCollection.Sort(IComparer comparer)
bei _CodeSmith.NetTiers_cst.Go()
bei _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control control)
bei CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
bei CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
bei CodeSmith.Engine.Control.Render(TextWriter writer)
bei CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
bei CodeSmith.Engine.CodeTemplate.RenderToString()
bei CodeSmith.Gui.CodeTemplateGenerator.f(Object A_0, EventArgs A_1)
Comments: ** Comment from web user: ericwgreene **

Has any work been done on this issue? I am attempting to use this provider but I am getting the same error. I have tracked down the error to:

new TableKeySchema(database, name, foreignKeyMemberColumns, foreignKeyTableOwner, foreignKeyTable,
primaryKeyMemberColumns, primaryKeyTableOwner, primaryKeyTable)

in routine GetTableKeys of file PgSqlSchemaProvider.cs.

I have checked all of the values being passed and everything appears ok. My particular table has no foreign keys but does have a one column primary key. Any help would be appreciated.

Patch Applied

burningsnow — Mon, 10 Sep 2007 14:27:17 GMT

burningsnow has applied patch #273.

Comment:
j

Patch Uploaded

kilroy — Sun, 09 Sep 2007 16:13:03 GMT

kilroy has uploaded a patch.

Description:
Got this to work with PostgreSQL 8.

Patch Uploaded

kilroy — Sun, 09 Sep 2007 16:12:30 GMT

kilroy has uploaded a patch.

Description:
Got this to work with PostgreSQL 8.

Source code checked in

burningsnow — Fri, 10 Aug 2007 18:34:17 GMT

GetTableKeys modified

Source code checked in

burningsnow — Fri, 10 Aug 2007 14:13:27 GMT

GetTableKeys modified

CREATED ISSUE: GetTableKeys generates errors...

burningsnow — Thu, 09 Aug 2007 18:01:54 GMT

Source code checked in

burningsnow — Thu, 09 Aug 2007 17:11:48 GMT

Fixed some bugs

Source code checked in

burningsnow — Thu, 09 Aug 2007 14:53:39 GMT

Source code checked in

burningsnow — Thu, 09 Aug 2007 14:52:31 GMT

Source code checked in

burningsnow — Thu, 09 Aug 2007 14:49:53 GMT

Last Source Code

UPDATED WIKI: Home

burningsnow — Thu, 09 Aug 2007 12:38:41 GMT

Project Description
A CodeSmith Schema Provider for PostgreSQL.

To do

Implement all methods from the CodeSmith Schema Provider interface (http://www.codesmithtools.com)
test the PostgreSQL Schema Provider

If there is someone who has knowledge about PostgreSQL meta information and would like to help finishing this project, so he is invited to contribute code.

UPDATED WIKI: Home

burningsnow — Thu, 09 Aug 2007 12:38:23 GMT

Project Description
A CodeSmith Schema Provider for PostgreSQL.

To do

Implement all methods from the CodeSmith Schema Provider interface (http://www.codesmithtools.com)
test the PostgreSQL Schema Provider

If there is someone who has knowledge about PostgreSQL meta information and would like to finish this project, so he is invited to contribute code.

Source code checked in

burningsnow — Thu, 09 Aug 2007 12:29:53 GMT

GetViews Implemented

Source code checked in

burningsnow — Thu, 09 Aug 2007 11:54:00 GMT

Added some todo comments

UPDATED WIKI: Home

burningsnow — Thu, 09 Aug 2007 11:43:23 GMT

Project Description
A CodeSmith Schema Provider for PostgreSQL.

To do

Implement all methods from the CodeSmith Schema Provider interface (http://www.codesmithtools.com)
test the PostgreSQL Schema Provider

Source code checked in

burningsnow — Thu, 09 Aug 2007 11:21:28 GMT

GetCommandText implemented

Source code checked in

burningsnow — Thu, 09 Aug 2007 10:48:54 GMT

GetCommands method implemented.

Source code checked in

burningsnow — Thu, 09 Aug 2007 08:41:46 GMT

First commit of the source code.

UPDATED WIKI: Home

burningsnow — Thu, 09 Aug 2007 07:53:24 GMT

Project Description
A CodeSmith Schema Provider for PostgreSQL.