# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).

require 'oci'
require 'date'

# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config

# Initialize service client with default config file
usage_api_client = OCI::UsageApi::UsageapiClient.new(config: config)

# Send the request to service, some parameters are not required, see API doc for more info
create_query_response =
  usage_api_client.create_query(
    OCI::UsageApi::Models::CreateQueryDetails.new(
      compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
      query_definition:
        OCI::UsageApi::Models::QueryDefinition.new(
          display_name: 'EXAMPLE-displayName-Value',
          report_query:
            OCI::UsageApi::Models::ReportQuery.new(
              tenant_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-tenantId-Value',
              granularity: 'DAILY',
              time_usage_started: DateTime.parse('2006-08-27T08:22:30.548Z'),
              time_usage_ended: DateTime.parse('2047-11-09T13:22:26.472Z'),
              is_aggregate_by_time: true,
              forecast:
                OCI::UsageApi::Models::Forecast.new(
                  time_forecast_ended:
                    DateTime.parse('2049-03-11T09:23:26.888Z'),
                  forecast_type: 'BASIC',
                  time_forecast_started:
                    DateTime.parse('2011-09-27T09:18:59.045Z')
                ),
              query_type: 'EXPIREDCREDIT',
              group_by: %w[EXAMPLE--Value],
              group_by_tag: [
                OCI::UsageApi::Models::Tag.new(
                  namespace: 'EXAMPLE-namespace-Value',
                  key: 'EXAMPLE-key-Value',
                  value: 'EXAMPLE-value-Value'
                )
              ],
              compartment_depth: 5.4588947,
              filter:
                OCI::UsageApi::Models::Filter.new(
                  operator: 'NOT',
                  dimensions: [
                    OCI::UsageApi::Models::Dimension.new(
                      key: 'EXAMPLE-key-Value', value: 'EXAMPLE-value-Value'
                    )
                  ],
                  tags: [
                    OCI::UsageApi::Models::Tag.new(
                      namespace: 'EXAMPLE-namespace-Value',
                      key: 'EXAMPLE-key-Value',
                      value: 'EXAMPLE-value-Value'
                    )
                  ]
                ),
              date_range_name: 'LAST_TWO_MONTHS'
            ),
          cost_analysis_ui:
            OCI::UsageApi::Models::CostAnalysisUI.new(
              graph: 'LINES', is_cumulative_graph: true
            ),
          version: 9851.71
        )
    )
  )

# Get the data from response
puts "#{create_query_response.data}"