Metadata-Version: 2.1
Name: Golla
Version: 0.0.0
Summary: A SQL ORM Tool
Home-page: https://github.com/AbhimanyuHK/Golla
Author: Abimanyu HK
Author-email: manyu1994@hotmail.com
License: MIT License : Copyright (c) 2019 Abhimanyu Haralukallu
Description: # Golla
        
        * A SQL Query free ORM
        * Support SQLAlchemy ORM 
        
        ### Create Connection 
        
        ```
        from sqlalchemy import create_engine
        from sqlalchemy.orm import sessionmaker
        
        host = 'localhost'
        user = 'postgres'
        password = 'root'
        data_base = 'postgres'
        port = '5432'
        URL = 'postgresql://{}:{}@{}:{}/{}'
        URL = URL.format(user, password, host, port, data_base)
        ds_schema = 'public'
        
        engine = create_engine(URL, encoding='utf8')
        engine.connect()
        Connection = sessionmaker(bind=engine)()
        
        ```
        
        ### Create Model class
        
        ```
        from sqlalchemy.ext.declarative import declarative_base
        from sqlalchemy import Integer, String, Column
        
        from golla.table import BaseChild
        
        Base = declarative_base()
        
        BaseChild.Connection = Connection
        
        
        class Employee(Base, BaseChild):
            __tablename__ = "employee"
            EMPID = Column("emp_id", Integer, primary_key=True)
            NAME = Column("NAME", String)
            Age = Column("Age", Integer)
        
        ```
        
        
        ### Save object into DB
        
        ```
        e = Employee()
        e.EMPID = 203
        e.Age = 20
        e.NAME = "b"
        
        Employee.save(e)
        
        ``` 
        
        ### Get records from table by id
        
        ```
        emp = Employee().get_by_id(EMPID=100)
        ```
        
        ### Get all records 
        
        ```
        emps = Employee().get_all()
        ```
        
        ### Delete records from table by id
        
        ```
        Employee().delete_by_id(EMPID=201)
        ```
         
        
         MIT License : Copyright (c) 2019 Abhimanyu Haralukallu
Platform: UNKNOWN
Description-Content-Type: text/markdown
