/*
 * Copyright (c) 2011, 2020 Oracle and/or its affiliates. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0 which is available at
 * http://www.eclipse.org/legal/epl-2.0,
 * or the Eclipse Distribution License v. 1.0 which is available at
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
 */

// Contributors:
//      tware - initial
package org.eclipse.persistence.jpars.test.util;

import jakarta.persistence.EntityManager;
import jakarta.persistence.EntityManagerFactory;

import org.eclipse.persistence.jpars.test.model.auction.StaticAddress;
import org.eclipse.persistence.jpars.test.model.auction.StaticAuction;
import org.eclipse.persistence.jpars.test.model.auction.StaticBid;
import org.eclipse.persistence.jpars.test.model.auction.StaticUser;

public class StaticModelDatabasePopulator {

    public static int USER1_ID;
    public static int USER2_ID;
    public static int USER3_ID;

    public static int AUCTION1_ID;
    public static int AUCTION2_ID;
    public static int AUCTION3_ID;

    public static int BID1_ID;
    public static int BID2_ID;
    public static int BID3_ID;

    public static int ADDRESS1_ID;

    public static void populateDB(EntityManagerFactory emf) {
        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();
        StaticUser user1 = user1();
        em.persist(user1);
        StaticAddress address1 = address1();
        em.persist(address1);
        user1.setAddress(address1);
        StaticUser user2 = user2();
        em.persist(user2);
        StaticUser user3 = user3();
        em.persist(user3);

        StaticAuction auction1 = auction1();
        em.persist(auction1);

        StaticAuction auction2 = auction1();
        em.persist(auction2);

        StaticAuction auction3 = auction1();
        em.persist(auction3);

        StaticBid bid1 = new StaticBid();
        bid1.setAmount(110);
        bid1.setTime(System.currentTimeMillis());
        bid1.setAuction(auction1);
        bid1.setUser(user1);
        em.persist(bid1);

        StaticBid bid2 = new StaticBid();
        bid2.setAmount(111);
        bid2.setTime(System.currentTimeMillis());
        bid2.setAuction(auction1);
        bid2.setUser(user2);
        em.persist(bid2);

        StaticBid bid3 = new StaticBid();
        bid3.setAmount(1100);
        bid3.setTime(System.currentTimeMillis());
        bid3.setAuction(auction2);
        bid3.setUser(user2);
        em.persist(bid3);

        em.getTransaction().commit();
        USER1_ID = user1.getId();
        USER2_ID = user2.getId();
        USER3_ID = user3.getId();

        AUCTION1_ID = auction1.getId();
        AUCTION2_ID = auction2.getId();
        AUCTION3_ID = auction3.getId();

        BID1_ID = bid1.getId();
        BID2_ID = bid2.getId();
        BID3_ID = bid3.getId();

        ADDRESS1_ID = address1.getId();
    }

    public static StaticUser user1() {
        StaticUser user = new StaticUser();
        user.setId(11);
        user.setName("user1");
        return user;
    }

    public static StaticUser user2() {
        StaticUser user = new StaticUser();
        user.setId(22);
        user.setName("user2");
        return user;
    }

    public static StaticUser user3() {
        StaticUser user = new StaticUser();
        user.setId(33);
        user.setName("user3");
        return user;
    }

    public static StaticAuction auction1() {
        StaticAuction auction = new StaticAuction();
        auction.setDescription("Auction 1");
        auction.setImage("auction1.jpg");
        auction.setName("A1");
        auction.setStartPrice(100);
        return auction;
    }

    public static StaticAuction auction2() {
        StaticAuction auction = new StaticAuction();
        auction.setDescription("Auction 2");
        auction.setImage("auction2.jpg");
        auction.setName("A2");
        auction.setStartPrice(1000);
        return auction;
    }

    public static StaticAuction auction3() {
        StaticAuction auction = new StaticAuction();
        auction.setDescription("Auction 3");
        auction.setImage("auction3.jpg");
        auction.setName("A3");
        auction.setStartPrice(1010);
        return auction;
    }

    public static StaticAddress address1() {
        StaticAddress address = new StaticAddress();
        address.setCity("Ottawa");
        address.setPostalCode("K1A1A1");
        address.setStreet("Rembrandt Rd.");
        address.setType("home");
        return address;
    }

    public static void cleanupDB(EntityManagerFactory emf) {
        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();

        em.createQuery("delete from StaticBid b").executeUpdate();
        em.createQuery("delete from StaticUser u").executeUpdate();
        em.createQuery("delete from StaticAddress d").executeUpdate();
        em.createQuery("delete from StaticAuction a").executeUpdate();

        em.getTransaction().commit();
    }
}