Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^4: SQL configurations in automated testing

by skazat (Hermit)
on Nov 21, 2007 at 22:38 UTC ( #652269=note: print w/replies, xml ) Need Help??

in reply to Re^3: SQL configurations in automated testing
in thread SQL configurations in automated testing

I see.

That's quite interesting.

For this project at least, it doesn't seem to be quite a good fit.

But, it still looks like there's no one quite to run the test suite on a server you're installing on. I'm thinking of weird dragons and discrepancies between the environment of the server I'm developing on and the (thousands) of different servers that may well have it installed on. That still doesn't seem to be a problem DBIx::Class solves (or advertises, I don't think)


-justin simoni
skazat me

  • Comment on Re^4: SQL configurations in automated testing

Replies are listed 'Best First'.
Re^5: SQL configurations in automated testing
by aquarium (Curate) on Nov 22, 2007 at 04:18 UTC
    you're quite right in that even the same operation can work quite differently on the same db engine but on different architecture. the db engine vendors do try to make things as portable but they're never 100%.
    on a side note in regards to different db engines, it's interesting to see some not so minor SQL standard implementations by the different vendors. some of this is documented in Joe Celko's book "SQL for Smarties"
    in terms of further developing your test suite...maybe it could be made more black box like by having a config. As for checking whether a db engine exists on a machine or such, you could run basic sanity check before running tests proper. The sanity check typically written in "eval" style defensive coding to connect to db etc.
    or maybe i'm missing the point entirely?
    the hardest line to type correctly is: stty erase ^H

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://652269]
[perldigious]: A question since I'm ignorant of what's normal for database management... Do admins change column names a lot in databases?
[perldigious]: On occasion my scripts break, because they will do something that seems laregly pointless to me... like in this case, changing a column name from "ABC Category" to "ABC Category Override".
[perldigious]: Being the ignorant one, my initial reaction to that is, "that's sort of a dick move, a lot of people like me expect column names like that to stay the same, why the hell would you change them like that for seemingly no good reason?"
[perldigious]: Or is my irritation/ frustration well founded?

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2017-05-25 13:29 GMT
Find Nodes?
    Voting Booth?