dpgaspar / flask-appbuilder-site Goto Github PK

The swagger documentation for the site is not showing up correct results. We would like to use this demo to showcase what the flask-appbuilder is capable of. Would love to have this issue resolved.

Link to the site:
http://flaskappbuilder.pythonanywhere.com/

Screenshot:

Hi,

I am new to flask/flask-appbuilder and sqlalchemy.

I was looking at the employee sample and wanted to try implementing an employee log (clock-in time, comment) .

I want it so the logs can be displayed in the Department view as well as the employee view.
(view all logs for department ABC, view all logs for employee XYZ)

I don't want to use related_views.
I want the logs displayed in the regular listview. Without having to click on show for the show view.

eg: Department View
Department

department name here

Logs

department logs here

eg: Employee View
Employee

employee Name Here

Logs

employee logs here

How should you write the model for department, employee, and log. I'm not sure how to do the relationship part. I am a little inexperienced with using secondary, backref and primaryjoin.

How should you write the view ?

Heres a little code so you can look at what I'm doing

class Log(Model):
id = Column(Integer, primary_key=True)
department_id = Column(Integer, ForeignKey('department.id'), nullable=False)
department = relationship("Department")
employee_id = Column(Integer, ForeignKey("employee.id"), nullable=False)
employee = relationship("Employee")
comment = Column(String, default='OK', nullable=False)
date = Column(DateTime, default=func.now(), nullable=True)

class Department(Model):
id = Column(Integer, primary_key=True)
name = Column(String, unique = True, nullable=False)
def repr(self):
return self.name

class Employee(Model):
id = Column(Integer, primary_key=True)
name = Column(String, unique=True, nullable=False)
department_id = Column(Integer, ForeignKey('department.id'), nullable=False)
department = relationship("Department")

Any help is appreciated.