Examples with Timestamp java.sql.Timestamp used on opensource projects

Example 36 with Timestamp

use of java.sql.Timestamp in project OpenAttestation by OpenAttestation.

the class CertificateRepository method search.

@Override
public //    @RequiresPermissions("tag_certificates:search") 
CertificateCollection search(CertificateFilterCriteria criteria) {
    log.debug("Certificate:Search - Got request to search for the Certificates.");
    CertificateCollection objCollection = new CertificateCollection();
    try (JooqContainer jc = TagJdbi.jooq()) {
        DSLContext jooq = jc.getDslContext();
        SelectQuery sql = jooq.select().from(MW_TAG_CERTIFICATE).getQuery();
        if (criteria.filter) {
            if (criteria.id != null) {
                // when uuid is stored in database as the standard UUID string format (36 chars)
                sql.addConditions(MW_TAG_CERTIFICATE.ID.equalIgnoreCase(criteria.id.toString()));
            }
            if (criteria.subjectEqualTo != null && criteria.subjectEqualTo.length() > 0) {
                sql.addConditions(MW_TAG_CERTIFICATE.SUBJECT.equalIgnoreCase(criteria.subjectEqualTo));
            }
            if (criteria.subjectContains != null && criteria.subjectContains.length() > 0) {
                sql.addConditions(MW_TAG_CERTIFICATE.SUBJECT.lower().contains(criteria.subjectContains.toLowerCase()));
            }
            if (criteria.issuerEqualTo != null && criteria.issuerEqualTo.length() > 0) {
                sql.addConditions(MW_TAG_CERTIFICATE.ISSUER.equalIgnoreCase(criteria.issuerEqualTo));
            }
            if (criteria.issuerContains != null && criteria.issuerContains.length() > 0) {
                sql.addConditions(MW_TAG_CERTIFICATE.ISSUER.lower().contains(criteria.issuerContains.toLowerCase()));
            }
            if (criteria.sha1 != null) {
                sql.addConditions(MW_TAG_CERTIFICATE.SHA1.equalIgnoreCase(criteria.sha1.toHexString()));
            }
            if (criteria.sha256 != null) {
                sql.addConditions(MW_TAG_CERTIFICATE.SHA256.equalIgnoreCase(criteria.sha256.toHexString()));
            }
            if (criteria.validOn != null) {
                sql.addConditions(MW_TAG_CERTIFICATE.NOTBEFORE.lessOrEqual(new Timestamp(criteria.validOn.getTime())));
                sql.addConditions(MW_TAG_CERTIFICATE.NOTAFTER.greaterOrEqual(new Timestamp(criteria.validOn.getTime())));
            }
            if (criteria.validBefore != null) {
                sql.addConditions(MW_TAG_CERTIFICATE.NOTAFTER.greaterOrEqual(new Timestamp(criteria.validBefore.getTime())));
            }
            if (criteria.validAfter != null) {
                sql.addConditions(MW_TAG_CERTIFICATE.NOTBEFORE.lessOrEqual(new Timestamp(criteria.validAfter.getTime())));
            }
            if (criteria.revoked != null) {
                sql.addConditions(MW_TAG_CERTIFICATE.REVOKED.equal(criteria.revoked));
            }
        }
        sql.addOrderBy(MW_TAG_CERTIFICATE.SUBJECT);
        Result<Record> result = sql.fetch();
        log.debug("Got {} records", result.size());
        for (Record r : result) {
            Certificate certObj = new Certificate();
            try {
                certObj.setId(UUID.valueOf(r.getValue(MW_TAG_CERTIFICATE.ID)));
                // unlike other table queries, here we can get all the info from the certificate itself... except for the revoked flag
                certObj.setCertificate((byte[]) r.getValue(MW_TAG_CERTIFICATE.CERTIFICATE));
                certObj.setIssuer(r.getValue(MW_TAG_CERTIFICATE.ISSUER));
                certObj.setSubject(r.getValue(MW_TAG_CERTIFICATE.SUBJECT));
                certObj.setNotBefore(r.getValue(MW_TAG_CERTIFICATE.NOTBEFORE));
                certObj.setNotAfter(r.getValue(MW_TAG_CERTIFICATE.NOTAFTER));
                certObj.setSha1(Sha1Digest.valueOf(r.getValue(MW_TAG_CERTIFICATE.SHA1)));
                certObj.setSha256(Sha256Digest.valueOf(r.getValue(MW_TAG_CERTIFICATE.SHA256)));
                certObj.setRevoked(r.getValue(MW_TAG_CERTIFICATE.REVOKED));
                log.debug("Certificate:Search - Created certificate record in search result {}", certObj.getId().toString());
                objCollection.getCertificates().add(certObj);
            } catch (Exception e) {
                log.error("Certificate:Search - Cannot load certificate #{}", r.getValue(MW_TAG_CERTIFICATE.ID), e);
            }
        }
        sql.close();
    } catch (Exception ex) {
        log.error("Certificate:Search - Error during certificate search.", ex);
        throw new RepositorySearchException(ex, criteria);
    }
    log.debug("Certificate:Search - Returning back {} of results.", objCollection.getCertificates().size());
    return objCollection;
}

Example 37 with Timestamp

use of java.sql.Timestamp in project pinot by linkedin.

the class JobManagerImpl method deleteRecordsOlderThanDaysWithStatus.

@Override
@Transactional
public int deleteRecordsOlderThanDaysWithStatus(int days, JobStatus status) {
    DateTime expireDate = new DateTime().minusDays(days);
    Timestamp expireTimestamp = new Timestamp(expireDate.getMillis());
    Predicate statusPredicate = Predicate.EQ("status", status.toString());
    Predicate timestampPredicate = Predicate.LT("updateTime", expireTimestamp);
    List<JobBean> list = genericPojoDao.get(Predicate.AND(statusPredicate, timestampPredicate), JobBean.class);
    for (JobBean jobBean : list) {
        deleteById(jobBean.getId());
    }
    return list.size();
}

Example 38 with Timestamp

use of java.sql.Timestamp in project hibernate-orm by hibernate.

the class DbVersionTest method testCollectionVersion.

@Test
public void testCollectionVersion() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    User steve = new User("steve");
    s.persist(steve);
    Group admin = new Group("admin");
    s.persist(admin);
    t.commit();
    s.close();
    Timestamp steveTimestamp = steve.getTimestamp();
    // For dialects (Oracle8 for example) which do not return "true
    // timestamps" sleep for a bit to allow the db date-time increment...
    Thread.sleep(1500);
    s = openSession();
    t = s.beginTransaction();
    steve = (User) s.get(User.class, steve.getId());
    admin = (Group) s.get(Group.class, admin.getId());
    steve.getGroups().add(admin);
    admin.getUsers().add(steve);
    t.commit();
    s.close();
    assertFalse("owner version not incremented", StandardBasicTypes.TIMESTAMP.isEqual(steveTimestamp, steve.getTimestamp()));
    steveTimestamp = steve.getTimestamp();
    Thread.sleep(1500);
    s = openSession();
    t = s.beginTransaction();
    steve = (User) s.get(User.class, steve.getId());
    steve.getGroups().clear();
    t.commit();
    s.close();
    assertFalse("owner version not incremented", StandardBasicTypes.TIMESTAMP.isEqual(steveTimestamp, steve.getTimestamp()));
    s = openSession();
    t = s.beginTransaction();
    s.delete(s.load(User.class, steve.getId()));
    s.delete(s.load(Group.class, admin.getId()));
    t.commit();
    s.close();
}

Example 39 with Timestamp

use of java.sql.Timestamp in project hibernate-orm by hibernate.

the class DbVersionTest method testCollectionNoVersion.

@Test
public void testCollectionNoVersion() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    User steve = new User("steve");
    s.persist(steve);
    Permission perm = new Permission("silly", "user", "rw");
    s.persist(perm);
    t.commit();
    s.close();
    Timestamp steveTimestamp = steve.getTimestamp();
    s = openSession();
    t = s.beginTransaction();
    steve = (User) s.get(User.class, steve.getId());
    perm = (Permission) s.get(Permission.class, perm.getId());
    steve.getPermissions().add(perm);
    t.commit();
    s.close();
    assertTrue("owner version was incremented", StandardBasicTypes.TIMESTAMP.isEqual(steveTimestamp, steve.getTimestamp()));
    s = openSession();
    t = s.beginTransaction();
    steve = (User) s.get(User.class, steve.getId());
    steve.getPermissions().clear();
    t.commit();
    s.close();
    assertTrue("owner version was incremented", StandardBasicTypes.TIMESTAMP.isEqual(steveTimestamp, steve.getTimestamp()));
    s = openSession();
    t = s.beginTransaction();
    s.delete(s.load(User.class, steve.getId()));
    s.delete(s.load(Permission.class, perm.getId()));
    t.commit();
    s.close();
}

Example 40 with Timestamp

use of java.sql.Timestamp in project Openfire by igniterealtime.

the class SessionEntry method getLast_activityAsDate.

public Date getLast_activityAsDate() {
    Timestamp stamp = new Timestamp(last_activity);
    Date date = new Date(stamp.getTime());
    return date;
}