SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: DB test schemas

  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2002
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DB test schemas

    I need to test a db abstraction class that supports mysql,mysqli,oracle,mssql and sqlite. Essentially, I am looking for a table schema I can adapt to these dbs that employs many datatypes and the queries to test these. I have googled and could not find a test suite that fits this. I realize that I may have to "roll my own", but would at least ask here before I started in case someone else has written or used something similar.

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't know of one schema in several varieties, as you suggest.

    There are however some standard test applications, such as the Java Pet Store sample, which define schemas for Oracle and MSSQL, at least.

    And so does the .NET sample, Fitch & Mathers I believe you can get that from MSDN.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •