boogerlad/mj - Change OLMU4W2JCB5WXCGSS4ZD4LPLXVLFX3KCTOCI4VLNF765ZXHOGPDQC

multiple out parameters are returned as a composite value: https://www.postgresql.org/docs/current/rowtypes.html#id-1.5.7.24.6 so ignore the open bracket prefix and the close bracket suffix, and then split by comma to get the variant id and the gram equivalency for freshly inserted, g will be '', so no equality check will happen. otherwise compare previous(selected) and current(from scrape)

Created by boogerlad on March 18, 2020

OLMU4W2JCB5WXCGSS4ZD4LPLXVLFX3KCTOCI4VLNF765ZXHOGPDQC

Dependencies

In channels

main

Change contents

Replacement in scrape/ocs.ca.js at line 229 [4.11674]

B:BD[3.885] → [2.5579:5725]

				console.log('gram equivalency', gram_equivalency);
				let variantID = (await postgres.query(`select ios_variant_id($1, $2, $3, $4, $5)`, [

[3.885]

[2.5725]

				let [variantID, g] = (await postgres.query(`select ios_variant_id($1, $2, $3, $4, $5)`, [

Replacement in scrape/ocs.ca.js at line 234 [4.11674]

B:BD[2.5805] → [2.5805:5894]

					gram_equivalency
				])).rows[0];
				console.log('vid', variantID);// => '(1,)'

[2.5805]

[4.23050]

					gram_equivalency.toString()
				])).rows[0].ios_variant_id.slice(1, -1).split(',');
				if(g.length && !gram_equivalency.eq(g)) {
					console.log('warning: gram_equivalency does not match', gram_equivalency.toString(), g, productID, variantID, `${url}/products/${e[i][j].handle}?variant=${e[i][j].objectID}`);
				}

Replacement in scrape/ocs.ca.js at line 241 [4.11674]
B:BD[4.23117] → [4.23117:23133]
```
						variant,
```
[4.23117]
[4.23133]
```
						variant_id,
```

Dependencies

In channels

Change contents

Replacement in scrape/ocs.ca.js at line 229 [4.11674]

Replacement in scrape/ocs.ca.js at line 234 [4.11674]

Replacement in scrape/ocs.ca.js at line 241 [4.11674]