MariaDB-SQLBuilder 1.0.0

MariaDB SQL Builder is a simple way to use Maria SQL. Use your own SQL or use the integrated Maria SQL Builder tool.

MariaDB SQL Builder

---

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.

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

Install the package with pip pip install mariadb-sqlbuilder

Installation with pip + github pip install git+https://github.com/princessmiku/MariaDB-SQLBuilder

Setup

import mariadb_sqlbuilder

connection = mariadb_sqlbuilder.Connector(
    host="HostIP/URL",
    user="User",
    password="Password",
    database="DatabaseToConnect"
)

Example Functions

Select

result = connection.table("myTable").select("name, age, email").where("age", 25).fetchall()

Insert

connection.table("myTable").insert().set("id", 10).set("age", 25).set("Name", "Helgo").execute()

Wiki

For all Details and how to use

Functions

• Select
• Insert
• Update
• Upsert
• Delete
• CustomSQL

---

Not completely used but
Translated with www.DeepL.com/Translator (free version)