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)
class CrudUtil(): con = None def __init__(self, link = 'padrao'): self.con = Conexao(link) def insert(self, tabela, camposValores): try: self.con.qb().begin_transaction() id = self.con.qb().table(tabela).insert_get_id(camposValores) self.con.qb().commit() return id except Exception as e: self.con.qb().rollback() raise Exception("Database transaction failed. Details: "+ str(e)) def update(self, tabela, where, camposValores): try: self.con.qb().begin_transaction() id = self.con.qb().table(tabela).where(where).update(camposValores) self.con.qb().commit() return id except Exception as e: self.con.qb().rollback() raise Exception("Database transaction failed. Details: " + str(e)) def delete(self, tabela, where): try: self.con.qb().begin_transaction() id = self.con.qb().table(tabela).where(where).delete() self.con.qb().commit() return id except Exception as e: self.con.qb().rollback() raise Exception("Database transaction failed. Details: " + str(e))