Ticket #226: aliasBugs.txt

I am running into one problem after another working with scaffolding, a table structure with one to many relationships and aliased columns. Everything works great if I use the original database object name but if I use the aliased column names I fix one bug only to be stopped by another. Since I don't have a full grasp of the design of Model Glue I'm getting to the point where I believe my fixes are hacks and describing them all will be counter productive. I think it will be easier for whomever to reproduce them. A picture is worth a thousand words kind of thing.

I have attached files that will allow you to easily create my simple schema and the reactor.xml and ModelGlue.xml that works for the object names but not the alias names.

I made it through a number of issues in reactor (which it appears were due to my inexperience) and now I've come out in Model Glue and I ran into a problem where the object name was being used to call getPRE_COLUMN_NAME() instead of using the alias name to call getColumnName(). I fixed that by doing what is below but now I ran into a problem where setPRE_COLUMN_NAME is being called instead of setColumnName at line 377 of D:\Inetpub\wwwroot\ModelGlue\unity\orm\ReactorAdapter.cfc

If there is something you need to know to help me please ask. Thanks.


The first problem was fixed by changing this in
D:\Inetpub\wwwroot\ModelGlue\unity\controller\ReactorORMController.cfc
line 195

was
        <cfloop from="1" to="#arrayLen(metadata.primaryKeys)#" index="i">
            <cfinvoke component="#record#" method="get#metadata.primaryKeys[i]#" returnvariable="tmp" />
            <cfset arguments.event.setValue(metadata.primaryKeys[i], tmp) />
        </cfloop>

is now

            <cfloop collection="#metadata.properties#" item="j" >                
                <cfif metadata.primaryKeys[i] EQ metadata.properties[j].name>                       
                    <cfinvoke component="#record#" method="get#metadata.properties[j].alias#" returnvariable="tmp" />
                </cfif>                
            </cfloop>
            <cfset arguments.event.setValue(metadata.primaryKeys[i], tmp) />            
        </cfloop>


I also ran into these problems in the xsl files

edit.xsl

had to change select="name"/> to select="alias"/>
    <xsl:if test="relationship = 'false'">
        &lt;div class="formfield"&gt;
                &lt;label for="<xsl:value-of select="name"/>" &lt;cfif structKeyExists(validation, &quot;<xsl:value-of select="alias"/>&quot;)>class=&quot;error&quot;&lt;/cfif&gt;&gt;&lt;b&gt;<xsl:value-of select="label"/>:&lt;/b&gt;&lt;/label&gt;

had to comment out because it wasn't a valid query
                  &lt;cfif viewstate.exists("<xsl:value-of select="alias"/>|<xsl:value-of select="sourcekey"/>")&gt;
            &lt;cfset selectedList = viewstate.getValue("<xsl:value-of select="alias"/>|<xsl:value-of select="sourcekey"/>") /&gt;
          &lt;cfelse&gt;
            &lt;cfset selectedList = valueList(selectedQuery.<xsl:value-of select="sourcekey"/>) /&gt;
          &lt;/cfif&gt;
 
 had to comment out because the query didn't exist because of above         
      &lt;input type="hidden" name="<xsl:value-of select="alias"/>|<xsl:value-of select="sourcekey"/>" value="" /&gt;
                &lt;div class="formfieldinputstack"&gt;
          &lt;cfoutput query="valueQuery"&gt;
            &lt;label for="<xsl:value-of select="alias"/>_#valueQuery.<xsl:value-of select="sourcekey"/>#"&gt;&lt;input type="checkbox" name="<xsl:value-of select="alias"/>|<xsl:value-of select="sourcekey"/>" id="<xsl:value-of select="alias"/>_#valueQuery.<xsl:value-of select="sourcekey"/>#" value="#valueQuery.<xsl:value-of select="sourcekey"/>#"&lt;cfif listFindNoCase(selectedList, "#valueQuery.<xsl:value-of select="sourcekey"/>#")&gt; checked&lt;/cfif&gt;/&gt;#valueQuery.<xsl:value-of select="sourcecolumn"/>#&lt;/label&gt;&lt;br /&gt;
          &lt;/cfoutput&gt;
                &lt;/div&gt;