Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here is an example as Objective-C methods. Note the separation of tasks into individual methods, each can be easily written &amp; tested individually.</p> <pre><code>- (NSString *)signatureBase64 { NSString *uri_path = [NSString stringWithFormat:@"%@?client=%@",@"/locations/haru-7",@"clientID"]; NSData *signature = [uri_path dataUsingEncoding:NSUTF8StringEncoding]; NSLog(@"signature Data: %@", signature); NSString *signingKeyBase64 = @"c2lnbmluZ0tleQ=="; NSData *signingKey = [self decodeURLBase64String:signingKeyBase64]; NSLog(@"signingKey Data: %@", signingKey); NSLog(@"signingKeyAscii: '%@'", [[NSString alloc] initWithData:signingKey encoding:NSUTF8StringEncoding]); NSData *digest = [self hmacSha1:signature key:signingKey]; NSLog(@"digest Data: %@", digest); NSString *signatureBase64 = [self encodeURLBase64Data:digest]; NSLog(@"signatureBase64: '%@'", signatureBase64); return signatureBase64; } - (NSData *)decodeURLBase64String:(NSString *)string { string = [string stringByReplacingOccurrencesOfString:@"-" withString:@"+"]; string = [string stringByReplacingOccurrencesOfString:@"_" withString:@"/"]; NSData *data = [[NSData alloc] initWithBase64Encoding:string]; return data; } - (NSString *)encodeURLBase64Data:(NSData *)data { NSString *signatureBase64 = [data base64EncodedStringWithOptions:0]; signatureBase64 = [signatureBase64 stringByReplacingOccurrencesOfString:@"+" withString:@"-"]; signatureBase64 = [signatureBase64 stringByReplacingOccurrencesOfString:@"?" withString:@"_"]; return signatureBase64; } // Note there is no intermediate buffer, this is a simple pattern. - (NSData *)hmacSha1:(NSData *)data key:(NSData *)key { NSMutableData *hmac = [NSMutableData dataWithLength:CC_SHA1_DIGEST_LENGTH]; CCHmac( kCCHmacAlgSHA1, key.bytes, key.length, data.bytes, data.length, hmac.mutableBytes); return hmac; } </code></pre> <p>NSLog output:</p> <pre><code>signatureData: &lt;2f6c6f63 6174696f 6e732f68 6172752d 373f636c 69656e74 3d636c69 656e7449 44&gt; signingKeyBase64: 'c2lnbmluZ0tleQ==' signingKey Data: &lt;7369676e 696e674b 6579&gt; signingKeyAscii: 'signingKey' digest Data: &lt;8e4b88b6 111e3151 3b5d35d0 04e60cf9 8a984fb3&gt; signatureBase64: 'jkuIthEeMVE7XTXQBOYM-YqYT7M=' </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POBase64 API Signature in iOS
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USzaph
    1. USzaph
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBase64 API Signature in iOS
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload