René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"PythonQL3 pattern matching not working","articleBody":"Hi there,\r\n\r\nI've recently discovered PythonQL - Wow! I spent my spare time over the last 2 days to go through the intro and tutorial and have created a python script with all the examples in there. Everything works beautifully except for the two pattern matching examples.\r\n\r\nThe sample data is as follows\r\n\r\n```\r\npeople = [ {'first':'John', 'last':'Doe', 'age':30,\r\n             'address' : {'city':'San Jose', 'zipcode':92122}},\r\n           {'first':'Daniela', 'last':'Kleene', 'age':40, \r\n             'address' : {'city':'San Jose', 'street':'Main', 'zipcode':92314}},\r\n           {'first':'Jerry', 'last':'Lee', 'age':50, 'occupation':'Engineer', \r\n             'address' : {'city':'San Jose', 'zipcode':93213}}\r\n]\r\n```\r\n\r\nThe first pattern matching example is as follows:\r\n\r\n```\r\nres = [ select (l, z)\r\n        match {\r\n         \"last\" : as l,\r\n         \"age\" : as a where a \u003e 25,\r\n         \"address\" : {\r\n             \"city\" : \"San Jose\",\r\n             \"zipcode\" : as z\r\n          }\r\n        } as x in people ]\r\n```\r\n\r\nNow this first example works 100%.\r\n\r\nThe second pattern matching example is as follows\r\n\r\n```\r\nres = [  select x\r\n          match {\r\n            \"last\" : as _,\r\n            \"first\" : as _,\r\n            \"age\" : as a where a \u003e 25,\r\n            \"address\" : {\r\n               \"city\" : as _,\r\n               \"zipcode\" : as _\r\n            }\r\n          } as x in people ]\r\n]\r\n```\r\n\r\nThis second pattern matching example has an error in that there appears to be an extra closing square bracket at the end. \r\n\r\nRemoving this bracket is obviously fixes the syntax error. This example is however supposed to return only the first record because it matches exactly - meaning it has all the same fields as the query but this example returns every record - according to the tutorial but it returns all the records (maybe this is the correct behaviour?). \r\n\r\nIf I now add an `occupation` field to the pattern it matches only the record that contains the occupation field. If I add a `street` field to the pattern nothing matches. If I now remove the `occupation` field but leave the `street` field in the pattern it matches the record that has the `street` field.  \r\n\r\nAm I missing something here? Or is the tutorial incorrect?","author":{"url":"https://github.com/erasmusa","@type":"Person","name":"erasmusa"},"datePublished":"2020-04-12T08:34:12.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/18/pythonql/issues/18"}