On Thu, Apr 24, 2008 at 4:15 AM, aka <[EMAIL PROTECTED]> wrote:
>
> Hi Jorge,
> I'm using SO with MySQL.
> I could get around it by using
> "SHOW COLUMNS FROM Rol LIKE '%s'" % (column)
> and stripping obsolete characters but there should be possibly more
> efficient ways to do it.
> What I saw on the MySQL site was this code:
>
oh I see, I got very little experience reflecting data from already
existing dbs in SO. So I got no optimal solution for you sorry. But
from what I can tell your solution seems to fix the issue.
Now I got one question for you can you migrate to SA? it's really
great at loading already exisiting dbs, while this is one of the most
dificult tasks with SO.
> def EnumValues(dbh, column):
> dbh.execute("SHOW COLUMNS FROM pages LIKE '%s'" % (column,))
> column_definition = dbh.fetchone()
> values = re.findall("'(.+?)'", column_definition['Type'])
> return values
>
> with MySQLdb.cursors.DictCursor used as the connection's cursorclass
> (and dbh as a cursor object for that connection), but I can't get that
> cursor right.
> Another one is: how can you update an ENUM list?
>
> On 24 apr, 02:02, "Jorge Vargas" <[EMAIL PROTECTED]> wrote:
>
> > On Wed, Apr 23, 2008 at 8:09 AM, aka <[EMAIL PROTECTED]> wrote:
> >
> > > Hi, can somebody tell me how to retrieve ENUM values from MySQL db in
> > > TurboGears?
> >
> > is this SA or SA? are you reflecting an existing table?
> >
> > here is a pointer for
> SAhttp://www.sqlalchemy.org/docs/04/sqlalchemy_databases_mysql.html#doc...
>
> > I'm not entirely sure of there is a cross-db for getting those as they
> > are not implemented in all db-engines.
> >
> >
> >
> > > Cheers- Tekst uit oorspronkelijk bericht niet weergeven -
> >
> > - Tekst uit oorspronkelijk bericht weergeven -
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
