~aleteoryx/muditaos

ref: 7bcc1c9bd4add82ca6d53aa22e12e620551ba172 muditaos/module-services/service-db/agents/quotes/QuotesQueries.hpp -rw-r--r-- 585 bytes
7bcc1c9b — Lucjan Bryndza [EGD-6013] Fix no copy syscall 4 years ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
// Copyright (c) 2017-2021, Mudita Sp. z.o.o. All rights reserved.
// For licensing, see https://github.com/mudita/MuditaOS/LICENSE.md

#pragma once

namespace Quotes::Queries
{
    constexpr auto getAllCategories = R"sql(
                        SELECT category_id, category_name, enabled
                        FROM category_table;
                        )sql";

    constexpr auto getAllQuotes = R"sql(
                        SELECT quote_id, lang_id, quote, author, enabled
                        FROM quote_table;
                        )sql";
} // namespace Quotes::Queries