Re: [Dbix-class] GOVERNANCE: Aggregation and conclusion
On November 2, 2016 at 7:02:46 AM, Dave Cross (d...@dave.org.uk) wrote: > > Mee too. > > +1 Matt's proposal (new project team) > -1 Andrew's proposal (forking) +1 (new project team) -1 (forking) -- Wallace Reis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] GOVERNANCE: An actually concrete proposal w/bootstrap governance system
On October 18, 2016 at 4:04:17 PM, Leo Lapworth (l...@cuckoo.org) wrote: > On 18 October 2016 at 17:51, Matt S Trout wrote: > > > =begin GOVERNANCE > > > . > > =end GOVERNANCE > > > > What say ye? > > This gets the governance issue resolved and puts in place a framework that > can evolve to fit what is needed at the time. > > +1 > > Anything more is just detail which can be added as required by the > community or core updating the governance in accordance with these rules. +1 # this pretty much summarizes my position. Cheers! -- Wallace Reis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] A slightly more concrete proposal
This pretty much matches my situation and opinion. Thanks Riba for the great work so far. +1 for Matt's plan. Cheers, -- Wallace Reis Em 5 de out de 2016 08:55, "Nigel Metheringham" <ni...@dotdot.it> escreveu: Background: I have been a happy DBIx::Class user from the early days. I have some code contributions within DBIC and SQLA, although relatively small ones, but have not had a need to make changes in recent years, so have recently been a silent DBIC mailing list member. Riba has put in a lot of work over a number of years maintaining and improving DBIx::Class - the level of commitment in this should in no way be understated. However going forward I would prefer to see an amicable move to a maintainer team with an initial core membership as indicated by MST. There needs to remain a focus on ensuring DBIC remains stable and does not eat data. Regards Nigel. -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangible Technologies ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/ dbix-class@lists.scsys.co.uk ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] How to specify the necessary scheme?
On 21/01/2010, at 12:46, konstan...@tokar.ru wrote: Hi, All! How to use the schema description generated Schema::Loader, for the scheme necessary to me? For example, there is class DBIC::EMULATOR::Cruise, I write for the current scheme use DBIC::EMULATOR; my $schema = DBIC::EMULATOR-connect(...); my $record = $schema-resultset('ship')-search()-first (); But if I need to address to tables of other scheme, for example EMULATOR2, EMULATOR3, how it to make? Something like my $record = $schema-resultset(EMULATOR2.ship')-search ()-first(); my $record = $schema-resultset(EMULATOR3.ship')-search ()-first(); You can create separate namespace for each *db schema* you have under your *DBIC schema* one, then you use the qualified table name when you set up the result class: if your DBIC schema is DBIC::EMULATOR, code package DBIC::EMULATOR::EMULATOR1::ship; use parent 'DBIx::Class::Core'; __PACKAGE__-table('EMULATOR1.ship'); [...] package DBIC::EMULATOR::EMULATOR2::ship; use parent 'DBIx::Class::Core'; __PACKAGE__-table('EMULATOR2.ship'); [...] /code thus, when you need to get the resultset for this result class you do: my $emulator1_ship_rs = $schema-resultset('EMULATOR1::ship'); my $emulator2_ship_rs = $schema-resultset('EMULATOR2::ship'); -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] create failures with has_one
On 09/12/2009, at 13:38, Dermot wrote: 2009/10/19 Dermot paik...@googlemail.com: 2009/10/19 Wallace Reis wall...@reis.org.br: On 15/10/2009, at 21:08, Dermot wrote: my $record = { 'validation_pass' = 1, 'files' = [], 'active' = 1, 'name' = 'Gustav MR', 'clipdata' = [ { 'contrib_id' = 2, } ], 'contrib_id' = 2, }; Use a HashRef for clipdata rel instead of a ArrayRef. Here, you should note that currently find (and update) part of *_or_create methods will fail for nested relations, so you need to call find(update)_or_create for relationships separately. Is this still true? At least of 0.08114. Dp. Yes, and that applies to the problem you described in another thread (about dupes). -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Left join with an extra condition
On 24/10/2009, at 11:48, Bill Moseley wrote: Can the virtual view inherit from the user? That is, can I convince DBIC that the object returned is a real user object so I can update the object and have it written to storage? The cookbook just says that the view cannot be operated on. Obviously, it would be much more useful to have a real user object. You can do it if you use a DBMS with RULEs support (like PostgreSQL). Or you can setup a belongs_to rel (where is_foreign_key_constraint = 0) to the user and override qw/insert delete update/ row methods in your view class to do such operations on -referred_user instead of $self, like you would do with RULEs on DBMS. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] create failures with has_one
On 15/10/2009, at 21:08, Dermot wrote: 2009/10/15 Wallace Reis wall...@reis.org.br: On 15/10/2009, at 08:34, Dermot wrote: 2009/10/15 Wallace Reis wall...@reis.org.br: On 14/10/2009, at 13:10, Dermot wrote: my $record = { 'validation_pass' = 1, 'files' = [], 'active' = 1, 'name' = 'Gustav MR', 'clipdata' = [ { 'contrib_id' = 2, } ], 'contrib_id' = 2, }; Use a HashRef for clipdata rel instead of a ArrayRef. Here, you should note that currently find (and update) part of *_or_create methods will fail for nested relations, so you need to call find(update)_or_create for relationships separately. I would really, really love to do a doc patch if I knew how. Mostly because that's all I feel I have the ability to do. However I have no experience of how to create patches. I guess it's a similar to `svn diff ...`. Is there something on the Advent Calendar's or similar that might show me? Not sure, but a svn diff output or a svk ci -P patch is fine. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] create failures with has_one
On 19/10/2009, at 11:59, Dermot wrote: 2009/10/19 Wallace Reis wall...@reis.org.br: On 15/10/2009, at 21:08, Dermot wrote: my $record = { 'validation_pass' = 1, 'files' = [], 'active' = 1, 'name' = 'Gustav MR', 'clipdata' = [ { 'contrib_id' = 2, } ], 'contrib_id' = 2, }; Use a HashRef for clipdata rel instead of a ArrayRef. That might explain why, even under 0.08112, I get DBIx::Class::ResultSet::find_or_create(): new_result needs a hash... when I use a nested structure. Are there any methods I can use that will allow me to create new, nested rows? You can encapsulate it in a resultset method like: sub import_record { my ( $self, $record ) = @_; my ( $files, $clipdata ) = map { delete $record-{$_} } qw/files clipdata/; my $schema = $self-result_source-schema; my $imp_rec; my $import_txn = sub { my $imported_record = $self-update_or_create($record); foreach my $file (@$files) { $imported_record-update_or_create_related('files', $file, { key = 'files_filename' } ); } $imported_record-update_or_create_related('clipdata', $clipdata); return $imported_record; }; eval { $imp_rec = $schema-txn_do($import_txn) }; if ($@) { # Transaction failed die something terrible has happened! # if ($@ =~ /Rollback failed/); # Rollback failed # deal_with_failed_transaction(); } return $imp_rec; } then call $schema-resultset('Submissions')-import_record($record). -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] create failures with has_one
On 15/10/2009, at 08:34, Dermot wrote: 2009/10/15 Wallace Reis wall...@reis.org.br: On 14/10/2009, at 13:10, Dermot wrote: my $record = { 'validation_pass' = 1, 'files' = [], 'active' = 1, 'name' = 'Gustav MR', 'clipdata' = [ { 'contrib_id' = 2, } ], 'contrib_id' = 2, }; Use a HashRef for clipdata rel instead of a ArrayRef. Thanx for the replay. Under ~/Class/ResultSet.pm#create it says use a Arrayref for has_one Example of creating a new row and also creating rows in a related has_many or has_one resultset. Note Arrayref. Patches are welcome! I think my problem was using update_or_create(). I think there are differences between the what create() and what update_or_create() expects. This might explain the Recursive update error I got as well. At the moment I am using find_or_create() and that is working as expected. There is no difference between those APIs, both update_or_create and find_or_create use -create. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Re: Using Storable with DBIx::Class - Can't locate object method result_source_instance
On Wed, Sep 30, 2009 at 1:10 PM, Bill Moseley mose...@hank.org wrote: $VERSION = '0.08111'; Ok, starting simple, what's the correct way to store and retrieve dbic row objects from Storable? Unable to restore schema at ../../lib/Storable.pm (autosplit into ../../lib/auto/Storable/thaw.al) line 415 calling -cds on deserialized object Can't call method source on an undefined value at /usr/local/share/perl/5.10.0/DBIx/Class/R The error message is clever in 0.08112. You need to 'freeze' and 'thaw' your dbic row. Look at DBIC::Schema docs about it. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Filtering with Many-to-Many relationship
On Tue, Sep 22, 2009 at 7:23 AM, Oleg Kostyuk cub.ua...@gmail.com wrote: I think, you just need to join twice with tags table, and this will give you what you want: And if you need products which have 3 or more tags? One join per tag? It is not ideal. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Filtering with Many-to-Many relationship
On Fri, Sep 18, 2009 at 3:06 PM, Shawn Marincas shawngmarin...@gmail.com wrote: I have a table Products and a table Tags with a many_to_many relationship setup, the purpose of which would be to easily generate a resultset of products with the given tag(s). However, I'm running in to problems when I want to generate a resultset of product records filtered with multiple tags. I was thinking that one of the following would work: my $tag1 = 'A'; my $tag2 = 'B'; my $product_rs = $schema-resultset('Product')-search_rs({ 'tag.tag_id' = { -in = [qw/A B/] } }, { join = { 'product_tags' = 'tag' } }); But apparently the many_to_many relationship accessor only returns a list of row_objects rather than a resultset itself, so I can't perform resultset searches on that. So I tried the following to chain together two searches: You've used the -search method in your code in list context, so it calls -all over the resultset and returns a list of row objects. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] different query after upgrade
Actually, never mind what i just said. DBIC is right, it's a proper bugfix. *Generally*, it is not correct to LEFT JOIN one thing then JOIN onwards from it, which clearly is not your case here. Sorry for the wrong spot. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Developer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Relations for multi-class object inflation from one table
On Thu, Jul 23, 2009 at 4:12 PM, Oleg Kostyukcub.ua...@gmail.com wrote: Hello all, I read about Dynamic Sub-classing DBIx::Class proxy classes in DBIx::Class::Manual::Cookbook, and have question. package My::Schema::Result::Company; use base qw/DBIx::Class/; __PACKAGE__-load_components(qw/Core/); __PACKAGE__-table('companies'); __PACKAGE__-add_columns(qw/company_id ../); __PACKAGE__-set_primary_key('company_id'); __PACKAGE__-has_many('admins', 'My::Schema::Result::User::Admin', ); __PACKAGE__-has_many('users', 'My::Schema::Result::User', ); __PACKAGE__-has_many('all_users', 'My::Schema::Result::User', ); My questions is: 1) what should be instead of '' in has_many() calls above? I think, this should be something like this (for first has_many): { 'foreign.company_id' = 'self.company_id', 'foreign.admin' = 1 } - is this correct? You can't define rels using constants in FK definitions like 'foreign.admin' = 1. You have to define just the 'all_users' rel with { 'foreign.company_id' = 'self.company_id' } and create result class methods for 'users' and 'admins' like: sub users_rs { my $self = shift; return $self-all_users_rs({ admin = '0' }); } sub users { my $self = shift; my $rs = $self-users_rs; return wantarray ? $rs-all : $rs; } sub admins_rs { my $self = shift; return $self-all_users_rs({ admin = '1' }); } sub admins { my $self = shift; my $rs = $self-admins_rs; return wantarray ? $rs-all : $rs; } Or you can create a base result class called Person, then Admin and User classes as a views (CREATE VIEW) over Person, thus you can define the rels like: __PACKAGE__-has_many('admins', 'My::Schema::Result::User::Admin', { 'foreign.company_id' = 'self.company_id' }); __PACKAGE__-has_many('users', 'My::Schema::Result::User', { 'foreign.company_id' = 'self.company_id' }); __PACKAGE__-has_many('all_users', 'My::Schema::Result::Person', { 'foreign.company_id' = 'self.company_id' }); 3) do I need write belongs_to(company) in User::Admin too, or only in User will be enough? Just in User should be enough. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Developer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Patch roundup time, again.
On Sun, Oct 5, 2008 at 6:23 PM, Matt S Trout [EMAIL PROTECTED] wrote: Also, can somebody poke at the views branch and get it pulled from trunk so we can merge that please? groditi doesn't have time and I'm not sure I can get to it soon enough. All tests successful. Done. -- wallace reis/wreis ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] Resurrected select for patch
On 9/24/07, Matt S Trout [EMAIL PROTECTED] wrote: (sorry for the top-posting everybody) Can somebody with a pg test rig already set up verify this and commit it please? Done. -- wallace reis/wreis http://wallace.reis.org.br ___ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]