Mercurial > malikania
annotate 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 |
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 |