Search Discussions

56 discussions - 277 posts

  • Hi, I'm unable to define a certain join condition with DBIC. Maybe someone can have a look and help me out, perhaps also Matt, because it seems there is a small bug with the "from"-attribute (see at ...
    Bernhard GrafBernhard Graf
    Nov 26, 2006 at 10:31 pm
    Dec 13, 2006 at 9:02 pm
  • Since everybody seems to ignore the docs and try and use 'as' to generate SQL AS clauses at least once, I propose we rename it, undocument the old name and pray that solves the problem. Anybody got ...
    Matt S TroutMatt S Trout
    Nov 3, 2006 at 8:40 am
    Nov 3, 2006 at 4:02 pm
  • Hi, I checked in a branch off of current under branches/DBIx-Class/param_bind which alters how SQL statements are executed so that you can specify bind parameters in your schema classes. This is ...
    John NapiorkowskiJohn Napiorkowski
    Nov 18, 2006 at 1:12 am
    Dec 13, 2006 at 1:20 am
  • Hi, Right now if I stuff extra things into the column metadata info like so: __PACKAGE__- add_columns( "thumbnail_path", { data_type = "VARCHAR", default_value = "", is_nullable = 0, size = 255, ...
    John NapiorkowskiJohn Napiorkowski
    Nov 2, 2006 at 3:09 pm
    Nov 10, 2006 at 4:08 pm
  • Is it possible to catch DBI errors, without having to wrap the code within eval blocks? The specific place where I'm experiencing trouble is, DELETE FROM contact WHERE ( contactid = ? AND owner = ? ...
    Josef KarthauserJosef Karthauser
    Nov 12, 2006 at 11:56 am
    Nov 14, 2006 at 1:36 pm
  • Hi, Not sure if I am doing this correctly. I am trying to order a result by the count of something but the 'as' parameter doesn't seem to do what I think it should do: Here is my code: ...
    John NapiorkowskiJohn Napiorkowski
    Nov 2, 2006 at 11:19 pm
    Nov 3, 2006 at 2:50 pm
  • I recently fought with my mother and we haven't been talking much since. I'd like to resolve this problem, but I really don't know how to approach this issue. What should I do? -- Yuval Kogman ...
    Yuval KogmanYuval Kogman
    Nov 23, 2006 at 2:49 pm
    Nov 24, 2006 at 9:28 am
  • Hey there, I wonder, would someone be able to help me with a multi field key that I'm having trouble with? I've got three tables: package Contact; use base qw/DBIx::Class/; __PACKAGE__- ...
    Josef KarthauserJosef Karthauser
    Nov 10, 2006 at 11:07 pm
    Nov 13, 2006 at 12:42 pm
  • Greetings, I'm looking at the docs for DBIx::Class::Serialize::Storable ( http://search.cpan.org/~bricas/DBIx-Class-0.07003/lib/DBIx/Class/Serialize/Storable.pm) The Synopsis refers to some ...
    Mike FriedmanMike Friedman
    Nov 26, 2006 at 4:37 am
    Nov 29, 2006 at 9:15 pm
  • Is it possible to extract a list of possible values for an enumerated type using DBIx? I think that this is possible in Class::DBI, so I expect it's possible here too, but I can't find it in the ...
    Josef KarthauserJosef Karthauser
    Nov 6, 2006 at 11:54 pm
    Nov 8, 2006 at 5:14 pm
  • Good thing I stumbled across the perf issue in C::A::G when I did. That could've sucked. -=Chris A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 ...
    Christopher H. LacoChristopher H. Laco
    Nov 22, 2006 at 4:30 pm
    Nov 22, 2006 at 6:35 pm
  • I have a need to avoid prepare_cached(). I found the disable_sth_caching option in the manual. What I haven't yet found is an example of how to actually set it. The manual says that these options are ...
    Louis EricksonLouis Erickson
    Nov 15, 2006 at 3:40 am
    Nov 16, 2006 at 12:34 am
  • Hi, I have within my code a query that looks like this:- # join on everything useful here.... my $join = [ qw/event_status event_type company /, { bookings = 'performances' } ]; my $attrs = { ...
    Nigel MetheringhamNigel Metheringham
    Nov 23, 2006 at 12:49 pm
    Nov 27, 2006 at 3:53 pm
  • The following patch against the trunk allows DBIC::Ordered to group across more than one column, and updates the position column of all affected rows when items move between groups. See pod comments ...
    Neil de CarteretNeil de Carteret
    Nov 12, 2006 at 5:26 pm
    Nov 16, 2006 at 6:58 pm
  • Hi, I'm trying to pass some additional 'hinting' information to the sql statement throught the dbi bind_param method. In 'straight' dbi procedural code I might write something like: my $update_sql = ...
    John NapiorkowskiJohn Napiorkowski
    Nov 14, 2006 at 10:39 pm
    Nov 16, 2006 at 6:05 pm
  • Hi, I know this issue comes up from time to time about support for BLOB/BYTEA, but I was wondering if anyone was doing anything other than the transaction method suggested a few months ago? I ...
    John NapiorkowskiJohn Napiorkowski
    Nov 10, 2006 at 7:05 pm
    Nov 13, 2006 at 5:12 pm
  • Hi, I've been using InflateColumn::DateTime for a few weeks now for my reports and it's worked very well. However I have run into the following trouble; if I try to change the datetime object value ...
    John NapiorkowskiJohn Napiorkowski
    Nov 7, 2006 at 5:49 pm
    Nov 7, 2006 at 7:34 pm
  • I was speaking with Matt yesterday on the IRC and he said that Nested Set Trees have already been implemented in the MojoMojo. It needs to porting/adopting to fit the DBIx::Class[::Tree]. Also Matt ...
    Roman FilippovRoman Filippov
    Nov 20, 2006 at 6:02 pm
    Nov 20, 2006 at 10:01 pm
  • Am I limited to pre-fetching only one has_many relation? I have something like: package Ucam::LookupDB::Person; use base 'Ucam::LookupDBBase'; my $keep = { cascade_delete = 0 }; __PACKAGE__- ...
    Jon WarbrickJon Warbrick
    Nov 8, 2006 at 5:56 pm
    Nov 20, 2006 at 3:57 pm
  • I'm using this code to attempt to retrieve a related table's info: my @all_user_notes = $user_notes- search_related('notes', { username = $session- param('username') } ); my @user_notes = map { { ...
    Devin AustinDevin Austin
    Nov 3, 2006 at 4:19 am
    Nov 8, 2006 at 11:30 pm
  • Hi there, I'm getting up to speed on DBIx::Class, in the context of Catalyst. Can someone help me with this query? I need to validate whether a particular column exists in the schema before calling a ...
    Josef KarthauserJosef Karthauser
    Nov 5, 2006 at 5:06 pm
    Nov 6, 2006 at 12:52 am
  • hi, when I'm using $schema- ruleset('table')- create({ ..... fieldX = 'CURRENT_TIMESTAMP' ..}); The fieldX is set to "0000-00-00 00:00:00" instead of current timestamp, probably 'cause it ...
    Ivan GeorgievIvan Georgiev
    Nov 1, 2006 at 7:28 pm
    Nov 2, 2006 at 6:19 pm
  • Greetings! I am trying to delete a resultset, but it doesn't work. Tried to find the solution for days, but I'm lost. Here is my code: my $user = $schema- resultset('User')- find(1); $user- delete; ...
    Nov 2, 2006 at 3:34 am
    Nov 2, 2006 at 8:41 am
  • Hi, I have two schemas connecting to two related databases. I'd like some way of "joining" between the two, i.e. to be able to do this: my $record = App::Schema1::RS- find(1); my $rec2 = $record- ...
    Sam CrawleySam Crawley
    Nov 23, 2006 at 11:31 am
    Nov 27, 2006 at 10:40 pm
  • (cc'd to dbix::class list per mst's request) look here: http://www.triplethink.net/2006-11-19/ MySQL::Packet - encode and decode the MySQL binary protocol POE::Component::DBD::MySQL - manage MySQL ...
    Tavin ColeTavin Cole
    Nov 19, 2006 at 8:35 pm
    Nov 23, 2006 at 11:13 pm
  • I've got a column called "group". (Stupid, I know, but not my design.) This seems to be causing syntax errors when I try to insert via DBIC. For example: DBD::mysql::st execute failed: You have an ...
    Mike FriedmanMike Friedman
    Nov 11, 2006 at 10:21 am
    Nov 11, 2006 at 3:31 pm
  • here is the code : $schema- resultset('tableX')- create(\%record); here is dump of the %record : $VAR1 = { 'field6' = '1', 'field5' = 'PP ', 'field1' = '00000000000011716438', 'field2' = 0, 'field3' ...
    Ivan GeorgievIvan Georgiev
    Nov 9, 2006 at 11:44 pm
    Nov 10, 2006 at 10:51 pm
  • Oracle's date datatype is supported via parse_date, format_date, parse_datetime, format_datetime. I plan to add 'timestamp' and 'timestamp with time zone' methods after I install 9i client libraries ...
    Nathan GrayNathan Gray
    Nov 6, 2006 at 2:23 pm
    Nov 7, 2006 at 10:06 pm
  • Since I have a current DBIC working copy on my HD now, I also offer this patch to be applied. It lets you set an inflator for multiple columns at once, as described in my email one month ago: ...
    Bernhard GrafBernhard Graf
    Nov 27, 2006 at 11:22 am
    Nov 28, 2006 at 2:25 pm
  • Hello everyone, I cannot seem to get a simple DBIx::Class setup to work. I was wondering if anyone sees what I am doing wrong... --- In "lib/MySchema.pm": package MySchema; use base ...
    Leandro HermidaLeandro Hermida
    Nov 23, 2006 at 3:44 pm
    Nov 23, 2006 at 3:58 pm
  • we have two tables one is for original language ================== package DB::Ministries; use base 'DBIx::Class'; __PACKAGE__- load_components( qw/ PK::Auto Core / ); __PACKAGE__- table( ...
    Nov 21, 2006 at 8:39 pm
    Nov 22, 2006 at 8:23 pm
  • I ask to save myself a couple of hours of playing with code in case it won't work; just thinking out loud and it seemed like an interesting point either way; sort of forced pair coding. Can I have a ...
    Ashley Pond VAshley Pond V
    Nov 22, 2006 at 8:20 am
    Nov 22, 2006 at 5:11 pm
  • Please test this: http://dtmf.com/Algorithm-C3-0.06.tar.gz if you've got the time, before I send it to CPAN. -- -- Brandon
    Brandon BlackBrandon Black
    Nov 15, 2006 at 7:05 pm
    Nov 20, 2006 at 5:21 pm
  • I have a resultset question. Is this by design, or by accident? This fails $schema- resultset('Carts')- search(undef, undef); with: This succeeds: $schema- resultset('Carts')- search(undef, {}); ...
    Christopher H. LacoChristopher H. Laco
    Nov 13, 2006 at 7:34 pm
    Nov 16, 2006 at 5:40 pm
  • Hello, Following up on my list post of September 15th, I'm writing to let you know that my QDRDBMS project is partly coded, and you will be able to see its continuing progress prior to its first CPAN ...
    Darren DuncanDarren Duncan
    Nov 8, 2006 at 8:48 am
    Nov 8, 2006 at 6:15 pm
  • Given a table "article" which has_many "article_history" would this be a reasonable approach to keeping track of the history for diffs and stuff? Is there a better one? Just store the diff (and apply ...
    Ashley Pond VAshley Pond V
    Nov 26, 2006 at 6:17 am
    Nov 26, 2006 at 5:01 pm
  • I got bit by this today, and I thought that it could be quite a bit more obvious and clear that many_to_many is not a true relationship. Patch attached. - Ted Carnahan ted@tedcarnahan.com A non-text ...
    Ted CarnahanTed Carnahan
    Nov 3, 2006 at 7:56 pm
    Nov 17, 2006 at 11:35 am
  • Over the last week on irc, someone asked the question about how to deal with currency columns and formatting in DBIC. I pointed them to Handel::Currency and Handel::Storage::DBIC from the upcoming ...
    Christopher H. LacoChristopher H. Laco
    Nov 13, 2006 at 2:59 pm
    Nov 13, 2006 at 3:05 pm
  • use strict; use Data::Dumper; package DB::IRCLogBot::Messages; use base qw/DBIx::Class/; __PACKAGE__- load_components(qw/PK::Auto ResultSetManager Core/); __PACKAGE__- table('messages'); __PACKAGE__- ...
    Victor IgumnovVictor Igumnov
    Nov 7, 2006 at 2:48 am
    Nov 7, 2006 at 1:01 pm
  • I'm playing around with the example Artist/Cd/Tracks SQLite database in order to learn DBIC. I've defined a left outer join relationship between the artist and cd tables like this: package ...
    Mike EarleyMike Earley
    Nov 6, 2006 at 2:56 pm
    Nov 7, 2006 at 5:13 am
  • Hi. I just added __PACKAGE__- sequence() calls to my DBIx:Class classes?. It went fine until I reached this one (cut-down example): package MyDB::Artist; use strict; use warnings; use base ...
    Adam SjøgrenAdam Sjøgren
    Nov 2, 2006 at 1:11 pm
    Nov 2, 2006 at 1:20 pm
  • A small patch for NoBindVars: 46c46 < while(my $bvar = shift @bind) { --- Problem - the while loop bailed out on the first non-true entry, leaving bad SQL. - Alan
    Alan HumphreyAlan Humphrey
    Nov 1, 2006 at 7:22 pm
    Nov 1, 2006 at 8:29 pm
  • I am interested in understanding autoincrement under DBIx::Class. It appears that it works out-of-the-box for databases which implement autoincrement columns. For databases using sequences in place ...
    Nathan GrayNathan Gray
    Nov 29, 2006 at 4:30 pm
    Nov 29, 2006 at 4:30 pm
  • Is this ready for CPAN? Can I convert DBIC -current to use it? Have you forgiven me for forgetting to look over the codebase and comment last time you asked? Will you forgive for forgetting who you ...
    Matt S TroutMatt S Trout
    Nov 25, 2006 at 10:45 pm
    Nov 25, 2006 at 10:45 pm
  • Are you out there in list-archive land?
    Neil de CarteretNeil de Carteret
    Nov 25, 2006 at 8:05 pm
    Nov 25, 2006 at 8:05 pm
  • Just a quick reminder, some people still seem to be under the impression dev.catalystframework.org is the location to check out the repos from. This was due to an accidental reconfiguration by Marcus ...
    Matt S TroutMatt S Trout
    Nov 25, 2006 at 12:39 pm
    Nov 25, 2006 at 12:39 pm
  • Hi users of DBIx::Class and Perl, (sorry for crossposting this to a lot of lists, but Perl needs YOU!) There is an international contest and comparison with scientific evaluation about programming ...
    Alvar FreudeAlvar Freude
    Nov 24, 2006 at 1:32 am
    Nov 24, 2006 at 1:32 am
  • Some time ago, I've reported a pretty nasty bug I encountered when prefetching nested has_many relationships. At the time I tried fixing it myself but the best I could do was finding where the bug ...
    Nilson Santos Figueiredo JuniorNilson Santos Figueiredo Junior
    Nov 17, 2006 at 11:58 pm
    Nov 17, 2006 at 11:58 pm
  • Hi, I've been working on this patch to allow bind parameter attributes so that we can properly support column types like Oracles B/CLOB type or Postgres' BYTEA type and wondering if there is a need ...
    John NapiorkowskiJohn Napiorkowski
    Nov 17, 2006 at 4:04 pm
    Nov 17, 2006 at 4:04 pm
  • I'm pleased to announce that a new bugfix release of DBIx::Class is on its way to CPAN. Until it's indexed, you can grab the tarball at: http://pause.perl.org/incoming/DBIx-Class-0.07003.tar.gz ...
    Brian CassidyBrian Cassidy
    Nov 16, 2006 at 6:05 pm
    Nov 16, 2006 at 6:05 pm
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
groupdbix-class @
categoriesperl, catalyst

60 users for November 2006

Matt S Trout: 34 posts John Napiorkowski: 23 posts Christopher H. Laco: 19 posts Bernhard Graf: 16 posts Jess Robinson: 16 posts Josef Karthauser: 16 posts Brandon Black: 13 posts Mike Friedman: 7 posts Aristotle Pagaltzis: 6 posts Devin Austin: 6 posts Lee Standen: 6 posts Nathan Gray: 6 posts Neil de Carteret: 6 posts Ivan Georgiev: 5 posts Jon Warbrick: 5 posts Len Jaffe: 5 posts Anthony Hinsinger: 4 posts Hartmaier Alexander: 4 posts Nigel Metheringham: 4 posts Yuval Kogman: 4 posts
show more