Skip to main content

Updated ActiveRecord Code Generator

Today, I updated the ActiveRecord Code Generator a bit. I checked in changes to use primary and foreign key details from INFORMATION_SCHEMA. The original code used naming conventions to decide what various fields were used for - ID = Primary Key, Field_ID = Foreign Key to table Fields. If you want to use naming conventions, let me know and I can add a setting in App.Config to allow this (along with any "real" key constraints).
Labels:

Comments

Jim Reineri said…
Thanks for posting this handly generator. I have had a few issues with it. Mostly to do with naming and foreign keys. One issue appears to be related to the truncating that is done to remove plurals in table names. It appears to happen twice in some instances. Also, there seems to be some strict constraints on naming of tables and keys for foreign keys. And, I got some errors that I do not understand yet on "PrimaryKey" attributes. I was able to get around that by replacing the generated attribute code with simply "[PrimaryKey]".

I am new to both NHibernate and ActiveRecord, so working throught these issues is taking me a while, but, I do intend to research all of them completely. If you would like, I would be glad to assist improving the tool.

BTW, I do really like the idea of removing plurals from the table names. I have not seen that feature in some other code generators for NHibernate.
August 02, 2007 8:28 AM
Roy Tate said…
It sounds like you downloaded the first version that I released. If not, could you post a CREATE TABLE script on the Google Code project with a few of related tables. If you had problems with primary keys, you must have grabbed the first version, before I started looking at INFORMATION_SCHEMA to decide what PK an FK constraints were.

I need to just read information on plural table / singular class from a file, and only fall back to my guess-work code if no entry is found. That will allow us to build a word list up, checked in to source control, and released with the app.
August 02, 2007 12:24 PM
Jim Reineri said…
I verified that I am using revision 4 from Subversion repository. I will post the code and schema to Google Code. But, I am newbie to Google Code. I will let you know when I have it there. Going to do some more research first. I have verified that name are getting truncated. Here is sample line from the class for a table named ChangeControlAttachments the has a foreign key relationship to a table named ChangeControl:
private ChangeContro _changeContro;

FYI, in my source version I added a "Browse..." button for the output folder.
August 02, 2007 1:24 PM
Jim Reineri said…
Browse button code:

private void btnBrowse_Click(object sender, EventArgs e)

{
System.Windows.Forms.FolderBrowserDialog dlg = new FolderBrowserDialog();

if (dlg.ShowDialog() == DialogResult.OK)
{
this.OutputDir = dlg.SelectedPath;
}
}
August 02, 2007 1:28 PM
Post a Comment

Popular posts from this blog

How does Rails scaffolding select HTML input tags?

Recently, a reader saw my fix for SQL Server booleans, and asked me a followup question: why does Rails display a yes/no selection instead of a checkbox? The short answer is look in {RUBY_HOME} /lib/ruby/gems/1.8 /gems/actionpack-1.10.2 /lib/action_view/helpers, but your path may vary depending on whether you are using gem, "edge rails", etc. Anyway, look in the file "active_record_helper.rb" for a method called "all_input_tags", and notice that it calls "default_input_block" if you don't supply an input_block. Now notice that "default_input_block" creates a label and calls "input(record, column.name)" which in turn calls "InstanceTag#to_tag" which finally looks at the datatype and maps boolean to a select tag. Perhaps a wiser Rails explorer can provide us with the rationale for this, but I guess we could add a MixIn for InstanceTag that redefines the to_tag() method, or just do a dirty and unmaintainable hack l...
2 comments
Read more

Castle Active Record Code Generator

I have finally released my Code Generator to Google Code as Active-Record-Gen . What does it generate? It generates ActiveRecord classes mainly, but I have used it to generate stored procedures and sys-admin scripts as well. This code generator does not (yet) generate a full Windows application project or a Mono-Rail web site, but the generated code could be used in either. In fact, with a few tweaks, this could be used to generate NHibernate "poco" and .xbm files. If you want to know more, look at the screen shots above, or head over to Google Code and run it. In my haste to make my first EXE release before supper, I forgot to add the Template directory, which should be at the same directory level as the EXE and config files. I just (1.5 hours later) uploaded a new EXE, but 2 people have already downloaded the EXE (not the source though). As for the basic table object, it is built with the following assumptions: Table name is plural, class name is singular. Field ...
2 comments
Read more