blob: 884afc6dbdfc63b32ae43f04310ea09454ab8c90 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
"""Tests for db/phenotypes.py"""
import json
from unittest import TestCase
from unittest import mock
import pytest
from gn3.db import insert
from gn3.db.metadata_audit import MetadataAudit
class TestMetadatAudit(TestCase):
"""Test cases for fetching chromosomes"""
@pytest.mark.unit_test
def test_insert_into_metadata_audit(self):
"""Test that data is inserted correctly in the audit table
"""
db_mock = mock.MagicMock()
with db_mock.cursor() as cursor:
type(cursor).rowcount = 1
self.assertEqual(insert(
conn=db_mock, table="metadata_audit",
data=MetadataAudit(dataset_id=35,
editor="Bonface",
json_data=json.dumps({"a": "b"}))), 1)
cursor.execute.assert_called_once_with(
"INSERT INTO metadata_audit (dataset_id, "
"editor, json_diff_data) VALUES (%s, %s, %s)",
(35, 'Bonface', '{"a": "b"}'))
|