def _add_db_record():
M.add_local('fake', 'fake_name', 'fake_st', 'fake_quantity',
'fake_received')
S.fake = faker.Faker()
S.fake.seed(S.seed)
S.fake_name = S.fake.name()
S.fake_st = S.fake.state_abbr()
S.fake_quantity = S.fake.random_int(0, 100)
S.fake_received = S.fake.boolean()
DB.insert('report',
(S.fake_name, S.fake_st, S.fake_quantity, S.fake_received))
def _sqlexec_add_record():
M.add_local('fake', 'fake_name', 'fake_st', 'fake_quantity',
'fake_received')
S.fake = faker.Faker()
S.fake.seed(S.seed)
S.fake_name = S.fake.name()
S.fake_st = S.fake.state_abbr()
S.fake_quantity = S.fake.random_int(0, 100)
S.fake_received = S.fake.boolean()
S.sqlcmd = "insert into REPORT values ('" + S.fake_name + "','" + S.fake_st + "'," + vfpfunc.str(
S.fake_quantity).strip() + ',' + vfpfunc.str(int(
S.fake_received)).strip() + ')'
print(S.sqlcmd)
return vfpfunc.sqlexec(S.sqlconn, S.sqlcmd)
def math_tests():
M.add_local('num_value')
S.num_value = math.pi
assert round(math.pi, 2) == 3.14
assert abs(math.tan(math.radians(45)) - 1) < 0.001
assert abs(math.sin(math.radians(90)) - 1) < 0.001
assert abs(math.cos(math.radians(90)) - 0) < 0.001
assert abs(math.cos(math.radians(45)) - math.sqrt(2) / 2) < 0.001
assert 0 < random.random() and random.random() < 1
M.add_local('stringval')
S.stringval = '1e5'
assert float(S.stringval) == 100000
assert vfpfunc.vartype(S.num_value) == 'N'
def date_tests():
M.add_local('somedate')
S.somedate = dt.date(2017, 6, 30)
assert S.somedate == dt.date(2017, 6, 30)
assert vfpfunc.dow_fix(S.somedate.weekday()) == 6
assert S.somedate.strftime('%A') == 'Friday'
assert S.somedate.month == 6
assert S.somedate.strftime('%B') == 'June'
assert S.somedate.strftime('%d %B %Y') == '30 June 2017'
assert len(dt.datetime.now().time().strftime('%H:%M:%S')) == 8
assert len(dt.datetime.now().time().strftime('%H:%M:%S.%f')[:11]) == 11
assert dt.datetime.combine(S.somedate,
dt.datetime.min.time()) == dt.datetime(
2017, 6, 30, 0)
assert vfpfunc.gomonth(S.somedate, -4) == dt.date(2017, 2, 28)
assert vfpfunc.vartype(S.somedate) == 'D'
assert vfpfunc.vartype(
dt.datetime.combine(S.somedate, dt.datetime.min.time())) == 'T'
def database_tests():
# FIX ME: SET SAFETY OFF
# FIX ME: SET ASSERTS ON
try:
DB.create_table('report',
'name c(50); st c(2); quantity n(5, 0); received l',
'free')
assert os.path.isfile('report.dbf')
assert DB.used('report')
try:
DB.use('report', 0, 'shared')
assert False
except Exception as err:
S.oerr = vfpfunc.Exception.from_pyexception(err)
print(S.oerr.message)
assert S.oerr.message == 'File is in use.'
_add_db_record(0)
_add_db_record(1)
_add_db_record(2)
_add_db_record(3)
assert DB.cpdbf() == 0
assert DB.fcount() == 4
DB.alter_table('report', 'add', 'age n(3, 0)')
assert DB.fcount() == 5
assert DB.field(2) == 'st'
assert not DB.found()
DB.goto(None, 0)
M.add_local('loopcount')
S.loopcount = 0
for _ in DB.scanner(scope=('rest', )):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 4
DB.goto(None, 3)
S.loopcount = 0
for _ in DB.scanner(scope=('all', ),
condition=lambda: S.st.strip() == 'ID'):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 2
S.loopcount = 0
for _ in DB.scanner(scope=('rest', ),
condition=lambda: S.st.strip() == 'ID'):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 0
DB.goto(None, 0)
S.loopcount = 0
for _ in DB.scanner(scope=('rest', ),
condition=lambda: S.st.strip() == 'ID'):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 2
del M.loopcount
assert S.name.strip(
) == 'Norma Fisher', S.name.strip() + ' should be Norma Fisher'
assert DB.recno() == 1
S.report_record = vfpfunc.scatter(totype='name')
assert S.report_record.name.strip(
) == 'Norma Fisher', S.report_record.name.strip(
) + ' should be Norma Fisher'
DB.goto(None, -1)
assert S.name.strip(
) == 'Joshua Wood', S.name.strip() + ' should be Joshua Wood'
assert S.report_record.name.strip(
) == 'Norma Fisher', S.report_record.name.strip(
) + ' should be Norma Fisher'
assert DB.recno() == 4
DB.goto(None, 1)
DB.locate(for_cond=lambda: S.st == 'ID')
assert S.name.strip(
) == 'Norma Fisher', S.name.strip() + ' should be Norma Fisher'
assert DB.found()
DB.continue_locate()
assert S.name.strip(
) == 'Ryan Gallagher', S.name.strip() + ' should be Ryan Gallagher'
DB.continue_locate()
assert DB.eof()
assert DB.recno() == DB.reccount() + 1
assert not DB.found()
S.countval = DB.count(None, ('all', ),
for_cond=lambda: S.quantity > 60)
assert S.countval == 2
assert DB.eof()
S.sumval = DB.sum(None, ('rest', ),
lambda: math.sqrt(S.quantity + 205),
for_cond=lambda: S.quantity > 50,
while_cond=lambda: S.quantity != 63)
assert S.sumval == 0
DB.goto(None, 0)
S.sumval = DB.sum(None, ('rest', ),
lambda: math.sqrt(S.quantity + 205),
for_cond=lambda: S.quantity > 50,
while_cond=lambda: S.quantity != 63)
assert S.sumval == 17 + 16
DB.index_on('st', 'st', 'ascending', True, False, False)
DB.seek(None, 'CA')
assert S.st.strip() == 'CA'
DB.goto(None, 0)
DB.delete_record(None, ('rest', ), for_cond=lambda: S.quantity > 60)
DB.pack('both', None, None)
DB.goto(None, 0)
assert DB.reccount() == 2
DB.replace('report', ('next', 1), 'name', 'N/A')
assert S.name.strip() == 'N/A'
DB.replace(None, ('all', ), 'name', 'Not Available')
assert DB.recno() == DB.reccount() + 1
DB.goto(None, -1)
assert S.name.strip() == 'Not Available'
DB.zap(None)
assert DB.reccount() == 0
DB.copy_structure('report2')
DB.use('report2', 0, 'shared', alias='somethingelse')
assert DB.alias() == 'report'
DB.select('report2')
assert DB.alias() == 'somethingelse'
assert DB.fcount() == 5
DB.alter_table('report2', 'drop', 'st')
assert DB.fcount() == 4
assert S.report_record.name.strip(
) == 'Norma Fisher', S.report_record.name.strip(
) + ' should be Norma Fisher'
DB.append(None, False)
vfpfunc.gather(val=S.report_record)
assert S.name.strip(
) == 'Norma Fisher', S.name.strip() + ' should be Norma Fisher'
assert DB.dbf() == 'report2.dbf'
DB.use(None, DB.select_function('report2'), None)
DB.use(None, DB.select_function('report'), None)
os.remove('report2.dbf')
except Exception as err:
S.err = vfpfunc.Exception.from_pyexception(err)
print(S.err.message)
DB.browse()
raise
finally:
os.remove('report.dbf')
S.sqlconn = vfpfunc.sqlconnect('testodbc')
assert S.sqlconn > 0
assert vfpfunc.sqlexec(
S.sqlconn,
'CREATE TABLE REPORT (NAME varchar(50), ST char(2), QUANTITY int(5), RECEIVED bit)'
) > 0
assert _sqlexec_add_record(S.sqlconn, 0) > 0
assert _sqlexec_add_record(S.sqlconn, 1) > 0
assert _sqlexec_add_record(S.sqlconn, 2) > 0
assert _sqlexec_add_record(S.sqlconn, 3) > 0
assert vfpfunc.sqlexec(S.sqlconn, 'SELECT * FROM REPORT')
DB.select('sqlresult')
assert S.name.strip() == 'Norma Fisher'
vfpfunc.sqlcommit(S.sqlconn)
vfpfunc.sqldisconnect(S.sqlconn)
S.sqlconn = vfpfunc.sqlstringconnect('dsn=testodbc')
assert S.sqlconn > 0
assert vfpfunc.sqltables(S.sqlconn) > 0
DB.select('sqlresult')
assert S.table_name.strip().lower() == 'report'
assert vfpfunc.sqlexec(S.sqlconn, 'DELETE FROM REPORT;')
assert vfpfunc.sqlrollback(S.sqlconn)
assert vfpfunc.sqlexec(S.sqlconn, 'SELECT * FROM REPORT')
DB.select('sqlresult')
assert S.name.strip() == 'Norma Fisher'
assert vfpfunc.sqlexec(S.sqlconn, 'DROP TABLE REPORT') > 0
vfpfunc.sqlcommit(S.sqlconn)
vfpfunc.sqldisconnect(S.sqlconn)
DB.close_tables(False)
def database_tests():
# FIX ME: SET SAFETY OFF
# FIX ME: SET ASSERTS ON
try:
DB.create_table('report',
'name c(50); st c(2); quantity n(5, 0); received l',
'free')
assert os.path.isfile('report.dbf')
assert DB.used('report')
try:
DB.use('report', 0, 'shared')
assert False
except Exception as S.oerr:
S.oerr = vfpfunc.Exception.from_pyexception(S.oerr)
print(S.oerr.message)
assert S.oerr.message == 'File is in use.'
_add_db_record(0)
_add_db_record(1)
_add_db_record(2)
_add_db_record(3)
assert DB.fcount() == 4
DB.alter_table('report', 'add', 'age n(3, 0)')
assert DB.fcount() == 5
assert DB.field(2) == 'st'
assert not DB.found()
DB.goto(None, 0)
M.add_local('loopcount')
S.loopcount = 0
for _ in DB.scanner(scope=('rest', )):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 4
DB.goto(None, 3)
S.loopcount = 0
for _ in DB.scanner(scope=('all', ),
condition=lambda: S.st.strip() == 'ID'):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 2
S.loopcount = 0
for _ in DB.scanner(scope=('rest', ),
condition=lambda: S.st.strip() == 'ID'):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 0
DB.goto(None, 0)
S.loopcount = 0
for _ in DB.scanner(scope=('rest', ),
condition=lambda: S.st.strip() == 'ID'):
assert len(S.name.strip()) > 0
S.loopcount += 1
assert S.loopcount == 2
del M.loopcount
assert S.name.strip(
) == 'Norma Fisher', S.name.strip() + ' should be Norma Fisher'
assert DB.recno() == 1
S.report_record = vfpfunc.scatter(totype='name')
assert S.report_record.name.strip(
) == 'Norma Fisher', S.report_record.name.strip(
) + ' should be Norma Fisher'
DB.goto(None, -1)
assert S.name.strip(
) == 'Joshua Wood', S.name.strip() + ' should be Joshua Wood'
assert S.report_record.name.strip(
) == 'Norma Fisher', S.report_record.name.strip(
) + ' should be Norma Fisher'
assert DB.recno() == 4
DB.goto(None, 1)
DB.locate(for_cond=lambda: S.st == 'ID')
assert S.name.strip(
) == 'Norma Fisher', S.name.strip() + ' should be Norma Fisher'
assert DB.found()
DB.continue_locate()
assert S.name.strip(
) == 'Ryan Gallagher', S.name.strip() + ' should be Ryan Gallagher'
DB.continue_locate()
assert DB.eof()
assert DB.recno() == DB.reccount() + 1
assert not DB.found()
S.countval = DB.count(None, ('all', ),
for_cond=lambda: S.quantity > 60)
assert S.countval == 2
assert DB.eof()
S.sumval = DB.sum(None, ('rest', ),
lambda: math.sqrt(S.quantity + 205),
for_cond=lambda: S.quantity > 50,
while_cond=lambda: S.quantity != 63)
assert S.sumval == 0
DB.goto(None, 0)
S.sumval = DB.sum(None, ('rest', ),
lambda: math.sqrt(S.quantity + 205),
for_cond=lambda: S.quantity > 50,
while_cond=lambda: S.quantity != 63)
assert S.sumval == 17 + 16
DB.index_on('st', 'st', 'ascending', True, False, False)
DB.seek(None, 'CA')
assert S.st.strip() == 'CA'
DB.goto(None, 0)
DB.delete_record(None, ('rest', ), for_cond=lambda: S.quantity > 60)
DB.pack('both', None, None)
DB.goto(None, 0)
assert DB.reccount() == 2
DB.replace('report', ('next', 1), 'name', 'N/A')
assert S.name.strip() == 'N/A'
DB.replace(None, ('all', ), 'name', 'Not Available')
assert DB.recno() == DB.reccount() + 1
DB.goto(None, -1)
assert S.name.strip() == 'Not Available'
DB.zap(None)
assert DB.reccount() == 0
DB.copy_structure('report2')
DB.use('report2', 0, 'shared', alias='somethingelse')
assert DB.alias() == 'report'
DB.select('report2')
assert DB.alias() == 'somethingelse'
assert DB.fcount() == 5
DB.alter_table('report2', 'drop', 'st')
assert DB.fcount() == 4
assert S.report_record.name.strip(
) == 'Norma Fisher', S.report_record.name.strip(
) + ' should be Norma Fisher'
DB.append(None, False)
vfpfunc.gather(val=S.report_record)
assert S.name.strip(
) == 'Norma Fisher', S.name.strip() + ' should be Norma Fisher'
assert DB.dbf() == 'report2.dbf'
DB.use(None, DB.select_function('report2'), None)
DB.use(None, DB.select_function('report'), None)
os.remove('report2.dbf')