コード例 #1
0
  public Long updateChannelContentProvider(ChannelInfo channel) {
    //		Log.v( TAG, "updateChannelContentProvider : enter" );

    if (null != channel) {

      if (Log.isLoggable(TAG, Log.VERBOSE)) {
        Log.v(TAG, "updateChannelContentProvider : channelInfo=" + channel.toString());
      }

      ContentValues values = new ContentValues();
      values.put(ChannelConstants.FIELD_CHAN_ID, channel.getChannelId());
      values.put(ChannelConstants.FIELD_CHAN_NUM, channel.getChannelNumber());
      values.put(ChannelConstants.FIELD_CALLSIGN, channel.getCallSign());
      values.put(ChannelConstants.FIELD_ICON_URL, channel.getIconUrl());
      values.put(ChannelConstants.FIELD_CHANNEL_NAME, channel.getChannelName());
      values.put(ChannelConstants.FIELD_MPLEX_ID, channel.getMultiplexId());
      values.put(ChannelConstants.FIELD_TRANSPORT_ID, channel.getTransportId());
      values.put(ChannelConstants.FIELD_SERVICE_ID, channel.getServiceId());
      values.put(ChannelConstants.FIELD_NETWORK_ID, channel.getNetworkId());
      values.put(ChannelConstants.FIELD_ATSC_MAJOR_CHAN, channel.getAtscMajorChannel());
      values.put(ChannelConstants.FIELD_ATSC_MINOR_CHAN, channel.getAtscMinorChannel());
      values.put(ChannelConstants.FIELD_FORMAT, channel.getFormat());
      values.put(ChannelConstants.FIELD_MODULATION, channel.getModulation());
      values.put(ChannelConstants.FIELD_FREQUENCY, channel.getFrequency());
      values.put(ChannelConstants.FIELD_FREQUENCY_ID, channel.getFrequencyId());
      values.put(ChannelConstants.FIELD_FREQUENCY_TABLE, channel.getFrequenceTable());
      values.put(ChannelConstants.FIELD_FINE_TUNE, channel.getFineTune());
      values.put(ChannelConstants.FIELD_SIS_STANDARD, channel.getSiStandard());
      values.put(ChannelConstants.FIELD_CHAN_FILTERS, channel.getChannelFilters());
      values.put(ChannelConstants.FIELD_SOURCE_ID, channel.getSourceId());
      values.put(ChannelConstants.FIELD_INPUT_ID, channel.getInputId());
      values.put(ChannelConstants.FIELD_COMM_FREE, channel.getCommercialFree());
      values.put(ChannelConstants.FIELD_USE_EIT, channel.isUseEit());
      values.put(ChannelConstants.FIELD_VISIBLE, channel.isVisable());
      values.put(ChannelConstants.FIELD_XMLTV_ID, channel.getXmltvId());
      values.put(ChannelConstants.FIELD_DEFAULT_AUTH, channel.getDefaultAuth());

      long id = 0;
      Cursor cursor =
          mContext
              .getContentResolver()
              .query(
                  ChannelConstants.CONTENT_URI,
                  null,
                  ChannelConstants.FIELD_CHAN_ID
                      + " = ? and "
                      + ChannelConstants.FIELD_SOURCE_ID
                      + " = ?",
                  new String[] {"" + channel.getChannelId(), "" + channel.getSourceId()},
                  null);
      if (cursor.moveToFirst()) {
        id = cursor.getInt(cursor.getColumnIndexOrThrow(ChannelConstants._ID));
      } else {
        Uri contentUri = mContext.getContentResolver().insert(ChannelConstants.CONTENT_URI, values);
        id = ContentUris.parseId(contentUri);
      }
      cursor.close();

      return id;
    }

    Log.v(TAG, "updateChannelContentProvider : exit, channel info is empty");
    return null;
  }
コード例 #2
0
  public Long batchUpdateChannelContentProvider(List<ChannelInfo> channels) {

    long numberInserted = 0;

    if (null != channels && !channels.isEmpty()) {

      List<String> lChannels = new ArrayList<String>();

      Cursor cursor =
          mContext
              .getContentResolver()
              .query(
                  ChannelConstants.CONTENT_URI,
                  new String[] {ChannelConstants._ID},
                  null,
                  null,
                  null);
      if (cursor.getCount() == 0) {
        List<ChannelInfo> filtered = new ArrayList<ChannelInfo>();
        for (ChannelInfo channel : channels) {
          if (!lChannels.contains(channel.getChannelNumber())) {
            if (channel.isVisable()) {
              filtered.add(channel);

              lChannels.add(channel.getChannelNumber());
            }
          }
        }

        int count = 0;
        ContentValues values;
        ContentValues[] valuesArray = new ContentValues[filtered.size()];
        for (ChannelInfo channel : filtered) {
          values = new ContentValues();
          values.put(
              ChannelConstants.FIELD_CHAN_ID,
              null != channel.getChannelId() ? channel.getChannelId() : "");
          values.put(ChannelConstants.FIELD_CHAN_NUM, channel.getChannelNumber());
          values.put(ChannelConstants.FIELD_CALLSIGN, channel.getCallSign());
          values.put(ChannelConstants.FIELD_ICON_URL, channel.getIconUrl());
          values.put(ChannelConstants.FIELD_CHANNEL_NAME, channel.getChannelName());
          values.put(ChannelConstants.FIELD_MPLEX_ID, channel.getMultiplexId());
          values.put(ChannelConstants.FIELD_TRANSPORT_ID, channel.getTransportId());
          values.put(ChannelConstants.FIELD_SERVICE_ID, channel.getServiceId());
          values.put(ChannelConstants.FIELD_NETWORK_ID, channel.getNetworkId());
          values.put(ChannelConstants.FIELD_ATSC_MAJOR_CHAN, channel.getAtscMajorChannel());
          values.put(ChannelConstants.FIELD_ATSC_MINOR_CHAN, channel.getAtscMinorChannel());
          values.put(ChannelConstants.FIELD_FORMAT, channel.getFormat());
          values.put(ChannelConstants.FIELD_MODULATION, channel.getModulation());
          values.put(ChannelConstants.FIELD_FREQUENCY, channel.getFrequency());
          values.put(ChannelConstants.FIELD_FREQUENCY_ID, channel.getFrequencyId());
          values.put(ChannelConstants.FIELD_FREQUENCY_TABLE, channel.getFrequenceTable());
          values.put(ChannelConstants.FIELD_FINE_TUNE, channel.getFineTune());
          values.put(ChannelConstants.FIELD_SIS_STANDARD, channel.getSiStandard());
          values.put(ChannelConstants.FIELD_CHAN_FILTERS, channel.getChannelFilters());
          values.put(ChannelConstants.FIELD_SOURCE_ID, channel.getSourceId());
          values.put(ChannelConstants.FIELD_INPUT_ID, channel.getInputId());
          values.put(ChannelConstants.FIELD_COMM_FREE, channel.getCommercialFree());
          values.put(ChannelConstants.FIELD_USE_EIT, channel.isUseEit() ? 1 : 0);
          values.put(ChannelConstants.FIELD_VISIBLE, channel.isVisable() ? 1 : 0);
          values.put(ChannelConstants.FIELD_XMLTV_ID, channel.getXmltvId());
          values.put(ChannelConstants.FIELD_DEFAULT_AUTH, channel.getDefaultAuth());
          valuesArray[count] = values;

          count++;
        }
        numberInserted =
            mContext.getContentResolver().bulkInsert(ChannelConstants.CONTENT_URI, valuesArray);
      }
      cursor.close();
    }

    return numberInserted;
  }