"""Queries."""

UPDATE_PROJECT_AND_PRODUCT_SUBACCOUNT = '\
UPDATE releases SET subaccount_id = {0} WHERE project_id IN ({1}); \
UPDATE project SET subaccount_id = {0} WHERE project_id IN ({1});'

GET_VENDOR_OF_SUBACCOUNT = '\
SELECT vendor_id FROM subaccount WHERE subaccount_id = {};'

GET_VENDOR_OF_PROJECTS = '\
SELECT vendor_id FROM project WHERE project_id IN ({}) GROUP BY vendor_id;'