function GetUsage($sdb, $usage, $bucket, $firstDay, $lastDay)
{
// Create the query
$query = "select StartTime, UsageValue " . " from " . BOOK_AWS_USAGE_DOMAIN . " where" . " Service='AmazonS3' and " . " StartTime >= '{$firstDay}' and " . " StartTime <= '{$lastDay}' and " . " Resource='{$bucket}' and " . " UsageType='{$usage}'";
// Query for the data
$res = $sdb->select($query);
// Check the result
if (!$res->isOK()) {
return null;
}
// Build array of results
$dailyUsage = array();
foreach ($res->body->SelectResult->Item as $item) {
$attrs = getItemAttributes($item);
$startTime = substr($attrs['StartTime'], 0, 10);
$usage = $attrs['UsageValue'];
$dailyUsage[$startTime] = $usage;
}
return $dailyUsage;
}
* or in the "license.txt" file accompanying this file. This file is
* distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS
* OF ANY KIND, either express or implied. See the License for the
* specific language governing permissions and limitations under the
* License.
*/
error_reporting(E_ALL);
require_once 'tarzan.class.php';
require_once 'book.php';
// Create the SimpleDB access object
$sdb = new AmazonSDB();
// Query for each file
$res1 = $sdb->select("select * from " . CL_ITEM_DOMAIN);
if ($res1->isOK()) {
foreach ($res1->body->SelectResult->Item as $item) {
$itemName = $item->Name;
// Get list of attributes
$attrs = array_keys(getItemAttributes($item));
// Delete the attributes
$res2 = $sdb->delete_attributes(CL_ITEM_DOMAIN, $itemName, $attrs);
if ($res2->isOK()) {
print "Deleted item {$itemName}\n";
} else {
$error = $res2->body->Errors->Error->Message;
print "Could not delete item: {$error}\n";
}
}
} else {
$error = $res1->body->Errors->Error->Message;
exit("Could not run query: {$error}\n");
}
