Cannot get count of COPY query

[ChristophP]

Hi @porsager thanks for making this library.

We are currently trying to migrate our data base code to this library and don't know how to get the count of a COPY query.

Our code looks like this:

const query = sql`COPY transaction (name) FROM STDIN`;
console.log(query.writeable); // undefined
console.log(await query); // Writeable

Normally one would use the .count property as described here https://github.com/porsager/postgres#count in the docs, but the problem is that in the example above await query is not a Result object but a Writeable (and thus has no .count property).

From the docs it seemed to me that one would have to call .writeable() on the query in order to get the stream but that's not what the console.log shows. I'm I missunderstanding something or should this behave differently?

[ChristophP]

Never mind. Layer 8 problem, typing .writable() instead of .writeable() helps a lot. :-(

[ChristophP]

But I still have a remaining question:

If this is the way to copy rows into a table using streams

const query = await sql`copy users (name, age) from stdin`.writable()
await pipeline(userStream, query);

Is there a way to get the Result.count somehow to find out how many rows got inserted? Since all I get is the Writable and not a Result

Additional info: I seem to get the Writable whether I actually call .writable() or not.

await sql`copy users (name, age) from stdin`;           // Writable
await sql`copy users (name, age) from stdin`.writable() // Writeable

[jgnieuwhof]

I too am looking for this feature!

Is there a way to glean count information from the COPY command / stream?

[porsager]

Yeah, it's available, but not until CommandComplete is sent by the db, which happens after the stream is finished.

Thinking of that now appears to be the wrong behaviour. I think for v4 it'd be better to push error handling to the stream, both initial query, and also wait for CommandComplete. That way we could include the count too.