Mercurial > malikania
annotate database/sqlite/src/sqlite_spell_dao.cpp @ 106:f8c6d2244795
Server: rework model and dao
author | David Demelier <markand@malikania.fr> |
---|---|
date | Mon, 04 Sep 2017 19:41:18 +0200 |
parents | |
children |
rev | line source |
---|---|
106
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
1 /* |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
2 * sqlite_spell_dao.cpp -- spell_dao for SQLite |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
3 * |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
4 * Copyright (c) 2013-2017 David Demelier <markand@malikania.fr> |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
5 * |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
6 * Permission to use, copy, modify, and/or distribute this software for any |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
7 * purpose with or without fee is hereby granted, provided that the above |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
8 * copyright notice and this permission notice appear in all copies. |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
9 * |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
10 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
11 * WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
12 * MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
13 * ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
14 * WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
15 * ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
16 * OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
17 */ |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
18 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
19 #include <malikania/server/db/spell_dao.hpp> |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
20 #include <malikania/server/db/character.hpp> |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
21 #include <malikania/server/db/spell.hpp> |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
22 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
23 #include "common.hpp" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
24 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
25 namespace mlk { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
26 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
27 namespace server { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
28 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
29 class sqlite_spell_dao : public spell_dao { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
30 public: |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
31 void save(spell&, character& parent) override; |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
32 void set_level(spell&s, std::uint8_t level) override; |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
33 void remove(spell&) override; |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
34 }; |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
35 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
36 void sqlite_spell_dao::save(spell& s, character& parent) |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
37 { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
38 const std::string sql( |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
39 "INSERT INTO spell(account_id, level) VALUES(?, ?)" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
40 ); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
41 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
42 mlk::server::sqlite::exec(sql, {parent.id(), static_cast<std::uint64_t>(s.level())}); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
43 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
44 s.set_character(parent.shared_from_this()); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
45 s.set_id(sqlite3_last_insert_rowid(mlk::server::sqlite::handle)); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
46 } |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
47 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
48 void sqlite_spell_dao::set_level(spell& s, std::uint8_t level) |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
49 { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
50 const std::string sql( |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
51 "UPDATE spell" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
52 " SET level = ?" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
53 " WHERE id = ?" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
54 ); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
55 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
56 mlk::server::sqlite::exec(sql, {static_cast<std::uint64_t>(level), s.id()}); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
57 } |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
58 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
59 void sqlite_spell_dao::remove(spell& s) |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
60 { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
61 const std::string sql( |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
62 "DELETE" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
63 " FROM spell" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
64 " WHERE id = ?" |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
65 ); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
66 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
67 mlk::server::sqlite::exec(sql, {s.id()}); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
68 } |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
69 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
70 } // !server |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
71 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
72 } // !mlk |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
73 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
74 extern "C" { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
75 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
76 BOOST_SYMBOL_EXPORT |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
77 std::unique_ptr<mlk::server::spell_dao> mlk_spell_dao() |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
78 { |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
79 return std::make_unique<mlk::server::sqlite_spell_dao>(); |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
80 } |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
81 |
f8c6d2244795
Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
82 } // !C |