public static void UpdateDatabase(string database, string server, string user, string password)
{
string convertDbFile = Path.Combine(Application.StartupPath, Form1.convertDbFile);
string logFileName = "CrudGeneratorLog.txt";
try {
ConnectToDatabase(database, server, user, password);
File.AppendAllText(logFileName, "-------------------Updating database '" + database + "' on " + DateTime.Now.ToString() + "-----------------------------"
+ "--\r\n");
List <Type> tableTypes = new List <Type>();
Type typeTableBase = typeof(TableBase);
Assembly assembly = Assembly.GetAssembly(typeTableBase);
foreach (Type typeClass in assembly.GetTypes())
{
if (typeClass.IsSubclassOf(typeTableBase) && !IsMobile(typeClass))
{
CrudQueries.Write(convertDbFile, typeClass, database, false, true, false, logFileName);
}
}
AddMissingPreferences(convertDbFile, logFileName);
}
catch (Exception ex) {
File.AppendAllText(logFileName, "Error: " + ex.Message + "\r\nStack Trace:\r\n" + ex.StackTrace + "\r\n\r\nTime of Occurrence: " + DateTime.Now + "\r\n");
}
}
public static string Create()
{
StringBuilder strb = new StringBuilder();
//This is a stub that is to be replaced with some good code generation:
strb.Append(@"using System;
using System.Collections.Generic;
using System.Text;
namespace OpenDentBusiness {
///<summary>Please ignore this class. It's used only for testing.</summary>
public class SchemaCrudTest {
///<summary>Example only</summary>
public static void AddTableTempcore() {
string command="""";" );
Type typeClass = typeof(SchemaTable);
FieldInfo[] fields = typeClass.GetFields();
FieldInfo priKey = CrudGenHelper.GetPriKey(fields, typeClass.Name);
List <FieldInfo> fieldsExceptPri = CrudGenHelper.GetFieldsExceptPriKey(fields, priKey);
List <DbSchemaCol> cols = CrudQueries.GetListColumns(priKey.Name, null, fieldsExceptPri, false);
strb.Append("\r\n" + CrudSchemaRaw.AddTable("tempcore", cols, 3, false, false));
strb.Append(@"
}
///<summary>Example only</summary>
public static void AddColumnEndClob() {
string command="""";" );
DbSchemaCol col = new DbSchemaCol("ColEndClob", OdDbType.Text, TextSizeMySqlOracle.Medium);
strb.Append("\r\n" + CrudSchemaRaw.AddColumnEnd("tempcore", col, 3, false, typeClass));
strb.Append(@"
}
///<summary>Example only</summary>
public static void AddColumnEndInt() {
string command="""";" );
col = new DbSchemaCol("ColEndInt", OdDbType.Int);
strb.Append("\r\n" + CrudSchemaRaw.AddColumnEnd("tempcore", col, 3, false, typeClass));
strb.Append(@"
}
///<summary>Example only</summary>
public static void AddColumnEndTimeStamp() {
string command="""";" );
col = new DbSchemaCol("ColEndTimeStamp", OdDbType.DateTimeStamp);
strb.Append("\r\n" + CrudSchemaRaw.AddColumnEnd("tempcore", col, 3, false, typeClass));
strb.Append(@"
}
///<summary>Example only</summary>
public static void AddIndex() {
string command="""";" );
strb.Append("\r\n" + CrudSchemaRaw.AddIndex("tempcore", "ColEndInt", 3));
strb.Append(@"
}
///<summary>Example only</summary>
public static void DropColumn() {
string command="""";" );
strb.Append("\r\n" + CrudSchemaRaw.DropColumn("tempcore", "TextLargeTest", 3));
strb.Append(@"
}
//AddColumnAfter
//DropColumnTimeStamp
//DropIndex
//etc.
}
}");
return(strb.ToString());
}
///<summary>Writes any necessary queries to the end of the ConvertDatabase file. Usually zero or one. The convertDbFile could also be the one in the Mobile folder.</summary>
///<param name="logFileName">If this is blank, will display the results in a MessageBox, otherwise writes the results to the file.</param>
public static void Write(string convertDbFile, Type typeClass, string dbName, bool isMobile, bool doRunQueries, bool doAppendToConvertDbFile,
string logFileName = "")
{
StringBuilder strb;
FieldInfo[] fields = typeClass.GetFields(); //We can't assume they are in the correct order.
FieldInfo priKey = null;
FieldInfo priKey1 = null;
FieldInfo priKey2 = null;
if (isMobile)
{
priKey1 = CrudGenHelper.GetPriKeyMobile1(fields, typeClass.Name);
priKey2 = CrudGenHelper.GetPriKeyMobile2(fields, typeClass.Name);
}
else
{
priKey = CrudGenHelper.GetPriKey(fields, typeClass.Name);
}
string tablename = CrudGenHelper.GetTableName(typeClass); //in lowercase now.
string priKeyParam = null;
string priKeyParam1 = null;
string priKeyParam2 = null;
if (isMobile)
{
priKeyParam1 = priKey1.Name.Substring(0, 1).ToLower() + priKey1.Name.Substring(1); //lowercase initial letter. Example customerNum
priKeyParam2 = priKey2.Name.Substring(0, 1).ToLower() + priKey2.Name.Substring(1); //lowercase initial letter. Example patNum
}
else
{
priKeyParam = priKey.Name.Substring(0, 1).ToLower() + priKey.Name.Substring(1); //lowercase initial letter. Example patNum
}
string obj = typeClass.Name.Substring(0, 1).ToLower() + typeClass.Name.Substring(1); //lowercase initial letter. Example feeSched or feeSchedm
List <FieldInfo> fieldsExceptPri = null;
if (isMobile)
{
fieldsExceptPri = CrudGenHelper.GetFieldsExceptPriKey(fields, priKey2); //for mobile, only excludes PK2
}
else
{
fieldsExceptPri = CrudGenHelper.GetFieldsExceptPriKey(fields, priKey);
}
CrudSpecialColType specialType;
string command = "SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = '" + dbName + "' AND table_name = '" + tablename + "'";
if (DataCore.GetScalar(command) != "1")
{
if (!CrudGenHelper.IsMissingInGeneral(typeClass))
{
strb = new StringBuilder();
strb.Append("This table was not found in the database:"
+ rn + tablename);
if (doAppendToConvertDbFile)
{
strb.Append(rn + "Query will be found at the end of " + Path.GetFileName(convertDbFile));
}
if (doRunQueries)
{
strb.Append(rn + "Table will be added to database.");
}
if (string.IsNullOrEmpty(logFileName))
{
MessageBox.Show(strb.ToString());
}
else
{
File.AppendAllText(logFileName, strb.ToString() + "\r\n");
}
strb = new StringBuilder();
strb.Append(rn + rn + t4 + "/*");
List <DbSchemaCol> cols = null;
if (isMobile)
{
cols = CrudQueries.GetListColumns(priKey1.Name, priKey2.Name, fieldsExceptPri, true);
}
else
{
cols = CrudQueries.GetListColumns(priKey.Name, null, fieldsExceptPri, false);
}
strb.Append("\r\n" + CrudSchemaRaw.AddTable(tablename, cols, 4, isMobile, doRunQueries));
strb.Append(rn + t4 + "*/");
if (doAppendToConvertDbFile)
{
File.AppendAllText(convertDbFile, strb.ToString());
}
}
}
List <FieldInfo> newColumns = CrudGenHelper.GetNewFields(fields, typeClass, dbName);
if (newColumns.Count > 0)
{
strb = new StringBuilder();
strb.Append("The following columns were not found in the database.");
for (int f = 0; f < newColumns.Count; f++)
{
strb.Append(rn + tablename + "." + newColumns[f].Name);
}
if (doAppendToConvertDbFile)
{
strb.Append(rn + "Query will be found at the end of " + Path.GetFileName(convertDbFile));
}
if (doRunQueries)
{
strb.Append(rn + "Column will be added to table.");
}
if (string.IsNullOrEmpty(logFileName))
{
MessageBox.Show(strb.ToString()); //one message for all new columns in a table.
}
else
{
File.AppendAllText(logFileName, strb.ToString() + "\r\n");
}
strb = new StringBuilder();
strb.Append(rn + rn + t4 + "/*");
for (int f = 0; f < newColumns.Count; f++)
{
specialType = CrudGenHelper.GetSpecialType(newColumns[f]);
OdDbType odtype = GetOdDbTypeFromColType(newColumns[f].FieldType, specialType);
TextSizeMySqlOracle textsize = TextSizeMySqlOracle.Small;
if (specialType.HasFlag(CrudSpecialColType.TextIsClob))
{
textsize = TextSizeMySqlOracle.Medium;
}
DbSchemaCol col = new DbSchemaCol(newColumns[f].Name, odtype, textsize);
strb.Append(CrudSchemaRaw.AddColumnEnd(tablename, col, 4, doRunQueries, typeClass));
}
strb.Append(rn + t4 + "*/");
if (doAppendToConvertDbFile)
{
File.AppendAllText(convertDbFile, strb.ToString());
}
}
}
public static string GetSnippet(Type typeClass, SnippetType snipType, bool isMobile)
{
//bool isMobile=CrudGenHelper.IsMobile(typeClass);
string Sname = GetSname(typeClass.Name);
FieldInfo[] fields = typeClass.GetFields(); //We can't assume they are in the correct order.
FieldInfo priKey = null;
FieldInfo priKey1 = null;
FieldInfo priKey2 = null;
if (isMobile)
{
priKey1 = CrudGenHelper.GetPriKeyMobile1(fields, typeClass.Name);
priKey2 = CrudGenHelper.GetPriKeyMobile2(fields, typeClass.Name);
}
else
{
priKey = CrudGenHelper.GetPriKey(fields, typeClass.Name);
}
string priKeyParam = null;
string priKeyParam1 = null;
string priKeyParam2 = null;
if (isMobile)
{
priKeyParam1 = priKey1.Name.Substring(0, 1).ToLower() + priKey1.Name.Substring(1); //lowercase initial letter. Example customerNum
priKeyParam2 = priKey2.Name.Substring(0, 1).ToLower() + priKey2.Name.Substring(1); //lowercase initial letter. Example patNum
}
else
{
priKeyParam = priKey.Name.Substring(0, 1).ToLower() + priKey.Name.Substring(1); //lowercase initial letter. Example patNum
}
string obj = typeClass.Name.Substring(0, 1).ToLower() + typeClass.Name.Substring(1); //lowercase initial letter. Example feeSched
string tablename = CrudGenHelper.GetTableName(typeClass); //in lowercase now. Example feesched
List <FieldInfo> fieldsExceptPri = null;
if (isMobile)
{
fieldsExceptPri = CrudGenHelper.GetFieldsExceptPriKey(fields, priKey2); //for mobile, only excludes PK2
}
else
{
fieldsExceptPri = CrudGenHelper.GetFieldsExceptPriKey(fields, priKey);
}
bool isTableHist = CrudGenHelper.IsTableHist(typeClass);
List <DbSchemaCol> cols = CrudQueries.GetListColumns(priKey.Name, null, fieldsExceptPri, false);
switch (snipType)
{
default:
return("snippet type not found.");
case SnippetType.Insert:
if (isMobile)
{
return(GetInsert(typeClass.Name, obj, null, true));
}
else
{
return(GetInsert(typeClass.Name, obj, priKey.Name, false));
}
case SnippetType.Update:
return(GetUpdate(typeClass.Name, obj, isMobile, isTableHist));
case SnippetType.EntireSclass:
if (isMobile)
{
return(GetEntireSclassMobile(typeClass.Name, obj, priKey1.Name, priKey2.Name, Sname, tablename, priKeyParam1, priKeyParam2, isTableHist));
}
else
{
List <Permissions> listAuditTrailPerms = GroupPermissions.GetPermsFromCrudAuditPerm(CrudTableAttribute.GetCrudAuditPermForClass(typeClass));
return(GetEntireSclass(typeClass.Name, obj, priKey.Name, Sname, tablename, priKeyParam, listAuditTrailPerms, isTableHist));
}
case SnippetType.AddTable:
return(CrudSchemaRaw.AddTable(tablename, cols, 0, false, false));
case SnippetType.AddColumnEnd:
return(string.Join("\r\n\r\n", cols.Select(x => CrudSchemaRaw.AddColumnEnd(tablename, x, 0, false, typeClass).Trim())));
case SnippetType.AddIndex:
return(string.Join("\r\n\r\n", cols.Select(x => CrudSchemaRaw.AddIndex(tablename, x.ColumnName, 0).Trim())));
case SnippetType.DropColumn:
return(string.Join("\r\n\r\n", cols.Select(x => CrudSchemaRaw.DropColumn(tablename, x.ColumnName, 0).Trim())));
}
}