Unable to query again using the geometry type obtained from the database

[coder-hxl]

geometry:

code:

Print point result:

Print error result

[sidorares]

could you tell what following code prints for you?

cont conn = await pool.getConnection();
const ps = conn.prepare(roomStatement);
console.log(ps.parameters);

I believe in your case data.polygon is serialised as a JSON.stringify string, which is probably not what server expects

node-mysql2/lib/packets/execute.js

Line 54 in 016900f

} else if (isJSON(value)) {

What is the syntax you'd use in SQL to insert points in a single query? Does pool.query works for your sql / data?

see also #1407 and #1239

we currently have the code that reads geometry

node-mysql2/lib/packets/packet.js

Line 519 in 016900f

parseGeometryValue() {

but we need to add the opposite, serialisation

[coder-hxl]

@sidorares The code is printed: undefined
I used pool.query to see if typeCast would solve the problem, now I've switched back to pool.execute

[coder-hxl]

@sidorares conn.prepare returns a Promise, When I do that

  const conn: any = await pool.getConnection()
  const ps = await conn.prepare(roomStatement)
  console.log(ps.statement.parameters)

Print result:

[
  ColumnDefinition {
    _buf: <Buffer 0c 00 00 01 00 02 00 00 00 0c 00 01 00 00 00 00 17 00 00 02 03 64 65 66 00 00 00 01 3f 00 0c 3f 00 00 00 00 01 ff 80 00 1f 00 00 05 00 00 03 fe 00 00 ... 651 more bytes>,
    _clientEncoding: 'utf8',
    _catalogLength: 3,
    _catalogStart: 21,
    _schemaLength: 0,
    _schemaStart: 25,
    _tableLength: 0,
    _tableStart: 26,
    _orgTableLength: 0,
    _orgTableStart: 27,
    _orgNameLength: 0,
    _orgNameStart: 30,
    characterSet: 63,
    encoding: 'binary',
    name: '?',
    columnLength: 16777216,
    columnType: 255,
    flags: 128,
    decimals: 31
  }
]

[sidorares]

What is the value ( and type ) of the parameter you passing, data.polygon in your example?

[sidorares]

I believe you need to pass the whole geometry text as a string to ST_GeomFromText function as a single parameter, example:

const geometry = 'MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))';
const [result] = await pool.execute('SELECT * FROM room WHERE ST_Intersects(ST_GeomFromText(?))', [geometry]);

[coder-hxl]

@sidorares I tried using recursion to parse data.polygon into strings, but it still didn't work