database.schema.ProductPriceTable Maven / Gradle / Ivy

Go to download
package database.schema;

import databaseconnector.api.Column;
import databaseconnector.api.sql.SQLTable;
import databaseconnector.api.sql.constraint.Constraint;
import databaseconnector.api.sql.constraint.NotNull;
import databaseconnector.api.sql.constraint.PrimaryKey;

import java.util.Arrays;
import java.util.HashSet;
import java.util.Set;

public class ProductPriceTable implements SQLTable {
    public static final Column ID = new Column() {
        @Override
        public String getName() {
            return "id";
        }

        @Override
        public String getDatatype() {
            return "VARCHAR(255)";
        }
    };

    public static final Column PRODUCT_ID = new Column() {
        @Override
        public String getName() {
            return "product_id";
        }

        @Override
        public String getDatatype() {
            return "VARCHAR(255)";
        }
    };

    public static final Column PRICE = new Column() {
        @Override
        public String getName() {
            return "price";
        }

        @Override
        public String getDatatype() {
            return "VARCHAR(255)";
        }
    };

    public static final Column CURRENCY_ID = new Column() {
        @Override
        public String getName() {
            return "currency_id";
        }

        @Override
        public String getDatatype() {
            return "VARCHAR(255)";
        }
    };

    public static final Column DATETIME = new Column() {
        @Override
        public String getName() {
            return "datetime";
        }

        @Override
        public String getDatatype() {
            return "TIMESTAMP(9) WITH TIME ZONE";
        }
    };

    @Override
    public Set getConstraints() {
        return new HashSet<>(Arrays.asList(
                new PrimaryKey(ID),
                new NotNull(PRODUCT_ID),
                new NotNull(PRICE),
                new NotNull(CURRENCY_ID),
                new NotNull(DATETIME)
        ));
    }

    @Override
    public String getName() {
        return "product_price";
    }

    @Override
    public Set getColumns() {
        return new HashSet<>(Arrays.asList(
                ID,
                PRODUCT_ID,
                PRICE,
                CURRENCY_ID,
                DATETIME
        ));
    }
}