From be55729482296663da8c96723bfd22080e6762c1 Mon Sep 17 00:00:00 2001
From: yyamashita <yyamashita@mosquit.one>
Date: Wed, 6 May 2026 22:07:53 +0900
Subject: Add Tokyo livehouse event aggregator service

Full-stack React Router v7 app that scrapes event listings from major
Tokyo live venues (Liquid Room, WWW/WWW X, Shibuya O-EAST, Shinjuku LOFT,
Club Quattro) and stores them in SQLite for browsing and search.

- Modular scraper architecture: add a new venue by dropping a file in
  app/scrapers/ and registering it in index.ts
- Routes: /events (filter by keyword/venue/date), /events/:id, /venues,
  GET /api/scrape
- EventCard shows artist, date/time, venue, ticket URL, and fee
- Post-scrape per-venue Markdown files generated to events/ (dev reference)
- /add-livehouse Claude Code skill defined in .claude/commands/

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
---
 app/scrapers/liquid-room.ts | 87 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 87 insertions(+)
 create mode 100644 app/scrapers/liquid-room.ts

(limited to 'app/scrapers/liquid-room.ts')

diff --git a/app/scrapers/liquid-room.ts b/app/scrapers/liquid-room.ts
new file mode 100644
index 0000000..b497759
--- /dev/null
+++ b/app/scrapers/liquid-room.ts
@@ -0,0 +1,87 @@
+/**
+ * Liquid Room (恵比寿) — https://www.liquidroom.net/schedule
+ *
+ * The schedule page lists events with JSON-LD or HTML data.
+ * Structure: <div class="p-schedule__item"> contains date, title, etc.
+ */
+import * as cheerio from "cheerio";
+import type { Scraper, VenueMeta } from "./base";
+import type { EventInput } from "~/lib/db.server";
+
+export const venue: VenueMeta = {
+  id: "liquid-room",
+  name: "LIQUID ROOM",
+  url: "https://www.liquidroom.net",
+  area: "恵比寿",
+};
+
+export const scraper: Scraper = {
+  venue,
+  async scrape(): Promise<EventInput[]> {
+    const res = await fetch("https://www.liquidroom.net/schedule");
+    if (!res.ok) throw new Error(`HTTP ${res.status}`);
+    const html = await res.text();
+    const $ = cheerio.load(html);
+    const events: EventInput[] = [];
+
+    $("article.p-schedule__item, .schedule-list__item, .c-event-item").each(
+      (_, el) => {
+        const $el = $(el);
+
+        const title =
+          $el.find(".p-schedule__title, .event-title, h3, h2").first().text().trim();
+        if (!title) return;
+
+        const dateStr =
+          $el.find(".p-schedule__date, .event-date, time").first().text().trim() ||
+          $el.find("time").attr("datetime") ||
+          "";
+        const date = parseJapaneseDate(dateStr);
+        if (!date) return;
+
+        const artist =
+          $el.find(".p-schedule__artist, .artist").first().text().trim() || null;
+        const startTime =
+          $el.find(".p-schedule__time, .open-time").first().text().trim().match(/\d{2}:\d{2}/)?.[0] ?? null;
+        const ticketUrl =
+          $el.find("a[href*='ticket'], a[href*='eplus'], a[href*='pia']").first().attr("href") ?? null;
+        const imageUrl =
+          $el.find("img").first().attr("src") ?? null;
+        const sourceUrl =
+          $el.find("a").first().attr("href") ?? null;
+
+        events.push({
+          venue_id: venue.id,
+          title,
+          artist,
+          date,
+          start_time: startTime,
+          ticket_url: ticketUrl,
+          image_url: imageUrl ? absoluteUrl(imageUrl, venue.url) : null,
+          source_url: sourceUrl ? absoluteUrl(sourceUrl, venue.url) : null,
+        });
+      }
+    );
+
+    return events;
+  },
+};
+
+function parseJapaneseDate(raw: string): string | null {
+  // Handles "2025.06.15" "2025/06/15" "2025年06月15日" "06.15" formats
+  const m =
+    raw.match(/(\d{4})[./年](\d{1,2})[./月](\d{1,2})/) ||
+    raw.match(/(\d{1,2})[./月](\d{1,2})/);
+  if (!m) return null;
+  if (m.length === 4) {
+    return `${m[1]}-${m[2].padStart(2, "0")}-${m[3].padStart(2, "0")}`;
+  }
+  const year = new Date().getFullYear();
+  return `${year}-${m[1].padStart(2, "0")}-${m[2].padStart(2, "0")}`;
+}
+
+function absoluteUrl(url: string, base: string): string {
+  if (url.startsWith("http")) return url;
+  if (url.startsWith("/")) return base + url;
+  return base + "/" + url;
+}
-- 
cgit v1.2.3