Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[API] create controller for endpoints needed for adding data from DEI #396

Open
jeff-knurek opened this issue Jun 20, 2021 · 1 comment
Open
Assignees
Labels
Module: API Issues related to the API. Project: PLD Issue related to Project Lockdown. ⌨ Team: Devs Task related to Team Developers.

Comments

@jeff-knurek
Copy link
Contributor

logo

Problem

The DEI needs to leverage the API as connection to the database. In order to save a DSL from the spreadsheet https://docs.google.com/spreadsheets/d/1mVyQxxLxAF3E1dw870WHXTOLgYzmumojvzIekpgvLV0/edit#gid=629188932 controllers for

  • /DSL
  • /Category
  • /DataPoint

need to be created

@jeff-knurek jeff-knurek added Project: PLD Issue related to Project Lockdown. ⌨ Team: Devs Task related to Team Developers. labels Jun 20, 2021
@jeff-knurek jeff-knurek added the Module: API Issues related to the API. label Jun 20, 2021
@jeff-knurek
Copy link
Contributor Author

jeff-knurek commented Jun 21, 2021

general idea of DB structure in Mongoose:

DSL
	_id : ObjectId
	Name : string
	Version : string or number
	Type : enum or DSL_Type
	Status : enum or Status
	Description : string
	Categories: []Category
	DateCreated 
	DateUpdated 
​
​
Category
	_id : ObjectId
	CategoryRefID : string
	DSL._id : ObjectId
	NameShort : string
	Name : string
	Description : string
	IconID : string
	Tags : []string
	Order : number
	DataPoints : []DataPoint
	DateCreated 
	DateUpdated 
	
​
DataPoint
	_id : ObjectId
	DataPointRefID : string
	Category._id : ObjectId
	NameShort : string
	Name : string
	Description : string
	IconID : string
	Tags : []string
	Order : number
	DateCreated 
	DateUpdated 
​
​
DataSetEntry
	_id : ObjectId
	Funnel/Type/Source : enum or Funnel
	Status : enum or Status
	DSL._id : ObjectId
	Territory : Territory
	Answers : []Answer
	SourceUrl: string
	MediaName: string
	StatusTitle: string
	DateIssued: datetime
	Status: Status
	Editor: string or User
	Type: 
	DateCreated 
	DateUpdated 
​
Answer
	_id : ObjectId
	Value : string
	DateStart : 
	DateEnd : 
	Details : string
	DataPoint : DataPoint
	DataSetEntry : DataSetEntry
	DateCreated 
	DateUpdated 
​
​
Territory
	_id : ObjectId
	PLD_Code : string
	Name : string
	ISO2 : string
	ISO3 : string
	UN_Code : string
	NATO_Code : string
	Wikidate_ID : string
	Reseacher : string
	Encoder : string
	Editor : string
	Region : Region
	BoundryLevel : string
	SubTerritories : []Territory
	DateCreated 
	DateUpdated 
​
Region
	_id : ObjectId
	Name : string	
	Tld : string	
​
//-------------- Optional 
​
Funnel/Type/Source
	type: string
	???
	DateCreated 
	DateUpdated 
​
Status
	name: string
	???
​
DSL_Type
	type: string
	????

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Module: API Issues related to the API. Project: PLD Issue related to Project Lockdown. ⌨ Team: Devs Task related to Team Developers.
Development

No branches or pull requests

2 participants