Hi,
I have two classes:
```python
class PlayerPro(MESA_BASE):
''' player_pro model '''
__tablename__ = "player_pro"
# Primary Keys
ebis_id = Column(MEDIUMINT(9), primary_key=True)
bam_id = Column(MEDIUMINT(9), index=True)
phil_id = Column(MEDIUMINT(9), index=True)
class EvalProHit(PHIL_DATA_BASE):
''' Eval Pro Hit model '''
__tablename__ = "eval_pro_hit"
def list_id_default(self): # pylint: disable=no-self-use
return uuid.uuid4().hex
# Keys
eval_id = Column(VARCHAR(255), primary_key=True, default=list_id_default)
phil_id = Column(MEDIUMINT(9), nullable=False)
ForeignKeyConstraint([phil_id],
[PlayerPro.phil_id],
onupdate="CASCADE")
```
There in two different databases. When I go to create the tables the create
statement is incorrect:
```sql
INFO:sqlalchemy.engine.base.Engine:
CREATE TABLE eval_pro_hit (
eval_id VARCHAR(255) NOT NULL,
phil_id MEDIUMINT(9) NOT NULL,
FOREIGN KEY(phil_id) REFERENCES player_pro (phil_id) ON UPDATE CASCADE
)
```
Should be mesa.player_pro instead of player_pro. This is occuring from
PHIL_DATA_BASE.metadata.create_all() . How can I accomplish this with
models?
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
