Yeah that makes way more sense. I found kind of what you were looking
for on the sqlobject mailing list after trying some other things I had
thought of. I don't know how to get the tables names but this will
help after that. It should make all your table classes in a list. So
that tableClasses[0] will be an SQLObject class(not an instance):
def getTableNames():
#not quite sure what to put here but I'll just assume
return ['table1', 'table2', 'table3']
def getTableClasses(tableNames):
tableClasses = []
for tableName in tableNames:
tableClasses.append(makeTable(tableName))
return tableClasses
def makeTable(name):
""" Copied from here
http://article.gmane.org/gmane.comp.python.sqlobject/7719
"""
class Test(SQLObject):
class sqlmeta:
table = name
def __classinit__(cls, new_attrs):
cls.__name__ = name
SQLObject.__classinit__(cls, new_attrs)
return Test
Do you know the table names you need to get classes for at run time ?
-Ian
On 1/26/07, Lee Connell <[EMAIL PROTECTED]> wrote:
> Not a problem, I didn't take it as criticism. The tables currently exist in
> the database, but at anytime a new table can be added to the database that
> contains the same structure as all the other tables im interested in here.
>
> The existing application is a syslog application that pulls data from SNMP
> and fills these tables with data. At anytime it can create a new table
> based on new SNMP captures, meaning new a new client comes on board.
>
> I am building a script that queries every single table in the database and
> grabs information based on a specific SNMP level, in my case anything
> "critical" within the last couple hours, grab it and send an email alert to
> a specific recipient.
>
> I want to loop through each table, make the necessary queries and send an
> email based on the results.
>
> I was hoping, to make it easier i could query the database and grab all the
> tables and make classes out of them during runtime.
>
> Does this make sense?
>
>
> On 1/26/07, Ian Wilson <[EMAIL PROTECTED]> wrote:
> >
> > Sorry earlier I wasn't critisizing your design I know how it is to try
> > and match other system designs. It sucks. But I am kind of confused
> > still on what actually needs to happen. Do the tables exist in the
> > database and you just need matching sqlobject classes? Or do you need
> > both to create the tables in the database and get a representative
> > sqlobject class ?
> >
> > -Ian
> >
> > On 1/25/07, Lee Connell < [EMAIL PROTECTED]> wrote:
> > >
> > > Hi,
> > >
> > > The reason I am doing this is because I have multiple tables in my
> database
> > > that have all the same fields and I want to be able to add tables to my
> > > script at anytime. These tables hold information about new clients.
> The DB
> > > design was not mine and it's how it works for a syslog application we
> are
> > > using.
> > >
> > > I want to be able to run through all of these tables and query
> information
> > > and send emails based on the data pulled. Since each table is going to
> be
> > > accessed the same way I just want to loop through each table/sqlobject
> > > class, query data and send an email.
> > >
> > > Is there an easier way to do this?
> > >
> > > -----Original Message-----
> > > From: [email protected] [mailto:[EMAIL PROTECTED]
> On
> > > Behalf Of Ian Wilson
> > > Sent: Thursday, January 25, 2007 8:18 PM
> > > To: [email protected]
> > > Subject: [TurboGears] Re: help with sqlobject classes at runtime
> > >
> > >
> > > I am confused on why or what you are doing but try this:
> > >
> > > Set the default to empty for level 2 and you won't get that error:
> > >
> > > level2 = StringCol(default='')
> > >
> > >
> > >
> > > On 1/25/07, Lee Connell <[EMAIL PROTECTED]> wrote:
> > > >
> > > > /// ERROR (if I don't override __init__ in my sqlobject class)///
> > > >
> /////////////////////////////////////////////////////////////////
> > > > c = help.classFromModule('__main__', 'SyslogPoll2')()
> > > > File
> > > >
> > > "C:\Python24\lib\site-packages\sqlobject-
> 0.7.2-py2.4.egg\sqlobject\declarati
> > > > ve.py", line 93, in _wrapper
> > > > return fn(self, *args, **kwargs)
> > > > File
> > > >
> > >
> "C:\Python24\lib\site-packages\sqlobject-0.7.2-py2.4.egg\sqlobject\main.py
> ",
> > > > line 1203, in __init__
> > > > self._create(id, **kw)
> > > > File
> > > >
> > >
> "C:\Python24\lib\site-packages\sqlobject-0.7.2-py2.4.egg\sqlobject\main.py",
> > > > line 1222, in _create
> > > > raise TypeError, "%s() did not get expected keyword argument %s" %
> > > > (self.__class__.__name__, column.name)
> > > > TypeError: SyslogPoll2() did not get expected keyword argument level2
> > > >
> > > >
> > > >
> > > > /// Calling Code ///
> > > > ////////////////////
> > > > class SyslogPoll2(SQLObject):
> > > > class sqlmeta:
> > > > table = "SyslogPoll"
> > > >
> > > > level2 = StringCol()
> > > >
> > > > help = DBHelper()
> > > > c = help.classFromModule('__main__', 'SyslogPoll2')()
> > > >
> > > >
> > > >
> > > > /// Helper Code ///
> > > > ///////////////////
> > > > class DBHelper:
> > > > def classFromModule (self, module, className):
> > > > mod = __import__ (module)
> > > > return getattr (mod, className)
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: [email protected] [mailto:
> [EMAIL PROTECTED] On
> > > > Behalf Of Patrick Lewis
> > > > Sent: Tuesday, January 23, 2007 12:58 AM
> > > > To: TurboGears
> > > > Subject: [TurboGears] Re: help with sqlobject classes at runtime
> > > >
> > > >
> > > > Not quite sure what the real problem you are facing is, but if all you
> > > > want to do is call the 'send' method without instantiating your class,
> > > > can you use the @staticmethod (or perhaps @classmethod) decorator?
> > > > e.g.
> > > >
> > > > class SyslogPoll2(SQLObject):
> > > >
> > > > @staticmethod
> > > > def send(data):
> > > > print data
> > > >
> > > > I don't think you want to be overriding sqlobject's __init__
> > > >
> (http://www.sqlobject.org/SQLObject.html#initializing-the-objects),
> > > > apparently that is Very Bad.
> > > >
> > > > If you want to do some introspection of the class to know what the
> > > > class needs to initialize, you should be able to get everything you
> > > > need out of SyslogPoll2.sqlmeta.columns attribute.
> > > >
> > > >
> > > >
> > > > --
> > > > No virus found in this incoming message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.5.432 / Virus Database: 268.17.8/648 - Release Date:
> 1/23/2007
> > > > 11:04 AM
> > > >
> > > >
> > > > --
> > > > No virus found in this outgoing message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.5.432 / Virus Database: 268.17.11/652 - Release Date:
> 1/25/2007
> > > > 3:32 PM
> > > >
> > > >
> > > >
> > > > >
> > > >
> > >
> > >
> > > --
> > > No virus found in this incoming message.
> > > Checked by AVG Free Edition.
> > > Version: 7.5.432 / Virus Database: 268.17.11/652 - Release Date:
> 1/25/2007
> > > 3:32 PM
> > >
> > >
> > > --
> > > No virus found in this outgoing message.
> > > Checked by AVG Free Edition.
> > > Version: 7.5.432 / Virus Database: 268.17.11/652 - Release Date:
> 1/25/2007
> > > 3:32 PM
> > >
> > >
> > >
> > > >
> > >
> >
> >
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
