Mercurial > malikania

annotate database/sqlite/src/sqlite_character_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_character_dao.cpp -- character_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/character.hpp>
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
20 #include <malikania/server/db/character_dao.hpp>
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
21
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
22 #include "common.hpp"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
23
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
24 namespace mlk {
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
25
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
26 namespace server {
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
27
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
28 class sqlite_character_dao : public character_dao {
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
29 public:
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
30 void save(character&) override;
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
31 void remove(character&) override;
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
32 void set_name(character&, const std::string&) override;
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
33 };
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 void sqlite_character_dao::save(character& ch)
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
36 {
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
37 const std::string sql(
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
38 "INSERT INTO character(name) VALUES (?)"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
39 );
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 mlk::server::sqlite::exec(sql, {ch.name()});
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
42
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
43 ch.set_id(sqlite3_last_insert_rowid(mlk::server::sqlite::handle));
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
44 }
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
45
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
46 void sqlite_character_dao::remove(character& ch)
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 const std::string sql(
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
49 "DELETE"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
50 " FROM character"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
51 " WHERE id = ?"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
52 );
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
53
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
54 mlk::server::sqlite::exec(sql, {ch.id()});
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
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
57 void sqlite_character_dao::set_name(character& ch, const std::string& name)
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 const std::string sql(
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
60 "UPDATE character"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
61 " SET name = ?"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
62 " WHERE id = ?"
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
63 );
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
64
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
65 mlk::server::sqlite::exec(sql, {name, ch.id()});
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
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
68 } // !server
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 } // !mlk
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 extern "C" {
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 BOOST_SYMBOL_EXPORT
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
75 std::unique_ptr<mlk::server::character_dao> mlk_character_dao()
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
76 {
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
77 return std::make_unique<mlk::server::sqlite_character_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
f8c6d2244795 Server: rework model and dao
David Demelier <markand@malikania.fr>
parents:
diff changeset
80 } // !C