package org.berzerkula.builddb.repositories;

import org.assertj.core.api.Assertions;
import org.berzerkula.builddb.models.Pkg;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.autoconfigure.jdbc.AutoConfigureTestDatabase;
import org.springframework.boot.test.autoconfigure.orm.jpa.DataJpaTest;

@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
class PkgRepositoryTest {

    @Autowired
    PkgRepository pkgRepository;

    @Test
    void testCreateReadDelete() {

        Pkg pkg = new Pkg(123, "Test", "1.2.3", "",
                "", "", "", "", "");

        pkgRepository.save(pkg);

        Iterable<Pkg> pkgs = pkgRepository.findAll();
        Assertions.assertThat(pkgs).extracting(Pkg::getSequence).containsOnly(123);

        pkgRepository.deleteAll();
        Assertions.assertThat(pkgRepository.findAll()).isEmpty();
    }

}