search

jazzdotdev / flute

The Application Framework Built for Powerful, Secure features and add-ons
17 stars 4 forks source link

views loader (visual query builder) #161

Open naturallymitchell opened 5 years ago

naturallymitchell commented 5 years ago

instead of manual lua code, ie(??): https://github.com/foundpatterns/contentdb/blob/66ec7a04ca4b194b35e532ae4f99774c8da110fd/read_document.lua https://github.com/foundpatterns/contentdb/blob/66ec7a04ca4b194b35e532ae4f99774c8da110fd/walk_documents.lua

go from: https://github.com/foundpatterns/gists/blob/master/content.yaml see also, nchah/freebase-mql: A review of the deprecated Freebase knowledge base and Metaweb Query Language (MQL). A brief comparison of MQL and GraphQL.

or: basic-node-setup_0

to, roughly, in Speakeasy syntax:

SELECT 
    node.title AS node_title, 
    node.nid AS nid, 
    node.created AS node_created
FROM 
    {node} node
WHERE 
    (( (node.status = '1') AND (node.type IN  ('article')) ))
ORDER BY 
    node_created DESC
LIMIT 10 OFFSET 0

(copied from https://evolvingweb.ca/blog/developing-views-part-i-describing-your-data-views )



will be useful when making a [BaaS](https://en.wikipedia.org/wiki/Mobile_backend_as_a_service) like:
* https://backendless.com/platform/backend-as-a-service/
* https://www.devart.com/dbforge/oracle/studio/
naturallymitchell commented 2 years ago

https://github.com/jmespath/jmespath.rs https://github.com/jmespath/jmespath.lua