package com.makananbekuenak.kyurifood.dao;

import com.makananbekuenak.kyurifood.AplikasiDistribusiWebApplication;
import javax.transaction.Transactional;
import com.makananbekuenak.kyurifood.entity.Produk;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.SpringApplicationConfiguration;
import org.springframework.test.context.jdbc.Sql;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

/**
 *
 * @author satria
 */

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = AplikasiDistribusiWebApplication.class)
@Transactional
@Sql(scripts = {"/mysql/delete-data.sql", "/mysql/sample-produk.sql"})
public class ProdukDaoTest {

    @Autowired
    private ProdukDao produkDao;

    @Test
    public void testSave() {
        Produk p = new Produk();
        Assert.assertNull(p.getKode());
        Assert.assertNull(p.getNama());
        produkDao.save(p);
        Assert.assertNotNull(p.getKode());
    }
    
    public void testCariBykode(){
        Assert.assertNotNull(produkDao.findOne("nnn"));
        Assert.assertNull(produkDao.findOne("aaa"));
    }
}

package com.makananbekuenak.kyurifood.dao;

import com.makananbekuenak.kyurifood.AplikasiDistribusiWebApplication;
import javax.transaction.Transactional;
import com.makananbekuenak.kyurifood.entity.Produk;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.SpringApplicationConfiguration;
import org.springframework.test.context.jdbc.Sql;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

/**
 *
 * @author satria
 */

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = AplikasiDistribusiWebApplication.class)
@Transactional
@Sql(scripts = {"/mysql/delete-data.sql", "/mysql/sample-produk.sql"})
public class ProdukDaoTest {

    @Autowired
    private ProdukDao produkDao;

    @Test
    public void testSave() {
        Produk p = new Produk();
        Assert.assertNull(p.getKode());
        Assert.assertNull(p.getNama());
        produkDao.save(p);
        Assert.assertNotNull(p.getKode());
    }
    
    @Test
    public void testCariBykode(){
        Assert.assertNotNull(produkDao.findOne("nnn"));
        Assert.assertNull(produkDao.findOne("aaa"));
    }
}

update tabel produk