def test_lazy_load():
import clientcentral.query as operators
print(pytest.ticket_id)
ticket = (cc.query_tickets().filter_by(
operators.and_(
operators.comparison("created_by_user.email", "=",
"'*****@*****.**'"),
operators.comparison("id", "=", str(pytest.ticket_id)),
)).all()[0])
assert ticket is not None
assert ticket.status.open == True
assert ticket.status.closed == False
assert hasattr(ticket, "_comments_attribute") == False
assert hasattr(ticket, "_change_events_attribute") == False
assert hasattr(ticket, "_events_attribute") == False
assert hasattr(ticket, "_custom_fields_attribute") == False
assert hasattr(ticket, "_available_buttons_attribute") == False
ticket.comments
assert hasattr(ticket, "_comments_attribute") == True
assert hasattr(ticket, "_change_events_attribute") == True
assert hasattr(ticket, "_events_attribute") == True
assert hasattr(ticket, "_custom_fields_attribute") == True
assert hasattr(ticket, "_available_buttons_attribute") == True
assert "<" not in ticket.comments[0].get_comment_text()
assert ">" not in ticket.comments[0].get_comment_text()
def test_button_press_from_ticket_query():
import clientcentral.query as operators
ticket = (cc.query_tickets().filter_by(
operators.and_(
operators.comparison("created_by_user.email", "=",
"'*****@*****.**'"),
operators.comparison("id", "=", str(pytest.ticket_id)),
)).all()[0])
assert ticket is not None
assert ticket.available_buttons is not None
def test_ticket_created_from_email():
# 90771
# Should not raise NoneType exception
ticket = cc.get_ticket_by_id(90771)
# Should not raise NoneType exception
tickets = (cc.query_tickets().filter_by(
operators.and_(operators.comparison("id", "=", "90771"), )).all())
def test_query_internal_event():
import clientcentral.query as operators
ticket = (cc.query_tickets().filter_by(
operators.and_(
operators.comparison("created_by_user.email", "=",
"'*****@*****.**'"),
operators.comparison("workspace_id", "=", 141),
)).all()[1])
# assert ticket.assignee is not None
assert ticket.status is not None
assert ticket.type is not None
assert ticket.workspace_id is not None
ticket.commit("not visible", commit_internal=True)
# ticket.refresh()
assert ticket.events[0].internal is True
ticket.commit("visible", commit_internal=False)
# ticket.refresh()
assert ticket.events[0].internal is False
def get_user_by_email(self, user_email: str) -> User:
url = (self._base_url + "/api/v1/users.json?" + self._token +
"&filter=" +
query.comparison("email", "=", "'" + user_email + "'"))
# Call URL
future = self._event_loop.create_task(self._request("GET", url))
response = self._event_loop.run_until_complete(future)
if response["status_code"] != 200:
raise HTTPError(f"Failed to get user by email: {user_email}",
response)
result_data = response["json"]["data"][0]
return User.create_user_from_dict(result_data)
def test_new_bug():
tickets = (cc.query_tickets().filter_by(
operators.and_(
operators.statement("status.open"),
operators.comparison("workspace_id", "=", "87"),
)).all())