@Entity
data class User (
    val name: String,
    val password: String,
    @PrimaryKey @ColumnInfo(name = "device_id") val deviceId: String,
    @ColumnInfo(name = "current_ip") val currentIp: String = "",
    @ColumnInfo(name = "current_port") val currentPort: Int = 0
)

@Dao
interface UserDao {
    @Query("SELECT * FROM user")
    fun getAllUsers(): List<User>

    @Query("SELECT * FROM user WHERE name=:name AND password=:password")
    fun getUser(name: String, password: String): User?

    @Insert
    fun insert(user: User)

    @Update
    fun update(user: User)

    @Delete
    fun delete(user: User)
}

@Database(entities = [User::class], version = 4, exportSchema = false)
abstract class Database : RoomDatabase() {
    abstract fun userDao(): UserDao
}