Kaz Okui naan
naan
/ gist:509117
Created
August 5, 2010 02:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE statuses ( | |
| 'id' INTEGER PRIMARY KEY, | |
| 'tweet' TEXT, | |
| 'in_reply_to_status_id' INTEGER, | |
| 'user_id' INTEGER, | |
| 'user' TEXT | |
| ); | |
| CREATE INDEX statuses_in_reply_to_status_id on statuses(in_reply_to_status_id); | |
| CREATE INDEX statuses_user_id on statuses(user_id); |
naan
/ gist:509110
Created
August 5, 2010 02:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE statuses ( | |
| 'id' INTEGER PRIMARY KEY, | |
| 'user_id' INTEGER, | |
| 'text' TEXT, | |
| 'created_at' INTEGER, | |
| 'source' TEXT, | |
| 'latitude' REAL, | |
| 'longitude' REAL, | |
| 'in_reply_to_status_id' INTEGER, | |
| 'in_reply_to_screen_name' TEXT, |
naan
/ gist:507759
Created
August 4, 2010 06:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DROP TABLE IF EXISTS home_timeline_%d; | |
| CREATE TABLE home_timeline_%d ( | |
| 'status_id' INTEGER PRIMARY KEY, | |
| 'favorited' INTEGER | |
| ); | |
| DROP TABLE IF EXISTS mentions_%d; | |
| CREATE TABLE mentions_%d ( | |
| 'status_id' INTEGER PRIMARY KEY, | |
| 'favorited' INTEGER |
naan
/ gist:500102
Created
July 30, 2010 07:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2010-07-30 00:43:37.206 ThreadTest[2998:207] SQLite version 3.7.0 | |
| 2010-07-30 00:43:38.048 ThreadTest[2998:207] JSON decode (0.532568 / 0.532568) | |
| 2010-07-30 00:43:38.599 ThreadTest[2998:207] Craete Status object (0.551935 / 1.084503) | |
| 2010-07-30 00:43:38.959 ThreadTest[2998:207] Parse tweet (0.359566 / 1.444069) | |
| 2010-07-30 00:43:39.479 ThreadTest[2998:207] Calc cell height (0.520373 / 1.964442) | |
| 2010-07-30 00:43:39.808 ThreadTest[2998:207] Insert data (0.328931 / 2.293373) |
naan
/ gist:499543
Created
July 29, 2010 23:59
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UIGraphicsBeginImageContext(CGSizeMake(320, 480)); | |
| CGContextRef context = UIGraphicsGetCurrentContext(); | |
| [controller.view setNeedsDisplay]; | |
| [controller.view.layer renderInContext:context]; | |
| UIImage *anImage = UIGraphicsGetImageFromCurrentImageContext(); | |
| NSData *png = UIImagePNGRepresentation(anImage); | |
| UIGraphicsEndImageContext(); |
naan
/ gist:496840
Created
July 29, 2010 00:20
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| void uncaughtExceptionHandler(NSException *exception) { | |
| // touch file or write nsdeafult | |
| } | |
| - (void)applicationDidFinishLaunching:(UIApplication *)application { | |
| NSSetUncaughtExceptionHandler(&uncaughtExceptionHandler); | |
| } |
naan
/ gist:492726
Created
July 27, 2010 19:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // | |
| // backward compatibility of handling URL | |
| // | |
| NSString* osVersion = [[UIDevice currentDevice] systemVersion]; | |
| if ([osVersion compare:@"3.9" options:NSNumericSearch] == NSOrderedAscending) { | |
| NSURL *url = [launchOptions objectForKey:UIApplicationLaunchOptionsURLKey]; | |
| if (url) { | |
| [self performSelector:@selector(handleURL:) withObject:url afterDelay:.1]; | |
| } | |
| } |
naan
/ gist:488210
Created
July 23, 2010 23:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Incident Identifier: BAE1F38C-4025-4A3B-A2B0-3CA36364A954 | |
| CrashReporter Key: ba9995c7cc8587eb81e42045979914a2818502b5 | |
| Hardware Model: iPhone1,2 | |
| Process: TwitterFon [677] | |
| Path: /var/mobile/Applications/8BF9065C-7DB2-411A-BCC0-787BDF51DEAF/TwitterFon.app/TwitterFon | |
| Identifier: TwitterFon | |
| Version: ??? (???) | |
| Code Type: ARM (Native) | |
| Parent Process: launchd [1] |
naan
/ gist:488028
Created
July 23, 2010 21:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Incident Identifier: CEF1A1FC-1533-4219-ABFC-BCF293457B2B | |
| Hardware Model: iPod2,1 | |
| Process: TwitterFon [421] | |
| Path: /var/mobile/Applications/BF6F95F2-6330-44D3-A9BF-C8767AE8184D/TwitterFon.app/TwitterFon | |
| Identifier: TwitterFon | |
| Version: ??? (???) | |
| Code Type: ARM (Native) | |
| Parent Process: launchd [1] | |
| Date/Time: 2010-07-21 18:24:25.533 +0900 |
naan
/ gist:488001
Created
July 23, 2010 20:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Incident Identifier: 79BE9192-B7F2-4A81-96FE-68B65DC8A1EA | |
| Hardware Model: iPhone2,1 | |
| Process: TwitterFon [485] | |
| Path: /var/mobile/Applications/820A6848-5F7E-4320-8F32-D2305413E80D/TwitterFon.app/TwitterFon | |
| Identifier: TwitterFon | |
| Version: ??? (???) | |
| Code Type: ARM (Native) | |
| Parent Process: launchd [1] | |
| Date/Time: 2010-07-21 16:46:49.664 +0900 |