Insertion without a model

[lexkrstn]

How to use bun as a query builder to insert a row into the database?

When I try this:

_, err = r.db.NewInsert().
	Table("custom_path").
	Value("port_a_id", portAId).
	Value("port_b_id", portBId).
	Value("checkpoints", strings.Join(checkpoints, ",")).
	Value("path", "st_geomfromgeojson(?)", pathJson).
	On("conflict (port_a_id, port_b_id, checkpoints) do update").
	Set("path = excluded.path").
	Exec(r.ctx)

I get an error "bun: Model(nil)".

[vmihailenco]

Looks like a bug.

[moutoum]

Hi, I'd be very interested by this feature aswell. Do you have a plan to implement this?
Thanks

[i-fix-retarded-bugs]

Still not fixed? Well

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[your-diary]

Any updates?

[j2gg0s]

_, err = r.db.NewInsert().
Table("custom_path").
Value("port_a_id", portAId).
Value("port_b_id", portBId).
Value("checkpoints", strings.Join(checkpoints, ",")).
Value("path", "st_geomfromgeojson(?)", pathJson).
On("conflict (port_a_id, port_b_id, checkpoints) do update").
Set("path = excluded.path").
Exec(r.ctx)

Why not use raw query?

db.NewRaw("INSERT INTO custom_path(port_a_id, port_b_id) VALUES(?, ?)", portAId, portBId).Exec(ctx)

[your-diary]

@j2gg0s

Why not use raw query?

I agree the example in the OP may be a bit too simplified, but in real-world situations, I believe ORM is often utilized to dynamically (conditionally) construct SQL queries:

query := db.NewInsert().Table("some_table")
if someCondition {
    query = query.Value(...)
}
if anotherCondition {
    query = query.Value(...)
}
query.Exec(...)

So, while NewRaw() is useful, I think it does not solve the core point of this issue.

[j2gg0s]

From the example, it seems more like a SQL Builder rather than an ORM.

On the other hand, the core of Bun is the Model. There is no way to generate SQL without relying on the Model.