Слияние кода завершено, страница обновится автоматически
goInception extension of the usage of Inception, to specify the remote server by adding annotations before the SQL review, and for distinguishing SQL and review adding special comments at the beginning and the end of SQL.
/*--user=root;--password=root;--host=127.0.0.1;--check=1;--port=3306;*/
inception_magic_start;
use test;
create table t1(id int primary key);
inception_magic_commit;
| Command | Default | Type | Explanation |
|---|---|---|---|
| host | "" | string | DB Server host |
| port | 0 | int | DB Service port |
| user | "" | string | User name to connect to DB |
| password | "" | string | password to connect to DB |
db v1.1.0
|
mysql | string | Default connection DB, optional,can null. |
| check | FALSE | bool | Review only |
| execute | FALSE | bool | Execute SQL |
| backup | FALSE | bool | Backup when execute |
| ignore_warnings | FALSE | bool | If stop execute when warning or not. |
trans v1.1.6
|
0 | int | How many DML operations can be included in each transaction. >1 means turn on transaction. |
fingerprint v0.6.2
|
FALSE | bool | SQL fingerprint for similar DML. reuses the explanation, decreases explain operations, speed review. |
masking v1.2.5
|
FALSE | bool | The new version of print SQL syntax tree, return JSON format result。More |
query-print v0.7.1
|
FALSE | bool | Print the SQL syntax map |
split v0.9.1
|
FALSE | bool | Split DDL and DML on the same table. But other option unavailable such as review, execute,backup,print sql syntax map. Normally, no need to split, GoInception records table structure snapshot which can be used for binlog translation. |
sleep v1.0-rc3
|
0 | int | For decrease the impact to DB service, set sleep time by sleep_rows. Default 0 millisecond, max value is 100000 millisecond, equally 100 second. |
sleep_rows v1.0-rc3
|
1 | int | Sleep after how many SQL execute. Default 1. |
real_row_count v1.0.3
|
FALSE | bool | If get real DML effect rows by count(*), default false, if ture, ignore fingerprintSQL, accurately first. |
| Key | Default | Type | Explanation |
|---|---|---|---|
| ssl | DISABLED | string | Ssl-mode same as mysql --ssl-mode |
| ssl-ca | string | CA file path, PEM format | |
| ssl-cert | string | SSL public key file path, PEM format | |
| ssl-key | string | SSL private key file path, PEM format |
| type | description |
|---|---|
| DISABLED(default) | Disable TLS |
| PREFERRED | TLS when server publishing use. |
| REQUIRED | Use TLS, but do not check CA |
| VERIFY_CA | Identify CA, but ignore hostname mismatch |
| VERIFY_IDENTITY | Identify CA |
# use ssl=verify_ca setting CA identify
# need to put the CA with goInception service on the same server
sql = '''/*--user=test;--password=xxx;--host=127.0.0.1;--port=3333;--check=1;\
--ignore-warnings=1;--ssl=verify_ca;\
--ssl-ca=/data/mysql/data/ca.pem;\
--ssl-cert=/data/mysql/data/client-cert.pem;\
--ssl-key=/data/mysql/data/client-key.pem;*/
inception_magic_start;
use test_inc;
...
inception_magic_commit;
sql = '''/*--user=test;--password=xxx;--host=127.0.0.1;--port=3333;--check=1;\
--ignore-warnings=1;--ssl=required;*/
inception_magic_start;
use test_inc;
...
inception_magic_commit;'''
Вы можете оставить комментарий после Вход в систему
Неприемлемый контент может быть отображен здесь и не будет показан на странице. Вы можете проверить и изменить его с помощью соответствующей функции редактирования.
Если вы подтверждаете, что содержание не содержит непристойной лексики/перенаправления на рекламу/насилия/вульгарной порнографии/нарушений/пиратства/ложного/незначительного или незаконного контента, связанного с национальными законами и предписаниями, вы можете нажать «Отправить» для подачи апелляции, и мы обработаем ее как можно скорее.
![dependabot[bot]](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAAXNSR0IArs4c6QAAAARzQklUCAgICHwIZIgAAAKSSURBVGhD7Zi/TxRBFMe/i3cgIAl3DRhUTDwT0EaIQU2kIRAbCog2mqidxo5YSrw/gBhNLCzQjlBYqGBhooCRQizEO1vx14kU3g8SjjOs3N6dzozcQQSTIdnldmbflJuX7Hy+3zfz3jzj/vlnv+GhZRCw5m6Tw5obDHKYHNZMAUppzQzdhEMOk8OaKUAprZmhdGlRSlNKa6aAIyldWePDpQc9W0qVtwqwzByyKzlkkiYWY2kkPi1hPppEIVdwXN4dB/4f0epPC3PTC4g8+gjrV94xcNcAFwm56y/vRpH8nHYE2nFgM53F6LWp9c0bgH+3D1W1fgQP1KGxJYDDp5tQXV9ViuFuj4dnsPxjxXbonQfeAsHYZaC9P4RjfYdgVDBF2FqMLePJjdd6Ahepjp5pxqnLR0qQL269w3wkYSu0KxzeSNR78wQaW4Pi07fZOCZuR/QGbj7egJ7r7QKSn+WRK5N6A1fWsho+zGr436OMhwPTyCTsu7xcl9Ic8sK9LtSs3dpPw29EY2LXciXw2aFOBPbtEYzPh2bx/X3SLl5nBvEbW8tNdVhi6+cYcL2XgD2V0rwDuzjc7Z1L62BHA7oH1spShpWlq5qXpd7wSdFf8xV7G8fkHY0bj39bS7tvaC6iK8oSfzy09YXQ1r/+eEh9TWNscEbiTt9eSFmA/dX8eehDYH8d9rYEEepsKjUaoqVkZ1c8D+P2dVhFWRwH3p7+YG2kiSk2AEh9UXQAIAvMHwofXi0g+lizEQ8f1FlmHlnTEm6m2BAvPrck2kdlh3iyrpYjzpEzXA4Q2X8SsKxSqsaRw6o6J7tvclhWKVXjyGFVnZPdNzksq5SqceSwqs7J7pscllVK1ThyWFXnZPftOYf/AOGev+g28wRIAAAAAElFTkSuQmCC)
Комментарий ( 0 )