CommandTest.java

package net.sourceforge.mayfly.evaluation.command;

import junit.framework.TestCase;

import net.sourceforge.mayfly.datastore.Columns;

public class CommandTest extends TestCase {

    public void testParse() throws Exception {
        DropTable command = (DropTable) Command.fromSql("drop table FOO");
        assertEquals("FOO", command.table().tableName());
        assertFalse(command.ifExists);
    }
    
    public void testParseSecondExample() throws Exception {
        CreateTable command = (CreateTable) 
            Command.fromSql("Create Table Foo (a integer)");

        assertEquals("Foo", command.table());
        Columns columns = command.columns();
        assertEquals(1, columns.columnCount());
        assertEquals("a", columns.column(0).columnName());
    }
    
}