Re: [Dbix-class] postgres table inheritance in Schema?

2010-08-03 Thread Peter Rabbitson
Bernhard Bauch wrote: hey all, i'm using postgres and postgres' table inheritance. but i want to deploy my db from my dbix:class schema, so i need a way to tell the schema that eg. App::Schema::Foo::Bar inherits from App::Schema::Foo using it in dbix-class works fine.. but just deploying

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. Were you helped with

Re: [Dbix-class] resultsource classdata

2010-08-03 Thread Peter Rabbitson
Bernhard Bauch wrote: hey dbixclass-list, i'm looking for something like having classdata for dbix-class resultset classes. of course if can have classdata available in my schema eg. like package MyApp::Schema; use Moose; use namespace::autoclean; BEGIN {

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. snip # a simple counting

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: ... however, if the join is present: DBIx::Class::ResultSet::all(): Cannot bind unknown placeholder 3 (3) at /Library/Perl/5.10.0/DBIx/Class/Storage/DBI.pm line 1475. Please provide the DBIC_TRACE=1 of what SQL is generated right before you see this error.

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Hi Peter, Am 03.08.2010 um 11:59 schrieb Peter Rabbitson: Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Hi, Am 03.08.2010 um 12:11 schrieb Peter Rabbitson: Wolfgang Kinkeldei wrote: ... however, if the join is present: DBIx::Class::ResultSet::all(): Cannot bind unknown placeholder 3 (3) at /Library/Perl/5.10.0/DBIx/Class/Storage/DBI.pm line 1475. Please provide the DBIC_TRACE=1 of what

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. snip # a simple counting

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Hi Peter, If you need the full schema files, I could provide a tarball for you. However, this is nothing that I would like to see in the mailing list as a whole. It would not help most of the people reading this thread... Am 03.08.2010 um 13:20 schrieb Peter Rabbitson: Wolfgang Kinkeldei

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hi Peter, If you need the full schema files, I could provide a tarball for you. No need for these. This is the search taken from my project. The points marked like (1), (2), (3) contain places where changes make the query work or fail. snipped a lot of stuff my

[Dbix-class] missing 'many-to-many' relationship

2010-08-03 Thread Steve
Hi all, I am bewildered as to why my 'many_to_many' relationship is being ignored. I get an error when trying to use the relationship because it 'does not exist', and clearly it doesn't. WHY? My result classes are 'User.pm', 'Role.pm', and 'UserRole.pm'. I'm using the DBIC::Loader to generate

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Peter, Am 03.08.2010 um 14:34 schrieb Peter Rabbitson: Wolfgang Kinkeldei wrote: Hi Peter, If you need the full schema files, I could provide a tarball for you. No need for these. This is the search taken from my project. The points marked like (1), (2), (3) contain places where

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Peter, Am 03.08.2010 um 14:34 schrieb Peter Rabbitson: Wolfgang Kinkeldei wrote: Hi Peter, If you need the full schema files, I could provide a tarball for you. No need for these. This is the search taken from my project. The points marked like (1), (2), (3)

[Dbix-class] DBIx::Class::Tree::Fast

2010-08-03 Thread vdg
Hello all, I have implemented a new dbic component to manage trees. It's an alternative method to DBIx::Class::Tree::AdjacencyList and DBIx::Class::Tree::NestedSet. Basically it's the implementation of the general method describe in this paper : http://arxiv.org/pdf/cs.DB/0402051 with this

Re: [Dbix-class] DBIx::Class::Tree::Fast

2010-08-03 Thread fREW Schmidt
Comments and ideas very welcome off course. This is indeed very interesting. I look forward to reading the code more carefully later. On first perusal I *did* notice two things though: 1) What is locale_h from POSIX? 2) Did you realize you used // which is in 5.10 and greater only? 3) you