FAQ

Search Discussions

47 discussions - 202 posts

  • Hi all, I've been hacking away at a set of components for representing, modifying, and traversing trees of DBIx::Class objects. The API was hammered out with some help from Matt and others on ...
    Aran DeltacAran Deltac
    Apr 3, 2006 at 3:31 pm
    Apr 5, 2006 at 9:15 am
  • I'm a relative newbie with DBIx::Class- but recently deployed a new web application using it. The application works great and thanks to DBIx::Class, it took less time to do. The application is ...
    Doran BartonDoran Barton
    Apr 4, 2006 at 8:20 pm
    Apr 5, 2006 at 6:56 pm
  • While working on the Handel conversion to DBIC, I've come across the need to have my resultsets always be "Carts" and "Items" regardless of what the actual packages are named. For now, I've simply ...
    Christopher H. LacoChristopher H. Laco
    Apr 3, 2006 at 3:53 pm
    Jul 25, 2006 at 10:22 pm
  • According to the docs "Note that DBIx::Class::Schema does not cache connections for you. If you use multiple connections, you need to do this manually." As I'm using DBIx::Class under FastCGI, I'd ...
    Dan HorneDan Horne
    Apr 30, 2006 at 12:58 am
    May 1, 2006 at 6:54 pm
  • Well, It's a module that adds some syntatic sugar to DBIx::Class. Currently, it only makes the DBIx::Class subclass "setup" easier on the eyes but I intend to develop it further as I see fit, maybe ...
    Nilson Santos Figueiredo JuniorNilson Santos Figueiredo Junior
    Apr 3, 2006 at 6:17 am
    Apr 3, 2006 at 6:52 pm
  • Hi guys, Just starting to use DBIx::Class in anger for the first time and have a few questions/comments: 1. Is there a way of accessing the $schema object from a Row or ResultSet method, or is that a ...
    Gavin CarrGavin Carr
    Apr 27, 2006 at 12:44 am
    Apr 28, 2006 at 11:14 am
  • I cannot get a join to work in DBIx-Class-0.06002 entirely due to the fact I can't figure it out. I have 2 tables: package DB_Schema::Company; use base qw/DBIx::Class/; __PACKAGE__- ...
    Maurice HeightMaurice Height
    Apr 24, 2006 at 9:53 am
    Apr 25, 2006 at 4:39 pm
  • Hi all, I'm trying to install DBIx::Class 0.06001 on two CentOS3 (RHEL3) boxes and getting some pretty weird test failures. 'perl Makefile.PL' and 'make' both look fine, and then 'make test' fails as ...
    Gavin CarrGavin Carr
    Apr 13, 2006 at 3:04 am
    Apr 18, 2006 at 3:18 pm
  • I found that if I do a prefetch on a Foo RS to its have_many Bar, but it doesn't have any Bars, I don't get the Foo at all. This is similar to a problem where if I do a prefetch from one to another ...
    Mark HedgesMark Hedges
    Apr 13, 2006 at 2:05 am
    Apr 13, 2006 at 5:57 pm
  • Hiya. I've created an instance of DBIx::Class::ResultSet for a table class called user where I have the following method: Example: sub update_email { ... my $rs = $self- search({...}); # This returns ...
    Kjell Arne ArvesenKjell Arne Arvesen
    Apr 8, 2006 at 9:37 am
    Apr 10, 2006 at 3:08 pm
  • I want to prefetch both a single hop relation and a two-hop relation. I.e. I want to combine this: my $rs = $schema- resultset('Foo')- search( { 'me.foo_id' = $foo_id, }, { prefetch = { bar = 'biz', ...
    Mark HedgesMark Hedges
    Apr 6, 2006 at 10:50 pm
    Apr 7, 2006 at 5:17 pm
  • There seems to be a bug in .06002 where an update on a foreign key does not get picked up by the relationship (belongs_to) attached to that key. Example, from the DBIx::Class::Manual::Example schema: ...
    Gavin CarrGavin Carr
    Apr 29, 2006 at 5:12 am
    May 9, 2006 at 10:31 am
  • I'm dynamically constructing my $rs search statements, and including "page" and "rows" values in my attribute hash, for paged results. In my display template, I'd like to do something like "25837 ...
    Jesse SheidlowerJesse Sheidlower
    Apr 10, 2006 at 1:49 am
    Apr 11, 2006 at 12:22 pm
  • Dear list, as discussed on irc, I've some problems with unique_contrains beeing "ignored" when using find_or_create. (My actual problem is using find_or_create_related, but I was unable to come up ...
    Goetz BockGoetz Bock
    Apr 4, 2006 at 8:26 pm
    Apr 7, 2006 at 3:55 am
  • Is this the expected behaviour of prefetch? Apologies for not replacing all the names with 'foo', 'bar' etc. Receptor has a 'many to many' relationship with Ligand, with 'natural_ligands_map' being ...
    Luke saundersLuke saunders
    Apr 3, 2006 at 9:33 am
    Apr 3, 2006 at 11:23 am
  • Hi I've started experimenting with DBIx::Class, but my initial efforts appear to be thwarted. The code: My/Schema.pm: package My::Schema; use base qw/DBIx::Class::Schema/; __PACKAGE__- ...
    Dan HorneDan Horne
    Apr 29, 2006 at 11:06 pm
    Apr 30, 2006 at 1:31 am
  • It looks like Nilson has no time atm to finish Schema::Declare. So it would be really nice if someone could take over development. http://dev.catalyst.perl.org/repos/bast/branches/Moose-Style- ...
    Sebastian RiedelSebastian Riedel
    Apr 20, 2006 at 12:33 am
    Apr 21, 2006 at 2:37 pm
  • Hi - A question about caching and esp. for relationships: Let's say I have a data model with a one-to-many relationship between Folders and Items: Folder- has_many ( items ) Item- has_a ( folder ) ...
    Michael KangMichael Kang
    Apr 17, 2006 at 9:47 pm
    Apr 18, 2006 at 3:05 pm
  • 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 ...
    Mark HedgesMark Hedges
    Apr 10, 2006 at 8:51 pm
    Apr 11, 2006 at 1:46 pm
  • I'm not on the list, but Matt asked me to post this anyway. It contains three patterns for making M-M relationships "work". I suggested that these might appear just as "add_to_..." appears for a ...
    ShevekShevek
    Apr 15, 2006 at 10:29 pm
    May 18, 2006 at 7:11 am
  • konobi's lobbed together a patch for Storage::DBI::Pg that hopefully improves sequence etc. support - can people who know/use such things more than I have a look over and say whether it's suitable ...
    Matt S TroutMatt S Trout
    Apr 27, 2006 at 12:17 pm
    May 1, 2006 at 1:05 pm
  • I have some queries in my application that cannot (yet) be handled efficiently (or in some cases at all) by DBIC, so I still have to use raw DBI queries here and there where neccesary. I've run into ...
    Brandon BlackBrandon Black
    Apr 26, 2006 at 3:23 pm
    Apr 26, 2006 at 10:08 pm
  • And I bet you thought componentized.pm was too small for a bug. Anyway. Use Schema::Loader (as documented) passing components = [ qw/ResultSetManager/] and resultset_components = [ qw/anything/ ] ...
    ShevekShevek
    Apr 16, 2006 at 11:04 am
    Apr 16, 2006 at 8:35 pm
  • when calling update_or_create, I want to know it's "create" or "update" since I want to do different thing according to different type. such as not + 1 if it's an "update" and +1 if it's a "create". ...
    Fayland LamFayland Lam
    Apr 10, 2006 at 7:11 am
    Apr 10, 2006 at 5:36 pm
  • Kept getting this error trying to update an object: Can't call method "update" on an undefined value at /usr/local/share/perl/5.8.8/DBIx/Class/Relationship/CascadeActions.pm line 36. In this case the ...
    Mark HedgesMark Hedges
    Apr 7, 2006 at 11:18 pm
    Apr 8, 2006 at 5:47 pm
  • Hi, After the (not so elegant) DBIx::Class::Sweet here's another approach we just discussed in #dbix-class. "type" defaults to integer(something) and table/class names are generated using a logic ...
    Sebastian RiedelSebastian Riedel
    Apr 3, 2006 at 6:00 pm
    Apr 4, 2006 at 8:11 am
  • Hi. I just want to thank all involved in DBIx::Class for the impressive work done. I've made this small "hack" that basically allows to serialize any perl-object that YAML can handle properly into ...
    Jesper KroghJesper Krogh
    Apr 30, 2006 at 7:25 pm
    Apr 30, 2006 at 7:39 pm
  • I've created a script in dbic-current/maint/ called dbicadmin. It allows you to create, modify, and remove data useing DBIC classes. Once I started playing with it beyond my original needs I found ...
    Aran DeltacAran Deltac
    Apr 27, 2006 at 3:13 pm
    Apr 29, 2006 at 2:48 am
  • Deployment could be much easier with a Module::Install extension for DBIx::Class. Could work like this, you add a line to your Makefile.PL: dbix_class(); And then get one or more make targets ...
    Sebastian RiedelSebastian Riedel
    Apr 25, 2006 at 12:07 pm
    Apr 25, 2006 at 11:50 pm
  • Hi, This may be a bug, or I may be doing something wrong. Since I can do what I want with Class::DBI and with plain SQL, I think it is a bug. I have a basic table in postgresql. I want to use it to ...
    James MarcaJames Marca
    Apr 21, 2006 at 10:05 pm
    Apr 21, 2006 at 11:27 pm
  • Yesterday I noticed Strange Things while working on a Catalyst application. I've managed to boil it down to a reasonably simple test-app (I can supply the tarball if required, but I prefer not to ...
    Chisel WrightChisel Wright
    Apr 21, 2006 at 10:05 am
    Apr 21, 2006 at 7:02 pm
  • Sorry, it seems I copied the wrong Changes of DBI. The relevant one should be this one, I'm afraid: http://search.cpan.org/~timb/DBI-1.50/Changes#Changes_in_DBI_1.43_(svn_rev_377)%2C_2nd_July_2004 - ...
    IslueIslue
    Apr 20, 2006 at 12:31 pm
    Apr 20, 2006 at 2:10 pm
  • Hi, As I mentioned on IRC, I'm having trouble with copying an object. I'm running DBIx-Class 0.06001 though I've tested this against trunk. I've pared it down to a minimal test case - does this help ...
    Carl VincentCarl Vincent
    Apr 11, 2006 at 9:33 am
    Apr 19, 2006 at 8:25 pm
  • ResultSetManager hooks 'table()', which leads to some weaknesses. Workaround attached. A better hook-in point should be found. I do not suggest one. The long version, with asides: I use Loader to get ...
    ShevekShevek
    Apr 16, 2006 at 11:42 am
    Apr 17, 2006 at 1:54 pm
  • hi I want to get last ID Auto_incerment in my table with DBIx any suggestion? thx -- Regard Reza Sadeghzadeh An HTML attachment was scrubbed... URL: ...
    Reza sadeghzadehReza sadeghzadeh
    Apr 8, 2006 at 4:59 pm
    Apr 9, 2006 at 3:27 pm
  • Weird. I can do: { prefetch = { some_hasmany = 'their_hasone' } } and all objects are populated without further queries when I call the accessors, but if I do this: { prefetch = 'some_hasmany' }, The ...
    Mark HedgesMark Hedges
    Apr 7, 2006 at 2:10 am
    Apr 7, 2006 at 8:42 am
  • I've been having a heck of a time getting the following DBIx::Class::ResultSet working and have tracked a couple of bugs through DBIx::Class::Storage::DBI (or SQL::Abstract, really). Here's the ...
    Matt IttigsonMatt Ittigson
    Apr 6, 2006 at 6:16 am
    Apr 6, 2006 at 1:25 pm
  • Hello, I've written a short script using DBIx::Class::Schema. It works about like I would expect, until I added the following line in GenesDB::SegmentTypes: 'use overload '""' = 'type', fallback = ...
    Stephen MooreStephen Moore
    Apr 27, 2006 at 5:22 pm
    Apr 27, 2006 at 5:22 pm
  • Hi. The current DBIx::Class fails to - create() stuff when the table is in a schema that isn't in the default search path. This patch makes the Auto sequence stuff work when the table resides in a ...
    Jesper KroghJesper Krogh
    Apr 21, 2006 at 3:57 pm
    Apr 21, 2006 at 3:57 pm
  • Hi, The attachment is the error log. With the help of Matt, I found the reason. http://search.cpan.org/~timb/DBI-1.50/Changes#Changes_in_DBI_1.43_(svn_rev_377)%2C_2nd_July_2004 - Changes in DBI 1.43 ...
    IslueIslue
    Apr 20, 2006 at 5:57 am
    Apr 20, 2006 at 5:57 am
  • Coming to a CPAN mirror nearest you, or straight from the factory doors http://trout.me.uk/perl/DBIx-Class-0.06002.tar.gz Changes since 0.06001: 0.06002 - fix set_from_related to accept undef - fix ...
    Christopher H. LacoChristopher H. Laco
    Apr 19, 2006 at 11:47 pm
    Apr 19, 2006 at 11:47 pm
  • Hello everyone, I worked out a patch that allows it to pass the method name to the ResultSet attribute. I had/have a need for this because I want(ed) to define two methods (on for the result set, one ...
    Robert SedlacekRobert Sedlacek
    Apr 16, 2006 at 9:44 pm
    Apr 16, 2006 at 9:44 pm
  • I'm about ready to do a dev release of the DBIx-Class-Tree project. I received a lot of valuable input in the recent thread "RFC: DBIx-Class-Tree". There were a couple key points: 1) Support DAGs. ...
    Aran DeltacAran Deltac
    Apr 16, 2006 at 8:20 pm
    Apr 16, 2006 at 8:20 pm
  • I'm not entirely sure about this, hence my sending this as a question rather than a patch: In Intro.pod: --- The preferred way to generate complex queries is to provide a SQL::Abstract construct to ...
    Jesse SheidlowerJesse Sheidlower
    Apr 10, 2006 at 3:01 am
    Apr 10, 2006 at 3:01 am
  • Available from CPAN soon, or http://trout.me.uk/perl/DBIx-Class-0.06001.tar.gz for the impatient. Changes since 0.06000: 0.06001 - minor fix to update in case of undefined rels - fixes for cascade ...
    Jess RobinsonJess Robinson
    Apr 8, 2006 at 9:53 pm
    Apr 8, 2006 at 9:53 pm
  • Is there a specific reason for this not to work: <code package OldModel::Foo; use base 'DBIx::Class'; __PACKAGE__- load_components(qw/PK::Auto Core/); __PACKAGE__- table('foo'); __PACKAGE__- ...
    Nilson Santos Figueiredo JuniorNilson Santos Figueiredo Junior
    Apr 8, 2006 at 3:22 am
    Apr 8, 2006 at 3:22 am
  • As discussed on #dbix-class attached is a patch which contains the following: - horrific but temporary hack to allow SQLite and Oracle to do counts on resultsets with multiple column select distincts ...
    Luke saundersLuke saunders
    Apr 6, 2006 at 2:34 pm
    Apr 6, 2006 at 2:34 pm
Group Navigation
period‹ prev | Apr 2006 | next ›
Group Overview
groupdbix-class @
categoriesperl, catalyst
discussions47
posts202
users47
websitedbix-class.org
irc#dbix-class

47 users for April 2006

Matt S Trout: 48 posts Mark Hedges: 18 posts Aran Deltac: 12 posts Nilson Santos Figueiredo Junior: 12 posts Brandon Black: 10 posts Christopher H. Laco: 8 posts Dan Horne: 7 posts Gavin Carr: 7 posts Luke saunders: 7 posts Jess Robinson: 6 posts Dave Howorth: 5 posts Jesper Krogh: 5 posts Daniel Westermann-Clark: 4 posts Sebastian Riedel: 4 posts Jesse Sheidlower: 3 posts Kjell Arne Arvesen: 3 posts Robert Sedlacek: 3 posts Shevek: 3 posts Will Hawes: 3 posts Alan Humphrey: 2 posts
show more
Archives