/*
 *    GeoTools - The Open Source Java GIS Toolkit
 *    http://geotools.org
 *
 *    (C) 2002-2010, Open Source Geospatial Foundation (OSGeo)
 *
 *    This library is free software; you can redistribute it and/or
 *    modify it under the terms of the GNU Lesser General Public
 *    License as published by the Free Software Foundation;
 *    version 2.1 of the License.
 *
 *    This library is distributed in the hope that it will be useful,
 *    but WITHOUT ANY WARRANTY; without even the implied warranty of
 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *    Lesser General Public License for more details.
 */
package org.geotools.data.teradata;

import org.geotools.jdbc.JDBCUDTTestSetup;

public class TeradataUDTTestSetup extends JDBCUDTTestSetup {

    public TeradataUDTTestSetup() {
        this(new TeradataTestSetup());
    }

    public TeradataUDTTestSetup(TeradataTestSetup setup) {
        super(setup);
    }


    protected void createUdtTable() throws Exception {
// TODO make restriction        run("CREATE TYPE foo AS text CHECK (VALUE ~ '\\\\d{2}\\\\D{2}');");
        run("CREATE TYPE foo AS varchar(4) final");
        run("CREATE TABLE udt (id integer PRIMARY KEY NOT NULL, ut foo);");
        run("INSERT INTO udt VALUES (0, '12ab');");

    }


    protected void dropUdtTable() throws Exception {
        runSafe("DROP TABLE udt");
        runSafe("DROP TYPE foo");
    }

}