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.

Source Distribution

alpha-orm-1.2.31.tar.gz (7.3 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page