suwako / ShaderPlayground

master
ブランチ master
ShaderPlayground / src / database / locale.cc
3.5 KB、103行 生 Blame 履歴
1/*
2# 076 License
3
4Copyright (c) 076 Studio LLC
5
6Permission is hereby granted to any person obtaining a copy of the software
7Shader Playground (the "Software") to use, modify, merge, copy, publish, distribute,
8sublicense, and/or sell copies of the Software, subject to the following conditions:
9
10 1. **Origin Attribution**:
11 - You must not misrepresent the origin of the Software; you must not claim
12 you created the original Software.
13 - If the Software is used in a product, you must either:
14 a. Provide clear attribution in the product's documentation, user interface,
15 or other visible areas, **OR**
16 b. Pay the original developers a fee they specify in writing.
17 2. **Usage Restriction**:
18 - The Software, or any derivative works, dependencies, or libraries
19 incorporating it, must not be used for censorship or to suppress freedom of
20 speech, expression, or creativity. Prohibited uses include, but are not
21 limited to:
22 - Censorship of so-called "hate speech", visuals, non-mainstream opinions,
23 ideas, or objective reality.
24 - Tools or systems designed to restrict access to information or
25 artistic works.
26 3. **Notice Preservation**:
27 - This license and the above copyright notice must remain intact in all copies
28 of the source code.
29
30THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED,
31INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
32PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
33HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
34CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE
35OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
36*/
37#include <database/locale.hh>
38#include <util/sqlitepp.hh>
39#include <sqlite3.h>
40#include <iostream>
41
42namespace db {
43 Locale::Locale(sqlitepp::Instance *db) : m_DB(db) {
44 {
45 sqlitepp::Stmt stmt(db->GetDB());
46 stmt.Prepare("SELECT id, name, code FROM languages ORDER BY id ASC;");
47
48 while (stmt.Step() == SQLITE_ROW) {
49 Languages lang;
50 lang.id = stmt.ColumnInt(0);
51 lang.name = stmt.ColumnText(1);
52 lang.code = stmt.ColumnText(2);
53
54 sqlitepp::Stmt langStmt(db->GetDB());
55 langStmt.Prepare("SELECT key, value FROM locale WHERE language_id = ?;");
56 langStmt.BindInt(1, lang.id);
57
58 while (langStmt.Step() == SQLITE_ROW)
59 lang.dict.emplace(langStmt.ColumnText(0), langStmt.ColumnText(1));
60
61 m_Langs.emplace_back(std::move(lang));
62 }
63 }
64
65 setLang();
66 }
67
68 string Locale::GetWord(const string &key) const {
69 auto it = m_CurLang.dict.find(key);
70 return it != m_CurLang.dict.end() ? it->second : key;
71 }
72
73 void Locale::SetLanguage(i32 id) {
74 sqlitepp::Stmt stmt(m_DB->GetDB());
75 stmt.Prepare("UPDATE settings SET value = ? WHERE key = ?;");
76 stmt.BindInt(1, id);
77 stmt.BindText(2, "locale");
78
79 if (stmt.Step() != SQLITE_DONE) {
80 std::cerr << "言語変更に失敗。" << std::endl;
81 return;
82 }
83 setLang();
84 }
85
86 //////////
87
88 void Locale::setLang() noexcept {
89 sqlitepp::Stmt stmt(m_DB->GetDB());
90 stmt.Prepare("SELECT value FROM settings WHERE key = ?;");
91 stmt.BindText(1, "locale");
92
93 if ((stmt.Step() == SQLITE_ROW)) {
94 i32 curLangId = stmt.ColumnInt(0);
95 for (const auto &lang : m_Langs) {
96 if (lang.id == curLangId) {
97 m_CurLang = lang;
98 break;
99 }
100 }
101 }
102 }
103} // namespace db