Compare commits
14 Commits
feature/an
...
27a3eb802c
| Author | SHA1 | Date | |
|---|---|---|---|
| 27a3eb802c | |||
| 13a887608c | |||
| f74af537e2 | |||
| bb832b7f95 | |||
| 3a75005f43 | |||
| f2a64ad66b | |||
| 3706ba3ecd | |||
| c8ab6bf072 | |||
| 7fe538dd5d | |||
| ff42341c47 | |||
| 90f998d189 | |||
| 433f9ee592 | |||
| 5c327cd8d8 | |||
| b12b5d720d |
28
GerbilManagerWebAPI/Endpoints/ImportDocxEndpoints.cs
Normal file
28
GerbilManagerWebAPI/Endpoints/ImportDocxEndpoints.cs
Normal file
@@ -0,0 +1,28 @@
|
|||||||
|
using GerbilManagerWebAPI.Import;
|
||||||
|
using Microsoft.AspNetCore.Http.HttpResults;
|
||||||
|
|
||||||
|
namespace GerbilManagerWebAPI.Endpoints
|
||||||
|
{
|
||||||
|
public static class ImportDocxEndpoints
|
||||||
|
{
|
||||||
|
public static IEndpointRouteBuilder MapImportDocxEndpoints(this IEndpointRouteBuilder app)
|
||||||
|
{
|
||||||
|
var group = app.MapGroup("/import/docx").WithTags("Import");
|
||||||
|
|
||||||
|
// POST /import/docx/dry-run — analyse without writing
|
||||||
|
group.MapPost("/dry-run",
|
||||||
|
async Task<Ok<ImportDocxReport>> (
|
||||||
|
ApplicationContext db, IConfiguration config, IWebHostEnvironment env) =>
|
||||||
|
TypedResults.Ok(await new ImportDocxService(db, config, env).RunAsync(execute: false)));
|
||||||
|
|
||||||
|
// POST /import/docx/execute — GATED: enriches Gerbils with Litter-Link,
|
||||||
|
// ReceiverContact, GoHomeDate, DateOfDeath, CauseOfDeath (fill-NULL-only).
|
||||||
|
group.MapPost("/execute",
|
||||||
|
async Task<Ok<ImportDocxReport>> (
|
||||||
|
ApplicationContext db, IConfiguration config, IWebHostEnvironment env) =>
|
||||||
|
TypedResults.Ok(await new ImportDocxService(db, config, env).RunAsync(execute: true)));
|
||||||
|
|
||||||
|
return app;
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
259
GerbilManagerWebAPI/Import/ImportDocxService.cs
Normal file
259
GerbilManagerWebAPI/Import/ImportDocxService.cs
Normal file
@@ -0,0 +1,259 @@
|
|||||||
|
using System.Text.Json;
|
||||||
|
using GerbilManagerWebAPI.Models;
|
||||||
|
using Microsoft.EntityFrameworkCore;
|
||||||
|
|
||||||
|
namespace GerbilManagerWebAPI.Import
|
||||||
|
{
|
||||||
|
/// <summary>
|
||||||
|
/// FEAT-8d docx loader. Consumes tools/import/output/docx_litters.json +
|
||||||
|
/// docx_animals.json (produced by extract_docx.py) and enriches the database:
|
||||||
|
///
|
||||||
|
/// Load policy (IDEMPOTENT NACHZUG after main WIPE+REIMPORT):
|
||||||
|
/// - Litter link: match docx WS-code to Litters.PairingCode → set Gerbil.LitterId
|
||||||
|
/// for animals matched by normalize(name) + litter birth date.
|
||||||
|
/// - ReceiverContact: lookup-or-create Contact by owner name → set ReceiverContactId.
|
||||||
|
/// - GoHomeDate, DateOfDeath, CauseOfDeath: fill if currently null (fill-NULL-only).
|
||||||
|
/// - NEVER overwrites a manually-set non-null value.
|
||||||
|
///
|
||||||
|
/// Idempotent: running multiple times is safe. Each run resolves whatever is still null.
|
||||||
|
/// Execute is gated by the endpoint; this service only acts when asked.
|
||||||
|
/// </summary>
|
||||||
|
public sealed class ImportDocxService
|
||||||
|
{
|
||||||
|
private static readonly JsonSerializerOptions Json = new() { PropertyNameCaseInsensitive = true };
|
||||||
|
|
||||||
|
private readonly ApplicationContext _db;
|
||||||
|
private readonly string _sourceDir;
|
||||||
|
|
||||||
|
public ImportDocxService(ApplicationContext db, IConfiguration config, IWebHostEnvironment env)
|
||||||
|
: this(db,
|
||||||
|
config["Import:SourcePath"]
|
||||||
|
?? Path.GetFullPath(Path.Combine(env.ContentRootPath, "..", "tools", "import", "output")))
|
||||||
|
{ }
|
||||||
|
|
||||||
|
public ImportDocxService(ApplicationContext db, string sourceDir)
|
||||||
|
{
|
||||||
|
_db = db;
|
||||||
|
_sourceDir = sourceDir;
|
||||||
|
}
|
||||||
|
|
||||||
|
public async Task<ImportDocxReport> RunAsync(bool execute)
|
||||||
|
{
|
||||||
|
var notes = new List<string>();
|
||||||
|
|
||||||
|
var docxLitters = Load<List<DocxLitter>>("docx_litters.json") ?? new();
|
||||||
|
var docxAnimals = Load<List<DocxAnimal>>("docx_animals.json") ?? new();
|
||||||
|
|
||||||
|
if (docxLitters.Count == 0 && docxAnimals.Count == 0)
|
||||||
|
{
|
||||||
|
notes.Add($"Keine Quelldaten in {_sourceDir} (docx_litters.json/docx_animals.json). " +
|
||||||
|
"extract_docx.py zuerst ausführen.");
|
||||||
|
return new ImportDocxReport(false, 0, 0, 0, 0, 0, 0, notes);
|
||||||
|
}
|
||||||
|
|
||||||
|
// Build lookup: PairingCode → Litter.Id (WS-code normalised: spaces removed)
|
||||||
|
var littersInDb = await _db.Litters
|
||||||
|
.Where(l => l.PairingCode != null)
|
||||||
|
.Select(l => new { l.Id, l.Date, l.PairingCode })
|
||||||
|
.ToListAsync();
|
||||||
|
var litterByWs = littersInDb
|
||||||
|
.GroupBy(l => l.PairingCode!.Replace(" ", ""))
|
||||||
|
.ToDictionary(g => g.Key, g => g.ToList());
|
||||||
|
|
||||||
|
// Build animal lookup: normalize(name) + litter_dob → Gerbil (for litter-link)
|
||||||
|
var gerbilsInDb = await _db.Gerbils
|
||||||
|
.Select(g => new { g.Id, g.Name, g.DateOfBirth, g.LitterId,
|
||||||
|
g.ReceiverContactId, g.GoHomeDate, g.DateOfDeath, g.CauseOfDeath })
|
||||||
|
.ToListAsync();
|
||||||
|
var gerbilByKey = gerbilsInDb
|
||||||
|
.Where(g => g.DateOfBirth is not null)
|
||||||
|
.GroupBy(g => NameDobKey(g.Name, g.DateOfBirth!.Value))
|
||||||
|
.ToDictionary(g => g.Key, g => g.ToList());
|
||||||
|
|
||||||
|
// Contact lookup: normalized name → existing Contact
|
||||||
|
var contactsInDb = await _db.Contacts
|
||||||
|
.Select(c => new { c.Id, c.Name })
|
||||||
|
.ToListAsync();
|
||||||
|
var contactByNorm = contactsInDb
|
||||||
|
.GroupBy(c => NormalizeName(c.Name))
|
||||||
|
.ToDictionary(g => g.Key, g => g.First().Id);
|
||||||
|
|
||||||
|
int litterLinked = 0, goHomeFilled = 0, deathFilled = 0;
|
||||||
|
int ownerLinked = 0, ownerCreated = 0, skipped = 0;
|
||||||
|
|
||||||
|
foreach (var da in docxAnimals)
|
||||||
|
{
|
||||||
|
if (string.IsNullOrWhiteSpace(da.Name)) { skipped++; continue; }
|
||||||
|
|
||||||
|
// Resolve the litter by WS-code + approximate birth date
|
||||||
|
Guid? litterId = null;
|
||||||
|
if (!string.IsNullOrWhiteSpace(da.WsCode) && !string.IsNullOrWhiteSpace(da.LitterDob))
|
||||||
|
{
|
||||||
|
var litterDob = ParseDate(da.LitterDob);
|
||||||
|
if (litterDob is not null && litterByWs.TryGetValue(da.WsCode.Replace(" ", ""), out var cands))
|
||||||
|
{
|
||||||
|
// Pick the litter whose date matches (within ±5 days for rounding)
|
||||||
|
var match = cands.FirstOrDefault(l =>
|
||||||
|
Math.Abs((l.Date.DayNumber - litterDob.Value.DayNumber)) <= 5);
|
||||||
|
litterId = match?.Id;
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
// Resolve the gerbil by name + litter birth date
|
||||||
|
var animalDob = litterId is not null
|
||||||
|
? (await _db.Litters.Where(l => l.Id == litterId).Select(l => (DateOnly?)l.Date).FirstOrDefaultAsync())
|
||||||
|
: ParseDate(da.LitterDob);
|
||||||
|
|
||||||
|
if (animalDob is null) { skipped++; continue; }
|
||||||
|
|
||||||
|
var key = NameDobKey(da.Name, animalDob.Value);
|
||||||
|
if (!gerbilByKey.TryGetValue(key, out var gerbilCands)) { skipped++; continue; }
|
||||||
|
|
||||||
|
// If multiple gerbils match (same name+dob), take the one without a litter link first
|
||||||
|
var gerbilSnap = gerbilCands.FirstOrDefault(g => g.LitterId == null)
|
||||||
|
?? gerbilCands.First();
|
||||||
|
|
||||||
|
// Resolve receiver contact (lookup-or-create)
|
||||||
|
Guid? receiverId = null;
|
||||||
|
if (!string.IsNullOrWhiteSpace(da.Owner))
|
||||||
|
{
|
||||||
|
var normOwner = NormalizeName(da.Owner);
|
||||||
|
if (contactByNorm.TryGetValue(normOwner, out var existingId))
|
||||||
|
{
|
||||||
|
receiverId = existingId;
|
||||||
|
ownerLinked++;
|
||||||
|
}
|
||||||
|
else
|
||||||
|
{
|
||||||
|
ownerCreated++;
|
||||||
|
if (execute)
|
||||||
|
{
|
||||||
|
var newContact = new Contact { Id = Guid.NewGuid(), Name = da.Owner.Trim() };
|
||||||
|
_db.Contacts.Add(newContact);
|
||||||
|
await _db.SaveChangesAsync();
|
||||||
|
receiverId = newContact.Id;
|
||||||
|
contactByNorm[normOwner] = receiverId.Value;
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
var goHomeDate = ParseDate(da.AbgabeDate);
|
||||||
|
var deathDate = ParseDate(da.DeathDate);
|
||||||
|
|
||||||
|
// Count what will change
|
||||||
|
bool willLinkLitter = litterId is not null && gerbilSnap.LitterId is null;
|
||||||
|
bool willFillGoHome = goHomeDate is not null && gerbilSnap.GoHomeDate is null;
|
||||||
|
bool willFillDeath = deathDate is not null && gerbilSnap.DateOfDeath is null;
|
||||||
|
|
||||||
|
if (willLinkLitter) litterLinked++;
|
||||||
|
if (willFillGoHome) goHomeFilled++;
|
||||||
|
if (willFillDeath) deathFilled++;
|
||||||
|
|
||||||
|
if (execute)
|
||||||
|
{
|
||||||
|
var row = await _db.Gerbils.FirstOrDefaultAsync(g => g.Id == gerbilSnap.Id);
|
||||||
|
if (row is null) continue;
|
||||||
|
|
||||||
|
if (willLinkLitter) row.LitterId = litterId;
|
||||||
|
if (receiverId is not null && row.ReceiverContactId is null)
|
||||||
|
row.ReceiverContactId = receiverId;
|
||||||
|
if (willFillGoHome) row.GoHomeDate = goHomeDate;
|
||||||
|
if (willFillDeath)
|
||||||
|
{
|
||||||
|
row.DateOfDeath = deathDate;
|
||||||
|
if (!string.IsNullOrWhiteSpace(da.DeathCause) && row.CauseOfDeath is null)
|
||||||
|
row.CauseOfDeath = da.DeathCause.Trim();
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
if (execute && (litterLinked + goHomeFilled + deathFilled + ownerLinked + ownerCreated) > 0)
|
||||||
|
await _db.SaveChangesAsync();
|
||||||
|
|
||||||
|
notes.Add($"Quelle: {docxLitters.Count} Würfe, {docxAnimals.Count} Tier-Zeilen aus der docx.");
|
||||||
|
notes.Add($"Litter-Links: {litterLinked} Tiere einem Wurf zugeordnet (WS-Code → PairingCode).");
|
||||||
|
notes.Add($"Abnehmer: {ownerLinked} bestehende Kontakte verknüpft, {ownerCreated} neue Kontakte angelegt.");
|
||||||
|
notes.Add($"GoHomeDate: {goHomeFilled} Abgabe-Daten nachgetragen.");
|
||||||
|
notes.Add($"Tod-Datum: {deathFilled} Todesdaten nachgetragen.");
|
||||||
|
notes.Add($"Übersprungen: {skipped} Zeilen (kein Name oder kein DB-Match).");
|
||||||
|
if (!execute) notes.Add("DRY-RUN: nichts gespeichert. /import/docx/execute schreibt die Änderungen.");
|
||||||
|
|
||||||
|
return new ImportDocxReport(execute, litterLinked, ownerLinked + ownerCreated,
|
||||||
|
goHomeFilled, deathFilled, ownerCreated, skipped, notes);
|
||||||
|
}
|
||||||
|
|
||||||
|
private T? Load<T>(string file)
|
||||||
|
{
|
||||||
|
var path = Path.Combine(_sourceDir, file);
|
||||||
|
if (!File.Exists(path)) return default;
|
||||||
|
using var fs = File.OpenRead(path);
|
||||||
|
return JsonSerializer.Deserialize<T>(fs, Json);
|
||||||
|
}
|
||||||
|
|
||||||
|
private static DateOnly? ParseDate(string? s)
|
||||||
|
{
|
||||||
|
if (string.IsNullOrWhiteSpace(s)) return null;
|
||||||
|
var m = System.Text.RegularExpressions.Regex.Match(s,
|
||||||
|
@"(\d{1,2})\.(\d{1,2})\.(\d{2,4})");
|
||||||
|
if (!m.Success) return null;
|
||||||
|
int d = int.Parse(m.Groups[1].Value), mo = int.Parse(m.Groups[2].Value);
|
||||||
|
int y = int.Parse(m.Groups[3].Value);
|
||||||
|
if (y < 100) y += 2000;
|
||||||
|
try { return new DateOnly(y, mo, d); } catch { return null; }
|
||||||
|
}
|
||||||
|
|
||||||
|
private static string NameDobKey(string name, DateOnly dob)
|
||||||
|
{
|
||||||
|
var n = System.Text.RegularExpressions.Regex.Replace(
|
||||||
|
(name ?? "").ToLowerInvariant(), @"[^a-z0-9äöüß]", "");
|
||||||
|
return $"{n}|{dob:yyyy-MM-dd}";
|
||||||
|
}
|
||||||
|
|
||||||
|
private static string NormalizeName(string name)
|
||||||
|
{
|
||||||
|
var n = (name ?? "").ToLowerInvariant();
|
||||||
|
n = System.Text.RegularExpressions.Regex.Replace(n, @"\s+", " ").Trim();
|
||||||
|
return n;
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
// ---- Source shapes (from extract_docx.py output) ----
|
||||||
|
|
||||||
|
public sealed class DocxLitter
|
||||||
|
{
|
||||||
|
public string LitterId { get; set; } = "";
|
||||||
|
public string Dob { get; set; } = "";
|
||||||
|
public string MotherName { get; set; } = "";
|
||||||
|
public string FatherName { get; set; } = "";
|
||||||
|
public string WsCode { get; set; } = "";
|
||||||
|
public string Note { get; set; } = "";
|
||||||
|
}
|
||||||
|
|
||||||
|
public sealed class DocxAnimal
|
||||||
|
{
|
||||||
|
public string WsCode { get; set; } = "";
|
||||||
|
public string LitterDob { get; set; } = "";
|
||||||
|
public string Name { get; set; } = "";
|
||||||
|
public string Farbschlag { get; set; } = "";
|
||||||
|
public string Gender { get; set; } = "";
|
||||||
|
public string Owner { get; set; } = "";
|
||||||
|
public string AbgabeDate { get; set; } = "";
|
||||||
|
public string AbgabeWeight { get; set; } = "";
|
||||||
|
public string DeathDate { get; set; } = "";
|
||||||
|
public string DeathCause { get; set; } = "";
|
||||||
|
public string PartnerName { get; set; } = "";
|
||||||
|
public string PartnerDob { get; set; } = "";
|
||||||
|
}
|
||||||
|
|
||||||
|
// ---- Report ----
|
||||||
|
|
||||||
|
public sealed record ImportDocxReport(
|
||||||
|
bool Executed,
|
||||||
|
int LitterLinked,
|
||||||
|
int OwnerLinked,
|
||||||
|
int GoHomeFilled,
|
||||||
|
int DeathFilled,
|
||||||
|
int ContactsCreated,
|
||||||
|
int Skipped,
|
||||||
|
IReadOnlyList<string> Notes);
|
||||||
|
}
|
||||||
@@ -98,6 +98,7 @@ app.MapInbreedingEndpoints();
|
|||||||
app.MapPhotoEndpoints();
|
app.MapPhotoEndpoints();
|
||||||
app.MapSaleAdEndpoints();
|
app.MapSaleAdEndpoints();
|
||||||
app.MapImportEndpoints();
|
app.MapImportEndpoints();
|
||||||
|
app.MapImportDocxEndpoints();
|
||||||
app.MapContractEndpoints();
|
app.MapContractEndpoints();
|
||||||
app.MapSettingsEndpoints();
|
app.MapSettingsEndpoints();
|
||||||
app.MapExportEndpoints();
|
app.MapExportEndpoints();
|
||||||
|
|||||||
207
HUMANQUESTION.md
207
HUMANQUESTION.md
@@ -2,150 +2,80 @@
|
|||||||
|
|
||||||
> ## ⛔ BITTE DIESE DATEI NICHT SELBST BEARBEITEN
|
> ## ⛔ BITTE DIESE DATEI NICHT SELBST BEARBEITEN
|
||||||
> **Antwortet einfach Michael (dem Assistenten) im Chat** — Stichworte genügen
|
> **Antwortet einfach Michael (dem Assistenten) im Chat** — Stichworte genügen
|
||||||
> („C1: ja", „A1: hier der Schlüssel …", „Ella: der erste Genotyp stimmt").
|
> („A3: hier das Passwort …", „PEW = REW: ja"). **Michael pflegt diese Datei**
|
||||||
> **Michael pflegt diese Datei** und streicht jede Frage, sobald sie beantwortet
|
> und streicht jede Frage, sobald sie beantwortet ist. So steht hier immer nur
|
||||||
> ist. So steht hier immer nur das, was **noch offen** ist. Nichts geht verloren —
|
> das, was **noch offen** ist. Nichts geht verloren.
|
||||||
> alles wartet geduldig, bis ihr antwortet.
|
|
||||||
|
|
||||||
_Stand: 2026-06-06._
|
_Stand: 2026-06-07. **Alle Genetik- und Konflikt-Fragen sind beantwortet ✅** (alle
|
||||||
|
32 Konflikt-Tiere entschieden). Die KI-Funktionen sind **live und kostenlos**. Der
|
||||||
Der Manager ist fertig und läuft. Die alten Daten sind importiert
|
große finale Re-Import (mit allen 41 Stammbäumen + Wurfchronik) steht startbereit.
|
||||||
(**865 Würfe + 325 Tiere + 138 Fotos** sind drin, Stand Re-Import #2.5). Mehrere
|
Offen sind nur noch ein paar **technische Zugänge** und etwas **optionaler
|
||||||
KI-Funktionen sind **fertig gebaut, schlafen aber**, bis ein Gemini-Schlüssel
|
Feinschliff** — siehe unten._
|
||||||
hinterlegt ist. Jede offene Frage unten zeigt, **was dadurch blockiert ist**.
|
|
||||||
|
|
||||||
---
|
---
|
||||||
|
|
||||||
## A. Für Julian — Konten, Schlüssel, Technik
|
## A. Zugänge & Technik (für Julian)
|
||||||
|
|
||||||
| # | Was gebraucht wird | Wofür / was es freischaltet | Blockiert gerade |
|
| # | Was gebraucht wird | Schaltet frei |
|
||||||
|---|---|---|---|
|
|---|---|---|
|
||||||
| ~~A1~~ | ✅ **ERLEDIGT (2026-06-07): Gemini-Key hinterlegt** (user-secrets, nie committed) + LIVE verifiziert — Verkaufstext-Endpunkt generiert echten Text. KI-Verkaufstexte + Charakterbogen-KI sind **live**. (Namensgenerator live sobald Backend gemerged; Posteingang braucht zusätzlich A3 Gmail; Web-Chat-Editor wenn gebaut.) | — | — |
|
| **A3** | **Gmail App-Passwort.** Google-Konto → 2-Faktor aktivieren → „App-Passwörter" → eines für „GerbilManager" → 16-stelligen Code an Michael. | E-Mail-Posteingang (Anfragen abrufen + KI-Antwortentwürfe). Backend ist fertig, wartet nur auf den Zugang. |
|
||||||
| ~~A2~~ | ✅ **ERLEDIGT (2026-06-07): KOSTENLOS, kein Billing nötig.** `gemini-2.0-flash` hatte kein Free-Kontingent (429), aber **`gemini-flash-latest` funktioniert im Free-Tier** (direkt + live verifiziert). Modell überall darauf umgestellt. Julian bleibt gratis. (Falls je volle Privatsphäre gewünscht: Ollama-Option steht.) | — | — |
|
| **A4** | **Domain-Name** (registriert ✔) + **Cloudflare-Konto & API-Token** (Berechtigung „Cloudflare Pages → Edit"). | Öffentliche Webseite veröffentlichen (Jimdo-Ersatz). Seite ist gebaut. |
|
||||||
| A3 | **Gmail App-Passwort.** Einmalig: Google-Konto → 2-Faktor-Bestätigung aktivieren → „App-Passwörter" → eines für „GerbilManager" erstellen → 16-stelligen Code an Michael. | Posteingang verbinden (Anfragen abrufen + Antworten senden) | E-Mail-Posteingang (live) |
|
| **A5** | **TrueNAS-Restfragen:** (a) SCALE-Version? · (c) eigener Postgres-Container (empfohlen) oder bestehender NAS-Postgres? · (d) Dataset-Pfad für Daten/Backups, Port 80 frei? | Produktiv-Betrieb auf dem NAS (compose ist fertig vorbereitet). |
|
||||||
| A4 | **Domain-Name** (ist registriert ✔) + **Cloudflare-Konto & API-Token** (Berechtigung „Cloudflare Pages → Edit"). | Öffentliche Webseite auf Cloudflare veröffentlichen | Veröffentlichung der neuen Webseite (Ersatz für Jimdo) |
|
| **A5b2** | **2 Gitea-Repo-Secrets** anlegen (Repo → Einstellungen → Actions → Secrets): `REGISTRY_USER` (dein Gitea-Login) + `REGISTRY_TOKEN` (Token mit `write:package`). | CI pusht fertige Docker-Images in die Registry. (Die CI-Tests laufen bereits grün.) |
|
||||||
| A5 | **TrueNAS / Gitea — Restfragen:** ~~(b) Gitea Actions?~~ ✅ **AKTIV seit 06.06. — CI läuft bereits** (Runner registriert, Backend+Frontend-Tests grün auf dem Runner). **NEU (b2): Docker-Push-Job braucht 2 Repo-Secrets** — in Gitea → Repo → Einstellungen → Actions → Secrets bitte `REGISTRY_USER` (dein Gitea-Login) und `REGISTRY_TOKEN` (Token mit `write:package`) anlegen, dann pusht die CI fertige Images in die Registry. Offen bleiben: (a) TrueNAS SCALE-Version? (c) Eigener Postgres-Container (empfohlen) oder bestehender NAS-Postgres? (d) Dataset-Pfad für Daten/Backups, Port 80 frei? | Manager auf dem NAS betreiben (Produktiv + Backups + CI) | NAS-Deployment (compose fertig; CI ✅ live) |
|
|
||||||
|
|
||||||
## B. Für Julian — kleine Aktionen (jederzeit)
|
## B. Kleine Aktion (jederzeit)
|
||||||
|
|
||||||
| # | Aktion | Warum |
|
| # | Aktion | Warum |
|
||||||
|---|---|---|
|
|---|---|---|
|
||||||
| B1 | **`git pull` + App neu starten** auf der laufenden Instanz | Holt den **Such-Fix** + neue Felder (Herkunft-Filter, unscharfe Suche, Charakterbogen). Die laufende Instanz ist sonst auf altem Stand. |
|
| **B2** | **Firewall-Regel** (PowerShell **als Administrator**): `New-NetFirewallRule -DisplayName "GerbilManager dev" -Direction Inbound -Action Allow -Protocol TCP -LocalPort 5173,5179 -Profile Any` | Damit das Handy deiner Frau im WLAN auf die App kommt (http://192.168.2.124:5173). |
|
||||||
| B2 | **Firewall-Regel** (PowerShell **als Administrator**): `New-NetFirewallRule -DisplayName "GerbilManager dev" -Direction Inbound -Action Allow -Protocol TCP -LocalPort 5173,5179 -Profile Any` | Damit das Handy deiner Frau im WLAN auf die App kommt. |
|
|
||||||
| B3 | **2 Test-Einträge löschen:** „Testmaus E2E…" und „Wurf E2E…" | Übrig gebliebene Test-Einträge aus der Qualitätssicherung. |
|
|
||||||
|
|
||||||
---
|
## C. Genetik-Feinschliff (optional, blockiert nichts)
|
||||||
|
|
||||||
## C. Für die Züchterin — Genetik-Schreibweise & Import-Prüfung
|
| # | Frage | Betrifft |
|
||||||
|
|
||||||
Diese Antworten laden die **restlichen importierten Daten** nach (die unten
|
|
||||||
gelisteten Konflikt-Tiere + Tiere mit Sonder-Kürzeln warten in Quarantäne —
|
|
||||||
**nichts ist verloren**; sobald geklärt, werden sie automatisch nachgeladen).
|
|
||||||
|
|
||||||
| # | Frage | Blockiert |
|
|
||||||
|---|---|---|
|
|---|---|---|
|
||||||
| ~~C1~~ | ✅ **BEANTWORTET** (2026-06-06): `Uw`=`G` (internationale Schreibweise, groß=groß/klein=klein) · `Sls`=`WP` (eine Scheckungsart) · `DP`=Darkpatch (Scheckungsart) · `Dea`=hörend / `dea`=`taub` (Hörfähigkeit, hängt von der Scheckung ab, steht nach `spsp`) · `WFNZ`=Wildfangnachzucht (keine rezessiven Gene) · `RV`=Rückverpaarung · `GV`=Geschwisterverpaarung (RV/GV = Zuchtmethode, kein Gencode). → Michael baut das ein; **damit lösen sich die 5 Konflikte in Abschnitt D2 von selbst** (Gg ≡ Uwuw). | — erledigt |
|
| **REW-1** | **PEW = REW?** „Pink Eyed White" (PEW) und „Rotaugenweiß" (REW) sind dasselbe — soll der alte PEW-Eintrag mit REW **zusammengeführt** werden? | Doppel-Eintrag im Farbkatalog. |
|
||||||
| ~~C2~~ | ✅ **BEANTWORTET** (2026-06-06): Ja — **`-` = „Allel unbekannt"** (z. B. `D-` = ein D-Allel unbekannt). Wird beim Import als `?`-Platzhalter übernommen. | — erledigt |
|
| **REW-2** | **REW bei nicht-agouti?** Wird ein `aa`-Tier (z. B. Marder) mit Colourpoint + `pp` **auch** als REW gewertet, oder soll REW nur für agouti-basierte Tiere gelten? | REW-Erkennung (wird gerade A-unabhängig gebaut = aa zählt mit). |
|
||||||
| ~~C3~~ | ✅ **BEANTWORTET** (2026-06-06): Ja, automatisch zusammenführen — **aber nur wenn auch der Zuchtname gleich ist** (Name + Geburtsdatum + Zuchtname = dasselbe Tier). Wird in die Dedup-Regel eingebaut. (Hinweis: der Extraktor fand bisher 0 Fälle mit gleichem Name+Datum aber verschiedenem Zuchtnamen, also ändert sich an den bestehenden Zusammenführungen nichts — die Regel ist die Absicherung.) | — erledigt |
|
| **C7** | *(optional)* Was hat deiner Frau bei **Renner Pro** gefehlt? Lieblings-Auswertungen? | mögliche neue Funktionen |
|
||||||
| ~~C4~~ | ✅ **BEANTWORTET** (2026-06-06): Ja, **Wurfchronik Teil 2 existiert** — wird gerade überarbeitet, kommt später. Der Importer ist pro Datei wiederholbar (idempotent), also einfach die Datei schicken, sobald fertig → Michael importiert sie nach (keine Doppelungen). | ⏳ Datei folgt, wenn überarbeitet |
|
|
||||||
| ~~C5~~ | ✅ **BEANTWORTET** (2026-06-06): **Es gibt KEIN „Schwarzschimmel"** — das war ein Fehler in unserem Katalog. Die korrekten Schimmelarten: `efef` → **Orangeschimmel** · `efef pp` → **Rotaugenschimmel** · `efef gg` → **Silberschimmel** · Kombis z. B. `c[chm]c[chm] efef` → **CP-Orangeschimmel**. Michael korrigiert den Katalog (Schwarzschimmel raus, efef = Orangeschimmel). | — erledigt |
|
|
||||||
| C6 | **FAST ERLEDIGT** (Stand 06.06. nachmittags): von den ursprünglich 32 Konflikt-Tieren sind **27 geklärt + geladen** (deine D1–D5-Antworten + Beibehalten-Regel + „genauer gewinnt"-Regel). **Offen sind nur noch die 5 Tiere in D6**: Hanami (Sterbedatum), Big Ben (PP↔Pp), Vance Jr. (Spsp↔spsp), Kazu (3 Loci), Skarlett (Sterbedatum). | nur diese 5 warten noch auf den Import |
|
|
||||||
| C7 | *(optional)* Was hat dir bei **Renner Pro** gefehlt? Lieblings-Auswertungen? | mögliche neue Funktionen |
|
|
||||||
| ~~C8~~ | ✅ **BEANTWORTET** (2026-06-06): **Himalaya gibt es** — Himalaya = **`A- c[h]c[h]`** (agouti), Hermelin = **`aa c[h]c[h]`** (nicht-agouti). Beide bleiben im Katalog; die Engine unterscheidet bereits korrekt nach A-/aa. — erledigt |
|
|
||||||
| ~~C9~~ | ✅ **BEANTWORTET** (2026-06-06): **„CP-Fuchs" ist ein Sammelbegriff** — bei diesen Tieren ist unklar, ob es CP-Polarfuchs, CP-Algierfuchs, CP-Kohlfuchs oder CP-Blaufuchs ist (Tiere sind schneeweiß mit schwarzen Augen; Verpaarungen haben die Gene nicht verraten). Bekannt ist nur: **„CP-Fuchs" = `c[chm]c[chm]`**, **„CP-Fuchs hell" = `c[chm]c[h]`**. **Generelle Regel: das Wort „hell" im Farbschlag-Namen bedeutet immer, dass ein `c[h]` im Gencode steckt** (also `c[chm]c[h]`); ohne „hell" = `c[chm]c[chm]`. Die „-Hell"-Vermutung war richtig ✓; Engine-Update beauftragt (GEN-3g): bei unbekannten Unterscheidungs-Loci bleibt der Sammelbegriff „CP-Fuchs" korrekt. — erledigt |
|
|
||||||
|
|
||||||
### Hinweis zu C5 — woher kam das falsche „Schwarzschimmel"? (wie gewünscht notiert)
|
## E. Charakterbogen-Eigenschaften (optional)
|
||||||
„Schwarzschimmel" stammt aus **unserem ursprünglichen Farbkatalog** `gerbil-manager-web/src/genetics/catalog.ts` (Genotyp `efef`), den wir ganz am Anfang aus den deutschen Genetik-Quellen (de.wikibooks „Schwarze Augen", rennmauswelten, clan-of-topolino) aufgebaut hatten. Von dort kam es in die DB-Seed-Liste + Stammbaum-Farbchips. → Wird in GEN-3 korrigiert: Schwarzschimmel entfernt, `efef` = Orangeschimmel. *(Falls du der Quelle Bescheid geben willst: es ist die de.wikibooks-Farbgenetik-Seite.)*
|
|
||||||
|
|
||||||
---
|
Aktuell eingebaute Häkchen-Eigenschaften (für die KI-Verkaufstexte) — **soll etwas ergänzt/gestrichen werden?**
|
||||||
|
|
||||||
## D. Die 32 Konflikt-Tiere (gleicher Name + Datum, aber widersprüchliche Angaben in mehreren Dateien)
|
|
||||||
|
|
||||||
> ✅ **STAND nach Re-Import #2.5 (06.06.2026):** Alle bisher beantworteten Konflikte sind **live geladen** (u. a. Victoria Welby: **„C" hat jetzt beide Eltern** ✔). Enya, Ella und Zac wurden inzwischen ebenfalls **automatisch geladen** („genauer gewinnt"-Regel: `CC` schlägt `C-`) → jetzt **325 Tiere** drin, 161 Eltern-Links nachgetragen. **Wirklich offen sind nur noch die 5 Tiere in D6 unten.**
|
|
||||||
|
|
||||||
Bitte je Tier kurz sagen, **welche Angabe stimmt**. Gruppiert nach Konflikt-Art.
|
|
||||||
Alle Details (sämtliche Genotyp-Varianten + Quelldateien): `tools/import/output/review-report.md`.
|
|
||||||
|
|
||||||
### D1 · Im Farbschlag-Feld steht versehentlich ein **Tiername** (Tippfehler) — welcher Farbschlag stimmt wirklich?
|
|
||||||
> ✅ **GEKLÄRT (Julian, 2026-06-06):** Ursache gefunden — **ab Spalte K** im Stammbaum stehen pro Tier nur Name / Datum / **Gencode** (KEINE Farbangabe). Der Importer hatte dort fälschlich die Nachbarzelle (z. B. den Namen des nächsten Tiers wie „Tennessee", oder eine Notiz wie „DD-Tumor") als Farbschlag gelesen. **Fix ist beauftragt:** in den tiefen Spalten wird kein Farbschlag mehr ausgelesen, die **Farbe wird aus dem Gencode berechnet**; in den frühen Spalten (Proband/Eltern) bleibt der echte Farbschlag erhalten (z. B. Chesnut = „Kohlfuchsschimmel"). **Chesnut und Tennessee sind getrennte Tiere** (bestätigt). → Nach dem Fix verschwindet D1 von selbst; **keine Aktion nötig.**
|
|
||||||
|
|
||||||
| Tier | im Farbschlag steht fälschlich | 📂 Stammbaum-Datei zum Nachschauen |
|
|
||||||
|---|---|---|
|
|
||||||
| ZoneFire (*07.12.2020) | „Kalea von den Kleinen Chaoten" | *Stammbaum von Akio Kids* |
|
|
||||||
| Louis v.d. Kleinen Chaoten (*15.07.2017) | „Roswitha…" (+ Genotyp G/Uw, siehe D2) | *(Quelle siehe `review-report.md`)* |
|
|
||||||
| Bruno of Black Forest (*01.06.2022) | „Mystique of Black Forest" (evtl. Blau) | *Stammbaum von Alberto Kids / Fire Kids / Stella Kids* |
|
|
||||||
| Little Runner's Big Ben (*03.02.2020) | „Daja of Little Rose" | *Stammbaum von Goldfuchs Sp (Pikachu) Kids* |
|
|
||||||
| Vance Jr. v.d. Kleinen Chaoten (*10.04.2022) | „Velvet…" (evtl. Kohlfuchs, hell) | *Stammbaum von Fire Kids / Stella Kids* |
|
|
||||||
| Trogir v.d. Kleinen Chaoten (*21.03.2022) | „Mahima…" (evtl. Gold Ansatzschecke) | *Stammbaum von Goldfuchs Sp (Pikachu) Kids / Kohlief, Goldfuchsef Sp von Chrissi / Watarus Kids* |
|
|
||||||
| Chayton v.d. Kleinen Chaoten (*04.02.2022) | „Victoria Welby…" (evtl. Orangeschimmel, hell) | *Stammbaum von Goldfuchs Sp (Pikachu) Kids / Kohlief, Goldfuchsef Sp von Chrissi / Watarus Kids* |
|
|
||||||
| Zac gen. Action v.d. Kleinen Chaoten (*25.12.2020) | „Belica gen. Emi…" | *Stammbaum von Goldfuchs Sp (Pikachu) Kids / Kohlief, Goldfuchsef Sp von Chrissi / Watarus Kids* |
|
|
||||||
| Chesnut (*13.11.2019) | „Tennessee…" (evtl. Kohlfuchsschimmel) | *Stammbaum von Kentucky* |
|
|
||||||
| Ethan v.d. Kleinen Chaoten (*09.07.2020) | „Ichika…" (evtl. Orangeschimmel hell Kragenschecke) | *(Quelle siehe `review-report.md`)* |
|
|
||||||
| Quied Soldier of Black Forest (*07.06.2018) | „Hoshi…" | *Stammbaum von Kentucky* |
|
|
||||||
|
|
||||||
### ~~D2~~ · ✅ GELÖST durch C1: `Uw`=`G` — diese 5 sind KEINE echten Konflikte, werden automatisch geladen, sobald Michael die Uw=G-Regel eingebaut hat
|
|
||||||
~~Ella · Roswitha · Silenos gen. Adonis · Brandon Stark · Enya~~ (erledigt)
|
|
||||||
|
|
||||||
### D3 · Genotyp: **kleine Abweichung** (eine Quelle genauer als die andere — `DD`↔`D-`, `PP`↔`P-`, `Ee`↔`E`, mit/ohne `spsp`) — welche stimmt?
|
|
||||||
Bitte je Tier sagen, **welcher Wert stimmt** (die Quellen widersprechen sich beim genannten Locus). Alle Varianten: `review-report.md`.
|
|
||||||
|
|
||||||
| Tier | Konkreter Konflikt — was stimmt? | Status |
|
|
||||||
|---|---|---|
|
|
||||||
| Firefly v.d. K.C. (*18.12.2019) | D-Locus: **D-** ↔ **DD** | ✅ **D-** (DD war Tippfehler) — Julian |
|
|
||||||
| WildFire v.d. K.C. (*05.10.2017) | P-Locus: **P-** ↔ **PP** | ✅ **PP** — Julian |
|
|
||||||
| Zuleika v.d. K.C. (*24.10.2015) | D-Locus: **D-** ↔ **DD** | ✅ **DD, Ee, Gg, PP** (`aa c[chm]c[h] DD Ee Gg PP spsp`) — Julian |
|
|
||||||
| Milka of LennyLengo (*09.12.2018) | C-Locus: **C-** ↔ **Cc[h]** · E-Locus: **E-** ↔ **EE** | ✅ **Cc[h], EE** (`aa Cc[h] dd EE Gg P- Spsp`) — Julian |
|
|
||||||
| Silvain v.d. K.C. (*27.03.2022) | E-Locus: **Ee** ↔ **ee** · P-Locus: **P-** ↔ **Pp** | ✅ **ee, Pp** (`aa c[chm]c[chm] Dd ee[-] Gg Pp Spsp`) — Julian |
|
|
||||||
| Ichika v.d. K.C. (*19.04.2020) | E-Locus: **ee** ↔ **ee[f]** | ✅ **ee[f]** (Beibehalten-Regel: `[f]` war vorhanden) — Julian |
|
|
||||||
| Daja of Little Rose (*16.05.2021) | Scheckung: **mit `spsp`** ↔ **ohne** | ✅ **mit `spsp`** (Beibehalten-Regel) — Julian |
|
|
||||||
| Chelsea v.d. K.C. | ⚠️ **Kein Genotyp-Konflikt** — zwei „Chelsea" mit verschiedenem Datum (\*02.04.2021 / \*15.10.2021) | ✅ **ein Tier, Geburtsdatum 02.04.2021** (15.10.2021 war falsch → zusammengeführt) — Julian |
|
|
||||||
|
|
||||||
### D4 · **Marker** unterschiedlich (`WP` / `DP` / `WFNZ` / „hörend" mal vorhanden, mal nicht) — welcher gilt?
|
|
||||||
> ✅ **REGEL (Julian 2026-06-06):** „Wenn irgendwo etwas vorhanden war, das anderswo fehlte → **immer beibehalten**." Gilt generell für Marker/Flags und Angaben wie `spsp` oder `[f]` (Vorhandensein gewinnt über Fehlen). Wird zur Standard-Regel im Importer → löst alle „mit/ohne"-Fälle automatisch (z. B. Daja `spsp`, Ichika `[f]`). Greift NICHT bei echten Wert-Widersprüchen (z. B. `DD`↔`D-`, `Ee`↔`ee`) — die brauchen weiter deine Entscheidung.
|
|
||||||
>
|
|
||||||
> ℹ️ Bei D4 waren die Marker `WP`/`DP`/`WFNZ`/`hörend` in BEIDEN Quellen gleich — also **gar nicht** der Konflikt (und jetzt sowieso Flags). Der echte Konflikt ist beim Genotyp. **3 von 5 dadurch automatisch gelöst:**
|
|
||||||
|
|
||||||
| Tier | Konkreter Konflikt — was stimmt? | Status |
|
|
||||||
|---|---|---|
|
|
||||||
| Vestra von den Schlossmäusen (*08.02.2019) | D-Locus: **D-** ↔ **DD** (WP gleich in beiden) | ✅ **DD** — Julian |
|
|
||||||
| Victoria Welby gen. Welby v.d. K.C. (*16.01.2023) | E-Locus: **Ee[f]** ↔ **ee[f]** — **Mutter von „C"!** | ✅ **ee[f]** — Julian → **geladen, C hat jetzt beide Eltern** (Re-Import #2) |
|
|
||||||
| Hedwig of BGB (*30.10.2019) | (WP/DP/hörend) | ✅ auto-gelöst — sind jetzt Flags, kein Konflikt mehr |
|
|
||||||
| Pitari gen. Piti v.d. K.C. (*16.05.2021) | (DP) | ✅ auto-gelöst — DP ist jetzt ein Flag |
|
|
||||||
| Little Hero of Black Forest (*22.02.2018) | (WFNZ ± spsp) | ✅ kein Genotyp-Konflikt mehr (WFNZ = Flag) |
|
|
||||||
|
|
||||||
### D5 · **Sterbedatum** widersprüchlich
|
|
||||||
| Tier | Problem |
|
|
||||||
|---|---|
|
|
||||||
| ~~Flint v.d. Kleinen Chaoten (*23.12.2017)~~ | ✅ **Tod 10.05.2021** (2022 war Tippfehler) — Julian 2026-06-06 |
|
|
||||||
| Hanami v.d. Kleinen Chaoten (*10.09.2015) | Tod 12.12.2019 vs. 14.01.2020 |
|
|
||||||
| ~~Molly of Black Forest (*13.09.2021)~~ | ✅ **Tod 03.05.2022** (03.05.2021 war Jahr-Tippfehler → lag vor der Geburt) — Julian 2026-06-06 |
|
|
||||||
|
|
||||||
*(Das sind 32 Tiere: 11 + 5 + 8 + 5 + 3.)*
|
|
||||||
|
|
||||||
### D6 · **Die letzten 5 offenen Konflikte** (Stand Re-Import #2) — bitte entscheiden
|
|
||||||
| Tier | Konkreter Konflikt — was stimmt? |
|
|
||||||
|---|---|
|
|
||||||
| Hanami v.d. K.C. (*10.09.2015) | Sterbedatum: **12.12.2019** ↔ **14.01.2020** (= D5) |
|
|
||||||
| ~~Little Runner's Big Ben (*03.02.2020)~~ | ✅ **Pp** (P-Locus) — Julian 2026-06-07 → in conflict-decisions.json |
|
|
||||||
| ~~Vance Jr. v.d. K.C. (*10.04.2022)~~ | ✅ **spsp** (ungescheckt) — Julian 2026-06-07 → in conflict-decisions.json |
|
|
||||||
| ~~Kazu v.d. K.C. (*23.04.2013)~~ | ✅ **ee[f] · GG · PP** — Julian 2026-06-07 → in conflict-decisions.json |
|
|
||||||
| ~~Skarlett v.d. K.C. (*14.07.2013)~~ | ✅ **Sterbedatum 17.04.2016** — Julian 2026-06-07 → in conflict-decisions.json |
|
|
||||||
|
|
||||||
*(Enya, Ella und Zac fehlen hier bewusst: deren Abweichung ist nur „unbekannt ↔ genau angegeben" — löst der Importer automatisch mit der „genauer gewinnt"-Regel.)*
|
|
||||||
|
|
||||||
---
|
|
||||||
|
|
||||||
## E. Charakterbogen — Eigenschaften-Liste (für die KI-Verkaufstexte)
|
|
||||||
|
|
||||||
Aktuell eingebaute Häkchen-Eigenschaften (jede ist leicht änderbar). **Bitte
|
|
||||||
sagen, was ergänzt oder gestrichen werden soll:**
|
|
||||||
|
|
||||||
> zutraulich · handzahm · neugierig · aufgeschlossen · ruhig/ausgeglichen ·
|
> zutraulich · handzahm · neugierig · aufgeschlossen · ruhig/ausgeglichen ·
|
||||||
> lebhaft/aktiv · verschmust · eigenständig · anfängergeeignet · futterfreudig ·
|
> lebhaft/aktiv · verschmust · eigenständig · anfängergeeignet · futterfreudig ·
|
||||||
> buddelt gern · klettert gern · läuft gern im Laufrad · gut verträglich · schreckhaft
|
> buddelt gern · klettert gern · läuft gern im Laufrad · gut verträglich · schreckhaft
|
||||||
|
|
||||||
- **E1** — Eigenschaften hinzufügen/entfernen? (z. B. *dominant, rangniedrig, für erfahrene Halter, einzelgängerisch* …?)
|
- **E1** — Eigenschaften hinzufügen/entfernen? (z. B. *dominant, rangniedrig, für erfahrene Halter, einzelgängerisch*?)
|
||||||
- **E2** — Auch **ehrliche „negative" Eigenschaften** aufnehmen (z. B. *schreckhaft, beißt manchmal*) für ehrliche Inserate, oder nur Positives?
|
- **E2** — Auch ehrliche **negative** Eigenschaften aufnehmen (z. B. *beißt manchmal*) für ehrliche Inserate?
|
||||||
|
|
||||||
|
---
|
||||||
|
|
||||||
|
## D7 · Neue Konflikt-Tiere aus den 41 Stammbäumen (bitte entscheiden)
|
||||||
|
|
||||||
|
Durch die vielen neuen Stammbaum-Dateien sind **13 neue Konflikt-Tiere** aufgetaucht (gleicher Name+Datum, widersprüchliche Angaben in mehreren Diagrammen). Sie warten in Quarantäne — **nichts ist verloren**, sie laden automatisch nach, sobald du je Tier kurz sagst was stimmt. (Uw=G + „Vorhandensein gewinnt" sind schon angewendet; das hier ist der echte Rest.)
|
||||||
|
|
||||||
|
**A) Nur Sterbedatum offen** (Gencode einig — bei Osamu/Filou/Sunny zusätzlich „taub" beibehalten):
|
||||||
|
| Tier | Sterbedatum — welches? |
|
||||||
|
|---|---|
|
||||||
|
| Isa of Golden Lights (*24.12.2014) | 21.07.2018 ↔ 21.10.2018 |
|
||||||
|
| Jack II v.d. K.C. (*14.02.2016) | 06.10.2019 ↔ 20.10.2019 |
|
||||||
|
| Osamu v.d. K.C. (*10.12.2015) | 01.10.2020 ↔ 18.12.2020 |
|
||||||
|
| Filou v.d. K.C. (*24.11.2014) | 31.08.2019 ↔ 31.10.2019 |
|
||||||
|
| Sunny von PZ Karl (*10.04.2014) | 30.04.2019 ↔ 05.05.2019 |
|
||||||
|
|
||||||
|
**B) Gencode-Konflikt** (+ ggf. Sterbedatum):
|
||||||
|
| Tier | Konflikt — was stimmt? |
|
||||||
|
|---|---|
|
||||||
|
| Milon v.d. K.C. (*27.11.2014) | A-Locus: **Aa** ↔ **aa** |
|
||||||
|
| Percy of little runners (*16.12.2017) | P-Locus: **PP** ↔ **Pp** |
|
||||||
|
| Iwana of little runners (*02.10.2018) | P-Locus: **PP** ↔ **Pp** |
|
||||||
|
| Sokrates v.d. K.C. (*14.12.2015) | D-Locus: **D-** ↔ **Dd** · + Sterbedatum 20.05.**2019** ↔ **2020** |
|
||||||
|
| Eragon (Elieus, *18.05.2016) | C-Locus: **CC** (vollfarbig) ↔ **c[chm]c[chm]** (Colourpoint) |
|
||||||
|
| Dakota of sweet little mouse (*30.01.2015) | A: **Aa**↔**aa** · P: **pp**↔**PP** · Sp: **Spsp**↔**spsp** |
|
||||||
|
| Kazumi v.d. K.C. (*23.04.2013) | A: **Aa**↔**aa** · G: **GG**↔**Gg** · P: **PP**↔**Pp** · Sp: **Spsp**↔**spsp** |
|
||||||
|
| Max von Privat (*01.02.2013) | D: **D-**↔**DD** · P: **P-**↔**PP** · Sterbedatum (4 Varianten: 04.02.2016 / 04.03.2016 / 2014 / 30.12.2015) |
|
||||||
|
|
||||||
|
*(Alle Gencode-Varianten + Quelldateien: `tools/import/output/review-report.md`.)*
|
||||||
|
|
||||||
---
|
---
|
||||||
|
|
||||||
@@ -153,16 +83,25 @@ sagen, was ergänzt oder gestrichen werden soll:**
|
|||||||
|
|
||||||
| Funktion | Status | Wartet auf |
|
| Funktion | Status | Wartet auf |
|
||||||
|---|---|---|
|
|---|---|---|
|
||||||
| KI-Verkaufstexte (Abgeben) | gebaut, schläft | **A1** (+A2) |
|
| KI-Verkaufstexte · Charakterbogen-KI · Namensgenerator | ✅ **LIVE & kostenlos** (Gemini Free-Tier) | — |
|
||||||
| Charakterbogen → KI-Text | gebaut, schläft | **A1** |
|
| E-Mail-Posteingang (Anfragen) | gebaut | **A3** (Gmail-App-Passwort) |
|
||||||
| Webseiten-Chat-Editor (Gemini) | in Arbeit | **A1** + Webseiten-Phasen |
|
| Öffentliche Webseite + KI-Chat-Editor | gebaut | **A4** (Domain + Cloudflare) |
|
||||||
| Öffentliche Webseite live | in Arbeit | **A4** (Domain + Cloudflare) |
|
| NAS-Produktiv-Deployment + Docker-Push | vorbereitet, CI grün | **A5** + **A5b2** |
|
||||||
| E-Mail-Posteingang (Anfragen) | in Arbeit | **A3** (App-Passwort) + **A1/A2** für Entwürfe |
|
|
||||||
| NAS-Deployment / Produktiv | fertig vorbereitet | **A5** |
|
|
||||||
| Restliche importierte Tiere (Konflikte) | nur noch 5 in Quarantäne (Re-Import #2.5 ✅, Enya/Ella/Zac geladen) | **D6** (5 Entscheidungen) |
|
|
||||||
| Handy-Zugriff im WLAN | App läuft | **B2** (Firewall) |
|
| Handy-Zugriff im WLAN | App läuft | **B2** (Firewall) |
|
||||||
|
| Alle importierten Konflikt-Tiere | ✅ **alle 32 entschieden** | finaler Re-Import (startbereit, läuft demnächst) |
|
||||||
|
|
||||||
---
|
---
|
||||||
|
|
||||||
*Einfach abschnittsweise antworten — Michael arbeitet die Antworten ein, streicht
|
## ✅ Erledigt (Archiv — nichts geht verloren)
|
||||||
sie hier und meldet, was dadurch live geht.*
|
|
||||||
|
- **A1 / A2 — Gemini-Key + Kosten:** Schlüssel hinterlegt (sicher, nie im Code); **kostenlos** über `gemini-flash-latest` (Free-Tier), kein Billing nötig. → KI live verifiziert.
|
||||||
|
- **B1 — Neustart nach Updates:** Michael startet die lokale Instanz jetzt **automatisch** nach jedem neuen Feature. Keine Aktion mehr nötig.
|
||||||
|
- **B3 — 2 Test-Einträge ("Testmaus/Wurf E2E"):** verschwinden automatisch beim finalen Re-Import (Wipe + Neuaufbau).
|
||||||
|
- **C1–C9 — Genetik-Schreibweise:** alles geklärt (Uw=G · „-"=Allel unbekannt · Dedup nach Name+Datum+Zucht · Schimmel-Arten · Himalaya/Hermelin · „CP-Fuchs"-Sammelbegriff + „hell"=`c[h]` · Dilute-Präfix · REW-Regel).
|
||||||
|
- **D1–D6 — alle 32 Konflikt-Tiere:** entschieden und in `tools/import/conflict-decisions.json` hinterlegt (werden beim finalen Re-Import alle geladen).
|
||||||
|
|
||||||
|
*Details der erledigten Punkte stehen in der git-Historie und in `tools/import/conflict-decisions.json`.*
|
||||||
|
|
||||||
|
---
|
||||||
|
|
||||||
|
*Einfach abschnittsweise antworten — Michael arbeitet die Antworten ein und meldet, was dadurch live geht.*
|
||||||
|
|||||||
@@ -54,6 +54,23 @@ test('unbekanntes Tier zeigt den deutschen Nicht-gefunden-Zustand', async ({ pag
|
|||||||
await expect(page.getByText(t.notFound).or(page.getByText(de.api.errors.notFound))).toBeVisible()
|
await expect(page.getByText(t.notFound).or(page.getByText(de.api.errors.notFound))).toBeVisible()
|
||||||
})
|
})
|
||||||
|
|
||||||
|
test('Ahnen-Namen sind Links zur Tier-Detailseite (STAMMBAUM-OPEN)', async ({ page }) => {
|
||||||
|
skipUnlessMock()
|
||||||
|
await page.goto('/rennmaeuse/kruemel/stammbaum')
|
||||||
|
await expect(page.locator('.pedigree-card').first()).toBeVisible()
|
||||||
|
|
||||||
|
// Fridolin ist Vater von Krümel — sein Name-Link soll /rennmaeuse/fridolin öffnen
|
||||||
|
const nameLink = page.getByRole('link', { name: 'Fridolin' })
|
||||||
|
await expect(nameLink).toBeVisible()
|
||||||
|
// href korrekt gesetzt
|
||||||
|
await expect(nameLink).toHaveAttribute('href', '/rennmaeuse/fridolin')
|
||||||
|
// Tastatur-Navigation (umgeht Toolbar-Überlappung im SVG-Canvas, testet zugl. Accessibility)
|
||||||
|
await nameLink.focus()
|
||||||
|
await page.keyboard.press('Enter')
|
||||||
|
await expect(page.getByRole('heading', { name: 'Fridolin' })).toBeVisible()
|
||||||
|
await expect(page).toHaveURL(/\/rennmaeuse\/fridolin$/)
|
||||||
|
})
|
||||||
|
|
||||||
test('Namenloser Ahne zeigt Platzhalter in der Stammbaum-Karte (UI-POLISH-2)', async ({ page }) => {
|
test('Namenloser Ahne zeigt Platzhalter in der Stammbaum-Karte (UI-POLISH-2)', async ({ page }) => {
|
||||||
skipUnlessMock()
|
skipUnlessMock()
|
||||||
await page.goto('/rennmaeuse/nameless-stub/stammbaum')
|
await page.goto('/rennmaeuse/nameless-stub/stammbaum')
|
||||||
|
|||||||
@@ -43,16 +43,29 @@ export default function BreedingResultView({ result, title }: BreedingResultView
|
|||||||
) : (
|
) : (
|
||||||
<>
|
<>
|
||||||
<ul className="farbschlag-cards">
|
<ul className="farbschlag-cards">
|
||||||
{result.byFarbschlag.map((f) => (
|
{result.byFarbschlag.map((f) => {
|
||||||
<li key={f.farbschlag} className="farbschlag-card">
|
// Representative genotype: highest-prob offspring for this farbschlag.
|
||||||
<FarbschlagImage name={f.farbschlag} />
|
const repGenotype = result.offspring.find(
|
||||||
<span className="farbschlag-card__name">{f.farbschlag}</span>
|
(o) => o.farbschlag === f.farbschlag,
|
||||||
<span className="farbschlag-card__prob">
|
)?.genotype
|
||||||
{f.probability.percent}
|
return (
|
||||||
<small> ({f.probability.text})</small>
|
<li key={f.farbschlag} className="farbschlag-card">
|
||||||
</span>
|
<div className="farbschlag-card__img">
|
||||||
</li>
|
<FarbschlagImage name={f.farbschlag} />
|
||||||
))}
|
</div>
|
||||||
|
<div className="farbschlag-card__body">
|
||||||
|
<span className="farbschlag-card__name">{f.farbschlag}</span>
|
||||||
|
{repGenotype && (
|
||||||
|
<code className="farbschlag-card__geno">{repGenotype}</code>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
<span className="farbschlag-card__prob">
|
||||||
|
{f.probability.percent}
|
||||||
|
<small> ({f.probability.text})</small>
|
||||||
|
</span>
|
||||||
|
</li>
|
||||||
|
)
|
||||||
|
})}
|
||||||
</ul>
|
</ul>
|
||||||
|
|
||||||
<button
|
<button
|
||||||
|
|||||||
@@ -179,17 +179,21 @@ describe('Farbschlag catalog', () => {
|
|||||||
expect(match.name).toBe('Unbekannter Farbschlag')
|
expect(match.name).toBe('Unbekannter Farbschlag')
|
||||||
})
|
})
|
||||||
|
|
||||||
it('has the expected catalogue coverage (GEN-3g: 66 after adding CP-*-Hell het variants)', () => {
|
it('has the expected catalogue coverage (GEN-4: 70 after adding 4 dilute-fox entries)', () => {
|
||||||
// GEN-3f: 73 -> 61 (cchm CP reconciliation).
|
// GEN-3f: 73 -> 61. GEN-3g: +5 -> 66. GEN-4: +4 (Dilute Algierfuchs/Goldfuchs/Rotfuchs/Polarfuchs) -> 70.
|
||||||
// GEN-3g: +5 het variants (CP-Agouti/Silberagouti/Algierfuchs/Polarfuchs/Orangeschimmel -Hell),
|
expect(CATALOG_SIZE).toBe(70)
|
||||||
// giving 61 + 5 = 66. CP-Fuchs-Hell was already counted.
|
|
||||||
expect(CATALOG_SIZE).toBe(66)
|
|
||||||
})
|
})
|
||||||
|
|
||||||
it('frozen contract names round-trip to themselves (DB-key guard)', () => {
|
it('frozen contract names round-trip to themselves (DB-key guard)', () => {
|
||||||
// The first 18 are the frozen ColorVariety keys — their representative
|
// The first 18 are the frozen ColorVariety keys — their representative
|
||||||
// genotype MUST resolve back to their own name, never a later variety.
|
// genotype MUST resolve back to their own name, never a later variety.
|
||||||
|
// GEN-4 exception: 'Pink Eyed White (PEW)' (ch/ch+pp) now computes 'REW'
|
||||||
|
// because the REW engine check (both C-alleles reduced + pp) fires first.
|
||||||
|
// PEW stays in the catalog as a user-pickable import name; its computed
|
||||||
|
// farbschlag is intentionally 'REW' per Julian's extended rule.
|
||||||
|
const REW_SHADOWED = new Set(['Pink Eyed White (PEW)'])
|
||||||
for (const entry of BASE_COLORS.slice(0, FROZEN_COUNT)) {
|
for (const entry of BASE_COLORS.slice(0, FROZEN_COUNT)) {
|
||||||
|
if (REW_SHADOWED.has(entry.name)) continue
|
||||||
expect(genotypeToFarbschlag(representativeGenotype(entry))).toBe(entry.name)
|
expect(genotypeToFarbschlag(representativeGenotype(entry))).toBe(entry.name)
|
||||||
}
|
}
|
||||||
})
|
})
|
||||||
@@ -373,9 +377,11 @@ describe("GEN-3c: unknown allele displays as '-' (stored as '?')", () => {
|
|||||||
})
|
})
|
||||||
|
|
||||||
describe('GEN-3c: no Unbekannt when the E locus is known (family fallback)', () => {
|
describe('GEN-3c: no Unbekannt when the E locus is known (family fallback)', () => {
|
||||||
it('eef with unknown other loci -> Fuchsschimmel (the reported bug case)', () => {
|
it('eef with unknown other loci -> specific Schimmel variety (GEN-4: Fuchsschimmel is a category)', () => {
|
||||||
|
// GEN-4: locusToken ef/e -> 'ef' enables catalog match; family fallback 'Fuchsschimmel' blocked.
|
||||||
|
// aa + ef/e + C/D/G/P resolved via GEN-3d -> Kohlfuchsschimmel (A:a, C:C, D:D, E:ef, G:G, P:P).
|
||||||
expect(genotypeToFarbschlag(fromDisplayString('aa C- D- eef Gg Pp spsp --'))).toBe(
|
expect(genotypeToFarbschlag(fromDisplayString('aa C- D- eef Gg Pp spsp --'))).toBe(
|
||||||
'Fuchsschimmel',
|
'Kohlfuchsschimmel',
|
||||||
)
|
)
|
||||||
})
|
})
|
||||||
it('ee -> Fuchs family, efef -> a Schimmel (never Unbekannt) even with unknowns', () => {
|
it('ee -> Fuchs family, efef -> a Schimmel (never Unbekannt) even with unknowns', () => {
|
||||||
@@ -401,9 +407,11 @@ describe('GEN-3d: dominance tiebreak for unknown loci', () => {
|
|||||||
expect(genotypeToFarbschlag(fromDisplayString('AA CC DD EE GG PP sp- rere'))).toBe('Agouti')
|
expect(genotypeToFarbschlag(fromDisplayString('AA CC DD EE GG PP sp- rere'))).toBe('Agouti')
|
||||||
})
|
})
|
||||||
|
|
||||||
it('still: eef with unknowns -> Fuchsschimmel (family pin unaffected by tiebreak)', () => {
|
it('still: eef with unknowns -> specific variety, not category (GEN-4 update)', () => {
|
||||||
|
// GEN-4: 'Fuchsschimmel' is a Farbart/category; the engine now resolves to the
|
||||||
|
// specific catalog entry (Kohlfuchsschimmel) via the locusToken ef/e -> 'ef' fix.
|
||||||
expect(genotypeToFarbschlag(fromDisplayString('aa C- D- eef Gg Pp spsp --'))).toBe(
|
expect(genotypeToFarbschlag(fromDisplayString('aa C- D- eef Gg Pp spsp --'))).toBe(
|
||||||
'Fuchsschimmel',
|
'Kohlfuchsschimmel',
|
||||||
)
|
)
|
||||||
})
|
})
|
||||||
})
|
})
|
||||||
@@ -421,7 +429,8 @@ describe('GEN-3e: C-locus colourpoint naming', () => {
|
|||||||
expect(name('AA cchmch DD EE gg PP spsp rere')).toBe('CP-Silberagouti-Hell')
|
expect(name('AA cchmch DD EE gg PP spsp rere')).toBe('CP-Silberagouti-Hell')
|
||||||
expect(name('AA cchmch DD ee GG PP spsp rere')).toBe('CP-Algierfuchs-Hell')
|
expect(name('AA cchmch DD ee GG PP spsp rere')).toBe('CP-Algierfuchs-Hell')
|
||||||
expect(name('AA cchmch DD ee gg PP spsp rere')).toBe('CP-Polarfuchs-Hell')
|
expect(name('AA cchmch DD ee gg PP spsp rere')).toBe('CP-Polarfuchs-Hell')
|
||||||
expect(name('AA cchmch dd ee GG PP spsp rere')).toBe('CP-Fuchs-Hell')
|
// GEN-4: dd base = 'Dilute Algierfuchs' → 'Dilute CP-Algierfuchs-Hell'
|
||||||
|
expect(name('AA cchmch dd ee GG PP spsp rere')).toBe('Dilute CP-Algierfuchs-Hell')
|
||||||
})
|
})
|
||||||
|
|
||||||
it('aa fixed colourpoint names (Marder/Siam/Zobel/Zobel-Hell)', () => {
|
it('aa fixed colourpoint names (Marder/Siam/Zobel/Zobel-Hell)', () => {
|
||||||
@@ -471,8 +480,8 @@ describe('GEN-3f: CP catalog reconciled to the breeder CP- naming (matches her l
|
|||||||
expect(name('AA cchmcchm DD EE gg PP spsp rere')).toBe('CP-Silberagouti')
|
expect(name('AA cchmcchm DD EE gg PP spsp rere')).toBe('CP-Silberagouti')
|
||||||
expect(name('AA cchmcchm DD ee GG PP spsp rere')).toBe('CP-Algierfuchs')
|
expect(name('AA cchmcchm DD ee GG PP spsp rere')).toBe('CP-Algierfuchs')
|
||||||
expect(name('AA cchmcchm DD ee gg PP spsp rere')).toBe('CP-Polarfuchs')
|
expect(name('AA cchmcchm DD ee gg PP spsp rere')).toBe('CP-Polarfuchs')
|
||||||
// dd agouti fox has no dedicated base -> the eFamily fallback yields 'CP-Fuchs'.
|
// GEN-4: dd+ee base = 'Dilute Algierfuchs' -> 'Dilute CP-Algierfuchs' (no more CP-Fuchs catch-all).
|
||||||
expect(name('AA cchmcchm dd ee GG PP spsp rere')).toBe('CP-Fuchs')
|
expect(name('AA cchmcchm dd ee GG PP spsp rere')).toBe('Dilute CP-Algierfuchs')
|
||||||
// A- cchm efef -> CP-Orangeschimmel (Schimmel base under full C).
|
// A- cchm efef -> CP-Orangeschimmel (Schimmel base under full C).
|
||||||
expect(name('AA cchmcchm DD efef GG PP spsp rere')).toBe('CP-Orangeschimmel')
|
expect(name('AA cchmcchm DD efef GG PP spsp rere')).toBe('CP-Orangeschimmel')
|
||||||
})
|
})
|
||||||
@@ -481,11 +490,12 @@ describe('GEN-3f: CP catalog reconciled to the breeder CP- naming (matches her l
|
|||||||
const siam = BASE_COLORS.find((e) => e.name === 'Siam')!
|
const siam = BASE_COLORS.find((e) => e.name === 'Siam')!
|
||||||
const zh = BASE_COLORS.find((e) => e.name === 'Zobel-Hell')!
|
const zh = BASE_COLORS.find((e) => e.name === 'Zobel-Hell')!
|
||||||
const cpah = BASE_COLORS.find((e) => e.name === 'CP-Agouti-Hell')!
|
const cpah = BASE_COLORS.find((e) => e.name === 'CP-Agouti-Hell')!
|
||||||
|
// GEN-4: CP-Fuchs-Hell kept for import/hand-pick but engine now returns the specific name.
|
||||||
const cpfh = BASE_COLORS.find((e) => e.name === 'CP-Fuchs-Hell')!
|
const cpfh = BASE_COLORS.find((e) => e.name === 'CP-Fuchs-Hell')!
|
||||||
expect(genotypeToFarbschlag(representativeGenotype(siam))).toBe('Siam')
|
expect(genotypeToFarbschlag(representativeGenotype(siam))).toBe('Siam')
|
||||||
expect(genotypeToFarbschlag(representativeGenotype(zh))).toBe('Zobel-Hell')
|
expect(genotypeToFarbschlag(representativeGenotype(zh))).toBe('Zobel-Hell')
|
||||||
expect(genotypeToFarbschlag(representativeGenotype(cpah))).toBe('CP-Agouti-Hell')
|
expect(genotypeToFarbschlag(representativeGenotype(cpah))).toBe('CP-Agouti-Hell')
|
||||||
expect(genotypeToFarbschlag(representativeGenotype(cpfh))).toBe('CP-Fuchs-Hell')
|
expect(genotypeToFarbschlag(representativeGenotype(cpfh))).toBe('Dilute CP-Algierfuchs-Hell')
|
||||||
})
|
})
|
||||||
})
|
})
|
||||||
|
|
||||||
@@ -507,7 +517,8 @@ describe('GEN-3g: "-Hell" in variety name == cchm/ch het; hom == cchm/cchm', ()
|
|||||||
expect(name('AA cchmch DD EE gg PP spsp rere')).toBe('CP-Silberagouti-Hell')
|
expect(name('AA cchmch DD EE gg PP spsp rere')).toBe('CP-Silberagouti-Hell')
|
||||||
expect(name('AA cchmch DD ee GG PP spsp rere')).toBe('CP-Algierfuchs-Hell')
|
expect(name('AA cchmch DD ee GG PP spsp rere')).toBe('CP-Algierfuchs-Hell')
|
||||||
expect(name('AA cchmch DD ee gg PP spsp rere')).toBe('CP-Polarfuchs-Hell')
|
expect(name('AA cchmch DD ee gg PP spsp rere')).toBe('CP-Polarfuchs-Hell')
|
||||||
expect(name('AA cchmch dd ee GG PP spsp rere')).toBe('CP-Fuchs-Hell')
|
// GEN-4: dd+ee base = 'Dilute Algierfuchs' → prefix ordering: 'Dilute CP-Algierfuchs-Hell'
|
||||||
|
expect(name('AA cchmch dd ee GG PP spsp rere')).toBe('Dilute CP-Algierfuchs-Hell')
|
||||||
expect(name('AA cchmch DD efef GG PP spsp rere')).toBe('CP-Orangeschimmel-Hell')
|
expect(name('AA cchmch DD efef GG PP spsp rere')).toBe('CP-Orangeschimmel-Hell')
|
||||||
})
|
})
|
||||||
|
|
||||||
@@ -525,6 +536,58 @@ describe('GEN-3g: "-Hell" in variety name == cchm/ch het; hom == cchm/cchm', ()
|
|||||||
})
|
})
|
||||||
})
|
})
|
||||||
|
|
||||||
|
describe('GEN-4: Dilute prefix, REW, no-bare-Fuchs', () => {
|
||||||
|
const name = (s: string) => genotypeToFarbschlag(fromDisplayString(s))
|
||||||
|
|
||||||
|
it('dd entries use Dilute prefix — no more X-dd names', () => {
|
||||||
|
expect(name('AA CC dd EE GG PP spsp rere')).toBe('Dilute Agouti')
|
||||||
|
expect(name('aa CC dd EE gg PP spsp rere')).toBe('Dilute Anthrazit')
|
||||||
|
expect(name('aa CC dd ee GG PP spsp rere')).toBe('Dilute Kohlfuchs')
|
||||||
|
expect(name('aa CC dd ee gg pp spsp rere')).toBe('Dilute Blaufuchs')
|
||||||
|
expect(name('AA CC dd EE GG pp spsp rere')).toBe('Dilute Gold')
|
||||||
|
expect(name('aa CC dd EE GG pp spsp rere')).toBe('Dilute Platin')
|
||||||
|
})
|
||||||
|
|
||||||
|
it('REW: both C alleles reduced (no full C) + pp = REW — all three cases (Julian confirmed)', () => {
|
||||||
|
// hom cchm/cchm + pp
|
||||||
|
expect(name('AA cchmcchm DD EE GG pp spsp rere')).toBe('REW') // CP-Gold
|
||||||
|
expect(name('AA cchmcchm DD ee GG pp spsp rere')).toBe('REW') // CP-Goldfuchs
|
||||||
|
expect(name('AA cchmcchm DD EE gg pp spsp rere')).toBe('REW') // CP-Elfenbein
|
||||||
|
expect(name('AA cchmcchm DD ee gg pp spsp rere')).toBe('REW') // CP-Apricot
|
||||||
|
expect(name('AA cchmcchm dd EE GG pp spsp rere')).toBe('REW') // CP-dd Gold
|
||||||
|
// het cchm/ch + pp (Julian: also REW)
|
||||||
|
expect(name('AA cchmch DD EE GG pp spsp rere')).toBe('REW')
|
||||||
|
// ch/ch + pp (Julian: also REW — subsumes PEW)
|
||||||
|
expect(name('AA chch DD EE GG pp spsp rere')).toBe('REW')
|
||||||
|
expect(name('aa chch DD EE GG pp spsp rere')).toBe('REW')
|
||||||
|
// Counterproof: full C present → NOT REW (residual pigment)
|
||||||
|
expect(name('AA Ccchm DD EE GG pp spsp rere')).not.toBe('REW') // Cc[chm] + pp = Gold-like
|
||||||
|
expect(name('AA Cch DD EE GG pp spsp rere')).not.toBe('REW') // Cc[h] + pp
|
||||||
|
})
|
||||||
|
|
||||||
|
it('Farbarten (categories) never appear as computed results', () => {
|
||||||
|
// 'Fuchs', 'Fuchsschimmel', 'Schimmel' etc. are Farbarten — blocked by category guard.
|
||||||
|
// het ef/e now resolves to specific variety via locusToken ef/e -> 'ef' fix.
|
||||||
|
expect(genotypeToFarbschlag(fromDisplayString('aa CC DD eef GG PP spsp rere'))).toBe('Kohlfuchsschimmel')
|
||||||
|
// Agouti ef/e: 'Orangeschimmel' wins (same token-set as Algierfuchsschimmel, listed first)
|
||||||
|
expect(genotypeToFarbschlag(fromDisplayString('AA CC DD eef GG PP spsp rere'))).toBe('Orangeschimmel')
|
||||||
|
// Unusual combo not in catalog -> Unbekannt (not 'Fuchsschimmel')
|
||||||
|
expect(farbschlagFor(fromDisplayString('aa CC dd eef GG PP spsp rere')).unknown).toBe(true)
|
||||||
|
// FK check: none of the 7 category names are in BASE_COLORS (no DB entries -> no FK risk)
|
||||||
|
const CATS = ['Standard', 'Colourpoint', 'Dilute', 'Fuchs', 'Fuchsschimmel', 'Schimmel', 'Colourpoint Dilute']
|
||||||
|
for (const cat of CATS) {
|
||||||
|
expect(BASE_COLORS.some(e => e.name === cat)).toBe(false)
|
||||||
|
}
|
||||||
|
})
|
||||||
|
|
||||||
|
it('bare Fuchs never appears — dilute-fox combinations are named specifically', () => {
|
||||||
|
expect(name('AA CC dd ee GG PP spsp rere')).toBe('Dilute Algierfuchs')
|
||||||
|
expect(name('AA CC dd ee GG pp spsp rere')).toBe('Dilute Goldfuchs')
|
||||||
|
expect(name('aa CC dd ee GG pp spsp rere')).toBe('Dilute Rotfuchs')
|
||||||
|
expect(name('AA CC dd ee gg PP spsp rere')).toBe('Dilute Polarfuchs')
|
||||||
|
})
|
||||||
|
})
|
||||||
|
|
||||||
describe('GEN-3h: breeder bracket-notation display + E-locus e-before-ef order', () => {
|
describe('GEN-3h: breeder bracket-notation display + E-locus e-before-ef order', () => {
|
||||||
// ── Display symbols ────────────────────────────────────────────────────
|
// ── Display symbols ────────────────────────────────────────────────────
|
||||||
it('ef displays as e[f], cchm as c[chm], ch as c[h]', () => {
|
it('ef displays as e[f], cchm as c[chm], ch as c[h]', () => {
|
||||||
|
|||||||
@@ -66,8 +66,8 @@ export const BASE_COLORS: readonly FarbschlagEntry[] = [
|
|||||||
{ name: 'Platin', english: 'Lilac', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'platin.JPG' },
|
{ name: 'Platin', english: 'Lilac', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'platin.JPG' },
|
||||||
{ name: 'Goldfuchs', english: 'Yellow Fox', tokens: { A: 'A', C: 'C', D: 'D', E: 'e', G: 'G', P: 'p' }, image: 'goldfuchs.jpg' },
|
{ name: 'Goldfuchs', english: 'Yellow Fox', tokens: { A: 'A', C: 'C', D: 'D', E: 'e', G: 'G', P: 'p' }, image: 'goldfuchs.jpg' },
|
||||||
{ name: 'Rotfuchs', english: 'Argente Nutmeg', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'p' }, image: 'rotfuchs.JPG' },
|
{ name: 'Rotfuchs', english: 'Argente Nutmeg', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'p' }, image: 'rotfuchs.JPG' },
|
||||||
{ name: 'dd Gold', english: 'dd Argente Golden', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'G', P: 'p' }, image: 'gold-dd.jpg' },
|
{ name: 'Dilute Gold', english: 'dd Argente Golden', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'G', P: 'p' }, image: 'gold-dd.jpg' },
|
||||||
{ name: 'dd Platin', english: 'dd Lilac', tokens: { A: 'a', C: 'C', D: 'd', E: 'E', G: 'G', P: 'p' }, image: 'platin-dd.jpg' },
|
{ name: 'Dilute Platin', english: 'dd Lilac', tokens: { A: 'a', C: 'C', D: 'd', E: 'E', G: 'G', P: 'p' }, image: 'platin-dd.jpg' },
|
||||||
|
|
||||||
// ── baseportal.de varieties (GEN-2), normalized to the frozen allele table ──
|
// ── baseportal.de varieties (GEN-2), normalized to the frozen allele table ──
|
||||||
{ name: 'Altweiss (REW)', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'g', P: 'p' }, image: 'altweiss-rew.jpeg' },
|
{ name: 'Altweiss (REW)', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'g', P: 'p' }, image: 'altweiss-rew.jpeg' },
|
||||||
@@ -78,16 +78,24 @@ export const BASE_COLORS: readonly FarbschlagEntry[] = [
|
|||||||
{ name: 'Kohlfuchs', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'P' }, image: 'kohlfuchs.jpg' },
|
{ name: 'Kohlfuchs', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'P' }, image: 'kohlfuchs.jpg' },
|
||||||
{ name: 'Polarfuchs', tokens: { A: 'A', C: 'C', D: 'D', E: 'e', G: 'g', P: 'P' }, image: 'polarfuchs.jpg' },
|
{ name: 'Polarfuchs', tokens: { A: 'A', C: 'C', D: 'D', E: 'e', G: 'g', P: 'P' }, image: 'polarfuchs.jpg' },
|
||||||
{ name: 'Saphir', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'saphir.jpg' },
|
{ name: 'Saphir', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'saphir.jpg' },
|
||||||
// GEN-3a: efef base (otherwise wild C/D/G/P) = Orangeschimmel (breeder C5).
|
// GEN-3a: efef base (agouti, wild C/D/G/P) = Orangeschimmel (breeder C5).
|
||||||
{ name: 'Orangeschimmel', tokens: { C: 'C', D: 'D', E: 'ef', G: 'G', P: 'P' }, image: 'schimmel-orangeschimmel.jpg' },
|
// GEN-4: A:'A' added — non-agouti ef animals fall through to Kohlfuchsschimmel etc.
|
||||||
|
{ name: 'Orangeschimmel', tokens: { A: 'A', C: 'C', D: 'D', E: 'ef', G: 'G', P: 'P' }, image: 'schimmel-orangeschimmel.jpg' },
|
||||||
{ name: 'Topas', tokens: { A: 'A', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'topas.jpg' },
|
{ name: 'Topas', tokens: { A: 'A', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'topas.jpg' },
|
||||||
{ name: 'Platin-Hell', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'platin-hell.jpg' },
|
{ name: 'Platin-Hell', tokens: { A: 'a', C: 'C', D: 'D', E: 'E', G: 'G', P: 'p' }, image: 'platin-hell.jpg' },
|
||||||
{ name: 'Agouti dd', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'G', P: 'P' }, image: 'agouti-dd.jpg' },
|
{ name: 'Dilute Agouti', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'G', P: 'P' }, image: 'agouti-dd.jpg' },
|
||||||
{ name: 'Silberagouti dd', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'g', P: 'P' }, image: 'silberagouti-dd.jpg' },
|
{ name: 'Dilute Silberagouti', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'g', P: 'P' }, image: 'silberagouti-dd.jpg' },
|
||||||
{ name: 'Kohlfuchs dd', tokens: { A: 'a', C: 'C', D: 'd', E: 'e', G: 'G', P: 'P' }, image: 'kohlfuchs-dd.jpg' },
|
{ name: 'Dilute Kohlfuchs', tokens: { A: 'a', C: 'C', D: 'd', E: 'e', G: 'G', P: 'P' }, image: 'kohlfuchs-dd.jpg' },
|
||||||
{ name: 'Anthrazit dd', tokens: { A: 'a', C: 'C', D: 'd', E: 'E', G: 'g', P: 'P' }, image: 'anthrazit-dd.jpg' },
|
{ name: 'Dilute Anthrazit', tokens: { A: 'a', C: 'C', D: 'd', E: 'E', G: 'g', P: 'P' }, image: 'anthrazit-dd.jpg' },
|
||||||
|
// GEN-4: dilute fox base entries — prevent bare 'Fuchs' family fallback for
|
||||||
|
// agouti+dilute+fox combinations not otherwise covered in the catalog.
|
||||||
|
{ name: 'Dilute Algierfuchs', tokens: { A: 'A', C: 'C', D: 'd', E: 'e', G: 'G', P: 'P' } },
|
||||||
|
{ name: 'Dilute Goldfuchs', tokens: { A: 'A', C: 'C', D: 'd', E: 'e', G: 'G', P: 'p' } },
|
||||||
|
{ name: 'Dilute Rotfuchs', tokens: { A: 'a', C: 'C', D: 'd', E: 'e', G: 'G', P: 'p' } },
|
||||||
|
{ name: 'Dilute Polarfuchs', tokens: { A: 'A', C: 'C', D: 'd', E: 'e', G: 'g', P: 'P' } },
|
||||||
// GEN-3a: efef gg base = Silberschimmel (breeder C5) — listed before the
|
// GEN-3a: efef gg base = Silberschimmel (breeder C5) — listed before the
|
||||||
// A-specific Polarfuchsschimmel so the canonical efef-gg reverse-matches here.
|
// A-specific Polarfuchsschimmel so the canonical efef-gg reverse-matches here.
|
||||||
|
// No A restriction: both agouti (AA) and non-agouti (aa) ef/gg = Silberschimmel.
|
||||||
{ name: 'Silberschimmel', tokens: { C: 'C', D: 'D', E: 'ef', G: 'g', P: 'P' }, image: 'silberschimmel.jpg' },
|
{ name: 'Silberschimmel', tokens: { C: 'C', D: 'D', E: 'ef', G: 'g', P: 'P' }, image: 'silberschimmel.jpg' },
|
||||||
{ name: 'Polarfuchsschimmel', tokens: { A: 'A', C: 'C', D: 'D', E: 'ef', G: 'g', P: 'P' }, image: 'polarfuchsschimmel.jpg' },
|
{ name: 'Polarfuchsschimmel', tokens: { A: 'A', C: 'C', D: 'D', E: 'ef', G: 'g', P: 'P' }, image: 'polarfuchsschimmel.jpg' },
|
||||||
{ name: 'Algierfuchsschimmel', tokens: { A: 'A', C: 'C', D: 'D', E: 'ef', G: 'G', P: 'P' }, image: 'algierfuchsschimmel.jpg' },
|
{ name: 'Algierfuchsschimmel', tokens: { A: 'A', C: 'C', D: 'D', E: 'ef', G: 'G', P: 'P' }, image: 'algierfuchsschimmel.jpg' },
|
||||||
@@ -104,8 +112,8 @@ export const BASE_COLORS: readonly FarbschlagEntry[] = [
|
|||||||
{ name: 'Rotfuchs, hell', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'p' }, image: 'rotfuchs-hell.jpg' },
|
{ name: 'Rotfuchs, hell', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'p' }, image: 'rotfuchs-hell.jpg' },
|
||||||
{ name: 'Kohlfuchs-Hell', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'P' }, image: 'kohlfuchs-hell-2.jpg' },
|
{ name: 'Kohlfuchs-Hell', tokens: { A: 'a', C: 'C', D: 'D', E: 'e', G: 'G', P: 'P' }, image: 'kohlfuchs-hell-2.jpg' },
|
||||||
{ name: 'Algierfuchs, hell', tokens: { A: 'A', C: 'C', D: 'D', E: 'e', G: 'G', P: 'P' }, image: 'algierfuchs-hell.JPG' },
|
{ name: 'Algierfuchs, hell', tokens: { A: 'A', C: 'C', D: 'D', E: 'e', G: 'G', P: 'P' }, image: 'algierfuchs-hell.JPG' },
|
||||||
{ name: 'Topas dd', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'G', P: 'p' }, image: 'topas-dd.jpg' },
|
{ name: 'Dilute Topas', tokens: { A: 'A', C: 'C', D: 'd', E: 'E', G: 'G', P: 'p' }, image: 'topas-dd.jpg' },
|
||||||
{ name: 'Blaufuchs dd', tokens: { A: 'a', C: 'C', D: 'd', E: 'e', G: 'g', P: 'p' }, image: 'blaufuchs-dd.jpg' },
|
{ name: 'Dilute Blaufuchs', tokens: { A: 'a', C: 'C', D: 'd', E: 'e', G: 'g', P: 'p' }, image: 'blaufuchs-dd.jpg' },
|
||||||
|
|
||||||
// ── GEN-3f/3g: c^chm colourpoint varieties ──
|
// ── GEN-3f/3g: c^chm colourpoint varieties ──
|
||||||
// GEN-3f: aa points = marten/sable group (Marder/Siam, +gg Zobel/Zobel-Hell).
|
// GEN-3f: aa points = marten/sable group (Marder/Siam, +gg Zobel/Zobel-Hell).
|
||||||
@@ -147,10 +155,12 @@ export interface FarbschlagMatch {
|
|||||||
* Expressed token at a locus. GEN-3d: an UNKNOWN allele ('?') is resolved to the
|
* Expressed token at a locus. GEN-3d: an UNKNOWN allele ('?') is resolved to the
|
||||||
* MOST-DOMINANT allele of the locus (the safer default) rather than acting as a
|
* MOST-DOMINANT allele of the locus (the safer default) rather than acting as a
|
||||||
* match-anything wildcard — so an unknown-C animal reads as full-colour 'C', not
|
* match-anything wildcard — so an unknown-C animal reads as full-colour 'C', not
|
||||||
* a c^h/c^chm colourpoint white. The E locus stays PAIR-aware so the Fuchs/
|
* a c^h/c^chm colourpoint white. The E locus uses the PHENOTYPICALLY EXPRESSED
|
||||||
* Schimmel family is distinguishable: ee->'e', e/ef->'eef', ef/ef->'ef'.
|
* allele for catalog matching: ee->'e', ef/ef->'ef', e/ef->'ef' (ef is dominant
|
||||||
* (The Fuchs/Schimmel FAMILY for unknown-E is still handled by eFamily on the
|
* for the Schimmel/roan phenotype, so het ef/e animals match Schimmel catalog
|
||||||
* raw pair, which runs before this.)
|
* entries such as Kohlfuchsschimmel). GEN-4: 'eef' removed — 'Fuchsschimmel'
|
||||||
|
* is a Farbart/category, not a concrete Farbschlag; the catalog must name the
|
||||||
|
* variety specifically.
|
||||||
*/
|
*/
|
||||||
function locusToken(g: Genotype, locus: LocusKey): string {
|
function locusToken(g: Genotype, locus: LocusKey): string {
|
||||||
// Default an unknown allele to the WILD-TYPE reading: most-dominant for the
|
// Default an unknown allele to the WILD-TYPE reading: most-dominant for the
|
||||||
@@ -162,7 +172,9 @@ function locusToken(g: Genotype, locus: LocusKey): string {
|
|||||||
const [x, y] = g[locus].map((a) => (a === WILDCARD ? fallback : a))
|
const [x, y] = g[locus].map((a) => (a === WILDCARD ? fallback : a))
|
||||||
if (locus === 'E') {
|
if (locus === 'E') {
|
||||||
if (x === y) return x // ee->'e', efef->'ef', EE->'E'
|
if (x === y) return x // ee->'e', efef->'ef', EE->'E'
|
||||||
if ((x === 'e' && y === 'ef') || (x === 'ef' && y === 'e')) return 'eef'
|
// GEN-4: het ef/e → 'ef' (ef is dominant for the Schimmel phenotype;
|
||||||
|
// enables catalog entries like Kohlfuchsschimmel to match het animals).
|
||||||
|
if ((x === 'e' && y === 'ef') || (x === 'ef' && y === 'e')) return 'ef'
|
||||||
return dominantAllele('E', x, y) // E/ef, E/e -> 'E'
|
return dominantAllele('E', x, y) // E/ef, E/e -> 'E'
|
||||||
}
|
}
|
||||||
return dominantAllele(locus, x, y)
|
return dominantAllele(locus, x, y)
|
||||||
@@ -175,10 +187,12 @@ function matches(g: Genotype, entry: FarbschlagEntry): boolean {
|
|||||||
}
|
}
|
||||||
|
|
||||||
/**
|
/**
|
||||||
* GEN-3c family fallback: the E locus alone names the Fuchs/Schimmel family even
|
* E-locus family: used to scope the catalog search to E-aware entries.
|
||||||
* when other loci are unknown (so genotypes never fall through to "Unbekannt").
|
* Returns a family tag ('Fuchs'/'Fuchsschimmel'/'Schimmel') when the E locus
|
||||||
* ee -> Fuchs | e/ef -> Fuchsschimmel | ef/ef -> Schimmel | e/? -> Fuchs (for now)
|
* implies a non-dominant extension pair, or null for full-extension/unknown.
|
||||||
* Returns null when E is dominant (full colour) or fully unknown.
|
* GEN-4: these family names are Farbarten (categories), NOT concrete Farbschläge.
|
||||||
|
* They are ONLY used here as catalog-search filters; they must NEVER appear as
|
||||||
|
* computed farbschlag output (the farbschlagFor category guard blocks them).
|
||||||
*/
|
*/
|
||||||
function eFamily(g: Genotype): string | null {
|
function eFamily(g: Genotype): string | null {
|
||||||
const [x, y] = g.E
|
const [x, y] = g.E
|
||||||
@@ -205,7 +219,10 @@ function baseColourFor(g: Genotype): string | null {
|
|||||||
const base = family
|
const base = family
|
||||||
? (BASE_COLORS.find((e) => e.tokens.E !== undefined && matches(g, e)) ?? null)
|
? (BASE_COLORS.find((e) => e.tokens.E !== undefined && matches(g, e)) ?? null)
|
||||||
: (BASE_COLORS.find((e) => matches(g, e)) ?? null)
|
: (BASE_COLORS.find((e) => matches(g, e)) ?? null)
|
||||||
return base?.name ?? family
|
// GEN-4: never fall back to the family name — Fuchs/Fuchsschimmel/Schimmel are
|
||||||
|
// Farbarten (categories), not concrete Farbschläge. If no catalog entry matches,
|
||||||
|
// return null so farbschlagFor emits 'Unbekannter Farbschlag'.
|
||||||
|
return base?.name ?? null
|
||||||
}
|
}
|
||||||
|
|
||||||
/**
|
/**
|
||||||
@@ -233,7 +250,13 @@ function colourpointName(g: Genotype): string | null {
|
|||||||
}
|
}
|
||||||
// A- colourpoint: base as if C were full; het (cchm/ch) -> '-Hell' suffix.
|
// A- colourpoint: base as if C were full; het (cchm/ch) -> '-Hell' suffix.
|
||||||
const base = baseColourFor(makeGenotype({ ...g, C: ['C', 'C'] }))
|
const base = baseColourFor(makeGenotype({ ...g, C: ['C', 'C'] }))
|
||||||
return base ? `CP-${base}${bothCchm ? '' : '-Hell'}` : null
|
if (!base) return null
|
||||||
|
// GEN-4: if base is a Dilute variety, prefix ordering is 'Dilute CP-X' not 'CP-Dilute X'.
|
||||||
|
const DILUTE = 'Dilute '
|
||||||
|
if (base.startsWith(DILUTE)) {
|
||||||
|
return `${DILUTE}CP-${base.slice(DILUTE.length)}${bothCchm ? '' : '-Hell'}`
|
||||||
|
}
|
||||||
|
return `CP-${base}${bothCchm ? '' : '-Hell'}`
|
||||||
}
|
}
|
||||||
|
|
||||||
export function farbschlagFor(g: Genotype): FarbschlagMatch {
|
export function farbschlagFor(g: Genotype): FarbschlagMatch {
|
||||||
@@ -241,8 +264,30 @@ export function farbschlagFor(g: Genotype): FarbschlagMatch {
|
|||||||
if (locusToken(g, 'Sp') === 'Sp') modifiers.push('Schecke')
|
if (locusToken(g, 'Sp') === 'Sp') modifiers.push('Schecke')
|
||||||
if (locusToken(g, 'Re') === 'Re') modifiers.push('Rex')
|
if (locusToken(g, 'Re') === 'Re') modifiers.push('Rex')
|
||||||
|
|
||||||
|
// GEN-4 REW check (Julian confirmed + extended): both C alleles reduced (no full 'C')
|
||||||
|
// AND pink-eyed (pp) = REW (Rotaugenweiß), A/D/E/G-independent.
|
||||||
|
// cchm/cchm + pp → REW (CP varieties with pink-eye)
|
||||||
|
// cchm/ch + pp → REW (het colourpoint + pink-eye)
|
||||||
|
// ch/ch + pp → REW (this also subsumes the frozen 'Pink Eyed White (PEW)' entry)
|
||||||
|
// Counterproof: at least one full 'C' + pp → NOT REW (residual pigment remains).
|
||||||
|
const [c0, c1] = resolvedPair(g, 'C')
|
||||||
|
const [p0, p1] = resolvedPair(g, 'P')
|
||||||
|
const cReduced = (c: string) => c === 'cchm' || c === 'ch'
|
||||||
|
if (cReduced(c0) && cReduced(c1) && p0 === 'p' && p1 === 'p') {
|
||||||
|
const name = ['REW', ...modifiers].join(' ')
|
||||||
|
return { name, base: null, unknown: false }
|
||||||
|
}
|
||||||
|
|
||||||
const baseName = colourpointName(g) ?? baseColourFor(g)
|
const baseName = colourpointName(g) ?? baseColourFor(g)
|
||||||
if (!baseName) {
|
// GEN-4: safety guard — Farbarten (categories/families) are NEVER valid as
|
||||||
|
// a computed Farbschlag output. If baseName is a category label, treat as
|
||||||
|
// Unbekannt instead of leaking an invalid name into the UI.
|
||||||
|
const CATEGORY_NAMES: ReadonlySet<string> = new Set([
|
||||||
|
'Standard', 'Colourpoint', 'Dilute',
|
||||||
|
'Fuchs', 'Fuchsschimmel', 'Schimmel',
|
||||||
|
'Colourpoint Dilute',
|
||||||
|
])
|
||||||
|
if (!baseName || CATEGORY_NAMES.has(baseName)) {
|
||||||
return { name: UNKNOWN_FARBSCHLAG, base: null, unknown: true }
|
return { name: UNKNOWN_FARBSCHLAG, base: null, unknown: true }
|
||||||
}
|
}
|
||||||
const name = [baseName, ...modifiers].join(' ')
|
const name = [baseName, ...modifiers].join(' ')
|
||||||
|
|||||||
@@ -539,28 +539,57 @@ textarea {
|
|||||||
margin: 0.5rem 0 1rem;
|
margin: 0.5rem 0 1rem;
|
||||||
padding: 0;
|
padding: 0;
|
||||||
display: grid;
|
display: grid;
|
||||||
grid-template-columns: repeat(auto-fill, minmax(13rem, 1fr));
|
/* GEN-4: wider min-width prevents long names (CP-Silberagouti-Hell) from overflowing */
|
||||||
|
grid-template-columns: repeat(auto-fill, minmax(15rem, 1fr));
|
||||||
gap: 0.5rem;
|
gap: 0.5rem;
|
||||||
}
|
}
|
||||||
|
|
||||||
|
/* GEN-4 layout fix: image left, body centre (name + genotype stacked), prob right.
|
||||||
|
align-items: stretch so all three columns fill the card height consistently. */
|
||||||
.farbschlag-card {
|
.farbschlag-card {
|
||||||
display: flex;
|
display: flex;
|
||||||
align-items: center;
|
align-items: center;
|
||||||
justify-content: space-between;
|
|
||||||
gap: 0.5rem;
|
gap: 0.5rem;
|
||||||
padding: 0.6rem 0.9rem;
|
padding: 0.6rem 0.9rem;
|
||||||
border: 1px solid var(--color-border);
|
border: 1px solid var(--color-border);
|
||||||
border-radius: 0.6rem;
|
border-radius: 0.6rem;
|
||||||
background: var(--color-surface);
|
background: var(--color-surface);
|
||||||
|
overflow: hidden; /* contain long genotype strings */
|
||||||
|
}
|
||||||
|
|
||||||
|
.farbschlag-card__img {
|
||||||
|
flex-shrink: 0;
|
||||||
|
}
|
||||||
|
|
||||||
|
/* Body takes the middle space and allows wrapping for long names */
|
||||||
|
.farbschlag-card__body {
|
||||||
|
flex: 1;
|
||||||
|
min-width: 0; /* allow flex child to shrink below content size */
|
||||||
|
display: flex;
|
||||||
|
flex-direction: column;
|
||||||
|
gap: 0.15rem;
|
||||||
}
|
}
|
||||||
|
|
||||||
.farbschlag-card__name {
|
.farbschlag-card__name {
|
||||||
font-weight: 600;
|
font-weight: 600;
|
||||||
|
overflow-wrap: break-word;
|
||||||
|
word-break: break-word;
|
||||||
|
}
|
||||||
|
|
||||||
|
/* Genotype code shown below the name — muted, small, wrappable */
|
||||||
|
.farbschlag-card__geno {
|
||||||
|
font-size: 0.7rem;
|
||||||
|
color: var(--color-text-muted, #666);
|
||||||
|
overflow-wrap: break-word;
|
||||||
|
word-break: break-all;
|
||||||
|
opacity: 0.8;
|
||||||
}
|
}
|
||||||
|
|
||||||
.farbschlag-card__prob {
|
.farbschlag-card__prob {
|
||||||
|
flex-shrink: 0;
|
||||||
color: var(--color-accent);
|
color: var(--color-accent);
|
||||||
white-space: nowrap;
|
white-space: nowrap;
|
||||||
|
text-align: right;
|
||||||
}
|
}
|
||||||
|
|
||||||
/* UX-MOBILE-2: scroll wrapper so genotype table scrolls horizontally on mobile
|
/* UX-MOBILE-2: scroll wrapper so genotype table scrolls horizontally on mobile
|
||||||
|
|||||||
@@ -377,7 +377,13 @@ function PedigreeCard({
|
|||||||
<div className="pedigree-card__body">
|
<div className="pedigree-card__body">
|
||||||
<div className="pedigree-card__name">
|
<div className="pedigree-card__name">
|
||||||
<SexIcon gender={g.gender} />
|
<SexIcon gender={g.gender} />
|
||||||
<span className="pedigree-card__nametext">{g.name || de.pages.gerbils.nameless}</span>
|
<Link
|
||||||
|
to={`/rennmaeuse/${g.id}`}
|
||||||
|
className="pedigree-card__nametext"
|
||||||
|
onClick={(e) => e.stopPropagation()}
|
||||||
|
>
|
||||||
|
{g.name || de.pages.gerbils.nameless}
|
||||||
|
</Link>
|
||||||
</div>
|
</div>
|
||||||
{farbschlag && (
|
{farbschlag && (
|
||||||
<span
|
<span
|
||||||
|
|||||||
@@ -134,6 +134,12 @@
|
|||||||
white-space: nowrap;
|
white-space: nowrap;
|
||||||
overflow: hidden;
|
overflow: hidden;
|
||||||
text-overflow: ellipsis;
|
text-overflow: ellipsis;
|
||||||
|
color: inherit;
|
||||||
|
text-decoration: none;
|
||||||
|
}
|
||||||
|
|
||||||
|
.pedigree-card__nametext:hover {
|
||||||
|
text-decoration: underline;
|
||||||
}
|
}
|
||||||
|
|
||||||
.pedigree-card__sex--male {
|
.pedigree-card__sex--male {
|
||||||
|
|||||||
@@ -112,6 +112,13 @@
|
|||||||
"decision": "E-locus = ee[f], G-locus = GG (one source wrote UwUw = GG in international notation), P-locus = PP — resolves the 3 contested loci",
|
"decision": "E-locus = ee[f], G-locus = GG (one source wrote UwUw = GG in international notation), P-locus = PP — resolves the 3 contested loci",
|
||||||
"genotype": "Aa Cc[chm] DD ee[f] GG PP Spsp",
|
"genotype": "Aa Cc[chm] DD ee[f] GG PP Spsp",
|
||||||
"source": "Julian 2026-06-07 — HUMANQUESTION D6"
|
"source": "Julian 2026-06-07 — HUMANQUESTION D6"
|
||||||
|
},
|
||||||
|
{
|
||||||
|
"name": "Hanami von den Kleinen Chaoten",
|
||||||
|
"dob": "10.09.2015",
|
||||||
|
"decision": "death date = 12.12.2019 (confirmed; the 14.01.2020 variant was wrong)",
|
||||||
|
"dateOfDeath": "12.12.2019",
|
||||||
|
"source": "Julian 2026-06-07 — HUMANQUESTION D5/D6 (letzter D6-Konflikt)"
|
||||||
}
|
}
|
||||||
]
|
]
|
||||||
}
|
}
|
||||||
|
|||||||
312
tools/import/extract_docx.py
Normal file
312
tools/import/extract_docx.py
Normal file
@@ -0,0 +1,312 @@
|
|||||||
|
#!/usr/bin/env python3
|
||||||
|
"""FEAT-8d Stage 1 — Wurfchronik-Detail-Dokument (.docx) extrahieren.
|
||||||
|
|
||||||
|
Liest 'Wurfchronik der Kleinen Chaoten im Detail.docx' (Word/XML, stdlib-Python,
|
||||||
|
kein pip) und erzeugt:
|
||||||
|
output/docx_litters.json — Wurf-Kopfdaten (WS-Code, DOB, Eltern, Notiz)
|
||||||
|
output/docx_animals.json — Tier-Zeilen (Name, Farbe, Abnehmer, ABD, Tod)
|
||||||
|
|
||||||
|
Format der Ausgabe ist so gestaltet, dass ImportDocxService.cs in C# direkt
|
||||||
|
darüber laden kann. Idempotent: mehrfaches Ausführen überschreibt denselben Output.
|
||||||
|
|
||||||
|
Bekannte Sonderwerte im Dokument:
|
||||||
|
ZT = Zucht-Tier (bleibt in Zucht, kein externer Abnehmer)
|
||||||
|
BLEIBT = vorläufig beim Züchter
|
||||||
|
FREI = noch verfügbar
|
||||||
|
VG: = Verpaarungs-Geschichte (bisherige Partner; nicht als Abnehmer werten)
|
||||||
|
RG: = Rückgabe
|
||||||
|
BEW = Bewerbung (Adoptionsinteressent in Prüfung)
|
||||||
|
-- ??? = Platzhalter, kein echter Name
|
||||||
|
|
||||||
|
Feld 'gender': '' = weiblich (kein Marker), '*' auf Farbschlag oder 'G'-Spalte = männlich.
|
||||||
|
|
||||||
|
Ausführung: python extract_docx.py [--docx PFAD]
|
||||||
|
"""
|
||||||
|
import os
|
||||||
|
import re
|
||||||
|
import sys
|
||||||
|
import json
|
||||||
|
import zipfile
|
||||||
|
import argparse
|
||||||
|
|
||||||
|
HERE = os.path.dirname(os.path.abspath(__file__))
|
||||||
|
DEFAULT_DOCX = os.path.join(
|
||||||
|
r"C:\Users\gulum\dev",
|
||||||
|
"Wurfchronik der Kleinen Chaoten im Detail.docx",
|
||||||
|
)
|
||||||
|
OUT = os.path.join(HERE, "output")
|
||||||
|
|
||||||
|
# --- Regex patterns -------------------------------------------------------
|
||||||
|
|
||||||
|
# Litter header paragraph (after whitespace-collapsing).
|
||||||
|
# Edge cases handled:
|
||||||
|
# - Dual birth date: "*16./17.03.2021"
|
||||||
|
# - WS without numerator: "WS: /5"
|
||||||
|
# - WS with trailing text: "WS: 4/4, davon 1 später..."
|
||||||
|
# - No space before WS: "...ChaotenWS: 2/4"
|
||||||
|
# Date part allows simple DD.MM.YYYY, dual-day (16./17.03.2021), or dual-month (31.05/*01.06.2023).
|
||||||
|
# We capture the LAST complete DD.MM.YYYY in the date token as the birth date.
|
||||||
|
_DATE_TOKEN = r"[\d./\*]+"
|
||||||
|
# Full litter header regex
|
||||||
|
LITTER_RE = re.compile(
|
||||||
|
r"([A-Za-z\d\-]*Wurf)\s*\*\s*(" + _DATE_TOKEN + r")"
|
||||||
|
r"\s*Von:\s*(.+?)\s*&\s*(.+?)\s*WS:\s*(\d*\s*/\s*\d+)"
|
||||||
|
r"(?:[,\s].*?)?(?:Notiz:\s*(.*?))?$",
|
||||||
|
re.IGNORECASE,
|
||||||
|
)
|
||||||
|
# Used to extract the canonical date from a date token like "31.05/*01.06.2023"
|
||||||
|
_LAST_DATE_RE = re.compile(r"(\d{1,2}\.\d{2}\.\d{4})(?![\d.])")
|
||||||
|
# Death/adoption date at start of combined T.D column: "16.09.23Tumor am After"
|
||||||
|
DATE_START_RE = re.compile(r"^(\d{1,2}\.\d{1,2}\.\d{2,4})\s*(.*)")
|
||||||
|
# Partner birth date: "Crow (*25.12.20)" or "Tom (*05.01.21)"
|
||||||
|
PARTNER_DOB_RE = re.compile(r"\(\s*\*\s*(\d{2}\.\d{2}\.\d{2,4})\s*\)")
|
||||||
|
# Special-value sentinel names to skip
|
||||||
|
PLACEHOLDER_NAMES = {"--", "???", ""}
|
||||||
|
INTERNAL_TOKENS = {"ZT", "BLEIBT", "FREI", "VG:", "VG*:", "RG:", "BEW"}
|
||||||
|
|
||||||
|
|
||||||
|
def _norm_dob(d: str) -> str:
|
||||||
|
"""Normalise German date to DD.MM.YYYY."""
|
||||||
|
if not d:
|
||||||
|
return ""
|
||||||
|
p = d.strip().split(".")
|
||||||
|
if len(p) == 3:
|
||||||
|
y = p[2].strip()
|
||||||
|
if len(y) == 2:
|
||||||
|
y = "20" + y
|
||||||
|
return f"{p[0].zfill(2)}.{p[1].zfill(2)}.{y}"
|
||||||
|
return d.strip()
|
||||||
|
|
||||||
|
|
||||||
|
def _cell_text(cell_xml: str) -> str:
|
||||||
|
"""Strip XML from a <w:tc> cell and return clean text."""
|
||||||
|
t = re.sub(r"<[^>]+>", "", cell_xml)
|
||||||
|
t = t.replace("&", "&").replace("<", "<").replace(">", ">")
|
||||||
|
t = t.replace("'", "'").replace(""", '"')
|
||||||
|
return re.sub(r"\s+", " ", t).strip()
|
||||||
|
|
||||||
|
|
||||||
|
def _is_internal(value: str) -> bool:
|
||||||
|
"""True if the owner/name field holds an internal sentinel, not a real person."""
|
||||||
|
v = value.strip()
|
||||||
|
return v in INTERNAL_TOKENS or any(v.startswith(tok) for tok in INTERNAL_TOKENS)
|
||||||
|
|
||||||
|
|
||||||
|
def extract(docx_path: str):
|
||||||
|
"""Parse the docx and return (litters, animals) lists."""
|
||||||
|
with zipfile.ZipFile(docx_path) as z:
|
||||||
|
xml = z.read("word/document.xml").decode("utf-8", errors="replace")
|
||||||
|
|
||||||
|
# ---- Paragraphs → litter header blocks ----
|
||||||
|
paras = re.findall(r"<w:p[ >].*?</w:p>", xml, re.DOTALL)
|
||||||
|
para_texts = []
|
||||||
|
for p in paras:
|
||||||
|
t = re.sub(r"<[^>]+>", "", p)
|
||||||
|
t = t.replace("&", "&").strip()
|
||||||
|
t = re.sub(r"\s+", " ", t).strip()
|
||||||
|
if t:
|
||||||
|
para_texts.append(t)
|
||||||
|
|
||||||
|
litters: list[dict] = []
|
||||||
|
current_ws: str = ""
|
||||||
|
current_litter_dob: str = ""
|
||||||
|
|
||||||
|
# Build a WS-code → litter index for assigning animals
|
||||||
|
ws_to_idx: dict[str, int] = {}
|
||||||
|
|
||||||
|
for para in para_texts:
|
||||||
|
m = LITTER_RE.search(para)
|
||||||
|
if not m:
|
||||||
|
continue
|
||||||
|
litter_id = m.group(1).strip()
|
||||||
|
dob_raw = m.group(2).strip()
|
||||||
|
mother_raw = m.group(3).strip()
|
||||||
|
father_raw = m.group(4).strip()
|
||||||
|
ws_raw = m.group(5).replace(" ", "")
|
||||||
|
note = (m.group(6) or "").strip()
|
||||||
|
|
||||||
|
# For dual-date tokens like "31.05/*01.06.2023", take the last full date.
|
||||||
|
last_dates = _LAST_DATE_RE.findall(dob_raw)
|
||||||
|
dob_clean = _norm_dob(last_dates[-1] if last_dates else dob_raw)
|
||||||
|
|
||||||
|
litter = {
|
||||||
|
"litterId": litter_id,
|
||||||
|
"dob": dob_clean,
|
||||||
|
"motherName": mother_raw,
|
||||||
|
"fatherName": father_raw,
|
||||||
|
"wsCode": ws_raw,
|
||||||
|
"note": note,
|
||||||
|
}
|
||||||
|
ws_to_idx[ws_raw] = len(litters)
|
||||||
|
litters.append(litter)
|
||||||
|
|
||||||
|
# ---- Tables → animal rows ----
|
||||||
|
# Each table sits after a litter-header paragraph; we sequence tables and
|
||||||
|
# litter headers together by their byte offset in the XML.
|
||||||
|
animals: list[dict] = []
|
||||||
|
|
||||||
|
# Build ordered sequence of (offset, type, data) events
|
||||||
|
events: list[tuple[int, str, any]] = []
|
||||||
|
for m in re.finditer(r"<w:p[ >].*?</w:p>", xml, re.DOTALL):
|
||||||
|
t = re.sub(r"<[^>]+>", "", m.group()).replace("&", "&").strip()
|
||||||
|
t = re.sub(r"\s+", " ", t).strip()
|
||||||
|
lm = LITTER_RE.search(t)
|
||||||
|
if lm:
|
||||||
|
ws = lm.group(5).replace(" ", "")
|
||||||
|
dob_tok = lm.group(2)
|
||||||
|
last = _LAST_DATE_RE.findall(dob_tok)
|
||||||
|
dob = _norm_dob(last[-1] if last else dob_tok)
|
||||||
|
events.append((m.start(), "litter", (ws, dob)))
|
||||||
|
|
||||||
|
for m in re.finditer(r"<w:tbl[ >].*?</w:tbl>", xml, re.DOTALL):
|
||||||
|
events.append((m.start(), "table", m.group()))
|
||||||
|
|
||||||
|
events.sort(key=lambda e: e[0])
|
||||||
|
|
||||||
|
active_ws = ""
|
||||||
|
active_dob = ""
|
||||||
|
|
||||||
|
for _, etype, edata in events:
|
||||||
|
if etype == "litter":
|
||||||
|
active_ws, active_dob = edata
|
||||||
|
elif etype == "table" and active_ws:
|
||||||
|
# Parse all rows in this table
|
||||||
|
rows = re.findall(r"<w:tr[ >].*?</w:tr>", edata, re.DOTALL)
|
||||||
|
for row in rows:
|
||||||
|
cells_xml = re.findall(r"<w:tc[ >].*?</w:tc>", row, re.DOTALL)
|
||||||
|
ct = [_cell_text(c) for c in cells_xml]
|
||||||
|
if not ct:
|
||||||
|
continue
|
||||||
|
# Skip header rows
|
||||||
|
if ct[0] == "G" and len(ct) > 1 and "Farbe" in ct[1]:
|
||||||
|
continue
|
||||||
|
|
||||||
|
# Column positions: G | Farbe | Name | Partner | Abnehmer | ABD | T.D
|
||||||
|
# Some newer tables add ABGew between ABD and T.D (7 or 8 cols)
|
||||||
|
g_col = ct[0] if len(ct) > 0 else ""
|
||||||
|
farbe_raw = ct[1] if len(ct) > 1 else ""
|
||||||
|
name = ct[2] if len(ct) > 2 else ""
|
||||||
|
partner = ct[3] if len(ct) > 3 else ""
|
||||||
|
owner = ct[4] if len(ct) > 4 else ""
|
||||||
|
abd_raw = ct[5] if len(ct) > 5 else ""
|
||||||
|
# If 8 cols, col 6 = ABGew, col 7 = T.D; if 7 cols, col 6 = T.D
|
||||||
|
if len(ct) >= 8:
|
||||||
|
abgew = ct[6]
|
||||||
|
tod_raw = ct[7]
|
||||||
|
elif len(ct) >= 7:
|
||||||
|
abgew = ""
|
||||||
|
tod_raw = ct[6]
|
||||||
|
else:
|
||||||
|
abgew = ""
|
||||||
|
tod_raw = ""
|
||||||
|
|
||||||
|
# Skip placeholders
|
||||||
|
name = name.strip()
|
||||||
|
if name in PLACEHOLDER_NAMES:
|
||||||
|
continue
|
||||||
|
if not farbe_raw.strip() and not name:
|
||||||
|
continue
|
||||||
|
|
||||||
|
# Gender: explicit marker in G column, or * suffix on Farbschlag
|
||||||
|
is_male = bool(g_col.strip() == "*" or farbe_raw.endswith("*"))
|
||||||
|
farbschlag = farbe_raw.rstrip("*").strip()
|
||||||
|
|
||||||
|
# Owner: strip internal sentinels
|
||||||
|
owner_clean = owner.strip()
|
||||||
|
if _is_internal(owner_clean):
|
||||||
|
owner_clean = ""
|
||||||
|
# For multi-owner ("1.) Julia2.) RG:"), take first
|
||||||
|
m1 = re.match(r"1\.\)\s*(.+?)(?:2\.\)|$)", owner_clean)
|
||||||
|
if m1:
|
||||||
|
owner_clean = m1.group(1).strip()
|
||||||
|
|
||||||
|
# ABD (Abgabe-Datum)
|
||||||
|
abgabe_date = _norm_dob(abd_raw.strip())
|
||||||
|
|
||||||
|
# T.D column: may start with a date followed by cause
|
||||||
|
death_date = ""
|
||||||
|
death_cause = ""
|
||||||
|
if tod_raw:
|
||||||
|
dm = DATE_START_RE.match(tod_raw.strip())
|
||||||
|
if dm:
|
||||||
|
death_date = _norm_dob(dm.group(1))
|
||||||
|
death_cause = dm.group(2).strip()
|
||||||
|
else:
|
||||||
|
death_cause = tod_raw.strip()
|
||||||
|
|
||||||
|
# Partner name and DOB
|
||||||
|
partner_clean = partner.strip()
|
||||||
|
partner_dob = ""
|
||||||
|
pdob_m = PARTNER_DOB_RE.search(partner_clean)
|
||||||
|
if pdob_m:
|
||||||
|
partner_dob = _norm_dob(pdob_m.group(1))
|
||||||
|
partner_clean = PARTNER_DOB_RE.sub("", partner_clean).strip()
|
||||||
|
# Strip VG:/ZT/etc. prefixes
|
||||||
|
partner_clean = re.sub(r"^(?:VG\*?:|ZT\s*)", "", partner_clean).strip()
|
||||||
|
# Take first partner in numbered list
|
||||||
|
pm1 = re.match(r"1\.\)\s*(.+?)(?:2\.\)|$)", partner_clean)
|
||||||
|
if pm1:
|
||||||
|
partner_clean = pm1.group(1).strip()
|
||||||
|
|
||||||
|
animals.append({
|
||||||
|
"wsCode": active_ws,
|
||||||
|
"litterDob": active_dob,
|
||||||
|
"name": name,
|
||||||
|
"farbschlag": farbschlag,
|
||||||
|
"gender": "male" if is_male else "female",
|
||||||
|
"owner": owner_clean,
|
||||||
|
"abgabeDate": abgabe_date,
|
||||||
|
"abgabeWeight": abgew.strip(),
|
||||||
|
"deathDate": death_date,
|
||||||
|
"deathCause": death_cause,
|
||||||
|
"partnerName": partner_clean,
|
||||||
|
"partnerDob": partner_dob,
|
||||||
|
})
|
||||||
|
|
||||||
|
return litters, animals
|
||||||
|
|
||||||
|
|
||||||
|
def main():
|
||||||
|
try:
|
||||||
|
sys.stdout.reconfigure(encoding="utf-8", errors="replace")
|
||||||
|
except Exception:
|
||||||
|
pass
|
||||||
|
|
||||||
|
ap = argparse.ArgumentParser(description="FEAT-8d docx extractor")
|
||||||
|
ap.add_argument("--docx", default=DEFAULT_DOCX,
|
||||||
|
help="Pfad zur 'im Detail.docx'")
|
||||||
|
args = ap.parse_args()
|
||||||
|
|
||||||
|
if not os.path.isfile(args.docx):
|
||||||
|
print(f"Fehler: Datei nicht gefunden: {args.docx}", file=sys.stderr)
|
||||||
|
sys.exit(1)
|
||||||
|
|
||||||
|
os.makedirs(OUT, exist_ok=True)
|
||||||
|
|
||||||
|
print(f"Lese: {args.docx}")
|
||||||
|
litters, animals = extract(args.docx)
|
||||||
|
|
||||||
|
litters_path = os.path.join(OUT, "docx_litters.json")
|
||||||
|
animals_path = os.path.join(OUT, "docx_animals.json")
|
||||||
|
|
||||||
|
with open(litters_path, "w", encoding="utf-8") as f:
|
||||||
|
json.dump(litters, f, ensure_ascii=False, indent=2)
|
||||||
|
with open(animals_path, "w", encoding="utf-8") as f:
|
||||||
|
json.dump(animals, f, ensure_ascii=False, indent=2)
|
||||||
|
|
||||||
|
# Stats
|
||||||
|
named = sum(1 for a in animals if a["name"])
|
||||||
|
with_owner = sum(1 for a in animals if a["owner"])
|
||||||
|
with_death = sum(1 for a in animals if a["deathDate"])
|
||||||
|
with_abgabe = sum(1 for a in animals if a["abgabeDate"])
|
||||||
|
|
||||||
|
print(f"Würfe: {len(litters)}")
|
||||||
|
print(f"Tiere: {len(animals)} (benannt: {named})")
|
||||||
|
print(f" mit Abnehmer: {with_owner}")
|
||||||
|
print(f" mit Abgabe-Dat: {with_abgabe}")
|
||||||
|
print(f" mit Tod-Datum: {with_death}")
|
||||||
|
print(f"Ausgabe: {OUT}")
|
||||||
|
|
||||||
|
|
||||||
|
if __name__ == "__main__":
|
||||||
|
main()
|
||||||
77
tools/import/test_extract_docx.py
Normal file
77
tools/import/test_extract_docx.py
Normal file
@@ -0,0 +1,77 @@
|
|||||||
|
"""Tests for extract_docx.py — run: python test_extract_docx.py"""
|
||||||
|
import sys
|
||||||
|
import os
|
||||||
|
|
||||||
|
# Require the docx to exist; skip if not present (CI won't have it)
|
||||||
|
DOCX = os.path.join(r"C:\Users\gulum\dev",
|
||||||
|
"Wurfchronik der Kleinen Chaoten im Detail.docx")
|
||||||
|
SKIP = not os.path.isfile(DOCX)
|
||||||
|
|
||||||
|
import extract_docx as ed
|
||||||
|
|
||||||
|
failed = 0
|
||||||
|
|
||||||
|
def check(name, cond):
|
||||||
|
global failed
|
||||||
|
print(("ok: " if cond else "FAIL: ") + name)
|
||||||
|
if not cond:
|
||||||
|
failed += 1
|
||||||
|
|
||||||
|
# --- _norm_dob ---
|
||||||
|
check("norm_dob 2-digit year", ed._norm_dob("12.09.21") == "12.09.2021")
|
||||||
|
check("norm_dob 4-digit year", ed._norm_dob("07.04.2019") == "07.04.2019")
|
||||||
|
check("norm_dob empty", ed._norm_dob("") == "")
|
||||||
|
|
||||||
|
# --- _LAST_DATE_RE ---
|
||||||
|
check("last date: simple", ed._LAST_DATE_RE.findall("07.04.2019") == ["07.04.2019"])
|
||||||
|
check("last date: dual-day", ed._LAST_DATE_RE.findall("16./17.03.2021") == ["17.03.2021"])
|
||||||
|
check("last date: dual-month", ed._LAST_DATE_RE.findall("31.05/*01.06.2023") == ["01.06.2023"])
|
||||||
|
|
||||||
|
# --- _is_internal ---
|
||||||
|
check("ZT is internal", ed._is_internal("ZT"))
|
||||||
|
check("BLEIBT is internal", ed._is_internal("BLEIBT"))
|
||||||
|
check("VG: is internal", ed._is_internal("VG: Partner"))
|
||||||
|
check("real name not internal", not ed._is_internal("Marion Teichmann"))
|
||||||
|
|
||||||
|
# --- LITTER_RE ---
|
||||||
|
cases = [
|
||||||
|
("D19-Wurf *07.04.2019Von: Xhemile gen. Chanel v.d. Kleinen Chaoten & Omero v.d. Kleinen Chaoten WS: 2/4Notiz:", "2/4", "07.04.2019"),
|
||||||
|
("-Wurf *16./17.03.2021Von: Victoria Welby v.d. Kleinen Chaoten & Patch v.d. Kleinen Chaoten WS: /5Notiz:", "/5", "16./17.03.2021"),
|
||||||
|
("S22-Wurf *31.05/*01.06.2023Von: Velvet v.d. Kleinen Chaoten & Vance Sohn v.d. Kleinen ChaotenWS: 3/3", "3/3", "31.05/*01.06.2023"),
|
||||||
|
("Q21-Wurf *21.03.2022Von: Belica gen. Emi v.d. Kleinen Chaoten & Zac gen. Action v.d. Kleinen ChaotenWS: 2/4Notiz:", "2/4", "21.03.2022"),
|
||||||
|
]
|
||||||
|
for para, expected_ws, _ in cases:
|
||||||
|
m = ed.LITTER_RE.search(para)
|
||||||
|
ws = m.group(5).replace(" ", "") if m else None
|
||||||
|
check(f"LITTER_RE matches: {para[:50]}...", ws == expected_ws)
|
||||||
|
|
||||||
|
if SKIP:
|
||||||
|
print("(Skipping live-docx tests: file not found)")
|
||||||
|
else:
|
||||||
|
litters, animals = ed.extract(DOCX)
|
||||||
|
check("93 litters extracted", len(litters) == 93)
|
||||||
|
check("All litters have wsCode", all(l["wsCode"] for l in litters))
|
||||||
|
check("All litters have dob", all(l["dob"] for l in litters))
|
||||||
|
check(">200 named animals", len(animals) >= 200)
|
||||||
|
check(">150 animals with owner", sum(1 for a in animals if a["owner"]) >= 150)
|
||||||
|
check(">20 animals with death date", sum(1 for a in animals if a["deathDate"]) >= 20)
|
||||||
|
# Verify first litter
|
||||||
|
d19 = next((l for l in litters if l["litterId"] == "D19-Wurf"), None)
|
||||||
|
check("D19-Wurf found", d19 is not None)
|
||||||
|
check("D19-Wurf dob correct", d19 and d19["dob"] == "07.04.2019")
|
||||||
|
check("D19-Wurf wsCode = 2/4", d19 and d19["wsCode"] == "2/4")
|
||||||
|
check("D19-Wurf mother contains Xhemile", d19 and "Xhemile" in d19["motherName"])
|
||||||
|
# Verify Eddie in animals
|
||||||
|
eddie = next((a for a in animals if a["name"] == "Eddie" and a["wsCode"] == "2/4"), None)
|
||||||
|
check("Eddie found in D19-Wurf", eddie is not None)
|
||||||
|
check("Eddie gender=male (Zobel* suffix)", eddie and eddie["gender"] == "male")
|
||||||
|
check("Eddie abgabeDate", eddie and eddie["abgabeDate"] == "12.09.2021")
|
||||||
|
# Flash death date
|
||||||
|
flash = next((a for a in animals if a["name"] == "Flash" and a["wsCode"] == "3/3"), None)
|
||||||
|
check("Flash death date extracted", flash and flash["deathDate"] == "16.09.2023")
|
||||||
|
check("Flash death cause extracted", flash and "Tumor" in flash["deathCause"])
|
||||||
|
|
||||||
|
if failed:
|
||||||
|
print(f"\n{failed} test(s) FAILED")
|
||||||
|
sys.exit(1)
|
||||||
|
print("\nALL PASS")
|
||||||
Reference in New Issue
Block a user