function drush_salesforce_api_soql_show_tables in Salesforce Suite 6.2

Same name and namespace in other branches

1. 7.2 salesforce_api/salesforce_api.drush.inc \drush_salesforce_api_soql_show_tables()

Duplicates the functionality of mysql's SHOW TABLES

File

salesforce_api/salesforce_api.drush.inc, line 52

Drush integration for Salesforce. Provides commands to examine and query Salesforce data.

Code

function drush_salesforce_api_soql_show_tables() {
  _salesforce_api_drush_check_soap();
  if ($sf = salesforce_api_connect()) {
    try {
      $response = salesforce_api_describeGlobal();
    } catch (Exception $e) {
      drush_print($e->faultstring);
      return;
    }
    $rows = array(
      array(
        dt('Label'),
        dt('Name'),
      ),
    );
    $rows[] = array(
      '------------',
      '------------',
    );
    foreach ($response->types as $type) {
      $rows[] = array(
        $type->label,
        $type->name,
      );
    }
    drush_print_table($rows, TRUE);
    drush_print("\n" . dt('!count rows in set.', array(
      '!count' => count($rows) - 1,
    )));
  }
  else {
    drush_print('Could not connect to salesforce.');
  }
}