本文整理汇总了Python中qgis.core.QgsRelation.setReferencedLayer方法的典型用法代码示例。如果您正苦于以下问题:Python QgsRelation.setReferencedLayer方法的具体用法?Python QgsRelation.setReferencedLayer怎么用?Python QgsRelation.setReferencedLayer使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类qgis.core.QgsRelation
的用法示例。
在下文中一共展示了QgsRelation.setReferencedLayer方法的14个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: testRelations
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def testRelations(self):
""" check that layers are shown in widget model"""
p = QgsProject.instance()
# not valid, but doesn't matter for test....
rel = QgsRelation()
rel.setId('rel1')
rel.setName('Relation Number One')
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair('foreignkey', 'y')
rel2 = QgsRelation()
rel2.setId('rel2')
rel2.setName('Relation Number Two')
rel2.setReferencingLayer(self.referencingLayer.id())
rel2.setReferencedLayer(self.referencedLayer.id())
rel2.addFieldPair('foreignkey', 'y')
p.relationManager().addRelation(rel)
p.relationManager().addRelation(rel2)
w = QgsExpressionBuilderWidget()
m = w.model()
# check that relations are shown
items = m.findItems('Relation Number One', Qt.MatchRecursive)
self.assertEqual(len(items), 1)
items = m.findItems('Relation Number Two', Qt.MatchRecursive)
self.assertEqual(len(items), 1)
示例2: test_fieldPairs
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_fieldPairs(self):
rel = QgsRelation()
rel.setRelationId("rel1")
rel.setRelationName("Relation Number One")
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair("foreignkey", "y")
assert rel.fieldPairs() == {"foreignkey": "y"}
示例3: test_getRelatedFeaturesWithQuote
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_getRelatedFeaturesWithQuote(self):
rel = QgsRelation()
rel.setId('rel1')
rel.setName('Relation Number One')
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair('fldtxt', 'x')
feat = self.referencedLayer.getFeature(3)
it = rel.getRelatedFeatures(feat)
assert next(it).attributes() == ["foobar'bar", 124]
示例4: test_getReferencedFeature
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_getReferencedFeature(self):
rel = QgsRelation()
rel.setRelationId("rel1")
rel.setRelationName("Relation Number One")
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair("foreignkey", "y")
feat = next(self.referencingLayer.getFeatures())
f = rel.getReferencedFeature(feat)
assert f.isValid()
assert f[0] == "foo"
示例5: test_getRelatedFeatures
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_getRelatedFeatures(self):
rel = QgsRelation()
rel.setRelationId('rel1')
rel.setRelationName('Relation Number One')
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair('foreignkey', 'y')
feat = self.referencedLayer.getFeatures().next()
it = rel.getRelatedFeatures(feat)
assert [a.attributes() for a in it] == [[u'test1', 123], [u'test2', 123]]
示例6: test_getRelatedFeatures
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_getRelatedFeatures(self):
rel = QgsRelation()
rel.setId('rel1')
rel.setName('Relation Number One')
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair('foreignkey', 'y')
feat = next(self.referencedLayer.getFeatures())
self.assertEqual(rel.getRelatedFeaturesFilter(feat), '"foreignkey" = 123')
it = rel.getRelatedFeatures(feat)
assert [a.attributes() for a in it] == [['test1', 123], ['test2', 123]]
示例7: test_fieldPairs
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_fieldPairs(self):
referencedLayer = createReferencedLayer()
referencingLayer = createReferencingLayer()
QgsMapLayerRegistry.instance().addMapLayers([referencedLayer,referencingLayer])
rel = QgsRelation()
rel.setRelationId( 'rel1' )
rel.setRelationName( 'Relation Number One' )
rel.setReferencingLayer( referencingLayer.id() )
rel.setReferencedLayer( referencedLayer.id() )
rel.addFieldPair( 'foreignkey', 'y' )
assert( rel.fieldPairs() == { 'foreignkey': 'y'} )
QgsMapLayerRegistry.instance().removeAllMapLayers()
示例8: test_isValid
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_isValid(self):
rel = QgsRelation()
assert not rel.isValid()
rel.setRelationId("rel1")
assert not rel.isValid()
rel.setRelationName("Relation Number One")
assert not rel.isValid()
rel.setReferencingLayer(self.referencingLayer.id())
assert not rel.isValid()
rel.setReferencedLayer(self.referencedLayer.id())
assert not rel.isValid()
rel.addFieldPair("foreignkey", "y")
assert rel.isValid()
示例9: test_getRelatedFeatures
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def test_getRelatedFeatures(self):
referencedLayer = createReferencedLayer()
referencingLayer = createReferencingLayer()
QgsMapLayerRegistry.instance().addMapLayers([referencedLayer,referencingLayer])
rel = QgsRelation()
rel.setRelationId( 'rel1' )
rel.setRelationName( 'Relation Number One' )
rel.setReferencingLayer( referencingLayer.id() )
rel.setReferencedLayer( referencedLayer.id() )
rel.addFieldPair( 'foreignkey', 'y' )
feat = referencedLayer.getFeatures().next()
it = rel.getRelatedFeatures( feat )
[ a.attributes() for a in it ] == [[u'test1', 123], [u'test2', 123]]
QgsMapLayerRegistry.instance().removeAllMapLayers()
示例10: import_in_qgis
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
#.........这里部分代码省略.........
for viewer_cls, _ in get_custom_viewers().values():
tag = no_prefix(viewer_cls.xml_tag())
if tag == xpath:
lg = CustomViewerLegend(viewer_cls.name(), viewer_cls.icon())
l.setLegend(lg)
# restore settings
settings.setValue("Projections/defaultBehavior", projection_behavior)
settings.setValue("Projections/layerDefaultCrs", projection_default)
# add 1:1 relations
relations_1_1 = []
sql = """
select
layer_name, field_name, field_related_layer, r.child_pkid
from
{0}_ogr_fields_metadata f
join {0}_ogr_layer_relationships r
on r.parent_layer = f.layer_name
and r.parent_element_name = f.field_name
where
field_category in ('PATH_TO_CHILD_ELEMENT_WITH_LINK', 'PATH_TO_CHILD_ELEMENT_NO_LINK')
and field_max_occurs=1
""".format(schema_s)
l = ds.ExecuteSQL(sql)
if l is not None:
for f in l:
rel = QgsRelation()
rel.setId('1_1_' + f.GetField('layer_name') + '_' + f.GetField('field_name'))
rel.setName('1_1_' + f.GetField('layer_name') + '_' + f.GetField('field_name'))
# parent layer
rel.setReferencingLayer(layers[f.GetField('layer_name')]['layer_id'])
# child layer
rel.setReferencedLayer(layers[f.GetField('field_related_layer')]['layer_id'])
# parent, child
rel.addFieldPair(f.GetField('field_name'), f.GetField('child_pkid'))
#rel.generateId()
if rel.isValid():
relations_1_1.append(rel)
# add 1:N relations
relations_1_n = []
sql = """
select
layer_name, r.parent_pkid, field_related_layer as child_layer, r.child_pkid
from
{0}_ogr_fields_metadata f
join {0}_ogr_layer_relationships r
on r.parent_layer = f.layer_name
and r.child_layer = f.field_related_layer
where
field_category in ('PATH_TO_CHILD_ELEMENT_WITH_LINK', 'PATH_TO_CHILD_ELEMENT_NO_LINK')
and field_max_occurs>1
-- junctions - 1st way
union all
select
layer_name, r.parent_pkid, field_junction_layer as child_layer, 'parent_pkid' as child_pkid
from
{0}_ogr_fields_metadata f
join {0}_ogr_layer_relationships r
on r.parent_layer = f.layer_name
and r.child_layer = f.field_related_layer
where
field_category = 'PATH_TO_CHILD_ELEMENT_WITH_JUNCTION_TABLE'
-- junctions - 2nd way
union all
示例11: open_db
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
#.........这里部分代码省略.........
geom_table_column_dict = dict(GEOMETRY_TABLES_COLUMNS)
for table in TABLES:
if not table_in_db(self.cur, table):
iface.messageBar().pushMessage(
"Warning",
"Table %s not found in edb" % table,
level=QgsMessageBar.WARNING,
duration=3
)
continue
geom_col = geom_table_column_dict.get(table, None)
self.db_uri.setDataSource(
schema,
table,
geom_col or ''
)
layer_uri = self.db_uri.uri() # + "&crs=EPSG:4326"
layer = QgsVectorLayer(layer_uri, table, 'spatialite')
layer.setCrs(QgsCoordinateReferenceSystem(
self.epsg,
QgsCoordinateReferenceSystem.EpsgCrsId)
)
if not layer.isValid():
raise ValueError(edb_filename)
map_layer = QgsMapLayerRegistry.instance().addMapLayer(
layer, False
)
if 'timevar' in table:
group = timevar_group
elif 'emission_function' in table:
group = emis_func_group
elif 'searchkey' in table:
group = searchkey_group
elif 'unit' in table:
group = unit_group
elif 'subgrp' in table:
group = subgrp_group
elif table == 'substances':
group = subtable_group
elif table.endswith('_emis'):
group = emis_group
elif table == 'points':
group = point_group
elif 'point_' in table:
group = point_support_group
elif table == 'areas':
group = area_group
elif 'area_' in table:
group = area_support_group
elif table == 'roads':
group = road_group
elif table in ('road_vehicle_link', 'road_alobs'):
group = road_support_group
elif 'road_' in table:
group = road_vehicle_group
elif 'roadtype' in table:
group = roadtype_group
elif table == 'facilties':
group = facility_group
elif 'facility' in table:
group = facility_support_group
elif 'companies' == table:
group = company_group
elif 'company' in table:
group = company_support_group
elif 'traffic_situation' in table:
group = road_vehicle_support_group
group.setVisible(False)
group.setExpanded(False)
group.addLayer(map_layer)
self.layers[table] = map_layer.id()
for table in TABLES:
foreign_keys = get_foreign_keys(self.con, table)
referencing_layer = self.layers[table]
for row in foreign_keys:
referenced_layer = self.layers[row['table']]
from_column = row['from']
to_column = row['to']
rel = QgsRelation()
rel.setReferencingLayer(referencing_layer)
rel.setReferencedLayer(referenced_layer)
rel.addFieldPair(from_column, to_column)
rel_name = 'fk_%s_%s-%s_%s' % (
table, from_column, row['table'], to_column
)
rel.setRelationId(rel_name)
rel.setRelationName(
'fk_%s_%s-%s_%s' % (
table, from_column, row['table'], to_column)
)
if not rel.isValid():
raise ValueError(
'Reference %s is invalid' % rel_name
)
QgsProject.instance().relationManager().addRelation(rel)
示例12: applyJoin
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def applyJoin(self):
self.dlg.show()
selectedFields = self.getSelFieldList() or []
if self.dlg.targetLayerCombo.currentText()[:6] != 'Select' and self.dlg.joinLayerCombo.currentText()[:6] != 'Select' and self.dlg.spatialTypeCombo.currentText()[:6] != 'Select':
targetLayer = self.layerSet[self.dlg.targetLayerCombo.currentText()]
joinLayer = self.layerSet[self.dlg.joinLayerCombo.currentText()]
joinLayerFields = [field.name() for field in joinLayer.pendingFields()]
#targetLayerFields = [field.name() for field in targetLayer.pendingFields()]
targetLayerFields = []
for field in targetLayer.pendingFields():
if field.name()[0:7] == 'spjoin_':
idx = targetLayer.pendingFields().fieldNameIndex(field.name())
self.tra.ce("removing:"+field.name()+str(idx))
targetLayer.dataProvider().deleteAttributes([idx])
targetLayer.removeExpressionField(idx)
else:
targetLayerFields.append(field.name())
self.tra.ce(targetLayerFields)
targetLayer.updateFields()
joinField = 'spjoin_rif'
exp = "geom"+self.dlg.spatialTypeCombo.currentText()+"('"+joinLayer.name()+"','$id')"
self.tra.ce( exp)
#add a rif field if build relation requested
if self.dlg.checkBuildRelation.checkState() == Qt.Checked:
#joinLayer.addExpressionField('$id', QgsField('spjoin_rif', QVariant.Int))
joinLayer.dataProvider().addAttributes([QgsField(joinField, QVariant.Int)])
#joinLayer.updateFields()
idx = joinLayer.dataProvider().fields().fieldNameIndex(joinField)
expObj = QgsExpression('$id')
changes = {}
for feature in joinLayer.getFeatures():
value = expObj.evaluate(feature)
#joinLayer.dataProvider().changeAttributeValues({feature.id():{idx:value}})
changes[feature.id()] = {idx:value}
joinLayer.dataProvider().changeAttributeValues(changes)
if self.dlg.checkDynamicJoin.checkState() == Qt.Checked:
targetLayer.addExpressionField(exp, QgsField(joinField, QVariant.Int))
else:
#Create static rif field
targetLayer.dataProvider().addAttributes([QgsField(joinField, QVariant.Int)])
#targetLayer.updateFields()
F = [field.name() for field in targetLayer.dataProvider().fields()]
self.tra.ce(F)
#Compile spatial expression to get feature rifs
expObj = QgsExpression(exp)
expObj.prepare(targetLayer.pendingFields())
idx = targetLayer.dataProvider().fields().fieldNameIndex(joinField)
self.tra.ce( "new " + joinField + str(idx))
changes = {}
#init progress bar
self.dlg.progressBar.setMinimum(0)
self.dlg.progressBar.setMaximum(targetLayer.featureCount())
#cicle into feature to build mod vector
for count, feature in enumerate(targetLayer.getFeatures()):
self.dlg.progressBar.setValue(count)
value = expObj.evaluate(feature)
changes[feature.id()] = {idx:value}
self.tra.ce(changes)
#apply mod vector
targetLayer.dataProvider().changeAttributeValues(changes)
targetLayer.updateFields()
#build expression fields to connect to join field rif
for f in selectedFields:
fieldType = joinLayer.pendingFields().field(f).type()
exp = """dbvaluebyid('%s','%s',"%s")""" %(joinLayer.name(),f,joinField)
self.tra.ce(exp)
targetLayer.addExpressionField(exp, QgsField('spjoin_'+f, fieldType))
targetLayer.updateFields()
if self.dlg.checkBuildRelation.checkState() == Qt.Checked:
jRel = QgsRelation()
jRel.setRelationId(targetLayer.name()+"_"+str(uuid.uuid1()))
jRel.setRelationName("%s_%s-rif_%s" % (targetLayer.name(),self.dlg.spatialTypeCombo.currentText(),joinLayer.name()))
jRel.setReferencedLayer(joinLayer.id())
jRel.setReferencingLayer(targetLayer.id())
jRel.addFieldPair('spjoin_rif','spjoin_rif')
QgsProject.instance().relationManager().addRelation(jRel)
self.dlg.hide()
示例13: createRelation
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def createRelation(self):
rel = QgsRelation()
rel.setReferencingLayer(self.referencingLayer.id())
rel.setReferencedLayer(self.referencedLayer.id())
rel.addFieldPair('foreignkey', 'y')
return rel
示例14: testDuplicateFeature
# 需要导入模块: from qgis.core import QgsRelation [as 别名]
# 或者: from qgis.core.QgsRelation import setReferencedLayer [as 别名]
def testDuplicateFeature(self):
""" test duplicating a feature """
project = QgsProject().instance()
# LAYERS
# - add first layer (parent)
layer1 = QgsVectorLayer("Point?field=fldtxt:string&field=pkid:integer",
"parentlayer", "memory")
# > check first layer (parent)
self.assertTrue(layer1.isValid())
# - set the value for the copy
layer1.setDefaultValueDefinition(1, QgsDefaultValue("rand(1000,2000)"))
# > check first layer (parent)
self.assertTrue(layer1.isValid())
# - add second layer (child)
layer2 = QgsVectorLayer("Point?field=fldtxt:string&field=id:integer&field=foreign_key:integer",
"childlayer", "memory")
# > check second layer (child)
self.assertTrue(layer2.isValid())
# - add layers
project.addMapLayers([layer1, layer2])
# FEATURES
# - add 2 features on layer1 (parent)
l1f1orig = QgsFeature()
l1f1orig.setFields(layer1.fields())
l1f1orig.setAttributes(["F_l1f1", 100])
l1f2orig = QgsFeature()
l1f2orig.setFields(layer1.fields())
l1f2orig.setAttributes(["F_l1f2", 101])
# > check by adding features
self.assertTrue(layer1.dataProvider().addFeatures([l1f1orig, l1f2orig]))
# add 4 features on layer2 (child)
l2f1orig = QgsFeature()
l2f1orig.setFields(layer2.fields())
l2f1orig.setAttributes(["F_l2f1", 201, 100])
l2f2orig = QgsFeature()
l2f2orig.setFields(layer2.fields())
l2f2orig.setAttributes(["F_l2f2", 202, 100])
l2f3orig = QgsFeature()
l2f3orig.setFields(layer2.fields())
l2f3orig.setAttributes(["F_l2f3", 203, 100])
l2f4orig = QgsFeature()
l2f4orig.setFields(layer2.fields())
l2f4orig.setAttributes(["F_l2f4", 204, 101])
# > check by adding features
self.assertTrue(layer2.dataProvider().addFeatures([l2f1orig, l2f2orig, l2f3orig, l2f4orig]))
# RELATION
# - create the relationmanager
relMgr = project.relationManager()
# - create the relation
rel = QgsRelation()
rel.setId('rel1')
rel.setName('childrel')
rel.setReferencingLayer(layer2.id())
rel.setReferencedLayer(layer1.id())
rel.addFieldPair('foreign_key', 'pkid')
rel.setStrength(QgsRelation.Composition)
# > check relation
self.assertTrue(rel.isValid())
# - add relation
relMgr.addRelation(rel)
# > check if referencedLayer is layer1
self.assertEqual(rel.referencedLayer(), layer1)
# > check if referencingLayer is layer2
self.assertEqual(rel.referencingLayer(), layer2)
# > check if the layers are correct in relation when loading from relationManager
relations = project.relationManager().relations()
relation = relations[list(relations.keys())[0]]
# > check if referencedLayer is layer1
self.assertEqual(relation.referencedLayer(), layer1)
# > check if referencingLayer is layer2
self.assertEqual(relation.referencingLayer(), layer2)
# > check the relatedfeatures
'''
# testoutput 1
print( "\nAll Features and relations")
featit=layer1.getFeatures()
f=QgsFeature()
while featit.nextFeature(f):
print( f.attributes())
childFeature = QgsFeature()
relfeatit=rel.getRelatedFeatures(f)
while relfeatit.nextFeature(childFeature):
print( childFeature.attributes() )
print( "\n--------------------------")
print( "\nFeatures on layer1")
for f in layer1.getFeatures():
print( f.attributes() )
print( "\nFeatures on layer2")
for f in layer2.getFeatures():
print( f.attributes() )
'''
# DUPLICATION
#.........这里部分代码省略.........