Re: [Dbix-class] Installing DBIx::Class under Windows

2006-02-09 Thread Matt S Trout
On Fri, Feb 10, 2006 at 11:11:27AM +0800, Alex Chen wrote: > Hello, > Is there ActivePerl package for DBIC? I just can't find it. I want to use > it connect MSSQL,but I just found installing unixODBC+FreeTDS is a little bit > tricky. So I would like to test it on my Windows first. but then I

Re: [Dbix-class] inflate? select? turning on utf8 for mysql till the dbd is upgraded

2006-02-09 Thread apv
So, this is great and I've got a quick take on the module for it but I must be doing something wrong b/c it's not working. I also need to learn how to use the DBIC::Test stuff to write proper tests for it. I've never looked at the internals of DBIC either so I'll do that if I get time in the next

[Dbix-class] Installing DBIx::Class under Windows

2006-02-09 Thread Alex Chen
Hello,     Is there ActivePerl package for DBIC? I just can't find it. I want to use it connect MSSQL,but I just found installing unixODBC+FreeTDS is a little bit tricky. So I would like to test it on my Windows first. but then I found the windows perl installation is from ActiveState. So ca

RE: [Dbix-class] copying between databases

2006-02-09 Thread Alan Humphrey
Good idea. The only problem I see off the top of my head is allowing "partial" copies to production. Some records may be in a halfway state and not ready for prime time so we couldn't just play back the entire log. Figuring out which records in the log are related doesn't sound like a non-trivia

Re: [Dbix-class] copying between databases

2006-02-09 Thread Matt S Trout
On Thu, Feb 09, 2006 at 05:37:05PM -0600, Brandon Black wrote: > On 2/9/06, Alan Humphrey <[EMAIL PROTECTED]> wrote: > > OK, I'm stumped again. I tried your technique, modified to allow more > > freedom for updates (as opposed to inserts). That quickly led to the > > realization that many-to-many

Re: [Dbix-class] copying between databases

2006-02-09 Thread Brandon Black
On 2/9/06, Alan Humphrey <[EMAIL PROTECTED]> wrote: > OK, I'm stumped again. I tried your technique, modified to allow more > freedom for updates (as opposed to inserts). That quickly led to the > realization that many-to-many relationships meant we'd be spidering the bulk > of the database on ea

RE: [Dbix-class] copying between databases

2006-02-09 Thread Alan Humphrey
OK, I'm stumped again. I tried your technique, modified to allow more freedom for updates (as opposed to inserts). That quickly led to the realization that many-to-many relationships meant we'd be spidering the bulk of the database on each "publish". No good. So I decided to take the 80% soluti

[Dbix-class] Re: Catalyst::Model::DBIC::Schema 0.03

2006-02-09 Thread Brandon Black
On 2/9/06, Brandon Black <[EMAIL PROTECTED]> wrote: > Snaphot is avail at http://www.dtmf.com/Catalyst-Model-DBIC-Schema-0.03.tar.gz > > The major change is the addition of a new Helper class called > Catalyst::Helper::Model::DBIC::SchemaInlineLoader > Actually, there's a better way to do that wit

Re: [Dbix-class] Catalyst::Model::DBIC::Schema

2006-02-09 Thread Alex Kavanagh
At Wed, 8 Feb 2006 11:01:58 -0600, Brandon Black wrote: > > On 2/8/06, Alex Kavanagh <[EMAIL PROTECTED]> wrote: > > Hi > > > > At Tue, 7 Feb 2006 21:24:44 -0600, > > Brandon Black wrote: > > > > > > Catalyst::Model::DBIC::Schema exists now, although I haven't CPANed it > > > yet, awaiting more fee

RE: [Dbix-class] copying between databases

2006-02-09 Thread Alan Humphrey
This is great! It's really nice to be able to see the API in use. I'm going to use this as a starting point. Changes I'll need to make: 1) related objects need to be migrated before the new object is created in order to avoid foreign key constraint problems in the db. 2) you're right, this is

Re: [Dbix-class] Re: DBIx::Class::UUIDColumns

2006-02-09 Thread Christopher H. Laco
Matt S Trout wrote: > On Thu, Feb 09, 2006 at 09:23:59AM -0500, Christopher H. Laco wrote: >> Matt S Trout wrote: >>> On Tue, Feb 07, 2006 at 09:13:08PM -0500, Christopher H. Laco wrote: Here's my first crack at it. I still have to do pod, and I'm not sure what to do about the recommends:

Re: [Dbix-class] Re: DBIx::Class::UUIDColumns

2006-02-09 Thread Matt S Trout
On Thu, Feb 09, 2006 at 09:23:59AM -0500, Christopher H. Laco wrote: > Matt S Trout wrote: > > On Tue, Feb 07, 2006 at 09:13:08PM -0500, Christopher H. Laco wrote: > >> Here's my first crack at it. I still have to do pod, and I'm not sure > >> what to do about the recommends: in meta.yml/build.pl o

Re: [Dbix-class] inflate? select? turning on utf8 for mysql till the dbd is upgraded

2006-02-09 Thread Matt S Trout
On Wed, Feb 08, 2006 at 10:50:07PM -0800, apv wrote: > In CDBI for MySQL I'm setting everything to utf8 this way (the tables > are utf8 but the DBD doesn't bring the info across): > > # the base class > use Data::Structure::Util qw( _utf8_on ); > __PACKAGE__->add_trigger(select => sub { _utf8_on(

Re: [Dbix-class] Re: DBIx::Class::UUIDColumns

2006-02-09 Thread Christopher H. Laco
Matt S Trout wrote: > On Tue, Feb 07, 2006 at 09:13:08PM -0500, Christopher H. Laco wrote: >> Here's my first crack at it. I still have to do pod, and I'm not sure >> what to do about the recommends: in meta.yml/build.pl or tests yet, >> since they assume just Data::UUID... >> >> >> UUIDColumns now

Re: [Dbix-class] Re: DBIx::Class::UUIDColumns

2006-02-09 Thread Matt S Trout
On Tue, Feb 07, 2006 at 09:13:08PM -0500, Christopher H. Laco wrote: > Here's my first crack at it. I still have to do pod, and I'm not sure > what to do about the recommends: in meta.yml/build.pl or tests yet, > since they assume just Data::UUID... > > > UUIDColumns now looks for a suitable uuid

[Dbix-class] Catalyst::Model::DBIC::Schema 0.03

2006-02-09 Thread Brandon Black
Snaphot is avail at http://www.dtmf.com/Catalyst-Model-DBIC-Schema-0.03.tar.gz The major change is the addition of a new Helper class called Catalyst::Helper::Model::DBIC::SchemaInlineLoader This comes close to emulating what Catalyst::Helper::Model::DBIC did, in that it generates a model-class w