Search Discussions

65 discussions - 261 posts

  • 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 - Sub-select support EXISTS and NOT EXISTS (which needs ...
    Matt S TroutMatt S Trout
    Mar 29, 2006 at 12:09 pm
    Apr 3, 2006 at 5:47 pm
  • In my table class inflate_column doesn't seemed to do anything. My table class looked like: package TDW::Schema::User; use base 'DBIx::Class'; use strict; use DateTime::Format::MySQL; __PACKAGE__- ...
    Bernhard GrafBernhard Graf
    Mar 2, 2006 at 3:39 pm
    Mar 2, 2006 at 8:42 pm
  • Hi, I'm trying to understand the role of the result_class, and I have what I think are naive questions. In a schema with My::Schema::Artist ... my $schema- resultset('Artist')- search(); My::Artist- ...
    Richard JollyRichard Jolly
    Mar 7, 2006 at 7:31 am
    Mar 15, 2006 at 7:49 pm
  • While reading the documentation I couldn't find any reference regarding DBIx::Class performing auto-joins. You'd always need to explicitely specify them. Is there any reason preventing this from ...
    Nilson Santos Figueiredo JuniorNilson Santos Figueiredo Junior
    Mar 30, 2006 at 1:28 am
    Mar 31, 2006 at 4:51 pm
  • Matt asked me to join and forward this to the list to start a discussion on how to do N-directional joins in relationships. Now it's limited to "me" and "foreign" in any relationship, but real-world ...
    Mark HedgesMark Hedges
    Mar 22, 2006 at 5:57 pm
    Mar 24, 2006 at 5:14 pm
  • As of 0.06, we're doing substantially better documentation-wise due to the sterling efforts of a substantial number of contributors. But - getting all the interfaces documented, arguments, return ...
    Matt S TroutMatt S Trout
    Mar 29, 2006 at 12:13 pm
    Apr 4, 2006 at 9:43 am
  • I've started work on extra HTML-Widget constraints at http://dev.catalyst.perl.org/repos/Catalyst/trunk/HTML-Widget-Constraint-MySQL/ At the moment, the intended use is something like: $w- ...
    Carl FranksCarl Franks
    Mar 24, 2006 at 2:11 pm
    Mar 28, 2006 at 1:08 pm
  • Hi, DBIx::Class::AlwaysRS was on my list of things to get around to looking at. Now it seems to be only available on backpan, though it is still mentioned in the POD of ResultSetManager and ...
    Richard JollyRichard Jolly
    Mar 20, 2006 at 12:24 pm
    Mar 23, 2006 at 10:40 am
  • I'm not sure what I've managed to do here, but the exercise of upgrading from 0.04xxx to 0.05007 and converting from DB to Schema has stopped my Oracle automatic primary keys from working. I'll start ...
    James FitzGibbonJames FitzGibbon
    Mar 8, 2006 at 8:07 pm
    Mar 13, 2006 at 2:01 pm
  • One more question: It looks like in- and deflators are only called it the column value is defined. Is this intended? -- Bernhard Graf
    Bernhard GrafBernhard Graf
    Mar 2, 2006 at 7:54 pm
    Mar 3, 2006 at 12:30 pm
  • Hello all, I just committed to trunk some changes with the formatting of arguments/return values in method documentation. As agreed on #dbix-class, the new format is: =over 4 =item Arguments: (...) ...
    Justin GuentherJustin Guenther
    Mar 24, 2006 at 7:26 am
    Mar 27, 2006 at 11:55 am
  • Hi, With Brandon's help, I've created a simple example that uses Schema::Loader, but I've hit a snag when I tried to use has_many. First, the loader was created in the file Test/Schema.pm, and my ...
    Vsevolod (Simon) IlyushchenkoVsevolod (Simon) Ilyushchenko
    Mar 22, 2006 at 1:06 pm
    Mar 23, 2006 at 12:32 am
  • Hi. I can't use two own components that use ResultSetManager. ex: package DBIx::Class::Foo; use strict; use base qw/DBIx::Class/; __PACKAGE__- load_components(qw/ResultSetManager/); sub foo : ...
    Atsushi kobayashiAtsushi kobayashi
    Mar 14, 2006 at 12:43 pm
    Mar 17, 2006 at 9:27 am
  • Somebody posted a proposal (and an evil Want hack as a possible implementation) for a neat bit of syntax, but (1) it's attached to an old thread, (2) it didn't particularly define what the syntax ...
    Matt S TroutMatt S Trout
    Mar 29, 2006 at 12:06 pm
    Mar 30, 2006 at 5:49 pm
  • Hello! I need to copy all the columns of a row object into an hash, so I do: my $o = $c- model('Dbs')- resultset('Book')- find($id); my %myhash = $o- get_columns; This works fine, but inflaters are ...
    Michele BeltrameMichele Beltrame
    Mar 29, 2006 at 8:53 pm
    Mar 29, 2006 at 9:44 pm
  • I need some help figuring out if it's possible, and if so how, to specify a 2-argument aggregate function for a search query using DBIx::Class. The examples in the docs say you can do this: my $rs = ...
    Doran L. BartonDoran L. Barton
    Mar 28, 2006 at 3:57 pm
    Mar 28, 2006 at 5:11 pm
  • While playing with SQL::Translator to generate sql scripts from schemas, I noticed that the DBIx::Class parser seemed to grab only one column of multi-column relationships. It looks like just making ...
    Stephan SzaboStephan Szabo
    Mar 26, 2006 at 8:05 pm
    Mar 28, 2006 at 2:00 am
  • Thanks. It makes sense, but it doesn't quite jibe with my experience. I've made the problem more concrete... I'm trying to override the create() method of a particular class, so that it creates two ...
    Richard JollyRichard Jolly
    Mar 8, 2006 at 11:35 am
    Mar 9, 2006 at 8:01 am
  • Cookbook tells: "To create a MySQL database from an existing DBIx::Class schema, convert the schema to MySQL's dialect of SQL: sqlt --from DBIx::Class --to MySQL --DBIx::Class "MySchema.pm" ...
    Bernhard GrafBernhard Graf
    Mar 1, 2006 at 11:08 pm
    Mar 2, 2006 at 2:43 pm
  • Hey all, I'm trying out DBIC for the first time and something in the docs has me scratching my head. I'm pretty sure I'm just completely misunderstanding something but this seems odd to me. From the ...
    Tim McIntyreTim McIntyre
    Mar 1, 2006 at 5:24 pm
    Apr 28, 2006 at 3:37 pm
  • Hi, I have a simple cascade delete test that fails under 6.0 but passed under 5.007. my $foo = $schema- resultset('Foo')- create({ foo = 1 }); my $bar = $schema- resultset('Bar')- create({ bar = 1 ...
    Richard JollyRichard Jolly
    Mar 30, 2006 at 11:14 am
    Apr 2, 2006 at 10:41 pm
  • Hi, I'm currently using Class::DBI in some larger web applications and "watching" this list. I've been playing around a bit with it (0.0499) and now have two questions: What is the preferred way to ...
    Rolf SchaufelbergerRolf Schaufelberger
    Mar 22, 2006 at 4:47 pm
    Mar 23, 2006 at 1:20 am
  • I've been trying to follow the example made in the cookbook, but for some reason, the "as"= part doesn't seem to be working: my $qs=$schema- resultset('Schema::Msgs')- search({}, {select = [ ...
    Matija GrabnarMatija Grabnar
    Mar 19, 2006 at 9:29 pm
    Mar 22, 2006 at 2:30 am
  • Well, like I said, I have been researching the issue and feel I can identify with both sides of the issue. My acedemic background (and most of my work experience) is OOP, so I am rather biased in ...
    Mar 15, 2006 at 9:57 pm
    Mar 16, 2006 at 6:54 pm
  • Hi. I'm having problems with using the update_or_create-method? - it seems to boil down to DBIx::Class not knowing that I have a UNIQUE-declaration in addition to the PRIMARY KEY on the table in ...
    Adam SjøgrenAdam Sjøgren
    Mar 6, 2006 at 12:08 pm
    Mar 6, 2006 at 5:44 pm
  • Hello, I'm facing a very weird problem while trying to use auto-inflated columns (with Catalyst). The auto-inflating is setup as: __PACKAGE__- inflate_column('update_time', { inflate = sub { ...
    Nilson Santos Figueiredo JuniorNilson Santos Figueiredo Junior
    Mar 31, 2006 at 3:04 pm
    Mar 31, 2006 at 3:31 pm
  • Build a resultset representing the view. Reflect this into a resultsource object. from clause returns the (SELECT ...), unless a flag is set that it's been deployed as a real view, in which case just ...
    Matt S TroutMatt S Trout
    Mar 29, 2006 at 7:55 pm
    Mar 29, 2006 at 8:43 pm
  • I just noticed this. These are modules with pod: For some reason, the last two aren't linked to their podhtml at all. Now, below that , is the "Documentation" section... What the hell are the UUID* ...
    Christopher H. LacoChristopher H. Laco
    Mar 29, 2006 at 8:01 pm
    Mar 29, 2006 at 8:24 pm
  • Hello! In a table schema of mine I have: __PACKAGE__- inflate_column('published', { inflate = sub { time_db2obj(shift) }, deflate = sub { time_obj2db(shift) }, }); I noticed that the deflate method ...
    Michele BeltrameMichele Beltrame
    Mar 22, 2006 at 11:52 am
    Mar 23, 2006 at 8:11 am
  • Found it. There's good news and there's bad news. The good news: most people won't be affected by the leak. The bad news: it's not just me. The problem is in DBI.pm, specifically in the sth method: ...
    Alan HumphreyAlan Humphrey
    Mar 15, 2006 at 6:33 pm
    Mar 16, 2006 at 7:20 pm
  • Changes from trunk - - renamed cols attribute to columns (cols still supported) - added has_column_loaded to Row - Storage::DBI connect_info supports coderef returning dbh as 1st arg - ...
    Matt S TroutMatt S Trout
    Mar 9, 2006 at 7:05 pm
    Mar 9, 2006 at 7:24 pm
  • As raised earlier by Andrew Main on this list, I think "Foo" examples in documentation badly need to be replaced by examples that the rest of us can more easily relate to. Of course, my abstract ...
    Maurice HeightMaurice Height
    Mar 6, 2006 at 2:10 pm
    Mar 7, 2006 at 11:53 am
  • I get an error when trying to access data with DBIC in Catalyst. I am sure I am doing something dumb like not doing a "connect" first but I can't figure out how that is done from the ...
    Maurice HeightMaurice Height
    Mar 5, 2006 at 11:29 pm
    Mar 6, 2006 at 1:23 pm
  • Hi, Are there any publicly available sites that show working, best practice examples? I use the DBIC tests as example code, but they don't reflect a "normal" code structure. Browsing working code can ...
    Richard JollyRichard Jolly
    Mar 2, 2006 at 6:32 pm
    Mar 6, 2006 at 12:07 pm
  • http://search.cpan.org/~mstrout/DBIx-Class-0.05007/lib/DBIx/Class/Manual/Cookbook.pod#Setting_default_values_for_a_row suggest overriding new() to set default values on creation. What's the best way ...
    Bernhard GrafBernhard Graf
    Mar 2, 2006 at 7:58 pm
    Mar 2, 2006 at 9:06 pm
  • Was speaking with castaway in IRC, and discovered belongs_to didn't seem to work (in this case) without fully specifying the package name: __PACKAGE__- belongs_to('role' = 'Role'); # The above line ...
    Ash BerlinAsh Berlin
    Mar 26, 2006 at 2:54 pm
    Mar 26, 2006 at 3:07 pm
  • Hi... Wouldn't you want to use the schema lib first from startup.pl? The I would assume the information gathered from the series of "describe tables" statements and relationship setups would stored ...
    Mark HedgesMark Hedges
    Mar 22, 2006 at 5:52 pm
    Mar 22, 2006 at 7:43 pm
  • *snip* Index: lib/DBIx/Class/Manual/Cookbook.pod =================================================================== --- lib/DBIx/Class/Manual/Cookbook.pod (revision 1261) +++ ...
    Hartmaier AlexanderHartmaier Alexander
    Mar 20, 2006 at 5:24 pm
    Mar 20, 2006 at 6:17 pm
  • Hi, $obj- in_storage is not correct if the object has been deleted by a cascade delete. Is that a problem? I'm not sure how you could guarantee that in_storage is always correct, baring doing a ...
    Richard JollyRichard Jolly
    Mar 15, 2006 at 7:27 pm
    Mar 16, 2006 at 1:19 pm
  • I'd like to have DBIx::Class::HTMLWidget set my widget element's maxlength if available from DBIC result_source and appropriate for the widget element. I attach my changes here. This is not very much ...
    Bernhard GrafBernhard Graf
    Mar 12, 2006 at 12:28 am
    Mar 13, 2006 at 5:43 pm
  • Brandon (or anyone else), Can someone please post a Catalyst::Model::DBIC::Schema-based sample application? I got the new Schema::Loader to work on its own, but not under Catalyst so far. The Helpers ...
    Vsevolod (Simon) IlyushchenkoVsevolod (Simon) Ilyushchenko
    Mar 11, 2006 at 3:11 pm
    Mar 11, 2006 at 4:48 pm
  • Hi, Would it be possible to have DBIx::Class always quote all table identifiers to avoid namespace conflicts? For example, here's the SQL generated for a many-to-many relationship I have: SELECT ...
    Dmitri BichkoDmitri Bichko
    Mar 10, 2006 at 12:56 pm
    Mar 10, 2006 at 1:05 pm
  • I have a table of events, and another table of parent relationships, as below. package cdiary::Schema::Event; __PACKAGE__- table('events'); __PACKAGE__- add_columns(qw/ id title /); __PACKAGE__- ...
    Carl FranksCarl Franks
    Mar 3, 2006 at 11:58 am
    Mar 3, 2006 at 12:41 pm
  • How can i use overload to stringify a resultset object? I can't find anything in the docs. Thanks --Jonas
    Jonas AlvesJonas Alves
    Mar 2, 2006 at 12:59 am
    Mar 2, 2006 at 1:10 am
  • I just got stumped on this earlier. What would the - search syntax be to get a literal on the left-hand side and the column on the right-hand side of an operator? In my case, a column in the table ...
    Brandon BlackBrandon Black
    Mar 31, 2006 at 5:26 pm
    Mar 31, 2006 at 5:26 pm
  • Warning: wild incoherent rambling and pseudo code ahead! OK, I really want to start working on a Catalyst/Handel ecomm package. But before I venture that way, I guess I need to get Handel converted ...
    Christopher H. LacoChristopher H. Laco
    Mar 29, 2006 at 3:57 pm
    Mar 29, 2006 at 3:57 pm
  • Yay! Three-tier layout - trunk/DBIx-Class : main codebase. bar a marge prior to a major version release, nothing bar bug fixes goes here (minor feature additions are ok but talk it over with people ...
    Matt S TroutMatt S Trout
    Mar 29, 2006 at 2:14 pm
    Mar 29, 2006 at 2:14 pm
  • BIx-Class 0.06000 has hit PAUSE and should be available from your CPAN mirror of choice soon; in the meantime you can get it from http://trout.me.uk/perl/DBIx-Class-0.06000.tar.gz This release has ...
    Matt S TroutMatt S Trout
    Mar 25, 2006 at 7:20 pm
    Mar 25, 2006 at 7:20 pm
  • And we've been having something of a docs push in the mean time. Comments and suggestions are welcome, and if you have any doc requests/tweaks/patches, now would be the time to send 'em to the list ...
    Matt S TroutMatt S Trout
    Mar 23, 2006 at 1:38 am
    Mar 23, 2006 at 1:38 am
  • Can be picked up at http://pause.perl.org/incoming/DBIx-Class-Schema-Loader-0.02007.tar.gz Changes for this release: 0.02007 Wed Mar 22 06:03:53 UTC 2006 - Backported Class::C3::reinitialize changes ...
    Brandon BlackBrandon Black
    Mar 22, 2006 at 6:28 am
    Mar 22, 2006 at 6:28 am
Group Navigation
period‹ prev | Mar 2006 | next ›
Group Overview
groupdbix-class @
categoriesperl, catalyst

52 users for March 2006

Matt S Trout: 60 posts Brandon Black: 25 posts Bernhard Graf: 22 posts Michele Beltrame: 14 posts Mark Hedges: 11 posts Carl Franks: 10 posts Christopher H. Laco: 10 posts Richard Jolly: 8 posts Nilson Santos Figueiredo Junior: 6 posts James FitzGibbon: 5 posts Jess Robinson: 5 posts Jonas Alves: 5 posts Kieren Diment: 4 posts Richard Jolly: 4 posts Vsevolod (Simon) Ilyushchenko: 4 posts Adam Sjøgren: 3 posts Andrew Ford: 3 posts Atsushi kobayashi: 3 posts Darren Duncan: 3 posts David Kamholz: 3 posts
show more