_table_= Table('catalogue', tadata,autoload=True,autoload_with=engine)Ĭonsole Output 12:34:08,809:INFO:flask_appbuilder.api:Registering route /api/v1/menu/ įile '/home/konrad/projekte/hito/database-frontend/venv/bin/flask', line 8, in įile '/home/konrad/projekte/hito/database-frontend/venv/lib/python3.8/site-packages/flask/cli.py', line 967, in mainĬli.main(args=sys.argv, prog_name='python -m flask' if as_module else None)įile '/home/konrad/projekte/hito/database-frontend/venv/lib/python3.8/site-packages/flask/cli.py', line 586, in main Uri VARCHAR(229) GENERATED ALWAYS AS ('' || suffix) STOREDĬode from sqlalchemy import create_engineĮngine = create_engine(config.SQLALCHEMY_DATABASE_URI) How can I get autoloading to work for this the catalogue table? The table has 4 columns and it works fine if I specify them manually using the model but it fails with autoload using the flask_appbuilder Base object. Flask-AppBuilder however seems to miss them, as it throws AttributeError: 'tuple' object has no attribute 'columns'. creates the user tables and I can login.I have a class 'catalogue' in my database with multiple columns. I know that the database connection works because F.A.B. I use Python 3.8.5 with Flask 1.1.2 with a PostgreSQL database. However when I start the application, I get 'No records found'. There is a view for it in views.py: class SoftwareProductView(ModelView):ĭatamodel = SQLAInterface(SoftwareProduct) If there is and that is missing, please tell me. I assume that it automatically links the class 'SoftwareProduct' to the table 'softwareproduct', because I don't see any option to manually link it. The table 'softwareproduct' exists in the database and has several entries. Label = Column(String(200), nullable=False) Suffix = Column(String(200), primary_key=True) Following the documentation on Model Views, I constructed the following model in models.py: class SoftwareProduct(Model):

Flask app builder no such column