# -*- coding: utf-8 -*-

"""
Test script for Jamcha SQLite
"""

# This code is a part of jamdict library: https://github.com/neocl/jamdict
# :copyright: (c) 2016 <NAME> <<EMAIL>>
# :license: MIT, see LICENSE for more details.

import os
import unittest
import logging

from jamdict import KanjiDic2SQLite
from jamdict import KanjiDic2XML


# -------------------------------------------------------------------------------
# Configuration
# -------------------------------------------------------------------------------

TEST_DIR = os.path.dirname(os.path.realpath(__file__))
TEST_DATA = os.path.join(TEST_DIR, 'data')
if not os.path.isdir(TEST_DATA):
    os.makedirs(TEST_DATA)
TEST_DB = os.path.join(TEST_DATA, 'jamcha.db')
MINI_KD2 = os.path.join(TEST_DATA, 'kanjidic2_mini.xml')


def getLogger():
    return logging.getLogger(__name__)


# -------------------------------------------------------------------------------
# Test cases
# -------------------------------------------------------------------------------

class TestJamdictSQLite(unittest.TestCase):

    db = KanjiDic2SQLite(TEST_DB)
    ramdb = KanjiDic2SQLite(":memory:", auto_expand_path=False)
    xdb = KanjiDic2XML.from_file(MINI_KD2)

    @classmethod
    def setUpClass(cls):
        if os.path.isfile(TEST_DB):
            getLogger().info("Removing previous database file at {}".format(TEST_DB))
            os.unlink(TEST_DB)

    def test_xml2sqlite(self):
        print("Test KanjiDic2 - XML to SQLite DB in RAM")
        getLogger().info("Testing using {} test characters".format(len(self.xdb)))
        db = self.ramdb
        with db.ctx() as ctx:
            fv = self.xdb.kd2.file_version
            dv = self.xdb.kd2.database_version
            doc = self.xdb.kd2.date_of_creation
            db.update_kd2_meta(fv, dv, doc, ctx)
            metas = ctx.meta.select()
            getLogger().debug("KanjiDic2 meta: {}".format(metas))
            for c in self.xdb:
                db.insert_char(c, ctx)
                c2 = db.char_by_id(c.ID, ctx)
                getLogger().debug("c-xml", c.to_dict())
                getLogger().debug("c-sqlite", c2.to_dict())
                with self.assertWarns(DeprecationWarning):
                    self.assertEqual(c.to_json(), c2.to_dict())
            # test searching
            # by id
            c = ctx.char.select_single()
            c = db.char_by_id(c.ID, ctx=ctx)
            self.assertIsNotNone(c)
            self.assertTrue(c.rm_groups[0].readings)
            self.assertTrue(c.rm_groups[0].meanings)
            # by literal
            c = db.get_char('持', ctx=ctx)
            self.assertEqual(c.literal, '持')
            self.assertTrue(c.rm_groups[0].readings)
            self.assertTrue(c.rm_groups[0].meanings)

    def test_reading_order(self):
        db = self.ramdb
        with db.ctx() as ctx:
            fv = self.xdb.kd2.file_version
            dv = self.xdb.kd2.database_version
            doc = self.xdb.kd2.date_of_creation
            db.update_kd2_meta(fv, dv, doc, ctx)
            metas = ctx.meta.select()
            getLogger().debug("KanjiDic2 meta: {}".format(metas))
            for c in self.xdb:
                db.insert_char(c, ctx)
            c = db.get_char('持', ctx=ctx)
            rmg = c.rm_groups[0]
            self.assertEqual(["ジ"], [x.value for x in rmg.on_readings])
            self.assertEqual(['も.つ', '-も.ち', 'も.てる'], [k.value for k in rmg.kun_readings])
            self.assertEqual([('chi2', 'pinyin'), ('ji', 'korean_r'), ('지', 'korean_h'), ('Trì', 'vietnam')],
                             [(x.value, x.r_type) for x in rmg.other_readings])
            expected = [{'type': 'ja_on', 'value': 'ジ', 'on_type': '', 'r_status': ''},
                        {'type': 'ja_kun', 'value': 'も.つ', 'on_type': '', 'r_status': ''},
                        {'type': 'ja_kun', 'value': '-も.ち', 'on_type': '', 'r_status': ''},
                        {'type': 'ja_kun', 'value': 'も.てる', 'on_type': '', 'r_status': ''},
                        {'type': 'pinyin', 'value': 'chi2', 'on_type': '', 'r_status': ''},
                        {'type': 'korean_r', 'value': 'ji', 'on_type': '', 'r_status': ''},
                        {'type': 'korean_h', 'value': '지', 'on_type': '', 'r_status': ''},
                        {'type': 'vietnam', 'value': 'Trì', 'on_type': '', 'r_status': ''}]
            actual = c.rm_groups[0].to_dict()['readings']
            self.assertEqual(expected, actual)


# -------------------------------------------------------------------------------
# Main
# -------------------------------------------------------------------------------

if __name__ == "__main__":
    unittest.main()

# -*- coding: utf-8 -*-

"""
Test script for Jamcha SQLite
"""

# This code is a part of jamdict library: https://github.com/neocl/jamdict
# :copyright: (c) 2016 <NAME> <<EMAIL>>
# :license: MIT, see LICENSE for more details.

import os
import unittest
import logging

from jamdict import KanjiDic2SQLite
from jamdict import KanjiDic2XML


# -------------------------------------------------------------------------------
# Configuration
# -------------------------------------------------------------------------------

TEST_DIR = os.path.dirname(os.path.realpath(__file__))
TEST_DATA = os.path.join(TEST_DIR, 'data')
if not os.path.isdir(TEST_DATA):
    os.makedirs(TEST_DATA)
TEST_DB = os.path.join(TEST_DATA, 'jamcha.db')
MINI_KD2 = os.path.join(TEST_DATA, 'kanjidic2_mini.xml')


def getLogger():
    return logging.getLogger(__name__)


# -------------------------------------------------------------------------------
# Test cases
# -------------------------------------------------------------------------------

class TestJamdictSQLite(unittest.TestCase):

    db = KanjiDic2SQLite(TEST_DB)
    ramdb = KanjiDic2SQLite(":memory:", auto_expand_path=False)
    xdb = KanjiDic2XML.from_file(MINI_KD2)

    @classmethod
    def setUpClass(cls):
        if os.path.isfile(TEST_DB):
            getLogger().info("Removing previous database file at {}".format(TEST_DB))
            os.unlink(TEST_DB)

    def test_xml2sqlite(self):
        print("Test KanjiDic2 - XML to SQLite DB in RAM")
        getLogger().info("Testing using {} test characters".format(len(self.xdb)))
        db = self.ramdb
        with db.ctx() as ctx:
            fv = self.xdb.kd2.file_version
            dv = self.xdb.kd2.database_version
            doc = self.xdb.kd2.date_of_creation
            db.update_kd2_meta(fv, dv, doc, ctx)
            metas = ctx.meta.select()
            getLogger().debug("KanjiDic2 meta: {}".format(metas))
            for c in self.xdb:
                db.insert_char(c, ctx)
                c2 = db.char_by_id(c.ID, ctx)
                getLogger().debug("c-xml", c.to_dict())
                getLogger().debug("c-sqlite", c2.to_dict())
                with self.assertWarns(DeprecationWarning):
                    self.assertEqual(c.to_json(), c2.to_dict())
            # test searching
            # by id
            c = ctx.char.select_single()
            c = db.char_by_id(c.ID, ctx=ctx)
            self.assertIsNotNone(c)
            self.assertTrue(c.rm_groups[0].readings)
            self.assertTrue(c.rm_groups[0].meanings)
            # by literal
            c = db.get_char('持', ctx=ctx)
            self.assertEqual(c.literal, '持')
            self.assertTrue(c.rm_groups[0].readings)
            self.assertTrue(c.rm_groups[0].meanings)

    def test_reading_order(self):
        db = self.ramdb
        with db.ctx() as ctx:
            fv = self.xdb.kd2.file_version
            dv = self.xdb.kd2.database_version
            doc = self.xdb.kd2.date_of_creation
            db.update_kd2_meta(fv, dv, doc, ctx)
            metas = ctx.meta.select()
            getLogger().debug("KanjiDic2 meta: {}".format(metas))
            for c in self.xdb:
                db.insert_char(c, ctx)
            c = db.get_char('持', ctx=ctx)
            rmg = c.rm_groups[0]
            self.assertEqual(["ジ"], [x.value for x in rmg.on_readings])
            self.assertEqual(['も.つ', '-も.ち', 'も.てる'], [k.value for k in rmg.kun_readings])
            self.assertEqual([('chi2', 'pinyin'), ('ji', 'korean_r'), ('지', 'korean_h'), ('Trì', 'vietnam')],
                             [(x.value, x.r_type) for x in rmg.other_readings])
            expected = [{'type': 'ja_on', 'value': 'ジ', 'on_type': '', 'r_status': ''},
                        {'type': 'ja_kun', 'value': 'も.つ', 'on_type': '', 'r_status': ''},
                        {'type': 'ja_kun', 'value': '-も.ち', 'on_type': '', 'r_status': ''},
                        {'type': 'ja_kun', 'value': 'も.てる', 'on_type': '', 'r_status': ''},
                        {'type': 'pinyin', 'value': 'chi2', 'on_type': '', 'r_status': ''},
                        {'type': 'korean_r', 'value': 'ji', 'on_type': '', 'r_status': ''},
                        {'type': 'korean_h', 'value': '지', 'on_type': '', 'r_status': ''},
                        {'type': 'vietnam', 'value': 'Trì', 'on_type': '', 'r_status': ''}]
            actual = c.rm_groups[0].to_dict()['readings']
            self.assertEqual(expected, actual)


# -------------------------------------------------------------------------------
# Main
# -------------------------------------------------------------------------------

if __name__ == "__main__":
    unittest.main()

# -*- coding: utf-8 -*- Test script for Jamcha SQLite # This code is a part of jamdict library: https://github.com/neocl/jamdict # :copyright: (c) 2016 <NAME> <<EMAIL>> # :license: MIT, see LICENSE for more details. # ------------------------------------------------------------------------------- # Configuration # ------------------------------------------------------------------------------- # ------------------------------------------------------------------------------- # Test cases # ------------------------------------------------------------------------------- # test searching # by id # by literal # ------------------------------------------------------------------------------- # Main # -------------------------------------------------------------------------------