com.premiumminds.persistence.utils.HibernateEnversDDLTest.java Source code

Java tutorial

Introduction

Here is the source code for com.premiumminds.persistence.utils.HibernateEnversDDLTest.java

Source

/**
 * Copyright (C) 2014 Premium Minds.
 *
 * This file is part of pm-persistence-utils.
 *
 * pm-persistence-utils 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, either version 3 of the License, or (at your option) any
 * later version.
 *
 * pm-persistence-utils 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.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with pm-persistence-utils. If not, see <http://www.gnu.org/licenses/>.
 */
package com.premiumminds.persistence.utils;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertTrue;

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileReader;
import java.io.PrintStream;

import org.apache.commons.io.IOUtils;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

public class HibernateEnversDDLTest {

    private final ByteArrayOutputStream outContent = new ByteArrayOutputStream();

    @Before
    public void setUpStreams() {
        System.setOut(new PrintStream(outContent));
    }

    @After
    public void cleanUpStreams() {
        System.setOut(null);
    }

    @Test
    public void testNoArgs() throws Exception {

        String[] args = new String[] {};

        HibernateEnversDDL.main(args);

        assertEquals("Usage: \n" + "   --create unitName filename - Create table commands\n"
                + "   --create-drop unitName filename - Create table and drop commands\n"
                + "   --update unitName jdbcUrl jdbcUsername jdbcPassword filename - Alter table commands based on your database\n"
                + "\n" + "   filename is the name of the file where to write\n", outContent.toString());
    }

    @Test
    public void testUpdateCommand() throws Exception {

        String[] args = new String[] { "--update", "application-data-unit-export-test",
                "jdbc:h2:" + getClass().getResource("/foobar_versioned.mv.db").getFile().replace(".mv.db", ""),
                "foo" };

        HibernateEnversDDL.main(args);

        assertEquals("Expected unitName jdbcUrl jdbcUsername jdbcPassword [filename]\n", outContent.toString());
    }

    @Test
    public void testUpdateCommandWithFile() throws Exception {

        File file = File.createTempFile("updatedb", ".sql");
        file.deleteOnExit();

        String[] args = new String[] { "--update", "application-data-unit-export-test",
                "jdbc:h2:" + getClass().getResource("/foobar_versioned.mv.db").getFile().replace(".mv.db", ""),
                "foo", "bar", file.getAbsolutePath() };

        HibernateEnversDDL.main(args);

        assertTrue(outContent.toString().isEmpty());
        assertEquals(
                "\n" + "    alter table FooBar \n" + "        add column bar integer not null;\n" + "\n"
                        + "    alter table FooBar_AUD \n" + "        add column bar integer;\n",
                IOUtils.toString(new FileReader(file)));
    }

    @Test
    public void testUpdateCommandWithoutFile() throws Exception {

        File file = File.createTempFile("updatedb", ".sql");
        file.deleteOnExit();

        String[] args = new String[] { "--update", "application-data-unit-export-test",
                "jdbc:h2:" + getClass().getResource("/foobar_versioned.mv.db").getFile().replace(".mv.db", ""),
                "foo", "bar" };

        HibernateEnversDDL.main(args);

        assertEquals(
                "\n" + "    alter table FooBar \n" + "        add column bar integer not null;\n" + "\n"
                        + "    alter table FooBar_AUD \n" + "        add column bar integer;\n",
                outContent.toString());
    }

    @Test
    public void testCreateCommand() throws Exception {

        String[] args = new String[] { "--create", "application-data-unit-export-test" };

        HibernateEnversDDL.main(args);

        assertEquals("Expected unitName and filename\n", outContent.toString());
    }

    @Test
    public void testCreateCommandWithFile() throws Exception {

        File file = File.createTempFile("updatedb", ".sql");
        file.deleteOnExit();

        String[] args = new String[] { "--create", "application-data-unit-export-test", file.getAbsolutePath() };

        HibernateEnversDDL.main(args);

        assertTrue(outContent.toString().isEmpty());
        assertEquals("\n" + "    create table FooBar (\n" + "        id integer not null,\n"
                + "        bar integer not null,\n" + "        foo varchar(255),\n" + "        primary key (id)\n"
                + "    );\n" + "\n" + "    create table FooBar_AUD (\n" + "        id integer not null,\n"
                + "        REV integer not null,\n" + "        REVTYPE tinyint,\n" + "        bar integer,\n"
                + "        foo varchar(255),\n" + "        primary key (id, REV)\n" + "    );\n" + "\n"
                + "    create table REVINFO (\n" + "        REV integer generated by default as identity,\n"
                + "        REVTSTMP bigint,\n" + "        primary key (REV)\n" + "    );\n" + "\n"
                + "    alter table FooBar_AUD \n" + "        add constraint FK_hq6lvb9twe0idlwiwq4locy79 \n"
                + "        foreign key (REV) \n" + "        references REVINFO;\n" + "",
                IOUtils.toString(new FileReader(file)));
    }

    @Test
    public void testCreateDropCommand() throws Exception {

        String[] args = new String[] { "--create-drop", "application-data-unit-export-test" };

        HibernateEnversDDL.main(args);

        assertEquals("Expected unitName and filename\n", outContent.toString());
    }

    @Test
    public void testCreateDropCommandWithFile() throws Exception {

        File file = File.createTempFile("updatedb", ".sql");
        file.deleteOnExit();

        String[] args = new String[] { "--create-drop", "application-data-unit-export-test",
                file.getAbsolutePath() };

        HibernateEnversDDL.main(args);

        assertTrue(outContent.toString().isEmpty());
        assertEquals("\n" + "    drop table FooBar if exists;\n" + "\n" + "    drop table FooBar_AUD if exists;\n"
                + "\n" + "    drop table REVINFO if exists;\n" + "\n" + "    create table FooBar (\n"
                + "        id integer not null,\n" + "        bar integer not null,\n"
                + "        foo varchar(255),\n" + "        primary key (id)\n" + "    );\n" + "\n"
                + "    create table FooBar_AUD (\n" + "        id integer not null,\n"
                + "        REV integer not null,\n" + "        REVTYPE tinyint,\n" + "        bar integer,\n"
                + "        foo varchar(255),\n" + "        primary key (id, REV)\n" + "    );\n" + "\n"
                + "    create table REVINFO (\n" + "        REV integer generated by default as identity,\n"
                + "        REVTSTMP bigint,\n" + "        primary key (REV)\n" + "    );\n" + "\n"
                + "    alter table FooBar_AUD \n" + "        add constraint FK_hq6lvb9twe0idlwiwq4locy79 \n"
                + "        foreign key (REV) \n" + "        references REVINFO;\n",
                IOUtils.toString(new FileReader(file)));
    }
}