_version1Instant = now.minusSeconds(100);
_version2Instant = now.minusSeconds(50);
s_logger.debug("test data now: {}", _version1Instant);
s_logger.debug("test data later: {}", _version2Instant);
final JdbcOperations template = _usrMaster.getDbConnector().getJdbcOperations();
ManageableOGUser user = new ManageableOGUser("101");
user.setUniqueId(UniqueId.of("DbUsr", "101", "0"));
user.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("A", "B"), ExternalId.of("C", "D"), ExternalId.of("E", "F")));
user.setUserId("Test101");
user.setName("TestUser101");
user.setTimeZone(ZoneId.of("Europe/London"));
template.update("INSERT INTO usr_oguser VALUES (?,?,?,?,?, ?,?,?,?,?, ?)",
101, 101, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP,
"Test101", "PW", "TestUser101", "Europe/London", "email101@email.com");
user.setUniqueId(UniqueId.of("DbUsr", "102", "0"));
user.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("A", "B"), ExternalId.of("C", "D"), ExternalId.of("G", "H")));
user.setUserId("Test102");
user.setName("TestUser102");
user.setTimeZone(ZoneId.of("Europe/Paris"));
template.update("INSERT INTO usr_oguser VALUES (?,?,?,?,?, ?,?,?,?,?, ?)",
102, 102, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP,
"Test102", "PW", "TestUser102", "Europe/Paris", "email102@email.com");
user.setUniqueId(UniqueId.of("DbUsr", "201", "0"));
user.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("C", "D"), ExternalId.of("E", "F")));
user.setUserId("Test201");
user.setName("TestUser201");
user.setTimeZone(ZoneId.of("Asia/Tokyo"));
template.update("INSERT INTO usr_oguser VALUES (?,?,?,?,?, ?,?,?,?,?, ?)",
201, 201, toSqlTimestamp(_version1Instant), toSqlTimestamp(_version2Instant), toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP,
"Test201", "PW", "TestUser201", "Asia/Tokyo", "email201@email.com");
user.setUniqueId(UniqueId.of("DbUsr", "201", "1"));
user.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("C", "D"), ExternalId.of("E", "F")));
user.setUserId("Test202");
user.setName("TestUser202");
user.setTimeZone(ZoneId.of("Asia/Tokyo"));
template.update("INSERT INTO usr_oguser VALUES (?,?,?,?,?, ?,?,?,?,?, ?)",
202, 201, toSqlTimestamp(_version2Instant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version2Instant), MAX_SQL_TIMESTAMP,
"Test202", "PW", "TestUser202", "Asia/Tokyo", "email202@email.com");
_totalUsers = 3;
// id bigint not null,