Insert value by Fernet.generate_key() into bytea?

Question

I've tried

SQL

CREATE TABLE table_name (key BYTEA, key_uuid UUID)

Python

cur.execute(f"INSERT INTO table_name (key, key_uuid) VALUES({Fernet.generate_key()}, uuid_generate_v4())")

It gives an error:

psycopg2.errors.InvalidTextRepresentation: "j" is not a valid binary digit
LINE 1: ...me (key, key_uuid) VALUES(b'jBB72dwn...
                                     ^

Or am I understanding this wrong..?

@MayankPorwal crypto key, random byte literal to encode and decode data — Shmookoff, Mar 21 '21 at 15:49
Don't use string interpolation (f-strings) to set values in SQL strings. Pass the value to the `execute` method, it'll properly inject it into the query. See [the documentation](https://www.psycopg.org/docs/usage.html#passing-parameters-to-sql-queries). — Marth, Mar 21 '21 at 15:52

score 2 · Answer 1 · answered Mar 21 '21 at 16:33

2

The issue was that I used f-strings. Don't use them, yeah... Documentation

Thanks @Marth ♥

answered Mar 21 '21 at 16:33

Shmookoff

146
1
10

Insert value by Fernet.generate_key() into bytea?

1 Answers1