Please enable JavaScript.

Coggle requires JavaScript to display documents.

Android-Intermediate (RxJava Advance (Other type of Observable: (Single: …

- - - - CRUD:
        Using annotation Insert Update Delete
      - Query for Information
        
        Use Query
        
        Pass param into query:
        Ex: Query ("SELECT * FROM user WHERE age > :param")
        public User getUser(param)
        
        Pass a collection of arguments
        Ex: Query(SELECT * from user WHERE region IN (:regions)"
        public void getUser(List<String> regions)
- - - - Using public final => mode only read
        
        Prevent box and unbox type data
      - To set or get data: using method get or set
        Ex: user.firstname.set = "Phuong"
        String firstname = user.firstname.get
    - - Using ObservableArrayMap with key and value
        Ex: ObservableArrayMap<String, Object> user = new ObservableArrayMap<>();
        
        To set data: user.put("firstname","Phuong");
        
        To get data: String name = user.firstname
      - Using ObservableArrayList
        Ex: ObservableArrayList<Object> user = new ObservableArrayList<>();
        
        To set data: user.add("Google");
        user.add("20");
        
        To get data: user[Fields.LAST_NAME]
- - - - put definitions global in your whole database in the root level of the class.
      - create an inner class for each table. Each inner class enumerates the corresponding table's columns.
  - - - Pass data to ContentValue and use insert method
        
        The value return is the newly created row or -1 if error
    - - Create array has columns need get data
        
        Use query method
        
        Return value is Cursor ( has position is -1 )
    - - Has condition to delete and using selection clause and selection argument to present it
        
        Use delete method
        
        Value return indicates the number of rows be deleted
    - - Use update method
        
        Create content value to contain data will update
        
        Create selection clause and selection args to check condition WHERE to update