:py:mod:`dissect.sql.c_sqlite3`
===============================

.. py:module:: dissect.sql.c_sqlite3


Module Contents
---------------

.. py:data:: sqlite3_def
   :value: Multiline-String

    .. raw:: html

        <details><summary>Show Value</summary>

    .. code-block:: python

        """
        #define PAGE_FLAG_INTKEY      0x01
        #define PAGE_FLAG_ZERODATA    0x02
        #define PAGE_FLAG_LEAFDATA    0x04
        #define PAGE_FLAG_LEAF        0x08
        
        #define PAGE_TYPE_INTERIOR_INDEX    PAGE_FLAG_ZERODATA
        #define PAGE_TYPE_INTERIOR_TABLE    PAGE_FLAG_INTKEY | PAGE_FLAG_LEAFDATA
        #define PAGE_TYPE_LEAF_INDEX        PAGE_FLAG_ZERODATA | PAGE_FLAG_LEAF
        #define PAGE_TYPE_LEAF_TABLE        PAGE_FLAG_INTKEY | PAGE_FLAG_LEAFDATA | PAGE_FLAG_LEAF
        
        struct header {
            char    magic[16];
            uint16  page_size;
            uint8   write_version;
            uint8   read_version;
            uint8   reserved_size;
            uint8   max_embedded_payload_fraction;
            uint8   min_embedded_payload_fraction;
            uint8   leaf_payload_fraction;
            uint32  change_counter;
            uint32  page_count;
            uint32  first_freelist_page;
            uint32  freelist_page_count;
            uint32  schema_cookie;
            uint32  schema_format_number;
            uint32  page_cache_size;
            uint32  largest_root_btree_page;
            uint32  text_encoding;
            uint32  user_version;
            uint32  incremental_vacuum_mode;
            uint32  application_id;
            char    reserved1[20];
            uint32  version_valid_for_number;
            uint32  sqlite_version_number;
        };
        
        struct page_header {
            uint8   flags;
            uint16  first_freeblock;
            uint16  cell_count;
            uint16  cell_start;
            uint8   fragmented_free_bytes;
        };
        
        struct wal_header {
            uint32  magic;
            uint32  version;
            uint32  page_size;
            uint32  checkpoint_sequence_number;
            uint32  salt1;
            uint32  salt2;
            uint32  checksum1;
            uint32  checksum2;
        };
        
        struct wal_frame {
            uint32  page_number;
            uint32  page_count;
            uint32  salt1;
            uint32  salt2;
            uint32  checksum1;
            uint32  checksum2;
        };
        """

    .. raw:: html

        </details>

   

.. py:data:: c_sqlite3

   

.. py:data:: ENCODING

   

.. py:data:: PAGE_TYPES

   

.. py:data:: SERIAL_TYPES

   

.. py:data:: SQLITE3_HEADER_MAGIC
   :value: b'SQLite format 3\x00'

   

.. py:data:: WAL_HEADER_MAGIC_LE
   :value: 931071618

   

.. py:data:: WAL_HEADER_MAGIC_BE
   :value: 931071619

   

.. py:data:: WAL_HEADER_MAGIC