from nose.tools import assert_true, assert_false, assert_equal, \
                        assert_list_equal, raises
import datajoint as dj
from . import CONN_INFO
from pymysql.err import OperationalError


class TestSSL:

    @staticmethod
    def test_secure_connection():
        result = dj.conn(**CONN_INFO, reset=True).query(
                "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
        assert_true(len(result) > 0)

    @staticmethod
    def test_insecure_connection():
        result = dj.conn(**CONN_INFO, ssl=False, reset=True).query(
                "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
        assert_equal(result, '')

    @staticmethod
    @raises(OperationalError)
    def test_reject_insecure():
        result = dj.conn(
                CONN_INFO['host'], user='djssl', password='djssl',
                ssl=False, reset=True
                ).query("SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]

from nose.tools import assert_true, assert_false, assert_equal, \
                        assert_list_equal, raises
import datajoint as dj
from . import CONN_INFO
from pymysql.err import OperationalError


class TestSSL:

    # @staticmethod
    # def test_secure_connection():
    #     result = dj.conn(**CONN_INFO, reset=True).query(
    #             "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
    #     assert_true(len(result) > 0)

    @staticmethod
    def test_insecure_connection():
        result = dj.conn(**CONN_INFO, ssl=False, reset=True).query(
                "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
        assert_equal(result, '')

    @staticmethod
    @raises(OperationalError)
    def test_reject_insecure():
        result = dj.conn(
                CONN_INFO['host'], user='djssl', password='djssl',
                ssl=False, reset=True
                ).query("SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]

Disable secure test until new test rig complete.
Disable secure test until new test rig complete.

  from nose.tools import assert_true, assert_false, assert_equal, \
                          assert_list_equal, raises
  import datajoint as dj
  from . import CONN_INFO
  from pymysql.err import OperationalError
  
  
  class TestSSL:
  
-     @staticmethod
+     # @staticmethod
-     def test_secure_connection():
+     # def test_secure_connection():
-         result = dj.conn(**CONN_INFO, reset=True).query(
+     #     result = dj.conn(**CONN_INFO, reset=True).query(
-                 "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
+     #             "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
-         assert_true(len(result) > 0)
+     #     assert_true(len(result) > 0)
  
      @staticmethod
      def test_insecure_connection():
          result = dj.conn(**CONN_INFO, ssl=False, reset=True).query(
                  "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
          assert_equal(result, '')
  
      @staticmethod
      @raises(OperationalError)
      def test_reject_insecure():
          result = dj.conn(
                  CONN_INFO['host'], user='djssl', password='djssl',
                  ssl=False, reset=True
                  ).query("SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
  
Disable secure test until new test rig complete.
## Code Before:
from nose.tools import assert_true, assert_false, assert_equal, \
                        assert_list_equal, raises
import datajoint as dj
from . import CONN_INFO
from pymysql.err import OperationalError


class TestSSL:

    @staticmethod
    def test_secure_connection():
        result = dj.conn(**CONN_INFO, reset=True).query(
                "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
        assert_true(len(result) > 0)

    @staticmethod
    def test_insecure_connection():
        result = dj.conn(**CONN_INFO, ssl=False, reset=True).query(
                "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
        assert_equal(result, '')

    @staticmethod
    @raises(OperationalError)
    def test_reject_insecure():
        result = dj.conn(
                CONN_INFO['host'], user='djssl', password='djssl',
                ssl=False, reset=True
                ).query("SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]

## Instruction:
Disable secure test until new test rig complete.
## Code After:
from nose.tools import assert_true, assert_false, assert_equal, \
                        assert_list_equal, raises
import datajoint as dj
from . import CONN_INFO
from pymysql.err import OperationalError


class TestSSL:

    # @staticmethod
    # def test_secure_connection():
    #     result = dj.conn(**CONN_INFO, reset=True).query(
    #             "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
    #     assert_true(len(result) > 0)

    @staticmethod
    def test_insecure_connection():
        result = dj.conn(**CONN_INFO, ssl=False, reset=True).query(
                "SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
        assert_equal(result, '')

    @staticmethod
    @raises(OperationalError)
    def test_reject_insecure():
        result = dj.conn(
                CONN_INFO['host'], user='djssl', password='djssl',
                ssl=False, reset=True
                ).query("SHOW STATUS LIKE 'Ssl_cipher';").fetchone()[1]
