MongoDB_02/2

Modification

Make changes on existing data. MongoDB doesn't restrict data stored in the same format. For convenience, in insert functions I kept data format the same. Fixed structure make query easy. Otherwise, for example, query strings in key "breath" is difficult. "breath" contains nested object. The key names under breath are barely the same.

With update $set and $unset, I can completely change the structure of existing records.

Update $set

Set values on qualified records. $set object can contain more than one data set.
At this example, I

changed style from Array to String.
added new object into key-breath, expanded its branches.
added another branch-song at record root.

After update, this record owned a structure different from others.

Update $unset

Unset specific keys. Everything under this key would be removed. $unset object can contain multiple keys, set value to 0 to remove data set. Here I

removed key-style
removed key-breath which contained nested objects.

For now, except query on key-name, what applied to other records wouldn't apply to this modified record. It contains different keys.

Delete Records

Delete records,

Drop Collection

Drop collection. And then use db function listCollections() to check the result.

Great Resources

NodeJS APIs for MongoDB: http://mongodb.github.io/node-mongodb-native/3.5/api/index.html

MongoDB Commands: https://docs.mongodb.com/manual/reference/method/

Comments

Bookmark service (MongoDB & Spring REST) -2/2

I accidentally deleted my development VM. I got lucky having the habit of taking notes. This blog is useful. Development VM is doom to be lost. Rebuild it waste time, but having a clean slate is refreshing~. What concerns me more is my AWS free quota this month is reaching 85%. The second VM I launched but never being used might be the one to blame. (Of course, my mistake.) I terminated the wrong VM. Now I got Linux 2 built. Great, just threw away everything happened on AMI. 1st layer: Page Page class Originally, I need to prepare getter/setter for all class properties for Spring. By using lombok, I only need to create constructors. lombok will deal with getter/setter and toString(). But there are chances to call getter/setter, but how? .......Naming convention.... Capitalize the 1st character with the prefix get/set. Annotation @Data was used on this class. Repository class Spring Docs: Repository https://docs.spring.io/spring-data/mongodb/docs/3....

gamer's interview

This project simulates a gamer's interview. Based on NodeJS+ ReactJS The setting is interviewing a gamer/journalist what's his/her plan of March 2020? The gamer answers his/her game list in plan, how many reviews on demand and how many hours expected. Games selected for review take 5 hours for each, while others take one. This project is designed to practice render html, jsx, component, props introduced in https://www.w3schools.com/REACT/default.asp . Also fixed other issues to make it work. When trying to modualize objects and tools, my design developed to separate views and processes. And it is quite similar to the initialized structure NodeJS+ReactJS provided. Furthermore, since include local module files are banned by browsers, use NodeJS service seems to be the best option. view file main process object tool

Comments for my Server/Client Web API samples

Finally, I finished the comments for python/07 and 09 projects. I almost forgot to put the date on source code which is used to note how long it took me. Not precisely in hours….. I didn’t include source code in my previous post. If choosing code-section for this post…… maybe I want to mark out my comment….. (Really?!) Once my work was developing websites for enterprises, including ERP, CRM or content sites. The sustainability of network and security are important issues. There are 2 methods for HTML Form submission: GET and POST. Submit via POST is secure, compared to GET which piles parameters on URL. RESTful API is mainly using GET. Yup, even if you have a certification key, if you put the value on the URL, it is visible data. When writing socket-communication, client-server sockets are a pair; both follow the agreement on commands and structures; and there are countless ports for usa...

Digital sailing

Search This Blog