How can I extract the parameters stored in a JSON object inside a function() call using RegExp.$?

Question

How can I extract the parameters stored in a JSON object inside a function() call using RegExp.$?

I am attempting to extract a set of parameters for RegExp.$ (also known as JavaScript f-strings) from a JSON file.

const schema = require('../schema.json').Flights;
class flightRepo{
    keys = Object.keys(schema);

    create(db) {    
        return client.query(
            "INSERT INTO flights ($1, $2, $3, $4, $5, $6) VALUES ($7, $8, $9, $10, $11, $12)",
            keys[0], keys[1], keys[2], keys[3], keys[4], keys[5],
            db.schema.keys[0], db.schema.keys[1], db.schema.keys[2], db.schema.keys[3], db.schema.keys[4], db.schema.keys[5]
        );
    }
}

ABOUT
client.query: Utilizes the Client Object from Deno's PostgreSQL Library
db: Receives a list [args[0-5] for each key] to generate a new DB entry
create: Function returns the query status obtained from PostgreSQL

JSON STRUCTURE

{
    "Flights" : {
        "FlightNo": "INT PRIMARY KEY",
        "Airlines": "STRING 50",
        "Time"": "DATETIME",
        "OnTime": "BOOLEAN",
        "Dep": "STRING 4",
        "Arr": "STRING 4"
    }
}

My goal was to eliminate the manual specification of n args (keys[0-5]) and ($1-12), and instead come up with an expression that can handle any x-item key list.

(plus, finding a way to omit the need to enter "Flights" as the JSON key in Line 1 would be beneficial)

javascript json regex string

Answer 1

Answer №1

To adjust the code for varying number of keys, use $# tokens based on the keys array in a template literal and spread notation for spreading out the arrays; refer to comments:

const schema = require('../schema.json').Flights;

class flightRepo {
//    ^−−−−−−−−−−−−−−−−−−−−−−−−−−−−−− capitalizing convention should be followed here
    keys = Object.keys(schema);

    create(db) {    
        return client.query(
            `INSERT INTO flights (${keys.map((_, i) => `${i + 1}`)}) VALUES (${keys.map((_, i) => `${i + 1 + keys.length}`})`,
            ...keys,
            ...db.schema.keys // Assuming `db.schema.keys` has the same length as `keys`
        );
    }
}

It would be helpful to find a way to eliminate entering the "Flights" JSON key in Line 1

To specify which part of the object you need, utilize destructuring with renaming:

const {Flights: schema} = require('../schema.json');

...however, maintaining the current naming might offer better clarity. Alternatively:

const {Flights} = require('../schema.json');

...utilize Flights instead of schema. But if it's not a constructor function, using uppercase may lead to confusion.

Since Flights appears to be the only property in the JSON example, you can try this:

const data = require("schema.json");
const schema = data[Object.keys(data)[0]];

Answer 2

To adjust the code for varying number of keys, use $# tokens based on the keys array in a template literal and spread notation for spreading out the arrays; refer to comments:

const schema = require('../schema.json').Flights;

class flightRepo {
//    ^−−−−−−−−−−−−−−−−−−−−−−−−−−−−−− capitalizing convention should be followed here
    keys = Object.keys(schema);

    create(db) {    
        return client.query(
            `INSERT INTO flights (${keys.map((_, i) => `${i + 1}`)}) VALUES (${keys.map((_, i) => `${i + 1 + keys.length}`})`,
            ...keys,
            ...db.schema.keys // Assuming `db.schema.keys` has the same length as `keys`
        );
    }
}

It would be helpful to find a way to eliminate entering the "Flights" JSON key in Line 1

To specify which part of the object you need, utilize destructuring with renaming:

const {Flights: schema} = require('../schema.json');

...however, maintaining the current naming might offer better clarity. Alternatively:

const {Flights} = require('../schema.json');

...utilize Flights instead of schema. But if it's not a constructor function, using uppercase may lead to confusion.

Since Flights appears to be the only property in the JSON example, you can try this:

const data = require("schema.json");
const schema = data[Object.keys(data)[0]];

How can I extract the parameters stored in a JSON object inside a function() call using RegExp.$?

Answer №1

Similar questions

Configuring an Android application by parsing JSON data

Identify the moment when the user modifies the sequence of a sortable table

What is the best way to swap the values of options between two input select elements?

Looking to access the layout details of an HTML element similar to what can be done in Firefox's debugger tool?

The instance is referencing "greet" during render, but it is not defined as a property or method

"We are experiencing issues with the app.get function and it is

What steps should I take to integrate my Node.js code into a website successfully?

In Laravel, Inertia.js will automatically close a modal if there are no validation errors present

Maintaining parameter values through multiple states using Angular and UI-Router

The Node.js response triggers an error message stating: 'SyntaxError: JSON.parse: unexpected end of data.'

Utilizing Dictionary Comprehension to Filter Key/Value Pairs Based on Conditions in API Response

Alternating Text Color jQuery Sequencing

How to extract iframe page title with jQuery in JavaScript

Safari's mysterious vanishing act: Elements go missing in Vue.js

Explore the format outlined in the setup file

Validation of textfields using React.js

Unresolved styles in React component linked to styles.css file

What is the best way to use form input to filter an Observable?

Heroku's Ban on Loading Mixed Content over HTTP

No data coming back from API in JSON format