[Rails] Re: Re: establish_connection not honored by db:migrate

Fearless Fool wrote:
> Colin Law wrote:
>>> Amen. �But since mine is a table containing >700K 18-column records of
>>> unchanging data, I'm not giving up without a fight.
>>
>> Why is that a reason for having it in a separate db?
>>
>> Colin
>
> Um, because I'm lazy? :)

Too lazy to set up the easier solution?

>
> One table in the external database contains 'highly decorated time
> records' with 15 minute granularity. Many of my other models depend on
> this table, and my unit tests are greatly simplified since I know the
> table is always available, precomputed and fully tested.
>
> Since the test database is always rolled back between each test,
> consider the alternative: I'd have to recompute a subset of the time
> records before each test I run, and (a) that slows things down

No You shouldnt be using enough records in any one test to slow things
down

> and (b)
> it makes my head hurt trying to figure out which ones I'd need to
> generate in advance of the test.

No. As I've explained before, just generate the ones you need for each
test. Use factories for this. Simple. If your head hurts, then
you're testing at too large a granularity. Stop overcomplicating!

>
> (I can hear Marnen chuckling in the background right about now...)

Not chuckling so much as getting frustrated.

>
> I am now thinking about keeping keeping it as a table in a separate
> database, but "broadside loading" it into the _development or _test
> database as a rake task using straight SQL commands when needed.

Drop that idea now.

> That
> might not be so painful.

On the contrary, it will be more painful. Stop fighting Rails already!

>
> - ff

Best,

-- 
Marnen Laibow-Koser
http://www.marnen.org
marnen@marnen.org

Sent from my iPhone
--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.