com.quinsoft.zeidon.dbhandler.SqliteJdbcTranslator Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of zeidon-joe Show documentation
The newest version!
/**
    This file is part of the Zeidon Java Object Engine (Zeidon JOE).

    Zeidon JOE 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.

    Zeidon JOE 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 Zeidon JOE.  If not, see .

    Copyright 2009-2015 QuinSoft
 */

package com.quinsoft.zeidon.dbhandler;

import java.sql.SQLException;
import java.time.Instant;
import java.time.ZoneId;
import java.time.ZonedDateTime;

import com.quinsoft.zeidon.Task;
import com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.SqlStatement;
import com.quinsoft.zeidon.domains.BooleanDomain;
import com.quinsoft.zeidon.domains.DateTimeDomain;
import com.quinsoft.zeidon.domains.Domain;
import com.quinsoft.zeidon.objectdefinition.AttributeDef;

/**
 * JDBC translator for Sqlite.
 *
 * @author DG
 *
 */
public class SqliteJdbcTranslator extends StandardJdbcTranslator
{

    /**
     * @param task
     * @param config
     */
    public SqliteJdbcTranslator(Task task, JdbcHandler handler )
    {
        super( task, handler );
    }

    @Override
    public Object convertDbValue(Domain domain, Object dbValue) throws SQLException
    {
        if ( domain instanceof DateTimeDomain )
        {
            // Sqlite stores dates as unix times.
            if ( dbValue instanceof Number )
            {
                long time = ((Number) dbValue).longValue();
                Instant i = Instant.ofEpochMilli( time );

                ZonedDateTime z = ZonedDateTime.ofInstant(i, ZoneId.systemDefault());
                return z;
            }
        }
        return super.convertDbValue( domain, dbValue );
    }

    /* (non-Javadoc)
     * @see com.quinsoft.zeidon.dbhandler.JdbcDomainTranslator#getAttributeValue(java.lang.StringBuilder, com.quinsoft.zeidon.objectdefinition.DataField, com.quinsoft.zeidon.EntityInstance)
     */
    @Override
    public boolean appendSqlValue(SqlStatement stmt, StringBuilder buffer, Domain domain, AttributeDef attributeDef, Object value)
    {
        if ( bindAllValues || value == null )
            return super.appendSqlValue( stmt, buffer, domain, attributeDef, value );

        // Sqlite stores booleans as integers.
        if ( domain instanceof BooleanDomain )
        {
            Object b = domain.convertExternalValue( getTask(), null, attributeDef, null, value );
            buffer.append( (Boolean) b ? "1" : "0" );
            return true;
        }

        return super.appendSqlValue( stmt, buffer, domain, attributeDef, value );
    }
}