Yay, congratulations! First step complete. Many thousands to go! ;-)
(For the record, I''m at approximately step 2.5)
On Wed, 23 Feb 2005 15:01:05 +1100, Neville Burnell
<Neville.Burnell-uEDVyssJ3mUpAS55Wn97og@public.gmane.org>
wrote:> Hi All,
>
> Just thought I''d talk about my RoR project which I started 4 hours
ago.
>
> Background:
> We develop and sell commercial accounting software via a reseller
> channel. We have an internally developed fat client application which
> manages our end users, licences, support contracts etc, with SQL server
> as the database. Management want to provide our resellers web access to
> details of the end users they are servicing, to streamline things like
> contract renewal, etc. A typical reseller portal.
>
> After lurking on the RoR list for a while, I had a few minor concerns:
> 1) early on I read somewhere that RoR is not recommended for
''existing
> databases''
> 2) SQL Server support was just freshly baked
>
> Diving Right In:
> So today I rolled up my sleeves and got started:
>
> Part 1 ... Easy as 123
> 1) retrieve Curt''s OnLamp article as a guide
> 2) Download & install Ruby via the one-click installer on my
development
> Win2000 server.
> 3) Use gem to fetch Ruby on Rails
> 4) create my empty portal application
> 5) start the webbrick server ... Cool
>
> Part 2 ... A little SQL Server
> 1) Create a new ''myportal'' database
> 2) create a view ''customers'' view which pulls data from
the customers
> database and renames id''s etc into RoR friendly names. This
approach
> achieves several goals including
>
> A) mashing our existing tables and fields to conform with rails
> pluralisation and id rules
> B) restricting the fields and tables ''published''
to the portal
>
> Part 3 ... Back to Ruby on Rails
> 1) Follow the ''How to connect to SQL Server'' instructions
from:
> http://wiki.rubyonrails.com/rails/show/HowtoConnectToMicrosoftSQLServer
> 2) generate a customer model and customer controller [as per Curts
> walkthough]
> 3) edit the controller to add scaffolding
> 4) Browse to http://127.0.0.1:3000/customer/list
>
> Tada ... A list of our customers ... and I don''t really have a
clue
> about ruby or rails!
>
> Now the hard work begins <grin>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
--
Jordan Brock
Spin Technologies
www.spintech.com.au