• Home
• com.toasttab
• test-jdbishard-dropwizard
• 0.0.2
• source code
• ClientShardDAO.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

jdbishard.dropwizard.testapp.dao.ClientShardDAO Maven / Gradle / Ivy

package jdbishard.dropwizard.testapp.dao;

import org.skife.jdbi.v2.sqlobject.Bind;
import org.skife.jdbi.v2.sqlobject.SqlQuery;
import org.skife.jdbi.v2.sqlobject.SqlUpdate;

import java.util.UUID;

/**
 * A Client information access helper tied to a specific shard. Method access is package-private
 * to prevent accidental use. Use {@link ClientDAO} instead.
 */
public abstract class ClientShardDAO {

    @SqlUpdate("create table client (id uuid primary key, age int)")
    abstract void createClientAgeTable();

    @SqlUpdate("insert into client (id, age) values (:id, :age)")
    abstract void insertClientAge(@Bind("id") UUID id, @Bind("age") int age);

    @SqlQuery("select sum(age) from client")
    abstract int sumClientAge();

    @SqlQuery("select age from client where id = :id")
    abstract int findAgeById(@Bind("id") UUID id);

}