TODO
====
- [ ] Setup automated testing for these changes
- [ ] Offer upstream to petoju repo
- [ ] Optionally build in lookups to see if current allocation is within
limits of total predicted cluster capacity
```
mysql> CALIBRATE RESOURCE START_TIME '2024-07-09 19:10:21' DURATION '30m';
+--------+
| QUOTA  |
+--------+
| 160194 |
+--------+
1 row in set (0.24 sec)

That's approx NOW() - DURATION

```

---------

Co-authored-by: Andrew Chen <andrewchen@plaid.com>

…rce_group_assignment` (#5)

[This
article](https://www.hashicorp.com/blog/writing-custom-terraform-providers)
provides a good initial explanation of the expected behaviors of the
different CRUD methods for a resource.

In it, it mentions that the `Read` method should be able to gracefully
handle when the resource no longer exists (probably due to manual
deletion).

I also fixed a bug where `resourceGroup` was supposed to be
`resource_group` and also modified `petoju` --> `zph` in certain places.
This makes error logs a bit more clear.

---------

Co-authored-by: Andrew Chen <andrewchen@plaid.com>

This fixes the following drift:
1. Resource group name would always be in quotes when pulled from the
DB. This PR removes the quotes.
2. Query Limit would always be missing `()` parentheses when pulled from
the DB. This PR standardizes around the query_limit inside the
parentheses. A breaking change is that we expect NO parenthesis to be
passed in for the query_limit from now on. Instead, we will wrap the
query_limit inside parentheses in the actual query rather than rely on
the query_limit string being wrapped in parentheses by the caller.

I also got basic tidb tests working and tested the above changes using
`make testtidb7.5.1`

---------

Co-authored-by: Andrew Chen <andrewchen@plaid.com>
Co-authored-by: Zander Hill <zander@xargs.io>

Supports creating a placement policy and adding it to a database:

```
resource "mysql_ti_placement_policy" "test" {
    name = "%s"
    primary_region = "%s"
    regions = %s
    constraints = %s
}

resource "mysql_database" "test" {
    name = "%s"
    default_character_set = "%s"
    default_collation = "%s"
    placement_policy = mysql_ti_placement_policy.test.name
}
```

---------

Co-authored-by: Andrew Chen <andrewchen@plaid.com>
Co-authored-by: Zander Hill <zander@xargs.io>