Skip to content

Instantly share code, notes, and snippets.

View wmuron's full-sized avatar

Wiktor Muroń wmuron

View GitHub Profile
@wmuron
wmuron / trajectory_utils.py
Created March 28, 2018 10:05
SfMLearner - merging consecutive poses sequences into single trajectory
import numpy as np
from kitti_eval.pose_evaluation_utils import pose_vec_to_mat
def convert_and_change_coordinate_system(poses, new_coord_index=0):
coord_pose = pose_vec_to_mat(poses[new_coord_index])
out = []
for pose_vec in poses:
pose = pose_vec_to_mat(pose_vec)
@wmuron
wmuron / dasda
Created December 4, 2016 14:55
sda
function signalFiltered = highPassFilter(signal, fc, fs)
signalFrecDomain = fft(signal);
frecs = 0 : ((fs/2)/length(signalFrecDomain)) : (fs/2);
minLength = min(length(signalFrecDomain), length(frecs));
signalFrecDomain = signalFrecDomain(1 : minLength);
frecs = frecs(1:minLength);
for ind = 1 : length(frecs)
INSERT INTO users (id, name, created_at_utc) VALUES (1, 'John Smith', '1970-1-1 00:00:00.000')
ConditionsBuilder conditionsBuilder = new ConditionsBuilder();
Condition cond = conditionsBuilder.equal("createdAt", utcDate);
conditionsBuilder.apply(cond);
List<User> results = uRepo.find(conditionsBuilder);
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<User> criteriaQuery = criteriaBuilder.createQuery(User.class);
Root<User> userRoot = criteriaQuery.from(User.class);
//Specification<User> specs = (root, query, cb) ->
// cb.equal(root.get("createdAt"), utcDate);
String paramName = "pn";
Specification<User> specs = (root, query, cb) ->
cb.equal(root.get("createdAt"), cb.parameter(Date.class, paramName));
@TypeDef(name = "UtcDateType", defaultForType = Date.class, typeClass = UtcDateType.class),
package com.montrosesoftware.dbassist.types;
@wmuron
wmuron / User.hbm.xml
Created October 20, 2016 13:36
Line showing how to use fix
...
<property name="createdAt" type="com.montrosesoftware.dbassist.types.UtcDateType" column="created_at"/>
...
import org.hibernate.type.DateType;
public class UtcDateType extends DateType {
private static final TimeZone UTC = TimeZone.getTimeZone("UTC");
@Override
public Object get(ResultSet rs, String name) throws SQLException {
return rs.getDate(name, Calendar.getInstance(UTC));
}
Configuration configuration = new Configuration().configure();
SessionFactory factory = configuration.buildSessionFactory();
Session session = factory.openSession();
Transaction transaction = session.beginTransaction();
//prepare date
String createdAtUtcStr = "2016-04-24 9:54:23";
DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
format.setTimeZone(TimeZone.getTimeZone("UTC"));
Date date = format.parse(createdAtUtcStr);
Configuration configuration = new Configuration().configure();
SessionFactory factory = configuration.buildSessionFactory();
Session session = factory.getCurrentSession();
Transaction transaction = session.getTransaction();
transaction.begin();
//insert one user
String sql = "INSERT INTO users (id, name, created_at_utc)"
+ "VALUES (1, 'Adam Spring', '2016-06-12 14:54:15')";
Query query = session.createSQLQuery(sql);