public ApplyUpdateIfNotFound ( string testQuery, string updateStatement, bool bIgnore ) : |
||
testQuery | string | |
updateStatement | string | |
bIgnore | bool | |
Результат |
public ActionResult CalendarDatabase() { List<string> lst = new List<string>(); DatabaseUpdate du = new DatabaseUpdate(); DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse(); string sqlUpdate = String.Empty; string sqlTest = String.Empty; try { sqlUpdate = WebHelper.ReadEmbededScript("CarrotCake.CMS.Plugins.CalendarModule.tblCalendar.sql"); sqlTest = "select * from [INFORMATION_SCHEMA].[COLUMNS] where table_name in('tblCalendar')"; dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false); if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) { lst.Add(dbRes.LastException.Message); } else { lst.Add(dbRes.Response); } } catch (Exception ex) { lst.Add(ex.ToString()); } return View(lst); }
protected void Page_Load(object sender, EventArgs e) { DatabaseUpdate du = new DatabaseUpdate(); DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse(); string sqlUpdate = ""; string sqlTest = ""; int iCt = 0; litMsg.Text = ""; sqlUpdate = ReadEmbededScript("Carrotware.CMS.UI.Plugins.EventCalendarModule.carrot_CalendarEvent.sql"); sqlTest = "select * from information_schema.columns where table_name = 'carrot_CalendarEventProfile' and column_name = 'RecursEvery'"; dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false); iCt++; if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) { litMsg.Text += iCt.ToString() + ") " + dbRes.LastException.Message + "<br />"; } else { litMsg.Text += iCt.ToString() + ") " + dbRes.Response + "<br />"; } }
protected void Page_Load(object sender, EventArgs e) { DatabaseUpdate du = new DatabaseUpdate(); DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse(); string sqlUpdate = ""; string sqlTest = ""; int iCt = 0; litMsg.Text = ""; sqlUpdate = ReadEmbededScript("Carrotware.CMS.UI.Plugins.FAQ2Module.carrot_FaqItem.sql"); sqlTest = "select * from [INFORMATION_SCHEMA].[COLUMNS] where table_name in('carrot_FaqItem')"; dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false); iCt++; if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) { litMsg.Text += iCt.ToString() + ") " + dbRes.LastException.Message + "<br />"; } else { litMsg.Text += iCt.ToString() + ") " + dbRes.Response + "<br />"; } }
protected void Page_Load(object sender, EventArgs e) { DatabaseUpdate du = new DatabaseUpdate(); DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse(); string sqlUpdate = ""; string sqlTest = ""; int iCt = 0; litMsg.Text = ""; sqlUpdate = ReadEmbededScript("Carrotware.CMS.UI.Plugins.PhotoGallery.tblGallery.sql"); sqlTest = "select * from [information_schema].[columns] where table_name in('tblGalleryImageMeta')"; dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false); iCt++; if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) { litMsg.Text += iCt.ToString() + ") " + dbRes.LastException.Message + "<br />"; } else { litMsg.Text += iCt.ToString() + ") " + dbRes.Response + "<br />"; } }
public ActionResult GalleryDatabase() { List<string> lst = new List<string>(); DatabaseUpdate du = new DatabaseUpdate(); DatabaseUpdateResponse dbRes = new DatabaseUpdateResponse(); string sqlUpdate = ""; string sqlTest = ""; try { sqlUpdate = GalleryHelper.ReadEmbededScript("CarrotCake.CMS.Plugins.PhotoGallery.tblGallery.sql"); sqlTest = "select * from [information_schema].[columns] where table_name in('tblGalleryImageMeta')"; dbRes = du.ApplyUpdateIfNotFound(sqlTest, sqlUpdate, false); if (dbRes.LastException != null && !string.IsNullOrEmpty(dbRes.LastException.Message)) { lst.Add(dbRes.LastException.Message); } else { lst.Add(dbRes.Response); } } catch (Exception ex) { lst.Add(ex.ToString()); } return View(lst); }