Monday, September 9, 2013

Database Modeling / ERwin



In ERwin I found I needed to use the physical view if I wanted to create a join table against the same table for purposes of creating a hierarchy without adding a nullable self-referencing parentId column to the target table. Looks like there are a lot of resources on SQL Hierarchies (http://stackoverflow.com/questions/4048151/what-are-the-options-for-storing-hierarchical-data-in-a-relational-database) So I'll have to study a bit -- not to mention, I'll need to find out whether an ORM like NHibernate will handle it.

Two open source options for data modeling I found are mogwai ER Designer NG and SQL Power Architect.

 Forward engineering to SQL Server 2008 works well in ERwin, except for some quirks: It adds extraneous collation metadata; it forces you to uncheck a lot of options e.g. uncheck Schema Create, uncheck all Trigger checkboxes, and those changes aren't saved between sessions. Looks like you can save an option set though, extra work...

To get crows feet notation, choose Information Engineering instead of IDEF1x in Model properties. I learned that and other stuff from http://www.isqa.unomaha.edu/wolcott/tutorials/erwin/erwin.html

Monday, August 19, 2013

NMock3

Was going to use Visual Studio 2012's new ease-of-use mocking feature, but then discovered they removed the ease-of-use right-click create unit test feature. So I had to do that in Visual Studio 2010 instead, and for mocking used NMock3 which worked beautifully after I followed the example here: http://searchcode.com/codesearch/view/10455162

Sunday, August 11, 2013

ASP.NET MVC 4 plus EF CF Tutorial

followed first three of http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application
Provides all the basics on code first migrations and ASP.NET MVC scaffolding

Sunday, July 28, 2013

Jetty Eclipse Tutorial

Following this as exercise: http://docs.codehaus.org/display/JETTY/Importing+Jetty+Source+into+Eclipse
which illustrates the use of the Maven Eclipse Plugin against jetty-6.
but it relies on old files, including cvs.exe. To work around I need to download sources manually via tortoiseSVN from https://svn.java.net/svn/glassfish~v2/trunk/pwc-commons, ./appserv-webtier, etc. directly to targets under modules, e.g. modules/jsp-2.1/target/glassfish, etc.
Then modify modules\jsp-2.1\pom.xml, replacing "extract-src" in ant task element with "update", doing same for jsp-api-2.1 folder. this is to prevent a cvs attempt at a defunct server (i.e. cvs.dev.java.net).

Sunday, May 19, 2013

JBoss Setup

Followed  http://davidghedini.blogspot.com/2011/03/install-jboss-6-on-centos.html
with CentOS 5.5 running on an old Dell Latitude D600 with 775MB RAM.

Was able to access admin-console once, but next day get HTTP Status 404.
Notice four run.sh processes running in top. May need to fix service script in /etc/init.d

When tried to edit /etc/init.d/jboss got an error regarding a file system being read-only. Reboot machine and run fsck -y to fix errors.

Monday, May 6, 2013

Word VBA, Template Customization

Learned about creating editable forms: http://www.sunyacc.edu/sites/default/files/Documents/ITS/word_-_creating_fillable_forms_legacy_tools.pdf

And how to insert a Field (Ctrl-F9)!  http://www.techsupportalert.com/pdf/e1182.pdf
and Alt-F9 to toggle!

And How to automatically execute a Word macro when you create, open, or close a document vs. AutoNew()

More on Auto Macros (tip from this link: hold down shift when pressing OK to prevent auto macros from running)

Microsoft's name for the ribbon and quick access toolbar is "Fluent User Interface"
ref: http://msdn.microsoft.com/en-us/library/office/ee704589(v=office.14).aspx

To remove a custom ribbon, simply edit the .rels file. see: http://msdn.microsoft.com/en-us/library/aa338202.aspx#OfficeCustomizingRibbonUIforDevelopers_AddingDocumentBasedAddIns
This also appears to reenable a greyed out File Options, and Customize Ribbon buttons.

To find a bookmark by name do Ctrl-Shift-F5. Note: Protection must be disabled.

Friday, May 3, 2013

Model Glue

Unpacked modelglue-framework-release-3.2-rc2.zip, copied contents (with root file ModelGlue.cfm) into a newly created folder "ModelGlue" under context root: C:\glassfish3\glassfish\domains\domain1\applications\cfusion\cfusion_war\ModelGlue