Advertisement
Guest User

Untitled

a guest
Aug 12th, 2017
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.96 KB | None | 0 0
  1. package com.app.test.storage.dao;
  2.  
  3. import android.arch.persistence.db.SupportSQLiteStatement;
  4. import android.arch.persistence.room.EntityInsertionAdapter;
  5. import android.arch.persistence.room.RoomDatabase;
  6. import android.arch.persistence.room.RoomSQLiteQuery;
  7. import android.arch.persistence.room.SharedSQLiteStatement;
  8. import android.database.Cursor;
  9. import com.app.test.storage.model.Alert;
  10. import java.lang.Override;
  11. import java.lang.String;
  12. import java.util.ArrayList;
  13. import java.util.List;
  14.  
  15. public class AlertDao_Impl implements AlertDao {
  16.   private final RoomDatabase __db;
  17.  
  18.   private final EntityInsertionAdapter __insertionAdapterOfAlert;
  19.  
  20.   private final SharedSQLiteStatement __preparedStmtOfDeleteTable;
  21.  
  22.   public AlertDao_Impl(RoomDatabase __db) {
  23.     this.__db = __db;
  24.     this.__insertionAdapterOfAlert = new EntityInsertionAdapter<Alert>(__db) {
  25.       @Override
  26.       public String createQuery() {
  27.         return "INSERT OR ABORT INTO `alert`(`autoGeneratedKey`,`description`,`expires`,`regions`,`severity`,`time`,`title`,`uri`) VALUES (nullif(?, 0),?,?,?,?,?,?,?)";
  28.       }
  29.  
  30.       @Override
  31.       public void bind(SupportSQLiteStatement stmt, Alert value) {
  32.         stmt.bindLong(1, value.getAutoGeneratedKey());
  33.         if (value.getDescription() == null) {
  34.           stmt.bindNull(2);
  35.         } else {
  36.           stmt.bindString(2, value.getDescription());
  37.         }
  38.         stmt.bindLong(3, value.getExpires());
  39.         if (value.getRegions() == null) {
  40.           stmt.bindNull(4);
  41.         } else {
  42.           stmt.bindString(4, value.getRegions());
  43.         }
  44.         if (value.getSeverity() == null) {
  45.           stmt.bindNull(5);
  46.         } else {
  47.           stmt.bindString(5, value.getSeverity());
  48.         }
  49.         stmt.bindLong(6, value.getTime());
  50.         if (value.getTitle() == null) {
  51.           stmt.bindNull(7);
  52.         } else {
  53.           stmt.bindString(7, value.getTitle());
  54.         }
  55.         if (value.getUri() == null) {
  56.           stmt.bindNull(8);
  57.         } else {
  58.           stmt.bindString(8, value.getUri());
  59.         }
  60.       }
  61.     };
  62.     this.__preparedStmtOfDeleteTable = new SharedSQLiteStatement(__db) {
  63.       @Override
  64.       public String createQuery() {
  65.         final String _query = "DELETE FROM alert";
  66.         return _query;
  67.       }
  68.     };
  69.   }
  70.  
  71.   @Override
  72.   public void insert(List<Alert> alert) {
  73.     __db.beginTransaction();
  74.     try {
  75.       __insertionAdapterOfAlert.insert(alert);
  76.       __db.setTransactionSuccessful();
  77.     } finally {
  78.       __db.endTransaction();
  79.     }
  80.   }
  81.  
  82.   @Override
  83.   public void deleteTable() {
  84.     final SupportSQLiteStatement _stmt = __preparedStmtOfDeleteTable.acquire();
  85.     __db.beginTransaction();
  86.     try {
  87.       _stmt.executeUpdateDelete();
  88.       __db.setTransactionSuccessful();
  89.     } finally {
  90.       __db.endTransaction();
  91.       __preparedStmtOfDeleteTable.release(_stmt);
  92.     }
  93.   }
  94.  
  95.   @Override
  96.   public List<Alert> queryAll() {
  97.     final String _sql = "SELECT * FROM alert";
  98.     final RoomSQLiteQuery _statement = RoomSQLiteQuery.acquire(_sql, 0);
  99.     final Cursor _cursor = __db.query(_statement);
  100.     try {
  101.       final int _cursorIndexOfAutoGeneratedKey = _cursor.getColumnIndexOrThrow("autoGeneratedKey");
  102.       final int _cursorIndexOfDescription = _cursor.getColumnIndexOrThrow("description");
  103.       final int _cursorIndexOfExpires = _cursor.getColumnIndexOrThrow("expires");
  104.       final int _cursorIndexOfRegions = _cursor.getColumnIndexOrThrow("regions");
  105.       final int _cursorIndexOfSeverity = _cursor.getColumnIndexOrThrow("severity");
  106.       final int _cursorIndexOfTime = _cursor.getColumnIndexOrThrow("time");
  107.       final int _cursorIndexOfTitle = _cursor.getColumnIndexOrThrow("title");
  108.       final int _cursorIndexOfUri = _cursor.getColumnIndexOrThrow("uri");
  109.       final List<Alert> _result = new ArrayList<Alert>(_cursor.getCount());
  110.       while(_cursor.moveToNext()) {
  111.         final Alert _item;
  112.         final int _tmpAutoGeneratedKey;
  113.         _tmpAutoGeneratedKey = _cursor.getInt(_cursorIndexOfAutoGeneratedKey);
  114.         final String _tmpDescription;
  115.         _tmpDescription = _cursor.getString(_cursorIndexOfDescription);
  116.         final long _tmpExpires;
  117.         _tmpExpires = _cursor.getLong(_cursorIndexOfExpires);
  118.         final String _tmpRegions;
  119.         _tmpRegions = _cursor.getString(_cursorIndexOfRegions);
  120.         final String _tmpSeverity;
  121.         _tmpSeverity = _cursor.getString(_cursorIndexOfSeverity);
  122.         final long _tmpTime;
  123.         _tmpTime = _cursor.getLong(_cursorIndexOfTime);
  124.         final String _tmpTitle;
  125.         _tmpTitle = _cursor.getString(_cursorIndexOfTitle);
  126.         final String _tmpUri;
  127.         _tmpUri = _cursor.getString(_cursorIndexOfUri);
  128.         _item = new Alert(_tmpAutoGeneratedKey,_tmpDescription,_tmpExpires,_tmpRegions,_tmpSeverity,_tmpTime,_tmpTitle,_tmpUri);
  129.         _result.add(_item);
  130.       }
  131.       return _result;
  132.     } finally {
  133.       _cursor.close();
  134.       _statement.release();
  135.     }
  136.   }
  137. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement