In release 1.0.15:
- We have moved project from https://pypi.org/project/sql-constructor/ to https://pypi.org/project/sqlconstructor/ . To install sqlconstructor use 'python3 -m pip install sqlconstructor' command. And to import use 'import sqlconstructor' statement instead.
- iteration for SqlQuery is added. It yeilds SqlSection per loop.
- Now SqlQuery has self.sql_id attribute.
- Now SqlCte class inherits from dict. That's why all dict methods are also available for SqlCte.
- We have moved project from https://pypi.org/project/sql-constructor/ to https://pypi.org/project/sqlconstructor/ . To install sqlconstructor use 'python3 -m pip install sqlconstructor' command. And to import use 'import sqlconstructor' statement instead.
- iteration for SqlQuery is added. It yeilds SqlSection per loop.
- Now SqlQuery has self.sql_id attribute.
- Now SqlCte class inherits from dict. That's why all dict methods are also available for SqlCte.
In release 1.0.16:
- Now when you set variables via call method of SqlContainer then you update vars storage and do not rewrite all vars storage. If you would like to rewrite storage you have to set dict to container.vars attribute.
Example:
def some_func(container: SqlContainer):
# remove all existing vars and set new by dict
container.vars = {'some_var': 'some_value'}
- Now when you set variables via call method of SqlContainer then you update vars storage and do not rewrite all vars storage. If you would like to rewrite storage you have to set dict to container.vars attribute.
Example:
def some_func(container: SqlContainer):
# remove all existing vars and set new by dict
container.vars = {'some_var': 'some_value'}
In release 1.0.18:
- SqlQuery has no longer text method. Call call method instead.
- SqlSection do not upper sql keywords anymore in inline/multiline comments and single/double quotes.
- SqlQuery has no longer text method. Call call method instead.
- SqlSection do not upper sql keywords anymore in inline/multiline comments and single/double quotes.