FAQ

Search Discussions

49 discussions - 262 posts

  • Hi everybody, I'm writing a forum application with DBIx::Class and Catalyst. Every post in a forum is stored using two tables (for performance reasons): * posts - (DBIC class "Forum::Post") contains ...
    TobiasTobias
    Jan 11, 2007 at 4:06 pm
    Jan 22, 2007 at 1:22 pm
  • Hi, I am trying to make a simple search, but I don't know what I am doing wrong, and it doesn't print the right result: my $roles = $schema- resultset("UserRole")- search; while (my $role = $roles- ...
    Octavian RasnitaOctavian Rasnita
    Jan 19, 2007 at 4:18 pm
    Jan 24, 2007 at 9:32 pm
  • Hi, I read that someone on this list was looking for Oracle 8 support in DBIx::Class. I have needed the same thing, and ended up writing it. It is attached. It does not have a test suite, so you'll ...
    Justin WJustin W
    Jan 2, 2007 at 2:42 pm
    Jan 26, 2007 at 9:49 am
  • Hi all, at thursday 9.00 am CET the web development platform contest starts (http://www.plat-forms.org). Some of you may have heard of it, some others not, so I'll just give some info: The contest ...
    Rolf SchaufelbergerRolf Schaufelberger
    Jan 23, 2007 at 11:36 am
    Feb 2, 2007 at 9:50 am
  • Hey Guys and Gals... We are just starting a DBIx::Class project here at the Washington University Genome Sequencing Center in St. Louis, and __of__course__ we choose DBIx::Class over all that other ...
    Ryan RichtRyan Richt
    Jan 24, 2007 at 1:01 am
    Jan 25, 2007 at 12:28 am
  • Hi, once again ... I am using DBIX::Class into Catalyst environment and i am trying to figure out a solution for 2 problems different but with common roots: 1 - how can i execute something like ...
    Igor LongagnaniIgor Longagnani
    Jan 17, 2007 at 9:43 am
    Jan 22, 2007 at 1:24 pm
  • Hi, I have a code like: my $rs = $c- model("Db::Forum")- search({ id_room = 1, }, { join = "id_user", prefetch = "id_user", rows = 20, order_by = 'date desc, time desc', page = 1, }); I want to add ...
    Octavian RasnitaOctavian Rasnita
    Jan 9, 2007 at 3:01 pm
    Jan 11, 2007 at 7:19 pm
  • Hi Matt, Thoughts about transactions if I may. Firstly things look a bit gnarly with respect to auto re-connection, and forking (validate_pid). It doesn't look as if any transaction rules are in ...
    Josef KarthauserJosef Karthauser
    Jan 24, 2007 at 3:36 pm
    Jan 25, 2007 at 4:59 pm
  • Hi, all I encountered a problem as below while tyring to use DBIx::Class::InflateColumn::DateTime. 'register_column' method of DBIx::Class::InflateColumn::DateTime changes 'timestamp' to 'datetime' ...
    Takashi KarinoTakashi Karino
    Jan 16, 2007 at 1:47 pm
    Jan 19, 2007 at 11:52 am
  • Hi. In a Catalyst application I am working on, in which we use DBIx::Class, server.pl just grew to use over 300MB ram, staying that size from then on. I've tried to replicate what happens, and hope ...
    Adam SjøgrenAdam Sjøgren
    Jan 8, 2007 at 3:51 pm
    Jan 11, 2007 at 6:38 pm
  • I've uploaded the latest development release to CPAN, please treat this as not yet RC quality, it may break and eat your marbles. Please report any bugs/problems to this list. 0.07999_02 2007-01-25 ...
    Jess RobinsonJess Robinson
    Jan 25, 2007 at 8:48 pm
    Jan 31, 2007 at 6:15 pm
  • I was wondering if anyone had any suggestions for how to properly use memcached (http://www.danga.com/memcached/) with DBIx::Class. When one tries to store a resultset in memcached, you get the error ...
    Jim SpathJim Spath
    Jan 24, 2007 at 8:10 pm
    Jan 25, 2007 at 11:54 am
  • Disclaimer: I'm a noob to DBIx::Class. I checked the archives, but was unable to find an answer to the following question. If I've overlooked an obvious source to my answers, please scold me and ...
    James R. LeuJames R. Leu
    Jan 23, 2007 at 9:34 pm
    Jan 25, 2007 at 8:55 am
  • Hi, Currently the ResultSet reflection (using the relationships method) is constrained to the 'true' relationships (that is those involving just two database tables) and there is no way to find the ...
    Zbigniew LukasiakZbigniew Lukasiak
    Jan 30, 2007 at 4:16 pm
    Jan 31, 2007 at 11:23 am
  • Hi, I'm attempting to use distinct with a rows attribute on Oracle 9. DBIC is generating SQL looking something like this: SELECT * FROM ( SELECT A.*, ROWNUM r FROM ( SELECT myCol AS col1 FROM table ...
    Sam CrawleySam Crawley
    Jan 15, 2007 at 2:44 pm
    Jan 16, 2007 at 9:42 am
  • I am still trying to wrap my head around DBIx::Class, and I am trying to create a little app with it. Currently I have four tables, "feed", "item", "user" and "subscription". The "subscription" table ...
    Patrik WallstromPatrik Wallstrom
    Jan 4, 2007 at 9:04 pm
    Jan 7, 2007 at 2:26 pm
  • Hi I want to add a new find method to one of my result classes ... package Engoi::Schema::EngoiDb::Members; use strict; use warnings; use base 'DBIx::Class'; __PACKAGE__- load_components("PK::Auto", ...
    Daniel McBreartyDaniel McBrearty
    Jan 4, 2007 at 2:12 pm
    Jan 4, 2007 at 5:31 pm
  • Hi, I am using DBIx::Class in a new Catalyst project which will include some legacy code that uses plain DBI. Is there a way to get the database handle from my schema and pass it on to the legacy ...
    Ivan WillsIvan Wills
    Jan 3, 2007 at 2:21 am
    Jan 3, 2007 at 10:02 pm
  • So I have this code: my $rs = $self- search_related('watching', {}, { select = [ { distinct = 'item.id' } ], prefetch = { person = { relations = 'item' } }, join = { 'person' = { 'relations' = 'item' ...
    Christopher HeschongChristopher Heschong
    Jan 27, 2007 at 2:53 am
    Jan 29, 2007 at 7:58 am
  • Hello, I'm facing a weird problem with DBIx::Class (used through Catalyst). Well, this constraint exists, but the fact is I wasn't trying to insert anything into the database. I have simplified the ...
    Xavier RobinXavier Robin
    Jan 24, 2007 at 1:35 pm
    Jan 26, 2007 at 8:41 am
  • Hi all, I'm just a little confused by all the various documentation. I'm attempting to create a table schema which has a multi-column primary foreign key. That is, the primary keys of table A, are ...
    Joss ShawJoss Shaw
    Jan 16, 2007 at 12:57 pm
    Jan 17, 2007 at 12:54 pm
  • I'm trying to figure out how to set up a polymorphic relationship using many_to_many, and I'm having a bit of trouble. Assume 4 tables: Actors: id, name ActorRoles: actor_id, charactername, ...
    Jason GottshallJason Gottshall
    Jan 9, 2007 at 11:01 pm
    Jan 11, 2007 at 9:17 pm
  • Restarter doesn't watch the Database for changes ('m talking about direct modifications to the database and NOT through the database handle.) Here's where ( i *think* ) the Restarter is failing .... ...
    AbhijithAbhijith
    Jan 10, 2007 at 4:09 am
    Jan 10, 2007 at 8:32 am
  • Hi, I am trying to use the following condition but without success. Is it possible to do it with DBIx::Class? select count(*) where substring(title, 1, 4)='XXXX'; I have tried using ...
    Octavian RasnitaOctavian Rasnita
    Jan 6, 2007 at 5:47 am
    Jan 7, 2007 at 12:54 am
  • Hello @all, I am useing DBIx:Class with Catalyst and would like to extend one of my modell classes (derived from DBIx::Class). I would like to extand the class that handles address data (like street, ...
    Mario MinatiMario Minati
    Jan 29, 2007 at 6:44 pm
    Jan 29, 2007 at 10:33 pm
  • Why does DBIx::Class involve itself with the status of the AutoCommit flag in its transaction code? Shouldn't it just delegate this to the DBI and propagate any exceptions raised there? Joe A ...
    Josef KarthauserJosef Karthauser
    Jan 26, 2007 at 7:56 pm
    Jan 27, 2007 at 10:25 am
  • Hi, Is it possible to insert in a table some records based on another resultset? For example, I have just inserted a user in the "user" table, and then I want to insert the roles for this user in the ...
    Octavian RasnitaOctavian Rasnita
    Jan 20, 2007 at 12:53 pm
    Jan 20, 2007 at 10:16 pm
  • Hi, I have created the table class using the Catalyst helper DBIC::Schema but I see that it automaticly chooses the same name for the relations as for the table rows, so it doesn't work in some ...
    Octavian RasnitaOctavian Rasnita
    Jan 19, 2007 at 7:07 pm
    Jan 19, 2007 at 8:28 pm
  • Hi, Is it possible to insert more records using the same code and just adding a certain different field for each record? I wanted to do something like: my $rs = $schema- resultset("Table")- new({ # ...
    Octavian RasnitaOctavian Rasnita
    Jan 10, 2007 at 2:50 pm
    Jan 11, 2007 at 10:32 pm
  • hi... i am using SchemaLoader to load the schema from mysql database. Here's the nature of the problem: 1. I create a table 't1' with columns c1,c2,c3. 2. Load the schema using Schema Loader. 3. I ...
    AbhijithAbhijith
    Jan 8, 2007 at 7:45 am
    Jan 8, 2007 at 3:06 pm
  • Hi all, I hope my question can be answered "generally" so I don't have to go too much into the details of my dbic setup... Here's my problem: I select rows in a table and use prefetch to also select ...
    Ben StaudeBen Staude
    Jan 5, 2007 at 2:22 pm
    Jan 5, 2007 at 3:38 pm
  • With SQL::Translator 0.07, a DBIx::Class declaration such as this: __PACKAGE__- add_columns('plugin_id' = { 'data_type' = 'integer', 'is_nullable' = 0, 'is_auto_increment' = 1, }, 'class' = { ...
    JonJon
    Jan 31, 2007 at 4:06 am
    Jul 30, 2007 at 9:58 am
  • Hi peeps, Me again. This time with a different question :). The background is that I'm implementing nested transaction handling, initially for mysql which can handle it using SAVEPOINTs. What I'm ...
    Josef KarthauserJosef Karthauser
    Jan 31, 2007 at 9:43 pm
    Feb 1, 2007 at 9:32 am
  • Hi! I'm currently in the process of "deploying" a Cat app to a server where I have very little rights. i.e. access is only through ftp. Some parts where installed by the sysadmins, but they do not ...
    Thomas KlausnerThomas Klausner
    Jan 31, 2007 at 3:12 pm
    Jan 31, 2007 at 8:44 pm
  • (Apologies I sent this to the wrong list earlier). I have a problem with some of the field types set up in my Database and wondered if anyone can help me to define it within my model properly. The ...
    Jonathan BatchelorJonathan Batchelor
    Jan 30, 2007 at 12:21 pm
    Jan 30, 2007 at 2:31 pm
  • Hello, Apologies for being a newbie, but could someone please help me with the correct syntax for this mysql query: select * from sessions where id='foo' and created DATE_SUB(NOW(), INTERVAL 1 HOUR ...
    DanielDaniel
    Jan 18, 2007 at 5:05 pm
    Jan 18, 2007 at 5:20 pm
  • Hi, I'm trying to clean up the issues with the param_bind branch, in particular the failing test that Matt noticed for the ordered function. Turns out the issue has nothing to do with ordering ...
    John NapiorkowskiJohn Napiorkowski
    Jan 10, 2007 at 9:18 pm
    Jan 11, 2007 at 10:42 pm
  • Dear list-members and DBIx::Class developers, Can any of you enlighten me on the best way --if at all possible in DBIx::Class-- to "translate" the following SQLquery in a DBIx::Class structure? ...
    Karl MoensKarl Moens
    Jan 10, 2007 at 7:57 am
    Jan 10, 2007 at 9:24 am
  • This is mostly a fix to correct find_or problems. Changelog: 0.07004 2007-01-09 21:52:00 - fix find_related-based queries to correctly grep the unique key - fix InflateColumn to inflate/deflate all ...
    Jess RobinsonJess Robinson
    Jan 9, 2007 at 9:54 pm
    Jan 9, 2007 at 10:07 pm
  • I'm reading the POD at http://search.cpan.org/~bricas/DBIx-Class-0.07003/lib/DBIx/Class/ResultSet.pm#count but not really getting it, or whether it's what I want to solve this particluar case. I have ...
    Daniel McBreartyDaniel McBrearty
    Jan 5, 2007 at 10:51 am
    Jan 8, 2007 at 8:21 pm
  • Took your advice. But... touching MyApp.pm doesn't help solve the problem. We ll have to touch lib/MyApp/SchemaClass.pm in order for it to reload the schema. ie., ...
    AbhijithAbhijith
    Jan 8, 2007 at 1:32 pm
    Jan 8, 2007 at 2:32 pm
  • I will be out of the office starting 31/01/2007 and will not return until 02/02/2007. In case of an emergency, please call our emergency telephone number +32 3 286 64 85. For urgent matters please ...
    Karl MoensKarl Moens
    Jan 31, 2007 at 11:30 am
    Jan 31, 2007 at 11:30 am
  • I have at least 3 dists that all do the same sort of thing, and I'm sure I'm not alone: use strict; use warnings; use lib 'lib'; use MyDist::Test tests = 42; # creates a fresh t/var/mydist.db ...
    Christopher H. LacoChristopher H. Laco
    Jan 29, 2007 at 3:58 pm
    Jan 29, 2007 at 3:58 pm
  • Example case (pseudo-code): CD- belongs_to('artist'); CD- might_have('pair' = 'CD' = 'other_cd_id'); Artist- has_many('cds' = 'CD' = 'artist_id'); Now, one might want to: $db- resultset('CD')- ...
    Radoslaw ZielinskiRadoslaw Zielinski
    Jan 25, 2007 at 4:03 pm
    Jan 25, 2007 at 4:03 pm
  • Hi James, DBIx::Class::Schema::Loader will scan one database for its tables and relationships and set up a single schema object for you. As far as I know it doesn't span more than one DB so you will ...
    Peter EdwardsPeter Edwards
    Jan 23, 2007 at 10:28 pm
    Jan 23, 2007 at 10:28 pm
  • Hello, This email is a follow-up to my post to this forum of 2 days ago of subject "RFC: host for new m-l for a DBMS module". See http://www.nntp.perl.org/group/perl.dbi.users/30734 for a ...
    Darren DuncanDarren Duncan
    Jan 21, 2007 at 9:21 am
    Jan 21, 2007 at 9:21 am
  • Hello, This email concerns an unreleased new Perl DBMS module/framework/engine that has separate Perl 5 and Perl 6 versions; the Perl 5 version is named QDRDBMS, and serves as a prototype for the ...
    Darren DuncanDarren Duncan
    Jan 19, 2007 at 6:19 am
    Jan 19, 2007 at 6:19 am
  • From the DBIx::Class::Manual::Cookbook -- Disconnecting cleanly If you find yourself quitting an app with Control-C a lot during development, you might like to put the following signal handler in ...
    Ashley Pond VAshley Pond V
    Jan 8, 2007 at 11:54 pm
    Jan 8, 2007 at 11:54 pm
  • It seems to me that a search with prefetch does not take into consideration the extra attributes specified in the prefetched relationships' attributes. My device class defines its relationships like ...
    Ryan VanderBijlRyan VanderBijl
    Jan 8, 2007 at 3:12 pm
    Jan 8, 2007 at 3:12 pm
Group Navigation
period‹ prev | Jan 2007 | next ›
Group Overview
groupdbix-class @
categoriesperl, catalyst
discussions49
posts262
users72
websitedbix-class.org
irc#dbix-class

72 users for January 2007

Matt S Trout: 42 posts Jess Robinson: 17 posts John Napiorkowski: 14 posts Octavian Rasnita: 13 posts Brandon Black: 11 posts Nilson Santos Figueiredo Junior: 11 posts Hartmaier Alexander: 10 posts Aristotle Pagaltzis: 8 posts Josef Karthauser: 8 posts Igor Longagnani c/o Synervis: 7 posts David Jack Olrik: 5 posts Abhijith: 4 posts Christopher H. Laco: 4 posts Daniel McBrearty: 4 posts Peter Edwards: 4 posts Richard Jolly: 4 posts Tobias Kremer: 4 posts Adam Sjøgren: 3 posts Brian Kirkbride: 3 posts Fernan Aguero: 3 posts
show more
Archives