• Home
• io.castled
• container
• 0.2.90-alpha
• source code
• EncryptionKeysDAO.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.

io.castled.daos.EncryptionKeysDAO Maven / Gradle / Ivy

package io.castled.daos;

import io.castled.encryption.TeamEncryptionKey;
import org.jdbi.v3.sqlobject.customizer.Bind;
import org.jdbi.v3.sqlobject.customizer.BindBean;
import org.jdbi.v3.sqlobject.statement.GetGeneratedKeys;
import org.jdbi.v3.sqlobject.statement.SqlQuery;
import org.jdbi.v3.sqlobject.statement.SqlUpdate;

public interface EncryptionKeysDAO {

    @SqlUpdate("insert into encryption_keys(team_id, encryption_key) values(:encryptionKey.teamId, :encryptionKey.cipherKey)")
    @GetGeneratedKeys
    long createEncryptionKey(@BindBean("encryptionKey") TeamEncryptionKey encryptionKey);

    @SqlQuery("select encryption_key from encryption_keys where team_id = :teamId and is_deleted = 0")
    String getEncryptionKey(@Bind("teamId") Long teamId);

    @SqlUpdate("update encryption_keys set is_deleted = 1 where team_id = :teamId")
    void deleteEncryptionKey(@Bind("teamId") Long teamId);

}