@Before public void setUp() { // Get everything primed and ready to roll H2Util.getInstance().setDatabaseLocation("~/mangotesting.db"); H2Util.getInstance().initializeSchemaOnDb(); TestUtility.executeInserts(); }
@Test public void testRemoveMovieFromList() { TestUtility.executeInserts(); DBMovie dieHard = new DBMovie(); dieHard.setId(1); }
@Test public void testRemoveList() { TestUtility.executeInserts(); H2ListsDAO.getInstance().removeList("Action Marathon"); assertTrue(H2ListsDAO.getInstance().getAllLists().size() == 0); }
public void run() { HazelcastClient hClient = TestUtility.newHazelcastClient(h); while (run) { Map<String, String> clientMap = hClient.getMap("putFromMultipleThreads"); clientMap.put(String.valueOf(counter.incrementAndGet()), String.valueOf(counter.get())); } }
@Test public void testGetAllLists() { TestUtility.executeInserts(); List<String> lists = H2ListsDAO.getInstance().getAllLists(); assertTrue(lists.size() == 1); assertTrue(lists.contains("Action Marathon")); }
@Test public void testGetMoviesInList() { TestUtility.executeInserts(); List<Movie> marathonMovies = H2ListsDAO.getInstance().getMoviesInList("Action Marathon"); assertEquals("Die Hard", marathonMovies.get(0).getTitle()); assertEquals("Die Hard: With a Vengeance", marathonMovies.get(1).getTitle()); }
@Test public void testGetBorrowedMovies() { TestUtility.executeInserts(); DBPerson zach = new DBPerson(); zach.setId(2); List<Movie> movies = H2PersonDAO.getInstance().getBorrowedMovies(zach); assertTrue(movies.size() == 1); assertTrue(movies.get(0).getTitle().equals("Die Hard: With a Vengeance")); }
@Test public void testGetAllPersons() { TestUtility.executeInserts(); List<Person> people = H2PersonDAO.getInstance().getAllPersons(); String[] names = {"Paul Osborne", "Zachary Varberg", "Kyle Ronning"}; List<String> namesList = Arrays.asList(names); for (Person p : people) { assertTrue(namesList.contains(p.getName())); } }
@Test public void testReturnMovie() { // TODO: things still need to be sorted out with how borrower // ids are handles here and there. TestUtility.executeInserts(); DBMovie dieHard = new DBMovie(); dieHard.setId(1); dieHard.getTitle(); H2PersonDAO.getInstance().returnMovie(dieHard); H2MovieDAO.getInstance().getMovieInfo(dieHard); assertTrue(dieHard.getBorrower() == null); }
@Test public void testReorderMoviesInList() { TestUtility.executeInserts(); // get the movies and reorder them List<Movie> movies = H2ListsDAO.getInstance().getMoviesInList("Action Marathon"); ArrayList<Movie> newMoviesList = new ArrayList<Movie>(); newMoviesList.add(movies.get(1)); newMoviesList.add(movies.get(0)); H2ListsDAO.getInstance().reorderMoviesInList("Action Marathon", newMoviesList); List<Movie> moviesAgain = H2ListsDAO.getInstance().getMoviesInList("Action Marathon"); assertEquals("Die Hard: With a Vengeance", moviesAgain.get(0).getTitle()); assertEquals("Die Hard", moviesAgain.get(1).getTitle()); }
@Test public void testBorrowMovie() { TestUtility.executeInserts(); // setup people and movie DBPerson kyle = new DBPerson(); kyle.setId(3); DBMovie dieHard = new DBMovie(); dieHard.setId(1); // borrow die hard to kyle H2PersonDAO.getInstance().borrowMovie(kyle, dieHard); H2MovieDAO.getInstance().updateMovie(dieHard); assertTrue(((DBPerson) dieHard.getBorrower()).getId() == kyle.getId()); }
@Test public void compareInfoLevelOutput() throws Exception { final List<String> failures = new ArrayList<String>(); for (final InfoLevel infoLevel : InfoLevel.values()) { if (infoLevel == InfoLevel.unknown) { continue; } for (final SchemaTextDetailType schemaTextDetailType : SchemaTextDetailType.values()) { final String referenceFile = schemaTextDetailType + "_" + infoLevel + ".txt"; final File testOutputFile = File.createTempFile("schemacrawler." + referenceFile + ".", ".test"); testOutputFile.delete(); final OutputOptions outputOptions = new OutputOptions(OutputFormat.text.name(), testOutputFile); outputOptions.setNoInfo(false); outputOptions.setNoHeader(false); outputOptions.setNoFooter(false); final Config config = Config.load( SchemaCrawlerOutputTest.class.getResourceAsStream( "/hsqldb.INFORMATION_SCHEMA.config.properties")); final SchemaCrawlerOptions schemaCrawlerOptions = new SchemaCrawlerOptions(config); schemaCrawlerOptions.setSchemaInfoLevel(infoLevel.getSchemaInfoLevel()); final DatabaseConnectionOptions connectionOptions = testUtility.getDatabaseConnectionOptions(); final Executable executable = new SchemaCrawlerExecutable(schemaTextDetailType.name()); executable.setSchemaCrawlerOptions(schemaCrawlerOptions); executable.setOutputOptions(outputOptions); executable.execute(connectionOptions.getConnection()); failures.addAll( TestUtility.compareOutput( INFO_LEVEL_OUTPUT + referenceFile, testOutputFile, outputOptions.getOutputFormat())); } } if (failures.size() > 0) { fail(failures.toString()); } }
@Test public void testPopulatePerson() { TestUtility.executeInserts(); // Paul is id 1 DBPerson paul = new DBPerson(); paul.setId(1); try { H2PersonDAO.getInstance().populatePerson(paul); } catch (PersonNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } assertTrue(paul.getName().equals("Paul Osborne")); assertTrue(paul.getAddress().equals("3001 Hampshire Ave N")); assertTrue(paul.getEmail().equals("*****@*****.**")); assertTrue(paul.getPhoneNumber().equals("7637970688")); }
/** Test of updatePerson method, of class H2PersonDAO. */ @Test public void testUpdatePerson() { TestUtility.executeInserts(); DBPerson p = new DBPerson(); p.setId(1); // Paul is person 1 p.setName("Some name that is not Paul"); p.setEmail("*****@*****.**"); p.setAddress("3899 drive"); p.setPhoneNumber("38828810083"); H2PersonDAO.getInstance().updatePerson(p); List<Person> people = H2PersonDAO.getInstance().getAllPersons(); ArrayList<String> names = new ArrayList<String>(); for (Person person : people) { names.add(person.getName()); } assertTrue(names.contains("Some name that is not Paul")); }
@Test public void testGetOwnedMovies() { TestUtility.executeInserts(); DBPerson paul = new DBPerson(); paul.setId(1); try { H2PersonDAO.getInstance().populatePerson(paul); } catch (PersonNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } List<Movie> paulsMovies = H2PersonDAO.getInstance().getOwnedMovies(paul); ArrayList<String> movieStrings = new ArrayList<String>(); for (Movie m : paulsMovies) { movieStrings.add(m.getTitle()); } assertTrue(movieStrings.contains("Die Hard")); assertTrue(movieStrings.contains("Die Hard: With a Vengeance")); }
@Test public void testCreateLocation() throws Exception { Time time = Time.of(2015, 12, 24, 9, 1, 0); UserLocation mc = TestUtility.createUserLocation( "+94770780210", "CDC47124648058A", 98.0f, "Home", 79.857488, 6.8781381, time); HTTP.Response response = HTTP.POST(server.httpURI().resolve("/contra/location/create").toString(), mc); // Check the status. assertEquals("Error in request.", HttpURLConnection.HTTP_OK, response.status()); // Do not use the exact location for withinDistance Result result = server .graph() .execute( "START n = node:location_layer('withinDistance:[6.8781381, 79.857487, 0.1]') RETURN n.name as name"); Map<String, Object> map = result.next(); assertEquals("Location is not created.", "Home", map.get("name")); }
/** Test of addPerson method, of class H2PersonDAO. */ @Test public void testAddPerson() { TestUtility.executeInserts(); DBPerson p = new DBPerson(); p.setName("Bob Billy McTest"); p.setEmail("*****@*****.**"); p.setAddress("123 the lane"); p.setPhoneNumber("952.883.3918"); try { H2PersonDAO.getInstance().addPerson(p); } catch (PersonExistsException pee) { fail("Why was this thrown?"); } List<Person> people = H2PersonDAO.getInstance().getAllPersons(); ArrayList<String> names = new ArrayList<String>(); for (Person person : people) { names.add(person.getName()); } assertTrue(names.contains("Bob Billy McTest")); }
@Test public void compareCompositeOutput() throws Exception { final String queryCommand1 = "all_tables"; final Config queriesConfig = new Config(); queriesConfig.put(queryCommand1, "SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES"); final String queryCommand2 = "dump_tables"; queriesConfig.put( queryCommand2, "SELECT ${orderbycolumns} FROM ${table} ORDER BY ${orderbycolumns}"); final String[] commands = new String[] { SchemaTextDetailType.details + "," + Operation.count + "," + Operation.dump, SchemaTextDetailType.list + "," + Operation.count, queryCommand1 + "," + queryCommand2 + "," + Operation.count + "," + SchemaTextDetailType.list, }; final List<String> failures = new ArrayList<String>(); for (final OutputFormat outputFormat : OutputFormat.values()) { for (final String command : commands) { final String referenceFile = command + "." + outputFormat.name(); final File testOutputFile = File.createTempFile("schemacrawler." + referenceFile + ".", ".test"); testOutputFile.delete(); final OutputOptions outputOptions = new OutputOptions(outputFormat.name(), testOutputFile); outputOptions.setNoInfo(false); outputOptions.setNoHeader(false); outputOptions.setNoFooter(false); final Config config = Config.load( SchemaCrawlerOutputTest.class.getResourceAsStream( "/hsqldb.INFORMATION_SCHEMA.config.properties")); final SchemaCrawlerOptions schemaCrawlerOptions = new SchemaCrawlerOptions(config); schemaCrawlerOptions.setSchemaInfoLevel(SchemaInfoLevel.maximum()); final DatabaseConnectionOptions connectionOptions = testUtility.getDatabaseConnectionOptions(); final SchemaCrawlerExecutable executable = new SchemaCrawlerExecutable(command); executable.setSchemaCrawlerOptions(schemaCrawlerOptions); executable.setOutputOptions(outputOptions); executable.setAdditionalConfiguration(queriesConfig); executable.execute(connectionOptions.getConnection()); failures.addAll( TestUtility.compareOutput( COMPOSITE_OUTPUT + referenceFile, testOutputFile, outputFormat)); } } if (failures.size() > 0) { fail(failures.toString()); } }
/** * Setup the No4j server for testing purposes. * * @throws Exception */ @BeforeClass public static void setUp() throws Exception { server = TestUtility.createServer(LocationResource.class); databaseService = server.graph(); TestUtility.createCommonEntities(databaseService); }