package org.javanicus.gsql

public class Table extends GroovyObjectSupport implements Cloneable {
    @Property catalog
    @Property name
    @Property groovyName
    @Property schema
    @Property remarks
    @Property type
    @Property List columns
    @Property List foreignKeys
    @Property List indexes
    
    public Table(aName) {
        catalog = null
        name = aName
        groovyName = null
        schema = null
        remarks = null
        type = null
        columns = []
        foreignKeys = []
        indexes = []
    }

    public Object clone() { // throws CloneNotSupportedException {
        def result = new Table(name)

        result.catalog     = catalog
        result.name        = name
        result.groovyName  = groovyName
        result.schema      = schema
        result.remarks     = remarks
        result.type        = type
        result.columns     = columns.clone()
        result.foreignKeys = foreignKeys.clone()
        result.indexes     = indexes.clone()
        
        return result
    }

// @todo - cannot override property getter succesfully
//    public String getType() {
//        return (type == null) ? "(null)" : type
//    }

    public List getUniques() {
        indexes.findAll() {it.isUnique()}
    }
    
    
    public boolean hasPrimaryKey() {
        def aPrimaryKeyColumn = getColumns().find() {it.isPrimaryKey()}
        return aPrimaryKeyColumn != null
    }   
    public Object getProperty(String propertyName) {
        try {
            return super.getProperty(propertyName);
        } catch (Exception e) {
            return findColumn(propertyName);
        }
    }
    public Column findColumn(aName) {
        // @todo
        // warning 'name' inside closure refers to 'this.name', not method parameter called 'name' (in groovy 1.0b6) !!!
        getColumns().find() {it.name.equalsIgnoreCase(aName)}
    }

    public Index findIndex(aName) {
        getIndexes().find() {it.name.equalsIgnoreCase(aName)}
    }

    public List getPrimaryKeyColumns() {
        getColumns().findAll() {it.isPrimaryKey()}
    }

    public Column getAutoIncrementColumn() {
        getColumns().find() {it.isAutoIncrement()}
    }
    
    public String toString() {
        "Table[name=${name};columnCount=${columns.size()}]"
    }

}