ตอนที่ 12 : การเขียน Scripts to authorize users in Mobile Services บน iOS / iPhone

function insert(item, user, request) {
  item.userId = user.userId;    
  request.execute();
}

function insert(item, user, request) {
  item.userId = user.userId;    
  request.execute();
}

function insert(item, user, request) {
    if (item.text.length > 10) {
        request.respond(statusCodes.BAD_REQUEST, 'Text length must be under 10');
    } else {
        request.execute();
    }
}

function insert(item, user, request) { 
    item.scriptComment =
        'this was added by a script and will be saved to the database'; 
    request.execute(); 
} 

function update(item, user, request) { 
    item.scriptComment = 
        'this was added by a script and will be saved to the database'; 
    request.execute(); 
} 

function read(query, user, request) { 
    // Only return records for the current user         
    query.where({ userid: user.userId}); 
    request.execute(); 
}

function insert(item, user, request) {
    item.owner = user.userId;
    request.execute();
}

function read(query, user, request) {
    query.where({
        owner: user.userId
    });
    request.execute();
}

function insert(item, user, request) {
    if (item.userId !== user.userId) {
        request.respond(statusCodes.FORBIDDEN, 
        'You may only insert records with your userId.');
    } else {
        request.execute();
    }
}

function read(query, user, request) {
    request.execute({
        success: function(results) {
            results.forEach(function(r) {
                r.scriptComment = 
                'this was added by a script after querying the database';
            });
            request.respond();
        }
    });
}

function update(item, user, request) { 
  request.execute({ 
    error: function(err) { 
      // Do some custom logging, then call respond. 
      request.respond(); 
    } 
  }); 
}

function insert(item, user, request) {
        var todoItemTable = tables.getTable('TodoItem');
        // Check the supplied custom parameter to see if
        // we should allow duplicate text items to be inserted.        
        if (request.parameters.duplicateText === 'false') {
            // Find all existing items with the same text
            // and that are not marked 'complete'. 
            todoItemTable.where({
                text: item.text,
                complete: false
            }).read({
                success: insertItemIfNotComplete
            });
        } else {
            request.execute();
        }

        function insertItemIfNotComplete(existingItems) {
            if (existingItems.length > 0) {
                request.respond(statusCodes.CONFLICT, 
                    "Duplicate items are not allowed.");
            } else {
                // Insert the item as normal. 
                request.execute();
            }
        }
    }

//
//  ViewController.h
//  myAppMobileService
//
//  Created by Weerachai on 5/12/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import <UIKit/UIKit.h>

@interface ViewController : UIViewController
{
    IBOutlet UITableView *myTable;
}
 
@end

//
//  ViewController.m
//  myAppMobileService
//
//  Created by Weerachai on 5/12/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import <WindowsAzureMobileServices/WindowsAzureMobileServices.h>
#import "MyMemberService.h"

#import "ViewController.h"

@interface ViewController ()

// Private properties
@property (strong, nonatomic)   MyMemberService   *memberService;

@end


@implementation ViewController

@synthesize memberService;


- (void)viewDidLoad
{
    [super viewDidLoad];
    
    // Start Service
    self.memberService = [MyMemberService defaultService];
    [self.memberService refreshDataOnSuccess:^
     {
         [myTable reloadData];
     }];

}

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath
{
    
    static NSString *CellIdentifier = @"Cell";
    
    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];
    if (cell == nil) {
        cell = [[[UITableViewCell alloc] initWithStyle : UITableViewCellStyleSubtitle
                                       reuseIdentifier : CellIdentifier] autorelease];
    }
     
    NSDictionary *item = [self.memberService.items objectAtIndex:indexPath.row];
    
    NSString *col1 =[NSString stringWithFormat:@"id = %@ name = %@",
                     [item objectForKey:@"id"],
                     [item objectForKey:@"name"]];
    cell.textLabel.text = col1;
    
    NSString *col2 =[NSString stringWithFormat:@"email = %@ status = %@",
                     [item objectForKey:@"email"],
                     [item objectForKey:@"status"]];
    cell.detailTextLabel.text= col2;
    
    return cell;
    
}

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView
{
    // Always a single section
    return 1;
}

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
{
    // Return the number of items in the todoService items array
    return [self.memberService.items count];
    
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

- (void)dealloc {
    [myTable release];
    [super dealloc];
}
@end

//
//  MyMemberService.h
//  myAppMobileService
//
//  Created by Weerachai on 7/21/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import <WindowsAzureMobileServices/WindowsAzureMobileServices.h>
#import <Foundation/Foundation.h>


typedef void (^QSCompletionBlock) ();
typedef void (^QSBusyUpdateBlock) (BOOL busy);
 

@interface MyMemberService : NSObject

@property (nonatomic, strong)   NSArray *items;
@property (nonatomic, strong)   MSClient *client;
@property (nonatomic, copy)     QSBusyUpdateBlock busyUpdate;


+ (MyMemberService *)defaultService;

- (void)refreshDataOnSuccess:(QSCompletionBlock)completion;

- (void)handleRequest:(NSURLRequest *)request
                 next:(MSFilterNextBlock)next
             response:(MSFilterResponseBlock)response;

@end

//
//  MyMemberService.m
//  myAppMobileService
//
//  Created by Weerachai on 7/21/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import "MyMemberService.h"
#import <WindowsAzureMobileServices/WindowsAzureMobileServices.h>


@interface MyMemberService() <MSFilter>

@property (nonatomic, strong)   MSTable *table;
@property (nonatomic)           NSInteger busyCount;

@end

@implementation MyMemberService

@synthesize items;


+ (MyMemberService *)defaultService
{
    // Create a singleton instance of MyMemberService
    static MyMemberService* service;
    static dispatch_once_t onceToken;
    dispatch_once(&onceToken, ^{
        service = [[MyMemberService alloc] init];
    });
    
    return service;
}

-(MyMemberService *)init
{
    self = [super init];
    
    if (self)
    {
        // Initialize the Mobile Service client with your URL and key
        MSClient *client = [MSClient clientWithApplicationURLString:@"https://thaicreate.azure-mobile.net/"
        applicationKey:@"uJPAhkAkcTBuTyCNxaOSnDKFzkoYqB49"];
         
        // Add a Mobile Service filter to enable the busy indicator
        self.client = [client clientWithFilter:self];
        
        // Create an MSTable instance to allow us to work with the TodoItem table
        self.table = [_client tableWithName:@"MyMember"];
        
        self.items = [[NSMutableArray alloc] init];
        self.busyCount = 0;
    }
    
    return self;
}

- (void)refreshDataOnSuccess:(QSCompletionBlock)completion
{
    
    // Query the TodoItem table and update the items property with the results from the service
    [self.table readWithCompletion:^(NSArray *results, NSInteger totalCount, NSError *error)
     {
         [self logErrorIfNotNil:error];
         
         items = [results mutableCopy];
         
         // Let the caller know that we finished
         completion();
     }];
    
}

- (void)busy:(BOOL)busy
{
    // assumes always executes on UI thread
    if (busy)
    {
        if (self.busyCount == 0 && self.busyUpdate != nil)
        {
            self.busyUpdate(YES);
        }
        self.busyCount ++;
    }
    else
    {
        if (self.busyCount == 1 && self.busyUpdate != nil)
        {
            self.busyUpdate(FALSE);
        }
        self.busyCount--;
    }
}

- (void)logErrorIfNotNil:(NSError *) error
{
    if (error)
    {
        NSLog(@"ERROR %@", error);
    }
}


- (void)handleRequest:(NSURLRequest *)request
                 next:(MSFilterNextBlock)next
             response:(MSFilterResponseBlock)response
{
    // A wrapped response block that decrements the busy counter
    MSFilterResponseBlock wrappedResponse = ^(NSHTTPURLResponse *innerResponse, NSData *data, NSError *error)
    {
        [self busy:NO];
        response(innerResponse, data, error);
    };
    
    // Increment the busy counter before sending the request
    [self busy:YES];
    next(request, wrappedResponse);
}

@end