summaryrefslogtreecommitdiff
path: root/Userland/Libraries/LibSQL/Database.h
blob: a9d1179aef6c8172d638ff0e9347e37bda9a6274 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
/*
 * Copyright (c) 2021, Jan de Visser <jan@de-visser.net>
 * Copyright (c) 2021, Mahmoud Mandour <ma.mandourr@gmail.com>
 *
 * SPDX-License-Identifier: BSD-2-Clause
 */

#pragma once

#include <AK/DeprecatedString.h>
#include <AK/RefPtr.h>
#include <LibCore/Object.h>
#include <LibSQL/Forward.h>
#include <LibSQL/Heap.h>
#include <LibSQL/Meta.h>
#include <LibSQL/Result.h>
#include <LibSQL/Serializer.h>

namespace SQL {

/**
 * A Database object logically connects a Heap with the SQL data we want
 * to store in it. It has BTree pointers for B-Trees holding the definitions
 * of tables, columns, indexes, and other SQL objects.
 */
class Database : public Core::Object {
    C_OBJECT(Database);

public:
    ~Database() override;

    ResultOr<void> open();
    bool is_open() const { return m_open; }
    ErrorOr<void> commit();

    ResultOr<void> add_schema(SchemaDef const&);
    static Key get_schema_key(DeprecatedString const&);
    ResultOr<NonnullRefPtr<SchemaDef>> get_schema(DeprecatedString const&);

    ResultOr<void> add_table(TableDef& table);
    static Key get_table_key(DeprecatedString const&, DeprecatedString const&);
    ResultOr<NonnullRefPtr<TableDef>> get_table(DeprecatedString const&, DeprecatedString const&);

    ErrorOr<Vector<Row>> select_all(TableDef&);
    ErrorOr<Vector<Row>> match(TableDef&, Key const&);
    ErrorOr<void> insert(Row&);
    ErrorOr<void> remove(Row&);
    ErrorOr<void> update(Row&);

private:
    explicit Database(DeprecatedString);

    bool m_open { false };
    NonnullRefPtr<Heap> m_heap;
    Serializer m_serializer;
    RefPtr<BTree> m_schemas;
    RefPtr<BTree> m_tables;
    RefPtr<BTree> m_table_columns;

    HashMap<u32, NonnullRefPtr<SchemaDef>> m_schema_cache;
    HashMap<u32, NonnullRefPtr<TableDef>> m_table_cache;
};

}