示例#1
0
 /**
  * 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;
 }
示例#2
0
 /**
  * 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;
 }
示例#3
0
 /**
  * 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;
 }
示例#4
0
 /**
  * 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;
 }
示例#5
0
 /**
  * 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;
 }