def __tester_replace_filename():
path = 'c:\\temp\\test_1.txt'
filename = 'test_2.csv'
path_test = u_file.replace_filename(path, filename)
path_true = 'c:\\temp\\test_2.csv'
p0 = path_test == path_true
u_tester.run(p0)
def tester_select_from(self):
q_test = Query()
q_test.Select = 'col_1, col_2'
q_test.From = 'tname'
q_true = 'select col_1, col_2 from tname order by 1'
p0 = str(q_test) == q_true
u_tester.run([p0])
def __tester_factors():
p0 = u_factor.factors(1) == {1}
p1 = u_factor.factors(2) == {1, 2}
p2 = u_factor.factors(3) == {1, 3}
p3 = u_factor.factors(4) == {1, 2, 4}
p4 = u_factor.factors(6) == {1, 2, 3, 6}
u_tester.run(p0, p1, p2, p3, p4)
def __tester_load_stat():
quest = Quest(qid=0,
qtype='SIMPLE',
priority='A',
topics=list(),
question='test',
answer_true='a',
answers_false=['b'])
quest.load_stat(asked=0, answered=0, last_10=str(), last_time=1000)
p0 = quest.grade = 100
quest = Quest(qid=0,
qtype='SIMPLE',
priority='B',
topics=list(),
question='test',
answer_true='a',
answers_false=['b'])
quest.load_stat(asked=0, answered=0, last_10=str(), last_time=1000)
p1 = quest.grade = 90
quest = Quest(qid=0,
qtype='SIMPLE',
priority='C',
topics=list(),
question='test',
answer_true='a',
answers_false=['b'])
quest.load_stat(asked=1000,
answered=1000,
last_10='1111111111',
last_time=0)
p2 = quest.grade = 1
u_tester.run(p0, p1, p2)
def __tester_union():
dict_1 = {'a': 1, 'b': 2}
dict_2 = {'b': 2, 'c': 3}
dict_test = u_dict.union(dict_1, dict_2)
dict_true = {'a': 1, 'b': 2, 'c': 3}
p0 = dict_test == dict_true
u_tester.run(p0)
def __tester_h():
ele_h = gen_tag.h(1)
p0 = str(ele_h) == '<h1>\n</h1>'
ele_text = Element(content='This is Header')
ele_h.nest(ele_text)
p1 = str(ele_h) == '<h1>\n\tThis is Header\n</h1>'
u_tester.run(p0, p1)
def tester_df_to_signature_cols(self):
dict_data = {'col_1': [1, 2], 'col_2': [1, 'a'], 'col_3': [1, 1.2]}
df = pd.DataFrame(dict_data)
signature_cols = Ora.df_to_signature_cols(df)
signature_cols_true = 'col_1 int, col_2 varchar2(100), col_3 float'
p0 = signature_cols == signature_cols_true
u_tester.run(p0)
def __tester_eq():
f1 = Fraction(1, 2)
f2 = Fraction(1, 2)
f3 = Fraction(1, 3)
p0 = f1 == f2
p1 = not f1 == f3
u_tester.run(p0, p1)
def __tester_init():
t = Topic(name='A -> B -> C', priority='ABA', i_row=8)
p0 = t.name == 'A -> B -> C'
p1 = t.priority == 'ABA'
p2 = t.i_row == 8
p3 = t.level == 2
u_tester.run(p0, p1, p2, p3)
def tester_drop(self):
u_ora.create_table_as('temp_u_ora', 'select * from dual')
res_drop = u_ora.drop_table('temp_u_ora')
p0 = True if res_drop else False
res_drop = u_ora.drop_table('temp_u_ora')
p1 = True if not res_drop else False
u_tester.run([p0, p1])
def tester_run(self):
res_0 = u_ora.run('select * from dual')
p0 = True if res_0 else False
res_1 = u_ora.run('xxx')
p1 = True if not res_1 else False
u_tester.run([p0, p1])
def tester_description(self):
res_0 = u_ora.description('dual')
p0 = True if res_0 else False
res_1 = u_ora.description('table_not_exist')
p1 = True if not res_1 else False
u_tester.run([p0, p1])
def tester_close(self):
ora = Ora()
ora.open()
res = ora.close()
p0 = True if res else False
u_tester.run(p0)
def __tester_to_str():
dt = datetime.datetime(year=2020, month=9, day=15, hour=23, minute=59,
second=2)
str_test = u_datetime.to_str(dt)
str_true = '20200915235902'
p0 = str_test == str_true
u_tester.run(p0)
def __tester_normalize():
f1 = Fraction(1, 2)
f2 = Fraction(1, 3)
f3, f4 = Fraction.normalize(f1, f2)
p0 = f3 == Fraction(3, 6)
p1 = f4 == Fraction(2, 6)
u_tester.run(p0, p1)
def tester_to_key_value_str(self):
dic = {'a': 1, 'b': 2}
str_test = u_dict.to_key_value_str(dic)
str_true = 'a="1", b="2"'
p0 = str_test == str_true
p1 = u_dict.to_key_value_str(dict()) == str()
u_tester.run(p0, p1)
def tester_select(self):
import pandas as pd
res = u_ora.select('dual')
df_true = pd.DataFrame.from_dict({'DUMMY': ['X']})
p0 = res.val.equals(df_true)
res = u_ora.select('select * from table not exist')
p1 = True if not res else False
u_tester.run([p0, p1])
def tester_orderby(self):
q_test = Query()
q_test.Select = 'col'
q_test.From = 'tname'
q_test.Orderby = 'col'
q_true = 'select col from tname order by col'
p0 = str(q_test) == q_true
u_tester.run([p0])
def tester_having(self):
q_test = Query()
q_test.Select = 'col_1, max(col_2)'
q_test.From = 'tname'
q_test.Having = 'max(col_2)>=1'
q_true = 'select col_1, max(col_2) from tname group by col_1 having max(col_2)>=1 order by 1'
p0 = str(q_test) == q_true
u_tester.run([p0])
def tester_get_empty_cols(self):
tname = 'temp_tester_get_empty_cols'
query = 'select dummy as col_1, cast(null as int) as col_2 from dual'
u_ora.create_table_as(tname, query)
empty_cols_test = u_ora.get_empty_cols(tname)
empty_cols_true = {'col_2'}
p0 = empty_cols_test == empty_cols_true
u_tester.run([p0])
def __tester_is_proper():
f0 = Fraction(1, 2)
p0 = f0.is_proper()
f1 = Fraction(1, 1)
p1 = not f1.is_proper()
f2 = Fraction(2, 1)
p2 = not f2.is_proper()
u_tester.run(p0, p1, p2)
def tester_val(self):
res = Res(1)
p0 = res.val == 1
res = Res('Error', False)
p1 = res.val is None
u_tester.run([p0, p1])
def tester_empty(self):
res = Res()
p0 = True if res else False
res = Res('Error', False)
p1 = True if not res else False
u_tester.run([p0, p1])
def tester_bool(self):
res = Res(1, True)
p0 = True if res else False
res = Res('Error', False)
p1 = True if not res else False
u_tester.run([p0, p1])
def __tester_load_and_select():
df_true = pd.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6]})
sql = Sqlite()
sql.load(df=df_true, tname='temp_1')
df_test = sql.select(query='temp_1')
sql.close()
p0 = df_test.equals(df_true)
u_tester.run(p0)
def __tester_decimal_point():
d = Decimal(1)
p0 = d.decimal_point() == 1
d = Decimal(1.1)
p1 = d.decimal_point() == 1
d = Decimal(1.23)
p2 = d.decimal_point() == 2
u_tester.run(p0, p1, p2)
def tester_where(self):
q_test = Query()
q_test.Select = 'col_1'
q_test.From = 'tname'
q_test.Where = 'col_2=col_3'
q_true = 'select col_1 from tname where col_2=col_3 order by 1'
p0 = str(q_test) == q_true
u_tester.run([p0])
def __tester_add():
d1, d2 = Decimal(1), Decimal(2)
p0 = d1 + d2 == 3.0
d1, d2 = Decimal(1.2), Decimal(3.4)
p1 = d1 + d2 == 4.6
d1, d2 = Decimal(1.2), Decimal(3.45)
p2 = d1 + d2 == 4.65
u_tester.run(p0, p1, p2)
def __tester_sublist_by_index():
# Simple Test
li = ['a', 'b', 'c']
indices = [0, 2]
li_test = u_list.sublist_by_index(li, indices)
li_true = ['a', 'c']
p0 = li_test == li_true
u_tester.run(p0)
def __tester_ctas():
df = pd.DataFrame({'a': [1, 2, 3]})
sql = Sqlite()
sql.load(df=df, tname='temp_1')
sql.ctas(tname='temp_2', query='select sum(a) as a from temp_1')
df_test = sql.select(query='temp_2')
df_true = pd.DataFrame({'a': [6]})
p0 = df_test.equals(df_true)
u_tester.run(p0)
