/** 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).
*/

import com.oracle.bmc.ConfigFileReader;
import com.oracle.bmc.auth.AuthenticationDetailsProvider;
import com.oracle.bmc.auth.ConfigFileAuthenticationDetailsProvider;
import com.oracle.bmc.opsi.OperationsInsightsClient;
import com.oracle.bmc.opsi.model.*;
import com.oracle.bmc.opsi.requests.*;
import com.oracle.bmc.opsi.responses.*;
import java.math.BigDecimal;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Date;
import java.util.UUID;
import java.util.Arrays;


public class IngestMySqlSqlStatsExample {
    public static void main(String[] args) throws Exception {

        /**
         * Create a default authentication provider that uses the DEFAULT
         * profile in the configuration file.
         * Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
         */
        final ConfigFileReader.ConfigFile configFile = ConfigFileReader.parseDefault();
        final AuthenticationDetailsProvider provider = new ConfigFileAuthenticationDetailsProvider(configFile);

        /* Create a service client */
        OperationsInsightsClient client = OperationsInsightsClient.builder().build(provider);

        /* Create a request and dependent object(s). */
	IngestMySqlSqlStatsDetails ingestMySqlSqlStatsDetails = IngestMySqlSqlStatsDetails.builder()
		.items(new ArrayList<>(Arrays.asList(MySqlSqlStats.builder()
				.digest("EXAMPLE-digest-Value")
				.timeCollected(new Date("Sat Sep 09 05:26:47 UTC 2028"))
				.commandType("EXAMPLE-commandType-Value")
				.totalRows(300L)
				.perfSchemaUsedPercent(475L)
				.schemaName("EXAMPLE-schemaName-Value")
				.execCount(690L)
				.totalLatencyInPs(217L)
				.lockLatencyInPs(668L)
				.errCount(907L)
				.warnCount(909L)
				.rowsAffected(217L)
				.rowsSent(824L)
				.rowsExamined(33L)
				.tmpDiskTables(387L)
				.tmpTables(50L)
				.selectFullJoin(413L)
				.selectFullRangeJoin(923L)
				.selectRange(647L)
				.selectRangeCheck(855L)
				.selectScan(488L)
				.sortMergePasses(749L)
				.sortRange(100L)
				.rowsSorted(223L)
				.sortScan(154L)
				.noIndexUsedCount(993L)
				.noGoodIndexUsedCount(467L)
				.cpuLatencyInPs(400L)
				.maxControlledMemoryInBytes(644L)
				.maxTotalMemoryInBytes(859L)
				.execCountSecondary(418L)
				.timeFirstSeen(new Date("Mon Jun 14 13:39:48 UTC 2004"))
				.timeLastSeen(new Date("Wed Nov 08 23:11:26 UTC 2006")).build()))).build();

	IngestMySqlSqlStatsRequest ingestMySqlSqlStatsRequest = IngestMySqlSqlStatsRequest.builder()
		.ingestMySqlSqlStatsDetails(ingestMySqlSqlStatsDetails)
		.databaseId("ocid1.test.oc1..<unique_ID>EXAMPLE-databaseId-Value")
		.id("ocid1.test.oc1..<unique_ID>EXAMPLE-id-Value")
		.opcRequestId("UR2C4S8GTTLHU7QULZHT<unique_ID>")
		.ifMatch("EXAMPLE-ifMatch-Value")
		.opcRetryToken("EXAMPLE-opcRetryToken-Value").build();

        /* Send request to the Client */
        IngestMySqlSqlStatsResponse response = client.ingestMySqlSqlStats(ingestMySqlSqlStatsRequest);
    }

    
}