Search parameters of L5-repository OR Infyom

Include 2 relationships: /api/v1/sites?limit=5&with=landowner;extractee https://github.com/andersao/l5-repository#using-the-requestcriteria Conducting research in the repository http://prettus.local/users?search=John%20Doe or http://prettus.local/users?search=John&searchFields=name:like or http://prettus.local/[email protected]&searchFields=email:= or http://prettus.local/users?search=name:John Doe;email:[email protected] or http://prettus.local/users?search=name:John;email:[email protected]&searchFields=name:like;email:= [ { “id”: 1, “name”: “John Doe”, “email”: “[email protected]”, “created_at”: “-0001-11-30 00:00:00”, “updated_at”: “-0001-11-30 00:00:00” } ] By default RequestCriteria makes its queries using the OR comparison operator for each query parameter.http://prettus.local/users?search=age:17;email:[email protected] The above example …

Generate models and migrations from exists database tables

https://github.com/krlove/eloquent-model-generator for generate models from exists POSTGRES database tables php artisan krlove:generate:model –output-path=Models –namespace=App\\Models Landowner don’t use plural for modle name. eg. use Landowner instead of landowners.   https://github.com/CrestApps/laravel-code-generator generator models, controller, view files, cool ! ! BUT NO API https://github.com/reliese/laravel for generate models from exists database tables https://github.com/Xethron/migrations-generator for Generate Laravel Migrations from an …

Install Laravel Docker for Mac

Install Laravel Docker for Mac 1. Download and install Docker for Mac, user: laraveldocker Pass:laravexxxxxxx.xxx8 2. Follow installation doc from http://laradock.io/documentation/ docker-compose up -d nginx postgres pgadmin redis workspace 3. errors fixed by “can add  shared paths /Applications/MAMP/htdocs/myapiary from Docker -> Preferences… -> File Sharing” and ERROR: for laradock_docker-in-docker_1  Cannot start service docker-in-docker: b’Mounts denied: …

How to use Json/jsonb in Postgres

How to use JSONB/Json in Postgres Now that we have gone over some of the benefits and use-cases for storing JSON data in Postgres, let’s take a look at how it’s actually done. Defining columns JSONB columns are just like any other data type now. Here’s an example of creating a cards table that stores …

Laravel Docker with Nginx,PHP7,MySql,Postgres,phpMyAdmin,pgAdmin

Laravel Docker with Nginx,PHP7,MySql,Postgres,phpMyAdmin,pgAdmin Let’s see how easy it is to install NGINX, PHP, Composer, MySQL, Redis and Beanstalkd: 1 – Clone Laradock inside your PHP project: git clone https://github.com/Laradock/laradock.git 2 – Enter the laradock folder and rename env-example to .env. cp env-example .env 3 – Run your containers: docker-compose up -d nginx mysql phpmyadmin redis workspace 4 – Open your project’s .env file and set the …

Infyom Laravel Code Generator, Generate CRUD, APIs Code

Infyom Laravel Code Generator  to generate CRUD, APIs, Test Cases and Swagger Documentation support Laravel 5.6, good for API+Swagger http://labs.infyom.com/laravelgenerator/docs better laravel crud, API, generator. include swagger api docs ==== ############ Commands examples:  ############ php artisan infyom:api User –fromTable –tableName=users –paginate=20 –save php artisan infyom:api MqttMsg –fromTable –tableName=mqtt_msgs –paginate=20 –save php artisan infyom:api Extractee –fromTable –tableName=extractees …