The database from grafiteinc

database's Introduction

Database - A set of handy commands for MySQL databases.

The Grafite Database package is a collection of commands to help with MySQL related concerns in developing including: creating databases, dropping them, backing them up and restoring them.

Author(s):

Matt Lantz (@mattylantz, mattlantz at gmail dot com)

Requirements

PHP 7.2+|8.0+

Compatibility and Support

Laravel Version	Package Tag	Supported
^6.x - ^11.x	2.x	yes
^6.x - ^7.x	1.x	no

Installation

Start a new Laravel project:

composer create-project laravel/laravel your-project-name

Then run the following to add Grafite Database

composer require "grafite/database"

Documentation

https://docs.grafite.ca/utilities/database

License

Grafite Database is open-sourced software licensed under the MIT license

Bug Reporting and Feature Requests

Please add as many details as possible regarding submission of issues and feature requests

Disclaimer

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

database's People

Contributors

Stargazers

Watchers

database's Issues

table start at

ALTER TABLE table_name AUTO_INCREMENT = start_value

Query Ideas

// User::tree()->get();
Builder::macro('tree', function (string $attribute, string $searchTerm) { //field (parent_id)
// select id,
// parent_id
// from (select * from builder_websites
// order by parent_id, id) builder_websites_sorted,
// (select @pv := 1) initialisation
// where find_in_set(parent_id, @pv)
// and length(@pv := concat(@pv, ',', id))
});

    // User::topParent()->get();
    Builder::macro('topParent', function (string $attribute, string $searchTerm) { //field (parent_id), depth = 10
//     SELECT c.id
//    FROM builder_websites c
//         INNER JOIN (SELECT coalesce(c7.id, c6.id, c5.id, c4.id, c3.id, c2.id, c1.id) id
//                            FROM builder_websites c1
//                                 LEFT JOIN builder_websites c2
//                                           ON c2.id = c1.parent_id
//                                 LEFT JOIN builder_websites c3
//                                           ON c3.id = c2.parent_id
//                                 LEFT JOIN builder_websites c4
//                                           ON c4.id = c3.parent_id
//                                 LEFT JOIN builder_websites c5
//                                           ON c5.id = c4.parent_id
//                                 LEFT JOIN builder_websites c6
//                                           ON c6.id = c5.parent_id
//                                 LEFT JOIN builder_websites c7
//                                           ON c7.id = c6.parent_id
//                            WHERE c1.id = 5) t
//                    ON t.id = c.id;
    });

Recommend Projects

grafiteinc / database Goto Github PK

database's Introduction

Author(s):

Requirements

Compatibility and Support

Installation

Documentation

License

Bug Reporting and Feature Requests

Disclaimer

database's People

Contributors

Stargazers

Watchers

database's Issues

table start at

Query Ideas

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent