SQLite3、Sequelでそんなテーブルはない(no such table:)と言われる

Question

前提・実現したいこと

Ruby、SQLite、Sequelを使用しています。
データベースに情報を書き込むプログラムを作ろうとしていますが、あるはずのテーブルがないといわれます。
Rubyのプログラムを２つに分けてこれを実行しようとしていますが、１つにしてもやはり、ダメでした（下記に記載）。
なぜうまくいかないのか、わかる人がいればよろしくお願い申し上げます。

発生している問題・エラーメッセージ

user@usernoMacBook-Air ruby % ruby test.rb
/Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize': SQLite3::SQLException: no such table: article (Sequel::DatabaseError)
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `new'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `prepare'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:193:in `execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block (2 levels) in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/logging.rb:38:in `log_connection_yield'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/connection_pool/threaded.rb:92:in `hold'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/connecting.rb:269:in `synchronize'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:193:in `_execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:159:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:1109:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:401:in `insert'
	from /Users/user/ruby/test2.rb:8:in `putdb'
	from test.rb:4:in `<main>'
/Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize': no such table: article (SQLite3::SQLException)
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `new'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `prepare'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:193:in `execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block (2 levels) in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/logging.rb:38:in `log_connection_yield'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/connection_pool/threaded.rb:92:in `hold'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/connecting.rb:269:in `synchronize'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:193:in `_execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:159:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:1109:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:401:in `insert'
	from /Users/user/ruby/test2.rb:8:in `putdb'
	from test.rb:4:in `<main>'

該当のソースコード

test.rb

require './test2.rb'

putdb(20211028111, "SQLiteについて", "https://www.google.com/")

test2.rb

require 'sqlite3'
require 'sequel'

def putdb(id, midashi, url)

    db = Sequel.connect('sqlite:./test.db')
    db[:article].insert(fugou: id, midashi: midashi, url: url)
end

test.sql

CREATE TABLE IF NOT EXISTS article(
    fugou INTEGER PRIMARY KEY, -- id 一意の値
    midashi TEXT NOT NULL, -- 見出し 文字列
    url TEXT UNIQUE NOT NULL -- URL 文字列
);
SELECT * FROM article;
.tables
.schema

試したこと

articleテーブルが存在している証明

user@usernoMacBook-Air ruby % sqlite3 test.db < test.sql
article
CREATE TABLE article(
    fugou INTEGER PRIMARY KEY, -- id 一意の値
    midashi TEXT NOT NULL, -- 見出し 文字列
    url TEXT UNIQUE NOT NULL -- URL 文字列
);

test3.rb(test.rbとtest2.rbを統合したもの)

#! /usr/bin/env ruby

db = Sequel.connect('sqlite:./test.db')

db[:article].insert(20211028111, "SQLiteについて", "https://www.google.com/")
# putdb(20211028111, "SQLiteについて", "https://www.google.com/")

user@usernoMacBook-Air ruby % ruby test3.rb  
/Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize': SQLite3::SQLException: no such table: article (Sequel::DatabaseError)
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `new'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `prepare'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:193:in `execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block (2 levels) in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/logging.rb:38:in `log_connection_yield'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/connection_pool/threaded.rb:92:in `hold'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/connecting.rb:269:in `synchronize'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:193:in `_execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:159:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:1109:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:401:in `insert'
	from test3.rb:6:in `<main>'
/Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize': no such table: article (SQLite3::SQLException)
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `new'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `prepare'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:193:in `execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block (2 levels) in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/logging.rb:38:in `log_connection_yield'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:202:in `block in _execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/connection_pool/threaded.rb:92:in `hold'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/database/connecting.rb:269:in `synchronize'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:193:in `_execute'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/adapters/sqlite.rb:159:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:1109:in `execute_insert'
	from /Users/user/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sequel-5.49.0/lib/sequel/dataset/actions.rb:401:in `insert'
	from test3.rb:6:in `<main>'

補足情報（FW/ツールのバージョンなど）

ruby 3.0.2p107 (2021-07-07 revision 0db68f0233) [arm64-darwin20]
SQLite version 3.36.0 2021-06-18 18:58:49
sequel (5.49.0)
macOS 12.0.1

Answer 1

以下の部分ですが、

db = Sequel.connect('sqlite:./test.db')

Method: Sequel.connect によれば、以下の様に記述する様です。

db = Sequel.connect('sqlite://test.db')

Comments

[decatail]

大変ありがとうございました。ご教授頂いた部分を直したら動きました。初歩的なミスであろうとは思っていましたが、test.dbはきちんと読み込んでいるようだと判断してそこが原因ではないと思い込んでいました。重ね重ねありがとうございました。