def get_project_tasks(projectPHID):
""" get project phid by name
:param projectPHID: str
"""
p = phdb(db='phabricator_maniphest',
user=phuser_user,
passwd=phuser_passwd)
_ = p.sql_x("SELECT src from edge \
WHERE dst=%s", (projectPHID), limit=None)
p.close()
if _ is None:
return []
p_ = list(util.tflatten(_))
return p_
def get_failed_creations(dbcon):
""" get failed creations
:param dbcon: db connector
:returns: list
"""
_ = dbcon.sql_x("SELECT id \
from bugzilla_meta \
where priority=%s", (6, ),
limit=None)
if _ is None:
return
f_ = list(util.tflatten(_))
if f_:
return f_
def get_failed_creations(dbcon):
""" get failed creations
:param dbcon: db connector
:returns: list
"""
_ = dbcon.sql_x("SELECT id \
from bugzilla_meta \
where priority=%s",
(6,),
limit=None)
if _ is None:
return
f_ = list(util.tflatten(_))
if f_:
return f_
def get_project_tasks(projectPHID):
""" get project phid by name
:param projectPHID: str
"""
p = phdb(db='phabricator_maniphest',
user=phuser_user,
passwd=phuser_passwd)
_ = p.sql_x("SELECT src from edge \
WHERE dst=%s", (projectPHID),
limit=None)
p.close()
if _ is None:
return []
p_ = list(util.tflatten(_))
return p_
def get_issues_by_priority(dbcon, priority, table):
""" get failed creations
:param dbcon: db connector
:param priority: int
:param table: str
:returns: list
"""
_ = dbcon.sql_x("SELECT id \
from %s \
where priority=%s" % (table, priority), (),
limit=None)
if _ is None:
return
f_ = list(util.tflatten(_))
if f_:
return f_
def get_issues_by_priority(dbcon, priority, table):
""" get failed creations
:param dbcon: db connector
:param priority: int
:param table: str
:returns: list
"""
_ = dbcon.sql_x("SELECT id \
from %s \
where priority=%s" % (table, priority),
(),
limit=None)
if _ is None:
return
f_ = list(util.tflatten(_))
if f_:
return f_
def add_task_cc(ticketphid, userphid):
p = phdb(db='phabricator_maniphest',
user=phuser_user,
passwd=phuser_passwd)
# Get json array of subscribers
query = "SELECT dst FROM \
edge WHERE src = %s and type=21"
jcc_list = p.sql_x(query, ticketphid, limit=None)
if jcc_list is None:
cc_list = []
else:
cc_list = util.tflatten(jcc_list)
if userphid not in cc_list:
set_task_subscriber(ticketphid, userphid)
p.close()
def add_task_cc(ticketphid, userphid):
p = phdb(db='phabricator_maniphest',
user=phuser_user,
passwd=phuser_passwd)
# Get json array of subscribers
query = "SELECT dst FROM \
edge WHERE src = %s and type=21"
jcc_list = p.sql_x(query, ticketphid, limit=None)
if jcc_list is None:
cc_list = []
else:
cc_list = util.tflatten(jcc_list)
if userphid not in cc_list:
set_task_subscriber(ticketphid, userphid)
p.close()