Fix column filter error

[kcajmagic]

The table is defined in the README.md. type is not a column in the database. In fact it is a keyword for cassandra. (It is not reserved, which is why we didn't see the problem)
This need to be fixed here:

codex-db/cassandra/db.go

Line 160 in dbee34f

deviceInfo, err := c.finder.findRecords(limit, "WHERE device_id = ? AND type = ?", deviceID, eventType)

suggestion:

 deviceInfo, err := c.finder.findRecords(limit, "WHERE device_id = ? AND record_type = ?", deviceID, eventType) 

If anywhere else the type column should be changed to record_type.

[iDevoid]

Hi @kcajmagic
I am first timer to code on open-source, can i try to do this?
I also found another line that has type = ?. is this related?

codex-db/postgresql/db.go

Line 271 in dbee34f

err := c.finder.findRecords(&deviceInfo, limit, "device_id = ? AND type = ?", deviceID, eventType)

[kcajmagic]

@iDevoid this is a perfect issue for new timers.

Yes it is related as type is also a keyword for Postgres. There will probably be more spots in that folder.

[iDevoid]

Hi @kcajmagic
would you mind to take a look to my PR #10 ?
please tell me your opinion and advice. Thank you 🙏

[kcajmagic]

Fixed in PR #10