CLI and Webapp for managing entities with their restful APIs

Cerrado Publicado hace 6 años Pagado a la entrega
Cerrado Pagado a la entrega

Vocabulary:

crate = box = entity

MasterApp = MA

About:

CLI and simple Webapp (MasterApp - MA) is to be created.

This MA has got its customers, which will use it to access standardized Crates with their own implementation.

So MA Customer will create (name) his new application and link chosen Crates to it. In this first simple solution there will be only one Users Crate created.

After linking crates this new application new db will be created and in it structures will be created.

This new application will have its own API to work with the data. (use api_key / app_id etc to secure api).

So in the end Customer1 with his NewApplication2 (NA2) will have access through API of NA2 to its data.

CLI script + Simple Webapp

Overview:

App will be written in nodejs, js, expressjs, mysql.

Script will be used from command line and web. Written in js.

Script should be interactive and intelligent.

Script logs its progress to a file/db.

Configs should be written preferable in yaml to json.

Every part of the application should communicate through a swagger documented restful api.

Api should be secured with api keys and tested with dredd.

I'm providing for you to use samples of:

1) swagger definitions of crates and users

2) sql for master db tables

3) users crate (sql setup and drop)

4) vision poorly drawn in uxpin

Workflow:

1) run script (cli or simplewebapp run)

2) admin will write NewApp name (alfanum)

3) script would access MasterDB Crates table via RestAPI a return list of crates that admin can use

4) admin will select (on web and in cli script) crates that will be fed to this NewApp

5) admin will supply new database name which should be created on server and script will create this db

6) setup scripts for that crate will be called and tables in db will be created

7) script will ask if sample data should be written to that db (for example 3 rows in db)

8) db configuration will be saved for that application - so that the api/app know to which db should it "talk" to

9) script will confirm everything went ok and return url on which api for this new application is running

10) script will call for API error check. Using Dredd the API and code for User crate will be tested and output showed to current admin.

11) script ends

After the script is finished:

Api will be "up and running" and dredd-checked on local machine = server.

One Crate aka Entity aka Box should contain:

- Api definition

- Backend API implementation in JS, nodejs, expressjs, mysql

- Sql file to create its table(s)

- Sql file to fill it with sample data

- Sql file to teardown this table

- Maybe a config file in yaml/json

- Dredd test?

- License file

More information will be provided to selected developer including, uxpin drafts, basic db table structures etc.

This project is prequel to much bigger project so the there is strong probability that, if both sides are satisfied, there will be more and longterm work on it.

Express JS MySQL Node.js RESTful

Nº del proyecto: #13814953

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace 6 años

7 freelancers están ofertando un promedio de $151 por este trabajo

chapter247

Dear Hiring Manager, Hi, How are you..? we have gone through with the requirements and I am ready to work on this project and with you. We have designed and built websites for various types of businesses very suc Más

$155 USD en 3 días
(3 comentarios)
3.9
techcrunch2

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Más

$205 USD en 6 días
(0 comentarios)
0.0