Mercurial > malikania

annotate database/sqlite/src/sqlite_spell_dao.cpp @ 106:f8c6d2244795

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Server: rework model and dao
author David Demelier <markand@malikania.fr>
date Mon, 04 Sep 2017 19:41:18 +0200
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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