/**
* Return the instance of an entity with a matching id.
*
* @param <T> Any ActiveRecordBase class.
* @param type The class of the entity to return.
* @param id The desired ID.
* @return The matching entity if reocrd found in DB, null otherwise
* @throws ActiveRecordException
*/
public <T extends ActiveRecordBase> T findByID(Class<T> type, long id)
throws ActiveRecordException {
if (m_Database == null) throw new ActiveRecordException("Set database first");
T entity = s_EntitiesMap.get(type, id);
if (entity != null) return entity;
try {
entity = type.newInstance();
} catch (IllegalAccessException e) {
throw new ActiveRecordException(e.getLocalizedMessage());
} catch (InstantiationException e) {
throw new ActiveRecordException(e.getLocalizedMessage());
}
Cursor c =
m_Database.query(entity.getTableName(), null, "_id = ?", new String[] {String.valueOf(id)});
try {
if (!c.moveToNext()) {
return null;
} else {
entity.inflate(c);
entity.m_NeedsInsert = false;
entity.m_Database = m_Database;
}
} finally {
c.close();
}
return entity;
}
/**
* Return all instances of an entity that match the given criteria. Use whereClause to specify
* condition, using reqular SQL syntax for WHERE clause.
*
* <p>For example selecting all JOHNs born in 2001 from USERS table may look like:
*
* <pre>
* users.find(Users.class, "NAME='?' and YEAR=?", new String[] {"John", "2001"});
* </pre>
*
* @param <T> Any ActiveRecordBase class.
* @param type The class of the entities to return.
* @param whereClause The condition to match (Don't include "where").
* @param whereArgs The arguments to replace "?" with.
* @return A generic list of all matching entities.
* @throws IllegalArgumentException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public <T extends ActiveRecordBase> List<T> find(
Class<T> type, String whereClause, String[] whereArgs) throws ActiveRecordException {
if (m_Database == null) throw new ActiveRecordException("Set database first");
T entity = null;
try {
entity = type.newInstance();
} catch (IllegalAccessException e1) {
throw new ActiveRecordException(e1.getLocalizedMessage());
} catch (InstantiationException e1) {
throw new ActiveRecordException(e1.getLocalizedMessage());
}
List<T> toRet = new ArrayList<T>();
Cursor c = m_Database.query(entity.getTableName(), null, whereClause, whereArgs);
try {
while (c.moveToNext()) {
entity = s_EntitiesMap.get(type, c.getLong(c.getColumnIndex("_id")));
if (entity == null) {
entity = type.newInstance();
entity.m_Database = m_Database;
entity.m_NeedsInsert = false;
entity.inflate(c);
}
toRet.add(entity);
}
} catch (IllegalAccessException e) {
throw new ActiveRecordException(e.getLocalizedMessage());
} catch (InstantiationException e) {
throw new ActiveRecordException(e.getLocalizedMessage());
} finally {
c.close();
}
return toRet;
}
public void true_insert() throws Exception {
// synchronized(variavel) {
Database db = new Database();
db.connect();
// BEGIN WORK -> stored procedure
db.update(
"insert into tbNews (tmsp, headline, body, email) values ('"
+ this.tmsp
+ "', '"
+ this.headline
+ "', '"
+ this.body
+ "', '"
+ this.email
+ "')");
ResultSet rs = db.query("select max(id) as id from tbNews");
if (rs.next()) {
this.id = rs.getInt("id");
}
// COMMIT
db.close();
// }
}
public static ResultSet findByQuery(Database db, String query) throws Exception {
return db.query(
"select tmsp, url, body from page where url like '%"
+ query
+ "%' or body like '%"
+ query
+ "%'");
}
public <T extends ActiveRecordBase> int getCount(Class<T> type) throws ActiveRecordException {
T entity = newEntity(type);
// We don't need to perform a full projection on the database because we only need to
// get enough data for us to count
String[] projection = new String[] {CamelNotationHelper.toSQLName(entity.getColumns()[0])};
Cursor c = m_Database.query(entity.getTableName(), projection, null, null);
int count = c.getCount();
c.close();
return count;
}
public static ResultSet findByUrl(Database db, String url) throws Exception {
return db.query("select tmsp, url, body from page where url = '" + url + "'");
}
// finders
public static ResultSet findAll(Database db) throws Exception {
return db.query("select tmsp, url, body from page");
}
public static ResultSet findLast(Database db, int n) throws Exception {
return db.query(
"select id, tmsp, headline, body, email from tbNews order by tmsp desc limit " + n);
}
public static ResultSet findByEmail(Database db, String email) throws Exception {
return db.query(
"select id, tmsp, headline, body, email from tbNews where email = '" + email + "'");
}
public static News findById(Database db, int id) throws Exception {
return News.next(
db.query("select id, tmsp, headline, body, email from tbNews where id = " + id));
}
// finders
public static ResultSet findAll(Database db) throws Exception {
return db.query("select id, tmsp, headline, body, email from tbNews");
}