Download the PHP package zoha/laravel-meta without Composer

Laravel Meta

a laravel package for working with meta !

Page Contents

1. Introduction
2. Features
3. Installation
4. Basic Methods
   • Create New Meta
   • Update Meta
   • Create Or Update Meta
   • Get Meta
   • Get Metas
   • Delete Meta
   • Check Meta Exists Or Not
   • Increase Meta
   • Decrease Meta
5. Clauses
   • Where Meta Clause
   • Where Meta In Clause
   • Where Meta Between Clause
   • Where Meta Null Clause
   • Where Meta Has Clause
   • Order By Meta
   • Eager Loading
6. Other Methods And Features
   • Notes
   • Data Type
   • Custom Meta Table
   • Meta Model
   • Meta Table
7. License
8. Contributing

Introduction

Sometimes our models in laravel needs a lot of information that should be stored in the database. For example, Suppose you want to create a blog and add a model for posts on this blog. The most important information that this model will need is its title and content. But this model may also have more information, Such as the number of likes, download links, thumbnails, views, and more. When the amount of this information is high, We need to create more columns for the model table, Which if there are too many, Will be difficult. Additionally, Each of these posts may have their own unique information that the rest of the posts do not need. In such cases, This package will help. If we want to explain this package simply: Laravel Meta allows you to store information for each of your models and easily access them without having to create new columns for this information in the database tables. If you still do not notice it, Just look at the examples below.

Features

• It is easy to store and receive meta for each model
• An alternative to creating many columns in the database table
• Minimum number of queries and complete optimization
• Ability to filter database records by meta

Installation

First , Require this package with composer

If you Use Laravel <= 5.4 add the ServiceProvider and Alias in config/app.php

And execute migrate command to migrate meta table

And then to add meta functionality to each of your models, You just need to extends it from MetableModel instead of the Model.

Or you can use Metable trait instead :

Optional Section

You can publish meta config file using this command :

In this file you can change default meta table ( default: meta ) Or you can customize meta table for a specific model

That's it! Now you can use all of the Laravel meta features

In all of the examples below, we assume that the $post is set to Post::first() which Post model is an example model

Basic Methods

Create New Meta

For create a meta you can use createMeta on Model :

Or you can create multiple meta like this :

@return : createMeta method returns true if the meta creation is performed successfully and false otherwise

addMeta method is alias of createMeta method

Update Meta

For update a meta you can use updateMeta on Model :

Or you can update multiple meta like this :

@return : If the update was successful updateMeta return true . but if meta already not exists or updating was faild false will be returned

Create Or Update Meta

For create or update meta use setMeta method this method will update meta or create a new one if not exists yet

Or you can set multiple meta like this

@return : setMeta returns true if it is successful. Otherwise it will return false

Or instead of this method, You can set meta using meta property like this :

Get Meta

getMeta method will return meta value :

Also you can get meta values using meta property :

Get Metas

getMetas method will return all metas as a collection :

Delete Meta

For delete meta use deleteMeta method

Or you can use unsetMeta method instead . both of methods are the same. truncateMeta also delete all meta of specific model :

Check Meta Exists Or Not

You can use hasMeta method if you want to check there is a particular meta or not ( if meta exists but value equals to null false will be returned )

The second argument specifies whether or not to accept null values . If you pass true for second argument , and meta exists even if value equals to null true will be returned

If you want to specify that a particular post has a specific meta, even if its value is null , use the existsMeta method.

Increase Meta

You can simply increase meta value using increaseMeta method. Note that incrementing a float value will not increment the decimal unless specified.

You can pass second argument for detemine increase step

Decrease Meta

You can simply decrease meta value using decreaseMeta method. Note that decrementing a float value will not decrement the decimal value unless specified.

And you can pass second argument for detemine decrease step

Clauses

Where Meta Clause

Filter items by meta value :

You can also pass a array for filter result :

You can aslso use orWhere for mulitple or where clause :

You can use branched filters for all meta clauses

Where Meta In Clause

whereMetaIn and whereMetaNotIn clauses :

Where Meta Between Clause

whereMetaBetween and whereMetaNotBetween clauses :

Where Meta Null Clause

whereMetaNull and whereMetaNotNull clauses :

Where Meta Has Clause

whereMetaHas and whereMetaDoesntHave clauses :

Order By Meta

You Can Sort Database Results Using orderByMeta clause :

Eager Loading

If you call $post->getMeta('key') for the first time all of this model meta will be loaded ( once ) and if you try to get another meta from this model another query will not be executed and meta value will loaded from previous query. But if you try to get meta in another model, Another query will be executed for new model . If you want get all meta of all models in one query you can use eager loading of meta . you just need to call withMeta scope like this :

Note that with('meta') will not work

Other Methods And Features

Notes

• by default all collections , arrrays and json values will convert to collection when you try to get them.
• all [] , "{}" , "[]" and null values will be considered null.
• If one of the items in the metable model is deleted, All the meta related to that item will be deleted too.

Data Type

All of setMeta , getMeta , updateMeta And createMeta methods accept a third argument that determine meta data type . there are some examples of this feature :

Available data types : string , integer , float , null , collection , json array , boolean.

In setMeta method

Third argument in createMeta and updateMeta methods is the same of setMeta method

In getMeta method

Custom Meta Table

By default, all meta-data for all models will be stored in the meta database table. But if you want, you can use a separate table for a particular model.

For example, you have Post, Comment and User models

You want to store all posts and comments meta in default table but the user's meta tags are in a special table To do this you have to take four steps :

First Step : you should publish package config file using this command :

This command will place a file named meta.php in your config folder

Second Step : open config file in tables array you find a custom array . in this array you can add new tables name . for our example we add users_meta in this array to handle users meta :

Third Step : you need to run migrate command to create new table .

If you have already migrated Meta migration, you should rollback this migrations and migrate it again ( to create new tables )

Final Step : now that the new table is made, you can introduce it to the User model (or any model you want) to handle its meta with this table . like this :

Meta Model

you are free to use meta model in your project

Note : If you change meta values using meta model ( change database directly ) meta valuse that was loaded before will not be updated . If you want to update them you should call refreshLoadedMeta metahod :

Meta Table

The structure of the meta table is this :

License

contributing

This project is open for you contribution