android bella: التعامل مع قواعد البيانات باستخدام روم Room Jetpack

apply plugin: 'kotlin-android'
//...
dependencies {
//...
implementation "android.arch.persistence.room:runtime:1.1.1"
kapt "android.arch.persistence.room:compiler:1.1.1"
}

implementation "android.arch.persistence.room:runtime:1.1.1"
annotationProcessor "android.arch.persistence.room:compiler:1.1.1"

@Entity
data class Person(@PrimaryKey(autoGenerate = true) var id:Int,
                  @ColumnInfo(name = "name") var name:String,
                  @ColumnInfo(name = "age")  var age:Double)

@Entity
public class Person {
    @PrimaryKey
    private int id;

    @ColumnInfo(name = "name")
    private String name;

    @ColumnInfo(name = "age")
    private Double age;

    //getter & setter 
    // مهمين جدا ليعمل الكود و لم اضفهما اختصارا
}

@Dao
interface PersonDao {
 @Query("SELECT * FROM person")
 fun getAll(): List<Person>

 @Query("SELECT * FROM person WHERE id IN (:personIds)")
 fun loadAllByIds(userIds: IntArray): List<Person>

 @Query("SELECT * FROM person WHERE name LIKE :name LIMIT 1")
 fun findByName(name: String): Person

 @Insert(onConflict = REPLACE)
 fun insertAll(vararg users: Person)
 // or fun insertAll(users: List<Person>)

 @Delete
 fun delete(user: Person)
}

@Dao
public interface PersonDao {
    @Query("SELECT * FROM person")
    List getAll();

    @Query("SELECT * FROM person WHERE uid IN (:personIds)")
    List loadAllByIds(int[] personIds);

    @Query("SELECT * FROM person WHERE name LIKE :name AND "
           + "age LIKE :age LIMIT 1")
    Person findByName(String name, String age);

    @Insert
    void insertAll(Person... persons);

    @Delete
    void delete(Person person);
}

@Database(entities = arrayOf(Person::class), version = 1)
abstract class AppDatabase : RoomDatabase() {
 abstract fun personDao(): PersonDao
}

@Database(entities = {Person.class}, version = 1)    
public abstract class AppDatabase extends RoomDatabase {
    public abstract PersonDao personDao(); 

}

 class Main : AppCompatActivity() {
    
     override fun onCreate(savedInstanceState: Bundle?) {
      super.onCreate(savedInstanceState)
      setContentView(R.layout.ac_main)
      //استخدام مكتبة انكو لتسهيل الوصول الى تريد thread منفصل
      doAsync {
       //instance
       val db = Room.databaseBuilder(this@Main, AppDatabase::class.java, "database-name").build()
       //انشاء مستحدم جديد
       val person=Person( null, "Ismail Bella",  19.0)
       //اضافة المستخدم الى قاعدة البيانات من خلال interface
       db.userDao().insertAll(person)
       // ارسال استعلام للحصول على معلومات المستخدم المسجلة من خلال الاسم
       val rp=db.userDao().findByName("Ismail Bella")
       //طباعة عمر المستخدم على Log
       uiThread { Log.e("your age",rp.age.toString()) }
      }
     }
    }

public class Main extends AppCompatActivity {
    @Override
    public void onCreate(@Nullable Bundle savedInstanceState, @Nullable PersistableBundle persistentState) {
        super.onCreate(savedInstanceState, persistentState);
        setContentView(R.layout.ac_main);
        new getPerson().execute();
    }

    private class getPerson extends AsyncTask {
        @Override protected Person doInBackground(Void... voids) {
            //instance
            AppDatabase db = Room.databaseBuilder(getApplicationContext(), AppDatabase.class, "database-name").build();
            //انشاء مستحدم جديد
            Person person = new Person(null, "Ismail Bella", 19.0);
            //اضافة المستخدم الى قاعدة البيانات من خلال interface
            db.userDao().insertAll(person);
            // ارسال استعلام للحصول على معلومات المستخدم المسجلة من خلال الاسم
            Person rp = db.userDao().findByName("Ismail Bella");
            return rp;
        }

        //طباعة عمر المستخدم على Log
        protected void onPostExecute(Person result) {
            Log.e("your age", result.getAge().toString());
        }
    }
}

val map = mapOf(1 to "x", 2 to "y", -1 to "zz")

Map<Integer,String> map=new HashMap<Integer,String>();  
  map.put(1,"x");  
  map.put(2,"y");
  map.put(-1,"zz");  

@Entity
data class Person(@PrimaryKey(autoGenerate = true) var id:Int,
                  @ColumnInfo(name = "name") var name:String,
                  @ColumnInfo(name = "age")  var age:Double,
                  var map:Map<Int,String>)

@Entity
public class Person {
    @PrimaryKey
    private int id;

    @ColumnInfo(name = "name")
    private String name;

    @ColumnInfo(name = "age")
    private Double age;

    private Map<Integer,String> map;
    //getter & setter 
    // مهمين جدا ليعمل الكود و لم اضفهما اختصارا
}

implementation 'com.google.code.gson:gson:2.8.5'

class MapConverter {
 @TypeConverter
 fun fromString(value: String): Map<String,String> {
  val listType = object : TypeToken<Map<String, String>>() {

  }.type
  return Gson().fromJson(value, listType)
 }

 @TypeConverter
 fun fromList(list: Map<String,String>): String {
  val gson = Gson()
  return gson.toJson(list)
 }
}

class MapConverter {
    @TypeConverter
    Map<String,String> fromString(String value){
        Type listType = new TypeToken<Map<Integer, String>>() {}.getType();
        return new Gson().fromJson(value, listType);
    }

    @TypeConverter
    String fromList( Map<Integer,String> list) {
        Gson gson = new Gson();
        return gson.toJson(list);
    }
}

@Database(entities = arrayOf(Person::class), version = 1)
@TypeConverters(MapConverter::class)
abstract class AppDatabase : RoomDatabase() {
 abstract fun personDao(): PersonDao
}

@Database(entities = {Person.class}, version = 1)
@TypeConverters({MapConverter::class})
public abstract class AppDatabase extends RoomDatabase {
    public abstract PersonDao personDao();
}

val map = mapOf(1 to "x", 2 to "y", -1 to "zz")
val person=Person( null, "Ismail Bella",  19.0,map)

Map<Integer,String> map=new HashMap<Integer,String>();  
  map.put(1,"x");  
  map.put(2,"y");
  map.put(-1,"zz");
  Person person = new Person(null, "Ismail Bella", 19.0,map);
  db.userDao().insert(person);