Simple_CRUD_API_SQLAlchemy_ORM
Simple CRUD API Build With Tornado Framework And SQLAlchemy_ORM For mapping any SQL Database
setup:
1) git clone https://github.com/MedAmineFouzai/Simple_CRUD_API_SQLAlchemy_ORM |
2) cd Simple_CRUD_API_SQLAlchemy_ORM |
3) pip install pipenv |
4) pipenv --python 3.6 |
5) pipenv install - r requirements.txt |
6) run project with torn cli : #command: [ torn run ] |
SQLAlchemy is an open-source SQL toolkit and object-relational mapper for the Python programming language
Connecting To A Database:
change uri to the suited database (postgresql,oracl,mysql,...) in models/post.py
ex:[mysql+pymysql://root:@localhost/dbname]
DB_NAME="MyDatabaseName"
engine=create_engine('mysql+pymysql://root:@localhost/{}'.format(DB_NAME),echo=False)
Base=declarative_base()
session=Session(bind=engine)
Defining Object Data:
change the Columns and there data types based on your object fields
ex:
class post(Base):
__tablename__='posts'
id=Column(Integer,primary_key=True)
title=Column(String(50))
body=Column(String(50))
def __repr__(self):
return "<Post(id={},title={},body={}>".format(self.id,self.title,self.body)