• Home
• com.github.ollgei.spring
• spring-boot-autoconfigure
• 1.0.0.RC12
• source code
• SqlStatementsSource.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.github.ollgei.spring.boot.autoconfigure.jdbc.SqlStatementsSource Maven / Gradle / Ivy

package com.github.ollgei.spring.boot.autoconfigure.jdbc;

import org.springframework.jdbc.core.ConnectionCallback;

/**
 * SqlStatementsSource.
 *
 *  if PostgreSQL insert:
 *  super.getInsertStatement() + " ON CONFLICT (" + name() + ") DO UPDATE " +
 *    "SET " + lockUntil() + " = :lockUntil, " + lockedAt() + " = :now, " + lockedBy() + " = :lockedBy " +
 *    "WHERE " + tableName() + "." + lockUntil() + " <= :now";
 * @author ollgei
 * @since 1.0.0
 */
public class SqlStatementsSource {
    private final JdbcTemplateConfiguration configuration;

    public SqlStatementsSource(JdbcTemplateConfiguration configuration) {
        this.configuration = configuration;
    }

    public static SqlStatementsSource create(JdbcTemplateConfiguration configuration) {
        return new SqlStatementsSource(configuration);
    }

    private static String getDatabaseProductName(JdbcTemplateConfiguration configuration) {
        return configuration.getJdbcTemplate().execute((ConnectionCallback) connection -> connection.getMetaData().getDatabaseProductName());
    }

    public String tableName() {
        return configuration.getTableName();
    }

    public boolean ifPostgreSQL() {
        String databaseProductName = getDatabaseProductName(configuration);
        return "PostgreSQL".equals(databaseProductName);
    }
}