- Checking table names and column names of right spelling
- Checking inserted data of the correct type
- Add Arithmetic functions
- Convert more types in the correct saving string / integer
- Saving conditions for multiple using
- Pylint checking of the most of the code
- Dummy Connector, if you won't use it with a connection
- sub selects
- Rename Connect to Connector
What's Changed
* Merge pull request 15 from princessmiku/development-0.5.1 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/16
* Development 1.0.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/18
* Development 1.0.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/19
* Development 1.0.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/20
* Add testing workflow by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/22
* Fix c0103 invalid name by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/23
* Fix C0321 multiple statements by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/24
* Fix W0611 unused imports by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/25
* Connector improvement by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/26
* add a error function for the dummy connection by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/27
* C0116 missing function or method docstring by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/28
* add C0301 Line too long fix by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/29
* Update testing.yml by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/30
* Pylint fixes by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/31
* Arithmetic operators by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/51
* Exsistens and type checker by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/53
* Implements dummy + fixes by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/54
* Subqueries by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/57
New Contributors
* oloc made their first contribution in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/22
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.0.5.1...v.1.0.0
v.1.0.0a6
The library now checks by default for entries with an active database connection whether the entry is possible.
This includes
- Table names
- Column names
- Data types
The advantage of this is that in case of a possible error a request is not sent to the database and you get a more detailed error description.
If you don't want to use this possibility, you can disable it in the connection with `use_validator=False`.
Example
python
con = Connector(
host="localhost",
...
use_validator=False
)
Also, bugs have been fixed and multiple types are now supported (timedelta, decimal and boolean).
What's Changed
* Exsistens and type checker by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/53
* Implements dummy + fixes by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/54
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.1.0.0a5...v.1.0.0a6
v.1.0.0a5
In the folder wiki/helpful/arithmetic.md you can find all information about the usage, also there was an update in the selectbuilder by the change
What's Changed
* Arithmetic operators by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/51
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.1.0.0a4...v.1.0.0a5
v.1.0.0a4
For this release a big thanks to oloc
Oloc brought the idea to change the Connect class to Connector, which makes sense.
Who wants to know more about this can read in the pull request
https://github.com/princessmiku/MariaDB-SQLBuilder/pull/26
Also the lib has adapted to the pylint standards for the most part. I was encouraged by Oloc when they suggested a workflow and some changes.
That was very nice, so I tried to incorporate all complaints from pylint as soon as possible.
Seeing the library being used makes me happy. Although I see it in the donwload numbers, but that someone has also actively worked something on it makes me very happy.
-----
What's Changed
* Add testing workflow by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/22
* Fix c0103 invalid name by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/23
* Fix C0321 multiple statements by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/24
* Fix W0611 unused imports by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/25
* Connector improvement by oloc in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/26
* add a error function for the dummy connection by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/27
* C0116 missing function or method docstring by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/28
* add C0301 Line too long fix by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/29
* Update testing.yml by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/30
* Pylint fixes by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/31
New Contributors
* oloc made their first contribution in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/22
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.1.0.0a3...v.1.0.0a4
v.1.0.0a3
Implements a Connection Dummy for people who only want use the sql builder tool
Implements a Conditions Saver
Checkout the wiki in this repo for more information about the new functions
https://github.com/princessmiku/MariaDB-SQLBuilder/tree/master/wiki
What's Changed
* Development 1.0.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/20
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.1.0.0a2...v.1.0.0a3
v.1.0.0a2
Change many variable names to the pep8 standard, add functions and remove sqlparse as pip requirement
What's Changed
* Merge pull request 15 from princessmiku/development-0.5.1 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/16
* Development 1.0.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/18
* Development 1.0.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/19
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.0.5.1...v.1.0.0a2
v.0.5.1
What's Changed
* execution bugfix by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/15
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.0.5.0...v.0.5.1
v.0.5.0
Add Json Support.
Now possible to get and Set data as a json format.
Added in Select, Update, Insert and Upsert.
Add "Join" in insert and upsert
Now is possiblie to insert data in more then one table with one insert/upsert
_And bugfixes_
v.0.4.1
I update the license to the LGPL-2.1 license.
This is also used by MariaDB and the license says that libraries should use the same license.
I would like to avoid any problems :)
v.0.4.0
- Added many conditions `like`, `between` and more
- Add a [Wiki](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki)
- Bugfix
- Update Structure of the code
What's Changed
* version change by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/11
* Development 0.4.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/12
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.0.3.2...v.0.4.0
v.0.3.2
Bugfix Execute in "main", add args and kwargs for init
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.0.3.1...v.0.3.2
v.0.3.1
What's Changed
* fix - cursor have not been released by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/9
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/v.0.3.0...v.0.3.1
v.0.3.0
- Added Exists checker
- Better Cursor handleing
- Update structure of where and more
What's Changed
* V.0.3.0 by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/8
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/compare/0.2.1...v.0.3.0
v.0.2.1
Fix not included moduls
v.0.2.0
What's Changed
* Dev by princessmiku in https://github.com/princessmiku/MariaDB-SQLBuilder/pull/1
**Full Changelog**: https://github.com/princessmiku/MariaDB-SQLBuilder/commits/v.0.2.0