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
} // end namespace kinetica