src/bin/readPropertiesFromGoogle.php

 
Procedures Status
No issues OK
 
 
1. <?php
2.
3. // include your composer dependencies
Code on global space   Code on global space  
4. require_once 'vendor/autoload.php';
5.
6.
Code on global space   Code on global space   Code on global space  
7. $shortopts = "";
Code on global space   Code on global space   Code on global space  
8. $shortopts .= "s:"; // Required - Google Spreadsheet ID
Code on global space   Code on global space   Code on global space  
9. $shortopts .= "p:"; // Required - path to property definitions directory
Code on global space   Code on global space   Code on global space  
10. $shortopts .= "c:"; // Required - path to credentials file for Google Drive API
11.
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
12. $options = getopt($shortopts);
13.
14. // Google Spreadsheet ID
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
15. $spreadsheetID = $options['s'];
16.
17. // Properties are stored here.
18. // They can be extended and reused across objects.
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
19. $propertyDir = realpath($options['p']);
20. // Create properties directory if needed
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
21. if (false === realpath($propertyDir)) {
Code on global space   Code on global space   Code on global space  
22. mkdir($propertyDir);
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
23. $propertyDir = realpath($propertyDir);
24. }
25.
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
26. define('SCOPES', implode(' ', array(
Code on global space   Code on global space  
27. Google_Service_Sheets::SPREADSHEETS_READONLY)
28. ));
29.
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
30. putenv('GOOGLE_APPLICATION_CREDENTIALS='.realpath($options['c']));
31.
Code on global space   Code on global space   Code on global space  
32. $client = new Google_Client();
Code on global space   Code on global space   Code on global space   Code on global space  
33. $client->setScopes(SCOPES);
Code on global space   Code on global space  
34. $client->useApplicationDefaultCredentials();
35.
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
36. $service = new Google_Service_Sheets($client);
37.
Code on global space   Code on global space   Code on global space  
38. $range = 'IncomingProperties!A1:C';
Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space   Code on global space  
39. $response = $service->spreadsheets_values->get($spreadsheetID, $range);
Code on global space   Code on global space   Code on global space   Code on global space  
40. $values = $response->getValues();
41.
Code on global space   Code on global space   Code on global space  
42. var_dump($values);
 
Generated Thu, 11 Jan 2018 21:56:06 -0800 by PHP_Testability