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
Platform: UNKNOWN
Description-Content-Type: text/markdown

# 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

