# ![TempusSQL](https://raw.githubusercontent.com/am-kantox/tempus_sql/master/stuff/tempus_sql-48x48.png) TempusSQL    [![Kantox ❤ OSS](https://img.shields.io/badge/❤-kantox_oss-informational.svg)](https://kantox.com/)  ![Test](https://github.com/am-kantox/tempus_sql/workflows/Test/badge.svg)  ![Dialyzer](https://github.com/am-kantox/tempus_sql/workflows/Dialyzer/badge.svg)

**Ecto/SQL backend to use with `Tempus` library**

## Installation

```elixir
def deps do
  [
    {:tempus_sql, "~> 1.0"}
  ]
end
```

## Setup & Migrations

- For new installations:
  ```sh
  $ mix tempus.gen.postgres.tempus_slot
  ```
- For upgrading existing databases to 1.0 (adds `from_open` and `to_open` attributes):
  ```sh
  $ mix tempus.gen.postgres.update_tempus_slot
  ```

See [MIGRATION.md](MIGRATION.md) for detailed migration instructions.

## Changelog
- **`1.0.0-rc.0`** — Support for half-open boundaries and boundary flags (`from_open`/`to_open`) in `Tempus.Slot`, 4-tuple Postgres composite type, `slot_from_open`/`slot_to_open` query helpers, and automated migration task.
- **`0.10.0`** — version numbers correspond to `Tempus` itself
- **`0.1.0`** — initial version, `Tempus.Ecto.Query.API.started_after/2`

## [Documentation](https://hexdocs.pm/tempus_sql)