示例#1
0
文件: EMF.java 项目: ranger101/reader
  static {
    try {
      Map<Object, Object> properties = getEntityManagerProperties();

      Environment.verifyProperties(properties);
      ConfigurationHelper.resolvePlaceHolders(properties);
      ServiceRegistry reg =
          new ServiceRegistryBuilder().applySettings(properties).buildServiceRegistry();

      DbOpenHelper openHelper =
          new DbOpenHelper(reg) {

            @Override
            public void onCreate() throws Exception {
              executeAllScript(0);
            }

            @Override
            public void onUpgrade(int oldVersion, int newVersion) throws Exception {
              // TODO Auto-generated method stub
            }
          };
      openHelper.open();

      emfInstance =
          Persistence.createEntityManagerFactory(
              "transactions-optional", getEntityManagerProperties());

    } catch (Throwable t) {
      log.error("Error creating EMF", t);
    }
  }
示例#2
0
 @Override
 protected void setUp() throws Exception {
   RenamingDelegatingContext context = new RenamingDelegatingContext(getContext(), "test");
   DbOpenHelper dbOpenHelper = new DbOpenHelper(context);
   db = dbOpenHelper.getWritableDatabase();
   db.beginTransaction();
   asteroidsDAO = new AsteroidsDAO(db);
 }
示例#3
0
  /**
   * Throws SprinklesNotInitializedException if you try to access the database before initializing
   * Sprinkles.
   *
   * @return the SQL Database used by Sprinkles.
   */
  public static SQLiteDatabase getDatabase() {
    if (sInstance == null) {
      throw new SprinklesNotInitializedException();
    }

    if (sDatabase == null) {
      DbOpenHelper dbOpenHelper =
          new DbOpenHelper(
              sInstance.mContext, sInstance.databaseName, sInstance.initialDatabaseVersion);
      sDatabase = dbOpenHelper.getWritableDatabase();
    }

    return sDatabase;
  }
示例#4
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: updateRecordFlags @Description: check existence of those records, and update record
   * flags in database.
   *
   * @return boolean operation result
   * @throws
   */
  @Deprecated
  public boolean updateRecordFlags() {
    SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
    String sql = "SELECT uid, date, record_flag FROM logs ORDER BY date DESC";
    Cursor cursor = null;
    try {
      cursor = db.rawQuery(sql, null);
      while (cursor.moveToNext()) {
        String uid = cursor.getString(cursor.getColumnIndex("uid"));
        long date = Long.parseLong(cursor.getString(cursor.getColumnIndex("date")));
        int recordFlag = cursor.getInt(cursor.getColumnIndex("record_flag"));

        boolean fileExists = Utils.isFileExists(uid, date);

        if (recordFlag == 0 && fileExists) {
          updateRecordFlag(uid, RecordFlagState.EXIST);
          updateRecordState(uid, RecordState.LOCAL);
        } else if (recordFlag == 1 && !fileExists) {
          updateRecordFlag(uid, RecordFlagState.NOT_EXIST);
        }
      }
    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
    return true;
  }
示例#5
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: refreshRecords @Description: refresh records in database
   *
   * @return boolean operation result
   * @throws
   */
  public boolean refreshRecords() {
    SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
    String sql = "SELECT uid, date FROM logs ORDER BY date";
    Cursor cursor = null;
    try {
      cursor = db.rawQuery(sql, null);

      while (cursor.moveToNext()) {
        String uid = cursor.getString(cursor.getColumnIndex("uid"));
        long date = Long.parseLong(cursor.getString(cursor.getColumnIndex("date")));
        if (!Utils.isFileExists(uid, date)) {
          //					updateRecordState(uid, RecordState.DELETED);
          deleteLogByUid(uid);
        }
      }

    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
    return true;
  }
示例#6
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
 /**
  * @Title: insertNewLog @Description: insert new log to database
  *
  * @param callLog MyCallLog instance
  * @param recordFlagState is record exists
  * @param recordState record storage state
  * @return boolean operation result
  * @throws
  */
 public boolean insertNewLog(
     MyCallLog callLog, RecordFlagState recordFlagState, RecordState recordState) {
   SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
   String sql =
       "INSERT INTO logs (name, number, duration, date, type, uid, record_flag, log_state_flag, record_state_flag) VALUES(?, ?, ?, ?, ?, ?, ?, 0, ?)";
   try {
     db.execSQL(
         sql,
         new Object[] {
           callLog.getName(),
           callLog.getNumber(),
           callLog.getDuration(),
           callLog.getDate(),
           callLog.getCallType().ordinal(),
           Check.getCRC32(callLog),
           recordFlagState.ordinal(),
           recordState.ordinal()
         });
   } catch (SQLException e) {
     e.printStackTrace();
     return false;
   } finally {
     if (db != null && db.isOpen()) {
       db.close();
     }
   }
   return true;
 }
示例#7
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: getContacts @Description: get contacts
   *
   * @param page page (10 items per page)
   * @return ArrayList<MyContact>
   * @throws
   */
  public ArrayList<MyContact> getContacts(int page) {
    SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
    String sql =
        "SELECT DISTINCT name, number FROM logs WHERE record_state_flag = "
            + RecordState.LOCAL.ordinal()
            + " ORDER BY date DESC limit "
            + (page * 10)
            + ", 10";
    Cursor cursor = null;

    ArrayList<MyContact> contacts = new ArrayList<MyContact>();
    try {
      cursor = db.rawQuery(sql, null);
      while (cursor.moveToNext()) {
        String name = cursor.getString(cursor.getColumnIndex("name"));
        String number = cursor.getString(cursor.getColumnIndex("number"));
        long date = getLatestContactDate(number);
        int count = getContactCount(number);

        contacts.add(new MyContact(name, number, date, count));
      }

      return contacts;
    } catch (SQLException e) {
      e.printStackTrace();
      return null;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
  }
示例#8
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: getIndividualLogs @Description: get individual logs by page
   *
   * @param page
   * @return ArrayList<Log>
   * @throws
   */
  public ArrayList<Log> getIndividualLogs(String number, int page) {
    SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
    String sql =
        "SELECT * FROM logs WHERE number like '%"
            + number
            + "%' AND record_state_flag = "
            + RecordState.LOCAL.ordinal()
            + " ORDER BY date DESC limit "
            + (page * 10)
            + ", 10";
    //		System.out.println(sql);
    Cursor cursor = null;

    ArrayList<Log> list = new ArrayList<Log>();
    try {
      cursor = db.rawQuery(sql, null);
      while (cursor.moveToNext()) {
        int id = cursor.getInt(cursor.getColumnIndex("id"));
        String name = cursor.getString(cursor.getColumnIndex("name"));
        int duration = cursor.getInt(cursor.getColumnIndex("duration"));
        long date = Long.parseLong(cursor.getString(cursor.getColumnIndex("date")));
        CallType callType = CallType.fromInt(cursor.getInt(cursor.getColumnIndex("type")) - 1);
        String uid = cursor.getString(cursor.getColumnIndex("uid"));
        RecordFlagState recordFlag =
            RecordFlagState.fromInt(cursor.getInt(cursor.getColumnIndex("record_flag")));
        LogState logState = LogState.NOT_DELETED;
        RecordState recordState =
            RecordState.fromInt(cursor.getInt(cursor.getColumnIndex("record_state_flag")));
        Timestamp addDate =
            Timestamp.valueOf(cursor.getString(cursor.getColumnIndex("update_date")));

        list.add(
            new Log(
                id,
                name,
                number,
                duration,
                date,
                callType,
                uid,
                recordFlag,
                logState,
                recordState,
                addDate));
      }
      return list;
    } catch (SQLException e) {
      e.printStackTrace();
      return null;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
  }
示例#9
0
 /**
  * 保存一个联系人
  *
  * @param user
  */
 public void saveContact(User user) {
   SQLiteDatabase db = dbHelper.getWritableDatabase();
   ContentValues values = new ContentValues();
   values.put(COLUMN_NAME_ID, user.getUsername());
   if (user.getNick() != null) values.put(COLUMN_NAME_NICK, user.getNick());
   if (user.getAvatar() != null) values.put(COLUMN_NAME_AVATAR, user.getAvatar());
   if (db.isOpen()) {
     db.replace(TABLE_NAME, null, values);
   }
 }
 public static T_WorkoutExercisesControl getInstance(Context context) {
   if (instance == null) {
     context = context.getApplicationContext();
     ThreadFactory logThreadFactory = Executors.defaultThreadFactory();
     Executor logExecutor = Executors.newSingleThreadExecutor(logThreadFactory);
     SQLiteOpenHelper openHelper =
         DbOpenHelper.getInstance(context, DBControl.DB_NAME, DBControl.DB_VERSION, logExecutor);
     instance = new T_WorkoutExercisesControl(context, logExecutor, openHelper);
   }
   return instance;
 }
示例#11
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
 /**
  * @Title: deleteLogByUid @Description: delete log by uid
  *
  * @param uid unique id of the log to be deleted
  * @return boolean operation result
  * @throws
  */
 public boolean deleteLogByUid(String uid) {
   SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
   String sql = "DELETE FROM logs WHERE uid = \"" + uid + "\"";
   try {
     db.execSQL(sql);
   } catch (SQLException e) {
     e.printStackTrace();
     return false;
   } finally {
     if (db != null && db.isOpen()) {
       db.close();
     }
   }
   return true;
 }
示例#12
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
 /**
  * @Title: updateRecordState @Description: update record state
  *
  * @param uid the unique id of the record
  * @param state the state to set
  * @return boolean operation result
  * @throws
  */
 public boolean updateRecordState(String uid, RecordState state) {
   SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
   String sql =
       "UPDATE logs SET record_state_flag = " + state.ordinal() + " WHERE uid = \"" + uid + "\"";
   try {
     db.execSQL(sql);
   } catch (SQLException e) {
     e.printStackTrace();
     return false;
   } finally {
     if (db != null && db.isOpen()) {
       db.close();
     }
   }
   return true;
 }
示例#13
0
  /**
   * 获取好友list
   *
   * @return
   */
  public Map<String, User> getContactList() {
    SQLiteDatabase db = dbHelper.getReadableDatabase();
    Map<String, User> users = new HashMap<String, User>();
    if (db.isOpen()) {
      Cursor cursor = db.rawQuery("select * from " + TABLE_NAME /* + " desc" */, null);
      while (cursor.moveToNext()) {
        String username = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_ID));
        String nick = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_NICK));
        String avatar = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_AVATAR));
        User user = new User();
        user.setUsername(username);
        user.setNick(nick);
        user.setAvatar(avatar);
        String headerName = null;
        if (!TextUtils.isEmpty(user.getNick())) {
          headerName = user.getNick();
        } else {
          headerName = user.getUsername();
        }

        if (username.equals(Constant.NEW_FRIENDS_USERNAME)
            || username.equals(Constant.GROUP_USERNAME)) {
          user.setHeader("");
        } else if (Character.isDigit(headerName.charAt(0))) {
          user.setHeader("#");
        } else {
          user.setHeader(
              HanziToPinyin.getInstance()
                  .get(headerName.substring(0, 1))
                  .get(0)
                  .target
                  .substring(0, 1)
                  .toUpperCase());
          char header = user.getHeader().toLowerCase().charAt(0);
          if (header < 'a' || header > 'z') {
            user.setHeader("#");
          }
        }
        users.put(username, user);
      }
      cursor.close();
    }
    return users;
  }
  /**
   * 保存message
   *
   * @param message
   * @return 返回这条messaged在db中的id
   */
  public synchronized Integer saveMessage(InviteMessage message) {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    int id = -1;
    if (db.isOpen()) {
      ContentValues values = new ContentValues();
      values.put(COLUMN_NAME_FROM, message.getFrom());
      values.put(COLUMN_NAME_GROUP_ID, message.getGroupId());
      values.put(COLUMN_NAME_GROUP_Name, message.getGroupName());
      values.put(COLUMN_NAME_REASON, message.getReason());
      values.put(COLUMN_NAME_TIME, message.getTime());
      values.put(COLUMN_NAME_STATUS, message.getStatus().ordinal());
      db.insert(TABLE_NAME, null, values);

      Cursor cursor = db.rawQuery("select last_insert_rowid() from " + TABLE_NAME, null);
      if (cursor.moveToFirst()) {
        id = cursor.getInt(0);
      }
    }
    return id;
  }
  /**
   * 获取messges
   *
   * @return
   */
  public List<InviteMessage> getMessagesList() {
    SQLiteDatabase db = dbHelper.getReadableDatabase();
    List<InviteMessage> msgs = new ArrayList<InviteMessage>();
    if (db.isOpen()) {
      Cursor cursor = db.rawQuery("select * from " + TABLE_NAME + " desc", null);
      while (cursor.moveToNext()) {
        InviteMessage msg = new InviteMessage();
        int id = cursor.getInt(cursor.getColumnIndex(COLUMN_NAME_ID));
        String from = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_FROM));
        String groupid = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_GROUP_ID));
        String groupname = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_GROUP_Name));
        String reason = cursor.getString(cursor.getColumnIndex(COLUMN_NAME_REASON));
        long time = cursor.getLong(cursor.getColumnIndex(COLUMN_NAME_TIME));
        int isIniviteFromMe = cursor.getInt(cursor.getColumnIndex(COLUMN_NAME_ISINVITEFROMME));
        int status = cursor.getInt(cursor.getColumnIndex(COLUMN_NAME_STATUS));

        msg.setId(id);
        msg.setFrom(from);
        msg.setGroupId(groupid);
        msg.setGroupName(groupname);
        msg.setReason(reason);
        msg.setTime(time);
        if (status == InviteMesageStatus.BEINVITEED.ordinal())
          msg.setStatus(InviteMesageStatus.BEINVITEED);
        else if (status == InviteMesageStatus.BEAGREED.ordinal())
          msg.setStatus(InviteMesageStatus.BEAGREED);
        else if (status == InviteMesageStatus.BEREFUSED.ordinal())
          msg.setStatus(InviteMesageStatus.BEREFUSED);
        else if (status == InviteMesageStatus.AGREED.ordinal())
          msg.setStatus(InviteMesageStatus.AGREED);
        else if (status == InviteMesageStatus.REFUSED.ordinal())
          msg.setStatus(InviteMesageStatus.REFUSED);
        else if (status == InviteMesageStatus.BEAPPLYED.ordinal()) {
          msg.setStatus(InviteMesageStatus.BEAPPLYED);
        }
        msgs.add(msg);
      }
      cursor.close();
    }
    return msgs;
  }
示例#16
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: updateLogs @Description: update logs
   *
   * @param callLogs call logs to update
   * @return boolean the result of the operation
   * @throws
   */
  @Deprecated
  public boolean updateLogs(List<MyCallLog> callLogs) {
    SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
    String sql = "SELECT uid, date FROM logs ORDER BY date";
    Cursor cursor = null;
    try {
      cursor = db.rawQuery(sql, null);

      List<String> uids = new ArrayList<String>();
      // update log_state
      while (cursor.moveToNext()) {
        String uid = cursor.getString(cursor.getColumnIndex("uid"));
        uids.add(uid);
        if (!Utils.containsUid(uid, callLogs)) {
          updateLogState(uid, LogState.ONLY_LOCAL);
        }
      }

      // insert new logs into table
      for (MyCallLog callLog : callLogs) {
        String tmp = Check.getCRC32(callLog);
        if (!uids.contains(tmp)) {
          insertNewLog(callLog);
        }
      }

    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
    return true;
  }
示例#17
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: getLatestContactDate @Description: get latest contact date
   *
   * @param number contact number
   * @return long date
   * @throws
   */
  public long getLatestContactDate(String number) {
    SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
    String sql = "SELECT date FROM logs WHERE number = '" + number + "' ORDER BY date DESC limit 1";
    Cursor cursor = null;

    try {
      cursor = db.rawQuery(sql, null);
      if (cursor.moveToFirst()) {
        return Long.parseLong(cursor.getString(cursor.getColumnIndex("date")));
      }
    } catch (SQLException e) {
      e.printStackTrace();
      return 0;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
    return 0;
  }
示例#18
0
文件: LogsDAO.java 项目: 0x4ec7/Logs
  /**
   * @Title: getContactCount @Description: get count
   *
   * @param number number of the contact
   * @return int count
   * @throws
   */
  public int getContactCount(String number) {
    SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
    String sql = "";
    if (number.length() < 5) {
      sql =
          "SELECT count(*) as count FROM logs WHERE number = '"
              + number
              + "' AND record_state_flag = "
              + RecordState.LOCAL.ordinal();
    } else {
      sql =
          "SELECT count(*) as count FROM logs WHERE number like '%"
              + number
              + "%' AND record_state_flag = "
              + RecordState.LOCAL.ordinal();
    }
    Cursor cursor = null;

    //		ArrayList<MyContact> contacts = new ArrayList<MyContact>();
    try {
      cursor = db.rawQuery(sql, null);
      if (cursor.moveToFirst()) {
        return cursor.getInt(cursor.getColumnIndex("count"));
      }
    } catch (SQLException e) {
      e.printStackTrace();
      return 0;
    } finally {
      if (cursor != null && !cursor.isClosed()) {
        cursor.close();
      }
      if (db != null && db.isOpen()) {
        db.close();
      }
    }
    return 0;
  }
 public SqliteJobQueue(Configuration configuration, long sessionId, JobSerializer serializer) {
   this.sessionId = sessionId;
   jobStorage = new FileStorage(configuration.getAppContext(), "jobs_" + configuration.getId());
   whereQueryCache = new WhereQueryCache(sessionId);
   dbOpenHelper =
       new DbOpenHelper(
           configuration.getAppContext(),
           configuration.isInTestMode() ? null : ("db_" + configuration.getId()));
   db = dbOpenHelper.getWritableDatabase();
   sqlHelper =
       new SqlHelper(
           db,
           DbOpenHelper.JOB_HOLDER_TABLE_NAME,
           DbOpenHelper.ID_COLUMN.columnName,
           DbOpenHelper.COLUMN_COUNT,
           DbOpenHelper.JOB_TAGS_TABLE_NAME,
           DbOpenHelper.TAGS_COLUMN_COUNT,
           sessionId);
   this.jobSerializer = serializer;
   if (configuration.resetDelaysOnRestart()) {
     sqlHelper.resetDelayTimesTo(JobManager.NOT_DELAYED_JOB_DELAY);
   }
   cleanupFiles();
 }
 /**
  * 更新message
  *
  * @param msgId
  * @param values
  */
 public void updateMessage(int msgId, ContentValues values) {
   SQLiteDatabase db = dbHelper.getWritableDatabase();
   if (db.isOpen()) {
     db.update(TABLE_NAME, values, COLUMN_NAME_ID + " = ?", new String[] {String.valueOf(msgId)});
   }
 }
 public InviteMessgeDao(Context context) {
   dbHelper = DbOpenHelper.getInstance(context);
 }
 public void deleteMessage(String from) {
   SQLiteDatabase db = dbHelper.getWritableDatabase();
   if (db.isOpen()) {
     db.delete(TABLE_NAME, COLUMN_NAME_FROM + " = ?", new String[] {from});
   }
 }
 public SQLiteDatabase getReadableDatabase() {
   return mDatabaseOpenHelper.getReadableDatabase();
 }
示例#24
0
 /**
  * 删除一个联系人
  *
  * @param username
  */
 public void deleteContact(String username) {
   SQLiteDatabase db = dbHelper.getWritableDatabase();
   if (db.isOpen()) {
     db.delete(TABLE_NAME, COLUMN_NAME_ID + " = ?", new String[] {username});
   }
 }
示例#25
0
 public UserDao(Context context) {
   dbHelper = DbOpenHelper.getInstance(context);
 }