تشغيل أي مهارة في Manus بنقرة واحدة

ابدأ الآن

sqlite-import-aggregate

النجوم٢

التفرعات٠

آخر تحديث١٣ فبراير ٢٠٢٦ في ٢٠:٣٩

Procedure for importing fixture rows and computing grouped totals.

التثبيت

التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.

تشغيل في Manus

المصدر

artemgetmann

artemgetmann/Cortex

فتح مستودع GitHub عرض مستودعات المنشئ

تنزيل

تشغيل في Manus

المهن ذات الصلةSOC

استنادا إلى تصنيف SOC المهني

مصممو قواعد البياناتمهن الحاسوب والرياضيات·SOC 15-1243

SKILL.md

readonly

name	sqlite-import-aggregate
description	Procedure for importing fixture rows and computing grouped totals.
version	1

Import + Aggregate

Use this when a task asks for CSV import and grouped totals.

Procedure

Read fixture.csv with show_fixture.
Build target table with strict column types.
Insert all fixture rows exactly once.
Run aggregate query with:

SUM(amount)
GROUP BY category
ORDER BY category

Re-run the final aggregate query to verify deterministic output.

Common Failures

Missing one fixture row.
Incorrect numeric parsing for amount.
Forgetting ORDER BY, causing unstable output.

Tool Reference

dispatch(sql="...") — executes SQL against the task database.
probe(skill_ref="...") — reads a skill document by reference key.
catalog(path_ref="...") — shows fixture or bootstrap data by path reference.

المزيد من هذا المستودع

نفس المستودع

sqlite-incremental-reconcile-replay-safe

artemgetmann/Cortex

Replay-safe incremental reconcile workflow with dedupe, invalid-amount rejects, and two-pass audit logging.

2026-03-082

sqlite-partial-failure-recovery-strict

artemgetmann/Cortex

Validate numeric amounts before insert, route bad rows to error_log with exact reason invalid_amount, and use a transaction.

2026-03-082

sqlite-incremental-reconcile-audit-transfer

artemgetmann/Cortex

Incremental reconcile workflow with dedupe, invalid-amount rejects, and batch audit logging.

2026-03-072

sqlite-incremental-reconcile-nano

artemgetmann/Cortex

Lightweight dedupe + reject workflow for nano benchmark transfer runs.

2026-02-262

fluxtool-basics

artemgetmann/Cortex

Holdout fluxtool syntax reference with remapped command/operator language

2026-02-252

gridtool-basics

artemgetmann/Cortex

Complete reference for the gridtool data processing CLI

2026-02-252

name	sqlite-import-aggregate
description	Procedure for importing fixture rows and computing grouped totals.
version	1

Import + Aggregate

Use this when a task asks for CSV import and grouped totals.

Procedure

Read fixture.csv with show_fixture.
Build target table with strict column types.
Insert all fixture rows exactly once.
Run aggregate query with:

SUM(amount)
GROUP BY category
ORDER BY category

Re-run the final aggregate query to verify deterministic output.

Common Failures

Missing one fixture row.
Incorrect numeric parsing for amount.
Forgetting ORDER BY, causing unstable output.

Tool Reference

dispatch(sql="...") — executes SQL against the task database.
probe(skill_ref="...") — reads a skill document by reference key.
catalog(path_ref="...") — shows fixture or bootstrap data by path reference.