Create table
In Appwrite, data is stored as a table of rows. Create a table in the Appwrite Console to store our ideas.
Create a new table with the following columns:
| Column | Type | Required | Size |
userId | String | Yes | 200 |
title | String | Yes | 200 |
description | String | No | 500 |
Navigate to the Settings tab of your table, add the role Any and check the Read box. Next, add a Users role and give them access to Create, Update and Delete by checking those boxes.
Add and remove methods
Now that you have a table to hold ideas, we can read and write to it from our app. Create a new file services/IdeasService.kt and add the following code to it. Replace the values for ideaDatabaseId and ideaTableId with the IDs of the database and table you created in the previous step.
package <YOUR_ROOT_PACKAGE_HERE>.services
import io.appwrite.Client
import io.appwrite.ID
import io.appwrite.Query
import io.appwrite.models.Row
import io.appwrite.services.TablesDB
class IdeaService(client: Client) {
companion object {
private const val ideaDatabaseId = "<YOUR_IDEA_DATABASE_ID_HERE>"
private const val ideaTableId = "<YOUR_IDEA_TABLE_ID_HERE>"
}
private val tablesDB = TablesDB(client)
suspend fun fetch(): List<Row<Map<String, Any>>> {
return tablesDB.listRows(
ideaDatabaseId,
ideaTableId,
listOf(Query.orderDesc("\$createdAt"), Query.limit(10))
).rows
}
suspend fun add(
userId: String,
title: String,
description: String
): Row<Map<String, Any>> {
return tablesDB.createRow(
ideaDatabaseId,
ideaTableId,
ID.unique(),
mapOf(
"userId" to userId,
"title" to title,
"description" to description
)
)
}
suspend fun remove(id: String) {
tablesDB.deleteRow(
ideaDatabaseId,
ideaTableId,
id
)
}
}
Update the services/Appwrite.kt file to add a new property for the IdeaService class.
Look for // Add this line 👇 to find where the changes made here.
package io.appwrite.tutorialforandroid.services
import android.content.Context
import io.appwrite.Client
object Appwrite {
private const val ENDPOINT = "https://<REGION>.cloud.appwrite.io/v1"
private const val PROJECT_ID = "<PROJECT_ID>"
private lateinit var client: Client
// Add this line 👇
internal lateinit var ideas: IdeaService
internal lateinit var account: AccountService
fun init(context: Context) {
client = Client(context)
.setEndpoint(ENDPOINT)
.setProject(PROJECT_ID)
// Add this line 👇
ideas = IdeaService(client)
account = AccountService(client)
}
}