# erl_sql_compare

**Repository Path**: zhuiyi9009/erl_sql_compare

## Basic Information

- **Project Name**: erl_sql_compare
- **Description**: mysql struct compare tool by erlang
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-07-06
- **Last Updated**: 2024-07-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# sql对比工具

## 使用条件
- 由于使用了maybe表达式, 需要OTP25或以上

## 入口
`erl_sql_compare:start/3`

## 支持输入源
- 文件
`"file:sql/source.sql"`
- mysql
`"mysql:root:root@127.0.0.1:3306/test_1?encoding=utf8"`

## 示例
`erl_sql_compare_test.erl`
```
1. erl_sql_compare:start("file:sql/source.sql", "file:sql/dest.sql", [{output, "sql/diff.sql"}]).

2. erl_sql_compare:start("mysql:root:root@127.0.0.1:3306/test_1?encoding=utf8", "mysql:root:root@127.0.0.1:3306/test_2?encoding=utf8", [{output, mysql}]).
```

## 快速使用
1. `escript rebar compile`
2. `escript compare.erl file:sql/source.sql file:dest.sql`
3. `escript compare.erl mysql:root:root@127.0.0.1:3306/test_1?encoding=utf8 mysql:root:root@127.0.0.1:3306/test_2?encoding=utf8 mysql`

## 测试环境
1. `OTP25`
2. `mysql 5.7`