private IEnumerable <DBSchemaItemRef> FillAllReferencesAndReturnTables(List <DBSchemaItemRef> items) { System.Diagnostics.Stopwatch sw = System.Diagnostics.Stopwatch.StartNew(); IEnumerable <DBSchemaItemRef> refs = null; try { refs = provider.GetAllTables(); items.AddRange(refs); refs = provider.GetAllViews(); items.AddRange(refs); refs = provider.GetAllIndexs(); items.AddRange(refs); if ((provider.SupportedSchemaTypes & DBSchemaTypes.StoredProcedure) > 0) { refs = provider.GetAllRoutines(); items.AddRange(refs); } refs = provider.GetAllForeignKeys(); items.AddRange(refs); } catch (Exception ex) { MessageBox.Show("Schema load failed : " + ex.Message); } sw.Stop(); System.Diagnostics.Debug.WriteLine("Total load time: " + sw.Elapsed); return(items); }
public Setup(string conn) { InitDbs(conn); db = base.Database; DBSchemaProvider provider = db.GetSchemaProvider(); tables = provider.GetAllTables(); }
/// <summary> /// /// </summary> /// <returns></returns> public List <string> GetTables() { List <DBSchemaItemRef> tables; List <string> tbls = new List <string>(); DBSchemaProvider provider = db.GetSchemaProvider(); tables = provider.GetAllTables().ToList(); foreach (DBSchemaItemRef s in tables) { tbls.Add(s.Name); } return(tbls); }
public void Install() { DBSchemaProvider provider = db.GetSchemaProvider(); tables = provider.GetAllTables(); DBSchemaItemRef table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozSchema.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozSchema.Table) .Add(Builder.Schema.TalentozSchema.ComponentID) .Add(Builder.Schema.TalentozSchema.ComponentName) .Add(Builder.Schema.TalentozSchema.Category) .Add(Builder.Schema.TalentozSchema.ComponentType) .Add(Builder.Schema.TalentozSchema.Title) .Add(Builder.Schema.TalentozSchema.PrimaryKeys) .Add(Builder.Schema.TalentozSchema.TableName) .Add(Builder.Schema.TalentozSchema.IsGlobal) .Add(Builder.Schema.TalentozSchema.ComponentState) .Add(Builder.Schema.TalentozSchema.EntityKey) .Add(Builder.Schema.TalentozSchema.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchema.ComponentID.Name, Builder.Schema.TalentozSchema.Table); } else { throw new System.Exception(Builder.Schema.TalentozSchema.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozSchemaInfo.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozSchemaInfo.Table) .Add(Builder.Schema.TalentozSchemaInfo.ComponentID) .Add(Builder.Schema.TalentozSchemaInfo.FieldID) .Add(Builder.Schema.TalentozSchemaInfo.AttributeName) .Add(Builder.Schema.TalentozSchemaInfo.DisplayName) .Add(Builder.Schema.TalentozSchemaInfo.IsRequired) .Add(Builder.Schema.TalentozSchemaInfo.IsUnique) .Add(Builder.Schema.TalentozSchemaInfo.IsCore) .Add(Builder.Schema.TalentozSchemaInfo.IsReadOnly) .Add(Builder.Schema.TalentozSchemaInfo.IsSecured) .Add(Builder.Schema.TalentozSchemaInfo.IsNullable) .Add(Builder.Schema.TalentozSchemaInfo.ISPrimaryKey) .Add(Builder.Schema.TalentozSchemaInfo.IsAuto) .Add(Builder.Schema.TalentozSchemaInfo.LookUpID) .Add(Builder.Schema.TalentozSchemaInfo.AttributeType) .Add(Builder.Schema.TalentozSchemaInfo.Length) .Add(Builder.Schema.TalentozSchemaInfo.DefaultValue) .Add(Builder.Schema.TalentozSchemaInfo.FileExtension) .Add(Builder.Schema.TalentozSchemaInfo.LookupComponent) .Add(Builder.Schema.TalentozSchemaInfo.ComponentLookupDisplayName) .Add(Builder.Schema.TalentozSchemaInfo.RegExp) .Add(Builder.Schema.TalentozSchemaInfo.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaInfo.ComponentID.Name + "," + Builder.Schema.TalentozSchemaInfo.FieldID.Name , Builder.Schema.TalentozSchemaInfo.Table); } else { throw new System.Exception(Builder.Schema.TalentozSchemaInfo.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozSchemaClientInfo.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozSchemaClientInfo.Table) .Add(Builder.Schema.TalentozSchemaClientInfo.ClientID) .Add(Builder.Schema.TalentozSchemaClientInfo.ComponentID) .Add(Builder.Schema.TalentozSchemaClientInfo.FieldID) .Add(Builder.Schema.TalentozSchemaClientInfo.AttributeName) .Add(Builder.Schema.TalentozSchemaClientInfo.DisplayName) .Add(Builder.Schema.TalentozSchemaClientInfo.IsRequired) .Add(Builder.Schema.TalentozSchemaClientInfo.IsUnique) .Add(Builder.Schema.TalentozSchemaClientInfo.IsCore) .Add(Builder.Schema.TalentozSchemaClientInfo.IsReadOnly) .Add(Builder.Schema.TalentozSchemaClientInfo.IsSecured) .Add(Builder.Schema.TalentozSchemaClientInfo.IsNullable) .Add(Builder.Schema.TalentozSchemaClientInfo.ISPrimaryKey) .Add(Builder.Schema.TalentozSchemaClientInfo.IsAuto) .Add(Builder.Schema.TalentozSchemaClientInfo.LookUpID) .Add(Builder.Schema.TalentozSchemaClientInfo.AttributeType) .Add(Builder.Schema.TalentozSchemaClientInfo.Length) .Add(Builder.Schema.TalentozSchemaClientInfo.DefaultValue) .Add(Builder.Schema.TalentozSchemaClientInfo.FileExtension) .Add(Builder.Schema.TalentozSchemaClientInfo.LookupComponent) .Add(Builder.Schema.TalentozSchemaClientInfo.ComponentLookupDisplayName) .Add(Builder.Schema.TalentozSchemaClientInfo.RegExp) .Add(Builder.Schema.TalentozSchemaClientInfo.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaClientInfo.ClientID.Name + "," + Builder.Schema.TalentozSchemaClientInfo.ComponentID.Name + "," + Builder.Schema.TalentozSchemaClientInfo.FieldID.Name , Builder.Schema.TalentozSchemaClientInfo.Table); } else { throw new System.Exception(Builder.Schema.TalentozSchemaClientInfo.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozView.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozView.Table) .Add(Builder.Schema.TalentozView.ViewID) .Add(Builder.Schema.TalentozView.CoreComponent) .Add(Builder.Schema.TalentozView.Name) .Add(Builder.Schema.TalentozView.Catgory) .Add(Builder.Schema.TalentozView.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozView.ViewID.Name , Builder.Schema.TalentozView.Table); } else { throw new System.Exception(Builder.Schema.TalentozView.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozViewSchema.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozViewSchema.Table) .Add(Builder.Schema.TalentozViewSchema.ViewID) .Add(Builder.Schema.TalentozViewSchema.ComponentID) .Add(Builder.Schema.TalentozViewSchema.ChildComponentID) .Add(Builder.Schema.TalentozViewSchema.ComponentAlias) .Add(Builder.Schema.TalentozViewSchema.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); // CreatePrimaryKeys(Builder.Schema.TalentozViewSchema.ViewID.Name //, Builder.Schema.TalentozView.Table); } else { throw new System.Exception(Builder.Schema.TalentozViewSchema.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozViewSchemaRelation.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozViewSchemaRelation.Table) .Add(Builder.Schema.TalentozViewSchemaRelation.ViewID) .Add(Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation) .Add(Builder.Schema.TalentozViewSchemaRelation.ParentField) .Add(Builder.Schema.TalentozViewSchemaRelation.RelatedField) .Add(Builder.Schema.TalentozViewSchemaRelation.Parent) .Add(Builder.Schema.TalentozViewSchemaRelation.Child) .Add(Builder.Schema.TalentozViewSchemaRelation.LastUPD); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozViewSchemaRelation.ViewID.Name + "," + Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation.Name , Builder.Schema.TalentozViewSchemaRelation.Table); } else { throw new System.Exception(Builder.Schema.TalentozViewSchemaRelation.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozTemplate.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozTemplate.Table) .Add(Builder.Schema.TalentozTemplate.ClientID) .Add(Builder.Schema.TalentozTemplate.TemplateID) .Add(Builder.Schema.TalentozTemplate.Name) .Add(Builder.Schema.TalentozTemplate.TemplateCode) .Add(Builder.Schema.TalentozTemplate.ViewFields) .Add(Builder.Schema.TalentozTemplate.TemplateType) .Add(Builder.Schema.TalentozTemplate.PivotColumn) .Add(Builder.Schema.TalentozTemplate.Category) .Add(Builder.Schema.TalentozTemplate.ViewID) .Add(Builder.Schema.TalentozTemplate.LastUPD); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaClientInfo.ClientID.Name + "," + Builder.Schema.TalentozTemplate.TemplateID.Name , Builder.Schema.TalentozTemplate.Table); } else { throw new System.Exception(Builder.Schema.TalentozTemplate.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozImportLog.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozImportLog.Table) .Add(Builder.Schema.TalentozImportLog.ImportID) .Add(Builder.Schema.TalentozImportLog.ClientID) .Add(Builder.Schema.TalentozImportLog.ImportSchema) .Add(Builder.Schema.TalentozImportLog.ActionBy) .Add(Builder.Schema.TalentozImportLog.Step) .Add(Builder.Schema.TalentozImportLog.LastUPD); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaClientInfo.ClientID.Name + "," + Builder.Schema.TalentozImportLog.ImportID.Name , Builder.Schema.TalentozImportLog.Table); } else { throw new System.Exception(Builder.Schema.TalentozImportLog.Table + " table Name exist"); } }