Skip to main content

A nice database orm written in python

Project description

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')

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for alpha-orm, version 1.0.0
Filename, size File type Python version Upload date Hashes
Filename, size alpha-orm-1.0.0.tar.gz (9.0 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page