Jeff Douglas – Technology, Coding and Bears… OH MY!

package com.cloudspokes.dynamodb;
 
@Controller
public class HomeController {
 
  static AmazonDynamoDBClient dynamoDB;
  private String tableName = "kiva-loans";
  // aws keys
  public static final String ACCESSKEY = "YOURKEY";
  public static final String SECRETKEY = "YOURSECRET";
 
  public HomeController() {
    try {
      setup();
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
 
  /**
   * Displays the list of loans from the table
   */
  @RequestMapping(value = "/loans", method = RequestMethod.GET)
  public String loans(Locale locale,
      @RequestParam(value = "keyword", required = false) String keyword,
      Model model) {
 
    ArrayList<Loan> loans = new ArrayList<Loan>();
    ScanRequest scanRequest = new ScanRequest(tableName);
 
    if (keyword != null) {
      HashMap<String, Condition> scanFilter = new HashMap<String, Condition>();
      Condition condition = new Condition().withComparisonOperator(
          ComparisonOperator.EQ.toString()).withAttributeValueList(
          new AttributeValue().withS(keyword));
      scanFilter.put("country", condition);
      scanRequest = new ScanRequest(tableName).withScanFilter(scanFilter);
    }
    ScanResult scanResult = dynamoDB.scan(scanRequest);
 
    for (int i = 0; i < scanResult.getCount(); i++) {
      HashMap<String, AttributeValue> item = (HashMap<String, AttributeValue>) scanResult
          .getItems().get(i);
      Loan loan = new Loan();
      loan.setActivity(item.get("activity").getS());
      loan.setCountry(item.get("country").getS());
      loan.setFunded_amount(Double.parseDouble(item.get("funded_amount")
          .getN()));
      loan.setId(Integer.parseInt(item.get("id").getN()));
      loan.setName(item.get("name").getS());
      loan.setStatus(item.get("status").getS());
      loan.setUse(item.get("use").getS());
      loans.add(loan);
    }
 
    model.addAttribute("loans", loans);
    return "loans";
  }
 
  /**
   * Displays a loan item
   */
  @RequestMapping(value = "/show/{id}", method = RequestMethod.GET)
  public String show(@PathVariable String id, Locale locale, Model model) {
    model.addAttribute("loan", getLoan(id));
    return "show";
  }
 
  /**
   * Displays a form to create a new loan item
   */
  @RequestMapping(value = "/new", method = RequestMethod.GET)
  public String newLoan(Locale locale, Model model) {
    model.addAttribute("loan", new Loan());
    return "new";
  }
 
  /**
   * Inserts a new loan item into dynamodb
   */
  @RequestMapping(value = "/new", method = RequestMethod.POST)
  public String addLoan(@ModelAttribute("loan") Loan loan,
      BindingResult result) {
 
    // populate an item with the data to put
    HashMap<String, AttributeValue> item = new HashMap<String, AttributeValue>();
    item.put("id", new AttributeValue().withN(String.valueOf(loan.getId())));
    item.put("activity", new AttributeValue().withS(loan.getActivity()));
    item.put("country", new AttributeValue().withS(loan.getCountry()));
    item.put("funded_amount", new AttributeValue().withN(String
        .valueOf(loan.getFunded_amount())));
    item.put("name", new AttributeValue().withS(loan.getName()));
    item.put("status", new AttributeValue().withS(loan.getStatus()));
    item.put("use", new AttributeValue().withS(loan.getUse()));
 
    // put the item to the table
    try {
      PutItemRequest req = new PutItemRequest(tableName, item);
      PutItemResult res = dynamoDB.putItem(req);
    } catch (AmazonServiceException ase) {
      System.err.println("Failed to create item in " + tableName);
    }
 
    return "redirect:show/" + loan.getId();
  }
 
  /**
   * Displays the item for editing
   */
  @RequestMapping(value = "/edit/{id}", method = RequestMethod.GET)
  public String editLoan(@PathVariable String id, Locale locale, Model model) {
    model.addAttribute("loan", getLoan(id));
    return "edit";
  }
 
  /**
   * Submits the updates loan data to dynamodb
   */
  @RequestMapping(value = "/edit/{id}", method = RequestMethod.POST)
  public String updateLoan(@PathVariable String id,
      @ModelAttribute("loan") Loan loan, BindingResult result) {
 
    Key key = new Key().withHashKeyElement(new AttributeValue().withN(id));
    HashMap<String, AttributeValueUpdate> updates = new HashMap<String, AttributeValueUpdate>();
 
    AttributeValueUpdate update = new AttributeValueUpdate().withValue(
        new AttributeValue(loan.getStatus())).withAction("PUT");
    updates.put("status", update);
 
    // update the item to the table
    try {
      UpdateItemRequest req = new UpdateItemRequest(tableName, key,
          updates);
      UpdateItemResult res = dynamoDB.updateItem(req);
    } catch (AmazonServiceException ase) {
      System.err.println("Failed to update item: " + ase.getMessage());
    }
 
    return "redirect:../show/" + id;
  }
 
  /**
   * Fetches loan data from Kiva an inserts it into dynamodb
   */
  @RequestMapping(value = "/loadData", method = RequestMethod.GET)
  public String loadData(Locale locale, Model model) {
 
    // delete all of the current loans
    deleteAllLoans();
 
    // make the REST call to kiva
    DefaultHttpClient httpClient = new DefaultHttpClient();
    HttpGet getRequest = new HttpGet(
        "http://api.kivaws.org/v1/loans/newest.json");
    getRequest.addHeader("accept", "application/json");
    HttpResponse response;
    String payload = "";
 
    try {
      response = httpClient.execute(getRequest);
 
      if (response.getStatusLine().getStatusCode() != 200) {
        throw new RuntimeException("Failed : HTTP error code : "
            + response.getStatusLine().getStatusCode());
      }
 
      BufferedReader br = new BufferedReader(new InputStreamReader(
          (response.getEntity().getContent())));
      payload = br.readLine();
    } catch (ClientProtocolException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (IOException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
 
    JSONObject json = (JSONObject) JSONSerializer.toJSON(payload);
    // get the array of loans
    JSONArray loans = json.getJSONArray("loans");
 
    for (int i = 0; i < loans.size(); ++i) {
      JSONObject loan = loans.getJSONObject(i);
      // populate an item with the data to put
      HashMap<String, AttributeValue> item = new HashMap<String, AttributeValue>();
      item.put("id", new AttributeValue().withN(loan.getString("id")));
      item.put("name", new AttributeValue().withS(loan.getString("name")));
      item.put("status",
          new AttributeValue().withS(loan.getString("status")));
      item.put("funded_amount",
          new AttributeValue().withN(loan.getString("funded_amount")));
      item.put("activity",
          new AttributeValue().withS(loan.getString("activity")));
      item.put("use", new AttributeValue().withS(loan.getString("use")));
      item.put("country", new AttributeValue().withS(loan.getJSONObject(
          "location").getString("country")));
 
      try {
        PutItemRequest req = new PutItemRequest(tableName, item);
        PutItemResult res = dynamoDB.putItem(req);
        System.out.println("Put result: " + res);
      } catch (AmazonServiceException ase) {
        System.err.println("Failed to create item in " + tableName);
      }
 
    }
 
    httpClient.getConnectionManager().shutdown();
 
    return "redirect:loans";
  }
 
  /**
   * Displays the home page
   */
  @RequestMapping(value = "/", method = RequestMethod.GET)
  public String home(Locale locale, Model model) {
    return "home";
  }
 
  /**
   * Fetches a specific loan item
   */
  private Loan getLoan(String id) {
    Key key = new Key().withHashKeyElement(new AttributeValue().withN(id));
    GetItemRequest req = new GetItemRequest(tableName, key);
    GetItemResult res = dynamoDB.getItem(req);
    HashMap<String, AttributeValue> item = (HashMap<String, AttributeValue>) res
        .getItem();
 
    Loan loan = new Loan();
    loan.setActivity(item.get("activity").getS());
    loan.setCountry(item.get("country").getS());
    loan.setFunded_amount(Double.parseDouble(item.get("funded_amount")
        .getN()));
    loan.setId(Integer.parseInt(item.get("id").getN()));
    loan.setName(item.get("name").getS());
    loan.setStatus(item.get("status").getS());
    loan.setUse(item.get("use").getS());
    return loan;
  }
 
  /**
   * Deletes all items from dynamodb
   */
  private void deleteAllLoans() {
    ScanRequest scanRequest = new ScanRequest(tableName);
    ScanResult scanResult = dynamoDB.scan(scanRequest);
    for (int i = 0; i < scanResult.getItems().size(); i++) {
      HashMap<String, AttributeValue> item = (HashMap<String, AttributeValue>) scanResult
          .getItems().get(i);
      try {
        Key key = new Key()
            .withHashKeyElement(new AttributeValue("id"))
            .withHashKeyElement(item.get("id"));
        DeleteItemRequest request = new DeleteItemRequest(tableName,
            key);
        DeleteItemResult result = dynamoDB.deleteItem(request);
        System.out.println("Result: " + result);
      } catch (AmazonServiceException ase) {
        System.err.println("Failed to delete item in " + tableName);
      }
    }
  }
 
  private void setup() throws Exception {
    BasicAWSCredentials creds = new BasicAWSCredentials(ACCESSKEY,
        SECRETKEY);
    dynamoDB = new AmazonDynamoDBClient(creds);
    dynamoDB.setEndpoint("http://dynamodb.us-east-1.amazonaws.com");
  }
 
}

public static Map<String, Schema.DescribeFieldResult> getFieldMetaData(
  Schema.DescribeSObjectResult dsor, Set<String> fields) {
 
  // the map to be returned with the final data
  Map<String,Schema.DescribeFieldResult> finalMap = 
    new Map<String, Schema.DescribeFieldResult>();
  // map of all fields in the object
  Map<String, Schema.SObjectField> objectFields = dsor.fields.getMap();
 
  // iterate over the requested fields and get the describe info for each one. 
  // add it to a map with field name as key
  for(String field : fields){
    // skip fields that are not part of the object
    if (objectFields.containsKey(field)) {
      Schema.DescribeFieldResult dr = objectFields.get(field).getDescribe();
      // add the results to the map to be returned
      finalMap.put(field, dr); 
    }
  }
  return finalMap;
}

// field to return -- skips fields not actually part of the sobject
Set<String> fields = new Set<String>{'name','annualrevenue','BADFIELD'};
 
Map<String, Schema.DescribeFieldResult> finalMap = 
  Utils.getFieldMetaData(Account.getSObjectType().getDescribe(), fields);
 
// only print out the 'good' fields
for (String field : new Set<String>{'name','annualrevenue'}) {
  System.debug(finalMap.get(field).getName()); // field name
  System.debug(finalMap.get(field).getType()); // field type
  System.debug(finalMap.get(field).getLength()); // field length
}

package controllers;
 
import play.*;
import play.mvc.*;
import java.util.*;
 
import models.*;
import service.*;
import com.sforce.soap.partner.*;
import com.sforce.ws.ConnectionException;
import com.sforce.soap.partner.sobject.SObject;
 
public class Account extends Controller {
 
  public static void create() {
    render();
  }
 
  // create the record in salesforce
  public static void createSubmit() {
 
    SaveResult[] results = null;
 
    // populate the new opportunity
    SObject a = new SObject();
    a.setType("Account");
    a.setField("Name", params.get("name"));
    a.setField("BillingCity", params.get("city"));
    a.setField("BillingState", params.get("state"));
    a.setField("Phone", params.get("phone"));
    a.setField("Website", params.get("website"));
 
    SObject[] accounts = {a};
 
    // get a reference to the connection
    PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
    try {
      results = connection.create(accounts);
 
      // check for any errors
      if ( results[0].isSuccess() ) {
         System.out.println("Successfully created Account: " + results[0].getId());
      } else {
         System.out.println("Error: could not create Accout: " + results[0].getErrors()[0].getMessage());
      }
 
    } catch (ConnectionException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
 
    redirect("/account/"+results[0].getId() );
  }
 
  // fetch the account and all related opportunities to display
  public static void display() {
 
    if (params.get("id") != null) {
 
      // add the account id to the array to be retrieved
      String[] accountIds = { params.get("id") };
 
      SObject[] accounts = null;
      QueryResult result = null;
 
      // get a reference to the connection
      PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
      try {
        accounts = connection.retrieve("Id, Name, Phone, BillingCity, BillingState, Website","Account", accountIds);
        result = connection.query("Select id, name, stagename, amount, closeDate, probability, ordernumber__c from Opportunity where AccountId = '"+params.get("id")+"'");
      } catch (ConnectionException e) {
        e.printStackTrace();
      } catch (NullPointerException npe) {
        System.out.println("NullPointerException: "+npe.getCause().toString());
      }
 
      renderArgs.put("account", accounts[0]);
      renderArgs.put("opportunities", result.getRecords());
 
    }
 
    render();
  }
 
  // fetch the account so we can show the edit form with data
  public static void edit() {
 
    if (params.get("id") != null) {
 
      // add the account id to the array to be retrieved
      String[] accountIds = { params.get("id") };
      SObject[] accounts = null;
 
      // get a reference to the connection
      PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
      try {
        accounts = connection.retrieve("Id, Name, Phone, BillingCity, BillingState, Website","Account", accountIds);
      } catch (ConnectionException e) {
        e.printStackTrace();
      } catch (NullPointerException npe) {
        System.out.println("NullPointerException: "+npe.getCause().toString());
      }
 
      renderArgs.put("account", accounts[0]);
 
    }
 
    render();
  }
 
  // update the record in salesforce
  public static void editSubmit() {
 
    SaveResult[] results = null;
 
    // populate the account to update
    SObject a = new SObject();
    a.setType("Account");
    a.setId(params.get("id"));
    a.setField("Billingcity", params.get("BillingCity"));
 
    SObject[] accounts = {a};
 
    // get a reference to the connection
    PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
    try {
      results = connection.update(accounts);
 
      // check for any errors
      if ( results[0].isSuccess() ) {
         System.out.println("Successfully updated Account: " + results[0].getId());
      } else {
         System.out.println("Error: could not update Account: " + results[0].getErrors()[0].getMessage());
      }
 
    } catch (ConnectionException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
 
    redirect("/account/"+params.get("id") );
  }
 
}

#{extends 'main.html' /}
#{set title:'Account Details' /}
 
<span class="nav"><a href="/opportunity">Search</a></span><p/>
<span class="title">Account Display</span>
<p/>
 
<table id="fancytable">
  <tr>
    <td class="label">Name</td>
    <td>${ account.getField("Name") }</td>
  </tr>
  <tr>
    <td class="label">City</td>
    <td>${ account.getField("BillingCity") }</td>
  </tr>
  <tr>
    <td class="label">State</td>
    <td>${ account.getField("BillingState") }</td>
  </tr>
  <tr>
    <td class="label">Phone</td>
    <td>${ account.getField("Phone") }</td>
  </tr>
  <tr>
    <td class="label">Website</td>
    <td>${ account.getField("Website") }</td>
  </tr>  
</table>
 
<br><a href="/opportunity/create/${ account.getField("Id") }">Create a new Opportunity</a> 
or <a href="/account/${ account.getField("Id") }/edit">edit this Account</a><p/>  
 
%{ if (opportunities.length > 0) { }%
 
  <p/><span class="heading">Opportunities for ${ account.getField("Name") }</span><br><p/>
 
  <table id="fancytable">
  <tr>
    <td class="label">Name</td>
    <td class="label">Amount</td>
    <td class="label">Stage</td>
    <td class="label">Probability</td>
    <td class="label">Close Date</td>
    <td class="label">Order</td>
  </tr>
  #{list items:opportunities, as:'o' }
    <tr>
      <td nowrap>${ o.getField("Name") }</td>
      <td>$${ o.getField("Amount") }</td>
      <td>${ o.getField("StageName") }</td>
      <td>${ o.getField("Probability") }</td>
      <td>${ o.getField("CloseDate") }</td>
      <td>${ o.getField("OrderNumber__c") }</td>
    </tr>
  #{/list}
  </table>
 
%{ } else { }%
  <p/><span class="heading">No Opportunities found for ${ account.getField("Name") }</span>
%{ } }%