#pragma once

#include <functional>
#include <string>

#include "types.hh"

class sqlite3;
class sqlite3_stmt;

namespace nix {

/* RAII wrapper to close a SQLite database automatically. */
struct SQLite
{
    sqlite3 * db;
    SQLite() { db = 0; }
    ~SQLite();
    operator sqlite3 * () { return db; }
};

/* RAII wrapper to create and destroy SQLite prepared statements. */
struct SQLiteStmt
{
    sqlite3 * db = 0;
    sqlite3_stmt * stmt = 0;
    SQLiteStmt() { }
    void create(sqlite3 * db, const std::string & s);
    ~SQLiteStmt();
    operator sqlite3_stmt * () { return stmt; }

    /* Helper for binding / executing statements. */
    class Use
    {
        friend struct SQLiteStmt;
    private:
        SQLiteStmt & stmt;
        unsigned int curArg = 1;
        Use(SQLiteStmt & stmt);

    public:

        ~Use();

        /* Bind the next parameter. */
        Use & operator () (const std::string & value, bool notNull = true);
        Use & operator () (int64_t value, bool notNull = true);
        Use & bind(); // null

        int step();

        /* Execute a statement that does not return rows. */
        void exec();

        /* For statements that return 0 or more rows. Returns true iff
           a row is available. */
        bool next();

        std::string getStr(int col);
        int64_t getInt(int col);
    };

    Use use()
    {
        return Use(*this);
    }
};

/* RAII helper that ensures transactions are aborted unless explicitly
   committed. */
struct SQLiteTxn
{
    bool active = false;
    sqlite3 * db;

    SQLiteTxn(sqlite3 * db);

    void commit();

    ~SQLiteTxn();
};


MakeError(SQLiteError, Error);
MakeError(SQLiteBusy, SQLiteError);

[[noreturn]] void throwSQLiteError(sqlite3 * db, const format & f);

/* Convenience function for retrying a SQLite transaction when the
   database is busy. */
template<typename T>
T retrySQLite(std::function<T()> fun)
{
    while (true) {
        try {
            return fun();
        } catch (SQLiteBusy & e) {
        }
    }
}

}
v class='path'>path: <a href='/guix/log/?id=1761f5335810615c53a02a031cece4e515487ddb'>root</a>/<a href='/guix/log/po?id=1761f5335810615c53a02a031cece4e515487ddb'>po</a>/<a href='/guix/log/po/packages?id=1761f5335810615c53a02a031cece4e515487ddb'>packages</a>/<a href='/guix/log/po/packages/LINGUAS?id=1761f5335810615c53a02a031cece4e515487ddb'>LINGUAS</a></div><div class='content'><table class='list nowrap'><tr class='nohover'><th class='left'>Age</th><th class='left'>Commit message (<a href='/guix/log/po/packages/LINGUAS?id=1761f5335810615c53a02a031cece4e515487ddb&amp;showmsg=1'>Expand</a>)</th><th class='left'>Author</th></tr>
<tr><td><span title='2023-01-05 08:14:55 +0100'>2023-01-05</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=dc7eb6f07ae982b4c9d083cfb10f72cb031c0424'>nls: Update translations.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/guix/ka.po: New file.
* po/guix/LINGUAS: Add it.
* po/packages/uk.po: New file.
* po/packages/LINGUAS: Add it.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2022-12-04 22:25:23 +0100'>2022-12-04</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=2e75b328b6bbdadbffe5b643a4891b5026a0defd'>nls: Update translations.</a><span class='msg-avail'>...<span class='msg-tooltip'>po/packages/vi.po: New file.
po/packages/LINGUAS: Add it.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2022-06-04 17:42:54 +0200'>2022-06-04</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=809c57c872a6dd48007d1abf6d7f3dd1482ec53a'>nls: Update translations.</a><span class='msg-avail'>...<span class='msg-tooltip'>po/packages/tr.po: New file.
po/packages/LINGUAS: Add it.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2022-04-02 18:42:36 +0200'>2022-04-02</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=8a208df17fe81fbf34f5a86cc52bb0b8e33c7b96'>nls: Update translations.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/packages/fi.po: New file.
* po/packages/LINGUAS: Add it.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2021-09-02 04:06:52 +0200'>2021-09-02</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=1ff2092a39dc5c7c7cd9b4a0ba4b59f92e738efc'>nls: Update translations.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/packages/it.po: New file.
* po/packages/LINGUAS: Add `it'.
* po/*/*.po: Update translations.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2021-05-10 22:27:53 -0400'>2021-05-10</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=63d26e81eea7be63caeb0eb7ca26ca1cf963ec97'>nls: New nl and oc translations for the 'packages' component.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/packages/nl.po: New file.
* po/packages/oc.po: Likewise.
* po/packages/LINGUAS: Register them.
</span></span></td><td>Maxim Cournoyer</td></tr>
<tr><td><span title='2021-04-18 21:07:24 +0200'>2021-04-18</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=a209c597e2e4e030bbaeb449779b311736026aa1'>nls: Remove 'vi' in LINGUAS</a><span class='msg-avail'>...<span class='msg-tooltip'>The po file is no longer available.

* po/packages/LINGUAS: Remove 'vi'.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2021-04-18 13:18:22 +0200'>2021-04-18</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=0f355124af123f793bfd3011341d2d539c965884'>nls: Add Korean translation.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/doc/guix-cookbook.ko.po: New file.
* po/doc/guix-manual.ko.po: New file.
* doc/local.mk (info_TEXINFOS): Add them.
* po/doc/local.mk (DOC_PO_FILES, DOC_COOKBOOK_PO_FILES): Add them.
* po/guix/ko.po: New file.
* po/guix/LINGUAS: Add 'ko'.
* po/packages/ko.po: New file.
* po/packages/LINGUAS: Add 'ko'.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2021-04-18 13:18:17 +0200'>2021-04-18</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=43fb84da6749a78d12ac0f13db4cecb435de7903'>nls: Add Persian translation.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/packages/fa.po: New file.
* po/packages/LINGUAS: Add 'fa'.
* po/doc/guix-cookbook.fa.po: New file.
* po/doc/guix-manual.fa.po: New file.
* po/doc/local.mk (DOC_PO_FILES, DOC_COOKBOOK_PO_FILES): Add them.
* doc/local.mk (info_TEXINFOS): Add them.
</span></span></td><td>Julien Lepiller</td></tr>
<tr><td><span title='2021-04-18 13:18:13 +0200'>2021-04-18</span></td><td><a href='/guix/commit/po/packages/LINGUAS?id=77c6c0aa577939da4d35a1ba95ea998459a3f337'>nls: Add Slovak translation.</a><span class='msg-avail'>...<span class='msg-tooltip'>* po/packages/sk.po: New file.
* po/packages/LINGUAS: Add 'sk'.
* po/doc/guix-manual.sk.po: New file.
* doc/local.mk (info_TEXINFOS): Add it.
* po/doc/local.mk (DOC_PO_FILES): Add it.
</span></span></td><td>Julien Lepiller</td></tr>