o ¯%j%@sZdZddlZddlmZedZejjddddZgdZd d Z e d kr+e dSdS) zCreate the Plappi marketing DB and seed the target list. Idempotent: re-running creates tables IF NOT EXISTS and only inserts a target when no row with the same (channel, name) already exists. Safe to re-run. N)Pathz2/home/agent/plappi-marketing/data/marketing.sqliteT)parentsexist_oku CREATE TABLE IF NOT EXISTS targets ( id INTEGER PRIMARY KEY, channel TEXT NOT NULL, -- 'press' | 'social' platform TEXT NOT NULL, -- email,podcast,reddit,facebook_group,instagram,tiktok,telegram,forum,linkedin,quora name TEXT NOT NULL, contact TEXT, -- email / URL / handle url TEXT, wave TEXT, -- press: A,A2,A3,A4,B,C · social: tier1,tier2 angle TEXT, -- A/B/C pitch angle or topic note posting_mode TEXT NOT NULL, -- email | auto_own | manual_community | paid rules TEXT, -- compliance reminder shown before posting language TEXT, -- de | en priority INTEGER DEFAULT 3, status TEXT DEFAULT 'active', -- active | contacted | replied | done | skip notes TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) ); CREATE TABLE IF NOT EXISTS items ( id INTEGER PRIMARY KEY, target_id INTEGER, channel TEXT NOT NULL, type TEXT NOT NULL, -- press_email | press_followup | social_post | social_comment platform TEXT, subject TEXT, body TEXT NOT NULL, disclosure TEXT, -- 'Werbung' / NULL status TEXT DEFAULT 'pending', -- pending|approved|sent|posted|rejected|superseded|replied|needs_followup scheduled_for TEXT, thread_ref TEXT, fix_iterations INTEGER DEFAULT 0, prompt_used TEXT, model_used TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), approved_at TEXT, sent_at TEXT, FOREIGN KEY (target_id) REFERENCES targets(id) ); CREATE TABLE IF NOT EXISTS events ( id INTEGER PRIMARY KEY, item_id INTEGER, event TEXT, detail TEXT, ts TEXT DEFAULT (datetime('now')) ); )%) pressemailzDer Brutkastenzredaktion@derbrutkasten.comzbrutkasten.comABrde) rrdeutsche-startups.dezahuesing@deutsche-startups.der rrru-Hüsing antwortet persönlich — kurz haltenr r ) rruGründerszene / BI DEzredaktion@gruenderszene.dez businessinsider.de/gruenderszenerrrr r r ) rrt3nz tipp@t3n.dezt3n.derrrzcoverte Toniesr ) rrz EU-Startupszantonio@eu-startups.comzeu-startups.comrrrr enr) rrzStartupticker.chznews@startupticker.chzstartupticker.chrrrr r r) rrzStartnext Pressezpresse@startnext.comz startnext.comrrrr r r) rrzTrending Topicsr ztrendingtopics.eurrru0Kontakt via Site-Formular (kein Mail bestätigt)r r) rrz Futurezone.atr zfuturezone.at/start-upsrrrz Start-ups-Desk; Kontakt via Siter r) rrztech.eur ztech.eu/startup-formrrrzPitch via Startup-Formularrr) rrz Eltern.dezredaktion@eltern.dez eltern.deA3Crr r r ) rrbilingual-erziehen.dezinfo@bilingual-erziehen.derrrru'Review/Gastbeitrag, Testgerät anbietenr r ) rrzLinguamulti (Z. Ortega)zz.ortega@linguamulti.atzlinguamulti.atrrru"Testimonial + Tür zu Der Standardr r ) rrgerman-toys.comzinfo@german-toys.comrrrrzAngle: Plappi vs. Tonieboxr r ) rrzfratz&cozredaktion@timepub.atzfratz.atrrrr r r) rr babelli.dezinfo@babelli.derrrrr r r) rrz Sprachheld.der z sprachheld.derrrz,Gastbeitrag-Formular, 2-4 Themen vorschlagenr r) rrzSpielzeugwelten.dezinfo@spielzeugwelten.dezspielzeugwelten.derrrzTestmuster anbietenr r) rpodcastzDie Linguistin (B. Gruber)zinfo@dielinguistin.atzdielinguistin.atA4rrGründer als Gastr r) rrzBOLD & BILINGUAL (S. Edelhoff)zsabine@belingualathome.comzbelingualathome.comrrrrr r) rrzEngadget (K. Naudus)r z engadget.comrrru Yoto-Hands-on; Testgerät nötigr) rrzWirecutter/NYT (A. Rochford)r znytimes.com/wirecutterrrruYoto-Test; Testgerät nötigrr) rru'The Toy Book — Talkin' Toys (J. Zahn)r z toybook.comrrrz&coverte TIMIO+Storypod; @TheRockFatherrr) rrz The Gadgeteerr zthe-gadgeteer.comrrru!Kids-Audio-Vergleiche; Testgerätrr) socialredditzr/multilingualparenting"reddit.com/r/multilingualparentingrtier1rmanual_communityzS90/10-Regel, value-first, 'I'm the founder' offenlegen, nur in Promo-Threads werbenrr ) rrz r/germanyreddit.com/r/germanyrrrrz8Toniebox-Threads laufen dort; value-first, kein Linkdroprr) rrz r/austriareddit.com/r/austriarrrrz(value-first, AT-Startup-Angle, kein Spamr r) rrzr/Elternreddit.com/r/Elternr rrrzklein aber exakt; value-firstr r) rfacebook_groupz'Raising Bilingual/Multilingual Childrenz8facebook.com/groups/RaisingBilingualMultilingualChildrenr rrru4Gruppenregeln lesen, Admin-OK/Promo-Tag für Werbungrr ) rr!z*Bilingual Kidspot (Little Global Citizens)z$facebook.com/groups/bilingualkidspotr rrrzGruppenregeln, value-firstrr ) rr!z.Non-native Speakers Raising Bilingual Childrenz#facebook.com/groups/277780785899414r rrru)exakter Fit; Admin-Erlaubnis für Werbungrr) rr!zToniebox Communityz$facebook.com/groups/2424166074431755r rrru:warm für screen-free Audio; vorsichtig, kein harter Pitchrr) rforumu$urbia.de — Mehrsprachig aufwachsenzurbia.de/forum/21-erziehungr rrrzADE-Forum; org. Teilnahme + Offenlegung, Werbung sonst nur bezahltr r) rr"u#rund-ums-baby.de — /mehrsprachig/z*rund-ums-baby.de/eltern-forum/mehrsprachigr rrrz/dediziertes Subforum; value-first + Offenlegungr r) r instagramzPlappi Instagram @helloplappizinstagram.com/helloplappirrauto_ownz%eigener Kanal; 'Werbung' kennzeichnenr r) rtiktokz Plappi TikTokr$ztiktok.com/@helloplappirrr%z4eigener Kanal; Disclosure-Toggle + 'Werbung' Captionr r) rlinkedinzFounder LinkedIn (Plappi-Story)r z linkedin.comrrr%u.kann über bestehende LinkedIn-Pipeline laufenr rcCstt}|td}tD]"}|d|d}}|d||f}|r&q|d||d7}q||dd}|dd}| t dtt d |d |d |dS) Nrz0SELECT 1 FROM targets WHERE channel=? AND name=?zINSERT INTO targets (channel,platform,name,contact,url,wave,angle, posting_mode,rules,language,priority) VALUES (?,?,?,?,?,?,?,?,?,?,?)z2SELECT COUNT(*) FROM targets WHERE channel='press'z3SELECT COUNT(*) FROM targets WHERE channel='social'zDB ok: z inserted u new targets · press=z social=) sqlite3connectDB executescriptSCHEMATARGETSexecutefetchonecommitcloseprint)conninstchannelnameexistsn_pressn_socr=F/home/nk/hobo-godmode/otto/projekte/plappi/marketing/engine/init_db.pymainps.   r?__main__) __doc__r*pathlibrr,parentmkdirr.r/r?__name__r=r=r=r>s 21