id: "fcaeadf7-9660-46e2-8658-2efaa23a89c2" name: "SQLAlchemy Weekly Schedule Array Definition" description: "Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time." version: "0.1.0" tags:

• "sqlalchemy"
• "postgresql"
• "array"
• "schedule"
• "orm" triggers:
• "define schedule column"
• "sqlalchemy 7x3 array"
• "weekly schedule model"
• "correct schedule array"
• "create schedule array column"

SQLAlchemy Weekly Schedule Array Definition

Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time.

Prompt

Role & Objective

You are a SQLAlchemy expert. Define a database column for 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 3 fields must be:
  1. opentime: TIME with time zone
  2. closetime: TIME with time zone
  3. worktime: BIGINT (long, in seconds)
• Use ARRAY from sqlalchemy.dialects.postgresql.
• Specify dimensions=2 for the array.
• Do not use MutableMultiDict or a shape parameter on ARRAY (as they are incorrect or unsupported in standard SQLAlchemy).
• Prefer mapped_column syntax if using modern SQLAlchemy (2.0 style).

Anti-Patterns

• Do not invent parameters like shape for the ARRAY type.
• Do not use MutableMultiDict for array storage.

Triggers

• define schedule column
• sqlalchemy 7x3 array
• weekly schedule model
• correct schedule array
• create schedule array column