A pretty library to help developers build RESTful APIs lightly, quickly and properly even without writing code.

It's always easy to customize to suit any need such as defining data relationships, authorization, caching, communicating or integrating into other systems.

• Serves RESTful APIs for any MySql database
  • Pagination
  • Sorting
  • Selection
  • Grouping, Having
  • Filtering
  • Relationships
  • Metadata
• Supports Event Bus

Use HTTP clients like Postman to invoke RESTful API calls.

Combine with API Gateway is also recommended to build a completely development environment for microservice.

Apify is packed as a composer package. So it's installed quickly in 2 steps

1. Require the composer package

   composer require megaads/apify

2. Register the provider:

   Megaads\Apify\ApifyServiceProvider

• PHP: >= 5.6
• Laravel/ Lumen Framework: 5.4.*
• MySQL
• Message queue server: optional

/api/post?page_id=2&page_size=20

Order by multiple columns using sorts parameter

/api/post?sorts=user_id

/api/post?sorts=-created_at

/api/post?sorts=user_id,-created_at

Select columns from the records using fields parameter. SQL aggregate functions such as COUNT, MAX, MIN, SUM, AVG, SQL aliases are also available

/api/post?fields=id,content,user_id,sum(view_count) as view_sum

Group the result-set by one or more columns using groups parameter and combine with aggregate functions using Selection

/api/post?fields=user_id,sum(view_count)&groups=user_id

Apify supports filtering records based on more than one AND, NOT condition by using comma. For example:

/api/post?filters=user_id=1,status={enabled;pending},tile~hello,view_count!=null

Complex conditions that combine AND, OR and NOT will be available soon.

Apify works by a simple mechanism, looking for a model class that correspond to the API entity, otherwise the API entity will be matched to a suitable DB table. That means no model class is required to create, do it only in the case of defining relationships, customizing.

So API entity name should follow one of the conventions:

• The API entity name is the same as a model class name

• Or the API entity name in snake_case that correspond to a model class with the name in CamelCase

• Or the API entity name is the same as a DB table name

Apify is packed into a Laravel/ Lumen package so relationships also are defined as methods on Eloquent model classes.

See Laravel docs for details: https://laravel.com/docs/5.6/eloquent-relationships

Let's consider the following relationship definations:

• A Nation has many City (one-to-many relationship)

namespace App\Models;
class Nation extends \Apify\Models\BaseModel {
    protected $table = 'location_nation';
    public function cities() {
        return $this->hasMany('App\Models\City', 'nation_id', id);
    }
}

• A City belongs to a Nation (many-to-one relationship)
• A City has many District (one-to-many relationship)

namespace App\Models;
class City extends \Apify\Models\BaseModel {
    protected $table = 'location_city';
    public function nation() {
        return $this->belongsTo('App\Models\Nation', 'nation_id');
    }
    public function districts() {
        return $this->hasMany('App\Models\District', 'city_id', id);
    }
}

• A District belongs to a City (many-to-one relationship)

namespace App\Models;
class District extends \Apify\Models\BaseModel {
    protected $table = 'location_district';
    public function city() {
        return $this->belongsTo('App\Models\City', 'city_id');
    }
}    

Apify provides the ability to embed relational data into the results using embeds parameter

For example

/api/nation?embeds=cities

/api/city?embeds=nation,districts

/api/district?embeds=city

Even nested relationships

/api/nation?embeds=cities.districts

/api/district?embeds=city.nation

/api/city?filters=nation.location_code=EU,districts.name~land

/api/post

or

/api/post?metric=get

Response format

{
    "meta": {
        "has_next": true,
        "total_count": 100,
        "page_count": 2,
        "page_size": 50,
        "page_id": 0
    },
    "result": [],
    "status": "successful"
}

/api/post?metric=first

Response format

{    
    "result": {},
    "status": "successful"
}

/api/post?metric=count

Response format

{    
    "result": 50,
    "status": "successful"
}

/api/post?metric=increment&fields=view_count

Response format

{    
    "result": 1,
    "status": "successful"
}

Is being updated ...

The Apify is open-sourced software licensed under the MIT license

Email: [email protected]

Skype: phult.bk