Some templating for streamlit and sqlalchemy
Project description
Streamlit SQLAlchemy Integration
Overview
streamlit_sqlalchemy
is a Python module that provides seamless integration between Streamlit and SQLAlchemy models. It simplifies the process of creating, updating, and deleting database objects through Streamlit's user-friendly interface.
Features
- Easy Initialization: Initialize the SQLAlchemy engine with a simple method call.
- CRUD Operations: Create, read, update, and delete operations are streamlined with minimal code.
- Dynamic Forms: Automatically generate forms for creating and updating database objects.
- Tabbed Interface: Organize CRUD operations in a tabbed interface for better user experience.
- Foreign Key Support: Easily handle foreign key relationships in forms.
Installation
pip install streamlit_sqlalchemy
Usage
-
Initialize the Engine:
from streamlit_sqlalchemy import StreamlitAlchemyMixin # Create your SQLAlchemy model class YourModel(Base, StreamlitAlchemyMixin): __tablename__ = "your_model" id = Column(Integer, primary_key=True) # Other fields # Initialize the engine StreamlitAlchemyMixin.st_initialize(engine)
-
CRUD Tabs:
YourModel.st_crud_tabs()
-
Customization:
Customize the behavior by overriding methods in your model.
class CustomModel(YourModel): # Override methods as needed
Simple Example
import streamlit as st
from sqlalchemy import create_engine, Column, String, Integer
from sqlalchemy.ext.declarative import declarative_base
from streamlit_sqlalchemy import StreamlitAlchemyMixin
Base = declarative_base()
class ExampleModel(Base, StreamlitAlchemyMixin):
__tablename__ = "example"
id = Column(Integer, primary_key=True)
name = Column(String)
# Initialize the connection
CONNECTION = st.connection("example_db", type="sql")
Base.metadata.create_all(CONNECTION.engine)
StreamlitAlchemyMixin.st_initialize(CONNECTION)
# Create CRUD tabs
ExampleModel.st_crud_tabs()
Comprehensive Example
import logging
from pathlib import Path
import streamlit as st
from examples.models import Base, Task, User
from streamlit_sqlalchemy import StreamlitAlchemyMixin
def show_single_task(task):
col1, col2, col3 = st.columns([1, 1, 1])
if task.done:
col1.write(f" - ~~{task.description}~~")
with col2:
task.st_delete_button()
else:
if task.due_date:
date_color = "red" if task.due_date < datetime.now() else "green"
col1.write(f" - {task.description} (:{date_color}[{task.due_date.strftime('%H:%M - %d.%m.%Y')}])")
else:
col1.write(f" - {task.description}")
with col2:
task.st_edit_button("Done", {"done": True})
with col3:
task.st_delete_button()
def app():
st.title("Streamlit SQLAlchemy Demo")
User.st_crud_tabs()
with CONNECTION.session as session:
for user in session.query(User).all():
with st.expander(f"### {user.name}'s tasks:"):
c = st.container()
st.write("**Add a new task:**")
Task.st_create_form(defaults={"user_id": user.id, "done": False})
with c:
if not user.tasks:
st.caption("No tasks yet.")
for task in user.tasks:
show_single_task(task)
def main():
if not Path("example.db").exists():
Base.metadata.create_all(CONNECTION.engine)
StreamlitAlchemyMixin.st_initialize(connection=CONNECTION)
app()
if __name__ == "__main__":
# initialize the database connection
# (see https://docs.streamlit.io/library/api-reference/connections/st.connection)
CONNECTION = st.connection("example_db", type="sql")
main()
You can explore this provided example, and launch it from the root directory (because it relies on relative imports):
python -m streamlit run examples/example.py
Contributing
We welcome contributions! See our contribution guidelines for more details.
License
This project is licensed under the Apache License 2.0 - see the LICENSE file for details.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for streamlit_sqlalchemy-0.1.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | a042d0a516b259d1a3341350444428cebc81993767253bfd485fd2e8fd820390 |
|
MD5 | e37f65bc1f975705622e195167784e22 |
|
BLAKE2b-256 | 9d10139259c83030f882997af5fcc10e31cdabe843c48040ef346bf0e8e5ba71 |
Hashes for streamlit_sqlalchemy-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8051f02129e974af3702de48b650fac4e072e136d51f1fa4403b5bc5be3aefc7 |
|
MD5 | 0611e146215e08106f29f92b783d76bd |
|
BLAKE2b-256 | 010d622a47b0d5dfd5318dd3e5ef114f90db373216015e427407ae70f50fa2c8 |