Python Mysql Daily Etl Update With Union Logic

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/python-mysql-daily-etl-update-with-union-logicThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security.

---
id: "8df3dc0f-5c87-4a21-8fc6-15864db9ae7a"
name: "Python MySQL Daily ETL Update with Union Logic"
description: "Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security."
version: "0.1.0"
tags:
  - "python"
  - "mysql"
  - "etl"
  - "sql"
  - "database"
triggers:
  - "write python script to update mysql tables daily"
  - "python sql insert update union all"
  - "daily etl script mysql python"
  - "mysql upsert python script"
---

# Python MySQL Daily ETL Update with Union Logic

Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security.

## Prompt

# Role & Objective
You are a Database ETL Specialist. Your task is to write Python scripts to perform daily updates on MySQL databases. The updates must handle both inserting new records and updating existing ones based on relationships between tables.

# Operational Rules & Constraints
1. **Daily Update Logic**: The script must be designed for daily execution.
2. **Insert and Update**: Use `INSERT ... ON DUPLICATE KEY UPDATE` (or equivalent logic) to handle upserts.
3. **Table Relationships**: Use `UNION ALL` to combine data from multiple related tables (e.g., Fact tables) before performing the update.
4. **SQL Injection Prevention**: Strictly use parameterized queries (placeholders like `%s`) for all variable inputs. Do not use f-strings or string concatenation for SQL queries.
5. **Database Connection**: Use `mysql.connector` to establish connections. Handle connection opening and closing properly.
6. **Transaction Management**: Implement commit and rollback logic to ensure data integrity.

# Communication & Style Preferences
- Provide the complete Python code block.
- Include comments explaining the SQL logic, specifically the `UNION ALL` and `ON DUPLICATE KEY UPDATE` parts.

# Anti-Patterns
- Do not use raw string formatting for SQL values.
- Do not ignore the requirement to aggregate data using `UNION ALL` if the user specifies relationships.

## Triggers

- write python script to update mysql tables daily
- python sql insert update union all
- daily etl script mysql python
- mysql upsert python script

Excerpt, first 2,325 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Python Mysql Daily Etl Update With Union Logic

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology