sqlify 0.1.0

A simple CLI tool for formatting SQL queries.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

# sqlify

A CLI tool to format your SQL code.

## Features

This tool utilizes [sqlformat](https://github.com/shssoichiro/sqlformat-rs)
under the hood to format the given SQL code.

## Installation

To install `sqlify` simply run the `cargo install` command:

```sh
cargo install sqlify
```

## Usage

To use it simply pass in your SQL as the argument, or pipe it from a file, like this:

```sh
sqlify "SELECT * FROM tablename"

# or

cat query.sql | sqlify

# or

sqlify < query.sql
```

where `query.sql` looks like

```sql
SELECT * FROM tablename
```

to get the following output:

```sql
SELECT
  *
FROM
  tablename
```

There are fomrating options from [sqlformat](https://docs.rs/sqlformat/latest/sqlformat/struct.FormatOptions.html)
exposed through arguments:

- `-u` or `--uppercase` to denote the use of uppercase keywords
- `-t` or `--tabs` to denote the use of tabs
- `-i` or `--indent` to specify the number of spaces to use for indentation
  (defaults to 2), ignored if tabs are used
- `-l` or `--lines-between-queries` to specify the number of line breaks
  to use between queries (defaults to 1)