1from __future__ import print_function 

2from builtins import str 

3import os 

4import unittest 

5import shutil 

6import unittest 

7import yaml 

8from fundamentals.utKit import utKit 

9from fundamentals import tools 

10from os.path import expanduser 

11home = expanduser("~") 

12 

13packageDirectory = utKit("").get_project_root() 

14settingsFile = packageDirectory + "/test_settings.yaml" 

15# settingsFile = home + "/.config/soxspipe.recipes/soxspipe.recipes.yaml" 

16su = tools( 

17 arguments={"settingsFile": settingsFile}, 

18 docString=__doc__, 

19 logLevel="DEBUG", 

20 options_first=False, 

21 projectName=None, 

22 defaultSettingsFile=False 

23) 

24arguments, settings, log, dbConn = su.setup() 

25 

26# SETUP AND TEARDOWN FIXTURE FUNCTIONS FOR THE ENTIRE MODULE 

27moduleDirectory = os.path.dirname(__file__) 

28utKit = utKit(moduleDirectory) 

29log, dbConn, pathToInputDir, pathToOutputDir = utKit.setupModule() 

30utKit.tearDownModule() 

31 

32try: 

33 shutil.rmtree(pathToOutputDir) 

34except: 

35 pass 

36# COPY INPUT TO OUTPUT DIR 

37shutil.copytree(pathToInputDir, pathToOutputDir) 

38 

39# Recursively create missing directories 

40if not os.path.exists(pathToOutputDir): 

41 os.makedirs(pathToOutputDir) 

42 

43# xt-setup-unit-testing-files-and-folders 

44 

45pathToSqlite = pathToInputDir + "/test.sqlite" 

46 

47class test_sqlite2mysql(unittest.TestCase): 

48 

49 def test_sqlite2mysql_function(self): 

50 

51 from fundamentals.mysql import sqlite2mysql 

52 this = sqlite2mysql( 

53 log=log, 

54 settings=settings, 

55 pathToSqlite=pathToSqlite, 

56 tablePrefix="Marvin", 

57 dbConn=dbConn 

58 ) 

59 this.convert_sqlite_to_mysql() 

60 

61 def test_sqlite2mysql_function_exception(self): 

62 

63 from fundamentals.mysql import sqlite2mysql 

64 try: 

65 this = sqlite2mysql( 

66 log=log, 

67 settings=settings, 

68 pathToSqlite=pathToSqlite, 

69 fakeKey="break the code" 

70 ) 

71 this.get() 

72 assert False 

73 except Exception as e: 

74 assert True 

75 # print(str(e)) 

76 

77 # x-print-testpage-for-pessto-marshall-web-object 

78 

79 # x-class-to-test-named-worker-function