mj'SrSSKJr SSKrSSKJr \"\5R5Rr \ S- r \ S- r Sr S S Sjjr S S S jjrg) u9SQLite schéma pro hotely, termíny letů a historii cen.) annotationsN)Pathdataz vacation.dba PRAGMA foreign_keys = ON; PRAGMA journal_mode = WAL; CREATE TABLE IF NOT EXISTS scrapes ( id INTEGER PRIMARY KEY AUTOINCREMENT, started_at TEXT NOT NULL, finished_at TEXT, hotels_ok INTEGER DEFAULT 0, flights_ok INTEGER DEFAULT 0, notes TEXT ); CREATE TABLE IF NOT EXISTS hotels ( id INTEGER PRIMARY KEY, slug TEXT NOT NULL, name TEXT NOT NULL, url TEXT NOT NULL, official_stars REAL, destination TEXT, destination_id INTEGER, area TEXT, country TEXT, lat REAL, lng REAL, airport_name TEXT, airport_iata TEXT, airport_distance TEXT, airport_distance_km REAL, beach_distance TEXT, center_distance TEXT, distances_json TEXT, benefits_json TEXT, summary TEXT, meals TEXT, meals_type TEXT, conditions TEXT, image_url TEXT, images_json TEXT, website TEXT, giata INTEGER, data_source INTEGER, provider_id TEXT, extra_json TEXT, updated_at TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS flights ( id INTEGER PRIMARY KEY AUTOINCREMENT, destination_id INTEGER, destination TEXT, country TEXT, departure_airport TEXT, departure_airport_id INTEGER, departure_date TEXT, return_date TEXT, nights INTEGER, price_from REAL, currency TEXT DEFAULT 'CZK', search_filter TEXT, source_url TEXT, scrape_id INTEGER, scraped_at TEXT NOT NULL, UNIQUE (destination_id, departure_airport_id, departure_date, return_date, nights) ); CREATE TABLE IF NOT EXISTS offers ( id INTEGER PRIMARY KEY AUTOINCREMENT, hotel_id INTEGER NOT NULL, offer_key TEXT NOT NULL, departure_date TEXT, return_date TEXT, nights INTEGER, days INTEGER, departure_airport TEXT, arrival_airport TEXT, meal TEXT, room TEXT, price_total REAL, price_per_person REAL, currency TEXT DEFAULT 'CZK', scope TEXT DEFAULT 'hotel', booking_url TEXT, raw_json TEXT, scrape_id INTEGER, scraped_at TEXT NOT NULL, UNIQUE (hotel_id, offer_key) ); CREATE TABLE IF NOT EXISTS price_history ( id INTEGER PRIMARY KEY AUTOINCREMENT, hotel_id INTEGER, offer_key TEXT NOT NULL, departure_date TEXT, return_date TEXT, nights INTEGER, departure_airport TEXT, meal TEXT, room TEXT, price REAL NOT NULL, currency TEXT DEFAULT 'CZK', scope TEXT, scrape_id INTEGER, scraped_at TEXT NOT NULL ); CREATE INDEX IF NOT EXISTS idx_history_key ON price_history(offer_key, scraped_at); CREATE INDEX IF NOT EXISTS idx_history_hotel ON price_history(hotel_id, scraped_at); CREATE INDEX IF NOT EXISTS idx_flights_dest ON flights(destination_id, departure_date); c[RSSS9 [R"U=(d [5n[R UlURS5 U$)NT)parentsexist_okzPRAGMA foreign_keys = ON)DATA_DIRmkdirsqlite3connectDB_PATHRow row_factoryexecute)pathconns /var/www/vacation/db.pyr r |sB NN4$N/ ??4?7 +D{{DLL+, KcUSLnU=(d [5nUR[5 URS5Vs1sHo"SiM nnSU;aURS5 UR 5 U(aU$U$s snf)NzPRAGMA table_info(offers)daysz*ALTER TABLE offers ADD COLUMN days INTEGER)r executescriptSCHEMArcommit)rownrowcolss rinit_dbrsx $,C  79Dv"ll+FG HGsFGD H T ABKKM  K IsB)N)rz Path | Nonereturnsqlite3.Connection)rzsqlite3.Connection | Nonerr )__doc__ __future__rr pathlibr__file__resolveparentROOTr r rr rrrr)sO?" H~&& &= ] "m ` r