[DBIx-Class-Devel] SQL::Statement-based driver support

[Brendan Byrd]

On Tue, Mar 19, 2013 at 9:05 AM, Peter Rabbitson <rabbit+dbic at rabbit.us>wro=
te:

> On Tue, Mar 19, 2013 at 08:35:51AM -0400, Brendan Byrd wrote:
> >
> > What about static files?  You want me to just put the SQL file in maint=
/?
>
> What sort of static files? (give me an example, then I can answer
> properly) The thing above needs to be kept in sync with the
> DBICTest::Schema:: tree, hence why I much much rather have SQLT generate
> it.


The Schema-SQL-Statement file (in test_deploy) is static.  It started out
as a SQLite file, and then I removed:

* Default values (no S:S syntax support)
* Foreign keys and references (no S:S syntax support)
* A few table removals involving the testing of field types that S:S/CSV
doesn't support
* Removal of a single-column table (DBD::DBM doesn't support this)

Yeah, I know; there's a lot of exceptions and crippled support here and
there.  But, based on the things you can do in the test file, there's still
plenty of stuff that works.

I suppose I could auto-create the file as SQLite and remove these things
automatically in the maint/ script.  That'll keep the *.sql file up-to-date
with the DBICTest Schema.

-- =

Brendan Byrd <Perl at ResonatorSoft.org>
Brendan Byrd <BBYRD at CPAN.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/201303=
19/28f891bd/attachment.htm