[Dbix-class] Re: Presentation about DBIx::Class

and a ResultSet was puzzling. Especially when using D:C:Loader, as depending on the command line arguments, there may not be a Result directory, and there certainly won't be a ResultSet directory. The very fact that you don't have to have a ResultSet directory is a good tidbit! Good Luck! Steve

[Dbix-class] Insert into join table succeeds but issues error anyway

(`role_id`) REFERENCES `roles` (`id`)) [for Statement "INSERT INTO users_roles ( role_id, user_id) VALUES ( ?, ? )" with ParamValues: 0='HASH(0xb57f080)', 1='66'] at /home/steve/Catalyst/WebStmt/script/../lib/FSUstmt/Controller/WebUsers.pm line 109 The interesting thing is that even though

[Dbix-class] Re: Insert into join table succeeds but issues error anyway

opics: 1. Insert into join table succeeds but issues error anyway (Steve) 2. Result Classes (Ben Hitz) 3. Jobs, jobs, jobs, and jobs (don't forget about jobs!) (fREW Schmidt) 4. can i add custom error info for throw_exception in dbix::class 0.07006? (??) 5. Re: can i a

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

relationships are being used successfully in the schema. Any clue as to why this relationship is not created? Thanks as always, Steve ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http

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

On 8/4/2010 10:46 AM, fREW Schmidt wrote: On Wed, Aug 4, 2010 at 7:34 AM, Steve st...@matsch.com mailto:st...@matsch.com wrote: Hi all, I am bewildered as to why my 'many_to_many' relationship is being ignored. I get an error when trying to use

Re: [Dbix-class] Chained resultsets and WHERE operators

It appears that you are *not* chaining these resultsets... If you first do... # Narrow the search down if the start date is supplied. $date_ranges = $rs-search({ start_date = { '=', $start_date }, end_date = { '=', $start_date }, }) if $start_date; then in order to 'chain' you must...

[Dbix-class] Relationship question/database structure

, etc. I am sure that this is a fairly common use case, but don't see much in the docs or on the list. The question is two-fold: What's the best structure, and how do we go about defining the DBIC rels? Thanks, Steve ___ List: http://lists.scsys.co.uk

Re: [Dbix-class] Relationship question/database structure

of changes...) David On Mon, Jan 10, 2011 at 1:18 PM, Steve st...@matsch.com mailto:st...@matsch.com wrote: I was unclear... sorry for that. The current 'note' table has two columns: 'TableName' and 'TableId', where the 'TableName' field is an abbreviation for the name

Re: [Dbix-class] Multiple DBs, one Schema to rule them all

I second that thought. I was advised to do it this way from some experienced Catalyst-ers. On 2/28/2011 12:01 PM, Wes Cravens wrote: On 2/11/2011 7:20 PM, Trevor Leffler wrote: Hello, I am investigating whether DBIC has support for switching between logical databases (ala 'use db1; ...; use

Re: [Dbix-class] Looking for a DBIC developer for new SaaS product

your requirements and the project to see whether I could be of help. Feel free to call my cell if you'd like to discuss this further. Steve Steve Schafer Matsch Systems Phone: 616-477-9629 Mobile: 616-304-9440 Email: st...@matsch.com Web: http://www.matsch.com/ On 7/28/2011 11:42 PM, Al

[Dbix-class] set_on_create problem

, Steve ___ 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

Out of office 10/4-10/5 (was: [Dbix-class] Caching total_entires in the Pager -- how can build a good cache key?)

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: [Dbix-class] Caching total_entires in the Pager -- how can build a good cache key?))

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: [Dbix-class] Caching total_entires in the Pager -- how can build a good cache key?)))

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: [Dbix-class] Caching total_entires in the Pager -- how can build a good cache ke

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: [Dbix-class] Caching total_entires in the Pager --

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: [Dbix-class] Caching

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-1

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-1

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-1

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-1

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-1

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-10/5 (was: Out of office 10/4-1

Thank you for your email. I will be out of the office Thursday and Friday, returning Monday the 8th. I will respond to your email at that time. Please call our office for any immediate concerns: 616-459-0782. -- Steve

Re: [Dbix-class] DBIx-Class Digest, Vol 176, Issue 1

If you use the convention: my $value = $row->colABC, then you'll get the inflated value, provided the column is defined as an object.  If you want the raw value, ask for $row->get_column('colABC'). On 12/9/2022 7:00 AM, dbix-class-requ...@lists.scsys.co.uk wrote: Send DBIx-Class mailing list

[Dbix-class] DBIx::Class creating get_* and set_* methods

on their functionality). # Accessor method $object-get_username; # mutator method $object-set_username('bob'); Has anyone done anything for this for DBIx::Class? Sincerely, Steve K ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix

[Dbix-class] Oracle Column Quoting

: SELECT 'me.level' FROM test me; The problem is that DBIx::Class does not do the single quoting by default and the single-quoting behavior, I don't believe, does not work for all databases. Does anyone have suggestions about how this problem could be addressed? Steve Kirkup

[Dbix-class] Dynamically removing an auto-increment column

used? Regards, Steve ___ 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] Dynamically removing an auto-increment column

Peter Rabbitson wrote: Steve Bertrand wrote: For MySQL, I have to have the 'id' field populated with a null value when calling create() Why? Please explain. Well, I can explain that I've been at this for hours on end, and when I went to dig up the code so I could explain, I realized that I

Re: [Dbix-class] Dynamically removing an auto-increment column

Dermot wrote: 2009/12/8 Steve Bertrand st...@ibctech.ca: Hi everyone, Hi Steve, I've just began using DBIx::Class late last week. Although I've got it doing pretty well everything I want, I'm quite overwhelmed by the amount of documentation, and hence, I'm having a hard time locating

Re: [Dbix-class] Dynamically removing an auto-increment column

Peter Rabbitson wrote: Steve Bertrand wrote: (Un)fortunately, this was a case of reading from a stale replicated MySQL server... Are you doing the reading manually or are you using the Replicated storage driver? If the former - take a look at Replicated. If the later - make sure you wrap

[Dbix-class] Issue converting select/insert from DBI to DBIx::Class

/ username nasipaddress / ], as = [ 'daily' ], }); Steve ___ 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

Re: [Dbix-class] Issue converting select/insert from DBI to DBIx::Class

::HashRefInflator' ); my $agg_table = $schema-resultset( 'DailyAgg' ); while ( my $daily_entry = $daily_fetch_rs-next() ) { $daily_entry-{ AcctDate } = $day; $agg_table-create( $daily_entry ); } Does that help? Yep! Thanks ;) Steve

[Dbix-class] Weird INSERT RETURNING error after updating to DBIx::Class .08123

out how to do that. Anyone else experienced this? Thanks in advance. -steve kleiman ___ 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

Re: [Dbix-class] multiple database connection

using $c-model('*DB*::Table')-... and the other using $c-model('*RadiusDB*::OtherTable')-... Don't know if this is the best way, but it's what I use?!! -- Steve Rippl Technology Director Woodland Public Schools 360 841 2730 ___ List: http

[Dbix-class] Join Myself?

' }, { is_deferrable = 1, join_type = LEFT, } ); I'm either missing something obvious or this can't be done (yet) and I should just use SQL to make the request. I guess I just want to know either way. TIA, -- STEVE - ___ List: http

[Dbix-class] Re: Join Myself?

On Fri, Jul 6, 2012 at 11:33 AM, Steve Wells we...@cedarnet.org wrote: I'm trying to convert this SQL statement to DBIC and I'm failing miserably. Let me clarify a bit… Given this setup: http://stackoverflow.com/questions/1313120/retrieving-the-last-record-in-each-group it is possible

[Dbix-class] New many-to-many warnings

but I suppose that's what the warning is telling me? Is it OK to just set DBIC_OVERWRITE_HELPER_METHODS_OK to true? Thanks, Steve -- Steve Rippl Technology Director Woodland Public Schools 360 841 2730 ___ List: http://lists.scsys.co.uk/cgi-bin

[Dbix-class] Re: New many-to-many warnings

OK, my bad! I had previously manually defined many-to-many relations for a couple of the tables and now they're being autogenerated with the same names. Sorry! On Thu, Dec 6, 2012 at 8:17 PM, Rippl, Steve rip...@woodlandschools.orgwrote: Hi, I have a Catalyst app using DBIx::Class and just

[Dbix-class] Generating DISTINCT ON with sub query

BY grade.id, course.name, section.name ) AS foo Can I generate that in dbic? Thanks, Steve -- Steve Rippl Technology Director Woodland Public Schools 360 841 2730 ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix

Re: [Dbix-class] Generating DISTINCT ON with sub query

On Wed, Apr 3, 2013 at 2:46 AM, Peter Rabbitson rabbit+d...@rabbit.uswrote: On Tue, Apr 02, 2013 at 08:20:34PM -0700, Rippl, Steve wrote: I have something like the following $self-search( $search, { join = [ { 'course

Re: [Dbix-class] Generating DISTINCT ON with sub query

On Wed, Apr 3, 2013 at 8:55 AM, Peter Rabbitson rabbit+d...@rabbit.uswrote: On Wed, Apr 03, 2013 at 08:41:05AM -0700, Rippl, Steve wrote: Have I given you enough info? I think so but I want to make sure I got it right. Tell me if the thing below is correct: $course_section_rs-search