quicklook_cache
===============

Files and thumbnails within OS X's Quicklook Cache.

Platform support
----------------
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. **Running a query against an unsupported platform will result in the following error:** ``no such table: quicklook_cache``

- Mac OSX

Table schema
------------

=============  =======  ==============================================
Name           Type     Description                                   
=============  =======  ==============================================
path           TEXT     Path of file                                  
rowid          INTEGER  Quicklook file rowid key                      
fs_id          TEXT     Quicklook file fs_id key                      
volume_id      INTEGER  Parsed volume ID from fs_id                   
inode          INTEGER  Parsed file ID (inode) from fs_id             
mtime          INTEGER  Parsed version date field                     
size           BIGINT   Parsed version size field                     
label          TEXT     Parsed version 'gen' field                    
last_hit_date  INTEGER  Apple date format for last thumbnail cache hit
hit_count      TEXT     Number of cache hits on thumbnail             
icon_mode      BIGINT   Thumbnail icon mode                           
cache_path     TEXT     Path to cache data                            
=============  =======  ==============================================

Query examples
--------------

Select all the results for the given table.

.. code-block:: sql

   SELECT * FROM quicklook_cache;