sqlite_crypt_writer.h

Go to the documentation of this file.

 
#ifndef SQLITE_CRYPT_WRITER_H
#define SQLITE_CRYPT_WRITER_H
 
#include <stdint.h>
#include <sqlite3.h>
 
#define CRYPT_STORE_TABLE_NAME "store"
#define CRYPT_STORE_CREATE_TABLE                                               \
  "CREATE TABLE " CRYPT_STORE_TABLE_NAME                                       \
  " (key TEXT NOT NULL, value TEXT, id TEXT, iv TEXT, "                        \
  "PRIMARY KEY (key));"
#define CRYPT_STORE_INSERT_INTO                                                \
  "INSERT INTO " CRYPT_STORE_TABLE_NAME " VALUES(@key, @value, @id, @iv);"
#define CRYPT_STORE_DELETE_FROM                                                \
  "DELETE FROM " CRYPT_STORE_TABLE_NAME " WHERE key=@key;"
#define CRYPT_STORE_GET                                                        \
  "SELECT value, id, iv FROM  " CRYPT_STORE_TABLE_NAME " WHERE key=?;"
 
#define CRYPT_SECRETS_TABLE_NAME "secrets"
#define CRYPT_SECRETS_CREATE_TABLE                                             \
  "CREATE TABLE " CRYPT_SECRETS_TABLE_NAME                                     \
  " (id TEXT NOT NULL, value TEXT, salt TEXT, iv TEXT, "                       \
  "PRIMARY KEY (id));"
#define CRYPT_SECRETS_INSERT_INTO                                              \
  "INSERT INTO " CRYPT_SECRETS_TABLE_NAME " VALUES(@id, @value, @salt, @iv);"
#define CRYPT_SECRETS_GET                                                      \
  "SELECT value, salt, iv FROM  " CRYPT_SECRETS_TABLE_NAME " WHERE id=?;"
 
struct store_row {
  const char *key; 
  char *value;     
  char *id;        
  char *iv;        
};
 
struct secrets_row {
  char *id;    
  char *value; 
  char *salt;  
  char *iv;    
};
 
int open_sqlite_crypt_db(const char *db_path, sqlite3 **sql);
 
void free_sqlite_crypt_db(sqlite3 *db);
 
int save_sqlite_store_entry(sqlite3 *db, struct store_row *row);
 
int save_sqlite_secrets_entry(sqlite3 *db, struct secrets_row *row);
 
struct store_row *get_sqlite_store_row(sqlite3 *db, const char *key);
 
void free_sqlite_store_row(struct store_row *row);
 
struct secrets_row *get_sqlite_secrets_row(sqlite3 *db, const char *id);
 
void free_sqlite_secrets_row(struct secrets_row *row);
#endif