"""Queries."""

UPDATE_PROJECT_AND_PRODUCT_SUBACCOUNT = '\
UPDATE releases SET subaccount_id = %(subaccount)s WHERE project_id IN %(projects)s; \
UPDATE project SET subaccount_id = %(subaccount)s WHERE project_id IN %(projects)s;'

GET_VENDOR_OF_SUBACCOUNT = 'SELECT vendor_id FROM subaccount WHERE subaccount_id = %(subaccount)s;'

GET_VENDOR_OF_PROJECTS = 'SELECT vendor_id FROM project WHERE project_id IN %(projects)s GROUP BY vendor_id;'