asimov | Agent-based SImulation , MOdeling , and Visualization | Data Visualization library

I am learning JSON function in mariaDB where I have

CREATE TABLE IF NOT EXISTS products ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, type VARCHAR(1) NOT NULL, name VARCHAR(40) NOT NULL, format VARCHAR(20) NOT NULL, price FLOAT(5, 2) NOT NULL, attr JSON NOT NULL)

INSERT INTO products (type, name, format, price, attr) VALUES ('M', 'Aliens', 'Blu-ray', 13.99,'{"video": {"resolution": "1080p", "aspectRatio": "1.85:1"}, "cuts": [{"name": "Theatrical", "runtime": 138}, {"name":"Special Edition", "runtime": 155}], "audio": ["DTS HD", "Dolby Surround"]}'); INSERT INTO products (type, name, format, price, attr) VALUES ('B', 'Foundation', 'Paperback', 7.99, '{"author": "Isaac Asimov", "page_count": 296}');

I want to find how many records are there where Cuts.name="Theatrical"

Something is wrong when I try to find the person who has the closest Age to Sonya Sotomayor. Can anyone detect my error?

So I have an entire program below that creates Book objects, initializes them, and prints any constructors/destructors that are created or destroyed throughout the execution of the program.

I have ran my code (and pasted the output below), and I am having trouble understanding how the destructors are being called. So I know that the constructors are destroyed in the opposite order in which they were created. But I don't get why four of the destructor statements have an id of 4. I'm assuming one came from the "explicit call to the copy constructor", the other came from "declaring and initializing book 6 from book 5", and the other came from the first part of "declaring and initializing books 1 to 4." But I'm confused as to where the extra id of 4 came from?

Additionally, I was wondering why a "-- dtor: 0" wasn't printed for the "declaring book 5" part where default ctor: 0 was created.

I would really appreciate any clarification!

main.cc:

I am a beginner to C, and essentially, I am trying to read a file char by char, and echo the characters to the output, but also, at the start of every line, include the line number. I have managed to figure out how to count the lines, but when I attempt to insert the line number, I can't figure out how to get it to insert on the next line, rather than immediately upon encountering the newline.

Here is my code:

The question is about lookahead and lookbehind assertion.

Reference to lookahead:

...

Using this data:

So I am fairly new to the express framework and to the mongoose database, I mostly used relational databases. I want to create a database with the following script, I have the mongod.exe running and listening on localhost:27017, and this works as I can connect to it via mongo.exe and via http. However when I try to run the script with node nameOfTheScript I keep getting

(node:1000) DeprecationWarning: current URL string parser is deprecated, and will be removed in a future ver sion. To use the new parser, pass option { useNewUrlParser: true } to MongoClient.connect. FINAL ERR: ValidationError: genre: Path genre is required.

my script:

How do I iterate the directory contents and put each file into a List or other collection?

Here is basically the problem. I am given a huge file. A text, that has a lot of blank spaces. I must write a program that removes the blank spaces, creates lines of exactly 80 characters long without splitting any word, and it will align the text to left and right simultaneously (justify text); The text is justified by placing additional spaces between words so that the line will end with a word and start with word, being exactly 80 chars long.

Yes this is a homework, but I am allowed to get any kind of online help. My code this far is able to do everything but align the text (justify):

Code: