Package com.saasovation.common.port.adapter.persistence

Examples of com.saasovation.common.port.adapter.persistence.JoinOn


    public Collection<DiscussionData> allDiscussionsDataOfForum(String aTenantId, String aForumId) {
        return this.queryObjects(
                DiscussionData.class,
                "select * from tbl_vw_discussion where tenant_id = ? and forum_id = ?",
                new JoinOn(),
                aTenantId,
                aForumId);
    }
View Full Code Here


    public DiscussionData discussionDataOfId(String aTenantId, String aDiscussionId) {
        return this.queryObject(
                DiscussionData.class,
                "select * from tbl_vw_discussion where tenant_id = ? and discussion_id = ?",
                new JoinOn(),
                aTenantId,
                aDiscussionId);
    }
View Full Code Here

                "post.reply_to_post_id as o_posts_reply_to_post_id, post.subject as o_posts_subject, "
                "post.tenant_id as o_posts_tenant_id "
                + "from tbl_vw_discussion as disc left outer join tbl_vw_post as post "
                + " on disc.discussion_id = post.discussion_id "
                + "where (disc.tenant_id = ? and disc.discussion_id = ?)",
                new JoinOn("discussion_id", "o_posts_discussion_id"),
                aTenantId,
                aDiscussionId);
    }
View Full Code Here

TOP

Related Classes of com.saasovation.common.port.adapter.persistence.JoinOn

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.