i already spent 3 days trying to map one stupid mysql view and i cant get
it to work.
in the python interpreter it works...
Python 2.7.5 (default, May 31 2018, 09:45:54)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-28)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> SQLALCHEMY_DATABASE_URI =
'mysql://aix_reg:blalblabla@localhost/aix_registry'
>>> from flask import Flask, request
>>> from flask_sqlalchemy import SQLAlchemy
>>> from sqlalchemy import String, Enum, create_engine, MetaData, Table,
Column, Integer
>>> from sqlalchemy.orm import sessionmaker
>>> from sqlalchemy.ext.declarative import declarative_base
>>> from flask_admin.contrib import sqla
>>> from flask_admin import Admin, expose, BaseView
>>> from flask_admin.contrib.sqla import ModelView
>>> from flask_admin.model.template import EndpointLinkRowAction,
LinkRowAction
>>> Base = declarative_base()
>>> engine = create_engine(SQLALCHEMY_DATABASE_URI)
>>> metadata = MetaData(bind=engine)
>>> Base.metadata = metadata
>>> metadata.reflect(views=True, autoload=True)
>>> WebView = metadata.tables['web_view']
>>> WebView
Table('web_view',
MetaData(bind=Engine(mysql://aix_reg:***@localhost/aix_registry)),
Column('NODE_ID', INTEGER(display_width=11), table=<web_view>,
server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x3fff7aace890>, for_update=False)), Column('NODE', VARCHAR(length=256),
table=<web_view>), Column('LOCATION', VARCHAR(length=256),
table=<web_view>), Column('IS_CLUSTER', VARCHAR(length=256),
table=<web_view>), Column('MAN_SYS_NAME', VARCHAR(length=256),
table=<web_view>), Column('HAS_CICS', VARCHAR(length=256),
table=<web_view>), Column('OS_LEVEL', VARCHAR(length=256),
table=<web_view>), Column('HAS_COBOL', VARCHAR(length=256),
table=<web_view>), Column('HAS_ORACLE', VARCHAR(length=256),
table=<web_view>), Column('MEM_VALUE', VARCHAR(length=256),
table=<web_view>), Column('HAS_TUXEDO', VARCHAR(length=256),
table=<web_view>), Column('STORAGE_VALUE', VARCHAR(length=256),
table=<web_view>), Column('IS_LPM', VARCHAR(length=256), table=<web_view>),
Column('HAS_SAP', VARCHAR(length=256), table=<web_view>),
Column('CPU_VALUE', VARCHAR(length=256), table=<web_view>),
Column('CLUSTER_RGS', VARCHAR(length=256), table=<web_view>),
Column('HA_LEVEL', VARCHAR(length=256), table=<web_view>),
Column('CLUSTER_NODES', VARCHAR(length=256), table=<web_view>),
Column('CLUSTER_NAME', VARCHAR(length=256), table=<web_view>),
Column('CPU_POOL', VARCHAR(length=256), table=<web_view>),
Column('AME_FACTOR', VARCHAR(length=256), table=<web_view>),
Column('SYS_PROFILE', VARCHAR(length=256), table=<web_view>),
Column('INFO_MAIL', VARCHAR(length=256), table=<web_view>),
Column('HOSTNAME', VARCHAR(length=256), table=<web_view>),
Column('OS_TYPE', VARCHAR(length=256), table=<web_view>),
Column('Java6_64', VARCHAR(length=256), table=<web_view>),
Column('Java7_64', VARCHAR(length=256), table=<web_view>),
Column('Java8_64', VARCHAR(length=256), table=<web_view>),
Column('Java5_64', VARCHAR(length=256), table=<web_view>), Column('Java8',
VARCHAR(length=256), table=<web_view>), Column('Java5',
VARCHAR(length=256), table=<web_view>), Column('Java14',
VARCHAR(length=256), table=<web_view>), Column('Java7',
VARCHAR(length=256), table=<web_view>), Column('Java71',
VARCHAR(length=256), table=<web_view>), Column('Java71_64',
VARCHAR(length=256), table=<web_view>), Column('Java14_64',
VARCHAR(length=256), table=<web_view>), Column('Java6',
VARCHAR(length=256), table=<web_view>), Column('UPTIME',
VARCHAR(length=256), table=<web_view>), Column('IP', VARCHAR(length=256),
table=<web_view>), Column('IP_LONG', VARCHAR(length=256),
table=<web_view>), Column('CLUSTER_NODENAME', VARCHAR(length=256),
table=<web_view>), Column('RG_SERVICE_IP_LONG', VARCHAR(length=256),
table=<web_view>), Column('HAS_SNA', VARCHAR(length=256),
table=<web_view>), schema=None)
but in the flask app no way
Base = declarative_base()
engine = create_engine(app.config.get('SQLALCHEMY_DATABASE_URI'))
metadata = MetaData(bind=engine)
Base.metadata = metadata
metadata.reflect(views=True, autoload=True)
Nodes = metadata.tables['nodes']
Attributes = metadata.tables['attribs']
Entries = metadata.tables['entries']
WebView = metadata.tables['web_view']
session = sessionmaker(bind=engine)
admin = Admin(app, name='AIX Registry', template_mode='bootstrap3')
admin.add_view(AixAdmin(Nodes, session, 'Overview'))
root@lpgaixmgmtlx01:/root/flask/aix_registry>python run.py
Traceback (most recent call last):
File "run.py", line 3, in <module>
from app import app
File "/root/flask/aix_registry/app/__init__.py", line 18, in <module>
from app import views
File "/root/flask/aix_registry/app/views.py", line 55, in <module>
admin.add_view(AixAdmin(Nodes, session, 'Overview'))
File "/usr/lib/python2.7/site-packages/flask_admin/contrib/sqla/view.py",
line 329, in __init__
menu_icon_value=menu_icon_value)
File "/usr/lib/python2.7/site-packages/flask_admin/model/base.py", line
812, in __init__
menu_icon_value=menu_icon_value)
File "/usr/lib/python2.7/site-packages/flask_admin/base.py", line 192, in
__init__
self.endpoint = self._get_endpoint(endpoint)
File "/usr/lib/python2.7/site-packages/flask_admin/model/base.py", line
825, in _get_endpoint
return self.model.__name__.lower()
AttributeError: 'Table' object has no attribute '__name__'
so how can i do this highly frustrating task correctly?
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
