This is a big update. Added some new features.
- classes
MetaSingleton
andDataBase
was extracted into filedatabase.py
- added
driver
property forDataBase
class - added processing special chars (like
+
,/
etc) fortable
parameter - added type
list
fortable
parameter - added
DISTINCT
forselect()
method - added parameter
with_values=True
forget_sql()
method - added methods:
__str__()
union()
andunion_select()
forUNION
andUNION ALL
inSELECT
queriesexpects()
andexcept_select()
forEXCEPT
inSELECT
queriesintersect()
andintersect_select()
forINTERSECT
inSELECT
querieshas_error()
insteadget_error()
(in the next version)
- written unit test for all SQL methods
- README was separated for some files
- added
create_view()
method (CREATE VIEW view_name AS SQL_SELECT
) - added
drop_view()
method (DROP VIEW view_name
)