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

2006-02-09 Thread Matt S Trout
the uuids in the following format: Applied to branches/DBIx-Class-current and I've given you @dbic-devel so you can commit to both branch and trunk. Have fun and thanks :D -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst

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

2006-02-09 Thread Matt S Trout
this added to the -current branch. PS: sorry for the double mail, Matt No worries :) -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst

Re: [Dbix-class] copying between databases

2006-02-09 Thread Matt S Trout
be pretty easy to implement. Just wrap the appropriate methods on Storage (insert, update, delete), serialise @_ less $self and dump that into the table. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST

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

2006-02-09 Thread Matt S Trout
found the windows perl installation is from ActiveState. So can't anyone tell me how to install DBIx::Class under Windows+ActivePerl? I got it built and installed via CPAN.pm fine, falling back to AS dists every time I encountered an XS module. -- Matt S Trout Offering custom

Re: [Dbix-class] Fw: Namespaces for own components

2006-02-24 Thread Matt S Trout
, and means if I want to change something I believe isn't being used externally I can do a quick recursive grep to check I'm not going to screw anybody over. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST

Re: [Dbix-class] Auto-generate random primary keys

2006-02-28 Thread Matt S Trout
have a similar implementation' might make a good basis for what you're trying to do. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk

Re: [Dbix-class] Auto-generate random primary keys

2006-03-01 Thread Matt S Trout
On Wed, Mar 01, 2006 at 11:58:23AM +0100, Bernhard Graf wrote: Matt S Trout wrote: On Tue, Feb 28, 2006 at 03:55:08PM +0100, Bernhard Graf wrote: Hi, I just started playing around with DBIC. Some tables in my db have random primary keys created by eg. Digest::MD5::md5_hex

Re: [Dbix-class] Auto-generate random primary keys

2006-03-01 Thread Matt S Trout
On Wed, Mar 01, 2006 at 03:14:29PM +0100, Bernhard Graf wrote: Matt S Trout wrote: It's broken. } while ($self-search({$column = $val})); should be } while ($self-result_source-resultset-search({$column = $val})); Very sophisticated. ;-) Unfortunately this results

Re: [Dbix-class] Schema export

2006-03-02 Thread Matt S Trout
-deploy(); to populate an empty database or print $schema-storage-deployment_statements($schema); to spit the CREATE TABLE statements to STDOUT should work fine on the -current branch. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts

Re: [Dbix-class] Fw: Namespaces for own components

2006-03-02 Thread Matt S Trout
On Thu, Mar 02, 2006 at 07:38:54PM +0900, Daisuke Murase wrote: Matt S Trout [EMAIL PROTECTED] wrote: I'd probably say Plugin::*, but it's really a matter of taste. One thing I'd politely ask is could you ask me for svn hosting in the bast repo if you want to develop a DBIC add

Re: [Dbix-class] Quoting table aliases

2006-03-10 Thread Matt S Trout
for DBIC - after years of headaches with Class::DBI, it's just a pleasure to work with. That was the object of the exercise. Thanks :) -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact

Re: [Dbix-class] role of result class?

2006-03-15 Thread Matt S Trout
the problem, so maybe this should be clearly written in the ResultSetManager documentation. ;-) They aren't specified in reverse order, they're specified most specific base class first, just like @ISA, use base and the rest of perl :) -- Matt S Trout Offering custom development

Re: [Dbix-class] role of result class?

2006-03-15 Thread Matt S Trout
. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information + Help us build a better perl ORM: http://dbix

Re: [Dbix-class] RFC: list/array context, TT and search()

2006-03-20 Thread Matt S Trout
on wantarray, but aren't entirely sure what's best. Ideas/comments/suggestions welcome - and that goes for everybody else. Gentlemen, start your mail clients :) -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx

Re: [Dbix-class] RFC: list/array context, TT and search()

2006-03-22 Thread Matt S Trout
behaviour but don't want to spanner anybody relying on it in production. Anybody got any bright ideas? -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst

Re: [Dbix-class] more complex relationships

2006-03-24 Thread Matt S Trout
Jonas Alves wrote: On Friday 24 March 2006 14:21, Matt S Trout wrote: Jess Robinson wrote: I'd still like to see the DBIx::Class code.. So, if I read it correctly now, from sale_item, which has a sale_id and a product_d, you want to get the entry in vendor_product? $schema-resultset

Re: [Dbix-class] Documentation formatting

2006-03-24 Thread Matt S Trout
now, which seems to be the usual standard in POD and is definitely how the entirety of DBIx::Class is written. I don't think it's overly illegible and has the advantage of avoiding linebreaks even under perldoc on an 80x25 xterm (which is what I read everything in :) -- Matt S Trout

Re: [Dbix-class] SQL::Translator::Parser::DBIx::Class

2006-03-27 Thread Matt S Trout
this and clear it up myself but I don't think I'll have time next couple days, sorry - so have a play and tell the list how far you get and we'll see what we can do ...) -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst

Re: [Dbix-class] 2-argument SQL agregates

2006-03-28 Thread Matt S Trout
a field name and a format string: SELECT foo, TO_CHAR('bar', 'Month DD Y') FROM Artist { TO_CHAR = [ 'bar', 'Month DD ' ] } ? Always try the obvious thing first (this assumes you have quoting turned on. if you don't, you probably want \'Month DD ') -- Matt S Trout

Re: [Dbix-class] 2-argument SQL agregates

2006-03-28 Thread Matt S Trout
Doran L. Barton wrote: Matt S Trout wrote: Doran L. Barton wrote: I specifically need to use the TO_CHAR() function which takes a field name and a format string: SELECT foo, TO_CHAR('bar', 'Month DD Y') FROM Artist { TO_CHAR = [ 'bar', 'Month DD ' ] } ? Always try the obvious

[Dbix-class] Info for DBIx-Class developers (svn layout)

2006-03-29 Thread Matt S Trout
created a subbranch about whether to commit stuff to there. If you have something you want to work on that isn't already in progress, feel free to create your own subbranch and get hacking. -- Matt S Trout Offering custom development, consultancy and support Technical Director

[Dbix-class] RFC: Materialized views and DBIx::Class

2006-03-29 Thread Matt S Trout
of the objects and allow all the magic to happen outside the class itself. No relationship should be required. I think. And I've sent this reply to the list as well so we can get this conversation going properly :) -- Matt S Trout Offering custom development, consultancy and support Technical

Re: [Dbix-class] RFC: Materialized views and DBIx::Class

2006-03-29 Thread Matt S Trout
Brandon Black wrote: On 3/29/06, Matt S Trout [EMAIL PROTECTED] wrote: J. Shirley wrote: Hey Matt, Sorry I'm not near an IRC client, but I wanted to run this by you to get your thoughts. I'm looking at a materialized view system (pseudo views in PostgreSQL, but it should work the same

Re: [Dbix-class] get_columns() with inflaters

2006-03-29 Thread Matt S Trout
in the database. I suspect this is intended but... is there a way to automatically get all the columns into an hash *running* the inflaters as well? my %hash = map { ($_ = $o-$_) } $o-columns; ? -- Matt S Trout Offering custom development, consultancy and support Technical Director

Re: [Dbix-class] get_columns() with inflaters

2006-03-29 Thread Matt S Trout
a bloody obvious perl idiom unless somebody else implements them and supplies a patch with tests. Mmm, and I turn 23 in an hour and a half. Somebody fetch me my pipe and slippers so I can sit around saying bah and saying how much better it was in the old days :) -- Matt S Trout

Re: [Dbix-class] get_columns() with inflaters

2006-03-29 Thread Matt S Trout
Christopher H. Laco wrote: Matt S Trout wrote: Michele Beltrame wrote: Hi! my %hash = map { ($_ = $o-$_) } $o-columns; Thanks Matt, this was so easy I didn't even think of it. I don't know why, I was looking for a method which did all automatically. ;-) DBIC doesn't tend to get convenience

Re: [Dbix-class] Auto-joins

2006-03-30 Thread Matt S Trout
the JOIN artist to the FROM part of the SQL statement in the first place, which is what we're discussing here. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst

Re: [Dbix-class] RFC: Syntactic sugar

2006-03-30 Thread Matt S Trout
-database anyway. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information + Help us build a better perl ORM: http

Re: [Dbix-class] Auto-joins

2006-03-30 Thread Matt S Trout
Nilson Santos Figueiredo Junior wrote: On 3/30/06, Matt S Trout [EMAIL PROTECTED] wrote: SQL::Abstract is not modular enough... Please join me on irc at around 18:00 GMT as I'm suffering from this too and want to fix it =) Right. I made this sort-of work in Sweet, but it was a nasty, fragile

Re: [Dbix-class] Auto-joins

2006-03-30 Thread Matt S Trout
Nilson Santos Figueiredo Junior wrote: On 3/30/06, Matt S Trout [EMAIL PROTECTED] wrote: Yes, that would be what we'd intend to do. But for the purposes of that we need a full SQL::Abstract abstract query tree parser with useful callbacks. Guess where the only such parser is. Now note my

Re: [Dbix-class] RFC: Database capabilities

2006-03-30 Thread Matt S Trout
Paul Makepeace wrote: Je 2006-03-29 13:09:07 +0100, Matt S Trout skribis: What things *haven't* you been able to get DBIC to do with your database that you'd like to be able to? The main things I'd kill for are - I know I sound like I'm droning on about this but... I'd like to be able

Re: [Dbix-class] stupid ?: how to create new objects save them?

2006-04-01 Thread Matt S Trout
not in the database yet. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information + Help us build a better perl ORM

Re: [Dbix-class] RFC: DBIx-Class-Tree

2006-04-03 Thread Matt S Trout
, but has been in the DBIC subversion repo for a while. If nobody's massively offended by the idea I think I'd like to roll the ::Ordered component into 0.06001 along with the SQLT deploy improvements in -current. What do people think of this idea? -- Matt S Trout Offering custom

Re: [Dbix-class] RFC: DBIx::Class::Sweet

2006-04-03 Thread Matt S Trout
that __PACKAGE__ is ugly as hell. So this fixes it. Btw: Why not just use http://search.cpan.org/~bauerb/Class-Method-Auto-1.00/lib/Class/Method/Auto.pm ? -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class

Re: [Dbix-class] RFC: DBIx-Class-Tree

2006-04-03 Thread Matt S Trout
seem pretty minimal to me. I'm not convinced it belongs in the main distribution. I think given it's lightweight, self-contained and represents a fairly common case any time you're modeling semantic data it might as well be. -- Matt S Trout Offering custom development, consultancy

Re: [Dbix-class] RFC: DBIx-Class-Tree

2006-04-04 Thread Matt S Trout
constrained to a single parent, right? -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information + Help us build

Re: [Dbix-class] Apache::DBI and DBIx::Class

2006-04-05 Thread Matt S Trout
::DBI use, I'd be interested to hear. I can also think of two possible workarounds - (1) use sqlrelay for thread pooling, (2) override Storage::DBI's connect() method to not route round Apache::DBI and keep an eye on your connections yourself. -- Matt S Trout Offering custom

Re: [Dbix-class] unique constrains are ignored when using find_or_create

2006-04-05 Thread Matt S Trout
. I didn't realise you hadn't added it when you did update_or_create -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more

Re: [Dbix-class] prefetch syntax

2006-04-07 Thread Matt S Trout
, { prefetch = { parent = { parent = 'parent' } } } ); If it doesn't work the way you're trying it, evidently I didn't get the code for this *quite* right. Any chance you could try and put together a test case against DBICTest? -- Matt S Trout Offering custom development

Re: [Dbix-class] setting SQL function

2006-04-10 Thread Matt S Trout
; $obj-discard_changes; might work (I have an awful cold today so I may be off there). -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst

Re: [Dbix-class] Running $rs-count() on full resultset?

2006-04-11 Thread Matt S Trout
Jesse Sheidlower wrote: On Mon, Apr 10, 2006 at 02:52:49PM +0100, Matt S Trout wrote: Jesse Sheidlower wrote: I'm dynamically constructing my $rs search statements, and including page and rows values in my attribute hash, for paged results. Don't do it that way. my $rs = $schema-resultset

Re: [Dbix-class] setting SQL function

2006-04-11 Thread Matt S Trout
Mark Hedges wrote: On Mon, 10 Apr 2006, Matt S Trout wrote: Mark Hedges wrote: Sorry I've missed how to do this. I want to set columns to raw SQL. For instance, I want to set a datetime field to sql 'now()' (i.e. 'CURRENT_TIMESTAMP()'). In mysql type 'timestamp' fields do the right

Re: [Dbix-class] Bug (?) with foreign key / relationship updates

2006-04-29 Thread Matt S Trout
($mj-artistid); would both work. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information + Help us build a better

Re: [Dbix-class] Caching connections

2006-04-30 Thread Matt S Trout
level and have a single db connection for the app (or in odd cases two, one for reading and a higher-privilege one for writing). -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact

Re: [Dbix-class] Possible trouble with ResultSet::new_result, was: Why are these two relations different?

2006-05-04 Thread Matt S Trout
John Napiorkowski wrote: I got an answer to one more question before giving up on this: [big snip] I can't figure out what module/method that ...-new(\%new) is referring to. It's not referring to the new method in ResultSet.pm but I can't trace it from here. [another big snip]

Re: [Dbix-class] Accessing $dbh for blobs/large-objects

2006-05-09 Thread Matt S Trout
Toby Corkindale wrote: Following on from discussion on IRC: * Answer: No, D::C doesn't have blob filehandle-alike operations. A crash-course in BLOBs for the uninitiated: * A BLOB is a binary large object. * BLOBs can be arbitrarily large - eg. many gigabytes - so you don't really want

Re: [Dbix-class] ping 'from' attribute doc author: you need to fix them

2006-05-10 Thread Matt S Trout
Toby Corkindale wrote: It's not neccessary, but I *should* be able to use 'from' to do what I was doing. Even if I didn't need it then, I will probably need it in the future. (Either that, or I have to break out the Real SQL (tm) to do anything complex.. which sort of defeats the point.)

Re: [Dbix-class] ping 'from' attribute doc author: you need to fix them

2006-05-10 Thread Matt S Trout
Toby Corkindale wrote: On Wed, May 10, 2006 at 10:00:07AM -0700, Aran Deltac wrote: Can whoever originally wrote this step up and correct it please? And perhaps add another couple of tests to your test suite? Toby - would you be willing to create these? If someone can provide documentation

Re: [Dbix-class] ping 'from' attribute doc author: you need to fix them

2006-05-10 Thread Matt S Trout
Brandon Black wrote: On 5/10/06, Matt S Trout [EMAIL PROTECTED] wrote: Cjoin will usually do what you need and it is strongly recommended that you avoid using Cfrom unless you cannot achieve the desired result using Cjoin. And we really do mean cannot, not just tried and failed. Attempting

Re: [Dbix-class] ENUM values from MySQL using the column_info()

2006-05-13 Thread Matt S Trout
Zbigniew Lukasiak wrote: Hmm, what I was proposing at that time was to lowercase the retrieved hash with columns info and then also lowercase the column name when matching. The effect would be exacly caseinsensitiviness but I was not using that word. I felt that what was expected from me was

Re: [Dbix-class] ENUM values from MySQL using the column_info()

2006-05-15 Thread Matt S Trout
Zbigniew Lukasiak wrote: On 5/15/06, Matt S Trout [EMAIL PROTECTED] wrote: The point of the case-sensitive match is that *if* there are e.g. columns 'name' and 'NAME', and *if* the DBD returns separate column info for 'name' and 'NAME', the two column info chunks get matched

Re: [Dbix-class] What is a cascading update?

2006-05-17 Thread Matt S Trout
in the parent class? Pretty much exactly that, yes. It does currently sometimes do an unnecessary SELECT though, which will be fixed in 0.06003 -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Matt S Trout
would be an excellent addition to the manual and much appreciated. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more

Re: [Dbix-class] Getting access to the DB handle

2006-05-18 Thread Matt S Trout
an AutoInflate::DateTime component that'll pick up the column data type and setup inflate/deflate methods appropriately - have a look at branches/DBIx-Class/datetime in svn for my progress so far. -- Matt S Trout Offering custom development, consultancy and support Technical Director

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Matt S Trout
a lot more emphasis on that than I think any other perl ORM does - native GROUP BY and HAVING support being something I think is unique to us currently, and I have every intention of getting subqueries, EXISTS and NOT EXISTS clauses working soon. -- Matt S Trout Offering custom

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Matt S Trout
Toby Corkindale wrote: On Thu, May 18, 2006 at 01:31:26PM +0100, Matt S Trout wrote: Toby Corkindale wrote: On Thu, May 18, 2006 at 01:11:46AM -0700, John Napiorkowski wrote: To be honest I am sure part of my problem is ignorance about the best way to use DBIx. So your suggestions of any

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Matt S Trout
Brandon Black wrote: On 5/18/06, Matt S Trout [EMAIL PROTECTED] wrote: equivalent to the pure hand-crafted SQL you would have done anyway, I want to know what the difference is so I can hack it in as a supported feature. Just for the record, here's one of my queries I've been unable

Re: [Dbix-class] [Catalyst] IF YOU USE SCHEMALOADER, TEST THIS: DBIx::Class::Schema::Loader 0.02999_08 is out

2006-05-21 Thread Matt S Trout
Brandon Black wrote: ... And could use some testing. After a little more time cleaning up documentation and wrangling any bugs that make themselves evident, this will become the new stable release in the near future. Please test this (if you are able) for correct backwards compatibility with

Re: [Dbix-class] [Catalyst] Announce: DBIx-Class-0.06003

2006-05-23 Thread Matt S Trout
Scott Karns wrote: Jess Robinson wrote: Revision history for DBIx::Class 0.06003 - make find_or_create_related check defined() instead of truth - don't unnecessarily fetch rels for cascade_update - don't set_columns explicitly in update_or_create; instead use

Re: [Dbix-class] update_or_insert from hash reference

2006-05-23 Thread Matt S Trout
Fernan Aguero wrote: Hi! I'm new to DBIx::Class and after setting up a mysql database I'm trying to test DBIx::Class by defining a minimal object-relational mapping for a single table: TABLE users ( user_id (PK, auto_increment), username, firstname, lastname.

Re: [Dbix-class] update_or_insert from hash reference

2006-05-23 Thread Matt S Trout
Fernan Aguero wrote: package MyApp::DB::Users; use base qw/DBIx::Class/; use DBIx::Class::Row; __PACKAGE__-load_components( qw/Core/ ); You were right about load_components. I was thrown off by the extraneous use, sorry. ___ List:

Re: [Dbix-class] update_or_insert from hash reference

2006-05-23 Thread Matt S Trout
John Li wrote: Will it use the primary key as declared in Users.pm? Or should I have to pass it as an extra attribute to the search call? (i.e. as in -search( hashRef, { key = user_id } ) ) I've already tried this and it didn't work ... but maybe I'm doing something wrong (again). my

Re: [Dbix-class] Devel::Cycle 1.07 released with bugfix

2006-05-24 Thread Matt S Trout
Matt S Trout wrote: Please don't worry about this and either (a) downgrade to Devel::Cycle 1.04, (b) force install the 06003 dist provided all other tests pass, or (c) modify your local copy of Devel/Cycle.pm as detailed in my reply to the RT ticket here http://rt.cpan.org/Ticket

Re: [Dbix-class] Naming columns in nested joins

2006-05-24 Thread Matt S Trout
Jon wrote: Basically, yes, you're supposed to keep track of it. Having a regular, simple rule for how relationships get aliased a second or third time means that you can always predict accurately what a given table in the query is going to be called, and means DBIC can always

Re: [Dbix-class] Branch status reports please

2006-05-24 Thread Matt S Trout
Carl Franks wrote: columns_info_for - Carl Franks? - don't think this has been worked on much yet? This won't be making it in. As far as I remember, its mysql support is complete. No support for other backends yet though. If it (a) works, (b) is an improvement on what's in -current,

Re: [Dbix-class] Naming columns in nested joins

2006-05-24 Thread Matt S Trout
Brandon Black wrote: On 5/24/06, Matt S Trout [EMAIL PROTECTED] wrote: The DBIC search syntax is effectively an SQL abstract syntax tree; if you want to maintain total abstraction for client applications, adding (and documenting :) a custom resultset class with additional search methods

Re: [Dbix-class] Branch status reports please

2006-05-24 Thread Matt S Trout
Aran Deltac wrote: many_to_many - bluefeet, jguenther? - would like to see this for 07 but it's an incremental improvement to helper stuff so we can probably sneak it into an 07xxx if we have to Got stumped on it, probably something silly. If anyone wants to help with this one I'd

Re: [Dbix-class] Branch status reports please

2006-05-24 Thread Matt S Trout
Daniel Westermann-Clark wrote: On 2006-05-24 13:20:32 +0100, Matt S Trout wrote: find_compat - dwc - needs to merge back for 07 since it makes older find semantics still work without disrupting the new and improved unique-key-driven find I started last night by allowing the non

Re: [Dbix-class] Naming columns in nested joins

2006-05-24 Thread Matt S Trout
Christopher H. Laco wrote: Brandon Black wrote: On 5/24/06, Matt S Trout [EMAIL PROTECTED] wrote: Something I'm very interested in doing once we have subselects is to allow the specification of a subselect as a ResultSource, with a view (oh gods) to being able to deploy it to the database

Re: [Dbix-class] Branch status reports please

2006-05-25 Thread Matt S Trout
Jesper Krogh wrote: Matt S Trout wrote: pg_bytea - not even sure whose this is anymore - doesn't seem to have any changes; I'm guessing this is 08+ ? Mine, just delete it .. (perhaps I can do that myself). I was trying to pass the result-source instead of the tablename to the Storage

Re: [Dbix-class] Specify tables for DBIx::Class::Schema::Loader

2006-05-26 Thread Matt S Trout
John Li wrote: Hi, Is there anyway that we can specify tables that we want/don't want in DBIx::Class::Schema::Loader::make_schema_at? Preferably using regular expressions or an arrayref of table names. Y'know, this is documented :)

Re: [Dbix-class] Announcement: DBIx-Class-0.06999_01

2006-05-28 Thread Matt S Trout
Dan Horne wrote: From: [EMAIL PROTECTED] [mailto:dbix-class- [EMAIL PROTECTED] On Behalf Of Aran Deltac [snip] Also, the change list stated that there is a new AutoInflate::DateTime module. This modules name is actually InflateColumn::DateTime. Aran I'm curious to know how to make use

Re: [Dbix-class] Announcement: DBIx-Class-0.06999_01

2006-05-28 Thread Matt S Trout
Dan Horne wrote: On Behalf Of Matt S Trout Dan Horne wrote: From: [EMAIL PROTECTED] [mailto:dbix-class- [EMAIL PROTECTED] On Behalf Of Aran Deltac [snip] Also, the change list stated that there is a new AutoInflate::DateTime module. This modules name is actually InflateColumn::DateTime

Re: [Dbix-class] Inflating and deflating Oracle dates

2006-06-04 Thread Matt S Trout
Dan Horne wrote: From: [EMAIL PROTECTED] [mailto:dbix-class- [EMAIL PROTECTED] On Behalf Of Matt S Trout Couldn't you just mirror how on_connect_do handles this? Quite possibly, now that you've pointed it out to me ;-) I guess the problem I'm experiencing is that I don't know the best

Re: [Dbix-class] Inflating and deflating Oracle dates

2006-06-07 Thread Matt S Trout
Dan Horne wrote: From: [EMAIL PROTECTED] [mailto:dbix-class- [EMAIL PROTECTED] On Behalf Of Hartmaier Alexander Sent: Tuesday, 6 June 2006 8:59 p.m. I created on_connect_do for exactly this purpose. I use Oracle and needed to set the date format because the one in the oracle init file isn't

Re: [Dbix-class] Molesting Schemas

2006-06-07 Thread Matt S Trout
Christopher H. Laco wrote: Matt S Trout wrote: Christopher H. Laco wrote: As part of the new Handel stuff, I'm trying to provide as much ability as possible of using an existing schema instead of just relying on the default Handel schema. As part of this process, I'm 'injecting

Re: [Dbix-class] InflateColumn::DateTime

2006-06-07 Thread Matt S Trout
Christopher H. Laco wrote: Can someone give me a quick synopsis of how this works. It looks like it's always loaded, and only intervenes when it sees a column_info data_type of 'datetime'. It's not always loaded, you have to ask for it. Yeah, all it does is intervene in the case of a

Re: [Dbix-class] possible bug in DBIC:ResultSet?

2006-06-07 Thread Matt S Trout
Mark Hedges wrote: On Tue, 6 Jun 2006, Mark Hedges wrote: I didn't look closely. This is another entity that has a timestamp DEFAULT CURRENT_TIMESTAMP() as a column of an MCPK. I tried adding __PACKAGE__-load_components(qw( PK::Auto Core )); to the class package for this entity. It

Re: [Dbix-class] InflateColumn::DateTime

2006-06-08 Thread Matt S Trout
[EMAIL PROTECTED] wrote: Hey Matt, No it isn't, because it stops you being able to do date math on your DB. One of the intentions of this feature is that once it's fully supported across all the databases we handle it'll make Epoch unnecessary. If the ::Epoch author's about on this list,

Re: [Dbix-class] InflateColumn::DateTime

2006-06-08 Thread Matt S Trout
Mark Hedges wrote: On Wed, 7 Jun 2006 [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] To: dbix-class@lists.rawmode.org Date: Wed, 07 Jun 2006 21:30:25 -0300 Subject: Re: [Dbix-class] InflateColumn::DateTime Hey Matt, No it isn't, because it stops you being able to do date math on your

Re: [Dbix-class] searchable archive of the list?

2006-06-08 Thread Matt S Trout
has the following header, along with all the other usual suspects: List-Archive: http://lists.rawmode.org/pipermail/dbix-class Regards, See term: searchable. :-) See google.com and the site: and similar search modifiers :-) -- Matt S Trout Offering custom development

Re: [Dbix-class] Is this the canonical way to do this?

2006-06-08 Thread Matt S Trout
my table designs. Note that find is always a 0 or 1 record query (or should be), so it returns a row object of the appropriate class, not a resultset. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class

Re: [Dbix-class] searchable archive of the list?

2006-06-08 Thread Matt S Trout
-based archives go, I prefer that site to most others, including Gossamer and Gmane. It has an on-site search too. Cheers. Note the list footer :) -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class

Re: [Dbix-class] InflateColumn::DateTime

2006-06-09 Thread Matt S Trout
in. Commit the anti-warnings patch to current please and add a failing test for this issue. I'll have a look at it later. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd

Re: [Dbix-class] Announcement: DBIx-Class-0.06999_02

2006-06-10 Thread Matt S Trout
think it does. And does it automagically for DBD::Sybase in general since TDS' bind var implementation appears to blow goats anyway. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact

[Dbix-class] They gave us BoF space! (YACP::EU 2006)

2006-06-16 Thread Matt S Trout
http://www.birmingham2006.com/cgi-bin/yapc.pl?act=talk-itemtalkid=77 So, who's turning up then? -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst

Re: [Dbix-class] DBIx::Class or Rose::DB::Object or other???

2006-06-19 Thread Matt S Trout
Jesper Krogh wrote: Matt S Trout wrote: 1. RDBO is faster. 2. DBIC has a Class::DBI compatibility layer that will make the transition from CDBI easier RDBO is much faster on the perl side; in a majority of situations you can generate SQL that's just as efficient on the database using DBIC

Re: [Dbix-class] HOWTO: functions in update

2006-06-19 Thread Matt S Trout
()' instead of update table changed = now() =cut $row-changed( 'now()' ); $row-update(changed = \'now()'); $row-discard_changes; # re-fetch from DB -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx

Re: [Dbix-class] [Catalyst] They gave us BoF space! (YACP::EU 2006)

2006-06-20 Thread Matt S Trout
Michael Gray wrote: Matt S Trout wrote: http://www.birmingham2006.com/cgi-bin/yapc.pl?act=talk-itemtalkid=77 So, who's turning up then? I'd like to attend, as long as it's okay to sit on the sidelines and absorb, since I'm not really a contributor (yet). Of course. My intent

Re: [Dbix-class] quote char works with sorting without breaking too much!

2006-06-21 Thread Matt S Trout
break current functionality.. or am I missing anything? how about { -desc = 'colname' } ? -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst

Re: [Dbix-class] Class::DBI vs DBIx and CDBICompat

2006-06-23 Thread Matt S Trout
simply isn't capable of things we tend to take for granted. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information

Re: [Dbix-class] fork- and thread-safe

2006-06-23 Thread Matt S Trout
of my code. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information + Help us build a better perl ORM: http://dbix

[Dbix-class] Windows installation failure logs please

2006-06-24 Thread Matt S Trout
to re-create and fix the problems - and if it's all in one place (i.e. this thread) that should make it a bit easier :) -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact Shadowcat Systems

Re: [Dbix-class] Problems getting prefetch to work..

2006-06-24 Thread Matt S Trout
a user object by $rs-next; I would like to be able to get a session obect and the user object from that one line.. You just did. Call $user-user_session to get the session object ... -- Matt S Trout Offering custom development, consultancy and support Technical Director

Re: [Dbix-class] Problems getting prefetch to work..

2006-06-24 Thread Matt S Trout
' }, { prefetch = 'user' }); then $rs-next will return a $session object with $session-user already populated with the appropriate user object -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class and BAST. Contact

Re: [Dbix-class] Problems getting prefetch to work..

2006-06-24 Thread Matt S Trout
Tim Watson wrote: On 6/24/06, Matt S Trout [EMAIL PROTECTED] wrote: Tim Watson wrote: I think I was going about this a little reverse... This works... my $rs = $dbh-resultset('User')-search({ 'sessionid' = '123456' } ,{ prefetch = 'user_session' }); But I am unable to figure out how

Re: [Dbix-class] Windows installation failure logs please

2006-06-25 Thread Matt S Trout
Nilson Santos Figueiredo Junior wrote: On 6/24/06, Matt S Trout [EMAIL PROTECTED] wrote: Can everybody who's been having trouble on windows do a full test run, then do a prove -l t/XXX.t for each failing one and capture the log output from that please? Under WinXP Pro, AS Perl 5.8.8

Re: [Dbix-class] Class::DBI vs DBIx and CDBICompat

2006-06-25 Thread Matt S Trout
not exactly a guaranteed means - plus there are a hell of a lot more committers and contributors than just me who are more likely to see it on the list. -- Matt S Trout Offering custom development, consultancy and support Technical Directorcontracts for Catalyst, DBIx::Class

Re: [Dbix-class] Patch for SQL::Translator::Parser::DBIx::Class

2006-06-25 Thread Matt S Trout
additional testing with more complex schema then I have readily available. The changes are clearly harmful. A schema class simply acts as a prototype for objects of that class, it is not guaranteed to contain all the requisite data. -- Matt S Trout Offering custom development

Re: [Dbix-class] Patch for SQL::Translator::Parser::DBIx::Class

2006-06-25 Thread Matt S Trout
Sebastian Willert wrote: On Sun, 2006-06-25 at 20:39 +0100, Matt S Trout wrote: Sebastian Willert wrote: Hi all, after some late-night discussion with castaway about DBIC::Schema-deploy() we noticed that SQL::Translator::Parser::DBIx::Class tries to query the connected database

  1   2   3   4   5   >