Page 1 of 1

wxActiveRecordGenerator 1.0 First Release

Posted: Sun Oct 01, 2006 11:09 am
by Ugly!
Hi folks. I have developed this component. Hope you find it useful.

wxActiveRecordGenerator is an application that connects to a database and generates c++ classes to interact with tables. You can also specified how the active records relate (only has-many relation currently, belongs-to comming soon). The component depends on the DatabaseLayer component at wxCode.
http://wxcode.sourceforge.net/complist. ... ase&page=1
So all you need it's a working DatabaseLayer backend (SQLite, MySQL or PostgreSQL at the moment); and also you have to include the wxActiveRecord.h and wxActiveRecord.cpp in your project (Note: see the defines at the begining of wxActiveRecord.h).

Currently there's a .exe release at wxCode.
https://sourceforge.net/project/showfil ... e_id=45182

Regards, Mat

Posted: Sun Oct 01, 2006 2:00 pm
by T-Rex
Still didn't test if generated source code works, but I like the idea and such kind of tool should be very helpful.

Also it seems that "Class Name:" edit box does not work because I always get the default class names for generated classes.

Posted: Sun Oct 01, 2006 6:26 pm
by Ugly!
T-Rex wrote: Also it seems that "Class Name:" edit box does not work because I always get the default class names for generated classes.
Thnx for testing it T-Rex, I'll correct that.

Regards, Mat

Posted: Tue Oct 03, 2006 2:02 pm
by paule
Mat

Posted: Tue Oct 03, 2006 3:21 pm
by Ugly!
Thanx for the feedback Paule. Now fixed I hope.

Regards, Mat

Posted: Thu Oct 05, 2006 1:06 pm
by jb_coder
For Firebird database support, you might look at FlameRobin. The have the SQL to retrieve the tables and fields in the getLoadingSql() function in the metadata/database.cpp file.

Also, are there any API changes that DatabaseLayer is lacking that would make it more usable from your perspective?

Thanks!

Posted: Fri Oct 06, 2006 10:07 am
by Ugly!
jb_coder wrote:For Firebird database support, you might look at FlameRobin. The have the SQL to retrieve the tables and fields in the getLoadingSql() function in the metadata/database.cpp file.
Thanks for the pointer jb_coder, I'll get into that when I have a Firebird DB set up in my box.
jb_coder wrote: Also, are there any API changes that DatabaseLayer is lacking that would make it more usable from your perspective?
I know I have thought of some things but I not remember them right now.
Some of them have to do with the metadata stuff. Right now I can only think that IIRC, the postgresql metada get's the int8 as an unknown type.

If you want I can mail you the sugestions/request/bugs I found in the way.

Thnx for the help and this great component.

Regards, Mat

Posted: Wed Oct 11, 2006 9:51 pm
by T-Rex
Hello. :)

I have a new bug-report.

When I add a relation, select it in the grid and press "Edit" then "Foreign ID" combobox of "Relation Properties" dialog does not contain items. I have to select another table in "Table:" list and then select my table anew.

Regards,
T-Rex

Posted: Thu Oct 12, 2006 9:32 am
by Ugly!
T-Rex wrote:Hello. :)

I have a new bug-report.

When I add a relation, select it in the grid and press "Edit" then "Foreign ID" combobox of "Relation Properties" dialog does not contain items. I have to select another table in "Table:" list and then select my table anew.

Regards,
T-Rex
Thanx for the report T-Rex.
Yep, your right, I'll fix it and update it tomorrow if I can. It shoud be v1.0.7.

[EDITED]: Done. Updated CVS and uploaded new win32 release at wxCode.