/**
    * 
    */
   package org.melati.poem.dbms.test;
   
   import org.melati.poem.dbms.DbmsFactory;
   
   /**
    * @author timp
   * @since 23 Jan 2007
   *
   */
  public class InterbaseTest extends DbmsSpec {
  
    /**
     * Constructor.
     * @param name
     */
    public InterbaseTest(String name) {
      super(name);
    }
  
    /**
     * {@inheritDoc}
     * @see org.melati.poem.dbms.test.DbmsSpec#setUp()
     */
    protected void setUp() throws Exception {
      super.setUp();
    }
  
    /**
     * {@inheritDoc}
     * @see org.melati.poem.dbms.test.DbmsSpec#tearDown()
     */
    protected void tearDown() throws Exception {
      super.tearDown();
    }
  
    protected void setObjectUnderTest() {
      it = DbmsFactory.getDbms("org.melati.poem.dbms.Interbase");    
    }
  
    /**
     * Test method for {@link org.melati.poem.dbms.Dbms#
     * getStringSqlDefinition(java.lang.String)}.
     */
    public void testGetStringSqlDefinition() throws Exception {
      assertEquals("blob sub_type 1",  it.getStringSqlDefinition(-1));
      assertEquals("VARCHAR(0)", it.getStringSqlDefinition(0));    
    }
  
    /**
     * Test method for {@link org.melati.poem.dbms.Dbms#
     * getSqlDefinition(java.lang.String)}.
     * @throws Exception 
     */
    public void testGetSqlDefinition() throws Exception {
      assertEquals("INT", it.getSqlDefinition("BOOLEAN"));
      assertEquals("DOUBLE PRECISION", it.getSqlDefinition("DOUBLE PRECISION"));
      assertEquals("INT8", it.getSqlDefinition("INT8"));
      assertEquals("Big Decimal", it.getSqlDefinition("Big Decimal"));
    }
  
    
    /**
     * Test method for {@link org.melati.poem.dbms.Dbms#
     * getForeignKeyDefinition(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)}.
     */
    public void testGetForeignKeyDefinition() {
      assertEquals(" ADD FOREIGN KEY (quser) REFERENCES quser(qid) ON DELETE CASCADE",it.getForeignKeyDefinition("test", "user", "user", "id", "delete"));
    }
  
    /**
     * Test method for {@link org.melati.poem.dbms.Dbms#
     * getPrimaryKeyDefinition(java.lang.String)}.
     */
    public void testGetPrimaryKeyDefinition() {
      assertEquals(" ADD PRIMARY KEY (qname)", it.getPrimaryKeyDefinition("name"));
    }
  
  
  }