add sqlite test and fix sqlite tag queries

fiatjaf / eventstore

an abstraction layer over databases for nostr events

The Unlicense

26 stars 15 forks source link

Closed fiatjaf closed 1 month ago

fiatjaf commented 1 month ago

@mattn this has been wrong since the first day I wrote it. Can you just take a look to ensure I'm not crazy?

mattn commented 1 month ago

["REQ","nak",{"#e":["111111...","222222..."]}]

This should be matched to following.

"tags": [["e", "11111..."]],

"tags": [["e", "222222..."], ["e", "11111..."]],

not a

"tags": [["e", "11111...", "222222..."]],

Right? Then, this PR should fix the problem.

fiatjaf commented 1 month ago

Yes, I think.