def fetch_empdat(usr_id): sql = """select upper(EMP.rfc) as rfc, EMP.no_id as no_id FROM gral_suc AS SUC LEFT JOIN gral_usr_suc AS USR_SUC ON USR_SUC.gral_suc_id = SUC.id LEFT JOIN gral_emp AS EMP ON EMP.id = SUC.empresa_id WHERE USR_SUC.gral_usr_id=""" q = "{0}{1}".format(sql, usr_id) logger.debug("Performing query: {}".format(q)) try: for row in HelperPg.onfly_query(pt.dbms.pgsql_conn, q): return ErrorCode.SUCCESS, dict(rfc=row['rfc'], no_id=row['no_id']) except: logger.error(dump_exception()) return ErrorCode.DBMS_SQL_ISSUES, None
def make_remain_prefacts_up(conn, user_id): """deals with the remain prefacts which are opened""" q = """SELECT * FROM fac_global_make_up( {}::integer ) AS result( rc integer, msg text )""".format(user_id) res = HelperPg.query(conn, q, True) if len(res) != 1: raise Exception( 'unexpected result regarding execution of fac_global_make_up') rcode, rmsg = res.pop() if rcode != 0: raise Exception(rmsg)
def validation(conn, user_id): """checks coherency before creation prefactura""" q = """SELECT * FROM fac_global_validation( {}::integer ) AS result( rc integer, msg text )""".format(user_id) res = HelperPg.query(conn, q, True) if len(res) != 1: raise Exception( 'unexpected result regarding execution of fac_global_validation') rcode, rmsg = res.pop() if rcode != 0: raise Exception(rmsg)