MCPcopy Index your code
hub / github.com/dwyl/learn-postgresql / insert_rows

Function insert_rows

server/db.js:168–187  ·  view source on GitHub ↗
()

Source from the content-addressed store, hash-verified

166 const len = data.entries.length - 1;
167
168 function insert_rows () { // inner function has access to outer variables
169 data.entries.forEach((p, i) => { // poor person's "async parallel":
170 const username = p.username;
171 // console.log('username:', username);
172 select_person(username, function(error1, result1) {
173 // console.log('L251 > result1: ', result1.rows[0]);
174 const person_id = result1.rows[0].id;
175 const query = `INSERT INTO relationships (${fields}) VALUES ($1, $2)`
176 const values = [person_id, rel_id];
177 // console.log('query:', query, 'values:', values);
178 PG_CLIENT.query(query, values, function(error2, result2) {
179 utils.log_error(error2, result2, new Error().stack);
180
181 if(i === len) {
182 return insert_next_page(data, callback);
183 }
184 });
185 });
186 }); // END data.entries.forEach
187 }
188 // there are three types of relationships, we switch based on data.type
189 switch (data.type) {
190 case 'stars':

Callers 1

insert_relationshipsFunction · 0.85

Calls 2

select_personFunction · 0.85
insert_next_pageFunction · 0.85

Tested by

no test coverage detected