mohanpedala

Table of Contents

• set -e, -u, -x, -o pipefail
• set -e
• set -x
• set -u
• set -o pipefail
• Setting IFS
• Original Reference

set -e, -u, -x, -o pipefail

cswiercz

/*
  Cached Factory
  
  Sometimes you want to make objects with a lifetime managed
  by their target owner but you also want to hold reference
  to them in a custom cache. The target owner, naturally, will
  be given a shared_ptr to the output object. However, we don't
  want the lifetime of the output object to be tied to the
  internal cache. I.e. if the owner dies then the object should
  die even if referenced in the cache.

paracycle

-- Clear tables
DROP TABLE chat_list;
DROP TABLE messages;

-- Create new tables
CREATE TABLE chat_list (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT UNIQUE, message_table_id INTEGER);
CREATE TABLE messages (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT NOT NULL, key_from_me INTEGER, key_id TEXT NOT NULL, status INTEGER, needs_push INTEGER, data TEXT, timestamp INTEGER, media_url TEXT, media_mime_type TEXT, media_wa_type TEXT, media_size INTEGER, media_name TEXT, latitude REAL, longitude REAL, thumb_image TEXT, remote_resource TEXT, received_timestamp INTEGER, send_timestamp INTEGER, receipt_server_timestamp INTEGER, receipt_device_timestamp INTEGER, raw_data BLOB, media_hash TEXT, recipient_count INTEGER, media_duration INTEGER, origin INTEGER);

-- Attach Android and iPhone databases
ATTACH 'msgstore.db' AS android;