Streamlit-sqlalchemy

Latest version: v0.2.0

Safety actively analyzes 627310 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

0.2.0

fix!: Add the many2one in update form

Originally, the many2one were not added to the update form because of
my single usecase. However it absolutely makes sense to be able to
modify the many2one relationships.

To keep the original behiaviour, you can use the except_columns
kwarg and add each of the _id ending fields.

BREAKING CHANGE: Now you have the many2one by default in the update
form.

Refs: https://github.com/artygo8/streamlit-sqlalchemy/issues/3

0.1.1

What's Changed
* [FIX] Fixing issue 1 by artygo8 in https://github.com/artygo8/streamlit-sqlalchemy/pull/2

**Full Changelog**: https://github.com/artygo8/streamlit-sqlalchemy/compare/0.1.0...0.1.1

Thank you for opening 1 !

0.1.0

Main changes:
- Optional `filter_by: dict` kwarg for `*_select_form` to display only
the elements you are interested in. (ex: filter on foreign key)
- Optional `except_columns: list` for `_form` methods: column names to
exclude from the form.
- Ensure the default value from the Column declaration is set.

Meta elements:
- `__st_input_meta__`: specify custom streamlit components for your
columns.
- `__st_repr__`: specify how an SQLAlchemy object is displayed in a
`selectbox`.
- `__st_order_by__`: specify how SQLAlchemy objects are ordered in a
`selectbox`.

New column types supported:
- Float: similar to int but with 0.1 steps
- Datetime: 2 input elements - Date & Time
- Date: st.date_input
- Time: st.time_input
- Text: st.text_area

Details:
- Add KWO arg `border=False` to methods containing forms
(streamlit>=1.29.0)

0.0.6

Changes:
- Use unique hashes to avoid form clashes (using md5).
- Remove the ' Id' at the end in the column names for display.
- Replace `engine` (sql Alchemy) by the `st.connection` for
StreamlitAlchemyMixin initialization.
- Remove the border from the forms (requires `streamlit>=1.29.0`)
- `st.rerun` on `st_update_select_forms` as well as on
`st_delete_select_form`.
- Add support for boolean Columns - using selectbox to allow None
as possible value.
- Pass `kwargs` from `st_*_button` to `st.button`.

![assets/streamlit-example-2023-12-31-16-12-91.gif](https://github.com/artygo8/streamlit-sqlalchemy/blob/main/assets/streamlit-example-2023-12-31-16-12-91.gif)

0.0.5

Preparing for Beta release !

0.0.4

First release of the templating tool to help writing sqlalchemy objects usable with streamlit!

Links

Releases

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.