Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Martin J. Evans
On 23/11/2011 20:33, Brendan Byrd wrote: On Wed, Nov 23, 2011 at 9:15 AM, Jens Rehsackwrote: 2011/11/23 Brendan Byrd: Well, I'd actually be using schema as a MIB name. Which is horribly wrong. Tables names like systemGroup are always full qualified. There is no other oid named systemGroup as

Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Brendan Byrd
On Wed, Nov 23, 2011 at 9:15 AM, Jens Rehsack wrote: > > 2011/11/23 Brendan Byrd : > > Well, I'd actually be using schema as a MIB name. > > Which is horribly wrong. Tables names like systemGroup are always > full qualified. There is no other oid named systemGroup as the one > below mib_ii. > You

Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Jens Rehsack
2011/11/23 Tim Bunce : > On Wed, Nov 23, 2011 at 09:34:06AM +0100, Jens Rehsack wrote: >> 2011/11/22 Brendan Byrd : >> > (Adding dbi-dev to conversation for >> > https://rt.cpan.org/Ticket/Display.html?id=72588) >> > >> > Still debugging DBD::SNMP right now, and I'm currently fighting with >> > SQL

Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Tim Bunce
On Wed, Nov 23, 2011 at 09:34:06AM +0100, Jens Rehsack wrote: > 2011/11/22 Brendan Byrd : > > (Adding dbi-dev to conversation for > > https://rt.cpan.org/Ticket/Display.html?id=72588) > > > > Still debugging DBD::SNMP right now, and I'm currently fighting with > > SQL::Statement to allow for schema

Re: Database/DBD Bridging?

2011-11-23 Thread Jens Rehsack
2011/10/4 Reinier Post : > On Fri, Sep 23, 2011 at 11:19:32PM -0400, Brendan Byrd wrote: > >> [...], the Perl community in general needs this.  Developers need to just >> grab some modules via CPAN, describe the relational models (if they don't >> already exist), and have the flow of data *just wor

Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Jens Rehsack
> On Wed, Nov 23, 2011 at 3:34 AM, Jens Rehsack > wrote: >> >> 2011/11/22 Brendan Byrd : >> > (Adding dbi-dev to conversation for >> > https://rt.cpan.org/Ticket/Display.html?id=72588) >> > >> > Still debugging DBD::SNMP right now, and I'm currently fighting with >> > SQL::Statement to allow for s

Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Brendan Byrd
Well, I'd actually be using schema as a MIB name. For example, IF_MIB.ifTable or SNMPv2_MIB.systemGroup. Dashes are converted to underscores, since MIBs don't use underscores and SQL doesn't like dashes. As far as testing, that's why I'd like to add this in as a flag. Testing is still required,

Re: Allowing for schema.table format in SQL::Statement

2011-11-23 Thread Jens Rehsack
2011/11/22 Brendan Byrd : > (Adding dbi-dev to conversation for > https://rt.cpan.org/Ticket/Display.html?id=72588) > > Still debugging DBD::SNMP right now, and I'm currently fighting with > SQL::Statement to allow for schema.table formats. The idea would that it > would be possible to reference th