BigQuery PHP调用未定义的方法Google_Client::setAssertionCredentials()

Question

所以基本上我从第二个答案开始尝试了这个，但它附带了一个错误

致命错误：调用未定义的方法中的Google_Client:：setAssertionCredentials()

这是我的代码

require_once 'xxx/vendor/autoload.php';
public function createGClient() {
define("CLIENT_ID", "xxx.apps.googleusercontent.com");
define("SERVICE_ACCOUNT_NAME","[e-mail]");
define("KEY_FILE",'xxx');
define("PROJECT_ID","xxx");
define("DATASET_ID","xxx");
define("TABLE_ID","xxx");
$this->client = new Google_Client();
$this->client->setApplicationName("Test");  
$key = file_get_contents(KEY_FILE);
$this->client->setAssertionCredentials(
Google_Auth_AssertionCredentials(SERVICE_ACCOUNT_NAME,
array('https://www.googleapis.com/auth/bigquery'), $key, "notasecret"));
$this->client->setClientId(CLIENT_ID);
$this->service = new Google_Service_Bigquery($this->client);
}
public function runQuery() {
// To see the a list of tables  
print_r($this->service->tables->listTables(PROJECT_ID, DATASET_ID));
// To see details of a table
print_r($this->service->tables->get(PROJECT_ID, DATASET_ID, TABLE_ID));
// To query a table
$jobs = $this->service->jobs;
$query = new Google_Service_Bigquery_QueryRequest();
$query->setQuery("SELECT * FROM wherever;");
$response = $jobs->query(PROJECT_ID, $query);
print_r($response);
}

我已经安装了指南/doc中的所有内容。有人能帮我吗，因为我什么都试过了，但都不起作用，非常感谢。

Answer 1

不再使用该版本的PHP库，因为它已经过时并且缺少文档。

下面链接了一个较新的凭据，它可以满足设置服务帐户默认凭据的需要，请参阅带有putenv和useApplicationDefaultCredentials()的行。这是我使用库的一个工作代码https://github.com/google/google-api-php-client您需要从控制台获取服务帐户密钥文件：https://console.cloud.google.com/iam-admin/serviceaccounts/

composer.json

{
"require": {
"google/cloud": "^0.13.0",
"google/apiclient": "^2.0"
}
}

php文件

# Imports the Google Cloud client library
use GoogleCloudBigQueryBigQueryClient;
use GoogleCloudServiceBuilder;
$query="SELECT repository_url, 
repository_has_downloads 
FROM   [publicdata:samples.github_timeline]
LIMIT  10";
$client = new Google_Client();
putenv('GOOGLE_APPLICATION_CREDENTIALS='.dirname(__FILE__) . '/.ssh/dummyname-7f0004z148e1.json');//this can be created with other ENV mode server side
$client->useApplicationDefaultCredentials();
$builder = new ServiceBuilder([
'projectId' => 'edited',
]);
$bigQuery = $builder->bigQuery();
$job = $bigQuery->runQueryAsJob($query);
$info=$job->info();
//      print_r($info);
//      exit;
$queryResults = $job->queryResults();
/*$queryResults = $bigQuery->runQuery(
$query,
['useLegacySql' => true]);*/
if ($queryResults->isComplete()) 
{
$i = 0;
$rows = $queryResults->rows();
foreach ($rows as $row) 
{
$i++;
$result[$i] = $row;
}
} 
else 
{
throw new Exception('The query failed to complete');
}
print_r($result);