Exemple #1
0
        protected override void TryProcessCast3Indexs(IList <TableDefInfo> tableList, IGeneratorWriter scriptWriter)
        {
            bool bCreatePKs = (m_scriptBuilder.DbXPIndexInCreateTable() == false);

            foreach (TableDefInfo tableDef in tableList)
            {
                if (bCreatePKs)
                {
                    IndexDefInfo indexPK = tableDef.IndexPK();
                    if (indexPK != null)
                    {
                        string scriptPart = m_scriptBuilder.AlterXPKIndexSQL(indexPK);

                        scriptPart += DBConstants.NEW_LINE_STR;

                        scriptWriter.DefaultCodeLine(scriptPart, indexPK.InfoName());
                    }
                }

                IList <IndexDefInfo> indexes = tableDef.IndexesNonPK();
                foreach (var indexIF in indexes)
                {
                    string scriptPart = m_scriptBuilder.CreateIndexSQL(indexIF);

                    scriptPart += DBConstants.NEW_LINE_STR;

                    scriptWriter.DefaultCodeLine(scriptPart, indexIF.InfoName());
                }
            }
        }