Search in sources :

Example 1 with Query

use of il.ac.technion.cs.yp.btw.db.queries.Query in project BTW by TechnionYearlyProject.

the class StreetsDataBase method getAllStreets.

/*
    * @author Sharon Hadar
    * @Date 21/01/2018
    * get from the data base all the traffic lights
    * */
public static Set<Street> getAllStreets(String mapName) {
    Query query = new QueryAllStreetNames(mapName);
    Set<String> streetNames = (Set<String>) MainDataBase.queryDataBase(query);
    Set<Street> streets = new HashSet();
    Iterator<String> iterator = streetNames.iterator();
    while (iterator.hasNext()) {
        streets.add(getStreet(iterator.next(), mapName));
    }
    return streets;
}
Also used : HashSet(java.util.HashSet) Set(java.util.Set) Query(il.ac.technion.cs.yp.btw.db.queries.Query) QueryAllStreetNames(il.ac.technion.cs.yp.btw.db.queries.QueryAllStreetNames) QueryStreet(il.ac.technion.cs.yp.btw.db.queries.QueryStreet) Street(il.ac.technion.cs.yp.btw.classes.Street) HashSet(java.util.HashSet)

Example 2 with Query

use of il.ac.technion.cs.yp.btw.db.queries.Query in project BTW by TechnionYearlyProject.

the class QueryTrafficLightExample method testGetAllTrafficLights.

/*
     * @author Sharon Hadar
     * @Date 21/01/2018*/
@Test
public void testGetAllTrafficLights() {
    TestResult result = new TestResult();
    MainDataBase.openConnection();
    Query query = new QueryTrafficLightExample("first");
    // MainDataBase database = new MainDataBase();
    // Set<TrafficLight> trafficLights = (Set<TrafficLight>) database.queryDataBase(query);
    Set<TrafficLight> trafficLights = (Set<TrafficLight>) MainDataBase.queryDataBase(query);
    Iterator<TrafficLight> iterator = trafficLights.iterator();
    // System.out.println("\n\n\nthe result set is:");
    while (iterator.hasNext()) {
        assertNotNull(iterator.next());
    // System.out.println(iterator.next().toString());
    }
    MainDataBase.closeConnection();
}
Also used : Set(java.util.Set) HashSet(java.util.HashSet) ResultSet(java.sql.ResultSet) Query(il.ac.technion.cs.yp.btw.db.queries.Query) DataTrafficLight(il.ac.technion.cs.yp.btw.db.DataObjects.DataTrafficLight) TrafficLight(il.ac.technion.cs.yp.btw.classes.TrafficLight) TestResult(junit.framework.TestResult) Test(org.junit.Test)

Example 3 with Query

use of il.ac.technion.cs.yp.btw.db.queries.Query in project BTW by TechnionYearlyProject.

the class QueryTrafficLightExample method testGetAllCenteralLocations.

/*
     * @author Sharon Hadar
     * @Date 21/01/2018*/
@Test
public void testGetAllCenteralLocations() {
    TestResult result = new TestResult();
    MainDataBase.openConnection();
    Query query = new QueryCenteralLocationExample("first");
    // MainDataBase database = new MainDataBase();
    // Set<CentralLocation> centeralLocations = (Set<CentralLocation>) database.queryDataBase(query);
    Set<CentralLocation> centeralLocations = (Set<CentralLocation>) MainDataBase.queryDataBase(query);
    Iterator<CentralLocation> iterator = centeralLocations.iterator();
    // System.out.println("\n\n\nthe result set is:");
    while (iterator.hasNext()) {
        assertNotNull(iterator.next());
    // System.out.println(iterator.next().toString());
    }
    MainDataBase.closeConnection();
}
Also used : Set(java.util.Set) HashSet(java.util.HashSet) ResultSet(java.sql.ResultSet) Query(il.ac.technion.cs.yp.btw.db.queries.Query) CentralLocation(il.ac.technion.cs.yp.btw.classes.CentralLocation) TestResult(junit.framework.TestResult) Test(org.junit.Test)

Example 4 with Query

use of il.ac.technion.cs.yp.btw.db.queries.Query in project BTW by TechnionYearlyProject.

the class QueryTrafficLightExample method testGetAllRoadsSet.

// the test method name needs to begin with the word 'test'
/*
     * @author Sharon Hadar
     * @Date 21/01/2018*/
@Test
public void testGetAllRoadsSet() {
    TestResult result = new TestResult();
    MainDataBase.openConnection();
    Query query = new QueryRoadExample("first");
    // MainDataBase database = new MainDataBase();
    // Set<Road> roads = (Set<Road>) database.queryDataBase(query);
    Set<Road> roads = (Set<Road>) MainDataBase.queryDataBase(query);
    Iterator<Road> iterator = roads.iterator();
    // System.out.println("\n\n\nthe result set is:");
    while (iterator.hasNext()) {
        assertNotNull(iterator.next());
    // System.out.println(iterator.next().toString());
    }
    MainDataBase.closeConnection();
}
Also used : Set(java.util.Set) HashSet(java.util.HashSet) ResultSet(java.sql.ResultSet) Query(il.ac.technion.cs.yp.btw.db.queries.Query) DataRoad(il.ac.technion.cs.yp.btw.db.DataObjects.DataRoad) Road(il.ac.technion.cs.yp.btw.classes.Road) TestResult(junit.framework.TestResult) Test(org.junit.Test)

Example 5 with Query

use of il.ac.technion.cs.yp.btw.db.queries.Query in project BTW by TechnionYearlyProject.

the class BTWDataBaseImpl method getTablesNames.

/**
 * @author: shay
 * @date: 20/1/18
 * update the heuristics table for the specific map in DB
 * @return this object
 */
@Override
public Set<String> getTablesNames() {
    Query query = new QueryAllTables("AdminTables");
    Set<String> tables = (Set<String>) MainDataBase.queryDataBase(query);
    return tables;
}
Also used : QueryAllTables(il.ac.technion.cs.yp.btw.db.queries.QueryAllTables) Query(il.ac.technion.cs.yp.btw.db.queries.Query)

Aggregations

Query (il.ac.technion.cs.yp.btw.db.queries.Query)5 HashSet (java.util.HashSet)4 Set (java.util.Set)4 ResultSet (java.sql.ResultSet)3 TestResult (junit.framework.TestResult)3 Test (org.junit.Test)3 CentralLocation (il.ac.technion.cs.yp.btw.classes.CentralLocation)1 Road (il.ac.technion.cs.yp.btw.classes.Road)1 Street (il.ac.technion.cs.yp.btw.classes.Street)1 TrafficLight (il.ac.technion.cs.yp.btw.classes.TrafficLight)1 DataRoad (il.ac.technion.cs.yp.btw.db.DataObjects.DataRoad)1 DataTrafficLight (il.ac.technion.cs.yp.btw.db.DataObjects.DataTrafficLight)1 QueryAllStreetNames (il.ac.technion.cs.yp.btw.db.queries.QueryAllStreetNames)1 QueryAllTables (il.ac.technion.cs.yp.btw.db.queries.QueryAllTables)1 QueryStreet (il.ac.technion.cs.yp.btw.db.queries.QueryStreet)1