[SQLObject] Same SQLObject class, different columns.

[<mic...@ya...>]

Hi guys!

I having a problem I don´t know how to solve. I have tow different
sites (made in webware) and hava two different modules to access two
different database.

The first site database was designed using the SQLObject´s createTable
method. I have one table called cidade and another one called estado.
The second site database was designed to another person, the database
name convention is too strange. The cidade id is not called id or
cidade_id, it is called cidaauct. So I need to specify each column´s
name.

The problem is that the webware are caching the Cidade class (I think),
I have put a _cacheValues=False on the class without sucess (I put in
all class), so I think the focus is the webware. If I acess the second
site first and then the first site there is no problem, but if I try to
access the first and then the second, the column estado_id is not
found, i think when the sqlobject is trying to make the join.

How can I specify to webware (if the problem is with webware), that
Site1.Database1.Estado is not equal Site2.Database2.Estado, or anything
like this?

Does anyone have such problem?

thanks for the attention, I will list the two classes code follow:

File: Site1.Database1
...
__CONNECTION__='mysql://...'

class Cidade(SQLObject):
  _connection=__CONNECTION__
  _cacheValues=False
  nome=StringCol(length=50)
  estado=ForeignKey('Estado')

class Estado(SQLObject):
  _connection=__CONNECTION__
  _cacheValues=False
  nome=StringCol(length=50)
  sigla=StringCol(length=2, alternateID=True)
  cidades=MultipleJoin('Cidade')
...

File: Site2.Database2
...
CONNECTION='mysql://...'

class Cidade(SQLObject):
  _connection=CONNECTION
  _idName='codicida'
  _cacheValues=False
  nome=StringCol(dbName='desccida')
  estado=ForeignKey('Estado', dbName='codiesta')

class Estado(SQLObject):
  _connection=CONNECTION
  _idName='codiesta'
  _cacheValues=False
  nome=StringCol(dbName='descesta')
  sigla=StringCol(dbName='siglesta', length=2, alternateID=True)
  cidades=MultipleJoin('Cidade')
...

=====
--
Michel Thadeu Sabchuk
Curitiba/PR

______________________________________________________________________

Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/