sukohi/white-sheet

一个通过命令行获取各种数据库信息的 Laravel 扩展包。

维护者

详情

github.com/SUKOHI/WhiteSheet

源代码

问题

安装: 20

依赖: 0

建议: 0

安全性: 0

星标: 0

关注者: 2

分支: 0

开放问题: 0

1.0.3 2017-07-09 10:53 UTC

Requires

MIT 9c843d7780f3230a54225ebf32aae0e77fce9b3a

  • Sukohi <sukohi.capilano.woop@gmail.com>

This package is not auto-updated.

Last update: 2024-09-15 01:22:27 UTC

README

一个通过命令行获取各种数据库信息的 Laravel 扩展包。
(此包在 L5.4 下维护)

[命令]

  • db:code : 生成代码
  • db:find : 查找列或表
  • db:fields : 显示字段
  • db:count : 显示行数
  • db:tail : 显示最新的表或行

安装

执行以下命令。

composer require sukohi/white-sheet:1.*

在 app.php 中设置服务提供者

'providers' => [
    ...Others...,
    Sukohi\WhiteSheet\WhiteSheetServiceProvider::class,
]

现在，您可以在 php artisan 命令中找到此包的命令。

使用方法

1. 生成代码

基本操作

您需要设置两个参数来运行此包，如下所示。

php artisan db:code (Model) (SHOWING_TYPE)

(例如)

php artisan db:code User array
  • 在这种情况下，User 表示 App\User。

或者

php artisan db:code App\\User array

生成类型

  • array
  • rule
  • getter
  • setter
  • request
  • js
  • seed
  • html
  • accessor
  • mutator

array

php artisan db:code User array

(输出)

$array = [
    'id' => 'id',
    'name' => 'name',
    'email' => 'email',
    'password' => 'password',
    'remember_token' => 'remember_token',
    'created_at' => 'created_at',
    'updated_at' => 'updated_at',
];

rule

php artisan db:code User rule

(输出)

return [
    'id' => 'required',
    'name' => 'required',
    'email' => 'required',
    'password' => 'required',
    'remember_token' => 'required',
    'created_at' => 'required',
    'updated_at' => 'required',
];

getter

php artisan db:code User getter

(输出)

$id = $user->id;
$name = $user->name;
$email = $user->email;
$password = $user->password;
$remember_token = $user->remember_token;
$created_at = $user->created_at;
$updated_at = $user->updated_at;
$created_on = $user->created_on;

注意：输出代码包括访问器。

setter

php artisan db:code User setter

(输出)

// Variable
$user = new \App\User();
$user->id = $id;
$user->name = $name;
$user->email = $email;
$user->password = $password;
$user->remember_token = $remember_token;
$user->created_at = $created_at;
$user->updated_at = $updated_at;
$user->created_on = $created_on;
$user->save();

// Request
$user = new \App\User();
$user->id = $request->id;
$user->name = $request->name;
$user->email = $request->email;
$user->password = $request->password;
$user->remember_token = $request->remember_token;
$user->created_at = $request->created_at;
$user->updated_at = $request->updated_at;
$user->created_on = $request->created_on;
$user->save();

注意：输出代码包括修改器。

request

php artisan db:code User request

(输出)

$id = $request->id;
$name = $request->name;
$email = $request->email;
$password = $request->password;
$remember_token = $request->remember_token;
$created_at = $request->created_at;
$updated_at = $request->updated_at;

js

php artisan db:code User js

(输出)

// Basic
var id = user.id;
var name = user.name;
var email = user.email;
var password = user.password;
var providerName = user.providerName;
var providerId = user.providerId;
var rememberToken = user.rememberToken;
var createdAt = user.createdAt;
var updatedAt = user.updatedAt;

// Vue
this.id = user.id;
this.name = user.name;
this.email = user.email;
this.password = user.password;
this.providerName = user.providerName;
this.providerId = user.providerId;
this.rememberToken = user.rememberToken;
this.createdAt = user.createdAt;
this.updatedAt = user.updatedAt;

seed

php artisan db:code User seed

(输出)

$user = new \App\User();
$user->name = $request->name;
$user->email = $request->email;
$user->password = $request->password;
$user->remember_token = $request->remember_token;
$user->created_on = $request->created_on;
$user->save();

html

php artisan db:code User html

(输出)

<!-- Empty -->
<input type="text" name="id" value="">
<input type="text" name="name" value="">
<input type="text" name="email" value="">
<input type="text" name="password" value="">
<input type="text" name="remember_token" value="">
<input type="text" name="created_at" value="">
<input type="text" name="updated_at" value="">

<!-- with Values -->
<input type="text" name="id" value="{{ $user->id }}">
<input type="text" name="name" value="{{ $user->name }}">
<input type="text" name="email" value="{{ $user->email }}">
<input type="text" name="password" value="{{ $user->password }}">
<input type="text" name="remember_token" value="{{ $user->remember_token }}">
<input type="text" name="created_at" value="{{ $user->created_at }}">
<input type="text" name="updated_at" value="{{ $user->updated_at }}">

<!-- Vue -->
<input type="text" name="id" v-model="id">
<input type="text" name="name" v-model="name">
<input type="text" name="email" v-model="email">
<input type="text" name="password" v-model="password">
<input type="text" name="remember_token" v-model="rememberToken">
<input type="text" name="created_at" v-model="createdAt">
<input type="text" name="updated_at" v-model="updatedAt">

访问器

php artisan db:code User accessor

(输出)

public function getIdAttribute($value) {

    return $value;

}
public function getNameAttribute($value) {

    return $value;

}
public function getEmailAttribute($value) {

    return $value;

}
public function getPasswordAttribute($value) {

    return $value;

}
public function getProviderNameAttribute($value) {

    return $value;

}
public function getProviderIdAttribute($value) {

    return $value;

}
public function getRememberTokenAttribute($value) {

    return $value;

}
public function getCreatedAtAttribute($value) {

    return $value;

}
public function getUpdatedAtAttribute($value) {

    return $value;

}

修改器

php artisan db:code User mutator

(输出)

public function setIdAttribute($value) {

    $this->attributes['id'] = $value;

}
public function setNameAttribute($value) {

    $this->attributes['name'] = $value;

}
public function setEmailAttribute($value) {

    $this->attributes['email'] = $value;

}
public function setPasswordAttribute($value) {

    $this->attributes['password'] = $value;

}
public function setProviderNameAttribute($value) {

    $this->attributes['provider_name'] = $value;

}
public function setProviderIdAttribute($value) {

    $this->attributes['provider_id'] = $value;

}
public function setRememberTokenAttribute($value) {

    $this->attributes['remember_token'] = $value;

}
public function setCreatedAtAttribute($value) {

    $this->attributes['created_at'] = $value;

}
public function setUpdatedAtAttribute($value) {

    $this->attributes['updated_at'] = $value;

}

2. 查找列或表

php artisan db:find SEARCH_KEYWORD

例如)

php artisan db:find user

/* Output

    [ authors ]:
     - created_user_id
     - updated_user_id
     
    [ users ]:

*/

3. 显示字段

php artisan db:fields TABLE_NAME

例如)

php artisan db:fields users

/* Output

    [ users ]:
     - id
     - name
     - email
     - password
     - provider_name
     - provider_id
     - remember_token
     - created_at
     - updated_at

*/

4. 显示行数

php artisan db:count TABLE_NAME

例如)

php artisan db:count items

/* Output

    [ items ]: 12345 rows

*/

4. 显示最新的表或行

(用于表)

php artisan db:tail

/* Output

    2017-07-01 15:11:59 : [ users ] 
    2017-07-09 18:20:59 : [ users ] 
    2017-07-09 18:30:00 : [ movies ] 
    2017-07-09 18:31:00 : [ songs ] 
    2017-07-09 18:34:00 : [ songs ] 

*/

(用于行)

php artisan db:tail TABLE_NAME

/* Output

    [ songs ]:
     - 2017-07-01 15:11:59 (ID: 208)
     - 2017-07-01 15:11:59 (ID: 202)
     - 2017-07-01 15:11:59 (ID: 203)
     - 2017-07-09 18:31:00 (ID: 204)
     - 2017-07-09 18:34:00 (ID: 205)


*/

[选项]

  • --limit, -l : 您想显示多少行？默认为 5。

许可证

此软件包受 MIT 许可证许可。
版权所有 2017 Sukohi Kuhoh