ErrRecordNotFound doesn't return an error?

[phantomdenkali]

Hi everyone, new to gorm here so this may be an obvious one to others: I am trying to check if a record already exists in the database before creating an object.

In my model. I have a BeforeCreate function that returns a uuid for the new row AFTER the following check:

err := tx.First(&existingFile, "file_id = ?", FileID).Error 
val := [errors.Is](http://errors.is/)(err, gorm.ErrRecordNotFound) 
fmt.Printf(" value of errors is %v \n", val)

However, what I find is that even with an empty database, there is no error generated on running the qyery. Is there a different way to check if the row already exists?

I am using sqllite, relevant entries in go.mod are:

gorm.io/driver/sqlite v1.5.2
gorm.io/gorm v1.25.2

[phantomdenkali]

never mind, my database was locked and hence the query was failing. all works well