> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bhuwanpandey.com.np/llms.txt
> Use this file to discover all available pages before exploring further.
# Custom Views
## Working with Custom Views
### BaseView
To add custom views to the Admin interface where you want to access database and SQLAlchemy models, you can use the `BaseView`.
Here' an example
```python theme={null}
from sqlalchemy import Column, Integer, String, select, func
from sqlalchemy.orm import sessionmaker, declarative_base
from fastdaisy_admin import Admin, BaseView, expose
from starlette.applications import Starlette
Base = declarative_base()
engine = create_engine(
"sqlite:///example.db",
connect_args={"check_same_thread": False},
)
Session = sessionmaker(bind=engine)
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True)
name = Column(String(length=16))
Base.metadata.create_all(engine) # Create tables
secret_key = "secret_key"
app = Starlette()
admin = Admin(app=app, secret_key=secret_key, engine=engine)
class ReportView(BaseView):
name = "Report Page"
icon = "fa-solid fa-chart-line"
@expose("/report", methods=["GET"])
async def report_page(self, request):
with Session(expire_on_commit=False) as session:
stmt = select(func.count(User.id))
result = session.execute(stmt)
users_count = result.scalar_one()
return await self.templates.TemplateResponse(
request,
"report.html",
context={"users_count": users_count, 'model_view':self},
)
admin.add_view(ReportView)
```
you can create `report.html` inside `templates` directory with the following content
```html theme={null}
{% extends "fastdaisy_admin/layout.html" %}
{% block head %}
{{ admin.title }} - Report
{% endblock %}
{% block breadcrumbs %}
{% endblock %}
```
If you want to use a custom `templates` directory name, you can change that with:
```python theme={null}
from fastdaisy_admin import Admin
admin = Admin(templates_dir="my_templates", ...)
```
Now visiting /admin/report you can render your report.html file.
### ModelView
You can also add extra endpoint in modelview with the help of `expose` decorator. The path is in this case prepended with the view's identity.
i.e `/admin/user/profile/{pk}`
```python {5,14-16} theme={null}
from markupsafe import Markup
from fastdaisy_admin import ModelView, expose
class UserView(ModelView):
column_list = [User.id, User.name, "detail"]
@expose("/profile/{pk}", methods=["GET"])
async def profile(self, request):
user: User = await self.get_object_for_edit(request)
return await self.templates.TemplateResponse(
request, "user.html", {"user": user, "model_view":self}
)
def detail(self,obj):
url = f'profile/{obj.id}'
return Markup(f'📝')
admin.add_view(UserView)
```
In the above example, By adding `detail` method in column\_list will display link that lead to custom view. Keep in the mind that, method must contain
one argument, in our case is `user object`.
`user.html` inside `templates` directory contains
```html theme={null}
{% extends "fastdaisy_admin/layout.html" %}
{% block head %}
{{ admin.title }} - Profile
{% endblock %}
{% block breadcrumbs %}