data/seed_database.py

from data.database import get_connection, initialize_database

SAMPLE_BOOKS = [
    {
        "title": "1984",
        "author": "George Orwell",
        "category": "Distopya",
        "price": 180.00,
        "stock": 10,
    },
    {
        "title": "Hayvan Çiftliği",
        "author": "George Orwell",
        "category": "Distopya",
        "price": 145.00,
        "stock": 13,
    },
    {
        "title": "Cesur Yeni Dünya",
        "author": "Aldous Huxley",
        "category": "Distopya",
        "price": 195.00,
        "stock": 7,
    },
    {
        "title": "Fahrenheit 451",
        "author": "Ray Bradbury",
        "category": "Distopya",
        "price": 175.00,
        "stock": 8,
    },
    {
        "title": "Dune",
        "author": "Frank Herbert",
        "category": "Bilim Kurgu",
        "price": 320.00,
        "stock": 7,
    },
    {
        "title": "Dune Mesihi",
        "author": "Frank Herbert",
        "category": "Bilim Kurgu",
        "price": 285.00,
        "stock": 5,
    },
    {
        "title": "Vakıf",
        "author": "Isaac Asimov",
        "category": "Bilim Kurgu",
        "price": 260.00,
        "stock": 9,
    },
    {
        "title": "Ben, Robot",
        "author": "Isaac Asimov",
        "category": "Bilim Kurgu",
        "price": 230.00,
        "stock": 6,
    },
    {
        "title": "Marslı",
        "author": "Andy Weir",
        "category": "Bilim Kurgu",
        "price": 290.00,
        "stock": 8,
    },
    {
        "title": "Otostopçunun Galaksi Rehberi",
        "author": "Douglas Adams",
        "category": "Bilim Kurgu",
        "price": 245.00,
        "stock": 11,
    },
    {
        "title": "Simyacı",
        "author": "Paulo Coelho",
        "category": "Roman",
        "price": 150.00,
        "stock": 8,
    },
    {
        "title": "Körlük",
        "author": "José Saramago",
        "category": "Roman",
        "price": 210.00,
        "stock": 4,
    },
    {
        "title": "Serenad",
        "author": "Zülfü Livaneli",
        "category": "Roman",
        "price": 225.00,
        "stock": 10,
    },
    {
        "title": "Kürk Mantolu Madonna",
        "author": "Sabahattin Ali",
        "category": "Roman",
        "price": 135.00,
        "stock": 15,
    },
    {
        "title": "İnce Memed",
        "author": "Yaşar Kemal",
        "category": "Roman",
        "price": 280.00,
        "stock": 7,
    },
    {
        "title": "Tutunamayanlar",
        "author": "Oğuz Atay",
        "category": "Roman",
        "price": 340.00,
        "stock": 6,
    },
    {
        "title": "Saatleri Ayarlama Enstitüsü",
        "author": "Ahmet Hamdi Tanpınar",
        "category": "Roman",
        "price": 220.00,
        "stock": 8,
    },
    {
        "title": "Suç ve Ceza",
        "author": "Fyodor Dostoyevski",
        "category": "Klasik",
        "price": 240.00,
        "stock": 6,
    },
    {
        "title": "Karamazov Kardeşler",
        "author": "Fyodor Dostoyevski",
        "category": "Klasik",
        "price": 390.00,
        "stock": 4,
    },
    {
        "title": "Sefiller",
        "author": "Victor Hugo",
        "category": "Klasik",
        "price": 360.00,
        "stock": 5,
    },
    {
        "title": "Monte Cristo Kontu",
        "author": "Alexandre Dumas",
        "category": "Klasik",
        "price": 410.00,
        "stock": 3,
    },
    {
        "title": "Anna Karenina",
        "author": "Lev Tolstoy",
        "category": "Klasik",
        "price": 375.00,
        "stock": 5,
    },
    {
        "title": "Vadideki Zambak",
        "author": "Honoré de Balzac",
        "category": "Klasik",
        "price": 170.00,
        "stock": 7,
    },
    {
        "title": "Yüzüklerin Efendisi",
        "author": "J. R. R. Tolkien",
        "category": "Fantastik",
        "price": 450.00,
        "stock": 5,
    },
    {
        "title": "Hobbit",
        "author": "J. R. R. Tolkien",
        "category": "Fantastik",
        "price": 275.00,
        "stock": 9,
    },
    {
        "title": "Harry Potter ve Felsefe Taşı",
        "author": "J. K. Rowling",
        "category": "Fantastik",
        "price": 260.00,
        "stock": 12,
    },
    {
        "title": "Taht Oyunları",
        "author": "George R. R. Martin",
        "category": "Fantastik",
        "price": 390.00,
        "stock": 6,
    },
    {
        "title": "Küçük Prens",
        "author": "Antoine de Saint-Exupéry",
        "category": "Çocuk",
        "price": 120.00,
        "stock": 12,
    },
    {
        "title": "Şeker Portakalı",
        "author": "José Mauro de Vasconcelos",
        "category": "Çocuk",
        "price": 155.00,
        "stock": 10,
    },
    {
        "title": "Momo",
        "author": "Michael Ende",
        "category": "Çocuk",
        "price": 190.00,
        "stock": 8,
    },
    {
        "title": "Sapiens",
        "author": "Yuval Noah Harari",
        "category": "Tarih",
        "price": 290.00,
        "stock": 9,
    },
    {
        "title": "Homo Deus",
        "author": "Yuval Noah Harari",
        "category": "Tarih",
        "price": 310.00,
        "stock": 7,
    },
    {
        "title": "Nutuk",
        "author": "Mustafa Kemal Atatürk",
        "category": "Tarih",
        "price": 250.00,
        "stock": 14,
    },
    {
        "title": "Doğu Ekspresinde Cinayet",
        "author": "Agatha Christie",
        "category": "Polisiye",
        "price": 185.00,
        "stock": 9,
    },
    {
        "title": "Sherlock Holmes: Kızıl Dosya",
        "author": "Arthur Conan Doyle",
        "category": "Polisiye",
        "price": 165.00,
        "stock": 8,
    },
    {
        "title": "Ejderha Dövmeli Kız",
        "author": "Stieg Larsson",
        "category": "Polisiye",
        "price": 280.00,
        "stock": 5,
    },
    {
        "title": "İnsanın Anlam Arayışı",
        "author": "Viktor E. Frankl",
        "category": "Psikoloji",
        "price": 190.00,
        "stock": 11,
    },
    {
        "title": "Düşünme, Hızlı ve Yavaş",
        "author": "Daniel Kahneman",
        "category": "Psikoloji",
        "price": 350.00,
        "stock": 6,
    },
    {
        "title": "Sofinin Dünyası",
        "author": "Jostein Gaarder",
        "category": "Felsefe",
        "price": 275.00,
        "stock": 8,
    },
    {
        "title": "Devlet",
        "author": "Platon",
        "category": "Felsefe",
        "price": 215.00,
        "stock": 7,
    },
]


def seed_books() -> None:
    """Örnek kitapları veritabanına ekler."""

    initialize_database()

    query = """
        INSERT OR IGNORE INTO books (
            title,
            author,
            category,
            price,
            stock
        )
        VALUES (?, ?, ?, ?, ?)
    """

    with get_connection() as connection:
        for book in SAMPLE_BOOKS:
            connection.execute(
                query,
                (
                    book["title"],
                    book["author"],
                    book["category"],
                    book["price"],
                    book["stock"],
                ),
            )

        connection.commit()

        book_count = connection.execute(
            "SELECT COUNT(*) AS total FROM books"
        ).fetchone()["total"]

    print("Örnek kitaplar başarıyla eklendi.")
    print(f"Veritabanındaki toplam kitap sayısı: {book_count}")


if __name__ == "__main__":
    seed_books()