Ejemplo n.º 1
0
        /// <summary>
        /// 单独在表上再创建一个索引表2
        /// </summary>
        public static void CreateGlobalIndex()
        {
            OTSClient otsClient = Config.GetClient();

            Console.WriteLine("Start create globalIndex...");

            IndexMeta indexMeta = new IndexMeta(IndexName2);

            indexMeta.PrimaryKey = new List <string>()
            {
                Col2
            };
            indexMeta.DefinedColumns = new List <string>()
            {
                Pk1
            };


            CapacityUnit             reservedThroughput = new CapacityUnit(0, 0);
            CreateGlobalIndexRequest request            = new CreateGlobalIndexRequest(TableName, indexMeta);

            otsClient.CreateGlobalIndex(request);

            Console.WriteLine("Global Index is created,tableName: " + TableName + ",IndexName:" + IndexName2);
        }
Ejemplo n.º 2
0
        protected ActionResult <IndexDto <TIndexDto> > Index(int page = 1, int limit = 100)
        {
            int offset = (page - 1) * limit;
            IEnumerable <TModel> projectsCollection = Repository.Index(offset, limit);

            int       count = Repository.Count();
            IndexMeta meta  = new IndexMeta {
                Page = page, Limit = limit, Count = count, Resource = Resource
            };
            IEnumerable <TIndexDto> data = Mapper.Map <IEnumerable <TIndexDto> >(projectsCollection);
            IndexDto <TIndexDto>    dto  = new IndexDto <TIndexDto>(data, meta);

            return(Ok(dto));
        }
        protected string BuildIndexName(IExprTableFullName tableIn, IndexMeta index)
        {
            if (index.Name != null && !string.IsNullOrEmpty(index.Name))
            {
                return(index.Name);
            }

            var table = tableIn.AsExprTableFullName();

            var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null;

            var columns = string.Join("_", index.Columns.Select(c => c.Column.ColumnName.Name + (c.Descending ? "_DESC" : null)));

            return($"IX_{schemaName}{table.TableName.Name}_{columns}");
        }
Ejemplo n.º 4
0
        //static void Main(string[] args)
        //{
        //    Console.WriteLine("GlobalIndexSample");

        //    CreateTableWithGlobalIndex();

        //    CreateGlobalIndex();

        //    PutRow();

        //    GetRangeFromIndexTable();

        //    DeleteGlobalIndex();

        //    DeleteTable();

        //    Console.ReadLine();

        //}

        /// <summary>
        /// 创建一个带二级索引的表
        /// </summary>
        public static void CreateTableWithGlobalIndex()
        {
            //建主表,两列Pk:Pk1、Pk2。 预定义列:Col1、Col2。
            //建索引表,索引表中Col1放Pk0
            OTSClient otsClient = Config.GetClient();

            Console.WriteLine("Start create table with globalIndex...");
            PrimaryKeySchema primaryKeySchema = new PrimaryKeySchema
            {
                { Pk1, ColumnValueType.String },
                { Pk2, ColumnValueType.String }
            };
            TableMeta tableMeta = new TableMeta(TableName, primaryKeySchema);

            tableMeta.DefinedColumnSchema = new DefinedColumnSchema {
                { Col1, DefinedColumnType.STRING },
                { Col2, DefinedColumnType.STRING }
            };

            IndexMeta indexMeta = new IndexMeta(IndexName);

            indexMeta.PrimaryKey = new List <string>()
            {
                Col1
            };
            indexMeta.DefinedColumns = new List <string>()
            {
                Col2
            };
            //indexMeta.IndexType = IndexType.IT_GLOBAL_INDEX;
            //indexMeta.IndexUpdateModel = IndexUpdateMode.IUM_ASYNC_INDEX;

            List <IndexMeta> indexMetas = new List <IndexMeta>()
            {
            };

            indexMetas.Add(indexMeta);

            CapacityUnit       reservedThroughput = new CapacityUnit(0, 0);
            CreateTableRequest request            = new CreateTableRequest(tableMeta, reservedThroughput, indexMetas);

            otsClient.CreateTable(request);

            Console.WriteLine("Table is created: " + TableName);
        }
        protected void AppendIndexColumnList(IndexMeta tableIndex)
        {
            tableIndex.Columns.AssertNotEmpty("Table index has to contain at least one column");

            this.Builder.Append('(');
            for (var index = 0; index < tableIndex.Columns.Count; index++)
            {
                var column = tableIndex.Columns[index];
                if (index != 0)
                {
                    this.Builder.Append(',');
                }

                column.Column.ColumnName.Accept(this.ExprBuilder, null);
                if (column.Descending)
                {
                    this.Builder.Append(" DESC");
                }
            }

            this.Builder.Append(')');
        }
 public CreateGlobalIndexRequest(string mainTableName, IndexMeta indexMeta)
 {
     this.MainTableName = mainTableName;
     this.IndexMeta     = indexMeta;
 }
Ejemplo n.º 7
0
 public IndexDto(IEnumerable <TDto> data, IndexMeta meta)
 {
     Data = data;
     Meta = meta;
 }
Ejemplo n.º 8
0
        protected void BuildIndexAndConstraints(TableDef tableDefTmp,
                                                TableMeta tableMetaTmp,
                                                ref ArrayList indexList,
                                                ref ArrayList primaryKeyList,
                                                ref ArrayList uniqkeyList,
                                                ref ArrayList foreignKeyList)
        {
            //  indexes, primaryKeyList, uniqkeyList;
            IndexDefCollection indexes = tableDefTmp.Indexes;

            foreach (IndexDef indxMixed in indexes)
            {
                if (ValidateVersion(indxMixed) == DDLActionEnum.NONE)   // not in range!
                {
                    continue;
                }

                if (indxMixed.Category == IndexCategoryEnum.NORMAL)
                {
                    IndexMeta indexMetaTmp = new IndexMeta(indxMixed.IndexName, tableDefTmp.Name, _context);
                    foreach (IndexColumn indCol in indxMixed.ColumnNames)
                    {
                        indexMetaTmp.GetColumnList().Add(indCol.ColumnName);
                    }
                    indexList.Add(indexMetaTmp);
                }
                else if (indxMixed.Category == IndexCategoryEnum.PRIMARYKEY)
                {
                    PK_ConstraintAlter pkTmp = new PK_ConstraintAlter(tableMetaTmp, indxMixed.IndexName);
                    foreach (IndexColumn indCol in indxMixed.ColumnNames)
                    {
                        pkTmp.GetColumnList().Add(indCol.ColumnName);
                    }
                    pkTmp.AlterAction = (int)DDLActionEnum.CREATE;
                    primaryKeyList.Add(pkTmp);
                }
                else if (indxMixed.Category == IndexCategoryEnum.UNIQUEKEY)
                {
                    UK_ConstraintAlter ukTmp = new UK_ConstraintAlter(tableMetaTmp, indxMixed.IndexName);
                    foreach (IndexColumn indCol in indxMixed.ColumnNames)
                    {
                        ukTmp.GetColumnList().Add(indCol.ColumnName);
                    }
                    ukTmp.AlterAction = (int)DDLActionEnum.CREATE;
                    uniqkeyList.Add(ukTmp);
                }
            }

            GlobalForeignKeyCollection gFrnKeys = tableDefTmp.GlobalTableForeignKeys;

            foreach (GlobalForeignKey fk in gFrnKeys)
            {
                if (ValidateVersion(fk) == DDLActionEnum.NONE)  // not in range!
                {
                    continue;
                }

                TableMeta          refTable      = new TableMeta(fk.ForeignTable, _context);
                FK_ConstraintAlter foreignKeyTmp = new FK_ConstraintAlter(tableMetaTmp, refTable, fk.Name);
                foreach (ForeignKeyColumn fkCol in fk.Columns)
                {
                    foreignKeyTmp.GetColumnList().Add(fkCol.LocalColumn);
                    foreignKeyTmp.GetRefColumnList().Add(fkCol.ForeignColumn);
                }
                foreignKeyTmp.AlterAction = (int)DDLActionEnum.CREATE;
                foreignKeyList.Add(foreignKeyTmp);
            }
        }