원클릭으로 Manus에서 모든 스킬 실행

atomicupdate

스타2

포크0

업데이트2026년 5월 7일 18:30

Create a new Koha atomicupdate file for a bug. Arguments: bug number (e.g. 12345) and a short description of the DB change.

설치

Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.

Manus에서 실행

출처

mrenvoize

mrenvoize/koha-contributor

GitHub 저장소 열기 Creator 저장소 보기

다운로드

Manus에서 실행

관련 직업SOC

SOC 직업 분류 기준

데이터베이스 아키텍트컴퓨터 및 수학직·SOC 15-1243

SKILL.md

readonly

name	atomicupdate
description	Create a new Koha atomicupdate file for a bug. Arguments: bug number (e.g. 12345) and a short description of the DB change.

Create an atomicupdate file for Koha bug $ARGUMENTS.

Steps:

Parse arguments: first token is the bug number, remainder is the description.
Create the file installer/data/mysql/atomicupdate/bug_BUGNUMBER.pl using the skeleton below.
Replace BUG_NUMBER with the actual bug number and DESCRIPTION with the description.
Leave the $dbh->do(q{}) placeholder in place — the user will fill in the actual SQL.
Make the file executable: chmod +x installer/data/mysql/atomicupdate/bug_BUGNUMBER.pl (Koha QA's file_permissions check enforces this).
Report the created file path.

Skeleton (based on installer/data/mysql/atomicupdate/skeleton.pl):

use Modern::Perl;
use Koha::Installer::Output qw(say_warning say_success say_info);

return {
    bug_number  => "BUG_NUMBER",
    description => "DESCRIPTION",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        # Add your DB changes here
        $dbh->do(q{});

        say_success( $out, "Done" );
    },
};

After the user fills in the SQL, remind them of the wider workflow:

Update installer/data/mysql/kohastructure.sql to match.
Apply inside KTD: perl installer/data/mysql/updatedatabase.pl.
Regenerate DBIC schema: dbic --force inside KTD.
For new tinyint(1) columns that semantically represent yes/no flags, add '+colname' => { is_boolean => 1 } to the Result module BELOW the # DO NOT MODIFY THIS OR ANYTHING ABOVE! line (QA SQL12 / tinyint_has_boolean_flag).
Commit auto-generated DBIC changes as Bug XXXXX: Automated Schema Update, then commit any manual is_boolean / relationship additions as a separate commit.

이 저장소의 다른 Skills

같은 저장소

koha-bz

mrenvoize/koha-contributor

File a Koha bug on bugs.koha-community.org and attach commits non-interactively via git bz. Use when the user wants to submit a patch, file a bug, or open a bz/Bugzilla ticket for Koha. Arguments (optional, free-form): summary or component hints. Without args, derive details from the current branch and HEAD commits.

2026-06-162

koha-build

mrenvoize/koha-contributor

Build Koha frontend assets (CSS, JS, OpenAPI spec) inside the KTD container. Use after editing SCSS, Vue components, or api/v1/swagger/*.yaml. After swagger changes you must also run restart_all to reload services — yarn build alone is not enough.

2026-06-082

koha-cypress

mrenvoize/koha-contributor

Run Koha Cypress end-to-end tests. Cypress runs from the HOST (not the KTD container) — KTD exposes the staff/OPAC interfaces on localhost and Cypress drives a real browser. Pass a spec path or directory under t/cypress/integration/.

2026-06-082

koha-prove

mrenvoize/koha-contributor

Run Koha Perl tests inside the KTD container. Pass a test file or directory path (relative to the Koha repo root, or absolute). Handles both t/ and t/db_dependent/ automatically.

2026-06-082

koha-qa

mrenvoize/koha-contributor

Run the Koha QA script (koha-qa.pl) inside KTD before submitting patches. Surfaces critic, POD, file_permissions, tinyint_has_boolean_flag, and other QA failures the community reviewers will check. Run after every commit; fix flagged issues before pushing.

2026-06-082

koha-schema-apply

mrenvoize/koha-contributor

Apply a Koha DB schema change end-to-end after editing kohastructure.sql and the atomicupdate file. Runs updatedatabase.pl in KTD, regenerates DBIC schema with dbic --force, and reminds about the manual is_boolean / relationship edits below the marker line. Use this after the atomicupdate skill has scaffolded the file and the SQL is filled in.

2026-06-082

name	atomicupdate
description	Create a new Koha atomicupdate file for a bug. Arguments: bug number (e.g. 12345) and a short description of the DB change.

Create an atomicupdate file for Koha bug $ARGUMENTS.

Steps:

Parse arguments: first token is the bug number, remainder is the description.
Create the file installer/data/mysql/atomicupdate/bug_BUGNUMBER.pl using the skeleton below.
Replace BUG_NUMBER with the actual bug number and DESCRIPTION with the description.
Leave the $dbh->do(q{}) placeholder in place — the user will fill in the actual SQL.
Make the file executable: chmod +x installer/data/mysql/atomicupdate/bug_BUGNUMBER.pl (Koha QA's file_permissions check enforces this).
Report the created file path.

Skeleton (based on installer/data/mysql/atomicupdate/skeleton.pl):

use Modern::Perl;
use Koha::Installer::Output qw(say_warning say_success say_info);

return {
    bug_number  => "BUG_NUMBER",
    description => "DESCRIPTION",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        # Add your DB changes here
        $dbh->do(q{});

        say_success( $out, "Done" );
    },
};

After the user fills in the SQL, remind them of the wider workflow:

Update installer/data/mysql/kohastructure.sql to match.
Apply inside KTD: perl installer/data/mysql/updatedatabase.pl.
Regenerate DBIC schema: dbic --force inside KTD.
For new tinyint(1) columns that semantically represent yes/no flags, add '+colname' => { is_boolean => 1 } to the Result module BELOW the # DO NOT MODIFY THIS OR ANYTHING ABOVE! line (QA SQL12 / tinyint_has_boolean_flag).
Commit auto-generated DBIC changes as Bug XXXXX: Automated Schema Update, then commit any manual is_boolean / relationship additions as a separate commit.