search

samimave / car-pool

Automatically exported from code.google.com/p/car-pool
0 stars 0 forks source link

Store locations in db #17

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
All Palmerston North streets need to be stored.

Original issue reported on code.google.com by Jordan.D...@gmail.com on 30 Aug 2008 at 9:42

GoogleCodeExporter commented 9 years ago 
Implemented new db, just need to get the locations into the db somehow.

Original comment by Jordan.D...@gmail.com on 31 Aug 2008 at 4:38

GoogleCodeExporter commented 9 years ago 
I have now a method to load all the streets into the db.  I have constructed a 
comma
separated list of all the streets.  There is some errors in it but they can be 
fixed
later.

Original comment by Jordan.D...@gmail.com on 31 Aug 2008 at 5:38

GoogleCodeExporter commented 9 years ago 
It is now possible to search all the locations in the database using the
CarPoolStore.findLocation(String name);

The syntax for the search is any space is replace by a wildcard and a wildcard 
is
also added to front and back.  For example:
'ynda' gives:
LYNDALE PLACE
TYNDALL STREET

whereas 'ynda s':
TYNDALL STREET

R Oak:
Royal Oak.

Hope you get it by now.

Original comment by Jordan.D...@gmail.com on 4 Sep 2008 at 9:12

GoogleCodeExporter commented 9 years ago 
Also, the returned type is a LocationList I have implemented which is used like 
this..

LocationList ll = cps.findLocation("ynda");
    while(ll.next()){
        sb.append(ll.getID() + "\t" + ll.getStreetName() + "\n");
    }
String mylist of IDS and NAMES = sb.toString();

Original comment by Jordan.D...@gmail.com on 4 Sep 2008 at 9:14

GoogleCodeExporter commented 9 years ago

Original comment by Jordan.D...@gmail.com on 22 Sep 2008 at 1:25