A simple and lightweight ORM that facilitate some operations on SQL Server using of pyodbc.
Project description
About
A simple and lightweight ORM that facilitate some operations on SQL Server using of pyodbc.
How to use
Preparation
# Single call it once to setup the inner settings
BetterMSSQL.setup("name of the database", "db user", "db password", "host", 1234) #port
# Creating a DB Model
class Fruits():
_table = "fruit_table_name"
class People():
_table = "people_table_name"
Select
# Select the first fruit ordered by name and retrieve the first row
Fruits().select("name").order("name").row() # returns one row
# Select all data from the top 15 fruits
Fruits().select("*").top("15").run() # returns a row list
# Select all data from the top 15 fruits
Fruits().select("*").top("15").run() # returns a row list
# Select the name of the first person with 34 years old
People().select("name").where("age = ?").cell(34) # returns the first cell of the first row
Insert
# Inserting a person given its name and age
People().insert("name, age").run(["Matt", 34])
Update
# Updating all ages to 16 where the name is Matt
People().update("age = ?").where("name = ?").run([16, "Matt"])
Delete
# Delete all persons
People().delete()
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
bettermssql-0.0.1.tar.gz
(3.5 kB
view hashes)
Built Distribution
Close
Hashes for bettermssql-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1438595364e723e5e70987a05ac578ad3410c09e3d2d7fdc3f8801a226d301fd |
|
MD5 | d73ab589eaee2ab3ba22f45af0df4d2d |
|
BLAKE2b-256 | 9d7ce578cc9f69d2dc25d52a3739bcb45dde098700caebcbe5f7dbbd22e167ab |