示例#1
0
        //получение полей первичного ключа
        public IndexData GetPrimaryKey(string schemaName, string tableName)
        {
            var _primData = new IndexData();

            if (_initialized)
            {
                using (ODBCHStatement statement = new ODBCHStatement(_connectionHandle))
                {
                    PrimaryKeyStatementDefinition primaryKeyDefinition = new PrimaryKeyStatementDefinition();
                    List <ODBCData> data = null;
                    try
                    {
                        data = BindBuffer(primaryKeyDefinition);
                        if (ODBCMethods.GetPrimKey(statement, schemaName, tableName))
                        {
                            if (BindColumns(data, statement))
                            {
                                while (ODBCMethods.Fetch(statement))
                                {
                                    FillInternalData(ref data);
                                    _primData.SetData(0, "");
                                    ColumnData _cd = new ColumnData(data[0].InternalData.strVal, data[1].InternalData.intVal, true);
                                    _primData.AddColumnData(_cd);
                                    //PrimaryKeyData prim = new PrimaryKeyData(data[0].InternalData.strVal, data[1].InternalData.intVal);
                                    // _primData.Add(prim);
                                }
                            }
                        }
                    }
                    finally
                    {
                        foreach (var record in data)
                        {
                            record.Dispose();
                        }
                        //  statement.Close();
                    }
                }
                return(_primData);
            }
            else
            {
                throw new ODBCErrorNotInitialized("You must connect to database!");
            }
        }
示例#2
0
        //получение информации об индексах, полях, входящих в них
        public List <IndexData> GetIndexData(string schemaName, string tableName)
        {
            var          _indexesData = new List <IndexData>();
            const ushort _indexType   = 1; //all indexes;

            if (_initialized)
            {
                using (ODBCHStatement statement = new ODBCHStatement(_connectionHandle))
                {
                    List <ODBCData>          data = null;
                    IndexStatementDefinition indexStatementDefinition = new IndexStatementDefinition();
                    try
                    {
                        data = BindBuffer(indexStatementDefinition);

                        if (ODBCNative.ODBCMethods.GetIndexInfo(statement, schemaName, tableName, _indexType))
                        {
                            if (BindColumns(data, statement))
                            {
                                bool fetched = ODBCNative.ODBCMethods.Fetch(statement);
                                while (fetched)
                                {
                                    FillInternalData(ref data);
                                    string indexName = data[1].InternalData.strVal;
                                    if (indexName.Length > 1)
                                    {
                                        IndexData _indexData = new IndexData();
                                        _indexData.SetData(data[0].InternalData.intVal, data[1].InternalData.strVal);

                                        while ((fetched) & (indexName.Equals(data[1].InternalData.strVal)))
                                        {
                                            int _unique = ODBCMethods.ReadShort(data[0].ColumnData);
                                            if ((_unique == ODBCNative.ODBCConstants.SQL_IS_INDEX_UNIQUE) | (_unique == ODBCNative.ODBCConstants.SQL_IS_INDEX_DUPLICATE))
                                            {
                                                bool       asc = (data[4].InternalData.strVal == "A");
                                                ColumnData cd  = new ColumnData(data[3].InternalData.strVal, data[2].InternalData.intVal, asc);
                                                _indexData.AddColumnData(cd);
                                            }
                                            fetched = ODBCNative.ODBCMethods.Fetch(statement);
                                            if (fetched)
                                            {
                                                FillInternalData(ref data);
                                            }
                                        }

                                        _indexesData.Add(_indexData);
                                    }
                                    else
                                    {
                                        fetched = ODBCNative.ODBCMethods.Fetch(statement);
                                    }
                                }
                            }
                        }
                    }

                    finally
                    {
                        foreach (var record in data)
                        {
                            record.Dispose();
                        }
                    }
                }
                return(_indexesData);
            }
            else
            {
                throw new ODBCErrorNotInitialized("You must connect to database!");
            }
        }