/**
* This function returns a vector of all the objects momentanly avaiable in the database
*
* @return a vector of objects if all goes right, alternativ it returns a MyError
*/
public static Linea getById(int lineaId, String table_prefix) {
MySQLiteDBAdapter sqlite = MySQLiteDBAdapter.getInstance(SASAbus.getContext());
String[] args = {Integer.toString(lineaId)};
Cursor cursor = sqlite.rawQuery("select * from " + table_prefix + "linee where id = ?", args);
Linea line = null;
if (cursor.moveToFirst()) {
line = new Linea(cursor);
}
cursor.close();
sqlite.close();
return line;
}
/**
* This function returns a vector of all the objects momentanly avaiable in the database
*
* @return a vector of objects if all goes right, alternativ it returns a MyError
*/
public static Linea getByNumLin(String linecode, String table_prefix) {
MySQLiteDBAdapter sqlite = MySQLiteDBAdapter.getInstance(SASAbus.getContext());
String[] args = {linecode};
Cursor cursor =
sqlite.rawQuery("select * from " + table_prefix + "linee where num_lin = ?", args);
Linea line = null;
if (cursor.moveToFirst()) {
line = new Linea(cursor);
}
cursor.close();
sqlite.close();
return line;
}
/**
* This function returns a vector of all the objects momentanly avaiable in the database
*
* @return a vector of objects if all goes right, alternativ it returns a MyError
*/
public static Vector<DBObject> getList() {
MySQLiteDBAdapter sqlite = MySQLiteDBAdapter.getInstance(SASAbus.getContext());
Cursor cursor = sqlite.rawQuery("select * from linee", null);
Vector<DBObject> list = null;
if (cursor.moveToFirst()) {
list = new Vector<DBObject>();
do {
Linea element = new Linea(cursor);
list.add(element);
} while (cursor.moveToNext());
}
cursor.close();
sqlite.close();
return list;
}
/**
* This method returns a vector of linee which are located in the bacino
*
* @param bacino is the bacino where we are searching the linee
* @return a vector of DBObjects with the linee located in the bacino
*/
public static Vector<DBObject> getList(String table_prefix) {
MySQLiteDBAdapter sqlite = MySQLiteDBAdapter.getInstance(SASAbus.getContext());
String[] args = null;
Cursor cursor =
sqlite.rawQuery("select * from " + table_prefix + "linee order by num_lin", args);
Vector<DBObject> list = null;
if (cursor.moveToFirst()) {
list = new Vector<DBObject>();
do {
Linea element = new Linea(cursor);
list.add(element);
} while (cursor.moveToNext());
}
cursor.close();
sqlite.close();
return list;
}
/**
* This method returns a vector of linee which are connecting the departure with the destination
*
* @param destinazione is the name of the destination busstop
* @param partenza is the name of the departure busstop
* @return a vector of DBObjects which are lines which connect the departure with the destination
*/
public static Vector<DBObject> getListDestPart(String destinazione, String partenza) {
MySQLiteDBAdapter sqlite = MySQLiteDBAdapter.getInstance(SASAbus.getContext());
String[] args = {destinazione, partenza};
/*
* This is a special query to provide the cases which the departure is
* yesterday near midnight and the destination is now, for showing non-negativ
* differences
*/
Cursor cursor =
sqlite.rawQuery(
"select distinct l.id as id, l.num_lin as num_lin, l.abbrev as abbrev, "
+ "l.bacinoId as bacinoId, l.descr_it as descr_it, l.descr_de as descr_de "
+ " from linee l, "
+ "(select * from orarii where palinaId IN ("
+ "select id from paline where nome_de = ?"
+ ")) as o1, "
+ "(select * from orarii where palinaId IN ("
+ "select id from paline where nome_de = ?"
+ ")) as o2, "
+ "(select id, lineaId "
+ "from corse "
+ "where "
+ "substr(corse.effettuazione,round(strftime('%J','now','localtime')) - round(strftime('%J', '"
+ Config.getStartDate()
+ "')) + 1,1)='1' "
+ ") as c "
+ "where c.lineaId = l.id "
+ "and o1.corsaId = o2.corsaId "
+ "and o2.corsaId = c.id "
+ "and o2.progressivo < o1.progressivo "
+ "order by l.abbrev",
args);
Vector<DBObject> list = null;
if (cursor.moveToFirst()) {
list = new Vector<DBObject>();
do {
Linea element = new Linea(cursor);
if (!list.contains(element)) list.add(element);
} while (cursor.moveToNext());
}
cursor.close();
sqlite.close();
return list;
}