haf plugin sql publish

The plugin sql publish of haf, now only support mysql

How to get it?

by pip tool

    tsbx-mw# pip install hafsqlpublish

by src

    tsbx-mw# git clone https://github.com/hautof/haf-plugin-sqlpublish ./
    tsbx-mw# python setup.py install

usage

notice

first of all , you must create an new database by the haf-plugin-sqlpublish/haf_publish.sql script file.

using as haf params

    python -m haf run --sql-publish=True --sql-publish-db=192.168.0.101:6606@root:test123@haf_publish

using as haf config

    "sql_publish": {
        "id": 1,
        "sql_name": "upload",
        "publish": true,
        "host": "192.168.1.2",
        "port": 3306,
        "username": "root",
        "password": "test123",
        "database": "haf_publish",
        "protocol": "mysql"
      }

design