Create sql query with the help of sql builder magic function help to make automatic sql query its help in build sql query string for Microsoft SQL, MySql, SqlLite, PostgreSQL, ORACLE, Apache Hive, Django, FLASK, HBASE and Apache Spark etc.
Project description
Universal SQL Builder
SQL framework ORM independent, it helps you build sql query in python
What ever you using Hive, HBase, Spark* SQL, Django & FLASK etc so you can gernate simple SQL query
Its return raw sql query string this can be use in any Framework
Installation
Step 1: pip install universal-sql-builderStep 2:
from UniversalSqlBuilder import UniversalSqlBuilder
Step 3: Flow the examples....
Select
UniversalSqlBuilder.table("employee").select("id,name").select(",department").get()
Where
You can use key and value based parameters : where("city=", "ABC")Or you can use raw where query : where("col=(select id from users)")
UniversalSqlBuilder.table("employee").select("id,name").select(",department").where("ram=(select id from users)").where("city=", "delhi").get()
OrWhere and WhereBetween
If you want data according min and max use :
whereBetween("age",[200,300])
UniversalSqlBuilder.table("employee").select("id,name").whereBetween("age",[200,300]).get()
Using OR with where :
UniversalSqlBuilder.table("employee").select("id,name").orWhere("seller=",'100').get()
GroupBy, OrderBy amd Limit
Use of group by : groupBy("name")UniversalSqlBuilder.table("employee").select("id,name").groupBy("name").get()
Use order by : orderBy("ID","desc")
UniversalSqlBuilder.table("employee").select("id,name").orderBy("ID","desc").get()
use with limit : limit(10,20)
UniversalSqlBuilder.table("employee").select("id,name").limit(10,20).get()
Join ('FULL OUTER', 'INNER', 'LEFT', 'RIGHT', 'JOIN')
Default :
join("users","users.id=employee.emp_id")
FULL OUTER : join("users","users.id=employee.emp_id","FULL OUTER")
INNER : join("users","users.id=employee.emp_id","INNER")
LEFT : join("users","users.id=employee.emp_id","LEFT")
RIGHT : join("users","users.id=employee.emp_id","RIGHT")
JOIN : join("users","users.id=employee.emp_id","JOIN")
Having & OrHaving
Using OR with Having :
UniversalSqlBuilder.table("employee").select("id,name").orHaving("seller=",'100').get()
You can use key and value based parameters : having("city=", "ABC")
Or you can use raw where query : having("col=(select id from users)")
UniversalSqlBuilder.table("employee").select("id,name").select(",department").having("id=(select id from users)").having("city=", "delhi").get()
Making Advance Query
Using OR with Having :
print(UniversalSqlBuilder.table("employee")
.select("id,name")
.select(",department")
.where("city=", "delhi")
.where("order_id=("+UniversalSqlBuilder.table("orders as temp").select("temp.id").orderBy("temp.id", "desc").get()+")")
.orWhere("seller=", '100')
.orWhere("brand=", 'rock')
.having("city=", "delhi")
.orHaving("seller=", '100')
.orHaving("brand=", 'rock')
.whereBetween("age", [200, 300])
.join("users", "users.id=employee.emp_id", "left")
.join("cars", "cars.id=employee.emp_id")
.groupBy("name")
.orderBy("ID", "desc")
.limit(10, 20).get())
SELECT
id, name, department
FROM
employee
LEFT JOIN
users ON users.id = employee.emp_id
INNER JOIN
cars ON cars.id = employee.emp_id
WHERE
city = 'delhi'
AND order_id = (SELECT
temp.id
FROM
orders AS temp
ORDER BY temp.id DESC)
AND age >= 200
AND age <= 300
AND (seller = '100' OR brand = 'rock')
GROUP BY name
HAVING city = 'delhi'
AND (seller = '100' OR brand = 'rock')
ORDER BY ID DESC
LIMIT 20 , 10
UniversalSqlBuilder.table("employee").select("id,name").select(",department").having("id=(select id from users)").having("city=", "delhi").get()
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for universal-sql-builder-0.1.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 29328ca62feba6274747112887a4522655e7af65d9c7030ea7f5dfdc7a6e49f0 |
|
MD5 | 2e6565bf361bcd5210b424530b4ef0f4 |
|
BLAKE2b-256 | b7d0bc704574c359a9a7cffb2e8bb8bd909dd0e275f6d18fbd2bf51612707bbb |
Hashes for universal_sql_builder-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0b4afcf37e8e9c39f59f2b930749a1b51959535581bdbc580e0b2699950d8042 |
|
MD5 | 77dd1e2d37730c982fb8d90f347f234e |
|
BLAKE2b-256 | a206404cabb057431520849607aabe528955ec69b7de6877329769f8ce073ff7 |