Mercurial > malikania

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