Package com.droidlogix.sqlite.datahandler

Class SqliteRepository

java.lang.Object

com.droidlogix.sqlite.datahandler.SqliteRepository

All Implemented Interfaces:

ISqliteRepository

public class SqliteRepository
extends Object
implements ISqliteRepository

Created by John Pili on 11/02/17.

Constructor Summary

Constructors

Constructor	Description
SqliteRepository(SqliteConfig sqliteConfig)
SqliteRepository(String dbLocation, String dbUsername, String dbPassword)

Method Summary

Modifier and Type	Method	Description
void	alterTable(String sql)	Method that handles alter table
void	createTable(String sql)	Method that handles create table
int	delete(String sql, Map<Integer,Object> parameters)	Delete rows in SQLite and return the number of affected rows
void	dropTable(String sql)	Method that handles drop table
Connection	getConnection()	This method initialize the SQLite connection and driver check
Connection	getConnection(boolean pragmaFk)	This method initialize the SQLite connection and driver check
<T> List<T>	getList(String sql, ISqliteObjectAssembler sqliteObjectAssembler)	Query a list items using sql.
<T> List<T>	getList(String sql, Map<Integer,Object> parameters, ISqliteObjectAssembler sqliteObjectAssembler)	Query a list items using sql and map of parameters.
<T> T	getSingle(String sql, ISqliteObjectAssembler sqliteObjectAssembler)	Query a single item using sql.
<T> T	getSingle(String sql, Map<Integer,Object> parameters, ISqliteObjectAssembler sqliteObjectAssembler)	Query a single item using sql and map of parameters.
int	insert(String sql, Map<Integer,Object> parameters)	Insert into SQLite and return the generated primary ID.
int	update(String sql, Map<Integer,Object> parameters)	Update rows in SQLite and return the number of affected rows

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqliteRepository

public SqliteRepository(SqliteConfig sqliteConfig)

SqliteRepository

public SqliteRepository(String dbLocation,
                        String dbUsername,
                        String dbPassword)

Method Detail

getConnection

public Connection getConnection()
                         throws SQLException,
                                SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

This method initialize the SQLite connection and driver check

Specified by:

getConnection in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getConnection

public Connection getConnection(boolean pragmaFk)
                         throws SQLException,
                                SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

This method initialize the SQLite connection and driver check

Specified by:

getConnection in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

insert

public int insert(String sql,
                  Map<Integer,Object> parameters)
           throws SQLException,
                  SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Insert into SQLite and return the generated primary ID. Method will return -1 if an error occurs during execution

Specified by:

insert in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

update

public int update(String sql,
                  Map<Integer,Object> parameters)
           throws SQLException,
                  SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Update rows in SQLite and return the number of affected rows

Specified by:

update in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

delete

public int delete(String sql,
                  Map<Integer,Object> parameters)
           throws SQLException,
                  SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Delete rows in SQLite and return the number of affected rows

Specified by:

delete in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getSingle

public <T> T getSingle(String sql,
                       ISqliteObjectAssembler sqliteObjectAssembler)
                throws SQLException,
                       SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Query a single item using sql. Convert resultset to POJO via dependency injection

Specified by:

getSingle in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getSingle

public <T> T getSingle(String sql,
                       Map<Integer,Object> parameters,
                       ISqliteObjectAssembler sqliteObjectAssembler)
                throws SQLException,
                       SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Query a single item using sql and map of parameters. Convert resultset to POJO via dependency injection

Specified by:

getSingle in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getList

public <T> List<T> getList(String sql,
                           ISqliteObjectAssembler sqliteObjectAssembler)
                    throws SQLException,
                           SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Query a list items using sql. Convert resultset to POJO via dependency injection

Specified by:

getList in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getList

public <T> List<T> getList(String sql,
                           Map<Integer,Object> parameters,
                           ISqliteObjectAssembler sqliteObjectAssembler)
                    throws SQLException,
                           SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Query a list items using sql and map of parameters. Convert resultset to POJO via dependency injection

Specified by:

getList in interface ISqliteRepository

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

createTable

public void createTable(String sql)
                 throws SQLException,
                        SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Method that handles create table

Specified by:

createTable in interface ISqliteRepository

Throws:

SQLException

SqliteDriverNotFoundException

alterTable

public void alterTable(String sql)
                throws SQLException,
                       SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Method that handles alter table

Specified by:

alterTable in interface ISqliteRepository

Throws:

SQLException

SqliteDriverNotFoundException

dropTable

public void dropTable(String sql)
               throws SQLException,
                      SqliteDriverNotFoundException

Description copied from interface: ISqliteRepository

Method that handles drop table

Specified by:

dropTable in interface ISqliteRepository

Throws:

SQLException

SqliteDriverNotFoundException