$ rails db
を実行
sqlite> .mode line
で見た目を整える
sqlite> .tables
テーブルの確認
ar_internal_metadata my_memos schema_migrations
sqlite> select * from my_memos;
dbの中身の確認ができる
sqlite> select * from my_memos
...> quit
...> ;
id = 3
title = test2
comment = test2
created_at = 2023-09-04 14:25:32.420428
updated_at = 2023-09-04 14:25:32.420428
sqlite> .schema
で設定の確認ができる
CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY);
CREATE TABLE IF NOT EXISTS "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
CREATE TABLE IF NOT EXISTS "my_memos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "comment" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
CREATE TABLE sqlite_sequence(name,seq);