Hi everybody, this was my surprise project , achivy.com my first startup, my first ruby on rails project :)

you can check the about page but it is simply a gamification platform for lots of social sites and more, it now supports foursquare, gowalla, stackoverflow etc….

Achivy adds some fun and gamification to your social life. Add Twitter,Tumblr, Foursquare Gowalla , Flickr, Stackoverflow, Klout and many other applications to your profile to see how many achievements, badges,scores you have and follow your progress. You can keep up with your friends, and see the other people’s achievements and activities — achivies.

more to come soon…

[caption id=”” align=”alignright” width=”240" caption=”Image by alancleaver_2000 via Flickr”]

[/caption]

it has been a long time since I posted :( so it would be really good to put some targets and build a list of them. otherwise I will be lying on my coach all the time.

• ruby on rails experience : so far so amazing.
• yagdao : finalize and release 1.0
• startupweekend amsterdam notes ! anybody for utrecht ?
• ???, surprise

hope to implement all those and do something interesting here

see you soon

Append Method handler
Another dynamic query builder. But this one , use simple StringBuilder instead of trying to parse the argument. So more fast and adjustable dynamic query builder

For more see test cases and example dao

@YMethod(type = YMethodType.APPEND,select = "pbyte,count(id)",groupBy = "pbyte")
    List<SimpleBean> append2(@YParameter("pint>=?") int i);@YMethod(type =…

yagdao (Yet Another Generic DAO) finally.

this version is a little bit experimental but stable.

yagdao is an generic dao framework that would be enabled by annotations.

simple step to go through for setup read more

• add jar into your classpath
• extend GenericDAO

moreover you can implement custom method read more

for hibernate

public String getIdProperty(Class entityClass) {
String idProperty=sessionAccessor.getSessionFactory()
                                              .getClassMetadata(entityClass)
                                              .getIdentifierPropertyName();
return idProperty;
}

for JPA 2.0 metamodel API this method or to get value of id field see comment below

public String getIdProperty(Class entityClass) {
        String idProperty;
        Metamodel metamodel = getEntityManager().getMetamodel();
        EntityType entity = metamodel.entity(entityClass);
        Set<SingularAttribute> singularAttributes = entity.getSingularAttributes();
        for (SingularAttribute singularAttribute : singularAttributes) {
            if (singularAttribute.isId()){
                idProperty=singularAttribute.getName();
                break;
            }
        }
        if(idProperty==null)
            throw new RuntimeException("id field not found");
        return idProperty;
    }

to

JPA Criteria API by samples — Part-I

some more examples with JPA criteria API
Simple Join query

long category=200L;
Query query = entityManager.createQuery(“select s from OrderItem s where s.product.category=:cat”);
query.setParameter(“cat”, category);
List<OrderItem> list = query.getResultList();
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<Object> criteriaQuery = criteriaBuilder.createQuery();
Root<OrderItem> from = criteriaQuery.from(OrderItem.class);
Path<Object> path = from.join(“product”).get(“category”);
CriteriaQuery<Object> select = criteriaQuery.select(from);
select.where(criteriaBuilder.equal(path, category));
TypedQuery<Object> typedQuery =…

Although examples are pretty much simple it will help you with finalized version of JPA 2.0 API.

For Part II please read JPA Criteria API by samples — Part-II

and in this examples in my opinion building query by programming is not so easy and maintainable but still possible.

PS…

Although this is an important, it is a hidden bug unless you trace you generated SQL for hibernate.

simply the two lines of code below should generate same SQL

Criteria rootCriteria = session.createCriteria(OrderItem.class);
        Criteria criteria = rootCriteria.createCriteria("order").createCriteria("customer")…