Run pip install pythonql to install pythonql for Python2.7, or pip install pythonql3 for Python 3.x. # Basic SQL query, but with some data cleaning res = [ select ( name, sum( price) as sum)įor o in ords let price = try float( o. # Basically, some data might be dirty, but you still want to be able to write a simple query from collections import namedtuple ord = namedtuple( 'Order', )Ĭust = namedtuple( 'Cust', )Ĭusts = #coding: pythonql # This example illustrates the try-catch business in PythonQL. So we can write path expression in the query language (and elsewhere in Python expressions) like this: expr where expr must evaluate to string expr where expr must evaluate to stringĭescendants step: for x in data.
We have modeled our path expression on XPath, however we use a much simplified verison:Ĭhild step: for x in data.
When working with nested data that has varied structure, path expressions are extremely useful. We propose the following extensions to Python( that are implemeneted in this demo preprocessor and query executor): However, group by mechanisms, outerjoins and support for semi-structured data are not handled well at all. Python has pretty advanced comprehensions, that cover a big chunk of SQL, to the point where PonyORM was able to build a whole ORM system based on comprehensions. PythonQL is an extension to Python that allows language-integrated queries against relational, XML and JSON data, as well an Python's collections
0 kommentar(er)
