Comments (7)
Thank you too for the question. That type of data structure on a database could considered in the future version of electron-db @EnOane
from electron-db.
Hi EnOane, I'm assuming that your table name is "equipment" in equipment.json.
Now, first is that the table structure should look something like this,
{
"equipment" : [
{
"row_name": "lala",
"id": "1525272872463",
"group": "oil",
.......
}
]
}
then you update the "lala" row by
const db = require('electron-db');
const electron = require('electron');
const app = electron.app || electron.remote.app;
let where = {
"row_name": "lala"
};
let set = {
"notes": "The things that you want to go in here.."
}
db.updateRow('equipment', where, set, (succ, msg) => {
// succ - boolean, tells if the call is successful
console.log("Success: " + succ);
console.log("Message: " + msg);
});
from electron-db.
Thanks you. But I have another question.
How I can get "row_name":
{
"equipment" :
{
"hope":
{
"row_name": "lala",
"id": "1525272872463",
"group": "oil"
}
}
from electron-db.
WHat do you mean "How can u get "row_name"?
By the way, after the "equipment": it should be a list, square brackets instead of curly braces.
from electron-db.
"squads": {
"firstSquad": {
"id": "1",
"name": "I смена",
"description": "THIS",
"rescues": [
{
"avatar": "/static/rescuers/10.jpg",
"name": "Бондарев Максим",
"birthday": "05/08/1984",
"position": "Командир отделения",
"dateOfEmployment": "01/02/2016",
"certificationForGRW": "01/02/2016",
"certificationForFW": "01/02/2016",
"certificationForSRW": "01/02/2016",
"certificationForHW": "1",
"certificationForHWM": "01/02/2016",
"docs": {
"passport": {
"name": "Паспорт",
"description": "Документ, удостоверящий личность",
"path": ""
},
"identityCardRescue": {
"name": "Удостоверение спасателя",
"description": "Выдается при первой аттестации",
"path": ""
},
"booksRescue": {
"name": "Книжка спасателя",
"description": "Выдается вместе с удостоверением",
"path": ""
}
}
},
]
} .....
How can I get "description"? Path = squads.firstSquad.description
from electron-db.
At the current version of electron-db, you can't, based on the structure of your data.
At the moment, electron-db only support one level object. Which means only one object with the table name and that object contains a list of objects without any sub-level objects.
This is derived from the structure of a relational database where you can only have one level of fields in a table (e.g. "field1", "field2" etc.)
from electron-db.
@alexiusacademia Thanks you very much! )
from electron-db.
Related Issues (20)
- BUG - getAll example uses incorrect syntax HOT 3
- UpdateRow Error HOT 1
- Problem app.asar.unpacked HOT 4
- Any way to drop entire table? HOT 2
- specify the documentation of the attributes of each of the functions to have a documentation section HOT 1
- Do this have any db lock/wait feature? HOT 1
- Table exists? HOT 1
- getField should return false for invalid field/key HOT 2
- Typo in variable of valid() function HOT 2
- updateRow updates only 1 row HOT 1
- Feature Request: tableExists method HOT 1
- Feature Request: Allow functions as where statements HOT 3
- i got a problem at getRow(s) HOT 3
- fs.existsSync is not a function HOT 4
- delete function error HOT 1
- [BUG] DeleteRow HOT 2
- Location custom doesn't work when packaging?
- [Feature]- Add unique check during insert and update HOT 2
- Broken Json issue HOT 1
- Feature Request: Return ID after insertTableContent HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from electron-db.