hogus/generate-query-sql

generate queries to sql

1.0 2023-08-17 03:36 UTC

Requires

• doctrine/dbal: ^3.0
• laravel/framework: ^8.0

MIT

• hogus

README

insert

use Hogus\Query\GrammarGenerate;

$values = [
    'name' => 'Tom',
    'age' => 12
];

$generate = new GrammarGenerate();
$generate->insert('user', $values)->save('user_insert');
// insert into `user` (`name`, `age`) values ('Tom', '12');

update

$values = [
    'name' => 'Tom',
    'age' => 12
];

$generate->update('user', $values, ['id' => 1]);
// or
$generate->update(DB::table('user')->where('id', 1), $values);
// save to file
$generate->save('user_sql');
// update `link_user` set `name` = 'Tom', `age` = '13' where (`id` = '1');

delete

$generate->delete('user', ['id' => 1]);
// or
$generate->delete(DB::table('user')->where('id', 1));

// save to file
$generate->save('user_sql');
//delete from `link_user` where `id` = '1';

change

$generate->change('user', function ($table) {
    $table->string('name', 50)->change();
    $table->integer('age', 11)->change();
});

//ALTER TABLE user CHANGE name name VARCHAR(50) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_general_ci`, CHANGE age age int(11) DEFAULT '0';

save or dump

# save
$generate->save($filename, $extension = 'sql'); // save to file

# dump
$generate->dump(); // print all sql