Search Discussions

63 discussions - 213 posts

  • It seems to me that there should be a Catalyst::Model::DBIC::Schema, which makes a $c- model('FooDB') for a given Schema + connection info. Unlike the previous Catalyst::Model::DBIC, which only used ...
    Brandon BlackBrandon Black
    Jan 31, 2006 at 5:47 pm
    Apr 7, 2006 at 3:52 pm
  • I'm trying to take baby steps in getting this working, so I've removed Catalyst from the equation for the time being. Today's effort is simply getting a single table read. Following the docs from ...
    Alan HumphreyAlan Humphrey
    Jan 6, 2006 at 6:12 pm
    Jan 18, 2006 at 3:10 pm
  • Is it possible to control the order in which columns are returned from a DBIx::Class object?
    Will HawesWill Hawes
    Jan 11, 2006 at 6:19 pm
    Jan 13, 2006 at 9:21 pm
  • Hi all. I just found strange behavior DBIC with SQLite3. Here is sample script, and it's does not work on my PC. use strict; use warnings; use DBIx::Class::Loader; DBIx::Class::Loader- new( dsn = ...
    Daisuke MuraseDaisuke Murase
    Jan 19, 2006 at 1:50 pm
    Jan 19, 2006 at 10:08 pm
  • I know we covered this on irc at some point, but I'm still at a loss as to the "correct" way to do these types of things. For example, in the old/bad way of doing things, a table-class MyDB::FooTable ...
    Brandon BlackBrandon Black
    Jan 31, 2006 at 10:50 pm
    Feb 1, 2006 at 9:37 pm
  • hi. I've tried to use DBIx::Class against a DBD::JDBC database (MS SQL Server) and it generally works fine, except that the call to SQL::Abstract::Limit cannot deduce the limit dialect on the remote ...
    Jesper KroghJesper Krogh
    Jan 25, 2006 at 3:31 pm
    Jan 27, 2006 at 3:21 pm
  • I've seen a lot of the Class::DBI vs. DBIx::Class stuff going back and forth, and I'm getting the feeling that DBIx::Class is becoming a better and better choice for someone making his first foray ...
    Todd LorenzTodd Lorenz
    Jan 20, 2006 at 3:31 am
    Jan 23, 2006 at 6:19 pm
  • Having been foiled earlier, I'm now looking through the rest of my code for cases the branch might not handle well, or perhaps that I just haven't discovered how to make the branch handle well, ...
    Brandon BlackBrandon Black
    Jan 16, 2006 at 11:05 pm
    Jan 18, 2006 at 9:43 am
  • Now there's a bold challenge :) ... we still need code for DISTINCT, GROUP BY, and HAVING, aggregate functions, and functions in general, I think, or is some of that in your new branch already?
    Brandon BlackBrandon Black
    Jan 11, 2006 at 10:16 pm
    Jan 16, 2006 at 9:28 pm
  • I have the following model class in a Catalyst application: package My::Model::DBIC::Link; use base 'My::Model::DBIC::Base'; # contains connection etc __PACKAGE__- table('link'); __PACKAGE__- ...
    Will HawesWill Hawes
    Jan 10, 2006 at 2:26 pm
    Jan 11, 2006 at 9:11 pm
  • Hi Everyone, I just joined your list. I seem to be hitting my head against a problem in DBI that I can't seem to avoid in DBIx::Class. When passing bind parameters, it appears that sql functions ...
    Nathan LewisNathan Lewis
    Jan 3, 2006 at 2:48 pm
    Jan 3, 2006 at 6:48 pm
  • Dear list, Please excuse a possibly stupid question---I might be doing this all backwards. I am doing a JOIN using DBIx::Class version 0.04999_04 to find the number of "requestedseqs" that has a ...
    TAPO (Thomas Agersten Poulsen)TAPO (Thomas Agersten Poulsen)
    Jan 27, 2006 at 11:44 am
    Jan 27, 2006 at 8:43 pm
  • Hi, We have a growing mismatch in our code between methods that return ResultSet objects and those that return an array/arrayref of objects. This is in a Catalyst model layer. For the sake of api ...
    Richard JollyRichard Jolly
    Jan 25, 2006 at 4:00 pm
    Jan 26, 2006 at 12:36 pm
  • So, I thought I'd give UNIQUE constraint support another try now that the resultset refactoring is settling down. It was discussed briefly before: ...
    Daniel Westermann-ClarkDaniel Westermann-Clark
    Jan 22, 2006 at 3:37 am
    Jan 23, 2006 at 6:32 am
  • I remember there was a thread asking for SQL examples. So I'd like to present two rather simple SQL queries for which I'll ask how to do it with DBIC. SELECT * FROM fw_menu WHERE menu_id NOT IN ...
    Kaare RasmussenKaare Rasmussen
    Jan 18, 2006 at 6:07 am
    Jan 19, 2006 at 10:05 am
  • I'm just trying to install DBIx::Class v0.04001 but am seeing an install test failure: t/cdbi-t/01-columns................Can't infer join condition for state on City; unable to load State at ...
    Dave HoworthDave Howorth
    Jan 13, 2006 at 6:08 pm
    Jan 16, 2006 at 4:33 pm
  • Hello I'm new to DBIx::Class, and before I delve too deeply into it, I have a few questions that I hope someone can answer. I'd like to use DBIx::Class:Loader, specifically with MySQL. If I'm using ...
    Dan HorneDan Horne
    Jan 15, 2006 at 1:28 am
    Jan 16, 2006 at 7:20 am
  • I'm getting a weird error when trying to create() or add_to_...(). I've checked my args and such, sorry no code right now, but the underlying stuff seems sound and is working in relational find() or ...
    Ashley Pond VAshley Pond V
    Jan 12, 2006 at 8:55 am
    Jan 13, 2006 at 6:50 pm
  • I'm moving from Class::DBI::Sweet to DBIx::Class. One of the features I find really useful in Sweet is the ability to do $class- search( {...}, { cmp = 'like' }); instead of using a separate method ...
    Will HawesWill Hawes
    Jan 7, 2006 at 7:01 pm
    Jan 7, 2006 at 10:46 pm
  • All - I'm trying to get my head around implementing my app via DBIx::Class::Schema. This may not make sense, but is there a way to use DBIx::Class::Loader *and* use the Schema? Or do I have to ...
    Alan HumphreyAlan Humphrey
    Jan 5, 2006 at 7:20 pm
    Jan 7, 2006 at 6:29 am
  • I accidentally sent this to Matt and he already replied but in the interest of the Pax DBIC, resent to the list: A non-text attachment was scrubbed... Name: not available Type: text/enriched Size: ...
    Ashley Pond VAshley Pond V
    Jan 20, 2006 at 1:45 am
    Mar 23, 2006 at 4:15 pm
  • Hi, I've just replaced Class::DBI with DBIx::Class in a small app that I wrote. One of the pages is displaying about 250 rows of complex data which the user did not want paged. The loading time ...
    Vsevolod (Simon) IlyushchenkoVsevolod (Simon) Ilyushchenko
    Jan 26, 2006 at 10:07 pm
    Jan 27, 2006 at 11:05 am
  • Hi. I want to Module::Pluggable feature into DBIC::Loader, and here is an suggestion and sample code. package DBIx::Class::Loader::Pluggable; use strict; use base qw/DBIx::Class::Loader/; require ...
    Daisuke MuraseDaisuke Murase
    Jan 24, 2006 at 4:21 pm
    Jan 24, 2006 at 6:58 pm
  • I'd like to override the storage used by each of the classes in my schema. This is what I've got now in my DB class: BirdWeb::Admin::Model::BirdWebSchema- compose_connection( __PACKAGE__, @conn_info ...
    Alan HumphreyAlan Humphrey
    Jan 12, 2006 at 5:28 pm
    Jan 13, 2006 at 5:51 pm
  • Sorry about the dodgy thread title, the correct terminology escapes me on a Monday morning. Given the following (in CDBI): package User; ... __PACKAGE__- has_many(addresses = ['UserAddress' = ...
    Will HawesWill Hawes
    Jan 9, 2006 at 11:05 am
    Jan 10, 2006 at 8:27 pm
  • I'm using MySQL 5. I'd like Loader to load my relationships. There is a problem in DBIx::Class::Loader::mysql : my $comment = $sth- fetchrow_hashref- {comment} || ''; should be my $comment = $sth- ...
    Alan HumphreyAlan Humphrey
    Jan 9, 2006 at 7:08 pm
    Jan 10, 2006 at 7:03 am
  • Hi list, I've got a new question about joins. I have three tables (*-marked being primary key): book (book_id*, title), member_books(book_id*, member_id*, relation), member(member_id*) I'm trying to ...
    Jon MolinJon Molin
    Jan 8, 2006 at 12:01 am
    Jan 10, 2006 at 1:05 am
  • The attached patch makes quotes work when the database uses [] (or any other quote where the left quote differs from the right). Jesper -- Jesper Krogh A non-text attachment was scrubbed... Name: ...
    Jesper KroghJesper Krogh
    Jan 31, 2006 at 2:32 pm
    Jan 31, 2006 at 5:34 pm
  • DBIx::Class 0.4999_06 is on its way to CPAN. In the meantime you can get it here: http://pause.perl.org/incoming/DBIx-Class-0.04999_06.tar.gz This release has one simple (but important) change from ...
    Daniel Westermann-ClarkDaniel Westermann-Clark
    Jan 28, 2006 at 10:20 pm
    Jan 28, 2006 at 11:16 pm
  • For the usage look at the docs (Manual::SchemaIntro). Tests are missing, if anyone knows which can be set for sqlite and checked later please do a patch or talk to me on irc.perl.org #dbix-class! ...
    Hartmaier AlexanderHartmaier Alexander
    Jan 23, 2006 at 6:41 pm
    Jan 26, 2006 at 5:00 pm
  • Hi I'm very new to DBIx::Class and I am very conduffled atm. I would like to create a Class based on dbixc that would always give me access to a query which is similiar to "select col from table ...
    Gert BurgerGert Burger
    Jan 24, 2006 at 3:27 pm
    Jan 25, 2006 at 12:58 pm
  • It's become clear to me as of late that my Handel-DBIC branch is so far behind trunk that re converting to the latest DBIC isn't worth the effort given that I'd like to do a big refactor in 1.0 ...
    Christopher H. LacoChristopher H. Laco
    Jan 24, 2006 at 4:08 pm
    Jan 24, 2006 at 6:57 pm
  • I'd like to search for the same value in multiple columns. I tried this: my @result = BirdWeb::Admin::Model::Staging- class('Birds')- search_like ({ bird_common_name = '%robin%', ...
    Alan HumphreyAlan Humphrey
    Jan 20, 2006 at 10:12 pm
    Jan 20, 2006 at 11:19 pm
  • Well, 0.12 had some dumb bugs in it, a fair amount of changes have built up, and what little feedback there has been on the pending changes has been positive, so without further ado: ...
    Brandon BlackBrandon Black
    Jan 19, 2006 at 7:40 am
    Jan 19, 2006 at 2:46 pm
  • I hit upon a problem with tring to use information in a secondary table (joined my a foreign key). I'm sure I'm doing something really dumg, but after looking at this for some time I can't see what ...
    Chisel WrightChisel Wright
    Jan 12, 2006 at 12:10 pm
    Jan 12, 2006 at 5:06 pm
  • How can I access the relationships for a DBIx::Class object (in Class::DBI I would use meta_info)? I'm not using CDBICompat.
    Will HawesWill Hawes
    Jan 9, 2006 at 10:47 am
    Jan 10, 2006 at 1:17 am
  • P.S. I'm sending this to dbix-class too, since some people whose opinions I respect don't appear on the other lists. ------------------ This RFC is an early probe, and is only being sent to 2 ...
    Darren DuncanDarren Duncan
    Jan 7, 2006 at 3:07 am
    Jan 10, 2006 at 12:05 am
  • I recently moved to creating large composite triggers using TT2 rather than having one trigger for sequences, one for validation, etc. One side effect of this is that my sequence generation is ...
    James FitzGibbonJames FitzGibbon
    Jan 3, 2006 at 7:14 pm
    Jan 3, 2006 at 8:41 pm
  • Is there a way to have conditional relationships? For instance in my case I have: field_name, type_id, data_id where the final table class to search for value (referenced by data_id) is determined by ...
    John LifseyJohn Lifsey
    Jan 31, 2006 at 9:32 pm
    Jan 31, 2006 at 9:41 pm
  • I think there's a typo: --- SchemaIntro-orig.pod 2006-01-24 15:12:40.000000000 +0000 +++ SchemaIntro.pod 2006-01-26 13:50:17.667685356 +0000 @@ -189,7 +189,7 @@ We also provide a handy shortcut for ...
    Dave HoworthDave Howorth
    Jan 26, 2006 at 2:56 pm
    Jan 26, 2006 at 4:18 pm
  • Forwarded to list... -------- Original Message -------- Subject: Re: [Catalyst] DBIx::Class newbish count problems Date: Thu, 19 Jan 2006 17:12:36 -0500 From: Dave C <skinnydill@gmail.com To: ...
    Will HawesWill Hawes
    Jan 19, 2006 at 11:37 pm
    Jan 25, 2006 at 10:21 am
  • Hi folks, On my way to work this morning, for some reason, I was pondering why "belongs_to" is so named. It seems a bit contrary to the rest, which are all from the POV of the current class/item. ...
    Jess RobinsonJess Robinson
    Jan 23, 2006 at 10:10 am
    Jan 23, 2006 at 3:01 pm
  • Hi. DBIx::Class::Loader::SQLite does something wrong about PK detection. Below is a patch to fix. --- SQLite.pm Tue Dec 20 18:17:27 2005 +++ SQLite_patched.pm Mon Jan 23 01:13:44 2006 @@ -138,7 ...
    Ishigaki KenichiIshigaki Kenichi
    Jan 22, 2006 at 5:09 pm
    Jan 23, 2006 at 7:32 am
  • Please take a few minutes to review. Error reports/improvements welcome. Index: Cookbook.pod =================================================================== --- Cookbook.pod (revision 508) +++ ...
    Will HawesWill Hawes
    Jan 19, 2006 at 6:28 pm
    Jan 19, 2006 at 8:18 pm
  • So you can trace the SQL statements by doing $class- storage- debug(1) or setting the DBIX_CLASS_STORAGE_DBI_DEBUG environment variable. This causes this statement to fire in ...
    Nigel MetheringhamNigel Metheringham
    Jan 12, 2006 at 12:40 pm
    Jan 13, 2006 at 5:21 pm
  • All - I'm using the Schema feature to access two databases. My application has a staging database and a production database. Users will enter/edit data in the staging database and when it's ready for ...
    Alan HumphreyAlan Humphrey
    Jan 11, 2006 at 12:22 am
    Jan 11, 2006 at 1:33 am
  • The biggest problem I have with separate triggers (in Oracle) is that the firing order is undefined for triggers of the same type. So if one BEFORE INSERT trigger populates your primary key and ...
    James FitzGibbonJames FitzGibbon
    Jan 3, 2006 at 8:50 pm
    Jan 7, 2006 at 10:17 am
  • I discovered that the Postgres auto incrementing PK support required a minimal level of DBI/DBD support (better than that found in the default packages for RHEL 4). SO I have added a FAQ entry for ...
    Nigel MetheringhamNigel Metheringham
    Jan 5, 2006 at 3:59 pm
    Jan 5, 2006 at 4:34 pm
  • DBIx::Class::Loader version 0.16 has been released and uploaded to CPAN. It can be found for the moment at: http://pause.perl.org/incoming/DBIx-Class-Loader-0.16.tar.gz Changes entries for this ...
    Brandon BlackBrandon Black
    Jan 31, 2006 at 4:31 am
    Jan 31, 2006 at 4:31 am
  • On its way to CPAN, in the meantime you can get it here: http://trout.me.uk/perl/DBIx-Class-0.04999_05.tar.gz Changes as follows: - count will now work for grouped resultsets - added accessor = ...
    Will HawesWill Hawes
    Jan 28, 2006 at 9:06 pm
    Jan 28, 2006 at 9:06 pm
Group Navigation
period‹ prev | Jan 2006 | next ›
Group Overview
groupdbix-class @
categoriesperl, catalyst

35 users for January 2006

Matt S Trout: 61 posts Brandon Black: 32 posts Will Hawes: 21 posts Alan Humphrey: 13 posts Ashley Pond V: 7 posts Jesper Krogh: 7 posts Daniel Westermann-Clark: 6 posts Chisel Wright: 5 posts Jess Robinson: 5 posts Zbigniew Lukasiak: 5 posts Dave Howorth: 4 posts Christopher H. Laco: 3 posts Daisuke Murase: 3 posts Darren Duncan: 3 posts Jon Molin: 3 posts Nigel Metheringham: 3 posts Richard Jolly: 3 posts Dan Horne: 2 posts Gert Burger: 2 posts Hartmaier Alexander: 2 posts
show more