Download the PHP package tobento/service-storage without Composer

On this page you can find all versions of the php package tobento/service-storage. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of tobento/service-storage

Informations about the package service-storage

Storage Service

The Storage Service comes with a query builder for storing and fetching items.

Table of Contents

Getting started

Add the latest version of the Storage service running this command.

Requirements

Highlights

Simple Example

Here is a simple example of how to use the Storage service.

Documentation

Storages

Pdo MariaDb Storage

Pdo MySql Storage

Json File Storage

In Memory Storage

Storage Comparison

Return items columns support:

Storage insert() insertMany() update() delete()
Pdo MariaDb Storage yes yes no yes
Pdo MySql Storage yes no no no
Json File Storage yes yes yes yes
In Memory Storage yes yes yes yes

Queries

Select Statements

Retrieving methods

get

Retrieve items.

Check out Items Interface to learn more about it.

column

Index by a certain column:

Check out Item Interface to learn more about it.

first

Returns the first found item or NULL.

Check out Item Interface to learn more about it.

find

Returns a single item by id or NULL.

Check out Item Interface to learn more about it.

value

Get a single column's value from the first item found.

count

Get the items count.

Where Clauses

where / orWhere

Supported operators: =, !=, >, <, >=, <=, <>, <=>, like, not like

whereIn / whereNotIn / orWhereIn / orWhereNotIn

whereNull / whereNotNull / orWhereNull / orWhereNotNull

whereBetween / whereNotBetween / orWhereBetween / orWhereNotBetween

whereColumn / orWhereColumn

Supported operators: =, !=, >, <, >=, <=, <>, <=>

JSON Where Clauses

whereJsonContains / orWhereJsonContains

whereJsonContainsKey / orWhereJsonContainsKey

whereJsonLength / orWhereJsonLength

Supported operators: =, !=, >, <, >=, <=, <>, <=>

Join Clauses

join

leftJoin / rightJoin

Advanced join clauses

Group Clauses

Select Columns

You may select just specific columns.

Index Column

Specify the column you want the items to be indexed.

Ordering

Limit

Insert Statements

Check out Item Interface to learn more about it.

return specific columns

return null

Mass Insert Statements

Check out Items Interface to learn more about it.

return specific columns

return null

Item Factory

You may use the item factory iterator to seed items and use the Seeder Service to generate fake data.

Json File Items

Update Statements

You may constrain the update query using where clauses.

Check out Items Interface to learn more about it.

return specific columns

:warning: Pdo MySql Storage does not return the items as returning statements are not supported.

You may get the count though:

return null

updateOrInsert

Check out Item Interface to learn more about it.

Check out Items Interface to learn more about it.

Updating JSON Columns

Delete Statements

Check out Items Interface to learn more about it.

return specific columns

return null

Transactions

commit

rollback

transaction

You may use the transaction method to run a set of storage operations within a transaction. If an exception is thrown within the transaction closure, the transaction will automatically be rolled back. If the closure executes successfully, the transaction will automatically be committed.

Chunking Results and Inserts

You may use the chunk method if you need to work with thousands or even millions of item(s).

column

Returns the column in generator mode.

get

Returns the items in generator mode.

insertItems

Returns the inserted items in generator mode.

If you set the return parameter to null it will immediately insert the items but not return them in generator mode. You may be able to get the number of items created though.

Miscellaneous

new

The new method will return a new storage instance.

fetchItems

The fetchItems method will return all table items.

storeItems

The storeItems method will store the items to the table which will be truncated first.

deleteTable

The deleteTable method will delete the table completely.

Debugging

Using a Closure

You must use a Closure if you want to debug other retrieving methods than "get" or insert, update and delete statements.

Item Interface

Iterating item attributes:

get

Get an item value by key.

all

Returns all items (attributes).

count

Returns the number of the attributes.

collection

Returns a new Collection with the attributes.

Check out the Collection to learn more about it.

Items Interface

Iterating items:

get

Get an item value by key.

all

Returns all items.

first

Returns the first item, otherwise null.

column

Returns the column of the items.

map

Map over each of the items returning a new instance.

groupBy

Returns a new instance with the grouped items.

reindex

Reindex items returning a new instance.

count

Returns the number of the items.

collection

Returns a new Collection with the items.

Check out the Collection to learn more about it.

Tables

Tables are used by the storages for verifying table and column names for building queries.

add

Credits

All versions of service-storage with dependencies

PHP Build Version
Package Version
Requires php Version >=8.0
tobento/service-collection Version ^1.0.7
tobento/service-support Version ^1.0
tobento/service-filesystem Version ^1.0
tobento/service-file-creator Version ^1.0
tobento/service-iterable Version ^1.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package tobento/service-storage contains the following files

Loading the files please wait ....