Metadata-Version: 2.1
Name: alpha-orm
Version: 1.2.23
Summary: A nice database orm written in python
Home-page: https://github.com/alpha-orm/python-alpha-orm
Author: Claret Nnamocha
Author-email: devclareo@gmail.com
License: MIT
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)
        ```python
        import alphaorm.AlphaORM as DB
        
        DB.setup('mysql',{
          'host' : 'localhost',
          'user' : 'root',
          'password' : '',
          'database' : 'alphaorm'
        })
        ```
        #
        #
        ### CREATE
        ```python
        #--------------------------------------
        #	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
        ```python
        #--------------------------------------
        #	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
        
        ```python
        
        #--------------------------------------
        #	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
        ```python
        #--------------------------------------
        #	DELETE 1 [delete single record]
        #--------------------------------------
        book = DB.find('book','id = :bid', { 'bid' : 1 })
        DB.drop(book)
        
        
        
        
        #--------------------------------------
        #	DELETE 2 [delete all records]
        #--------------------------------------
        DB.dropAll('book')
        ```
Keywords: database,orm,db,database-orm
Platform: UNKNOWN
Classifier: Operating System :: OS Independent
Classifier: License :: OSI Approved :: MIT License
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Requires-Python: >=3
Description-Content-Type: text/markdown
