Esempio n. 1
0
  @Test
  public void testDelete() {
    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    Person p = new Person();
    p.setId(2L);

    List<Person> list = sqlEngine.query(session, Person.class, p);
    assertEquals(1, list.size());
    assertEquals("Halle", list.get(0).getName().getFirst());
    assertNotSame(null, list.get(0).getCreatedDate());

    SqlCrudEngine crudEngine = getCrudEngine("DELETE_PERSON");

    String sql = crudEngine.getDeleteSql(p, null);
    logger.info(sql);
    assertContains(sql, "delete from PERSON");
    assertContains(sql, "WHERE ID = :id", "WHERE ID = ?");

    int count = crudEngine.delete(session, p);
    assertEquals(1, count);

    list = sqlEngine.query(session, Person.class, p);
    assertEquals(0, list.size());
  }
Esempio n. 2
0
  @Test
  public void testInsert2() {
    if ("MYSQL".equalsIgnoreCase(dbType) || "MSSQL".equalsIgnoreCase(dbType)) return;

    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    List<Person> list = sqlEngine.query(session, Person.class);
    assertEquals(2, list.size());

    Person p = new Person();
    // p.setId(3L);
    p.setSsn(new Ssn());
    p.getSsn().setNumber("345678");
    p.getSsn().setCountry(Country.UNITED_STATES);
    p.setName(new PersonName());
    p.getName().setFirst("Toby");
    p.getName().setLast("Stephens");
    p.setAge(1969, 4, 21);
    p.setSex(Gender.MALE);
    // p.setCreatedDate(new Date());
    p.setCreatedBy("wlado");
    p.setVersion(1L);
    p.setClothesSize(Size.MIDDLE);

    SqlCrudEngine crudEngine = getCrudEngine("INSERT_PERSON_2");

    String sql = crudEngine.getInsertSql(p, null);
    logger.info(sql);

    int count = crudEngine.insert(session, p);
    assertEquals(1, count);

    list = sqlEngine.query(session, Person.class);
    assertEquals(3, list.size());
  }
Esempio n. 3
0
  @Test
  public void testDelete6() {
    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    Person p = new Person();

    List<Person> list = sqlEngine.query(session, Person.class, p);
    assertEquals(2, list.size());

    SqlCrudEngine crudEngine = getCrudEngine("DELETE_PERSON_6");

    p.setId(list.get(0).getId());
    String sql = crudEngine.getDeleteSql(p, p);
    logger.info(sql);
    assertContains(sql, "delete from PERSON");
    assertContains(sql, "WHERE ID = :id", "WHERE ID = ?");
    assertContains(sql, "AND LASTUPDATEDBY is null");

    int count = crudEngine.delete(session, p);
    assertEquals(1, count);

    list = sqlEngine.query(session, Person.class);
    assertEquals(1, list.size());

    try {
      count = crudEngine.delete(session, null);
      fail();
    } catch (IllegalArgumentException e) {
      assertContains(e.getMessage(), "notempty");
    }
  }
Esempio n. 4
0
  @Test
  public void testGetNull() {
    SqlCrudEngine sqlEngine = getCrudEngine("GET_PERSON");

    Person p = new Person();
    p.setId(9999L);

    Person person2 = sqlEngine.get(session, Person.class, p);
    assertNull(person2);
  }
Esempio n. 5
0
  @Test
  public void testGet() {
    SqlCrudEngine sqlEngine = getCrudEngine("GET_PERSON");

    Person p = new Person();
    p.setId(2L);

    Person person2 = sqlEngine.get(session, Person.class, p);
    assertNotNull(person2);
    assertEquals("Halle", person2.getName().getFirst());
    assertEquals("Berry", person2.getName().getLast());
  }
Esempio n. 6
0
  @Test
  public void testUpdate1() {
    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    Person p = new Person();
    p.setId(2L);

    List<Person> list = sqlEngine.query(session, Person.class, p);
    assertEquals(1, list.size());
    assertEquals("Halle", list.get(0).getName().getFirst());
    assertNotSame(null, list.get(0).getCreatedDate());

    p.setName(new PersonName());
    p.getName().setFirst("Toby");
    p.setCreatedDate(null);

    SqlCrudEngine crudEngine = getCrudEngine("UPDATE_PERSON");

    String sql = crudEngine.getUpdateSql(p, null);
    logger.info(sql);
    assertContains(sql, "update PERSON");
    assertContains(sql, "SET");
    assertContains(sql, "NAME_FIRST = :name_first", "NAME_FIRST = ?");
    assertContains(sql, "CREATEDDATE = :createdDate", "CREATEDDATE = ?");
    assertContains(sql, "WHERE");
    assertContains(sql, "ID = :id", "ID = ?");

    int count = crudEngine.update(session, p);
    assertEquals(1, count);

    list = sqlEngine.query(session, Person.class, p);
    assertEquals(1, list.size());
    assertEquals("Toby", list.get(0).getName().getFirst());
    if ("MYSQL".equalsIgnoreCase(dbType)) assertNotNull(list.get(0).getCreatedDate());
    else assertEquals(null, list.get(0).getCreatedDate());
  }
Esempio n. 7
0
  @Test
  public void testDelete7() {
    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    Person p = new Person();

    List<Person> list = sqlEngine.query(session, Person.class, p);
    assertEquals(2, list.size());

    SqlCrudEngine crudEngine = getCrudEngine("DELETE_PERSON_7");

    p.setSsn(new Ssn());
    p.getSsn().setNumber("123456");
    p.setSex(Gender.MALE);
    String sql = crudEngine.getDeleteSql(p, p);
    logger.info(sql);
    assertContains(sql, "delete from PERSON");
    assertContains(sql, "WHERE SSN_NUMBER = :ssn.number", "WHERE SSN_NUMBER = ?");
    assertContains(sql, "SEX = :sex", "SEX = ?");

    int count = crudEngine.delete(session, p);
    assertEquals(1, count);

    list = sqlEngine.query(session, Person.class);
    assertEquals(1, list.size());

    try {
      count = crudEngine.delete(session, null);
      fail();
    } catch (IllegalArgumentException e) {
      assertContains(e.getMessage(), "notempty");
    }

    try {
      p = new Person();
      p.setSsn(new Ssn());
      p.getSsn().setNumber("123456");
      count = crudEngine.delete(session, p);
      fail();
    } catch (IllegalArgumentException e) {
      assertContains(e.getMessage(), "notempty");
    }
  }
Esempio n. 8
0
  @Test
  public void testInsertEmpty() {
    if ("oracle".equalsIgnoreCase(dbType)) return;

    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    List<Person> list = sqlEngine.query(session, Person.class);
    assertEquals(2, list.size());

    Person p = new Person();
    p.setId(3L);
    p.setSsn(new Ssn());
    p.getSsn().setNumber("");
    p.getSsn().setCountry(Country.UNITED_STATES);
    p.setName(new PersonName());
    p.getName().setFirst("");
    p.getName().setLast("Stephens");
    p.setAge(1969, 4, 21);
    p.setSex(Gender.MALE);
    p.setCreatedDate(new Date());
    p.setCreatedBy("wlado");
    p.setVersion(1L);
    p.setClothesSize(Size.MIDDLE);

    SqlCrudEngine crudEngine = getCrudEngine("INSERT_PERSON");

    String sql = crudEngine.getInsertSql(p, null);
    logger.info(sql);

    int count = crudEngine.insert(session, p);
    assertEquals(1, count);
    logger.info("new id: " + p.getId());
    assertNotNull(p.getId());

    Person p2 = new Person();
    p2.setId(p.getId());
    list = sqlEngine.query(session, Person.class, p2);
    assertEquals(1, list.size());
    Person p3 = list.get(0);
    assertEquals("", p3.getName().getFirst());
    assertEquals("Stephens", p3.getName().getLast());
  }
Esempio n. 9
0
  @Test
  public void testInsert5() {
    if ("ORACLE".equalsIgnoreCase(dbType) || "POSTGRESQL".equalsIgnoreCase(dbType)) return;

    SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");

    List<Person> list = sqlEngine.query(session, Person.class);
    assertEquals(2, list.size());

    Person p = new Person();
    // p.setId(3L);
    p.setSsn(new Ssn());
    p.getSsn().setNumber("345678");
    p.getSsn().setCountry(Country.UNITED_STATES);
    p.setName(new PersonName());
    p.getName().setFirst("Toby");
    p.getName().setLast("Stephens");
    p.setAge(1969, 4, 21);
    p.setSex(Gender.MALE);
    // p.setCreatedDate(new Date());
    p.setCreatedBy("wlado");
    p.setVersion(1L);
    p.setClothesSize(Size.MIDDLE);

    SqlCrudEngine crudEngine = getCrudEngine("INSERT_PERSON_5");

    String sql = crudEngine.getInsertSql(p, null);
    logger.info(sql);
    assertContains(sql, "VALUES");
    assertContains(
        sql,
        ":ssn_number, :ssn_country, :name_first, :name_last, :birthDate, :sex, :createdDate, :createdBy, :version, :clothesSize)",
        "?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

    int count = crudEngine.insert(session, p);
    assertEquals(1, count);
    logger.info("new id: " + p.getId());
    assertNotNull(p.getId());

    list = sqlEngine.query(session, Person.class);
    assertEquals(3, list.size());
  }