Support for `TRUNCATE`

[fpringle]

Hi there! Are there any plans to support the TRUNCATE command in Opaleye? At the moment if we want to clear a table we have to do DELETE FROM ... WHERE true (i.e. Delete table (const (toFields True)) rCount), which can be considerably slower for very large tables.

[tomjaguarpaw]

No plans, but I'm willing to take a PR supporting that feature if you're willing to implement it and support it going forward.

[fpringle]

I'd be happy to! Could you point me in the right direction where I should start implementing it? Since truncate is quite a simple command I assume it won't be as complicated as insert or delete etc.

[tomjaguarpaw]

I couldn't tell you off the top of my head, but have a look where delete and insert etc. are defined (Manipulation.hs and work backwards ...).