void BngWeb::sortear()
{
    Sql::Transaction t;

    QVariantList rodadaIds;
    QVariantList bolas;

CREATE OR REPLACE FUNCTION bng.comprar_cartelas(v_rodada_id bigint, v_pdv_id integer, v_user_id integer, v_cartelas_qde integer, v_identificacao text, v_autenticacao uuid, v_imprimiu boolean)
RETURNS bigint AS $$
DECLARE
    m_sala_id integer;
    m_venda_id bigint;
    m_ponto_id integer;

CREATE OR REPLACE VIEW bng.rodadas_prontas AS
SELECT r.id, r.sala_id, r.data_hora, r.valor_cartela, r.cartelas_vendidas,
 r.premio_kuadra, r.premio_kina, r.premio_keno,
 s.paga_acumulado, s.acumulado, r.numero_bola_acumulado,
 (SELECT array_agg(vc.cartela_id) AS cartelas FROM bng.venda_cartelas vc WHERE r.id=vc.rodada_id) AS cartelas,
 CASE WHEN s.paga_acumulado AND s.paga_acumulado_maximo AND s.acumulado < s.acumulado_maximo THEN false ELSE true END AS bloqueia_acumulado,

CREATE OR REPLACE VIEW bng.rodadas_prontas AS
SELECT r.id, r.sala_id, r.data_hora, r.valor_cartela, r.cartelas_vendidas,
 r.premio_kuadra, r.premio_kina, r.premio_keno,
 s.paga_acumulado, s.acumulado, r.numero_bola_acumulado,
 (SELECT array_agg(vc.cartela_id) AS cartelas FROM bng.venda_cartelas vc WHERE r.id=vc.rodada_id) AS cartelas,
 CASE WHEN s.paga_acumulado AND s.paga_acumulado_maximo AND s.acumulado < s.acumulado_maximo THEN false ELSE true END AS bloqueia_acumulado,

module qxmpp
    repository git://github.com/qxmpp-project/qxmpp.git
    branch master

    cmake-options -DBUILD_TESTS=OFF -DBUILD_EXAMPLES=OFF -DWITH_GSTREAMER=ON
end module

import os.path
import time
from tkinter import *
import sqlite3
import sys
sys.path.append('..')

import os.path
import time
from tkinter import *
import sqlite3
import sys
sys.path.append('..')

from tkinter import *
import sqlite3, sys
sys.path.append('..')
import time, os.path

class TextFormat(object):

[ 98%] Building C object mc-plugin/CMakeFiles/mcp-account-manager-ofono.dir/mcp-account-manager-ofono.c.o
cd /home/jbb/kde/src/build/telepathy-ofono/mc-plugin && /usr/bin/cc -DQT_NO_KEYWORDS -DUSE_PULSEAUDIO -Dmcp_account_manager_ofono_EXPORTS -I/home/jbb/kde/src/build/telepathy-ofono/mc-plugin -I/home/jbb/kde/src/telepathy-ofono/mc-plugin -I/home/jbb/kde/src/build/telepathy-ofono/mc-plugin/mcp-account-manager-ofono_autogen/include -I/home/jbb/kde/install/include/telepathy-qt5 -I/home/qt/work/install/include/QtDBus -I/home/qt/work/install/include -I/home/qt/work/install/include/QtNetwork -I/home/qt/work/install/include/QtXml -I/home/qt/work/install/include/QtCore -I/home/jbb/.local/Qt/5.15.0/gcc_64/include -I/home/jbb/.local/Qt/5.15.0/gcc_64/include/QtCore -I/home/jbb/.local/Qt/5.15.0/gcc_64/./mkspecs/linux-g++ -I/home/jbb/.local/Qt/5.15.0/gcc_64/include/QtDBus -I/usr/include/phonenumbers -I/usr/include/telepathy-qt5 -I/usr/include/ofono-qt -I/home/jbb/kde/install/include/mission-control-5.18 -I/usr/include/telepathy-1.0 -I/usr/include/dbus-1.0 -I/usr/lib/x86_64-linux-gnu/dbus-1.0/include -I/usr/include/libmount -I/usr/include/blkid -I/usr/include/glib-2.0 -I/usr/lib/x86_64-linux-gnu/glib-2.0/include  -fPIC   -o CMakeFiles/mcp-account-manager-ofono.dir/mcp-account-manager-ofono.c.o   -c /home/jbb/kde/src/telepathy-ofono/mc-plugin/mcp-account-manager-ofono.c
In file included from /usr/include/telepathy-1.0/telepathy-glib/telepathy-glib.h:83,
                 from /home/jbb/kde/install/include/mission-control-5.18/mission-control-plugins/mission-control-plugins.h:26,
                 from /home/jbb/kde/src/telepathy-ofono/mc-plugin/mcp-account-manager-ofono.h:4,
                 from /home/jbb/kde/src/telepathy-ofono/mc-plugin/mcp-account-manager-ofono.c:30:

import org.kde.kirigami 2.2 as Kirigami
import QtQuick 2.7
import QtQuick.Controls 2.2 as Controls

Kirigami.ApplicationWindow {
        pageStack.initialPage: Kirigami.ScrollablePage {