Re^2: Setting up database connection in tests

Or don't even bother with the temp file and attach SQLite to the file :memory: for an in-memory database.

Comment on Re^2: Setting up database connection in tests Download Code

Replies are listed 'Best First'.
Re^3: Setting up database connection in tests by tobyink (Canon) on Sep 14, 2012 at 09:00 UTC
Indeed, but that couldn't be used to persist across multiple ".t" files, which was one of the criteria the OP mentioned. Obviously if you're using very advanced SQL features, you may not be able to support SQLite. But if you're almost able to support SQLite already, then it's certainly worth putting in the extra effort to support it fully. The benefits to your test suite will pay back your effort. `perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'`	[reply]

Replies are listed 'Best First'.

Re^3: Setting up database connection in tests
by tobyink (Canon) on Sep 14, 2012 at 09:00 UTC

Indeed, but that couldn't be used to persist across multiple ".t" files, which was one of the criteria the OP mentioned.

Obviously if you're using very advanced SQL features, you may not be able to support SQLite. But if you're almost able to support SQLite already, then it's certainly worth putting in the extra effort to support it fully. The benefits to your test suite will pay back your effort.

perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'

[reply]