Package com.droidlogix.sqlite.datahandler

Interface ISqliteRepository<T>

All Known Implementing Classes:

SqliteRepository

public interface ISqliteRepository<T>

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
<T> List<T>	getList(String sql, ISqliteObjectAssembler sqliteObjectAssembler)	Query a list items using sql.
List<T>	getList(String sql, Map<Integer,Object> parameters, ISqliteObjectAssembler sqliteObjectAssembler)	Query a list items using sql and map of parameters.
T	getSingle(String sql, ISqliteObjectAssembler sqliteObjectAssembler)	Query a single item using sql.
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

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 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 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

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