--- android/TrainInfoServiceGoogle/src/dk/thoerup/traininfoservice/LocateStations.java	2010/09/21 16:45:24	1092
+++ android/TrainInfoServiceGoogle/src/dk/thoerup/traininfoservice/LocateStations.java	2010/09/21 20:10:46	1093
@@ -98,29 +98,44 @@
 				pm = PMF.get().getPersistenceManager();
 				
 				
+
+
+				JdoStationBean b = new JdoStationBean();
+				b.setId(1000);
+				b.setName("TestStation");
+				b.setNameLower( b.getName().toLowerCase() );
+				b.setMetro("12");
+				pm.makePersistent(b);
+	
+					
+				JdoStationBean b2 = new JdoStationBean();
+				b2.setId(1001);
+				b2.setName("teststation 2");
+				b2.setNameLower( b2.getName().toLowerCase() );
+				b2.setMetro("12");
+				pm.makePersistent(b2);
+				
+				JdoStationBean b3 = new JdoStationBean();
+				b3.setId(1002);
+				b3.setName("Horsens");
+				b3.setNameLower( b3.getName().toLowerCase() );
+				b3.setMetro("13");
+				pm.makePersistent(b3);
+
+
+				
 				
+				//String query = "select from " + JdoStationBean.class.getName();// + " where nameLower.startsWith('test')";
 				
-				String query = "select from " + JdoStationBean.class.getName() + " where name.matches('Test.*')";
-				List<JdoStationBean> stations = (List<JdoStationBean>) pm.newQuery(query).execute();								
+				String query = "select from " + JdoStationBean.class.getName() + " where (id == 1001 || id == 1002) ";
+				
+				List<JdoStationBean> stations = (List<JdoStationBean>) pm.newQuery( query ).execute();								
 				
 				logger.info("size=" + stations.size() );
 				for(JdoStationBean bean : stations) {
 					logger.info("Station: " + bean.getId() + "/" + bean.getName());
 				}
 				
-				/*if (stations.size() == 0) {
-					JdoStationBean b = new JdoStationBean();
-					b.setId(1000);
-					b.setName("TestStation");
-					b.setMetro("12");
-					pm.makePersistent(b);
-					
-					JdoStationBean b2 = new JdoStationBean();
-					b2.setId(1001);
-					b2.setName("teststation 2");
-					b2.setMetro("12");
-					pm.makePersistent(b2);
-				}*/