Python Transaction 예제들

예제 #1

파일: TransactionTest.py 프로젝트: fmatz/featureserver

    def testDelete(self):
        xml = """<?xml version="1.0"?>
<wfs:Transaction
       version="1.1.0"
       service="WFS"
       xmlns="http://example.com/featureserver"
       xmlns:gml="http://www.opengis.net/gml"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengeospatial.net//wfs/1.0.0/WFS-basic.xsd">
    <wfs:Delete typeName="test_point" xmlns:feature="http://opengeo.org">
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="1"/>
        </ogc:Filter>
    </wfs:Delete>
    <wfs:Delete typeName="test_point" xmlns:feature="http://opengeo.org">
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="2"/>
        </ogc:Filter>
    </wfs:Delete>
</wfs:Transaction> """
        solution = [" DELETE FROM osm_point WHERE \"osm_id\" = '1'; ", " DELETE FROM osm_point WHERE \"osm_id\" = '2'; "]
        result = []

        transaction = Transaction()
        transaction.parse(xml)
        transactions = transaction.getActions()
                                                
        for transaction in transactions:
            result.append(transaction.getStatement(self.datasource))
        
        self.assertItemsEqual(solution, result)

예제 #2

파일: TransactionTest.py 프로젝트: fmatz/featureserver

    def testUpdate(self):
        xml = """<?xml version="1.0"?>
<wfs:Transaction
       version="1.1.0"
       service="WFS"
       xmlns="http://example.com/featureserver"
       xmlns:gml="http://www.opengis.net/gml"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengeospatial.net//wfs/1.0.0/WFS-basic.xsd">
    <wfs:Update typeName="test_point" xmlns:feature="http://opengeo.org">
        <wfs:Property>
            <wfs:Name>way</wfs:Name>
            <wfs:Value>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.53438799881,47.3187879949</gml:coordinates>
                </gml:Point>
            </wfs:Value>
        </wfs:Property>
        <wfs:Property>
            <wfs:Name>Description</wfs:Name>
            <wfs:Value>abc</wfs:Value>
        </wfs:Property>
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="1"/>
        </ogc:Filter>
    </wfs:Update>
    <wfs:Update typeName="test_point" xmlns:feature="http://opengeo.org">
        <wfs:Property>
            <wfs:Name>way</wfs:Name>
            <wfs:Value>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.53438799881,47.3187879949</gml:coordinates>
                </gml:Point>
            </wfs:Value>
        </wfs:Property>
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="2"/>
        </ogc:Filter>
    </wfs:Update>
</wfs:Transaction> """         
        solution = [" UPDATE osm_point SET \"way\" = ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns:feature=\"http://opengeo.org\" xmlns=\"http://example.com/featureserver\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') , \"Description\" = 'abc' WHERE \"osm_id\" = '1'; ",
                    " UPDATE osm_point SET \"way\" = ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns:feature=\"http://opengeo.org\" xmlns=\"http://example.com/featureserver\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') WHERE \"osm_id\" = '2'; "]
        result = []

        transaction = Transaction()
        transaction.parse(xml)
        transactions = transaction.getActions()
                                                
        for transaction in transactions:
            result.append(transaction.getStatement(self.datasource))
        
        self.assertItemsEqual(solution, result)

예제 #3

파일: TransactionTest.py 프로젝트: fmatz/featureserver

    def testInsert(self):
        xml = """<?xml version="1.0"?>
<wfs:Transaction
       version="1.1.0"
       service="WFS"
       xmlns="http://example.com/featureserver"
       xmlns:gml="http://www.opengis.net/gml"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengeospatial.net//wfs/1.0.0/WFS-basic.xsd">
    <wfs:Insert idgen="GenerateNew">
        <osm_point gml:id="1">
            <way>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.53438799881,47.3187879949</gml:coordinates>
                </gml:Point>
            </way>
            <name>honky1</name>
            <operator>ABC</operator>
            <highway>bus_stop</highway>
        </osm_point>
        
        <osm_point gml:id="2">
            <way>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.52892699881,47.3221139949</gml:coordinates>
                </gml:Point>
            </way>
            <highway>bus_stop</highway>
        </osm_point>
        
    </wfs:Insert>
</wfs:Transaction>    
            """
        solution = [" INSERT INTO osm_point ( \"way\" , \"name\" , \"operator\" , \"highway\" ) VALUES ( ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns=\"http://example.com/featureserver\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') , 'honky1' , 'ABC' , 'bus_stop' ); ",
                    " INSERT INTO osm_point ( \"way\" , \"highway\" ) VALUES ( ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns=\"http://example.com/featureserver\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') , 'bus_stop' ); "]
        result = []
        
        transaction = Transaction()
        transaction.parse(xml)
        transactions = transaction.getActions()
                                                
        for transaction in transactions:
            result.append(transaction.getStatement(self.datasource))
        
        self.assertItemsEqual(solution, result)

예제 #4

파일: TransactionTest.py 프로젝트: vovoma/featureserver

    def testUpdate(self):
        xml = """<?xml version="1.0"?>
<wfs:Transaction
       version="1.1.0"
       service="WFS"
       xmlns="http://featureserver.org/fs"
       xmlns:gml="http://www.opengis.net/gml"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengeospatial.net//wfs/1.0.0/WFS-basic.xsd">
    <wfs:Update typeName="test_point" xmlns:feature="http://opengeo.org">
        <wfs:Property>
            <wfs:Name>way</wfs:Name>
            <wfs:Value>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.53438799881,47.3187879949</gml:coordinates>
                </gml:Point>
            </wfs:Value>
        </wfs:Property>
        <wfs:Property>
            <wfs:Name>Description</wfs:Name>
            <wfs:Value>abc</wfs:Value>
        </wfs:Property>
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="1"/>
        </ogc:Filter>
    </wfs:Update>
    <wfs:Update typeName="test_point" xmlns:feature="http://opengeo.org">
        <wfs:Property>
            <wfs:Name>way</wfs:Name>
            <wfs:Value>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.53438799881,47.3187879949</gml:coordinates>
                </gml:Point>
            </wfs:Value>
        </wfs:Property>
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="2"/>
        </ogc:Filter>
    </wfs:Update>
</wfs:Transaction> """
        solution = [
            " UPDATE osm_point SET \"way\" = ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns:feature=\"http://opengeo.org\" xmlns=\"http://featureserver.org/fs\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') , \"Description\" = 'abc' WHERE \"osm_id\" = '1'; ",
            " UPDATE osm_point SET \"way\" = ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns:feature=\"http://opengeo.org\" xmlns=\"http://featureserver.org/fs\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') WHERE \"osm_id\" = '2'; "
        ]
        result = []

        transaction = Transaction()
        transaction.parse(xml)
        transactions = transaction.getActions()

        for transaction in transactions:
            result.append(transaction.getStatement(self.datasource))

        self.assertItemsEqual(solution, result)

예제 #5

파일: TransactionTest.py 프로젝트: vovoma/featureserver

    def testInsert(self):
        xml = """<?xml version="1.0"?>
<wfs:Transaction
       version="1.1.0"
       service="WFS"
       xmlns="http://featureserver.org/fs"
       xmlns:gml="http://www.opengis.net/gml"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengeospatial.net//wfs/1.0.0/WFS-basic.xsd">
    <wfs:Insert idgen="GenerateNew">
        <osm_point gml:id="1">
            <way>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.53438799881,47.3187879949</gml:coordinates>
                </gml:Point>
            </way>
            <name>honky1</name>
            <operator>ABC</operator>
            <highway>bus_stop</highway>
        </osm_point>
        
        <osm_point gml:id="2">
            <way>
                <gml:Point srsName="EPSG:4326">
                    <gml:coordinates decimal="." cs="," ts=" ">8.52892699881,47.3221139949</gml:coordinates>
                </gml:Point>
            </way>
            <highway>bus_stop</highway>
        </osm_point>
        
    </wfs:Insert>
</wfs:Transaction>    
            """
        solution = [
            " INSERT INTO osm_point ( \"way\" , \"name\" , \"operator\" , \"highway\" ) VALUES ( ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns=\"http://featureserver.org/fs\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') , 'honky1' , 'ABC' , 'bus_stop' ); ",
            " INSERT INTO osm_point ( \"way\" , \"highway\" ) VALUES ( ST_GeomFromGML('<gml:Point xmlns:gml=\"http://www.opengis.net/gml\" xmlns=\"http://featureserver.org/fs\" xmlns:ogc=\"http://www.opengis.net/ogc\" xmlns:wfs=\"http://www.opengis.net/wfs\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" srsName=\"EPSG:4326\"> <gml:coordinates decimal=\".\" cs=\",\" ts=\" \">8.53438799881,47.3187879949</gml:coordinates> </gml:Point> ') , 'bus_stop' ); "
        ]
        result = []

        transaction = Transaction()
        transaction.parse(xml)
        transactions = transaction.getActions()

        for transaction in transactions:
            result.append(transaction.getStatement(self.datasource))

        self.assertItemsEqual(solution, result)

예제 #6

파일: TransactionTest.py 프로젝트: vovoma/featureserver

    def testDelete(self):
        xml = """<?xml version="1.0"?>
<wfs:Transaction
       version="1.1.0"
       service="WFS"
       xmlns="http://featureserver.org/fs"
       xmlns:gml="http://www.opengis.net/gml"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengeospatial.net//wfs/1.0.0/WFS-basic.xsd">
    <wfs:Delete typeName="test_point" xmlns:feature="http://opengeo.org">
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="1"/>
        </ogc:Filter>
    </wfs:Delete>
    <wfs:Delete typeName="test_point" xmlns:feature="http://opengeo.org">
        <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
            <ogc:FeatureId fid="2"/>
        </ogc:Filter>
    </wfs:Delete>
</wfs:Transaction> """
        solution = [
            " DELETE FROM osm_point WHERE \"osm_id\" = '1'; ",
            " DELETE FROM osm_point WHERE \"osm_id\" = '2'; "
        ]
        result = []

        transaction = Transaction()
        transaction.parse(xml)
        transactions = transaction.getActions()

        for transaction in transactions:
            result.append(transaction.getStatement(self.datasource))

        self.assertItemsEqual(solution, result)