Androidで DBのフレームワーク SQLDelightを使う方法、公式の手順だとエラーしか出ない罠

pluginManagement {
    // SQLDelight
    resolutionStrategy {
        eachPlugin {
            if (requested.id.namespace == 'com.squareup') {
                useModule('com.squareup.sqldelight:gradle-plugin:+')
            }
        }
    }
    repositories {
        gradlePluginPortal()
        google()
        mavenCentral()
    }
}
...

plugins {
    id 'com.android.application'
    id 'org.jetbrains.kotlin.android'

    // SQLDelight
    id 'com.squareup.sqldelight'
}

...


// SQLDelight
// archivesBaseName = 'sample-common'

// SQLDelight
sqldelight {
    HockeyDb {
        packageName = "com.example.testsqldelight"
    }
    linkSqlite = true
}

dependencies {

    implementation 'androidx.core:core-ktx:1.7.0'
    implementation 'androidx.appcompat:appcompat:1.4.1'
    implementation 'com.google.android.material:material:1.5.0'
    implementation 'androidx.constraintlayout:constraintlayout:2.1.3'
    testImplementation 'junit:junit:4.13.2'
    androidTestImplementation 'androidx.test.ext:junit:1.1.3'
    androidTestImplementation 'androidx.test.espresso:espresso-core:3.4.0'

    // SQLDelight
    // https://cashapp.github.io/sqldelight/android_sqlite/
    implementation "com.squareup.sqldelight:android-driver:1.5.3"

/**
 * hockeyPlayer table define
 */
CREATE TABLE hockeyPlayer (
  player_number INTEGER NOT NULL,
  full_name TEXT NOT NULL
);

/**
 * Initialize hockeyPlayer table at install application
 */
CREATE INDEX hockeyPlayer_full_name ON hockeyPlayer(full_name);

INSERT INTO hockeyPlayer (player_number, full_name)
VALUES (15, 'Ryan Getzlaf');

/**
 * SQL
 */
selectAll:
SELECT *
FROM hockeyPlayer;

insert:
INSERT INTO hockeyPlayer(player_number, full_name)
VALUES (?, ?);

update:
UPDATE hockeyPlayer
SET full_name = :full_name
WHERE player_number = :player_number;

insertOrReplace:
INSERT OR REPLACE INTO hockeyPlayer(player_number, full_name)
VALUES (?, ?);

insertFullPlayerObject:
INSERT INTO hockeyPlayer(player_number, full_name)
VALUES ?;

deleteAll:
DELETE
FROM hockeyPlayer;

package com.example.testsqldelight

import android.os.Bundle
import android.util.Log
import androidx.appcompat.app.AppCompatActivity
import com.squareup.sqldelight.android.AndroidSqliteDriver
import com.squareup.sqldelight.db.SqlDriver

class MainActivity : AppCompatActivity() {
    override fun onCreate(savedInstanceState: Bundle?) {
        super.onCreate(savedInstanceState)
        setContentView(R.layout.activity_main)

        val driver: SqlDriver = AndroidSqliteDriver(HockeyDb.Schema, applicationContext, "test.db")

        // In reality the database and driver above should be created a single time
        // and passed around using your favourite dependency injection/service
        // locator/singleton pattern.
        val database = HockeyDb(driver)

        val playerQueries: PlayerQueries = database.playerQueries

        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())
        // Prints [HockeyPlayer(15, "Ryan Getzlaf")]

        playerQueries.insert(player_number = 10, full_name = "Corey Perry")
        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())
        // Prints [HockeyPlayer(15, "Ryan Getzlaf"), HockeyPlayer(10, "Corey Perry")]

        val player = HockeyPlayer(10, "Ronald McDonald")
        playerQueries.insertFullPlayerObject(player)
        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())

        playerQueries.update(player_number = 15, full_name = "update")
        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())

        playerQueries.insertOrReplace(player_number = 10, full_name = "insertOrReplace")
        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())

        playerQueries.update(player_number = 10, full_name = "update 10")
        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())

        playerQueries.deleteAll()
        Log.e("SQLDelight", playerQueries.selectAll().executeAsList().toString())
    }
}

2022-04-17 20:11:43.698 23557-23557/com.example.testsqldelight E/SQLDelight: [HockeyPlayer [
      player_number: 15
      full_name: Ryan Getzlaf
    ]]
2022-04-17 20:11:43.711 23557-23557/com.example.testsqldelight E/SQLDelight: [HockeyPlayer [
      player_number: 15
      full_name: Ryan Getzlaf
    ], HockeyPlayer [
      player_number: 10
      full_name: Corey Perry
    ]]
2022-04-17 20:11:43.725 23557-23557/com.example.testsqldelight E/SQLDelight: [HockeyPlayer [
      player_number: 15
      full_name: Ryan Getzlaf
    ], HockeyPlayer [
      player_number: 10
      full_name: Corey Perry
    ], HockeyPlayer [
      player_number: 10
      full_name: Ronald McDonald
    ]]
2022-04-17 20:11:43.738 23557-23557/com.example.testsqldelight E/SQLDelight: [HockeyPlayer [
      player_number: 15
      full_name: update
    ], HockeyPlayer [
      player_number: 10
      full_name: Corey Perry
    ], HockeyPlayer [
      player_number: 10
      full_name: Ronald McDonald
    ]]
2022-04-17 20:11:43.749 23557-23557/com.example.testsqldelight E/SQLDelight: [HockeyPlayer [
      player_number: 15
      full_name: update
    ], HockeyPlayer [
      player_number: 10
      full_name: Corey Perry
    ], HockeyPlayer [
      player_number: 10
      full_name: Ronald McDonald
    ], HockeyPlayer [
      player_number: 10
      full_name: insertOrReplace
    ]]
2022-04-17 20:11:43.764 23557-23557/com.example.testsqldelight E/SQLDelight: [HockeyPlayer [
      player_number: 15
      full_name: update
    ], HockeyPlayer [
      player_number: 10
      full_name: update 10
    ], HockeyPlayer [
      player_number: 10
      full_name: update 10
    ], HockeyPlayer [
      player_number: 10
      full_name: update 10
    ]]
2022-04-17 20:11:43.778 23557-23557/com.example.testsqldelight E/SQLDelight: []

Androidで Twitter4Jを使って Twitterのユーザー タイムラインを丸っと取得する方法

Androidの公式 Twitterライブラリで Twitterのユーザー タイムラインを丸っと取得する方法

.NET C#の Tweetinviライブラリで Twitterの投稿内容を投稿画像込みで丸っと取得する方法

Pythonの Tweepyライブラリで Twitterの投稿内容を投稿画像込みで丸っと取得する方法

ちいかわの単行本を買ってみた！もちろん特装版！

すみっコぐらし サンエックスの人気キャラクター お菓子のキッシュシュクレ（タルト）、フィナンシェ

【全集中の呼吸】鬼滅の刃の食玩お菓子を買ったら報告するスレ、オマケシール集め【鬼殺隊】

【我が道を】遂にガチの食玩にも手を出してしまった。。。Re:ゼロから始める異世界生活ウエハース vol.3【突き進むのみ】

テレビアニメ ご注文はうさぎですか？ 通称「ごちうさ」のフィギュアを買ったのでレビュー