val exposedVersion: String by project
repositories {
    maven {
			name = "GitHubPackages"
			url = uri("https://maven.pkg.github.com/tpasipanodya/exposed")
			credentials {
				username = System.getenv("GITHUB_USERNAME")
				password = System.getenv("GITHUB_ACCESS_TOKEN")
			}
		}
}

dependencies {
    implementation(platform("io.taff.exposed:exposed-bom:0.10.0"))
    implementation("io.taff.exposed", "exposed-core")
    implementation("io.taff.exposed", "exposed-dao")
    implementation("io.taff.exposed", "exposed-jdbc")
}

CurrentUserId = ThreadLocal<Long>()

object users : LongIdTable() {
    val name = varchar("name", length = 50) // Column<String>
}

object posts : LongIdTable() {
    val text = text("text")
    val userId = integer("user_id") references users.id

    override val defaultFilter = { Op.build { userId eq CurrentUserId.get() } }
}

fun main() {
    Database.connect(db_url)
    transaction {
        SchemaUtils.create(users, posts)
        
        val user1Id = users.insert { it[name] = "User 1" }[users.id]
        val user2Id = users.insert { it[name] = "User 2" }[users.id]

        posts.insert {
            it[userId] = user1Id
            it[text] = "foo bar"
        }
        posts.insert {
            it[userId] = user2Id
            it[text] = "lorem ipsum"
        }

        CurrentUserId.set(user1Id)
        var retrievedText = posts.selectAll().single()[posts.text]

       
        println(retrievedText == "foo bar")
        //> true

        CurrentUserId.set(user2Id)
        retrievedText = posts.selectAll().single()[posts.text]

        
        println(retrievedText == "lorem ipsum")
        //> true
        
        // Any persisted record must have an id but the following update statment 
        // applies the table's default filter, hence only the current user's post 
        // will be updated.
        val newText =  "Let's get it started in here"
        posts.update({ id.isNotNull() }) { it[text] = newText }

        posts.stripDefaultFilter()
            .orderBy(posts.userId, SortOrder.Asc)
            .selectAll()
            .map { it[posts.userId] to it[posts.text] }
            .let { allTexts -> 
                // true
                listOf(
                    user1Id to "foo bar", 
                    user2Id to newText
                ) == allTexts
            }
    }
}