a7df3c2708
Dashboard Add top-right user dropdown using Syncfusion DropDownButton: shows username + role; menu entries “Profil” and “Abmelden”. Replace custom dropdown logic with Syncfusion component; position at header’s right edge. Update /logout page to call backend logout and redirect to /login (reliable user switching). Build/Config Add @syncfusion/ej2-react-splitbuttons and @syncfusion/ej2-splitbuttons dependencies. Update Vite optimizeDeps.include to pre-bundle splitbuttons and avoid import-analysis errors. Docs README: Rework Architecture Overview with clearer data flow: Listener consumes MQTT (discovery/heartbeats) and updates API. Scheduler reads from API and publishes events via MQTT to clients. Clients send via MQTT and receive via MQTT. Worker receives commands directly from API and reports results back (no MQTT). Explicit note: MariaDB is accessed exclusively by the API Server; Dashboard never talks to DB directly. README: Add SplitButtons to “Syncfusion Components Used”; add troubleshooting steps for @syncfusion/ej2-react-splitbuttons import issues (optimizeDeps + volume reset). Copilot instructions: Document header user menu and splitbuttons technical notes (deps, optimizeDeps, dev-container node_modules volume). Program info Bump to 2025.1.0-alpha.10 with changelog: UI: Header user menu (DropDownButton with username/role; Profil/Abmelden). Frontend: Syncfusion SplitButtons integration + Vite pre-bundling config. Fix: Added README guidance for splitbuttons import errors. No breaking changes.
41 lines
1.4 KiB
Python
41 lines
1.4 KiB
Python
"""
|
|
Add editor role to UserRole enum and ensure role column exists on users table
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
import enum
|
|
|
|
# revision identifiers, used by Alembic.
|
|
revision = 'add_userrole_editor_and_column'
|
|
down_revision = None # Set this to the latest revision in your repo
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
# Define the new enum including 'editor'
|
|
class userrole_enum(enum.Enum):
|
|
user = "user"
|
|
editor = "editor"
|
|
admin = "admin"
|
|
superadmin = "superadmin"
|
|
|
|
def upgrade():
|
|
# MySQL: check if 'role' column exists
|
|
conn = op.get_bind()
|
|
insp = sa.inspect(conn)
|
|
columns = [col['name'] for col in insp.get_columns('users')]
|
|
if 'role' not in columns:
|
|
with op.batch_alter_table('users') as batch_op:
|
|
batch_op.add_column(sa.Column('role', sa.Enum('user', 'editor', 'admin', 'superadmin', name='userrole'), nullable=False, server_default='user'))
|
|
else:
|
|
# If the column exists, alter the ENUM to add 'editor' if not present
|
|
# MySQL: ALTER TABLE users MODIFY COLUMN role ENUM(...)
|
|
conn.execute(sa.text(
|
|
"ALTER TABLE users MODIFY COLUMN role ENUM('user','editor','admin','superadmin') NOT NULL DEFAULT 'user'"
|
|
))
|
|
|
|
def downgrade():
|
|
# ### commands auto generated by Alembic - please adjust! ###
|
|
with op.batch_alter_table('users') as batch_op:
|
|
batch_op.drop_column('role')
|
|
# ### end Alembic commands ###
|