Mercurial > malikania
comparison database/sqlite/src/sqlite_character_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 |
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 |