py_watch/processa_sql.py at master · feliphebueno/py_watch · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
from conexao import Conexao
import sys

class processaSql:

    con = None

    def __init__(self):
        self.con = Conexao()
        return

    def getDadosPullRequestSql(self, id):
        qb = self.con.qb('prod_t1')
        return qb.table('repositorio_pull').where('repositorioPullId', id)

    def getContributorSql(self, login):
        qb = self.con.qb('prod_t1')
        return qb.table('contributor').where('contributorLogin', login)

    def getRepositorioSql(self, id):
        qb = self.con.qb('prod_t1')
        return qb.table('repositorio').where('repositorioId', id)

    def getCommitSql(self, sha):
        qb = self.con.qb('prod_t1')
        return qb.table('repositorio_branch_commit').where('repositorioBranchCommitSha', sha)

    def getBranchSql(self, name):
        qb = self.con.qb('prod_t1')
        return qb.table('repositorio_branch').where('repositorioBranchNome', name)