ExecuteSql.cs

Go to the documentation of this file.

/*
 *  This file was autogenerated by the Kinetica schema processor.
 *
 *  DO NOT EDIT DIRECTLY.
 */

using System.Collections.Generic;

namespace kinetica;

public class ExecuteSqlRequest : KineticaData
{
    public struct Encoding
    {
        public const string BINARY = "binary";
        public const string JSON = "json";
    } // end struct Encoding

    public struct Options
    {
        public const string COST_BASED_OPTIMIZATION = "cost_based_optimization";

        public const string TRUE = "true";
        public const string FALSE = "false";

        public const string DISTRIBUTED_JOINS = "distributed_joins";

        public const string DISTRIBUTED_OPERATIONS = "distributed_operations";

        public const string IGNORE_EXISTING_PK = "ignore_existing_pk";

        public const string LATE_MATERIALIZATION = "late_materialization";

        public const string PAGING_TABLE = "paging_table";

        public const string PAGING_TABLE_TTL = "paging_table_ttl";

        public const string PARALLEL_EXECUTION = "parallel_execution";

        public const string PLAN_CACHE = "plan_cache";

        public const string PREPARE_MODE = "prepare_mode";

        public const string PRESERVE_DICT_ENCODING = "preserve_dict_encoding";

        public const string QUERY_PARAMETERS = "query_parameters";

        public const string RESULTS_CACHING = "results_caching";

        public const string RULE_BASED_OPTIMIZATION = "rule_based_optimization";

        public const string SSQ_OPTIMIZATION = "ssq_optimization";

        public const string TTL = "ttl";

        public const string UPDATE_ON_EXISTING_PK = "update_on_existing_pk";

        public const string VALIDATE_CHANGE_COLUMN = "validate_change_column";

        public const string CURRENT_SCHEMA = "current_schema";
    } // end struct Options

    public string statement { get; set; }

    public long offset { get; set; } = 0;

    public long limit { get; set; } = -9999;

    public string encoding { get; set; } = Encoding.BINARY;

    public string request_schema_str { get; set; } = "";

    public IList<byte[]> data { get; set; } = new List<byte[]>();

    public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();

    public ExecuteSqlRequest() { }

    public ExecuteSqlRequest( string statement,
                              long? offset = null,
                              long? limit = null,
                              string request_schema_str = null,
                              IList<byte[]> data = null,
                              IDictionary<string, string> options = null)
    {
        this.statement = statement ?? "";
        this.offset = offset ?? 0;
        this.limit = limit ?? -9999;
        this.encoding = Encoding.BINARY;
        this.request_schema_str = request_schema_str ?? "";
        this.data = data ?? new List<byte[]>();
        this.options = options ?? new Dictionary<string, string>();
    } // end constructor

    public ExecuteSqlRequest( string statement,
                              long? offset = null,
                              long? limit = null,
                              string encoding = null,
                              string request_schema_str = null,
                              IList<byte[]> data = null,
                              IDictionary<string, string> options = null)
    {
        this.statement = statement ?? "";
        this.offset = offset ?? 0;
        this.limit = limit ?? -9999;
        this.encoding = encoding ?? Encoding.BINARY;
        this.request_schema_str = request_schema_str ?? "";
        this.data = data ?? new List<byte[]>();
        this.options = options ?? new Dictionary<string, string>();
    } // end full constructor
} // end class ExecuteSqlRequest

public class RawExecuteSqlResponse : KineticaData
{
    public struct HasMoreRecords
    {
        public const string TRUE = "true";
        public const string FALSE = "false";
    } // end struct HasMoreRecords

    public struct Info
    {
        public const string COUNT = "count";

        public const string RESULT_TABLE_LIST = "result_table_list";
    } // end struct Info

    public long count_affected { get; set; }

    public string response_schema_str { get; set; }

    public byte[] binary_encoded_response { get; set; }

    public string json_encoded_response { get; set; }

    public long total_number_of_records { get; set; }

    public bool has_more_records { get; set; }

    public string paging_table { get; set; }

    public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
} // end class RawExecuteSqlResponse

public class ExecuteSqlResponse : KineticaData
{
    public struct HasMoreRecords
    {
        public const string TRUE = "true";
        public const string FALSE = "false";
    } // end struct HasMoreRecords

    public struct Info
    {
        public const string COUNT = "count";

        public const string RESULT_TABLE_LIST = "result_table_list";
    } // end struct Info

    public long count_affected { get; set; }

    public IList<KineticaRecord> data { get; set; } = new List<KineticaRecord>();

    public long total_number_of_records { get; set; }

    public bool has_more_records { get; set; }

    public string paging_table { get; set; }

    public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
} // end class ExecuteSqlResponse