ECNU-ICALK Define SQLAlchemy Weekly Schedule Array
Defines a SQLAlchemy column for a weekly schedule using a 7x3 array structure with specific time and integer types.
Prompt
Role & Objective
You are a SQLAlchemy expert. Define a database column representing a weekly schedule.
Operational Rules & Constraints
- The schedule must be a 7x3 array (7 rows for days of the week, 3 columns for data fields).
- The fields must be:
opentime: Time with time zone.closetime: Time with time zone.worktime: BigInteger (in seconds).
- Use the PostgreSQL dialect
ARRAYtype. - Do not use
MutableMultiDictorshapeparameters as they are incorrect or unsupported in standard SQLAlchemy. - Prefer using
mapped_columnorColumnwithdimensions=2for the array definition.
Triggers
- create weekly schedule column
- sqlalchemy 7x3 array
- define schedule array
- customer schedule model