Requery 4 - RecyclerView ומחיקת Watching

     implementation(libs.appcompat)
     implementation(libs.constraintlayout)
     implementation(libs.material)
+    implementation("androidx.recyclerview:recyclerview:1.4.0")
     testImplementation(libs.junit)

 <resources>
-    <string name="app_name">sqlrequery</string>
-    <string name="add_student">Add Student</string>
-    <string name="add_movie">Add Movie</string>
-    <string name="add_watching">Add Watching</string>
+    <string name="app_name">Class Netflix</string>
+    <string name="title">🎬 WHO WATCHED WHAT?</string>
+    <string name="add_student">Add student</string>
+    <string name="add_movie">Add movie</string>
+    <string name="add_watching">Add watching</string>
+    <string name="column_student">Student</string>
+    <string name="column_movie">Movie</string>
+    <string name="column_rating">Rating</string>
+    <string name="column_action">Action</string>
+    <string name="delete">Delete</string>
+    <string name="rating_value">%1$d</string>
 </resources>

 <?xml version="1.0" encoding="utf-8"?>
-<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
-    xmlns:app="http://schemas.android.com/apk/res-auto"
-    xmlns:tools="http://schemas.android.com/tools"
-    android:id="@+id/main"
+<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
     android:layout_width="match_parent"
     android:layout_height="match_parent"
-    tools:context=".MainActivity">
+    android:orientation="vertical"
+    android:padding="24dp">
+
+    <TextView
+        android:layout_width="wrap_content"
+        android:layout_height="wrap_content"
+        android:layout_marginBottom="12dp"
+        android:text="@string/title"
+        android:textSize="24sp"
+        android:textStyle="bold" />

     <LinearLayout
-        android:layout_width="0dp"
+        style="?android:attr/buttonBarStyle"
+        android:layout_width="match_parent"
         android:layout_height="wrap_content"
-        android:layout_marginHorizontal="16dp"
-        android:layout_marginTop="16dp"
-        android:orientation="horizontal"
-        app:layout_constraintEnd_toEndOf="parent"
-        app:layout_constraintStart_toStartOf="parent"
-        app:layout_constraintTop_toTopOf="parent">
+        android:layout_marginBottom="24dp"
+        android:orientation="horizontal">

         <Button
             android:id="@+id/button_add_student"
+            style="?android:attr/buttonBarButtonStyle"
⁞
         <Button
             android:id="@+id/button_add_movie"
+            style="?android:attr/buttonBarButtonStyle"
⁞
         <Button
             android:id="@+id/button_add_watching"
+            style="?android:attr/buttonBarButtonStyle"

+import android.app.Activity;
+import android.app.AlertDialog;
 import android.os.Bundle;
⁞
-import androidx.activity.EdgeToEdge;
-import androidx.appcompat.app.AlertDialog;
-import androidx.appcompat.app.AppCompatActivity;
-import androidx.core.graphics.Insets;
-import androidx.core.view.ViewCompat;
-import androidx.core.view.WindowInsetsCompat;
+import androidx.recyclerview.widget.DividerItemDecoration;
+import androidx.recyclerview.widget.LinearLayoutManager;

-/** Displays the typed join and owns the three insert dialogs. */
-public class MainActivity extends AppCompatActivity {
+/**
+ * The demo's only screen: three insert dialogs and a deletable RecyclerView of typed join results.
+ *
+ * <p>{@link ActivityMainBinding} is generated from {@code activity_main.xml}, so every XML view is
+ * accessed through View Binding rather than {@code findViewById}. Database calls stay direct and
+ * synchronous because this tiny teaching database contains only a few rows. A real application
+ * should move potentially slow database work off the main thread.</p>
+ */
+public class MainActivity extends Activity {
+    /** Generated, type-safe access to the views in {@code activity_main.xml}. */
     private ActivityMainBinding binding;
+
+    /** The Requery store used directly by this one Activity. */
     private EntityDataStore<Persistable> data;
+
+    /** Connects typed join tuples to the reusable views in the RecyclerView. */
+    private WatchAdapter adapter;
+
+    /**
+     * Inflates the bound layout, opens and seeds SQLite, wires the buttons, and displays the join.
+     *
+     * @param savedInstanceState Android's previously saved Activity state, if one exists
+     */
     @Override
     protected void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
-        EdgeToEdge.enable(this);
         binding = ActivityMainBinding.inflate(getLayoutInflater());
         setContentView(binding.getRoot());
-        ViewCompat.setOnApplyWindowInsetsListener(binding.main, (v, insets) -> {
-            Insets systemBars = insets.getInsets(WindowInsetsCompat.Type.systemBars());
-            v.setPadding(systemBars.left, systemBars.top, systemBars.right, systemBars.bottom);
-            return insets;
-        });

 data = Database.open(this);
 Database.seedIfEmpty(data);

+adapter = new WatchAdapter(this::deleteWatching);
+binding.recyclerView.setLayoutManager(new LinearLayoutManager(this));
+binding.recyclerView.addItemDecoration(
+        new DividerItemDecoration(this, DividerItemDecoration.VERTICAL));
+binding.recyclerView.setAdapter(adapter);

 binding.buttonAddStudent.setOnClickListener(v -> showAddStudent());

+    /**
+     * Deletes exactly one association row using Watching's two-column primary key.
+     *
+     * <p>The student and movie IDs come from the same join tuple displayed by RecyclerView. Names
+     * and titles are presentation values and need not be unique, so they are not safe identifiers
+     * for deletion. The final {@code value()} executes Requery's lazy delete result.</p>
+     *
+     * @param data the open Requery store
+     * @param studentId first half of the Watching composite key
+     * @param movieId second half of the Watching composite key
+     */
+    static void deleteWatching(EntityDataStore<Persistable> data, int studentId, int movieId) {
+        data.delete(Watching.class)
+                .where(WatchingEntity.STUDENT_ID.eq(studentId)
+                        .and(WatchingEntity.MOVIE_ID.eq(movieId)))
+                .get().value();
+    }