ethosce / lookmlphp
write lookml with php
Installs: 5 746
Dependents: 0
Suggesters: 0
Security: 0
Stars: 3
Watchers: 3
Forks: 0
Open Issues: 0
This package is auto-updated.
Last update: 2024-09-16 19:26:19 UTC
README
Write LookML with PHP for Looker
LookML is based off of YAML, but it is not YAML.
This library will allow you generate LookML with PHP.
Installation
composer require ethosce/lookmlphp:dev-master
Usage
LookMLphp is designed to be very flexible but provide convenience when possible.
See example.php
for a full usage example.
Create a model
require_once 'vendor/autoload.php'; use LookML\Model; // Define the model and connection $model = new Model(); $model->set('connection', 'pgsql'); // Comments and includes $model->comment('include all the views'); $model->set('include', '*.view'); $model->comment('include all the dashboards'); $model->set('include', '*.dashboard'); // Explore on orders $order = $model->explore('order'); $order->set('label', 'Orders'); $order->join('users') ->set('foreign_key', 'uid') ->set('relationship', 'many_to_one'); // Explore on users $user = $model->explore('user') ->set('label', 'Users'); // Render LookML print $model;
Create a view
require_once 'vendor/autoload.php'; use LookML\View; $user = new View('user'); $user->dimension('uid') ->set('type', 'number'); $user->dimension('name') ->set('type', 'string'); // Render the view. print $user; $order = new View('order'); $order = new View('order'); $order->dimension('order_id') ->set('type', 'number'); print $order;
Todo
- Formatting/indenting