Banana-manager

Added

- Introduced a new **Change History Modal** (still under development), which currently lacks some functionalities, such as the **Undo Button**.
- Added `gridOptions` property to table models for enhanced configurability.

Fixed

- Resolved an issue where foreign key columns were not utilizing the default filter component.
- Fixed rendering issues that occurred during page refresh.

Changed

- Replaced the `editable`, `sortable`, `filter`, and `hide` properties with a unified `columnDef` property, aligning with AG Grid's standard notation.
- Updated the **Refresh Button** with a slightly revised style.
- Renamed the `grid_options` property in the `config.yaml` file to `defaultGridOptions` for consistency.

Added

- **New Placeholder Title:** A placeholder title is now available when no table is selected.
- **Error Notifications:** Added error notifications when attempting to refresh table configurations.

Fixed

- **Button Behavior:** Buttons on the side menu no longer shrink after reaching the maximum container height.

Changed

- **Refresh Button Location:** The “Refresh” button has been moved to the side menu, making it clearer that it refreshes the menu rather than the table.
- **Error Notification Style:** A new error notification style and back-end function have been introduced.

Added

- Added an optional `theme` argument. Users can now set this argument to one of the [default Mantine colors](https://mantine.dev/theming/colors/#default-colors) to customize the application’s color palette.

Fixed

- Fixed the issue with the “Insert” button, which previously caused an error when attempting to open the form.

Added

- **Insert Button:** An “Insert” button has been added. It allows users to add new rows to the table.
- **Refresh Button:** A new “Refresh” button has been introduced. It updates the left-side menu with new table configurations without requiring the app to be restarted.
- **Notification Pop-ups:** When an error occurs during row insertion or cell updates, notification pop-ups will appear.

Changed

- **Log History:** The log history is now stored in a `log.db` file located in the data folder.

Quick additions to enhance the logging functionality of the package.

Added

- The application now creates an `error.log` file in your data folder. You can specify the data folder directory in the `config.yaml`.
- The `update.log` also records the old cell value before updating.

Changed

- The `connection_string` argument in `config.yaml` has been replaced with a `connection` object. The new structure for the connection configuration is as follows:

yaml
Old config.yaml
connection_string: <string>

New config.yaml
connection:
drivername: <optional string>
username: <optional string>
password: <optional string>
host: <optional string>
port: <optional positive int>
database: <optional string>


Added

1. Environment Variables for Username and Password

You can now read the username and password from environment variables. Set `BANANA_USERNAME` and `BANANA_PASSWORD` as environment variables.

2. Logging for Changed Values

A `update.log` file will be created in your data folder. You can specify the data folder location in the `config.yaml` using the `data_path` key.

yaml
data_path: "data"


3. Add `order_by` and `limit` clauses to table configuration.

yaml
tables:
- limit: <optional positive int>
order_by:
- column: <string>
desc: <optional bool>


4. Add AG Grid options in the `config.yaml`.

yaml
grid_options:
pagination: True
paginationPageSize: 50
singleClickEdit: True


5. Add `editable`, `filter` and `sortable` to column definition.

yaml
columns:
- editable: <optional bool>
- filter: <optional bool>
- sortable: <optional bool>


6. Add `hide`, `filter` and `sortable` to primary key definition.

yaml
primary_key:
- hide: <optional bool>
- filter: <optional bool>
- sortable: <optional bool>


7. Add `order_by` to foreign key definition.

yaml
foreign_key:
order_by:
- column: <string>
desc: <optional bool>