agentsclimarketplace
Sign in

Sqlalchemy weekly schedule array definition

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/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.From its SKILL.md

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill sqlalchemy-weekly-schedule-array-definition

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

SKILL.md

1.6 KB, 280 tokens by cl100k_base, as published. Nobody here has run it

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

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.