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