Models SQLAlchemy from SQLServer Database structure
$30-250 USD
완료함
게시됨 9년 이상 전
$30-250 USD
제출할때 지불됩니다
This project has theses jobs:
1. Build all models for SQLAlchemy from SQLServer database. The backup file "[login to view URL]" is attach of this project as a link of google drive download. You have to use SQLAlcemy "declarative base class" approach.
2. Use Flask and Flask-RESTful library to build a RESTful api to access this database from HTML Pages.
3. Build a little CRUD application for the table INGREDIENTE. You should use combobox for all of fields that ends with "_ID" (select just one record), it's a relationship. This CRUD operation form have to use RESTful API for all operations. CRUD Operation = Create, Read, Update, Delete records. You can list all the records and but the URL Links for all CRUD operation in each line table record.
4. Validation all CRUD operation RESTful API through unit test approach. The database should be blank for each unit test, in other words, for each unit test: Insert data, validate data and make rollback for databse became blank.
5 HTML JSON format with all INGREDIENTE thats belongs one [login to view URL] (the [login to view URL] can insert in a URL parameter for filter). This table has two columns: [login to view URL] and ITEMTABELAPRECO.PRECO. Take a look of _ID fields to understand the relationship between theses tables. Use RESTful API with JSON format.
All SQLAlchemy objects should be in the same file named models.py. The [login to view URL] file have to contains all tables of the You database.
MS SQLServer Database file: [login to view URL]
Thank you
Hi,
I've been learning Flask since last year and have done some small projects with it.
I understand the concepts of restful APIs, as I've been creating them in PHP and .NET and I'm also very familiar with MSSQL having used it for the last 2 years.
Regards,
Anthony.