コード例 #1
0
ファイル: test_mappers.py プロジェクト: josegutab/scipion
    def test_SqliteDb(self):
        """ Test the SqliteDb class that is used by the sqlite mappers. """
        from pyworkflow.mapper.sqlite_db import SqliteDb

        db = SqliteDb()
        db._createConnection(self.modelGoldSqlite, timeout=1000)

        tables = ["Objects", "Relations"]
        self.assertEqual(tables, db.getTables())

        db.close()
コード例 #2
0
ファイル: test_mappers.py プロジェクト: azazellochg/scipion
 def test_SqliteDb(self):
     """ Test the SqliteDb class that is used by the sqlite mappers. """
     db = SqliteDb()
     db._createConnection(self.modelGoldSqlite, timeout=1000)
     
     tables = ['Objects', 'Relations']
     self.assertEqual(tables, db.getTables())
     
     # Test getting the version, for the gold file it should be 0
     self.assertEqual(0, db.getVersion())
     
     db.close()
コード例 #3
0
ファイル: test_mappers.py プロジェクト: EyeSeeTea/scipion-web
    def test_SqliteDb(self):
        """ Test the SqliteDb class that is used by the sqlite mappers. """
        db = SqliteDb()
        db._createConnection(self.modelGoldSqlite, timeout=1000)

        tables = ['Objects', 'Relations']
        self.assertEqual(tables, db.getTables())

        # Test getting the version, for the gold file it should be 0
        self.assertEqual(0, db.getVersion())

        db.close()
コード例 #4
0
ファイル: test_mappers.py プロジェクト: azazellochg/scipion
    def test_SqliteMapper(self):
        fn = self.getOutputPath("basic.sqlite")
        fnGoldCopy = self.getOutputPath('gold.sqlite')
        fnGold = self.modelGoldSqlite
        
        print ">>> Using db: ", fn
        print "        gold: ", fnGold
        print "   gold copy: ", fnGoldCopy
        
        pwutils.copyFile(fnGold, fnGoldCopy)

        mapper = SqliteMapper(fn)
        # Insert a Complex
        c = Complex.createComplex() # real = 1, imag = 1
        mapper.insert(c)
        # Insert an Integer
        i = Integer(1)
        mapper.insert(i)
        # Insert two Boolean
        b = Boolean(False)
        b2 = Boolean(True)
        mapper.insert(b)
        mapper.insert(b2)
        #Test storing pointers
        p = Pointer()
        p.set(c)
        mapper.insert(p)
        
        # Store csv list
        strList = ['1', '2', '3']
        csv = CsvList()
        csv += strList
        mapper.insert(csv)
        
        # Test normal List
        iList = List()
        mapper.insert(iList) # Insert the list when empty        
        
        i1 = Integer(4)
        i2 = Integer(3)
        iList.append(i1)
        iList.append(i2)
        
        mapper.update(iList) # now update with some items inside
        
        pList = PointerList()
        p1 = Pointer()
        p1.set(b)
        p2 = Pointer()
        p2.set(b2)
        pList.append(p1)
        pList.append(p2)
        
        mapper.store(pList)
        

        # Test to add relations
        relName = 'testRelation'
        creator = c
        mapper.insertRelation(relName, creator, i, b)
        mapper.insertRelation(relName, creator, i, b2)
        
        mapper.insertRelation(relName, creator, b, p)
        mapper.insertRelation(relName, creator, b2, p)        
        
        # Save changes to file
        mapper.commit()
        self.assertEqual(1, mapper.db.getVersion())

        # Intentionally keep gold.sqlite as version 0 to check
        # backward compatibility
        db = SqliteDb()
        db._createConnection(fnGold, timeout=1000)
        print "Checking old version is properly read"
        self.assertEqual(0, db.getVersion())
        colNamesGold = [u'id', u'parent_id', u'name', u'classname', 
                        u'value', u'label', u'comment', u'object_parent_id', 
                        u'object_child_id', u'creation']
        colNames = [col[1] for col in db.getTableColumns('Relations')]
        self.assertEqual(colNamesGold, colNames)
        
        # Reading test
        mapper2 = SqliteMapper(fnGoldCopy, globals())
        print "Checking that Relations table is updated and version to 1"
        self.assertEqual(1, mapper2.db.getVersion())
        # Check that the new column is properly added after updated to version 1
        colNamesGold += [u'object_parent_extended', u'object_child_extended']
        colNames = [col[1] for col in mapper2.db.getTableColumns('Relations')]
        self.assertEqual(colNamesGold, colNames)
        
        l = mapper2.selectByClass('Integer')[0]
        self.assertEqual(l.get(), 1)

        c2 = mapper2.selectByClass('Complex')[0]
        self.assertTrue(c.equalAttributes(c2))
        
        b = mapper2.selectByClass('Boolean')[0]
        self.assertTrue(not b.get())

        p = mapper2.selectByClass('Pointer')[0]
        self.assertEqual(c, p.get())
        
        csv2 = mapper2.selectByClass('CsvList')[0]
        self.assertTrue(list.__eq__(csv2, strList))
        
        # Iterate over all objects
        allObj = mapper2.selectAll()
        iterAllObj = mapper2.selectAll(iterate=True)

        for a1, a2 in zip(allObj, iterAllObj):
            # Note compare the scalar objects, which have a well-defined comparison
            if isinstance(a1, Scalar):
                self.assertEqual(a1, a2)
            
        # Test relations
        childs = mapper2.getRelationChilds(relName, i)
        parents = mapper2.getRelationParents(relName, p)
        # In this case both childs and parent should be the same
        for c, p in zip(childs, parents):
            self.assertEqual(c, p, "Childs of object i, should be the parents of object p")

        relations = mapper2.getRelationsByCreator(creator)
        for row in relations:
            print row
コード例 #5
0
ファイル: test_mappers.py プロジェクト: EyeSeeTea/scipion-web
    def test_SqliteMapper(self):
        fn = self.getOutputPath("basic.sqlite")
        fnGoldCopy = self.getOutputPath('gold.sqlite')
        fnGold = self.modelGoldSqlite

        print ">>> Using db: ", fn
        print "        gold: ", fnGold
        print "   gold copy: ", fnGoldCopy

        pwutils.copyFile(fnGold, fnGoldCopy)

        mapper = SqliteMapper(fn)
        # Insert a Complex
        c = Complex.createComplex()  # real = 1, imag = 1
        mapper.insert(c)
        # Insert an Integer
        i = Integer(1)
        mapper.insert(i)
        # Insert two Boolean
        b = Boolean(False)
        b2 = Boolean(True)
        mapper.insert(b)
        mapper.insert(b2)
        #Test storing pointers
        p = Pointer()
        p.set(c)
        mapper.insert(p)

        # Store csv list
        strList = ['1', '2', '3']
        csv = CsvList()
        csv += strList
        mapper.insert(csv)

        # Test normal List
        iList = List()
        mapper.insert(iList)  # Insert the list when empty

        i1 = Integer(4)
        i2 = Integer(3)
        iList.append(i1)
        iList.append(i2)

        mapper.update(iList)  # now update with some items inside

        pList = PointerList()
        p1 = Pointer()
        p1.set(b)
        p2 = Pointer()
        p2.set(b2)
        pList.append(p1)
        pList.append(p2)

        mapper.store(pList)

        # Test to add relations
        relName = 'testRelation'
        creator = c
        mapper.insertRelation(relName, creator, i, b)
        mapper.insertRelation(relName, creator, i, b2)

        mapper.insertRelation(relName, creator, b, p)
        mapper.insertRelation(relName, creator, b2, p)

        # Save changes to file
        mapper.commit()
        self.assertEqual(1, mapper.db.getVersion())

        # Intentionally keep gold.sqlite as version 0 to check
        # backward compatibility
        db = SqliteDb()
        db._createConnection(fnGold, timeout=1000)
        print "Checking old version is properly read"
        self.assertEqual(0, db.getVersion())
        colNamesGold = [
            u'id', u'parent_id', u'name', u'classname', u'value', u'label',
            u'comment', u'object_parent_id', u'object_child_id', u'creation'
        ]
        colNames = [col[1] for col in db.getTableColumns('Relations')]
        self.assertEqual(colNamesGold, colNames)

        # Reading test
        mapper2 = SqliteMapper(fnGoldCopy, globals())
        print "Checking that Relations table is updated and version to 1"
        self.assertEqual(1, mapper2.db.getVersion())
        # Check that the new column is properly added after updated to version 1
        colNamesGold += [u'object_parent_extended', u'object_child_extended']
        colNames = [col[1] for col in mapper2.db.getTableColumns('Relations')]
        self.assertEqual(colNamesGold, colNames)

        l = mapper2.selectByClass('Integer')[0]
        self.assertEqual(l.get(), 1)

        c2 = mapper2.selectByClass('Complex')[0]
        self.assertTrue(c.equalAttributes(c2))

        b = mapper2.selectByClass('Boolean')[0]
        self.assertTrue(not b.get())

        p = mapper2.selectByClass('Pointer')[0]
        self.assertEqual(c, p.get())

        csv2 = mapper2.selectByClass('CsvList')[0]
        self.assertTrue(list.__eq__(csv2, strList))

        # Iterate over all objects
        allObj = mapper2.selectAll()
        iterAllObj = mapper2.selectAll(iterate=True)

        for a1, a2 in zip(allObj, iterAllObj):
            # Note compare the scalar objects, which have a well-defined comparison
            if isinstance(a1, Scalar):
                self.assertEqual(a1, a2)

        # Test relations
        childs = mapper2.getRelationChilds(relName, i)
        parents = mapper2.getRelationParents(relName, p)
        # In this case both childs and parent should be the same
        for c, p in zip(childs, parents):
            self.assertEqual(
                c, p, "Childs of object i, should be the parents of object p")

        relations = mapper2.getRelationsByCreator(creator)
        for row in relations:
            print row