Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-3431

Improve database unit tests in the absence of a running server

    XMLWordPrintable

    Details

    • Team:
      Data Access and Database

      Description

      There is a number of packages (daf_ingest, obs_sdss, obs_lsstSim, daf_persistence) that contains unit tests which communicate with a database server. When the usual database server at NCSA is not up, or not reachable, the tests are skipped.

      It should be possible to do something more useful via mocking. For example, it may be possible to record and serialize a passing unit test's database interactions with a live instance, and to play back those interactions via mocks of the DBAPI connection and cursor classes when no live database is available.

        Attachments

          Issue Links

            Activity

            Hide
            frossie Frossie Economou added a comment -

            Jacek Becla - KT suggested I assign this to you for consideration

            Show
            frossie Frossie Economou added a comment - Jacek Becla - KT suggested I assign this to you for consideration
            Hide
            Parejkoj John Parejko added a comment -

            Though I don't know much about this particular database, I have some experience with python mocks in tests, so I'd be happy to help in that regard.

            Show
            Parejkoj John Parejko added a comment - Though I don't know much about this particular database, I have some experience with python mocks in tests, so I'd be happy to help in that regard.
            Hide
            jbecla Jacek Becla added a comment -

            Thanks John, it'll be appreciated . I assigned it to you. Simon Krughoff OK'ed it. Let me know if you need any help / assistance from the Database Team.

            Show
            jbecla Jacek Becla added a comment - Thanks John, it'll be appreciated . I assigned it to you. Simon Krughoff OK'ed it. Let me know if you need any help / assistance from the Database Team.
            Hide
            Parejkoj John Parejko added a comment -

            It looks like I may have some time this month post-All Hands. If this is still needed, does someone want to chat with me about it during the AHM?

            Show
            Parejkoj John Parejko added a comment - It looks like I may have some time this month post-All Hands. If this is still needed, does someone want to chat with me about it during the AHM?
            Hide
            jbecla Jacek Becla added a comment -

            Fritz please coordinate, I added you to the watchers list

            Show
            jbecla Jacek Becla added a comment - Fritz please coordinate, I added you to the watchers list
            Hide
            Parejkoj John Parejko added a comment -

            My spare time to look at this is rapidly running out: if you want me to take a look this month, please speak up!

            Show
            Parejkoj John Parejko added a comment - My spare time to look at this is rapidly running out: if you want me to take a look this month, please speak up!
            Hide
            tjenness Tim Jenness added a comment -

            I think this work was done in DM-13822

            Show
            tjenness Tim Jenness added a comment - I think this work was done in DM-13822

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              smonkewitz Serge Monkewitz
              Watchers:
              Brian Van Klaveren, Fritz Mueller, Frossie Economou, Jacek Becla, John Parejko, Serge Monkewitz, Tim Jenness
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins Builds

                  No builds found.