博客

数据库提取

• 在 Android Studio 中点击
  
Device File Explorer

  按钮。
• 选择
  
/data/data/com.xxx.xxx/databases/bugle_db

  右键
  
Save As

  保存到本地。
• 
  注：com.xxx.xxx 为当前自己的工程目录
  

数据库说明

• Messaging创建了数据库
  
bugle_db

  用于同步
  
mms/sms.db

  的数据，短信查询时直接从
  
bugle_db

  数据库进行查询。

数据库内表和视图：

• conversation_list_view：主界面的视图，是把conversations、messages和participants三个表的数据糅合起来的视图，方便主界面的各项数据显示。
• conversation_participants：记录conversation和它的联系人participatant的关联。
• messages：记录每一条短彩信的数据，包括远程uri和已读状态等。
• parts：记录短彩信的实际内容，比如文本或者图片uri，跟messages关联能得到完整的短彩信数据。

数据库中数据表有：

conversations、messages、parts、participants、conversation_participants等。

视图有：

draft_parts_view 、coversation_image_parts_view 、conversation_list_view。

数据表

数据表 conversation_participants

数据表 conversations

数据表 messages

数据表 parts

数据表 participants

视图

conversation_list_view

查询对话列表

SELECT conversations._id AS _id,
       conversations.name AS name,
       conversations.current_self_id AS current_self_id,
       conversations.archive_status AS archive_status,
       messages.read AS read,
       conversations.icon AS icon,
       conversations.participant_contact_id AS participant_contact_id,
       conversations.participant_lookup_key AS participant_lookup_key,
       conversations.participant_normalized_destination AS participant_normalized_destination,
       conversations.sort_timestamp AS sort_timestamp,
       conversations.show_draft AS show_draft,
       conversations.draft_snippet_text AS draft_snippet_text,
       conversations.draft_preview_uri AS draft_preview_uri,
       conversations.draft_subject_text AS draft_subject_text,
       conversations.draft_preview_content_type AS draft_preview_content_type,
       conversations.preview_uri AS preview_uri,
       conversations.preview_content_type AS preview_content_type,
       conversations.participant_count AS participant_count,
       conversations.notification_enabled AS notification_enabled,
       conversations.notification_sound_uri AS notification_sound_uri,
       conversations.notification_vibration AS notification_vibration,
       conversations.include_email_addr AS include_email_addr,
       messages.message_status AS message_status,
       messages.raw_status AS raw_status,
       messages._id AS message_id,
       participants.first_name AS snippet_sender_first_name,
       participants.display_destination AS snippet_sender_display_destination,
       conversations.IS_ENTERPRISE AS IS_ENTERPRISE,
       conversations.is_top AS is_top,
       conversations.snippet_text AS snippet_text,
       conversations.subject_text AS subject_text
  FROM conversations
       LEFT JOIN
       messages ON (conversations.latest_message_id = messages._id) 
       LEFT JOIN
       participants ON (messages.sender_id = participants._id) 
 ORDER BY conversations.sort_timestamp DESC;

coversation_image_parts_view

查询图片列表

SELECT messages.conversation_id AS conversation_id,
       parts.uri AS uri,
       participants.full_name AS _display_name,
       parts.uri AS contentUri,
       NULL AS thumbnailUri,
       parts.content_type AS contentType,
       participants.display_destination AS display_destination,
       messages.received_timestamp AS received_timestamp,
       messages.message_status AS message_status
  FROM messages
       LEFT JOIN
       parts ON (messages._id = parts.message_id) 
       LEFT JOIN
       participants ON (messages.sender_id = participants._id) 
 WHERE parts.content_type LIKE image/%
 ORDER BY messages.received_timestamp ASC,
          parts._id ASC;

draft_parts_view

查询草稿附件

SELECT parts._id AS _id,
       parts.message_id AS message_id,
       parts.text AS text,
       parts.uri AS uri,
       parts.content_type AS content_type,
       parts.width AS width,
       parts.height AS height,
       messages.conversation_id AS conversation_id
  FROM messages
       LEFT JOIN
       parts ON (messages._id = parts.message_id) 
 WHERE messages.message_status = 3;

参考：


安卓短信Messaging数据库表格整理与字段分析