How to bind database record upon successful insert query

Asked May 07 '21 at 01:51

Active May 30 '21 at 21:19

Viewed 74 times

ScanCAS() & MapScanCAS() are returning the values of the database row(old), only if the insert statement is not applied on a database table.

insertQuery = "INSERT INTO my_table (id, column1, column2) " + "VALUES (?, ?, toTimeStamp(now())) IF NOT EXISTS"

applied, err := session.Query(insertQuery,ID,column1).ScanCAS(&id,
        &value1,
        &value2)

How to bind the values of table row, upon successful insert? because ScanCAS binds the values(previous) only with failed attempt of insert query....

edited May 30 '21 at 21:19

Jonathan Hall

75,165
16
143
189

asked May 07 '21 at 01:51

overexchange

15,768
30
152
347

but do you have data that you attempted to insert? – Alex Ott May 07 '21 at 06:06
@AlexOtt yes I have that data, except timestamp (third column) generated by database. – overexchange May 07 '21 at 06:42
unfortunately this is how Cassandra behaves. Anyway it's usually recommended to generate timestamp on the client side instead of relying on `now()` – Alex Ott May 07 '21 at 06:54
@AlexOtt If client machine sits in different time zone than database machine? – overexchange May 07 '21 at 14:02
generate in UTC - cassnadra is doing it anyway – Alex Ott May 07 '21 at 14:17

How to bind database record upon successful insert query

0 Answers0