[Bug 658464] New: insanityweb: sane defaults/fall back gracefully if database does not exist/is not writable

[GStreamer (bugzilla.gnome.org)]

https://bugzilla.gnome.org/show_bug.cgi?id=658464
  GStreamer | gst-qa-system | unspecified

           Summary: insanityweb: sane defaults/fall back gracefully if
                    database does not exist/is not writable
    Classification: Platform
           Product: GStreamer
           Version: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: Normal
         Component: gst-qa-system
        AssignedTo: gstreamer-bugs at lists.freedesktop.org
        ReportedBy: alsuren at gmail.com
         QAContact: gstreamer-bugs at lists.freedesktop.org
                CC: senko at senko.net
     GNOME version: ---


The current default location for the sqlite backend in settings.py is
os.path.abspath(os.path.dirname(__file__))/../testrun.db

In the default setup, this is /usr/[local/]share/insanity/testrun.db, which is
unlikely to be writable. Would it make sense to fall back to
$HOME/.local/share/insanity/testrun.db if this is the case? (possibly with some
loud debugging for the perpetually confused)

Also, if the database is empty, we should probably try to fix it at startup,
rather than causing "Caught DatabaseError while rendering: no such table:
testrun" on page load.

-- 
Configure bugmail: https://bugzilla.gnome.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.