org.sqlite.SQLiteConnectionConfig Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of sqlite-jdbc Show documentation
Show all versions of sqlite-jdbc Show documentation
SQLite JDBC library with encryption and authentication support
package org.sqlite;
import org.sqlite.date.FastDateFormat;
import java.sql.Connection;
import java.util.EnumMap;
import java.util.Map;
import java.util.Properties;
import static org.sqlite.SQLiteConfig.DEFAULT_DATE_STRING_FORMAT;
/**
* Connection local configurations
*/
public class SQLiteConnectionConfig implements Cloneable
{
private SQLiteConfig.DateClass dateClass = SQLiteConfig.DateClass.INTEGER;
private SQLiteConfig.DatePrecision datePrecision = SQLiteConfig.DatePrecision.MILLISECONDS; //Calendar.SECOND or Calendar.MILLISECOND
private String dateStringFormat = DEFAULT_DATE_STRING_FORMAT;
private FastDateFormat dateFormat = FastDateFormat.getInstance(dateStringFormat);
private int transactionIsolation = Connection.TRANSACTION_SERIALIZABLE;
private SQLiteConfig.TransactionMode transactionMode = SQLiteConfig.TransactionMode.DEFERRED;
private boolean autoCommit = true;
public static SQLiteConnectionConfig fromPragmaTable(Properties pragmaTable) {
return new SQLiteConnectionConfig(
SQLiteConfig.DateClass.getDateClass(pragmaTable.getProperty(SQLiteConfig.Pragma.DATE_CLASS.pragmaName, SQLiteConfig.DateClass.INTEGER.name())),
SQLiteConfig.DatePrecision.getPrecision(pragmaTable.getProperty(SQLiteConfig.Pragma.DATE_PRECISION.pragmaName, SQLiteConfig.DatePrecision.MILLISECONDS.name())),
pragmaTable.getProperty(SQLiteConfig.Pragma.DATE_STRING_FORMAT.pragmaName, DEFAULT_DATE_STRING_FORMAT),
Connection.TRANSACTION_SERIALIZABLE,
SQLiteConfig.TransactionMode.getMode(
pragmaTable.getProperty(SQLiteConfig.Pragma.TRANSACTION_MODE.pragmaName, SQLiteConfig.TransactionMode.DEFERRED.name())),
true);
}
public SQLiteConnectionConfig(
SQLiteConfig.DateClass dateClass,
SQLiteConfig.DatePrecision datePrecision,
String dateStringFormat,
int transactionIsolation,
SQLiteConfig.TransactionMode transactionMode,
boolean autoCommit
)
{
setDateClass(dateClass);
setDatePrecision(datePrecision);
setDateStringFormat(dateStringFormat);
setTransactionIsolation(transactionIsolation);
setTransactionMode(transactionMode);
setAutoCommit(autoCommit);
}
public SQLiteConnectionConfig copyConfig() {
return new SQLiteConnectionConfig(
dateClass,
datePrecision,
dateStringFormat,
transactionIsolation,
transactionMode,
autoCommit
);
}
public long getDateMultiplier()
{
return (datePrecision == SQLiteConfig.DatePrecision.MILLISECONDS) ? 1L : 1000L;
}
public SQLiteConfig.DateClass getDateClass()
{
return dateClass;
}
public void setDateClass(SQLiteConfig.DateClass dateClass)
{
this.dateClass = dateClass;
}
public SQLiteConfig.DatePrecision getDatePrecision()
{
return datePrecision;
}
public void setDatePrecision(SQLiteConfig.DatePrecision datePrecision)
{
this.datePrecision = datePrecision;
}
public String getDateStringFormat()
{
return dateStringFormat;
}
public void setDateStringFormat(String dateStringFormat)
{
this.dateStringFormat = dateStringFormat;
this.dateFormat = FastDateFormat.getInstance(dateStringFormat);
}
public FastDateFormat getDateFormat()
{
return dateFormat;
}
public boolean isAutoCommit()
{
return autoCommit;
}
public void setAutoCommit(boolean autoCommit)
{
this.autoCommit = autoCommit;
}
public int getTransactionIsolation()
{
return transactionIsolation;
}
public void setTransactionIsolation(int transactionIsolation)
{
this.transactionIsolation = transactionIsolation;
}
public SQLiteConfig.TransactionMode getTransactionMode()
{
return transactionMode;
}
@SuppressWarnings("deprecation")
public void setTransactionMode(SQLiteConfig.TransactionMode transactionMode)
{
if (transactionMode == SQLiteConfig.TransactionMode.DEFFERED) {
transactionMode = SQLiteConfig.TransactionMode.DEFERRED;
}
this.transactionMode = transactionMode;
}
private final static Map beginCommandMap =
new EnumMap(SQLiteConfig.TransactionMode.class);
static {
beginCommandMap.put(SQLiteConfig.TransactionMode.DEFERRED, "begin;");
beginCommandMap.put(SQLiteConfig.TransactionMode.IMMEDIATE, "begin immediate;");
beginCommandMap.put(SQLiteConfig.TransactionMode.EXCLUSIVE, "begin exclusive;");
}
String transactionPrefix() {
return beginCommandMap.get(transactionMode);
}
}