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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
-module(db).
-behaviour(gen_server).
%% API.
-export([start_link/0, stop/0]).
-export([init_db/0, init_db/1, init_tables/0, init_tables/1]).
-export([add/1, find/1]).
%% API for testing.
-export([dump/1, destroy_tables/0, info_tables/0, dump_to_file/1]).
%% gen_server callbacks.
-export([init/1, handle_call/3, terminate/2, handle_cast/2, handle_info/2,
code_change/3]).
-include_lib("stdlib/include/qlc.hrl").
-include("db.hrl").
-include("plop.hrl").
%% @doc Set up a database schema on all nodes that are to be included
%% in the "database cluster". Has to be run _before_ mnesia has been
%% started.
init_db() ->
init_db([node()]).
init_db(Nodes) ->
ok = mnesia:create_schema(Nodes),
rpc:multicall(Nodes, application, start, [mnesia]),
init_tables(Nodes),
rpc:multicall(Nodes, application, stop, [mnesia]).
%% @doc Run once, or rather every time you start on a new database.
%% If run more than once, we'll get {aborted, {already_exists, TABLE}}.
init_tables() ->
init_tables([node()]).
init_tables(Nodes) ->
%% We've once upon a time invoked mnesia:create_schema/1 with the
%% nodes that will be part of the database.
RamCopies = [],
DiscCopies = [],
DiscOnlyCopies = Nodes,
mnesia:start(),
mnesia:create_table(plop, [{type, set},
{ram_copies, RamCopies},
{disc_copies, DiscCopies},
{disc_only_copies, DiscOnlyCopies},
{attributes, record_info(fields, plop)}]),
mnesia:add_table_index(plop, hash).
destroy_tables() ->
mnesia:delete_table(plop).
info_tables() ->
mnesia:table_info(plop, all).
dump_to_file(Filename) ->
mnesia:dump_to_textfile(Filename).
init(_Args) ->
{mnesia:wait_for_tables([plop], 5000), []}.
start_link() ->
gen_server:start_link({local, ?MODULE}, ?MODULE, [], []).
stop() ->
gen_server:call(?MODULE, stop).
add(Entry) ->
gen_server:call(?MODULE, {add, Entry}).
find(Hash) ->
gen_server:call(?MODULE, {find, Hash}).
dump(Table) ->
gen_server:call(?MODULE, {dump, Table}).
%%%%%%%%%%%%%%%%%%%%
handle_cast(_Request, State) ->
{noreply, State}.
handle_info(_Info, State) ->
{noreply, State}.
code_change(_OldVsn, State, _Extra) ->
{ok, State}.
terminate(_Reason, _State) ->
io:format("~p terminating~n", [?MODULE]),
ok.
%%%%%%%%%%%%%%%%%%%%
handle_call(stop, _From, State) ->
{stop, normal, stopped, State};
handle_call({add, Entry}, _From, State) ->
F = fun() ->
mnesia:write(Entry)
end,
Res = mnesia:transaction(F),
{reply, Res, State};
handle_call({dump, Table}, _From, State) ->
F = fun() ->
Q = qlc:q([E || E <- mnesia:table(Table)]),
qlc:e(Q)
end,
Res = mnesia:transaction(F),
{reply, Res, State};
handle_call({find, Hash}, _From, State) ->
F = fun() ->
mnesia:index_read(plop, Hash, #plop.hash)
end,
{atomic, Result} = mnesia:transaction(F),
Record = case length(Result) of
0 -> [];
1 -> hd(Result);
_ -> duplicate_hash_in_db % FIXME: log an error
end,
{reply, Record, State}.
|