Search Discussions
-
(I'm using 0.08250) I'll avoid a boring preamble and just ask if anyone could advise on how to construct resultsets so that deep in the internals, _prune_unused_joins isn't called? (so as to save me ...
Bob MacCallum
May 10, 2013 at 3:46 pm
May 10, 2013 at 4:14 pm -
Hello! Is there a way to do PG's "SELECT FROM ONLY tablename" in DBIx::Class without using literal SQL? Alex
Alex Povolotsky
May 10, 2013 at 1:56 pm
May 10, 2013 at 7:02 pm -
Hi, Does anybody know what's happening here? (I know the index is switched off.) This: @rs = $schema- resultset("LeasingUser")- search( \[ 'UPPER(username) = ?', uc($username) ] ); ok( scalar(@rs), ...
Duncan Garland
May 7, 2013 at 5:24 pm
May 8, 2013 at 8:46 am -
I have been unable to find documentation about how to use different transaction isolation levels, or even what the default isolation level is, generally, but also specifically for postgres. I've read ...
Stanley Pilton
May 4, 2013 at 3:12 pm
May 6, 2013 at 4:37 pm -
Hello! OVERVIEW Imagine that we have some data in DB, which can be represented in nested structure Eg. categories tree: CREATE TABLE categories ( id INT NOT NULL, parent_id INT NULL , title TEXT, ...
Dmitry L.
May 2, 2013 at 9:39 am
May 2, 2013 at 11:35 am -
Hi all, In my project, a user can have multiple roles and multiple users can have the same role. The username is the primary key for the users table. When I run a query like: - search({ 'me.username' ...
Shea Levy
May 1, 2013 at 10:16 pm
May 2, 2013 at 3:01 pm -
Hi everybody, Does DBIx::Class allow relationships to be set up between two fields that are two different sizes? We have a registration table and a class table that are linked by term, course number, ...
Stephenmoy
May 1, 2013 at 5:49 pm
May 2, 2013 at 6:32 am -
I honestly fail to see what part of my earlier reply you could have perceived as negative, but glad your problem ended up solved ;) Cheers
Peter Rabbitson
May 1, 2013 at 3:17 pm
May 2, 2013 at 10:17 am -
I have a column in a table that is going to be renamed from "foo" to "bar". I know I can use the "accessor" attribute, but there's other usage such as $obj- update( { foo = 'new' } ), and also - ...
Bill Moseley
Apr 21, 2013 at 4:55 pm
Apr 22, 2013 at 9:42 am -
An HTML attachment was scrubbed... URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20130418/8c731261/attachment.htm
José Diaz Seng
Apr 18, 2013 at 9:12 pm
Apr 22, 2013 at 10:46 am -
I am meaning to run... search records where: ??? if item_type='XX' ? _then_ item column should contain '%01par%'? or '%01pqt%' ??? and, ??? if item_type='YY' OR item_type='YZ' ?? _then_ ? item column ...
Rajeev Prasad
Apr 15, 2013 at 7:47 pm
Apr 16, 2013 at 9:31 pm -
How do I maintain a circular reference? The relation part of the schema is below, but I can do: my $url_rs = $self- search({url = $url})- single; foreach my $text (@{$data- {$domain}{$url}}) { try { ...
Shawn wilson
Apr 12, 2013 at 8:26 pm
Apr 14, 2013 at 11:49 pm -
hi, I'm trying to install HTML::FormHandler::Model::DBIC. with DBIx::Class 0.08210, I get the following error: Undefined subroutine &DBI::SQL_INTEGER called at ...
Patrick Meidl
Apr 12, 2013 at 11:29 am
Apr 22, 2013 at 9:58 am -
Hi, After updating sqlite from 3.7.14.1 to 3.7.16.1 (my package manager uses a system sqlite for DBD::SQLite), the DBIx-Class testsuites fail: http://hydra.nixos.org/build/4720176/nixlog/1/raw. Any ...
Shea Levy
Apr 11, 2013 at 5:47 pm
Apr 22, 2013 at 9:50 am -
Since txn_* is a part of the schema, how do I have a resultset method always run within one transaction without passing $schema (which just seems kludgy)? Since I can't find anything on google about ...
Shawn wilson
Apr 11, 2013 at 2:58 pm
Apr 22, 2013 at 9:54 am -
I have googled for this, as far as I can tell DBIx::Class does not support complex joins. An example of which is below. select star.id,star.name,body.id,body.name,building.class,empire.name from star ...
Iain C Docherty
Apr 10, 2013 at 7:40 pm
Apr 10, 2013 at 8:41 pm -
Hi all, I'm new to DBIx, I'm trying to retrieve only a subset of columns from a result set: my @recs=$self- db- resultset($self- table)- search({},{columns = [qw/ id Name OperationId Name /],},)- ...
Max
Apr 9, 2013 at 1:19 pm
Apr 11, 2013 at 11:46 am -
I have noticed strange behavior of $schema- deploy (actually my tests started to fail after DBIC upgrade). my $schema = Schema- connect( 'dbi:SQLite:dbmane=:memory:' ); $schema- deploy({ ...
Konstantin A. Pustovalov
Apr 9, 2013 at 10:19 am
Apr 10, 2013 at 3:36 am -
Hi list! I have a code which I have narrowed to http://paste.scsys.co.uk/240549 It does $schema- resultset- search_rs- search_related_rs- delete This happened to work with DBIC v 0.08196 but stopped ...
Konstantin A. Pustovalov
Apr 9, 2013 at 8:35 am
Apr 10, 2013 at 3:34 am -
Anyone using DBIC to represent hierarchal directory (folder) structures? Essentially just like a file system, except users each have their own root. To add to the complexity, I need to be able to ...
Bill Moseley
Apr 7, 2013 at 6:42 pm
Apr 8, 2013 at 2:02 pm -
hello, I have a table with around 2,000,000 records (15 columns). I have to sync this from an outside source once everyday. not all records are changed/removed /new-added everyday. so what is the ...
Rajeev Prasad
Apr 5, 2013 at 11:45 pm
Apr 6, 2013 at 8:50 pm -
Hello! A little overview. I have 1 table (users), and 3 result classes: AbstractUser, User and Admin. Table has column role (which defines who user is - Admin or User). And I use inflate_result in ...
Dmitry Latin
Apr 4, 2013 at 7:10 am
Apr 4, 2013 at 8:04 am -
I have something like the following $self- search( $search, { join = [ { 'course' = [ { course_coursetypes = 'type' }, { course_grades = 'grade' }, 'course_locations', ] }, { 'section' = { ...
Rippl, Steve
Apr 3, 2013 at 3:20 am
Apr 3, 2013 at 4:23 pm -
Hello, I'd like to combine the usage of DBIx::Class::Migration with DBIx::Class::Journal but setting up a test environment doesn't show the tables created from Journal. Is this a general problem that ...
Mario Minati
Apr 2, 2013 at 10:03 pm
Apr 8, 2013 at 11:39 am -
hi @ll, i am playing around with DBIx::Class::Migration and use dump_all_sets to store my persistent data. I was wondering why a single file is generated for each record. In my case this results in ...
M0ses
Apr 2, 2013 at 8:23 am
Apr 2, 2013 at 8:23 am -
Hi all, In my db, a Project has many Jobs. I have a query on Projects where I want to: 1. Sort the jobs of each project by a particular column on the Jobs table 2. Only include jobs that satisfy some ...
Shea Levy
Apr 1, 2013 at 12:43 pm
Apr 2, 2013 at 5:05 am -
Here's a rather contrived example: my $artist = $schema- resultset( 'Artist' )- first; eval { my $guard = $schema- txn_scope_guard; $artist- delete; die 'rollback!'; 1; }; #$artist- in_storage(1) ...
Bill Moseley
Mar 26, 2013 at 5:51 am
Mar 27, 2013 at 2:20 pm -
I tried to use delete_all, but there is no primary key in the table so it failed. what else can i do? I need to delete all rows from a table and then add new ones based on logic. this happens once a ...
Rajeev Prasad
Mar 24, 2013 at 10:28 pm
Mar 27, 2013 at 1:50 pm -
Hi! Currently the dev team does not have an easy access to a Sybase ASE server (properly installing and configuring one is a massive bitch). If someone has such an instance handy it would be very ...
Peter Rabbitson
Mar 23, 2013 at 2:15 pm
Mar 28, 2013 at 12:22 am -
Hello, I tried quite a few things, but it is not working... col1 not like "%xx%" AND col1 like "%yy%" OR, if someone can tell me how can i run a select query again on an rs obtained by running a ...
Rajeev Prasad
Mar 19, 2013 at 11:32 pm
Mar 20, 2013 at 3:39 pm -
A cow-orker saw weird behaviour earlier when he tried to email the list I'm getting this: Cannot send to <span class="m_body_email_addr" title="9306d962dbb245deb6b2f5b61883abdf" ...
Chisel
Mar 18, 2013 at 5:47 pm
Mar 18, 2013 at 5:47 pm -
Hello, Just wanted to point out an issue I ran with cols/+cols when chaining a couple of DBIC queries. I was trying to do the following: $schema- resultset('CD')- search({}, { cols = 'me.cola'})- ...
Darius Jokilehto
Mar 18, 2013 at 4:44 pm
Mar 19, 2013 at 2:04 pm -
I have a PostgreSQL database that I run queries on, then use $rs- result_class('DBIx::Class::ResultClass::HashRefInflator'); and send [ $rs- all ] to JSON::XS for serialization in a RESTful ...
Robert Rothenberg
Mar 15, 2013 at 9:48 am
Mar 18, 2013 at 1:25 pm -
Greetings Yet another release of DBIC featuring the experimental constructor rewrite just hit CPAN. Please grab and test 0.08242-TRIAL from your nearest mirror [1]. You can install the release in ...
Peter Rabbitson
Mar 10, 2013 at 3:31 pm
Mar 21, 2013 at 10:33 pm -
I have tested this in our test suite with master at that time and can confirm it passes. Thanks for your help. -- Colin Dearing Developer NET-A-PORTER.COM NET-A-PORTER.COM Irresistible fashion at ...
Colin Dearing
Mar 10, 2013 at 2:36 pm
Mar 10, 2013 at 3:33 pm -
I am trying to run a DBIx::Class query on a PostGIS function with binders, with the attributes of the search query having something like: { 'as' = [ 'id', 'name', 'location', 'distance_from_location' ...
Robert Rothenberg
Mar 8, 2013 at 2:05 pm
Mar 8, 2013 at 2:48 pm -
Just curious if anyone has suggestions for running parallel queries with DBIC -- same schema on many database machines. Anyone have experience with POE::Component::MDBA::Backend::DBIC? From 2007 and ...
Bill Moseley
Mar 5, 2013 at 7:12 pm
Mar 13, 2013 at 1:56 pm -
Will do. Thanks for the pointer.
Diab Jerius
Mar 4, 2013 at 3:15 pm
Mar 4, 2013 at 3:15 pm -
Hi In http://afoolishmanifesto.com/dbie-intro/slideshow.html , slide "28 What it do's?", it's mentioned that not all DB systems are exception-supported. With DBIx::Class: 0.08127 and DBD::mysql ...
Vangelis Katsikaros
Mar 1, 2013 at 4:59 pm
Apr 5, 2013 at 2:42 pm -
This is a follow-up to <http://blogs.perl.org/users/ross_attrill/2013/02/dbixdatamodel---elegant-database-interaction-with-perl.html#comment-367206 . Peter Rabbitson �: Sounds like a severe case of ...
Lars Dɪᴇᴄᴋᴏᴡ 迪拉斯
Feb 24, 2013 at 6:33 pm
Apr 9, 2013 at 12:33 pm -
Skipped content of type multipart/alternative A non-text attachment was scrubbed... Name: failing_test.t Type: application/x-troff Size: 1440 bytes Desc: not available Url ...
Chisel
Feb 22, 2013 at 4:46 pm
Feb 23, 2013 at 3:49 pm -
Greetings Another release of the experimental constructor rewrite just hit CPAN. Please grab and test 0.08241-TRIAL from our nearest mirror [1]. You can install the release in question by simply ...
Peter Rabbitson
Feb 20, 2013 at 11:31 am
Feb 24, 2013 at 3:08 pm -
Greetings Almost 4 years[1] to the day of the first commits toying with the idea, the constructor rewrite / prefetch modernization project seems to be nearing completion. At least it passes enough ...
Peter Rabbitson
Feb 14, 2013 at 8:38 am
Feb 14, 2013 at 12:24 pm -
I have a sneaking suspicion that this is a FAQ, but I can't find the answer anywhere. I have a schema where some of the table names are acronyms, and I'd like dbicdump to create classes with all-caps ...
Dag-Erling Smørgrav
Feb 13, 2013 at 5:16 pm
Feb 15, 2013 at 1:49 pm -
Hello, I have run into a bug when using an aggregate function and setting two or more possible values to the same column in the 'having' clause. Example: my $rs = $schema- resultset("Artist")- ...
André Walker
Feb 13, 2013 at 4:42 pm
Feb 13, 2013 at 7:10 pm -
Hey, Thanks for DBIx::Class. I am liking it. But I'm confused by inflation. I'm using 0.08120 - I know it's not the latest, but it's what I can use - and Class::Schema::Loader::make_schema_at to ...
Joe Carlson
Feb 8, 2013 at 6:59 pm
Feb 11, 2013 at 9:04 am -
I thought that people on this list might be interested in this too. Or, more likely, that you might know people who think *should* be interested :-) ----- Forwarded message from <span ...
Dave Cross
Feb 6, 2013 at 9:51 am
Feb 6, 2013 at 9:51 am -
Hi, Has anyone gotten DBIx::Class to work with an Ingres database using an ODBC driver? I get the following error on a simple search: DBIx::Class::ResultSet::search(): DBI Exception: DBD::ODBC::db ...
Stephenmoy
Jan 22, 2013 at 5:21 pm
Feb 20, 2013 at 2:15 pm -
Hello, I am performing a join between a table 'mdata', that has a 'has many' relationship with 'mc' and 'mt'. $where contains conditions over mc and mt, and I want all columns of mc and mdata in the ...
Mpm
Jan 18, 2013 at 8:06 pm
Jan 24, 2013 at 1:45 am -
Hello, I am trying to build a query based on two column values as folows: columnA = x (one char, any char - not null) columnB = zz _or_ x,xx,yyy,mm (comma seperated values or just one value) I am ...
Rajeev Prasad
Jan 18, 2013 at 6:19 pm
Jan 22, 2013 at 2:15 am
Group Overview
| group | dbix-class |
| categories | perl, catalyst |
| discussions | 2,498 |
| posts | 11,288 |
| users | 893 |
| website | dbix-class.org |
| irc | #dbix-class |
Top users
Archives
- March 2013 (29)
- February 2013 (37)
- January 2013 (82)
- December 2012 (63)
- November 2012 (65)
- October 2012 (48)
- September 2012 (63)
- August 2012 (69)
- July 2012 (110)
- June 2012 (91)
- May 2012 (48)
- April 2012 (17)
- March 2012 (23)
- February 2012 (50)
- January 2012 (73)
- December 2011 (22)
- November 2011 (28)
- October 2011 (89)
- September 2011 (58)
- August 2011 (46)
- July 2011 (59)
- June 2011 (32)
- May 2011 (51)
- April 2011 (60)
- March 2011 (37)
- February 2011 (61)
- January 2011 (76)
- December 2010 (66)
- November 2010 (53)
- October 2010 (62)
- September 2010 (29)
- August 2010 (86)
- July 2010 (78)
- June 2010 (79)
- May 2010 (95)
- April 2010 (103)
- March 2010 (66)
- February 2010 (90)
- January 2010 (124)
- December 2009 (117)
- November 2009 (71)
- October 2009 (75)
- September 2009 (94)
- August 2009 (86)
- July 2009 (180)
- June 2009 (158)
- May 2009 (194)
- April 2009 (147)
- March 2009 (153)
- February 2009 (161)
- January 2009 (113)
- December 2008 (30)
- November 2008 (127)
- October 2008 (193)
- September 2008 (97)
- August 2008 (92)
- July 2008 (198)
- June 2008 (123)
- May 2008 (147)
- April 2008 (136)
- March 2008 (135)
- February 2008 (207)
- January 2008 (235)
- December 2007 (109)
- November 2007 (123)
- October 2007 (203)
- September 2007 (182)
- August 2007 (113)
- July 2007 (201)
- June 2007 (273)
- May 2007 (451)
- April 2007 (179)
- March 2007 (107)
- February 2007 (50)
- January 2007 (262)
- December 2006 (172)
- November 2006 (277)
- October 2006 (200)
- September 2006 (236)
- August 2006 (239)
- July 2006 (241)
- June 2006 (315)
- May 2006 (230)
- April 2006 (202)
- March 2006 (261)
- February 2006 (202)
- January 2006 (213)
- December 2005 (88)
- November 2005 (112)
- October 2005 (30)
- September 2005 (49)
- August 2005 (89)
- July 2005 (43)
