public static TableEntity.Table GetTableEntityByTableName(string tableName) { System.Data.DataTable userDataTable = OracleDocument.GetUserTableByTableName(tableName); if (userDataTable.Rows.Count > 0) { return(GetTableEntityByDataRow(userDataTable.Rows[0])); } return(null); }
public static Dictionary <string, string> GetIndexColumnByIndexName(string indexName) { Dictionary <string, string> columnDictionary = new Dictionary <string, string>(); System.Data.DataTable columnDataTable = OracleDocument.GetIndexesColumnsByIndexName(indexName); foreach (System.Data.DataRow dataRow in columnDataTable.Rows) {//index_name,table_name,column_name,column_position, descend columnDictionary.Add(dataRow["column_name"].ToString().ToLower(), dataRow["descend"].ToString().ToLower()); } return(columnDictionary); }
public static Dictionary <string, TableEntity.Trigger> GetTriggerByTable(string tableName) { Dictionary <string, TableEntity.Trigger> triggerDictionary = new Dictionary <string, TableEntity.Trigger>(); System.Data.DataTable triggerDataTable = OracleDocument.GetTriggerByTableName(tableName); foreach (System.Data.DataRow dataRow in triggerDataTable.Rows) {//a.table_name,a.trigger_name,a.table_owner,a.triggering_event,a.trigger_body TableEntity.Trigger trigger = new TableEntity.Trigger(); trigger.TriggerName = dataRow["trigger_name"].ToString(); trigger.TriggeringEvent = dataRow["triggering_event"].ToString(); trigger.TriggerBody = dataRow["trigger_body"].ToString(); trigger.ColumnName = dataRow["column_name"].ToString(); triggerDictionary.Add(trigger.TriggerName, trigger); } return(triggerDictionary); }
public static Dictionary <string, TableEntity.Table> AllTable() { Dictionary <string, TableEntity.Table> tablesDictionary = new Dictionary <string, TableEntity.Table>(); System.Data.DataTable userDataTable = OracleDocument.GetAllUserTable(); int i = 1; foreach (System.Data.DataRow dataRow in userDataTable.Rows) { TableEntity.Table userTable = GetTableEntityByDataRow(dataRow); tablesDictionary.Add(userTable.TableName, userTable); //if (++i > 20) // break; } return(tablesDictionary); }
public static Dictionary <string, TableEntity.Index> GetIndexesByTable(string tableName) {//a.index_name,table_owner,table_name,a.uniqueness,a.tablespace_name Dictionary <string, TableEntity.Index> indexDictionary = new Dictionary <string, TableEntity.Index>(); System.Data.DataTable indexDataTable = OracleDocument.GetIndexesByTableName(tableName); foreach (System.Data.DataRow dataRow in indexDataTable.Rows) { TableEntity.Index index = new TableEntity.Index(); index.IndexName = dataRow["index_name"].ToString().ToLower(); index.TableSpace = dataRow["tablespace_name"].ToString(); index.Uniqueness = dataRow["uniqueness"].ToString(); index.Columns = GetIndexColumnByIndexName(index.IndexName); indexDictionary.Add(index.IndexName, index); } return(indexDictionary); }
public static Dictionary <string, TableEntity.Column> GetColumnsByTable(string tableName) { Dictionary <string, TableEntity.Column> columnsDictionary = new Dictionary <string, TableEntity.Column>(); System.Data.DataTable columnDataTable = OracleDocument.GetColumnsByTableName(tableName); foreach (System.Data.DataRow dataRow in columnDataTable.Rows) { // a.table_name,a.column_name,a.data_type,a.data_length,a.NULLABLE,a.column_id,b.comments TableEntity.Column column = new TableEntity.Column(); column.ColumnName = dataRow["column_name"].ToString().ToLower(); column.ColumnType = dataRow["data_type"].ToString(); column.ColumnLength = dataRow["data_length"].ToString(); column.NullAble = dataRow["nullable"].ToString(); column.DefaultValue = dataRow["data_default"].ToString(); column.Comments = dataRow["comments"].ToString(); columnsDictionary.Add(column.ColumnName, column); } return(columnsDictionary); }