Re: [SQLObject] gettin column type information
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: jonhattan <jon...@op...> - 2007-09-17 07:22:54
|
I do something similar with a snippet like this: for column in Webuser.sqlmeta.columnList: name = column.name columnDef = column.columnDef.__class__ if columnDef == col.StringCol: ... elif columnDef == col.IntCol: ... ... cm...@gm... escribió: > Hi, > need help we a maybe newbie question. > i'm using cherrypy and sqlobject to write a litte program. > actually i'm implementing the search pages and i would like to use > automatically the startswith option every time the column type is > "String". > i will pass 1...n parameters and the i evaluate and split them into > column-name and search value. > i have the column-name and need to know the filed type of this column > > here my "working" example where i'm actually checking the name instead > of the column type. > > thx mike > > [...] > class Webuser(SQLObject): > _connection = myconn > username = StringCol(length = 15) > group = IntCol() > > [....] > def mysearchresult(self, **kwargs): > if len(kwargs) > 0: > evalList = [] > for kw in kwargs.items(): > #assemble all criteria into a bigstring > #to be evaluated > key, val = kw > if key == "username": > evalList.append('Webuser.q.%s.startswith("%s")' > % (key, val)) > else: > evalList.append('Webuser.q.%s=="%s"' % > (key, val)) > > if len(kwargs) == 1: > critString = ''.join(evalList) > evalString = 'Webuser.select(%s)' % > (critString) > mywebusers = eval(evalString) > else: > critString = ' , '.join(evalList) > evalString = 'Webuser.select(AND(%s))' > % (critString) > mywebusers = eval(evalString) > else: > mywebusers = Webuser.select() > > template = Template(''' > [..] > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > > |