#
# Copyright © 2012 Intel Corporation
#
# Permission is hereby granted, free of charge, to any person obtaining a
# copy of this software and associated documentation files (the "Software"),
# to deal in the Software without restriction, including without limitation
# the rights to use, copy, modify, merge, publish, distribute, sublicense,
# and/or sell copies of the Software, and to permit persons to whom the
# Software is furnished to do so, subject to the following conditions:
#
# The above copyright notice and this permission notice (including the next
# paragraph) shall be included in all copies or substantial portions of the
# Software.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.  IN NO EVENT SHALL
# THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
# FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS
# IN THE SOFTWARE.
#
import apsw
import sys
import os.path as path
import xdg.BaseDirectory as xdg

__all__ = ['load']

def load(config):
    '''Load the results database, creating it if it doesn't exist.
    
    Will exit the program if it fails.'''
    try:
        connection = apsw.Connection(config['options']['database'])
        cursor = connection.cursor()

        cursor.execute('''CREATE TABLE IF NOT EXISTS runs
                          (date INTEGER,
                           name TEXT,
                           driver TEXT,
                           sysinfo TEXT)''')
        cursor.execute('''CREATE TABLE IF NOT EXISTS results
                          (run_id INTEGER,
                           test_name TEXT,
                           command TEXT,
                           result TEXT,
                           return_code INTEGER,
                           errors TEXT,
                           output TEXT)''')
        return cursor
    except OSError as e:
        print('error: could not open results database', str(e), '\n')
        sys.exit(0)