org.apache.isis.objectstore.jdo.datanucleus.Utils.java Source code

Introduction

Here is the source code for org.apache.isis.objectstore.jdo.datanucleus.Utils.java

Source

/*
 *  Licensed to the Apache Software Foundation (ASF) under one
 *  or more contributor license agreements.  See the NOTICE file
 *  distributed with this work for additional information
 *  regarding copyright ownership.  The ASF licenses this file
 *  to you under the Apache License, Version 2.0 (the
 *  "License"); you may not use this file except in compliance
 *  with the License.  You may obtain a copy of the License at
 *
 *        http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing,
 *  software distributed under the License is distributed on an
 *  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 *  KIND, either express or implied.  See the License for the
 *  specific language governing permissions and limitations
 *  under the License.
 */
package org.apache.isis.objectstore.jdo.datanucleus;

import java.sql.Connection;
import java.sql.Statement;
import java.util.Properties;

import org.joda.time.LocalDate;
import org.joda.time.LocalDateTime;

import org.apache.isis.core.commons.config.IsisConfiguration;
import org.apache.isis.core.commons.config.IsisConfigurationDefault;
import org.apache.isis.core.integtestsupport.IsisSystemWithFixtures;
import org.apache.isis.core.runtime.system.context.IsisContext;

public class Utils {

    private Utils() {
    }

    public static IsisSystemWithFixtures.Builder systemBuilder() {
        return IsisSystemWithFixtures.builder().with(configurationForDataNucleusDb())
                .with(new DataNucleusPersistenceMechanismInstaller());
    }

    public static IsisSystemWithFixtures.Listener listenerToDeleteFrom(final String... tables) {
        return new IsisSystemWithFixtures.ListenerAdapter() {

            @Override
            public void postSetupSystem(boolean firstTime) throws Exception {
                Connection connection = getConnection();
                try {
                    final Statement statement = connection.createStatement();
                    for (String table : tables) {
                        statement.executeUpdate("DELETE FROM " + table);
                    }
                } catch (Exception ex) {
                    connection.rollback();
                    throw ex;
                } finally {
                    connection.commit();
                }
            }

            private Connection getConnection() {
                final DataNucleusObjectStore objectStore = (DataNucleusObjectStore) IsisContext
                        .getPersistenceSession().getObjectStore();
                return objectStore.getJavaSqlConnection();
            }
        };
    }

    public static IsisConfiguration configurationForDataNucleusDb() {
        final IsisConfigurationDefault configuration = new IsisConfigurationDefault();
        Properties props = new Properties();

        props.put("isis.persistor.datanucleus.impl.javax.jdo.PersistenceManagerFactoryClass",
                "org.datanucleus.api.jdo.JDOPersistenceManagerFactory");

        // last one wins!
        configureHsqlDbFileBased(props);
        configureForMsSqlServer(props);
        configureHsqlDbInMemory(props);

        props.put("isis.persistor.datanucleus.impl.datanucleus.autoCreateSchema", "true");
        props.put("isis.persistor.datanucleus.impl.datanucleus.validateTables", "true");
        props.put("isis.persistor.datanucleus.impl.datanucleus.validateConstraints", "true");

        props.put("isis.persistor.datanucleus.impl.datanucleus.cache.level2.type", "none");

        configuration.add(props);
        return configuration;
    }

    private static void configureHsqlDbInMemory(Properties props) {
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionDriverName", "org.hsqldb.jdbcDriver");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionURL", "jdbc:hsqldb:mem:test");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionUserName", "sa");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionPassword", "");
    }

    private static void configureHsqlDbFileBased(Properties props) {
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionDriverName", "org.hsqldb.jdbcDriver");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionURL",
                "jdbc:hsqldb:file:hsql-db/test;hsqldb.write_delay=false;shutdown=true");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionUserName", "sa");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionPassword", "");
    }

    private static void configureForMsSqlServer(Properties props) {
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionDriverName",
                "com.microsoft.sqlserver.jdbc.SQLServerDriver");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionURL",
                "jdbc:sqlserver://127.0.0.1:1433;instance=SQLEXPRESS;databaseName=jdo;");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionUserName", "jdo");
        props.put("isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionPassword", "jdopass");
    }

    public static long toMillis(int year, int monthOfYear, int dayOfMonth) {
        LocalDate d = new LocalDate(year, monthOfYear, dayOfMonth);
        return d.toDateMidnight().getMillis();
    }

    public static long toMillis(int year, int monthOfYear, int dayOfMonth, int hourOfDay, int minuteOfHour,
            int secondOfMinute) {
        LocalDateTime d = new LocalDateTime(year, monthOfYear, dayOfMonth, hourOfDay, minuteOfHour, secondOfMinute);
        return d.toDateTime().getMillis();
    }

}