Download the PHP package shimabox/laqu without Composer

On this page you can find all versions of the php package shimabox/laqu. 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 shimabox/laqu

Informations about the package laqu

Laqu

[ Japanese | English ]

Laqu is Laravel Db Query Helper.

Run Tests Maintainability Test Coverage

Features

Attention

このライブラリは、開発中に利用されることを想定しています。

See Also

【Laravel】実行されたDBクエリの確認ができるやつを書いた - Qiita

Requirement

Installation

Via composer.

Develop.

Usage

QueryAssertion

期待するクエリが流れているかPHPUnitでアサーションするためのものです。
traitです。assertQuery()を使います。

QueryAnalyzer

クエリが流れるメソッドを渡して、どのようなクエリが流れたのか確認することができます。
QueryAnalyzer::analyze()で実行されたクエリの結果(Laqu\Analyzer\QueryList)が取得できます。
※ QueryListはLaqu\Analyzer\Queryを持ちます

Helper

QueryLog

QueryLogは Basic Database Usage - Laravel - The PHP Framework For Web Artisans の処理をラップしたものです。
※ 実行時間関連はそこまで精密ではありません

QueryHelper

クエリとバインドパラメータを渡すと、実行されるクエリの確認ができます。
pdo-debug/pdo-debug.php at master · panique/pdo-debug を参考にしています。

QueryFormatter

QueryFormatterはDoctrine\SqlFormatter\SqlFormatterのラッパーです。
@see doctrine/sql-formatter: A lightweight php class for formatting sql statements. Handles automatic indentation and syntax highlighting.

デフォルトはNullHighlighterを利用していますが、CLI、HTMLでのフォーマットも可能です。

format()

デフォルトのHighlighterはDoctrine\SqlFormatter\NullHighlighterです。

Doctrine\SqlFormatter\CliHighlighterを利用する場合は以下の通り、CliHighlighterをインジェクトしてください。

出力結果
example_CliHighlighter

Doctrine\SqlFormatter\HtmlHighlighterを利用する場合は以下の通り、HtmlHighlighterをインジェクトしてください。

出力結果
example_HtmlHighlighter

highlight()

使い方は format() とほぼ同じです。
https://github.com/doctrine/sql-formatter#syntax-highlighting-only を参照してください。

compress()

compress()はすべてのコメントと余計な空白を取り除いたクエリを返却します。
https://github.com/doctrine/sql-formatter#compress-query を参照してください。

Develop

Run php-cs-fixer.

check.

fix.

Run phpstan(larastan).

check.

Run test.

Run ci.

Run all the above commands at once.

TODO

テストで確認しているクエリのパターンがまだまだ少ないです。

All versions of laqu with dependencies

PHP Build Version
Package Version
Requires php Version ^7.4|^8.0
illuminate/support Version ^6.0|^7.0|^8.0|^9.0
doctrine/sql-formatter Version ^1.1
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 shimabox/laqu contains the following files

Loading the files please wait ....