/** ************ Helper stuff ***************** */ private void createAndFillUserTable() { int rowCount = 10000; sql2o .createQuery( "create table User(\n" + "id int identity primary key,\n" + "name varchar(20),\n" + "email varchar(255),\n" + "text varchar(100))") .executeUpdate(); Query insQuery = sql2o.createQuery("insert into User(name, email, text) values (:name, :email, :text)"); Date before = new Date(); for (int idx = 0; idx < rowCount; idx++) { insQuery .addParameter("name", "a name " + idx) .addParameter("email", String.format("*****@*****.**", idx)) .addParameter("text", "some text") .addToBatch(); } insQuery.executeBatch(); Date after = new Date(); Long span = after.getTime() - before.getTime(); System.out.println( String.format("inserted %d rows into User table. Time used: %s ms", rowCount, span)); insertIntoUsers += rowCount; }
@Before public void setUp() { controller = new Controller(35.0); Calendar cal = Calendar.getInstance(); cal.set(2012, Calendar.JANUARY, 1, 1, 1, 0); Date d1, d2; d1 = cal.getTime(); t1 = d1.getTime(); cal.set(2012, Calendar.JANUARY, 1, 1, 1, 2); d2 = cal.getTime(); t2 = d2.getTime(); }
@Test public void testDecodeQualificationForXML() throws IOException { assumeTrue(TestUtil.testdataAvailable()); Date startDate = Calendar.getInstance().getTime(); DecodeQualification decodeQualification = plugIn.getDecodeQualification( TestUtil.getTestFile(productsFolder + "dimap/test_ST4_MT.xml")); assertEquals(DecodeQualification.UNABLE, decodeQualification); decodeQualification = plugIn.getDecodeQualification( TestUtil.getTestFile(productsFolder + "SPOT4_HRVIR1_XS_88888888_N1A.tgz")); assertEquals(DecodeQualification.INTENDED, decodeQualification); Date endDate = Calendar.getInstance().getTime(); assertTrue( "The decoding time for the file is too big!", (endDate.getTime() - startDate.getTime()) / 1000 < 30); // 30 sec }
public void planTest() { Worker worker = workerDAO.getWorkerById(6); Department department = depDAO.getDepartment(2); Date date = new Date(); new Timestamp(date.getTime()); // plan creating Plan plan = new Plan(); plan.setWorker(worker); // worker plan.setDepartment(department); // department // set several timestamp attributes plan.setCreateTime(new Timestamp(date.getTime())); plan.setBeginTime(new Timestamp(date.getTime())); plan.setEndTime(new Timestamp(date.getTime())); // planCommodityRel creating PlanCommodityRel relation1 = new PlanCommodityRel(); Commodity commodity1 = commoDAO.getCommodityById(1); relation1.setCommodity(commodity1); relation1.setPlan(plan); relation1.setPlanNum(50); relation1.setSinglePrice(8); PlanCommodityRel relation2 = new PlanCommodityRel(); Commodity commodity2 = commoDAO.getCommodityById(2); relation2.setCommodity(commodity2); relation2.setPlan(plan); relation2.setPlanNum(50); relation2.setSinglePrice(8); PlanCommodityRel relation3 = new PlanCommodityRel(); Commodity commodity3 = commoDAO.getCommodityById(3); relation3.setCommodity(commodity3); relation3.setPlan(plan); relation3.setPlanNum(50); relation3.setSinglePrice(8); plan.getPlanCommodityRelList().add(relation1); plan.getPlanCommodityRelList().add(relation2); plan.getPlanCommodityRelList().add(relation3); planDAO.createPlan(plan); }
@Test public void testExecuteAndFetch() { createAndFillUserTable(); Date before = new Date(); List<User> allUsers = sql2o.createQuery("select * from User").executeAndFetch(User.class); Date after = new Date(); long span = after.getTime() - before.getTime(); System.out.println(String.format("Fetched %s user: %s ms", insertIntoUsers, span)); // repeat this before = new Date(); allUsers = sql2o.createQuery("select * from User").executeAndFetch(User.class); after = new Date(); span = after.getTime() - before.getTime(); System.out.println(String.format("Again Fetched %s user: %s ms", insertIntoUsers, span)); assertTrue(allUsers.size() == insertIntoUsers); deleteUserTable(); }
public void convert() { // param dateString looks like:2016.2.23 String dateString = "2016.2.23"; Date date = new Date(); DateFormat sdf = new SimpleDateFormat("yyyy.M.d"); try { date = sdf.parse(dateString); } catch (ParseException e) { e.printStackTrace(); } Timestamp timestamp = new Timestamp(date.getTime()); System.out.println(timestamp); }
@Test public void date2() throws SQLException { Date d1 = new Date(1092941466000L); stat.execute("create table t (c1);"); PreparedStatement prep = conn.prepareStatement("insert into t values (datetime(?/1000, 'unixepoch'));"); prep.setDate(1, d1); prep.executeUpdate(); ResultSet rs = stat.executeQuery("select strftime('%s', c1) * 1000 from t;"); assertTrue(rs.next()); assertEquals(d1.getTime(), rs.getLong(1)); assertTrue(rs.getDate(1).equals(d1)); }
public void orderTest() { Customer customer = customerDAO.getCustomerById(3); List<Commodity> commodityList = commoDAO.getCommoditiesByIdString("2;3;4"); List<OrderCommodityRel> relationLsit = CommodityListTools.commoToRel(commodityList); Order order = new Order(customer, relationLsit, 100); Map<Integer, Integer> map = new HashMap<Integer, Integer>(); map.put(2, 2); map.put(3, 4); map.put(4, 4); order.setBuyNum(map); Date date = new Date(); order.setOrderTime(new Timestamp(date.getTime())); orderDAO.createOrder(order); System.out.println(order.getOrderId()); }
@Test public void testDate() { assertTrue(eval(builder.profileProperty("properties.lastVisit").equalTo(lastVisit).build())); assertTrue( eval( builder .profileProperty("properties.lastVisit") .greaterThan(new Date(lastVisit.getTime() - 10000)) .build())); assertTrue( eval( builder .profileProperty("properties.lastVisit") .lessThan(new Date(lastVisit.getTime() + 10000)) .build())); assertTrue( eval( builder .profileProperty("properties.lastVisit") .in( new Date(lastVisit.getTime() + 10000), new Date(lastVisit.getTime() - 10000), lastVisit) .build())); assertTrue( eval( builder .profileProperty("properties.lastVisit") .notIn(new Date(lastVisit.getTime() + 10000), new Date(lastVisit.getTime() - 10000)) .build())); assertFalse( eval( builder .profileProperty("properties.lastVisit") .notIn( new Date(lastVisit.getTime() + 10000), new Date(lastVisit.getTime() - 10000), lastVisit) .build())); assertTrue(eval(builder.profileProperty("properties.lastVisit").all(lastVisit).build())); assertFalse( eval( builder .profileProperty("properties.lastVisit") .all(new Date(lastVisit.getTime() + 10000), lastVisit) .build())); }
@Test public void date1() throws SQLException { Date d1 = new Date(987654321); stat.execute("create table t (c1);"); PreparedStatement prep = conn.prepareStatement("insert into t values(?);"); prep.setDate(1, d1); prep.executeUpdate(); prep.setDate(1, null); prep.executeUpdate(); ResultSet rs = stat.executeQuery("select c1 from t;"); assertTrue(rs.next()); assertEquals(d1.getTime(), rs.getLong(1)); assertTrue(rs.getDate(1).equals(d1)); assertTrue(rs.next()); assertEquals(null, rs.getDate(1)); rs.close(); }