PHP Classes
elePHPant
Icontem

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: 1 year 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}}"
    }
  }
}