コード例 #1
0
 def test_persist(self):
     d = tempfile.mkdtemp()
     path = os.path.join(d, 'x.db')
     try:
         db1 = DbBackend(path)
         node = Node(id=NodeID(),
                     tags={'my_tag'},
                     attr={'my_attr': 'my_val'},
                     pos_start=0x123,
                     pos_end=0x456,
                     data={'my_key'},
                     bindata={'my_bindata': 12345})
         db1.create(node)
         db1.close()
         db2 = DbBackend(path)
         n1 = db2.get(NodeID())
         self.assertEqual(n1, None)
         n2 = db2.get(node.id)
         self.assertIsInstance(n2, Node)
         self.assertEqual(n2.id, node.id)
         self.assertEqual(n2.parent, node.parent)
         self.assertEqual(n2.tags, node.tags)
         self.assertEqual(n2.attr, node.attr)
         self.assertEqual(n2.pos_start, node.pos_start)
         self.assertEqual(n2.pos_end, node.pos_end)
         self.assertEqual(n2.data, set())
         self.assertEqual(n2.bindata, {})
         db2.close()
     finally:
         try:
             os.unlink(path)
         except Exception:
             pass
         os.rmdir(d)
コード例 #2
0
 def test_list_simple(self):
     db = DbBackend(None)
     n1 = Node(id=NodeID(), tags={'aaa', 'bbb'})
     n2 = Node(id=NodeID(), tags={'aaa', 'ccc'})
     n1_1 = Node(id=NodeID(), parent=n1.id, tags={'ddd'})
     n1_2 = Node(id=NodeID(), parent=n1.id, tags={'ddd', 'eee'})
     for n in [n1, n2, n1_1, n1_2]:
         db.create(n)
     self.assertEqual(set(db.list(NodeID.root_id)), {n1.id, n2.id})
     self.assertEqual(set(db.list(NodeID.root_id, {'aaa'})), {n1.id, n2.id})
     self.assertEqual(set(db.list(NodeID.root_id, {'bbb'})), {n1.id})
     self.assertEqual(set(db.list(NodeID.root_id, {'ccc'})), {n2.id})
     self.assertEqual(set(db.list(NodeID.root_id, {'aaa', 'ccc'})), {n2.id})
     self.assertEqual(set(db.list(NodeID.root_id, {'ddd'})), set())
     self.assertEqual(set(db.list(NodeID.root_id, {'aaa', 'ddd'})), set())
     self.assertEqual(set(db.list(n1.id)), {n1_1.id, n1_2.id})
     self.assertEqual(set(db.list(n1.id, {'ddd'})), {n1_1.id, n1_2.id})
     self.assertEqual(set(db.list(n1.id, {'eee'})), {n1_2.id})
     self.assertEqual(set(db.list(n1.id, {'ddd', 'eee'})), {n1_2.id})
     self.assertEqual(set(db.list(n1.id, {'aaa'})), set())
     self.assertEqual(set(db.list(n1.id, {'aaa', 'ddd'})), set())
     self.assertEqual(set(db.list(n2.id)), set())
     self.assertEqual(set(db.list(n2.id, {'aaa', 'ddd'})), set())
     self.assertEqual(set(db.list(n1_1.id)), set())
     self.assertEqual(set(db.list(n1_2.id)), set())
コード例 #3
0
 def test_delete(self):
     db = DbBackend(None)
     node = Node(id=NodeID(),
                 tags={'my_node'},
                 attr={'a': 'b'},
                 pos_start=None,
                 pos_end=None,
                 data=set(),
                 bindata={})
     db.create(node)
     db.set_data(node.id, 'c', 'd')
     db.set_bindata(node.id, 'e', start=0, data=b'f', truncate=False)
     n2 = db.get(node.id)
     self.assertEqual(n2.tags, {'my_node'})
     self.assertEqual(db.get_data(node.id, 'c'), 'd')
     self.assertEqual(db.get_bindata(node.id, 'e'), b'f')
     db.delete(node.id)
     self.assertEqual(db.get(node.id), None)
     self.assertEqual(db.get_data(node.id, 'c'), None)
     self.assertEqual(db.get_bindata(node.id, 'e'), b'')
     id2 = NodeID()
     id3 = NodeID()
     self.assertEqual(db.get(id2), None)
     db.delete(id3)
     self.assertEqual(db.get(id3), None)
     with self.assertRaises(TypeError):
         db.delete(b'zlew')
コード例 #4
0
 def test_simple(self):
     db = DbBackend(None)
     node = Node(id=NodeID(),
                 tags={'my_tag'},
                 attr={'my_attr': 'my_val'},
                 pos_start=0x123,
                 pos_end=0x456789abcdef1122334456789abcdef,
                 data={'my_key'},
                 bindata={'my_bindata': 12345})
     db.create(node)
     n1 = db.get(NodeID())
     self.assertEqual(n1, None)
     n2 = db.get(node.id)
     self.assertIsInstance(n2, Node)
     self.assertEqual(n2.id, node.id)
     self.assertEqual(n2.parent, node.parent)
     self.assertEqual(n2.tags, node.tags)
     self.assertEqual(n2.attr, node.attr)
     self.assertEqual(n2.pos_start, node.pos_start)
     self.assertEqual(n2.pos_end, node.pos_end)
     self.assertEqual(n2.data, set())
     self.assertEqual(n2.bindata, {})
     with self.assertRaises(TypeError):
         db.get('zlew')
     with self.assertRaises(TypeError):
         db.get(node.id.bytes)
     with self.assertRaises(TypeError):
         db.create({'id': node.id})
コード例 #5
0
 def test_parent(self):
     db = DbBackend(None)
     id1 = NodeID()
     id2 = NodeID()
     n1 = Node(id=id1,
               attr={'name': 'parent'},
               data=set(),
               tags=set(),
               bindata={})
     db.create(n1)
     n2 = Node(id=id2,
               parent=id1,
               attr={'name': 'child'},
               tags=set(),
               data=set(),
               bindata={})
     db.create(n2)
     n1 = db.get(id1)
     self.assertIsInstance(n1, Node)
     self.assertEqual(n1.id, id1)
     self.assertEqual(n1.parent, NodeID.root_id)
     self.assertEqual(n1.attr['name'], 'parent')
     n2 = db.get(id2)
     self.assertIsInstance(n2, Node)
     self.assertEqual(n2.id, id2)
     self.assertEqual(n2.parent, id1)
     self.assertEqual(n2.attr['name'], 'child')
     l0 = db.list(NodeID.root_id)
     l1 = db.list(id1)
     l2 = db.list(id2)
     self.assertEqual(l0, {id1})
     self.assertEqual(l1, {id2})
     self.assertEqual(l2, set())
     # reparent n2 to root
     db.set_parent(id2, NodeID.root_id)
     n1 = db.get(id1)
     n2 = db.get(id2)
     self.assertEqual(n1.parent, NodeID.root_id)
     self.assertEqual(n2.parent, NodeID.root_id)
     l0 = db.list(NodeID.root_id)
     l1 = db.list(id1)
     l2 = db.list(id2)
     self.assertEqual(l0, {id1, id2})
     self.assertEqual(l1, set())
     self.assertEqual(l2, set())
     # reparent n1 to n2
     db.set_parent(id1, id2)
     n1 = db.get(id1)
     n2 = db.get(id2)
     self.assertEqual(n1.parent, id2)
     self.assertEqual(n2.parent, NodeID.root_id)
     l0 = db.list(NodeID.root_id)
     l1 = db.list(id1)
     l2 = db.list(id2)
     self.assertEqual(l0, {id2})
     self.assertEqual(l1, set())
     self.assertEqual(l2, {id1})
     with self.assertRaises(TypeError):
         db.set_parent(id1, id2.bytes)
コード例 #6
0
ファイル: test_nodeid.py プロジェクト: yuttasakcom/veles
 def test_valid(self):
     obj = NodeID()
     obj2 = NodeID()
     self.assertNotEqual(obj, obj2)
     byte = b'\x11\x12'*(NodeID.WIDTH//2)
     obj = NodeID(byte)
     self.assertEqual(byte, obj.bytes)
     obj = NodeID.root_id
     self.assertEqual(b'\xff'*NodeID.WIDTH, obj.bytes)
コード例 #7
0
ファイル: test_nodeid.py プロジェクト: yuttasakcom/veles
 def test_hashing(self):
     byte = b'\x11\x12'*(NodeID.WIDTH//2)
     byte2 = b'\x12\x11'*(NodeID.WIDTH//2)
     obj = NodeID(byte)
     obj2 = NodeID(byte)
     obj3 = NodeID(byte2)
     s = {obj}
     self.assertIn(obj2, s)
     self.assertNotIn(obj3, s)
     self.assertNotEqual(obj, byte)
     self.assertNotEqual(obj, byte2)
コード例 #8
0
ファイル: test_nodeid.py プロジェクト: yuttasakcom/veles
 def test_invalid(self):
     with self.assertRaises(TypeError):
         NodeID(123456)
     with self.assertRaises(TypeError):
         NodeID(u'zlew')
     with self.assertRaises(ValueError):
         NodeID(b'\x11'*(NodeID.WIDTH-1))
     with self.assertRaises(ValueError):
         NodeID(b'\x11'*(NodeID.WIDTH+1))
     with self.assertRaises(TypeError):
         NodeID.from_hex(123456)
     with self.assertRaises(ValueError):
         NodeID.from_hex('11'*(NodeID.WIDTH-1))
     with self.assertRaises(ValueError):
         NodeID.from_hex('11'*(NodeID.WIDTH+1))
コード例 #9
0
 def test_pos(self):
     db = DbBackend(None)
     node = Node(id=NodeID(),
                 tags=set(),
                 attr={},
                 pos_start=None,
                 pos_end=None,
                 data=set(),
                 bindata={})
     db.create(node)
     n2 = db.get(node.id)
     self.assertEqual(n2.pos_start, None)
     self.assertEqual(n2.pos_end, None)
     db.set_pos(node.id, 123, None)
     n2 = db.get(node.id)
     self.assertEqual(n2.pos_start, 123)
     self.assertEqual(n2.pos_end, None)
     db.set_pos(node.id, 0x11111111111111111111111111111111111,
                0x222222222222222222222222222222222222222)
     n2 = db.get(node.id)
     self.assertEqual(n2.pos_start, 0x11111111111111111111111111111111111)
     self.assertEqual(n2.pos_end, 0x222222222222222222222222222222222222222)
     with self.assertRaises(TypeError):
         db.set_pos(node.id, 123, b'zlew')
     with self.assertRaises(TypeError):
         db.set_pos(node.id, b'zlew', None)
コード例 #10
0
 def test_nodeid(self):
     a = fields.NodeID()
     id = NodeID()
     a.validate(id)
     with self.assertRaises(SchemaError):
         a.validate(b'abcd')
     with self.assertRaises(SchemaError):
         a.validate(1234)
     self.assertEqual(a.dump(id), id)
     self.assertEqual(a.load(id), id)
     with self.assertRaises(SchemaError):
         a.load(b'abcd')
     with self.assertRaises(SchemaError):
         a.load(1234)
コード例 #11
0
ファイル: backend.py プロジェクト: yuttasakcom/veles
 def get(self, id):
     if not isinstance(id, NodeID):
         raise TypeError('node id has wrong type')
     raw_id = buffer(id.bytes)
     c = self.db.cursor()
     c.execute("""
         SELECT parent, pos_start, pos_end FROM node WHERE id = ?
     """, (raw_id,))
     rows = c.fetchall()
     if not rows:
         return None
     (raw_parent, pos_start, pos_end), = rows
     parent = NodeID(bytes(raw_parent)) if raw_parent else NodeID.root_id
     c.execute("""
         SELECT name FROM node_tag WHERE id = ?
     """, (raw_id,))
     tags = {x for x, in c.fetchall()}
     c.execute("""
         SELECT name, data FROM node_attr WHERE id = ?
     """, (raw_id,))
     attr = {k: self._load(v) for k, v in c.fetchall()}
     c.execute("""
         SELECT name FROM node_data WHERE id = ?
     """, (raw_id,))
     data = {x for x, in c.fetchall()}
     # ATTENTION: sqlite dependency here - length(data) will be evaluated
     # for the max page for a given key (see
     # https://www.sqlite.org/lang_select.html#bareagg).
     assert isinstance(c, sqlite3.Cursor)
     c.execute("""
         SELECT name, MAX(page), length(data)
         FROM node_bindata
         WHERE id = ?
         GROUP BY name
     """, (raw_id,))
     bindata = {
         key: page * DB_BINDATA_PAGE_SIZE + lastlen
         for key, page, lastlen in c.fetchall()
     }
     return Node(id=id, parent=parent,
                 pos_start=db_bigint_decode(pos_start),
                 pos_end=db_bigint_decode(pos_end), tags=tags, attr=attr,
                 data=data, bindata=bindata)
コード例 #12
0
 def create(self,
            id=None,
            parent=None,
            pos=(None, None),
            tags=set(),
            attr={},
            data={},
            bindata={}):
     """
     Creates a node with the given data.  If ``id`` is None, a random id
     will be generated.  Returns a tuple of (node, awaitable of node) -
     the node is available immediately (and can be linked to other objects,
     or used as a parent), and the awaitable will be resolved once
     the operation completes on the server.
     """
     if id is None:
         id = NodeID()
     obj = self.get_node_norefresh(id)
     return obj, obj._create(parent, pos, tags, attr, data, bindata)
コード例 #13
0
ファイル: backend.py プロジェクト: yuttasakcom/veles
 def list(self, parent, tags=frozenset(), pos_filter=PosFilter()):
     if not isinstance(parent, NodeID):
         raise TypeError('parent must be a NodeID')
     if not isinstance(tags, (set, frozenset)):
         raise TypeError('tags must be a set')
     if not isinstance(pos_filter, PosFilter):
         raise TypeError('pos_filter must be a PosFilter')
     if parent == NodeID.root_id:
         stmt = """
             SELECT id FROM node WHERE parent IS NULL
         """
         args = ()
     else:
         stmt = """
             SELECT id FROM node WHERE parent = ?
         """
         args = (buffer(parent.bytes), )
     for tag in tags:
         if not isinstance(tag, six.text_type):
             raise TypeError('tag is not a string')
         stmt += """ AND EXISTS (
             SELECT 1 FROM node_tag
             WHERE node_tag.id = node.id AND name = ?
         )"""
         args += (tag,)
     if pos_filter.start_from is not None:
         stmt += " AND pos_start >= ?"
         args += (db_bigint_encode(pos_filter.start_from),)
     if pos_filter.start_to is not None:
         stmt += " AND (pos_start <= ? OR pos_start IS NULL)"
         args += (db_bigint_encode(pos_filter.start_to),)
     if pos_filter.end_from is not None:
         stmt += " AND (pos_end >= ? OR pos_end is NULL)"
         args += (db_bigint_encode(pos_filter.end_from),)
     if pos_filter.end_to is not None:
         stmt += " AND pos_end <= ?"
         args += (db_bigint_encode(pos_filter.end_to),)
     c = self.db.cursor()
     c.execute(stmt, args)
     return {NodeID(bytes(x)) for x, in c.fetchall()}
コード例 #14
0
 def test_tags(self):
     db = DbBackend(None)
     node = Node(id=NodeID(),
                 tags={'abc', 'def', 'ghi'},
                 attr={},
                 pos_start=0x123,
                 pos_end=0x456,
                 data={'my_key'},
                 bindata={'my_bindata': 12345})
     db.create(node)
     n2 = db.get(node.id)
     self.assertEqual(n2.tags, {'abc', 'def', 'ghi'})
     db.add_tag(node.id, 'abc')
     db.add_tag(node.id, 'jkl')
     db.del_tag(node.id, 'def')
     db.del_tag(node.id, 'mno')
     n3 = db.get(node.id)
     self.assertEqual(n3.tags, {'abc', 'ghi', 'jkl'})
     with self.assertRaises(TypeError):
         db.add_tag(node.id, b'zlew')
     with self.assertRaises(TypeError):
         db.add_tag(node.id, 123)
     with self.assertRaises(TypeError):
         db.del_tag(node.id, 123)
コード例 #15
0
ファイル: test_nodeid.py プロジェクト: yuttasakcom/veles
 def test_restricted(self):
     with self.assertRaises(ValueError):
         NodeID(b'\x00'*NodeID.WIDTH)
     with self.assertRaises(ValueError):
         NodeID.from_hex('00'*NodeID.WIDTH)
コード例 #16
0
ファイル: test_nodeid.py プロジェクト: yuttasakcom/veles
 def test_from_hex(self):
     obj = NodeID.from_hex('1112'*(NodeID.WIDTH//2))
     self.assertEqual(b'\x11\x12'*(NodeID.WIDTH//2), obj.bytes)
コード例 #17
0
ファイル: test_pos_filter.py プロジェクト: yuttasakcom/veles
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

import unittest

from veles.schema.nodeid import NodeID
from veles.proto.node import Node, PosFilter

NODES = [
    Node(id=NodeID()),
    Node(id=NodeID(), pos_start=17),
    Node(id=NodeID(), pos_end=17),
    Node(id=NodeID(), pos_start=0x123456789abcdef123456789),
    Node(id=NodeID(), pos_start=10, pos_end=20),
    Node(id=NodeID(), pos_start=20, pos_end=30),
    Node(id=NodeID(), pos_start=30, pos_end=40),
    Node(id=NodeID(), pos_start=10, pos_end=40),
    Node(id=NodeID(), pos_start=20),
    Node(id=NodeID(), pos_start=20, pos_end=20),
]
CASES = [
    (PosFilter(), [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]),
    (PosFilter(start_from=9), [1, 3, 4, 5, 6, 7, 8, 9]),
    (PosFilter(start_from=10), [1, 3, 4, 5, 6, 7, 8, 9]),
    (PosFilter(start_from=11), [1, 3, 5, 6, 8, 9]),
コード例 #18
0
 def test_attr(self):
     db = DbBackend(None)
     id2 = NodeID()
     node = Node(id=NodeID(),
                 tags={'my_tag'},
                 attr={
                     'int': 123,
                     'bool': False,
                     'bytes': b'\x01\x02\x03',
                     'str': 'abc',
                     'list': (1, 2, 3),
                     'dict': {
                         'a': 'b',
                         'c': 'd'
                     },
                     'id': id2,
                     'bindata': BinData.from_spaced_hex(12, '123 456'),
                     'long': 0x123456789abcdef123456789abcdef,
                     'neglong': -0x123456789abcdef123456789abcdef,
                 },
                 pos_start=0x123,
                 pos_end=0x456,
                 data={'my_key'},
                 bindata={'my_bindata': 12345})
     db.create(node)
     n2 = db.get(node.id)
     self.assertEqual(
         set(n2.attr.keys()), {
             'int',
             'bool',
             'bytes',
             'str',
             'list',
             'dict',
             'id',
             'bindata',
             'long',
             'neglong',
         })
     self.assertEqual(n2.attr['int'], 123)
     self.assertEqual(n2.attr['bool'], False)
     self.assertNotIn('none', n2.attr)
     self.assertNotIn('meh', n2.attr)
     b = n2.attr['bytes']
     s = n2.attr['str']
     self.assertEqual(b, b'\x01\x02\x03')
     self.assertEqual(s, 'abc')
     self.assertIsInstance(b, bytes)
     self.assertIsInstance(s, six.text_type)
     self.assertEqual(n2.attr['list'], [1, 2, 3])
     self.assertEqual(n2.attr['dict'], {'a': 'b', 'c': 'd'})
     self.assertEqual(n2.attr['id'], id2)
     self.assertEqual(n2.attr['bindata'],
                      BinData.from_spaced_hex(12, '123 456'))
     self.assertEqual(n2.attr['long'], 0x123456789abcdef123456789abcdef)
     self.assertEqual(n2.attr['neglong'], -0x123456789abcdef123456789abcdef)
     db.set_attr(node.id, 'int', None)
     db.set_attr(node.id, 'bool', True)
     db.set_attr(node.id, 'meh', 'meh')
     n3 = db.get(node.id)
     self.assertEqual(
         set(n3.attr.keys()), {
             'meh',
             'bool',
             'bytes',
             'str',
             'list',
             'dict',
             'id',
             'bindata',
             'long',
             'neglong',
         })
     self.assertEqual(n3.attr['bool'], True)
     self.assertEqual(n3.attr['meh'], 'meh')
     with self.assertRaises(TypeError):
         db.set_attr(node.id, b'zlew', 'zlew')
     with self.assertRaises(TypeError):
         db.set_attr(node.id, 123, 456)
     with self.assertRaises(TypeError):
         db.set_attr(node.id, 123, 456)
コード例 #19
0
 def test_data(self):
     db = DbBackend(None)
     node = Node(id=NodeID(),
                 tags={'my_tag'},
                 attr={'my_attr': 'my_val'},
                 pos_start=0x123,
                 pos_end=0x456,
                 data={'my_key'},
                 bindata={'my_bindata': 12345})
     id2 = NodeID()
     db.create(node)
     db.set_data(node.id, 'int', 123)
     db.set_data(node.id, 'bool', False)
     db.set_data(node.id, 'none', None)
     db.set_data(node.id, 'bytes', b'\x01\x02\x03')
     db.set_data(node.id, 'str', 'abc')
     db.set_data(node.id, 'list', (1, 2, 3))
     db.set_data(node.id, 'dict', {'a': 'b', 'c': 'd'})
     db.set_data(node.id, 'id', id2)
     db.set_data(node.id, 'bindata', BinData.from_spaced_hex(12, '123 456'))
     db.set_data(node.id, 'long', 0x123456789abcdef123456789abcdef)
     db.set_data(node.id, 'neglong', -0x123456789abcdef123456789abcdef)
     n2 = db.get(node.id)
     self.assertEqual(
         n2.data, {
             'int',
             'bool',
             'bytes',
             'str',
             'list',
             'dict',
             'id',
             'bindata',
             'long',
             'neglong',
         })
     self.assertEqual(db.get_data(node.id, 'int'), 123)
     self.assertEqual(db.get_data(node.id, 'bool'), False)
     self.assertEqual(db.get_data(node.id, 'none'), None)
     self.assertEqual(db.get_data(node.id, 'meh'), None)
     b = db.get_data(node.id, 'bytes')
     s = db.get_data(node.id, 'str')
     self.assertEqual(b, b'\x01\x02\x03')
     self.assertEqual(s, 'abc')
     self.assertIsInstance(b, bytes)
     self.assertIsInstance(s, six.text_type)
     self.assertEqual(db.get_data(node.id, 'list'), [1, 2, 3])
     self.assertEqual(db.get_data(node.id, 'dict'), {'a': 'b', 'c': 'd'})
     self.assertEqual(db.get_data(node.id, 'id'), id2)
     self.assertEqual(db.get_data(node.id, 'bindata'),
                      BinData.from_spaced_hex(12, '123 456'))
     self.assertEqual(db.get_data(node.id, 'long'),
                      0x123456789abcdef123456789abcdef)
     self.assertEqual(db.get_data(node.id, 'neglong'),
                      -0x123456789abcdef123456789abcdef)
     with self.assertRaises(TypeError):
         db.set_data(node.id, b'zlew', 'zlew')
     with self.assertRaises(TypeError):
         db.set_data(node.id, 123, 456)
     with self.assertRaises(TypeError):
         db.get_data(node.id, b'zlew')
     with self.assertRaises(TypeError):
         db.get_data(node.id, 123)
コード例 #20
0
 def test_bindata(self):
     db = DbBackend(None)
     node = Node(id=NodeID(),
                 tags=set(),
                 attr={},
                 pos_start=None,
                 pos_end=None,
                 data=set(),
                 bindata={'my_bindata': 12345})
     db.create(node)
     db.set_bindata(node.id, 'one', start=0, data=b'')
     db.set_bindata(node.id, 'two', start=0, data=b'\x12\x34\x56')
     db.set_bindata(node.id, 'three', start=0, data=b'\x11' * 0x123456)
     n2 = db.get(node.id)
     self.assertEqual(n2.bindata, {
         'two': 3,
         'three': 0x123456,
     })
     self.assertEqual(db.get_bindata(node.id, 'one'), b'')
     self.assertEqual(db.get_bindata(node.id, 'one', start=3), b'')
     self.assertEqual(db.get_bindata(node.id, 'one', start=3, end=15), b'')
     self.assertEqual(db.get_bindata(node.id, 'two'), b'\x12\x34\x56')
     self.assertEqual(db.get_bindata(node.id, 'two', start=2), b'\x56')
     self.assertEqual(db.get_bindata(node.id, 'two', start=4), b'')
     self.assertEqual(db.get_bindata(node.id, 'two', start=1, end=2),
                      b'\x34')
     self.assertEqual(db.get_bindata(node.id, 'two', start=1, end=6),
                      b'\x34\x56')
     self.assertEqual(db.get_bindata(node.id, 'three'), b'\x11' * 0x123456)
     db.set_bindata(node.id, 'one', start=0, data=b'\x11\x22')
     self.assertEqual(db.get_bindata(node.id, 'one'), b'\x11\x22')
     db.set_bindata(node.id, 'one', start=1, data=b'\x33\x44\x55')
     self.assertEqual(db.get_bindata(node.id, 'one'), b'\x11\x33\x44\x55')
     db.set_bindata(node.id, 'one', start=2, data=b'\x66')
     self.assertEqual(db.get_bindata(node.id, 'one'), b'\x11\x33\x66\x55')
     db.set_bindata(node.id, 'one', start=2, data=b'\x77', truncate=True)
     self.assertEqual(db.get_bindata(node.id, 'one'), b'\x11\x33\x77')
     n2 = db.get(node.id)
     self.assertIn('one', n2.bindata)
     db.set_bindata(node.id, 'one', start=0, data=b'', truncate=True)
     self.assertEqual(db.get_bindata(node.id, 'one'), b'')
     n2 = db.get(node.id)
     self.assertNotIn('one', n2.bindata)
     db.set_bindata(node.id, 'three', start=0x12345, data=b'\x22' * 0x789ab)
     n2 = db.get(node.id)
     self.assertEqual(n2.bindata['three'], 0x123456)
     correct = (b'\x11' * 0x12345 + b'\x22' * 0x789ab + b'\x11' *
                (0x123456 - 0x789ab - 0x12345))
     self.assertEqual(db.get_bindata(node.id, 'three'), correct)
     with self.assertRaises(WritePastEndError):
         db.set_bindata(node.id, 'three', start=0x1234567, data=b'\x33')
     with self.assertRaises(ValueError):
         db.set_bindata(node.id, 'three', start=-1, data=b'\x33')
     db.set_bindata(node.id,
                    'three',
                    start=0x123456,
                    data=b'\x33' * 0x789ab)
     n2 = db.get(node.id)
     self.assertEqual(n2.bindata['three'], 0x123456 + 0x789ab)
     correct = (b'\x11' * 0x12345 + b'\x22' * 0x789ab + b'\x11' *
                (0x123456 - 0x789ab - 0x12345) + b'\x33' * 0x789ab)
     self.assertEqual(db.get_bindata(node.id, 'three'), correct)
     db.set_bindata(node.id,
                    'three',
                    start=0x6789a,
                    data=b'\x44' * 0x789ab,
                    truncate=True)
     n2 = db.get(node.id)
     self.assertEqual(n2.bindata['three'], 0x6789a + 0x789ab)
     correct = (b'\x11' * 0x12345 + b'\x22' * (0x6789a - 0x12345) +
                b'\x44' * 0x789ab)
     self.assertEqual(db.get_bindata(node.id, 'three'), correct)
     self.assertEqual(db.get_bindata(node.id, 'three', start=0x789ab),
                      b'\x44' * 0x6789a)
     self.assertEqual(
         db.get_bindata(node.id, 'three', start=0x789ab, end=0xdeadbeef),
         b'\x44' * 0x6789a)
     self.assertEqual(
         db.get_bindata(node.id, 'three', start=0x55555, end=0x88888),
         b'\x22' * 0x12345 + b'\x44' * (0x33333 - 0x12345))
     db.set_bindata(node.id, 'three', start=0x1234, data=b'', truncate=True)
     n2 = db.get(node.id)
     self.assertEqual(n2.bindata['three'], 0x1234)
     correct = b'\x11' * 0x1234
     self.assertEqual(db.get_bindata(node.id, 'three'), correct)
     with self.assertRaises(TypeError):
         db.set_bindata(node.id, b'zlew', 0, b'zlew')
     with self.assertRaises(TypeError):
         db.set_bindata(node.id, 'abc', 0, 'zlew')
     with self.assertRaises(TypeError):
         db.set_bindata(node.id, 'abc', 0, 1234)
     with self.assertRaises(TypeError):
         db.set_bindata(node.id, 'zlew', b'zlew', b'zlew')
     with self.assertRaises(TypeError):
         db.set_bindata(node.id, 'zlew', 0, b'zlew', truncate='zlew')
     with self.assertRaises(TypeError):
         db.get_bindata(node.id, b'zlew')
     with self.assertRaises(TypeError):
         db.get_bindata(node.id, 123)