66 lines
1.6 KiB
JavaScript
66 lines
1.6 KiB
JavaScript
import { db } from '../../database-calls/db.mjs'
|
|
import { getWords } from '../../database-calls/GETFunctions.mjs'
|
|
|
|
|
|
//const words = getWords(db)
|
|
const allDefinitionsAreFormOf = (meanings) => {
|
|
let formsOf = 0
|
|
let totalDefs = 0
|
|
for (const meaning of meanings) {
|
|
for (const definition of meaning.definitions) {
|
|
totalDefs++
|
|
if (definition.form_of == true) {
|
|
formsOf++
|
|
}
|
|
}
|
|
}
|
|
return formsOf === totalDefs
|
|
}
|
|
const sampleMeanings =[
|
|
{
|
|
"type": "noun",
|
|
"definitions": [
|
|
{
|
|
"definition": "plural of look",
|
|
"form_of": true,
|
|
"plural": true
|
|
},
|
|
{
|
|
"definition": "One's appearance or attractiveness.",
|
|
"form_of": false,
|
|
"plural": true
|
|
}
|
|
]
|
|
},
|
|
{
|
|
"type": "verb",
|
|
"definitions": [
|
|
{
|
|
"definition": "third-person singular simple present indicative form of look",
|
|
"form_of": true,
|
|
"plural": false
|
|
}
|
|
]
|
|
}
|
|
]
|
|
const words = await getWords(db)
|
|
const flagged = []
|
|
for (const word of words) {
|
|
const res =
|
|
await db('dictionary')
|
|
.select('meanings')
|
|
.where('word', word.word)
|
|
const meanings = JSON.parse(res[0].meanings)
|
|
if(allDefinitionsAreFormOf(meanings)){
|
|
await db('dictionary').
|
|
where('word', word.word)
|
|
.update('derivative',1)
|
|
flagged.push(word)
|
|
}
|
|
}
|
|
console.log(`${flagged.length} entries flagged`)
|
|
//console.dir(flagged)
|
|
db.destroy()
|
|
|
|
|