\LibMelanie\SqlSqlWorkspaceRequests

Liste des requêtes SQL vers les workspaces

Summary

Methods
Properties
Constants
No public methods found
No public properties found
listPublicsWorkspaces
listUserWorkspaces
listSharedWorkspaces
listWorkspacesByHashtag
listWorkspaceHashtags
listWorkspaceShares
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Constants

listPublicsWorkspaces

listPublicsWorkspaces ="SELECT dwp_workspaces.* FROM dwp_workspaces WHERE workspace_ispublic = 1{order_by}{limit};" :string

listUserWorkspaces

listUserWorkspaces ="SELECT dwp_workspaces.* FROM dwp_workspaces INNER JOIN dwp_shares USING (workspace_id) WHERE user_uid = :user_uid AND rights = 'o'{order_by}{limit};" :string

listSharedWorkspaces

listSharedWorkspaces ="SELECT dwp_workspaces.* FROM dwp_workspaces INNER JOIN dwp_shares USING (workspace_id) WHERE user_uid = :user_uid{order_by}{limit};" :string

listWorkspacesByHashtag

listWorkspacesByHashtag ="SELECT dwp_workspaces.* FROM dwp_workspaces INNER JOIN dwp_hashtags_workspaces USING (workspace_id) INNER JOIN dwp_hashtags USING (hashtag_id) WHERE hashtag = :hashtag{order_by}{limit};" :string

listWorkspaceHashtags

listWorkspaceHashtags ="SELECT dwp_hashtags.* FROM dwp_hashtags INNER JOIN dwp_hashtags_workspaces USING (hashtag_id) WHERE workspace_id = :workspace_id{order_by}{limit};" :string

listWorkspaceShares

listWorkspaceShares ="SELECT dwp_shares.* FROM dwp_shares WHERE workspace_id = :workspace_id{order_by}{limit};" :string