← Back to team overview

mvhub-dev team mailing list archive

Re: db agnostic 00_setup.sql (was funny but irrelevant subject)

 

Replying to developer's list as Ferhat is also interested in sequences and Emmad in mv_setup_development

This all sounds great.

You probably should look at mv_update_development to see when the test data is loaded.


Tomorrow, I'm going to be at one of the day jobs. Simplifying the situation somewhat there is a bulldozer coming to knock down our server room so stuff needs to move. Over the weekend, I've got elderly relatives to visit, but I'm going to try to be on IRC

You might catch other people on IRC tomorrow....

#######
On 08/11/2011 04:54 PM, Jeff Bonhag wrote:
Dan, you're way too hard on yourself.

We just came back from a pretty awesome camping trip to Mt. Mansfield in
Vermont -- you can't scare me off that easily.

I migrated all the test data from
app-mvhub/project-tools/test_mvh_db.sql

into
http://bazaar.launchpad.net/~jbonhag/mvhub/db_agnostic/view/head:/app-mvhub/setup/database/sql/000_setup.sql

There were only two Big Issues:
1) SQLite doesn't support sequences, meaning we would have to handle
that with Perl code (which you had mentioned)
2) SQLite stores boolean values as 1 and 0 for true and false.

So now we've got a nice little SQLite test database to play with.  I'll
definitely be around tomorrow morning, we can catch up at 10 and keep
pushing the locomotive uphill.


Jeff