Skip to content

Instantly share code, notes, and snippets.

@gitcheckoutnikhil

gitcheckoutnikhil/ios_rollup.sql

Created February 7, 2019 02:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gitcheckoutnikhil/b2dafcefc101935f61eefbf16ac1f469 to your computer and use it in GitHub Desktop.
Save gitcheckoutnikhil/b2dafcefc101935f61eefbf16ac1f469 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ios_rollup.sql
CASE
WHEN context_device_model IN ('iPhone1,1') THEN 'iPhone'
WHEN context_device_model IN ('iPhone1,2') THEN 'iPhone 3G'
WHEN context_device_model IN ('iPhone2,1') THEN 'iPhone 3GS'
WHEN context_device_model IN ('iPhone3,1', 'iPhone3,2', 'iPhone3,3') THEN 'iPhone 4'
WHEN context_device_model IN ('iPhone4,1', 'iPhone4,2', 'iPhone4,3') THEN 'iPhone 4S'
WHEN context_device_model IN ('iPhone5,1', 'iPhone5,2') THEN 'iPhone 5'
WHEN context_device_model IN ('iPhone5,3', 'iPhone5,4') THEN 'iPhone 5C'
WHEN context_device_model IN ('iPhone6,1', 'iPhone6,2') THEN 'iPhone 5S'
WHEN context_device_model IN ('iPhone7,2') THEN 'iPhone 6'
WHEN context_device_model IN ('iPhone7,1') THEN 'iPhone 6 Plus'
WHEN context_device_model IN ('iPhone8,1') THEN 'iPhone 6S'
WHEN context_device_model IN ('iPhone8,2') THEN 'iPhone 6S Plus'
WHEN context_device_model IN ('iPhone8,4') THEN 'iPhone SE'
WHEN context_device_model IN ('iPhone9,1', 'iPhone9,3') THEN 'iPhone 7'
WHEN context_device_model IN ('iPhone9,2', 'iPhone9,4') THEN 'iPhone 7 Plus'
WHEN context_device_model IN ('iPhone10,1', 'iPhone10,4') THEN 'iPhone 8'
WHEN context_device_model IN ('iPhone10,2', 'iPhone10,5') THEN 'iPhone 8 Plus'
WHEN context_device_model IN ('iPhone10,3', 'iPhone10,6') THEN 'iPhone X'
WHEN context_device_model IN ('iPhone11,2') THEN 'iPhone Xs'
WHEN context_device_model IN ('iPhone11,4', 'iPhone11,6') THEN 'iPhone Xs Max'
WHEN context_device_model IN ('iPhone11,8') THEN 'iPhone Xʀ'
WHEN context_device_model IN ('iPad1,1') THEN 'iPad'
WHEN context_device_model IN ('iPad2,1', 'iPad2,2', 'iPad2,3', 'iPad2,4') THEN 'iPad 2'
WHEN context_device_model IN ('iPad3,1', 'iPad3,2', 'iPad3,3') THEN 'iPad 3'
WHEN context_device_model IN ('iPad3,4', 'iPad3,5', 'iPad3,6') THEN 'iPad 4'
WHEN context_device_model IN ('iPad6,11', 'iPad6,12') THEN 'iPad 5'
WHEN context_device_model IN ('iPad7,5', 'iPad7,6') THEN 'iPad 6'
WHEN context_device_model IN ('iPad4,1', 'iPad4,2', 'iPad4,3') THEN 'iPad Air'
WHEN context_device_model IN ('iPad5,3', 'iPad5,4') THEN 'iPad Air 2'
WHEN context_device_model IN ('iPad2,5', 'iPad2,6', 'iPad2,7') THEN 'iPad Mini'
WHEN context_device_model IN ('iPad4,4', 'iPad4,5', 'iPad4,6') THEN 'iPad Mini 2'
WHEN context_device_model IN ('iPad4,7', 'iPad4,8', 'iPad4,9') THEN 'iPad Mini 3'
WHEN context_device_model IN ('iPad5,1', 'iPad5,2') THEN 'iPad Mini 4'
WHEN context_device_model IN ('iPad6,3', 'iPad6,4') THEN 'iPad Pro 9.7-inch'
WHEN context_device_model IN ('iPad7,3', 'iPad7,4') THEN 'iPad Pro 10.5-inch'
WHEN context_device_model IN ('iPad8,1', 'iPad8,2', 'iPad8,3', 'iPad8,4') THEN 'iPad Pro 11-inch'
WHEN context_device_model IN ('iPad6,7', 'iPad6,8') THEN 'iPad Pro 12.9-inch'
WHEN context_device_model IN ('iPad7,1', 'iPad7,2') THEN 'iPad Pro 12.9-inch 2'
WHEN context_device_model IN ('iPad8,5', 'iPad8,6', 'iPad8,7', 'iPad8,8') THEN 'iPad Pro 12.9-inch 3'
ELSE context_device_model END AS device_model,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment