db.h

Go to the documentation of this file.

/*
   Copyright 2020 Raphael Beck
 
   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 
   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
*/
 
#ifndef OPSICK_DB_H
#define OPSICK_DB_H
 
#ifdef __cplusplus
extern "C" {
#endif
 
#include <stddef.h>
#include <stdint.h>
#include <libpq-fe.h>
 
#include "user.h"
 
int opsick_db_init(const char* dbconn_filepath);
 
PGconn* opsick_db_connect();
 
void opsick_db_disconnect(PGconn* dbconn);
 
uint64_t opsick_db_get_schema_version_number();
 
uint64_t opsick_db_get_last_used_userid();
 
void opsick_db_last_128_bytes_of_ciphertext(uint8_t out[128]);
 
uint64_t opsick_db_get_last_db_schema_version_nr_lookup();
 
int opsick_db_does_user_id_exist(PGconn* dbconn, uint64_t user_id);
 
int opsick_db_create_user(PGconn* dbconn, const char* pw, uint64_t exp_utc, const char* public_key_ed25519, const char* encrypted_private_key_ed25519, const char* public_key_curve448, const char* encrypted_private_key_curve448, uint64_t* out_user_id);
 
int opsick_db_delete_user(PGconn* dbconn, uint64_t user_id);
 
uint64_t opsick_db_count_users(PGconn* dbconn);
 
int opsick_db_get_user_metadata(PGconn* db, uint64_t user_id, struct opsick_user_metadata* out_user_metadata);
 
int opsick_db_set_user_pw(PGconn* dbconn, uint64_t user_id, const char* new_pw);
 
int opsick_db_set_user_totps(PGconn* dbconn, uint64_t user_id, const char* new_totps);
 
int opsick_db_get_user_body(PGconn* dbconn, uint64_t user_id, char** out_body, size_t* out_body_length);
 
int opsick_db_set_user_body(PGconn* dbconn, uint64_t user_id, const char* body);
 
int opsick_db_set_user_exp(PGconn* dbconn, uint64_t user_id, uint64_t new_exp);
 
int opsick_db_set_user_keys(PGconn* dbconn, uint64_t user_id, const char* new_pubkey_ed25519, const char* new_prvkey_ed25519, const char* new_pubkey_curve448, const char* new_prvkey_curve448);
 
void opsick_db_free();
 
#ifdef __cplusplus
} // extern "C"
#endif
 
#endif // OPSICK_DB_H