Nawa kawai ne jininka ku yi amfani da AI don rubuta maigida da juyawar siffa na kamuwa?

Question

IT Interview Practice · Accepted Answer

AI yayi daidai sosai ga **juyawar siffa** (CSV ↔ JSON ↔ SQL) da jujuyawar maigida saboda a ka gaske juyawa shi ne na ugar likita. Kwatanci shi ne ba shi da isa kontekste don zama daidai da aminci: mabantu, jere na misali, da wajabau aminci mai bayyanar.

## Nawa ne dole ku tambaye shi

- **Ba shi da asali da niyya mabantu** — sunan gajerun, nau'i, rashin lallai.
- **Haɗa gaske misali jere** don ya ga siffar ne da gida da al'amari na gefen (fita, babu, jiya).
- **Bukaci a zama idempotent da tabbatatu** — sake aiki bai kamata a dubi ko harabar bayyane; mun cimma jeri kuwa kamata a gano, ba a bugi jikinsu ba.
- **Koda yaushe koyi-fitsari a jigon** kamuwa kafin susuban kasuwa. Duba sakamakon da farko.

## Misali: CSV → SQL aje

```python
import csv

# Source CSV: id,email,signup_date  (signup_date may be blank)
# Target table: users(id INT, email TEXT NOT NULL, signup_date DATE NULL)
def csv_to_sql(path: str) -> list[str]:
    statements = []
    with open(path, newline="", encoding="utf-8") as f:
        for row in csv.DictReader(f):
            email = row["email"].strip()
            if not email:                      # validate: skip invalid rows, don't insert garbage
                continue
            date = row["signup_date"].strip() or None
            email_sql = email.replace("'", "''")   # escape quotes to avoid broken SQL / injection
            date_sql = f"'{date}'" if date else "NULL"
            # ON CONFLICT makes it idempotent: re-running won't create duplicates
            statements.append(
                f"INSERT INTO users (id, email, signup_date) "
                f"VALUES ({int(row['id'])}, '{email_sql}', {date_sql}) "
                f"ON CONFLICT (id) DO NOTHING;"
            )
    return statements
```

Rashin aiki sun tabbatar sassa da mahaɗa: **tabbatarwa** (cire saitunan waje), **fitarwa** (fita) da **idempotency** (`ON CONFLICT DO NOTHING`). Bukaci AI a haɗa duka uku — su ne abubuwan da rufe gida tsarata ta manta.

## Me yasa yana mahaɗa

Kamuwa juyawar sun yi kike da sau gida gida: rufe da jujuyawar daya zai iya zama jin kofi a ware. AI sanye hanzari ne akan rubutu, amma ƙarya aminci — idempotency, tabbatarwa, da koyi-fitsari akan jigon — ba za su iya katsu ba. Ɗauki jujuya jere azaman rawe wanda dole a karanta da gwada, kaɗai ba ga abin da za a taka iska a kan kamuwan ne.

Nawa ne dole ku tambaye shi

Misali: CSV → SQL aje

Me yasa yana mahaɗa

Tambayoyi masu alaƙa