dbix-class@lists.scsys.co.uk discussions

2	[Dbix-class] Avoiding _prune_unused_joins

(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

3	[Dbix-class] Postgres "SELECT FROM ONLY"?

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

3	[Dbix-class] SQL::Abstract

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

6	[Dbix-class] transaction isolation levels

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

7	[Dbix-class] How to build a "good" object with deep nested prefetched rows from raw data?

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

2	[Dbix-class] Duplication of records in many-to-many prefetch

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

1	[Dbix-class] DBIx::Class Relationship Setup Based on Substring of Value in Field

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

2	[Dbix-class] Returning search results in a specific order

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

1	[Dbix-class] Column renaming.

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

2	[Dbix-class] DBIx::Class::DeploymentHandler cannot create ugrade scripts for SQL Server

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

2	[Dbix-class] what is the err in this DBIx select...

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

1	[Dbix-class] update circular reference

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

1	[Dbix-class] missing "require DBI" in DBIx::Class::Storage::DBI::SQLite

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

5	[Dbix-class] Test suites fail on sqlite upgrade

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

7	[Dbix-class] transaction in a resultset class

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

2	[Dbix-class] Complex joins

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

6	[Dbix-class] select specific columns on resultset

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

3	[Dbix-class] Undetermined deployment statements

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

5	[Dbix-class] Deletion of related rows in MySQL

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

8	[Dbix-class] Representing directory structures

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

2	[Dbix-class] update a row only if any column has changed

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

1	[Dbix-class] Inherited search method, current_source_alias and add_to_ for many_to_many.

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

4	[Dbix-class] Generating DISTINCT ON with sub query

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

5	[Dbix-class] using DBIx::Class::Migration with Journal

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

0	[Dbix-class] DBIx::Class::Fixtures store content of table in one file

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

8	[Dbix-class] Fine-tuning of prefetched relationships

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

6	[Dbix-class] DBIx::Class::Relationship::CascadeActions::delete(): Not in database

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

6	[Dbix-class] how to empty a Table? when there is no primary key

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

2	[Dbix-class] Sybase users needed to test a DBIC::Storage::Sybase::ASE change

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

2	[Dbix-class] how to build this query? col1 not like "%xx%" AND col1 like "%yy%"

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

0	[Dbix-class] Testing behaviour when sending to the list - safe to ignore

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

3	[Dbix-class] Is columns to cols as +columns is to +cols

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

2	[Dbix-class] DBIx::Class::ResultClass::HashRefInflator and JSON::XS expanding numbers as strings

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

3	[Dbix-class] [ANNOUNCE] A much faster DBIx::Class public trial round three - v0.08242

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

1	[Dbix-class] Re: "search on row->has_many fails if row has prefetch join", after 0.08196 -> 0.08206 upgrade

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

2	[Dbix-class] How do I select bound functions with as 'as' name in the column

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

1	[Dbix-class] Running Parallel queries

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

0	[Dbix-class] PostgreSQL & schema

Will do. Thanks for the pointer.

Diab Jerius
Mar 4, 2013 at 3:15 pm
Mar 4, 2013 at 3:15 pm

3	[Dbix-class] Exceptions per DB system

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

14	[Dbix-class] "the apparent complexity of it all"

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

3	[Dbix-class] "search on row->has_many fails if row has prefetch join" after 0.08196 -> 0.08206 upgrade

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

12	[Dbix-class] [ANNOUNCE] A much faster DBIx::Class public trial round two - v0.08241

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

1	[Dbix-class] [ANNOUNCE] A much faster DBIx::Class public trial - v0.08240

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

3	[Dbix-class] Explicit class naming

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

1	[Dbix-class] Code Review - Duplicated columns with 'having'

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

1	[Dbix-class] Is inflation the default?

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

0	[Dbix-class] Fwd: Perl School 4: Database Programming with Perl and DBIx::Class

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

14	[Dbix-class] DBIx::Class with ODBC

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

13	[Dbix-class] Prefetch and join on different tables

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

4	[Dbix-class] help needed in forming a 'and' and 'or' select query using DBIx::Class

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	dbix-class
categories	perl, catalyst
discussions	2,498
posts	11,288
users	893
website	dbix-class.org
irc	#dbix-class

summaries	on	Hotkey: s
users list	on	Hotkey: d
user style	avatars	Hotkey: a

Perl > dbix-class

Search Discussions

2,498 discussions - 11,288 posts

Top users

Content

People

Support

Translate