# This Source Code Form is subject to the terms of the Mozilla Public
# License, v. 2.0. If a copy of the MPL was not distributed with this
# file, You can obtain one at http://mozilla.org/MPL/2.0/.

from nose.plugins.attrib import attr
from nose.tools import eq_

from socorro.external.postgresql.crash import Crash
from socorro.lib import datetimeutil

from unittestbase import PostgreSQLTestCase


#==============================================================================
@attr(integration='postgres')  # for nosetests
class IntegrationTestCrash(PostgreSQLTestCase):
    """Test socorro.external.postgresql.crash.Crash class. """

    #--------------------------------------------------------------------------
    def setUp(self):
        """Set up this test class by populating the reports table with fake
        data. """
        super(IntegrationTestCrash, self).setUp()

        cursor = self.connection.cursor()

        # Insert data
        self.now = datetimeutil.utc_now()
        uuid = "%%s-%s" % self.now.strftime("%y%m%d")
        signature = 'FakeSignature%s'

        cursor.execute("""
            INSERT INTO reports
            (id, signature, date_processed, uuid, url, email, success, addons_checked,
             exploitability)
            VALUES
            (
                1,
                '%s',
                '%s',
                '%s',
                'http://mywebsite.com',
                'test@something.com',
                TRUE,
                TRUE,
                'interesting'
            ),
            (
                2,
                '%s',
                '%s',
                '%s',
                'http://myotherwebsite.com',
                'admin@example.com',
                NULL,
                FALSE,
                NULL
            ),
            (
                3,
                '%s',
                '%s',
                '%s',
                'http://myotherwebsite.com',
                'admin@example.com',
                TRUE,
                FALSE,
                'medium'
            );
        """ % (
            signature % '1',
            self.now,
            uuid % "a1",
            signature % '2',
            self.now,
            uuid % "a2",
            signature % '3',
            self.now,
            uuid % "b1"
            )
        )

        cursor.execute("""
            INSERT INTO reports_duplicates
            ( uuid, duplicate_of, date_processed)
            VALUES
            (
                '%s',
                'a2',
                '%s'
            );
        """ % (uuid % "a1", self.now))

        self.connection.commit()

    #--------------------------------------------------------------------------
    def test_get(self):
        crash = Crash(config=self.config)
        now = self.now
        uuid = "%%s-%s" % now.strftime("%y%m%d")

        #......................................................................
        # Test 1: a valid crash with duplicates
        params = {
            "uuid": uuid % "a1"
        }
        res = crash.get(**params)
        res_expected = {
            "hits": [
                {
                    "signature" : "FakeSignature1",
                    "email": "test@something.com",
                    "url": "http://mywebsite.com",
                    "addons_checked": True,
                    "exploitability": "interesting",
                    "duplicate_of": "a2"
                }
            ],
            "total": 1
        }

        eq_(res, res_expected)

        #......................................................................
        # Test 2: an invalid crash
        params = {
            "uuid": uuid % "a4"
        }
        res = crash.get(**params)
        res_expected = {
            "hits": [],
            "total": 0
        }

        eq_(res, res_expected)

        #......................................................................
        # Test 3: a valid crash without duplicates
        params = {
            "uuid": uuid % "b1"
        }
        res = crash.get(**params)
        res_expected = {
            "hits": [
                {
                    "signature" : "FakeSignature3",
                    "email": "admin@example.com",
                    "url": "http://myotherwebsite.com",
                    "addons_checked": False,
                    "exploitability": "medium",
                    "duplicate_of": None
                }
            ],
            "total": 1
        }

        eq_(res, res_expected)

    #--------------------------------------------------------------------------
    def tearDown(self):
        """Clean up the database, delete tables and functions. """
        cursor = self.connection.cursor()
        cursor.execute("""
            TRUNCATE reports_duplicates, reports
            CASCADE
        """)
        self.connection.commit()
        super(IntegrationTestCrash, self).tearDown()
