# MariaDB SQL Builder
-----
[![License - GNU LPGL version 2.1](https://img.shields.io/badge/License-GNU_LPGL_version_2.1-green)](https://opensource.org/licenses/LGPL-2.1)
[![Python - ^3.7](https://img.shields.io/badge/Python-^3.7-blue)](https://www.python.org/)
[![Downloads](https://pepy.tech/badge/mariadb-sqlbuilder)](https://pepy.tech/project/mariadb-sqlbuilder)
## Warning! Update 1.0 change many functions and variable names to the pep8 standard
Too lazy to write SQL? Then use the SQL Builder to make your life easier!
MariaDB SQL Builder is a simple way to use SQL.
Use your own SQL or use the integrated SQL Builder tool.
### MariaDB license
This library uses MariaDB Connector/Python, which is released under the terms of the GPLv2 license. For more
information, please see the [license file in the repository](https://github.com/mariadb-corporation/mariadb-connector-python/blob/1.1/LICENSE).
# What is new in 1.0.0?
- 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
# [Install](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Installation)
Install the package with pip
``pip install mariadb-sqlbuilder``
Installation with pip + github
``pip install git+https://github.com/princessmiku/MariaDB-SQLBuilder``
# [Setup](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Setup)
````python
import mariadb_sqlbuilder
connection = mariadb_sqlbuilder.Connector(
host="HostIP/URL",
user="User",
password="Password",
database="DatabaseToConnect"
)
````
# Example Functions
### Select
```python
result = connection.table("myTable").select("name, age, email").where("age", 25).fetchall()
```
### Insert
```python
connection.table("myTable").insert().set("id", 10).set("age", 25).set("Name", "Helgo").execute()
```
# [Wiki](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki)
For all Details and how to use
## Functions
- **[Select](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Select)**
- **[Insert](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Insert)**
- **[Update](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Update)**
- **[Upsert](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Upsert)**
- **[Delete](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Delete)**
- **[CustomSQL](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Custom-SQL)**
----------------------------------------------------------------
<br>
Not completely used but <br>
Translated with www.DeepL.com/Translator (free version)
Raw data
{
"_id": null,
"home_page": "https://github.com/princessmiku/MariaDB-SQLBuilder",
"name": "MariaDB-SQLBuilder",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7.0",
"maintainer_email": "",
"keywords": "database,mariadb,sql,builder,script builder,mariadb sql,orm",
"author": "Miku",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/25/11/d6d1e2809190d5856c3dd0362140d954b454cbbc8a9a75c1fd3b5eab9a9c/MariaDB-SQLBuilder-1.0.0.tar.gz",
"platform": null,
"description": "# MariaDB SQL Builder\n\n-----\n\n[![License - GNU LPGL version 2.1](https://img.shields.io/badge/License-GNU_LPGL_version_2.1-green)](https://opensource.org/licenses/LGPL-2.1)\n[![Python - ^3.7](https://img.shields.io/badge/Python-^3.7-blue)](https://www.python.org/)\n[![Downloads](https://pepy.tech/badge/mariadb-sqlbuilder)](https://pepy.tech/project/mariadb-sqlbuilder)\n\n## Warning! Update 1.0 change many functions and variable names to the pep8 standard\n\nToo lazy to write SQL? Then use the SQL Builder to make your life easier!\n\nMariaDB SQL Builder is a simple way to use SQL.\nUse your own SQL or use the integrated SQL Builder tool.\n\n### MariaDB license\n\nThis library uses MariaDB Connector/Python, which is released under the terms of the GPLv2 license. For more \ninformation, please see the [license file in the repository](https://github.com/mariadb-corporation/mariadb-connector-python/blob/1.1/LICENSE).\n\n# What is new in 1.0.0?\n\n- Checking table names and column names of right spelling\n- Checking inserted data of the correct type\n- Add Arithmetic functions\n- Convert more types in the correct saving string / integer\n- Saving conditions for multiple using\n- Pylint checking of the most of the code\n- Dummy Connector, if you won't use it with a connection\n- sub selects\n- Rename Connect to Connector\n\n# [Install](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Installation)\nInstall the package with pip\n``pip install mariadb-sqlbuilder``\n\nInstallation with pip + github\n``pip install git+https://github.com/princessmiku/MariaDB-SQLBuilder``\n\n# [Setup](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Setup)\n\n````python\nimport mariadb_sqlbuilder\n\nconnection = mariadb_sqlbuilder.Connector(\n host=\"HostIP/URL\",\n user=\"User\",\n password=\"Password\",\n database=\"DatabaseToConnect\"\n)\n````\n\n# Example Functions\n### Select\n```python\nresult = connection.table(\"myTable\").select(\"name, age, email\").where(\"age\", 25).fetchall()\n```\n\n### Insert\n```python\nconnection.table(\"myTable\").insert().set(\"id\", 10).set(\"age\", 25).set(\"Name\", \"Helgo\").execute()\n```\n\n# [Wiki](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki)\nFor all Details and how to use\n\n## Functions\n\n- **[Select](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Select)**\n- **[Insert](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Insert)**\n- **[Update](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Update)**\n- **[Upsert](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Upsert)**\n- **[Delete](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Builder---Delete)**\n- **[CustomSQL](https://github.com/princessmiku/MariaDB-SQLBuilder/wiki/Custom-SQL)**\n\n\n----------------------------------------------------------------\n\n<br>\nNot completely used but <br>\nTranslated with www.DeepL.com/Translator (free version)\n",
"bugtrack_url": null,
"license": "LGPL 2.1",
"summary": "MariaDB SQL Builder is a simple way to use Maria SQL. Use your own SQL or use the integrated Maria SQL Builder tool.",
"version": "1.0.0",
"split_keywords": [
"database",
"mariadb",
"sql",
"builder",
"script builder",
"mariadb sql",
"orm"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5256d4e295ee77dfefbff28565c1bf99f65ecce99e55a9402def8c01ee5751f0",
"md5": "98b6cad68636f3935a56b29e7db15129",
"sha256": "69479bc5b7c779c25e5eb8c03e1d61d84ca47890698a1c4976409008aa88933f"
},
"downloads": -1,
"filename": "MariaDB_SQLBuilder-1.0.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "98b6cad68636f3935a56b29e7db15129",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7.0",
"size": 34446,
"upload_time": "2023-03-17T23:07:17",
"upload_time_iso_8601": "2023-03-17T23:07:17.645638Z",
"url": "https://files.pythonhosted.org/packages/52/56/d4e295ee77dfefbff28565c1bf99f65ecce99e55a9402def8c01ee5751f0/MariaDB_SQLBuilder-1.0.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "2511d6d1e2809190d5856c3dd0362140d954b454cbbc8a9a75c1fd3b5eab9a9c",
"md5": "d92794546cdacc0d3fb7c1f7633d234c",
"sha256": "b2ab7ff584c71fbd26eb378d85528b75bcf2117d585e714e0640f5a65c4d03ac"
},
"downloads": -1,
"filename": "MariaDB-SQLBuilder-1.0.0.tar.gz",
"has_sig": false,
"md5_digest": "d92794546cdacc0d3fb7c1f7633d234c",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7.0",
"size": 24925,
"upload_time": "2023-03-17T23:07:19",
"upload_time_iso_8601": "2023-03-17T23:07:19.613554Z",
"url": "https://files.pythonhosted.org/packages/25/11/d6d1e2809190d5856c3dd0362140d954b454cbbc8a9a75c1fd3b5eab9a9c/MariaDB-SQLBuilder-1.0.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-03-17 23:07:19",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "princessmiku",
"github_project": "MariaDB-SQLBuilder",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "mariadb",
"specs": [
[
">=",
"1.1.4"
]
]
}
],
"lcname": "mariadb-sqlbuilder"
}