alpha-orm
An extraordinary python database orm
Features
- Automatically creates tables and columns.
- No configuration required, simply create database.
- Currently supported databases include mysql.
Examples
Setup (MySQL)
import alphaorm.AlphaORM as DB
DB.setup('mysql',{
'host' : 'localhost',
'user' : 'root',
'password' : '',
'database' : 'alphaorm'
})CREATE
#--------------------------------------
# CREATE 1
#--------------------------------------
product = DB.create('product')
product.name = 'Running shoes'
product.price = 5000
DB.store(product)
#--------------------------------------
# CREATE 2
#--------------------------------------
author = DB.create('author')
author.name = 'Chimamanda Adichie'
book = DB.create('book')
book.title = 'Purple Hibiscus'
book.author = author
DB.store(book)READ
#--------------------------------------
# READ 1 [get all records]
#--------------------------------------
books = DB.getAll('book')
for book in books:
print(f'{book.title} by {book.author.name}')
#--------------------------------------
# READ 2 [filter one]
#--------------------------------------
book = DB.find('book','id = :bid', { 'bid' : 1 })
print(f'{book.title} by {book.author.name}')
#--------------------------------------
# READ 3 [filter all]
#--------------------------------------
author = DB.find('author','name = :authorName',{ 'authorName': 'William Shakespare' })
booksByShakespare = DB.findAll('book', 'author_id = :authorId', { 'authorId': author.getID() })
print('Books by William Shakespare are :')
for book in booksByShakespare:
print(book.title)UPDATE
#--------------------------------------
# UPDATE
#--------------------------------------
product = DB.find('product', 'id = :pid', { 'pid': 1 })
product.price = 500
book = DB.find('book','id = :bid', { 'bid' : 1 })
book.author.name = 'New author'
book.isbn = '3847302-SD'
book.title = 'New Title'
DB.store(book)
print(book)DELETE
#--------------------------------------
# DELETE 1 [delete single record]
#--------------------------------------
book = DB.find('book','id = :bid', { 'bid' : 1 })
DB.drop(book)
#--------------------------------------
# DELETE 2 [delete all records]
#--------------------------------------
DB.dropAll('book')
