def test_write(self):
pytest4 = self.dbs.get_file("PYTEST4",
internal=True,
fieldnames=["GENDER", "NUMBERS", "YESNO"])
transaction.begin()
rowid = pytest4.insert(NAME="Insert Internal",
GENDER="F",
NUMBERS="4",
YESNO="N")
transaction.commit()
cursor = pytest4.traverser("B", "Insert Internal")
rec = cursor.next()
self.assertEqual(rec[0], "F")
self.assertEqual(rec[1], "4")
self.assertEqual(rec[2], "N")
# Check validation
transaction.begin()
try:
rowid = pytest4.update(rowid, GENDER="UNKNOWN")
transaction.commit()
except FilemanError, e:
transaction.abort()
def test_readwrite(self):
dd = self.dbs.dd("PYTEST7")
self.assertEqual(dd.fileid, "999912")
pytest = self.dbs.get_file("PYTEST7")
transaction.begin()
rowid = pytest.insert(NAME = 'Test Insert')
transaction.commit()
# The low-level traverser, walks index "B", on NAME field
# ('^DD(9999903,0,"IX","B",9999903,.01)', ''),
cursor = pytest.traverser("B", "Test")
rec = cursor.next()
# validate the inserted data
self.assertEqual(rec[0], "Test Insert")
self.assertEqual(rec[1], "100")
# Attempt to update the field
e = None
transaction.begin()
try:
pytest.update(rowid, C1="200")
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
def test_readwrite(self):
dd = self.dbs.dd("PYTEST7")
self.assertEqual(dd.fileid, "999912")
pytest = self.dbs.get_file("PYTEST7")
transaction.begin()
rowid = pytest.insert(NAME='Test Insert')
transaction.commit()
# The low-level traverser, walks index "B", on NAME field
# ('^DD(9999903,0,"IX","B",9999903,.01)', ''),
cursor = pytest.traverser("B", "Test")
rec = cursor.next()
# validate the inserted data
self.assertEqual(rec[0], "Test Insert")
self.assertEqual(rec[1], "100")
# Attempt to update the field
e = None
transaction.begin()
try:
pytest.update(rowid, C1="200")
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
def test_badwrite(self):
pytest3 = self.dbs.get_file("PYTEST3")
transaction.begin()
e = None
try:
pytest3.insert(NAME="bad Insert1", INT1=1.1)
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
def test_badwrite(self):
pytest3 = self.dbs.get_file("PYTEST3")
transaction.begin()
e = None
try:
pytest3.insert(NAME="bad Insert1", INT1=1.1)
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
def test_badinsert(self):
"""
Should fail to insert if foreign key non-existant
"""
pytest = self.dbs.get_file("PYTEST10C", internal=True)
transaction.begin()
exception = False
try:
rowid = pytest.insert(NAME="TEST INSERT", VP1="VP1.20")
transaction.commit()
except FilemanError, e:
transaction.abort()
exception = e
def test_badinsert(self):
"""
Should fail to insert if foreign key non-existant
"""
pytest = self.dbs.get_file("PYTEST10C", internal=True)
transaction.begin()
exception = False
try:
rowid = pytest.insert(NAME="TEST INSERT", VP1="VP1.20")
transaction.commit()
except FilemanError, e:
transaction.abort()
exception = e
def test_badinsert(self):
"""
Should fail to insert if foreign key non-existant
"""
pytest = self.dbs.get_file("PYTEST9B", internal=True,
fieldnames=["NAME", "P1", "P2"])
transaction.begin()
exception = False
try:
rowid = pytest.insert(NAME="TEST INSERT", P1="20")
transaction.commit()
except FilemanError, e:
transaction.abort()
exception = e
def test_badinsert(self):
"""
Should fail to insert if foreign key non-existant
"""
pytest = self.dbs.get_file("PYTEST9B",
internal=True,
fieldnames=["NAME", "P1", "P2"])
transaction.begin()
exception = False
try:
rowid = pytest.insert(NAME="TEST INSERT", P1="20")
transaction.commit()
except FilemanError, e:
transaction.abort()
exception = e
def test_write(self):
pytest4 = self.dbs.get_file("PYTEST4", internal=True,
fieldnames=["GENDER", "NUMBERS", "YESNO"])
transaction.begin()
rowid = pytest4.insert(NAME="Insert Internal", GENDER="F", NUMBERS="4", YESNO="N")
transaction.commit()
cursor = pytest4.traverser("B", "Insert Internal")
rec = cursor.next()
self.assertEqual(rec[0], "F")
self.assertEqual(rec[1], "4")
self.assertEqual(rec[2], "N")
# Check validation
transaction.begin()
try:
rowid = pytest4.update(rowid, GENDER="UNKNOWN")
transaction.commit()
except FilemanError, e:
transaction.abort()
def test_readwrite(self):
pytest = self.dbs.get_file("PYTEST8", fieldnames=['NAME', 'M1'])
transaction.begin()
rowid = pytest.insert(NAME='Test Insert', M1='SET X=4,Y=7')
transaction.commit()
# The low-level traverser, walks index "B", on NAME field
cursor = pytest.traverser("B", "Test")
rec = cursor.next()
# validate the inserted data
self.assertEqual(rec[0], "Test Insert")
self.assertEqual(rec[1], "SET X=4,Y=7")
# Attempt to update the field
e = None
transaction.begin()
try:
pytest.update(_rowid=rowid, M1="Invalid Code")
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
def test_readwrite(self):
pytest = self.dbs.get_file("PYTEST8", fieldnames=['NAME', 'M1'])
transaction.begin()
rowid = pytest.insert(NAME='Test Insert', M1='SET X=4,Y=7')
transaction.commit()
# The low-level traverser, walks index "B", on NAME field
cursor = pytest.traverser("B", "Test")
rec = cursor.next()
# validate the inserted data
self.assertEqual(rec[0], "Test Insert")
self.assertEqual(rec[1], "SET X=4,Y=7")
# Attempt to update the field
e = None
transaction.begin()
try:
pytest.update(_rowid=rowid, M1="Invalid Code")
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
pytest3.insert(NAME="bad Insert2", DOLLARS=44.4499)
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
# rounding errors ignored
self.assertEquals(e, None)
transaction.begin()
e = None
try:
pytest3.insert(NAME="bad Insert3", FLOAT1="abc")
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
self.assertTrue(isinstance(e, FilemanError))
def test_indexing(self):
"""
TODO: walk a numeric index. Can I return the values as ints / floats.
"""
test_cases = (TestNumerics, )
def load_tests(loader, tests, pattern):
suite = unittest.TestSuite()
def tearDown(self):
# destroy the file
if transaction.in_transaction:
transaction.abort()
self._cleanupFile()
def tearDown(self):
# destroy the file
if transaction.in_transaction:
transaction.abort()
self._cleanupFile()
# TODO: These are no longer working, since I switched to insert in Internal mode
transaction.begin()
exception = False
try:
pytest1 = self.dbs.get_file("PYTEST1")
pytest1.insert(NAME='ROW3', TEXTLINE_ONE="LINE 1", TEXTLINE2=None)
except FilemanError, e:
exception = True
self.assertEqual(exception, True)
transaction.abort()
transaction.begin()
exception = False
try:
pytest1 = self.dbs.get_file("PYTEST1")
pytest1.insert(NAME='ROW3', TEXTLINE_ONE="LINE 1", TEXTLINE2="")
except FilemanError, e:
exception = True
self.assertEqual(exception, True)
transaction.abort()
test_cases = (TestTextline, )
def load_tests(loader, tests, pattern):
suite = unittest.TestSuite()
for test_class in test_cases:
tests = loader.loadTestsFromTestCase(test_class)
suite.addTests(tests)
return suite
class TestNumerics(unittest.TestCase):
"""
Create a simple file containing a couple of numeric values.
"""
DIC = [
('^DIC(9999905,0)', 'PYTEST3^9999905'),
('^DIC(9999905,0,"AUDIT")', '@'),
('^DIC(9999905,0,"DD")', '@'),
('^DIC(9999905,0,"DEL")', '@'),
('^DIC(9999905,0,"GL")', '^DIZ(9999905,'),
('^DIC(9999905,0,"LAYGO")', '@'),
('^DIC(9999905,0,"RD")', '@'),
('^DIC(9999905,0,"WR")', '@'),
('^DIC(9999905,"%A")', '10000000020^3120720'),
('^DIC("B","PYTEST3",9999905)', ''),
]
DIZ = [
('^DIZ(9999905,0)', 'PYTEST3^9999905^1^1'),
('^DIZ(9999905,1,0)',
'entered via fileman^10^-10^33.33^22222.22^-333'),
('^DIZ(9999905,"B","entered via fileman",1)', ''),
]
DD = [
('^DD(9999905,0)', 'FIELD^^5^6'),
('^DD(9999905,0,"DT")', '3120720'),
('^DD(9999905,0,"IX","B",9999905,.01)', ''),
('^DD(9999905,0,"NM","PYTEST3")', ''),
('^DD(9999905,.01,0)',
'''NAME^RF^^0;1^K:$L(X)>30!(X?.N)!($L(X)<3)!'(X'?1P.E) X'''),
('^DD(9999905,.01,1,0)', '^.1'),
('^DD(9999905,.01,1,1,0)', '9999905^B'),
('^DD(9999905,.01,1,1,1)', 'S ^DIZ(9999905,"B",$E(X,1,30),DA)=""'),
('^DD(9999905,.01,1,1,2)', 'K ^DIZ(9999905,"B",$E(X,1,30),DA)'),
('^DD(9999905,.01,3)',
'NAME MUST BE 3-30 CHARACTERS, NOT NUMERIC OR STARTING WITH PUNCTUATION'
),
('^DD(9999905,1,0)',
'''int1^NJ6,0^^0;2^K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X'''),
('^DD(9999905,1,3)',
'Type a Number between 0 and 999999, 0 Decimal Digits'),
('^DD(9999905,1,"DT")', '3120720'),
('^DD(9999905,2,0)',
'''int2^NJ5,0^^0;3^K:+X'=X!(X>10000)!(X<-10000)!(X?.E1"."1N.N) X'''),
('^DD(9999905,2,3)',
'Type a Number between -10000 and 10000, 0 Decimal Digits'),
('^DD(9999905,2,"DT")', '3120720'),
('^DD(9999905,3,0)',
'''dollars^NJ8,2^^0;4^S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>10000)!(X<0) X'''
),
('^DD(9999905,3,3)',
'Type a Dollar Amount between 0 and 10000, 2 Decimal Digits'),
('^DD(9999905,3,"DT")', '3120720'),
('^DD(9999905,4,0)',
'''float1^NJ8,2^^0;5^K:+X'=X!(X>99999)!(X<0)!(X?.E1"."3N.N) X'''),
('^DD(9999905,4,3)',
'Type a Number between 0 and 99999, 2 Decimal Digits'),
('^DD(9999905,4,"DT")', '3120720'),
('^DD(9999905,5,0)',
'''float2^NJ9,4^^0;6^K:+X'=X!(X>1000)!(X<-1000)!(X?.E1"."5N.N) X'''),
('^DD(9999905,5,3)',
'Type a Number between -1000 and 1000, 4 Decimal Digits'),
('^DD(9999905,5,"DT")', '3120720'),
('^DD(9999905,"B","NAME",.01)', ''),
('^DD(9999905,"B","dollars",3)', ''),
('^DD(9999905,"B","float1",4)', ''),
('^DD(9999905,"B","float2",5)', ''),
('^DD(9999905,"B","int1",1)', ''),
('^DD(9999905,"B","int2",2)', ''),
('^DD(9999905,"GL",0,1,.01)', ''),
('^DD(9999905,"GL",0,2,1)', ''),
('^DD(9999905,"GL",0,3,2)', ''),
('^DD(9999905,"GL",0,4,3)', ''),
('^DD(9999905,"GL",0,5,4)', ''),
('^DD(9999905,"GL",0,6,5)', ''),
('^DD(9999905,"IX",.01)', ''),
('^DD(9999905,"RQ",.01)', ''),
]
IX = []
def _cleanupFile(self):
transaction.begin()
Globals["^DIC"]["9999905"].kill()
Globals["^DIC"]['B']["PYTEST3"].kill()
Globals["^DD"]["9999905"].kill()
Globals["^DIZ"]["9999905"].kill()
transaction.commit()
def _createFile(self):
# This creates a file
transaction.begin()
Globals.deserialise(self.DIC)
Globals.deserialise(self.DD)
Globals.deserialise(self.DIZ)
#Globals.deserialise(self.IX)
transaction.commit()
# Are indices setup
dd = self.dbs.dd("PYTEST3")
self.assertEqual(dd.fileid, "9999905")
self.assertEqual(len(dd.indices), 1)
#self.assertEqual(len(dd.new_indices), 1)
def setUp(self):
self.dbs = connect("0", "")
self._cleanupFile()
self._createFile()
def tearDown(self):
# destroy the file
self._cleanupFile()
if transaction.in_transaction:
transaction.abort()
def test_read(self):
"""
Validate the data which was in the file. This data
was created via FILEMAN.
"""
pytest3 = self.dbs.get_file(
"PYTEST3",
internal=True,
fieldnames=["NAME", "INT1", "INT2", "DOLLARS", "FLOAT1", "FLOAT2"])
cursor = pytest3.traverser("B", "e")
rec = cursor.next()
self.assertEqual(rec[1], '10')
self.assertEqual(rec[2], '-10')
self.assertEqual(rec[3], '33.33')
self.assertEqual(rec[4], '22222.22')
self.assertEqual(rec[5], '-333.0')
pytest3 = self.dbs.get_file(
"PYTEST3",
internal=False,
fieldnames=["NAME", "INT1", "INT2", "DOLLARS", "FLOAT1", "FLOAT2"])
cursor = pytest3.traverser("B", "e")
rec = cursor.next()
self.assertEqual(rec[1], '10')
self.assertEqual(rec[2], '-10')
self.assertEqual(rec[3], '33.33')
self.assertEqual(rec[4], '22222.22')
self.assertEqual(rec[5], '-333.0')
def test_write(self):
pytest3 = self.dbs.get_file(
"PYTEST3",
fieldnames=["NAME", "INT1", "INT2", "DOLLARS", "FLOAT1", "FLOAT2"])
transaction.begin()
rowid = pytest3.insert(NAME="Insert",
INT1=11,
INT2=-11,
DOLLARS=44.44,
FLOAT1=3333.33,
FLOAT2=-444.0)
transaction.commit()
cursor = pytest3.traverser("B", "Insert")
rec = cursor.next()
self.assertEqual(rec[1], '11')
self.assertEqual(rec[2], '-11')
self.assertEqual(rec[3], '44.44')
self.assertEqual(rec[4], '3333.33')
self.assertEqual(rec[5], '-444.0')
def test_badwrite(self):
pytest3 = self.dbs.get_file("PYTEST3")
transaction.begin()
e = None
try:
pytest3.insert(NAME="bad Insert1", INT1=1.1)
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
# rounding errors ignored
self.assertEquals(e, None)
transaction.begin()
e = None
try:
pytest3.insert(NAME="bad Insert2", DOLLARS=44.4499)
transaction.commit()
except FilemanError, e1:
transaction.abort()
e = e1
class TestTextline(unittest.TestCase):
"""
Create a simple file containing two text lines,
one mandatory and one optional. Verify that the
read and write functionality works.
"""
# DIC record
DIC = [
('^DIC(9999903,0)', u'PYTEST1^9999903'),
('^DIC(9999903,0,"AUDIT")', '@'),
('^DIC(9999903,0,"DD")', '@'),
('^DIC(9999903,0,"DEL")', '@'),
('^DIC(9999903,0,"GL")', '^DIZ(9999903,'),
('^DIC(9999903,0,"LAYGO")', '@'),
('^DIC(9999903,0,"RD")', '@'),
('^DIC(9999903,0,"WR")', '@'),
('^DIC(9999903,"%A")', '10000000020^3120716'),
('^DIC("B","PYTEST1",9999903)', ''),
]
# ^DIZ record
DIZ = [
('^DIZ(9999903,0)', 'PYTEST1^9999903^0^0')
]
# ^DD record
# I added a traditional style index / cross reference (C)
DD = [
('^DD(9999903,0)', u'FIELD^^2^3'),
('^DD(9999903,0,"DT")', '3120716'),
('^DD(9999903,0,"IX","B",9999903,.01)', ''),
('^DD(9999903,0,"IX","C",9999903,1)', ''),
('^DD(9999903,0,"NM","PYTEST1")', ''),
('^DD(9999903,.01,0)', "NAME^RF^^0;1^K:$L(X)>30!(X?.N)!($L(X)<3)!'(X'?1P.E) X"),
('^DD(9999903,.01,1,0)', '^.1'),
('^DD(9999903,.01,1,1,0)', '9999903^B'),
('^DD(9999903,.01,1,1,1)', 'S ^DIZ(9999903,"B",$E(X,1,30),DA)=""'),
('^DD(9999903,.01,1,1,2)', 'K ^DIZ(9999903,"B",$E(X,1,30),DA)'),
('^DD(9999903,.01,3)', 'NAME MUST BE 3-30 CHARACTERS, NOT NUMERIC OR STARTING WITH PUNCTUATION'),
('^DD(9999903,1,0)', 'Textline One^F^^0;2^K:$L(X)>200!($L(X)<1) X'),
('^DD(9999903,1,.1)', 'Text Line One'),
('^DD(9999903,1,1,0)', '^.1'),
# Traditional Index
('^DD(9999903,1,1,1,0)', '9999903^C'),
('^DD(9999903,1,1,1,1)', 'S ^DIZ(9999903,"C",$E(X,1,30),DA)=""'),
('^DD(9999903,1,1,1,2)', 'K ^DIZ(9999903,"C",$E(X,1,30),DA)'),
('^DD(9999903,1,1,1,"DT")', '3120716'),
('^DD(9999903,1,3)', 'Answer must be 1-200 characters in length.'),
('^DD(9999903,1,"DT")', '3120716'),
('^DD(9999903,2,0)', 'textline2^RF^^1;1^K:$L(X)>200!($L(X)<1) X'),
('^DD(9999903,2,3)', 'Answer must be 1-200 characters in length.'),
('^DD(9999903,2,"DT")', '3120716'),
('^DD(9999903,"B","NAME",.01)', ''),
('^DD(9999903,"B","Text Line One",1)', '1'),
('^DD(9999903,"B","Textline One",1)', ''),
('^DD(9999903,"B","textline2",2)', ''),
('^DD(9999903,"GL",0,1,.01)', ''),
('^DD(9999903,"GL",0,2,1)', ''),
('^DD(9999903,"GL",1,1,2)', ''),
('^DD(9999903,"IX",.01)', ''),
# Traditional Index
('^DD(9999903,"IX",1)', ''),
('^DD(9999903,"RQ",.01)', ''),
('^DD(9999903,"RQ",2)', ''),
]
# ^DD("IX") describes "New" style indexes
# TODO: I must allocate the index id dynamically
IX = [
('^DD("IX",116,0)', '9999903^D^Regular index on textline2^R^^F^IR^I^9999903^^^^^LS'),
('^DD("IX",116,1)', 'S ^DIZ(9999903,"D",$E(X,1,30),DA)=""'),
('^DD("IX",116,2)', 'K ^DIZ(9999903,"D",$E(X,1,30),DA)'),
('^DD("IX",116,2.5)', 'K ^DIZ(9999903,"D")'),
('^DD("IX",116,11.1,0)', '^.114IA^1^1'),
('^DD("IX",116,11.1,1,0)', '1^F^9999903^2^30^1^F'),
('^DD("IX",116,11.1,1,3)', ''),
('^DD("IX",116,11.1,"AC",1,1)', ''),
('^DD("IX",116,11.1,"B",1,1)', ''),
('^DD("IX",116,11.1,"BB",1,1)', ''),
('^DD("IX","B",9999903,116)', ''),
('^DD("IX","IX","D",116)', ''),
('^DD("IX","AC",9999903,116)', ''),
('^DD("IX","BB",9999903,"D",116)', ''),
('^DD("IX","F",9999903,2,116,1)', ''),
]
def _cleanupFile(self):
transaction.begin()
Globals["^DIC"]["9999903"].kill()
Globals["^DIC"]['B']["PYTEST1"].kill()
Globals["^DD"]["9999903"].kill()
Globals["^DIZ"]["9999903"].kill()
Globals["^DD"]["IX"]["116"].kill()
Globals["^DD"]["IX"]["B"]["9999903"].kill()
Globals["^DD"]["IX"]["BB"]["9999903"].kill()
Globals["^DD"]["IX"]["AC"]["9999903"].kill()
Globals["^DD"]["IX"]["IX"]["D"]["116"].kill()
Globals["^DD"]["IX"]["F"]["9999903"].kill()
transaction.commit()
def _createFile(self):
# This creates a file
transaction.begin()
Globals.deserialise(self.DIC)
Globals.deserialise(self.DD)
Globals.deserialise(self.DIZ)
Globals.deserialise(self.IX)
transaction.commit()
# Are indices setup
dd = self.dbs.dd("PYTEST1")
self.assertEqual(len(dd.indices), 2)
self.assertEqual(len(dd.new_indices), 1)
def setUp(self):
self.dbs = connect("0", "")
self._cleanupFile()
self._createFile()
def tearDown(self):
# destroy the file
if transaction.in_transaction:
transaction.abort()
self._cleanupFile()
def test_readwrite(self):
transaction.begin()
pytest1 = self.dbs.get_file("PYTEST1", fieldnames=['NAME', 'TEXTLINE_ONE', 'TEXTLINE2'])
pytest1.insert(NAME='Test Insert', TEXTLINE_ONE="LINE 1", TEXTLINE2="LINE 2")
transaction.commit()
# The low-level traverser, walks index "B", on NAME field
# ('^DD(9999903,0,"IX","B",9999903,.01)', ''),
cursor = pytest1.traverser("B", "Test")
rec = cursor.next()
# validate the inserted data
self.assertEqual(rec[0], "Test Insert")
self.assertEqual(rec[1], "LINE 1")
self.assertEqual(rec[2], "LINE 2")
# Once this is working
# Verify mandatory field insert logic
# Verify utf-8 characters
# Verify update
def test_traversal(self):
"""
Insert multiple items. Verify that traversal back and
forward works.
"""
transaction.begin()
pytest1 = self.dbs.get_file("PYTEST1")
for i in range(10):
pytest1.insert(NAME='ROW%d' % i, TEXTLINE_ONE="%d: LINE 1" % i, TEXTLINE2="%d: LINE 2" % i)
transaction.commit()
# Index B is a default Key Field on the NAME field
# It is a "traditional" index
cursor = pytest1.traverser("B", "ROW4", "ROW8", raw=True)
result = list(cursor)
self.assertEqual(len(result), 4)
self.assertEqual(result[0][0], "ROW4")
self.assertEqual(result[1][0], "ROW5")
self.assertEqual(result[2][0], "ROW6")
self.assertEqual(result[3][0], "ROW7")
cursor = pytest1.traverser("B", "ROW8", "ROW4", ascending=False, raw=True)
result = list(cursor)
self.assertEqual(len(result), 4)
self.assertEqual(result[0][0], "ROW8")
self.assertEqual(result[1][0], "ROW7")
self.assertEqual(result[2][0], "ROW6")
self.assertEqual(result[3][0], "ROW5")
cursor = pytest1.traverser("B", "ROW4", "ROW8", to_rule="<=", from_rule=">=", raw=True)
result = list(cursor)
self.assertEqual(len(result), 5)
self.assertEqual(result[0][0], "ROW4")
self.assertEqual(result[1][0], "ROW5")
self.assertEqual(result[2][0], "ROW6")
self.assertEqual(result[3][0], "ROW7")
self.assertEqual(result[4][0], "ROW8")
cursor = pytest1.traverser("B", "ROW8", "ROW4", ascending=False, to_rule=">=", from_rule="<=", raw=True)
result = list(cursor)
self.assertEqual(len(result), 5)
self.assertEqual(result[0][0], "ROW8")
self.assertEqual(result[1][0], "ROW7")
self.assertEqual(result[2][0], "ROW6")
self.assertEqual(result[3][0], "ROW5")
self.assertEqual(result[4][0], "ROW4")
# Index C is a Cross reference Field on the TEXTLINE_ONE field
# It is a "traditional" index
# If I just pass in "4" it searches wrongly, putting integers
# before strings.
# TODO: how to make numbers and strings collate properly
cursor = pytest1.traverser("C", "4:", "8:", raw=True)
result = list(cursor)
self.assertEqual(len(result), 4)
self.assertEqual(result[0][0], "4: LINE 1")
self.assertEqual(result[1][0], "5: LINE 1")
self.assertEqual(result[2][0], "6: LINE 1")
self.assertEqual(result[3][0], "7: LINE 1")
cursor = pytest1.traverser("C", "8:", "4:", ascending=False, raw=True)
result = list(cursor)
self.assertEqual(len(result), 4)
self.assertEqual(result[0][0], "7: LINE 1")
self.assertEqual(result[1][0], "6: LINE 1")
self.assertEqual(result[2][0], "5: LINE 1")
self.assertEqual(result[3][0], "4: LINE 1")
# TODO: This is not working - I tried to renumber the index and
# since then it is not working properly.
# Index D is a new style index. Traversal works the same as
# traditional indices.
cursor = pytest1.traverser("D", "4:", "8:", raw=True)
result = list(cursor)
self.assertEqual(result[0][0], "4: LINE 2")
self.assertEqual(result[1][0], "5: LINE 2")
self.assertEqual(result[2][0], "6: LINE 2")
self.assertEqual(result[3][0], "7: LINE 2")
cursor = pytest1.traverser("D", "8:", "4:", ascending=False, raw=True)
result = list(cursor)
self.assertEqual(len(result), 4)
self.assertEqual(result[0][0], "7: LINE 2")
self.assertEqual(result[1][0], "6: LINE 2")
self.assertEqual(result[2][0], "5: LINE 2")
self.assertEqual(result[3][0], "4: LINE 2")
def test_mandatory(self):
"""
Fileman's concept of mandatory is that the value cannot be
set to a null value. However, if a value is never put into
it, it is not validated.
"""
transaction.begin()
pytest1 = self.dbs.get_file("PYTEST1")
pytest1.insert(NAME='ROW1', TEXTLINE_ONE="LINE 1")
transaction.commit()
# TODO: These are no longer working, since I switched to insert in Internal mode
transaction.begin()
exception = False
try:
pytest1 = self.dbs.get_file("PYTEST1")
pytest1.insert(NAME='ROW3', TEXTLINE_ONE="LINE 1", TEXTLINE2=None)
except FilemanError, e:
exception = True
self.assertEqual(exception, True)
transaction.abort()
transaction.begin()
exception = False
try:
pytest1 = self.dbs.get_file("PYTEST1")
pytest1.insert(NAME='ROW3', TEXTLINE_ONE="LINE 1", TEXTLINE2="")
except FilemanError, e:
exception = True
