--[[----------------------------------------------------------------------------

ADOBE CONFIDENTIAL
------------------
Copyright 2014 Adobe Systems Incorporated
All Rights Reserved.

NOTICE: All information contained herein is, and remain the property of
Adobe Systems Incorporated and its suppliers, if any. The intellectual and
technical concepts contained herein are proprietary to Adobe Systems
Incorporated and its suppliers and may be covered by U.S. and Foreign
Patents, patents in process, and are protected by trade secret or copyright
law.  Dissemination of this information or reproduction of this material is
strictly forbidden unless prior written permission is obtained from
Adobe Systems Incorporated.

----------------------------------------------------------------------------]]--

local LrmAssetQueries = {}

LrmAssetQueries.unsyncedProfiles = [[
							SELECT 
								l.docId, l.subtype, l.fileName, l.masterUrl, l.uniqueId 
							FROM 
								assetProfileLinks as l 
							LEFT JOIN 
								profileRegistration as p 
							ON 
								p.uniqueId == l.uniqueId 
							WHERE 
								l.docId == ? 
							AND 
								p.uniqueId IS NULL]]

--------------------------------------------------------------------------------

LrmAssetQueries.allUnsyncedProfiles = [[
							SELECT
								l.docId, l.subtype, l.fileName, l.masterUrl, l.uniqueId
							FROM
								assetProfileLinks as l
							LEFT JOIN
								profileRegistration as p
							ON
								p.uniqueId == l.uniqueId
							WHERE
								p.uniqueId IS NULL]]

--------------------------------------------------------------------------------

LrmAssetQueries.unsyncedCameraProfiles = [[
							SELECT 
								l.docId, l.subtype, l.fileName, l.masterUrl, l.uniqueId 
							FROM 
								assetProfileLinks as l 
							LEFT JOIN 
								profileRegistration as p 
							ON 
								p.uniqueId == l.uniqueId 
							WHERE 
								l.docId == ?  AND l.subtype == 'camera'
							AND 
								p.uniqueId IS NULL]]

return LrmAssetQueries
