package com.jbidwatcher.util.db;

import junit.framework.TestCase;
import com.jbidwatcher.util.config.JConfig;
import com.cyberfox.util.config.ErrorManagement;
import com.jbidwatcher.util.Record;
import com.jbidwatcher.util.HashBacked;
import com.jbidwatcher.Upgrader;

import java.util.List;
import java.sql.Savepoint;

/**
 * Created by IntelliJ IDEA.
 * User: mrs
 * Date: Jan 31, 2009
 * Time: 5:54:49 PM
 *
 *
 */
@SuppressWarnings({"UseOfSystemOutOrSystemErr"})
public class TableTest extends TestCase {
  Savepoint mSavepoint = null;
  public TableTest(String name) {
    super(name);
  }

  public void setUp() throws Exception {
    super.setUp();
    JConfig.setLogger(new ErrorManagement());
    JConfig.setConfiguration("db.user", "test_tables");
    JConfig.setConfiguration("db.autocommit", "false");
    Upgrader.upgrade();
  }

  public void tearDown() throws Exception {
    super.tearDown();
  }

  public void testCountEntries() throws Exception {
    Table t = new Table("entries");
    assertEquals(0, t.count());
  }

  public void testInsertData() throws Exception {
    Table t = new Table("categories");
    mSavepoint = t.getDB().getConnection().setSavepoint();
    assert(t.execute("DELETE FROM categories"));
    Record r = new Record();
    r.put("id", "1");
    r.put("name", "zarf");
    t.storeMap(r);
    List<Record> recs = t.findAll();
    for(Record rec : recs) {
      HashBacked h = new HashBacked(rec);
      System.err.println(h.dumpRecord());
    }
    assertEquals(1, t.count());
    t.getDB().getConnection().rollback(mSavepoint);
  }

  public void testDeleteData() throws Exception {
    Table t = new Table("categories");
    mSavepoint = t.getDB().getConnection().setSavepoint();
    assert(t.execute("DELETE FROM categories"));
    t.getDB().getConnection().rollback(mSavepoint);
    t.commit();
  }
}