com.jporm.sql.SqlDsl Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jpo-sql Show documentation
There is a newer version: 8.9.0
/*******************************************************************************
 * Copyright 2015 Francesco Cina'
 *
 * Licensed 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 com.jporm.sql;

import java.util.function.Supplier;

import com.jporm.sql.dialect.SqlRender;
import com.jporm.sql.query.delete.Delete;
import com.jporm.sql.query.delete.DeleteBuilderImpl;
import com.jporm.sql.query.insert.Insert;
import com.jporm.sql.query.insert.InsertBuilderImpl;
import com.jporm.sql.query.processor.NoOpsStringPropertiesProcessor;
import com.jporm.sql.query.processor.TablePropertiesProcessor;
import com.jporm.sql.query.select.SelectBuilder;
import com.jporm.sql.query.select.SelectBuilderImpl;
import com.jporm.sql.query.update.Update;
import com.jporm.sql.query.update.UpdateBuilderImpl;

public class SqlDsl {

    private static final TablePropertiesProcessor DEFAULT_PROPERTIES_PROCESSOR = new NoOpsStringPropertiesProcessor();
    private final Supplier> propertiesProcessorSupplier;
    private final SqlRender sqlRender;

    public static SqlDsl get(final SqlRender sqlRender) {
        return new SqlDsl<>(sqlRender, () -> DEFAULT_PROPERTIES_PROCESSOR);
    }

    private SqlDsl(final SqlRender sqlRender, Supplier> propertiesProcessorSupplier) {
        this.sqlRender = sqlRender;
        this.propertiesProcessorSupplier = propertiesProcessorSupplier;
    }

    public Delete deleteFrom(T table) {
        return new DeleteBuilderImpl(sqlRender.getDeleteRender(), propertiesProcessorSupplier.get()).from(table);
    }

    public Insert insertInto(T table, String... columns) {
        return new InsertBuilderImpl<>(sqlRender.getInsertRender(), columns, propertiesProcessorSupplier.get()).into(table);
    }

    public SelectBuilder selectAll() {
        return select("*");
    }

    public SelectBuilder select(final String... fields) {
        return select(()->fields);
    }

    public SelectBuilder select(final Supplier fields) {
        return new SelectBuilderImpl(sqlRender.getSelectRender(), fields, propertiesProcessorSupplier.get());
    }

    public Update update(T table) {
        return new UpdateBuilderImpl(sqlRender.getUpdateRender(), propertiesProcessorSupplier.get()).update(table);
    }

}