PHP Classes

File: src/Cabin/Bridge/Queries/pgsql.json

Recommend this page to a friend!
  Classes of Scott Arciszewski   CMS Airship   src/Cabin/Bridge/Queries/pgsql.json   Download  
File: src/Cabin/Bridge/Queries/pgsql.json
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: CMS Airship
Content management system with security features
Author: By
Last change: Implement Blog Post History

See #149
Re-add link to Blog Post History
Date: 8 years ago
Size: 1,442 bytes
 

Contents

Class file image Download
{ "blog": { "comments": { "list_all": "SELECT * FROM hull_blog_comments ORDER BY approved ASC, commentid ASC OFFSET {{offset}} LIMIT {{limit}}" }, "posts": { "get_version": "SELECT * FROM view_hull_blog_unfiltered WHERE version_unique = ?", "list_all": "SELECT * FROM view_hull_blog_list ORDER BY postid DESC OFFSET {{offset}} LIMIT {{limit}}", "list_mine": "SELECT * FROM view_hull_blog_list l LEFT JOIN hull_blog_author_owners a ON l.author = a.authorid WHERE l.status OR a.userid = ? ORDER BY postid DESC OFFSET {{offset}} LIMIT {{limit}}", "list_versions": "SELECT * FROM hull_blog_post_versions WHERE post = ? ORDER BY versionid DESC", "latest_version": "SELECT * FROM hull_blog_post_versions WHERE post = ? ORDER BY versionid DESC OFFSET 0 LIMIT 1" }, "series": { "list_all": "SELECT * FROM hull_blog_series ORDER BY name ASC OFFSET {{offset}} LIMIT {{limit}}", "list_for_author": "SELECT * FROM hull_blog_series WHERE author IN {{authorids}} ORDER BY name ASC OFFSET {{offset}} LIMIT {{limit}}", "tree": "SELECT s.* FROM hull_blog_series_items i LEFT JOIN hull_blog_series s ON i.parent = s.seriesid WHERE i.series = ? AND i.parent NOT IN {{valueset}}" }, "tags": { "list_all": "SELECT * FROM hull_blog_tags {{orderby}} OFFSET {{offset}} LIMIT {{limit}}" } } }