Contents

# fluent-plugin-sql_fingerprint

[![Build Status](https://travis-ci.org/kikumoto/fluent-plugin-sql_fingerprint.svg?branch=master)](https://travis-ci.org/kikumoto/fluent-plugin-sql_fingerprint)

A Fluent filter plugin to convert sql to sql's fingerprint.

## Requirements

Fluentd >= v0.12

## Install

```shell
gem install fluent-plugin-sql_fingerprint
```

## Configuration Example

```conf
<filter tag.dummy.*>
  type sql_fingerprint
  fingerprint_tool_path /usr/bin/pt-fingerprint
</filter>
```

### sample

record before filter

```
{
  "sql": "SELECT * FROM demo WHERE record = 'AAA';"
}
```

record after filter

```
{
  "sql": "SELECT * FROM demo WHERE record = 'AAA';",
  "fingerprint": "select * from demo where record = ?"
}
```


## Parameters

* fingerprint_tool_path (required)

  Tool path which generates fingerpint. 
  It must input from standard input and output to standard output.
  Ex. pt-fingerprint (see https://www.percona.com/doc/percona-toolkit/2.2/index.html)

* target_key

  The key which was passed to standard input of fingerprint_tool. Default is `sql`.

* added_key

  The key which was added to new record that holds fingerprint generated by fingerpinrt_tool. Default is `fingerprint`.

## Copyright

Copyright (c) 2015 Takahiro Kikumoto. See [LICENSE](LICENSE) for details.

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
fluent-plugin-sql_fingerprint-0.0.1	README.md