Skip to content
Snippets Groups Projects
Select Git revision
  • 8ab6a8e8c679896b4424f0891775b84dae5a930c
  • master default protected
  • release/beta-qt-202301101210
  • stable
  • release/beta-qt-202211182015
  • release/beta-qt-202211181752
  • release/beta-qt-202211171508
  • release/beta-qt-202211081754
  • release/beta-qt-202211071518
  • release/beta-qt-202210270957
  • release/beta-qt-202210071648
  • release/beta-qt-202209291549
  • release/beta-qt-202209011129
  • release/beta-qt-202208261640
  • release/beta-qt-202208241511
  • release/beta-qt-202208231849
  • release/beta-qt-202208091525
  • release/beta-qt-202207191241
  • release/beta-qt-202207181708
  • release/beta-qt-202207131914
  • release/beta-qt-202207131513
  • android/release_358
  • android/release_357
  • android/release_356
  • android/release_355
  • android/release_354
  • 20221220.0956.79e1207
  • android/release_353
  • android/release_352
  • android/release_350
  • android/release_349
  • android/release_348
  • android/release_347
  • 20221031.1308.130cc26
  • android/release_346
  • android/release_345
  • android/release_344
  • android/release_343
  • android/release_342
  • android/release_341
  • android/release_340
41 results

Dockerfile_debian_testing

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    databasehelper.cpp 11.33 KiB
    /****************************************************************************
     *   Copyright (C) 2017 Savoir-faire Linux                                  *
     *   Author: Nicolas Jäger <nicolas.jager@savoirfairelinux.com>             *
     *   Author: Sébastien Blin <sebastien.blin@savoirfairelinux.com>           *
     *                                                                          *
     *   This library is free software; you can redistribute it and/or          *
     *   modify it under the terms of the GNU Lesser General Public             *
     *   License as published by the Free Software Foundation; either           *
     *   version 2.1 of the License, or (at your option) any later version.     *
     *                                                                          *
     *   This library is distributed in the hope that it will be useful,        *
     *   but WITHOUT ANY WARRANTY; without even the implied warranty of         *
     *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU      *
     *   Lesser General Public License for more details.                        *
     *                                                                          *
     *   You should have received a copy of the GNU General Public License      *
     *   along with this program.  If not, see <http://www.gnu.org/licenses/>.  *
     ***************************************************************************/
    #include "databasehelper.h"
    #include "api/profile.h"
    
    namespace lrc
    {
    
    namespace authority
    {
    
    namespace database
    {
    
    std::string
    getProfileId(Database& db, const std::string& uri)
    {
        auto ids = db.select("id", "profiles","uri=:uri", {{":uri", uri}}).payloads;
        return ids.empty() ? "" : ids[0];
    }
    
    std::string
    getOrInsertProfile(Database& db,
                       const std::string& contactUri,
                       const std::string& alias,
                       const std::string& avatar,
                       const std::string& type)
    {
        // Check if profile is already present.
        auto profileAlreadyExists = db.select("id",
                                               "profiles",
                                               "uri=:uri",
                                               {{":uri", contactUri}});
        if (profileAlreadyExists.payloads.empty()) {
           // Doesn't exists, add contact to the database
           auto row = db.insertInto("profiles",
           {{":uri", "uri"}, {":alias", "alias"}, {":photo", "photo"}, {":type", "type"},
           {":status", "status"}},
           {{":uri", contactUri}, {":alias", alias}, {":photo", avatar}, {":type", type},
           {":status", "TRUSTED"}});
    
           if (row == -1) {
               qDebug() << "contact not added to the database";
               return "";
           }
    
           return std::to_string(row);
        } else {
           // Exists, update and retrieve it.
           if (!avatar.empty() && !alias.empty()) {
               db.update("profiles",
                         "alias=:alias, photo=:photo",
                         {{":alias", alias}, {":photo", avatar}},
                         "uri=:uri", {{":uri", contactUri}});