Writing twice to sqlite database and get error SQLSTATE[HY000]: General error: 5 database is locked

[ffuentese]

I wrote the following function to get input from the user

app()->post('/createThread', function () {
        
  $user = auth()->user()->get();
  if (!$user) {
      return response()->render('login',[
      'status' => 'error',
      'message' => 'Debe iniciar sesión',
      'data' => auth()->errors(),
    ]);
  }
 
$userData = request()->get(['title', 'message', 'topic_id']);
$db = db();
    $db->insert('threads')->params([
        'title' => $userData['title'],
        'user_id' => auth()->id(),
        'topic_id' => $userData['topic_id']
   ])->execute();
 
  $thread_id = $db->lastInsertId();
 
$db->insert('comments')->params([
        'message'=>$userData['message'],
        'user_id' => auth()->id(),
        'thread_id'=>$thread_id
 ])->execute();
 
  return response()->redirect('/thread/{$thread_id}');
 
});

However, I'm getting the aforementioned error 5 and I tried with the transaction function callback but I get another error "no active transaction". The documentation is not super exhaustive and no resource is helpful. Thanks.

[fadrian06]

If you add $this->queryResult = null in the \Leaf\Db\Core@execute method, it works, so I have to mock auth() and db()

[fadrian06]

one fix could be add this before your require 'vendor/autoload.php':

NOTE: I'm using php 8.3

use Leaf\Auth;
use Leaf\Config;
use Leaf\Db;

/**
 * Return the leaf auth object
 *
 * @return Leaf\Auth
 */
function auth()
{
  if (!Config::getStatic('auth')) {
    Config::singleton('auth', static fn(): Auth => new class extends Auth {
      #[Override]
      public function autoConnect(array $pdoOptions = []): static
      {
        $this->db = new class extends Db {
          #[Override]
          public function execute(): ?PDOStatement
          {
            $this->queryResult = null;

            return parent::execute();
          }
        };

        $this->db->autoConnect($pdoOptions);

        return $this;
      }
    });
  }

  return Config::get('auth');
}