Package com.droidlogix.sqlite.datahandler

Interface ISqliteRepository

All Known Implementing Classes:

SqliteRepository

public interface ISqliteRepository

Created by mrprintedwall on 11/02/17.

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

Method Detail

getConnection

Connection getConnection()
                  throws SQLException,
                         SqliteDriverNotFoundException

This method initialize the SQLite connection and driver check

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getConnection

Connection getConnection(boolean pragmaFk)
                  throws SQLException,
                         SqliteDriverNotFoundException

This method initialize the SQLite connection and driver check

Parameters:

pragmaFk -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

insert

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

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

Parameters:

sql -

parameters -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

update

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

Update rows in SQLite and return the number of affected rows

Parameters:

sql -

parameters -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

delete

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

Delete rows in SQLite and return the number of affected rows

Parameters:

sql -

parameters -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getSingle

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

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

Parameters:

sql -

sqliteObjectAssembler -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getSingle

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

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

Parameters:

sql -

parameters -

sqliteObjectAssembler -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getList

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

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

Type Parameters:

T -

Parameters:

sql -

sqliteObjectAssembler -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

getList

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

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

Parameters:

sql -

parameters -

sqliteObjectAssembler -

Returns:

Throws:

SQLException

SqliteDriverNotFoundException

createTable

void createTable(String sql)
          throws SQLException,
                 SqliteDriverNotFoundException

Method that handles create table

Parameters:

sql -

Throws:

SQLException

SqliteDriverNotFoundException

alterTable

void alterTable(String sql)
         throws SQLException,
                SqliteDriverNotFoundException

Method that handles alter table

Parameters:

sql -

Throws:

SQLException

SqliteDriverNotFoundException

dropTable

void dropTable(String sql)
        throws SQLException,
               SqliteDriverNotFoundException

Method that handles drop table

Parameters:

sql -

Throws:

SQLException

SqliteDriverNotFoundException