internal static void Generate(
DBConnection cn, TextWriter writer, string namespaceDeclaration, Database database,
RedStapler.StandardLibrary.Configuration.SystemDevelopment.Database configuration)
{
StandardModificationStatics.writer = writer;
StandardModificationStatics.database = database;
writer.WriteLine( namespaceDeclaration );
foreach( var tableName in DatabaseOps.GetDatabaseTables( database ) ) {
var isRevisionHistoryTable = DataAccessStatics.IsRevisionHistoryTable( tableName, configuration );
writeClass( cn, tableName, isRevisionHistoryTable, false );
if( isRevisionHistoryTable )
writeClass( cn, tableName, true, true );
}
writer.WriteLine( "}" );
}
internal static void Generate(DBConnection cn, TextWriter writer, string baseNamespace, Database database,
RedStapler.StandardLibrary.Configuration.SystemDevelopment.Database configuration)
{
info = cn.DatabaseInfo;
if (configuration.customModifications != null)
{
writer.WriteLine("namespace " + baseNamespace + " {");
testQueries(cn, configuration.customModifications);
CodeGenerationStatics.AddSummaryDocComment(writer, "Contains custom modification operations.");
writer.WriteLine("public static class " + database.SecondaryDatabaseName + "CustomModifications {");
foreach (var mod in configuration.customModifications)
{
writeMethod(writer, database, mod);
}
writer.WriteLine("}"); // class
writer.WriteLine("}"); // namespace
}
}
internal static void Generate(
DBConnection cn, TextWriter writer, string baseNamespace, Database database,
RedStapler.StandardLibrary.Configuration.SystemDevelopment.Database configuration)
{
if (configuration.queries == null)
{
return;
}
info = cn.DatabaseInfo;
writer.WriteLine("namespace " + baseNamespace + "." + database.SecondaryDatabaseName + "Retrieval {");
foreach (var query in configuration.queries)
{
List <Column> columns;
try {
columns = validateQueryAndGetColumns(cn, query);
}
catch (Exception e) {
throw new UserCorrectableException("Column retrieval failed for the " + query.name + " query.", e);
}
CodeGenerationStatics.AddSummaryDocComment(writer, "This object holds the values returned from a " + query.name + " query.");
writer.WriteLine("public static partial class " + query.name + "Retrieval {");
// Write nested classes.
DataAccessStatics.WriteRowClasses(writer, columns, localWriter => { });
writeCacheClass(writer, database, query);
writer.WriteLine("private const string selectFromClause = @\"" + query.selectFromClause + " \";");
foreach (var postSelectFromClause in query.postSelectFromClauses)
{
writeQueryMethod(writer, database, query, postSelectFromClause);
}
writer.WriteLine("static partial void updateSingleRowCaches( Row row );");
writer.WriteLine("}"); // class
}
writer.WriteLine("}"); // namespace
}
internal static bool IsRevisionHistoryTable(string table, RedStapler.StandardLibrary.Configuration.SystemDevelopment.Database configuration)
{
return(configuration.revisionHistoryTables != null &&
configuration.revisionHistoryTables.Any(revisionHistoryTable => revisionHistoryTable.EqualsIgnoreCase(table)));
}
internal static void Generate(
DBConnection cn, TextWriter writer, string namespaceDeclaration, Database database,
RedStapler.StandardLibrary.Configuration.SystemDevelopment.Database configuration)
{
writer.WriteLine(namespaceDeclaration);
foreach (var table in DatabaseOps.GetDatabaseTables(database))
{
CodeGenerationStatics.AddSummaryDocComment(writer, "Contains logic that retrieves rows from the " + table + " table.");
writer.WriteLine("public static partial class " + GetClassName(cn, table) + " {");
var isRevisionHistoryTable = DataAccessStatics.IsRevisionHistoryTable(table, configuration);
var columns = new TableColumns(cn, table, isRevisionHistoryTable);
// Write nested classes.
DataAccessStatics.WriteRowClasses(
writer,
columns.AllColumns,
localWriter => {
if (!columns.DataColumns.Any())
{
return;
}
var modClass = database.SecondaryDatabaseName + "Modification." +
StandardModificationStatics.GetClassName(cn, table, isRevisionHistoryTable, isRevisionHistoryTable);
var revisionHistorySuffix = StandardModificationStatics.GetRevisionHistorySuffix(isRevisionHistoryTable);
writer.WriteLine("public " + modClass + " ToModification" + revisionHistorySuffix + "() {");
writer.WriteLine(
"return " + modClass + ".CreateForSingleRowUpdate" + revisionHistorySuffix + "( " +
StringTools.ConcatenateWithDelimiter(
", ",
columns.AllColumnsExceptRowVersion.Select(i => StandardLibraryMethods.GetCSharpIdentifierSimple(i.PascalCasedNameExceptForOracle)).ToArray()) +
" );");
writer.WriteLine("}");
});
writeCacheClass(cn, writer, database, table, columns, isRevisionHistoryTable);
var isSmallTable = configuration.SmallTables != null && configuration.SmallTables.Any(i => i.EqualsIgnoreCase(table));
var tableUsesRowVersionedCaching = configuration.TablesUsingRowVersionedDataCaching != null &&
configuration.TablesUsingRowVersionedDataCaching.Any(i => i.EqualsIgnoreCase(table));
if (tableUsesRowVersionedCaching && columns.RowVersionColumn == null && !(cn.DatabaseInfo is OracleInfo))
{
throw new UserCorrectableException(
cn.DatabaseInfo is MySqlInfo
? "Row-versioned data caching cannot currently be used with MySQL databases."
: "Row-versioned data caching can only be used with the {0} table if you add a rowversion column.".FormatWith(table));
}
if (isSmallTable)
{
writeGetAllRowsMethod(writer, isRevisionHistoryTable, false);
}
writeGetRowsMethod(cn, writer, database, table, columns, isSmallTable, tableUsesRowVersionedCaching, isRevisionHistoryTable, false);
if (isRevisionHistoryTable)
{
if (isSmallTable)
{
writeGetAllRowsMethod(writer, true, true);
}
writeGetRowsMethod(cn, writer, database, table, columns, isSmallTable, tableUsesRowVersionedCaching, true, true);
}
if (columns.KeyColumns.Count() == 1 && columns.KeyColumns.Single().Name.ToLower().EndsWith("id"))
{
writeGetRowMatchingIdMethod(cn, writer, database, table, columns, isSmallTable, tableUsesRowVersionedCaching, isRevisionHistoryTable);
}
if (isRevisionHistoryTable)
{
DataAccessStatics.WriteGetLatestRevisionsConditionMethod(writer, columns.PrimaryKeyAndRevisionIdColumn.Name);
}
if (tableUsesRowVersionedCaching)
{
var keyTupleTypeArguments = getPkAndVersionTupleTypeArguments(cn, columns);
writer.WriteLine("private static " + "Cache<System.Tuple<" + keyTupleTypeArguments + ">, BasicRow>" + " getRowsByPkAndVersion() {");
writer.WriteLine(
"return AppMemoryCache.GetCacheValue<{0}>( \"{1}\", () => new {0}( i => System.Tuple.Create( {2} ) ) ).RowsByPkAndVersion;".FormatWith(
"VersionedRowDataCache<System.Tuple<{0}>, System.Tuple<{1}>, BasicRow>".FormatWith(getPkTupleTypeArguments(columns), keyTupleTypeArguments),
database.SecondaryDatabaseName + table.TableNameToPascal(cn) + "TableRetrievalRowsByPkAndVersion",
StringTools.ConcatenateWithDelimiter(", ", Enumerable.Range(1, columns.KeyColumns.Count()).Select(i => "i.Item{0}".FormatWith(i)).ToArray())));
writer.WriteLine("}");
}
// Initially we did not generate this method for small tables, but we found a need for it when the cache is disabled since that will cause
// GetRowMatchingId to repeatedly query.
if (columns.KeyColumns.Count() == 1 && columns.KeyColumns.Single().Name.ToLower().EndsWith("id"))
{
writeToIdDictionaryMethod(writer, columns);
}
writer.WriteLine("}"); // class
}
writer.WriteLine("}"); // namespace
}
internal static void Generate(
DBConnection cn, TextWriter writer, string baseNamespace, Database database,
RedStapler.StandardLibrary.Configuration.SystemDevelopment.Database configuration ) {
if( configuration.rowConstantTables == null )
return;
writer.WriteLine( "namespace " + baseNamespace + "." + database.SecondaryDatabaseName + "RowConstants {" );
foreach( var table in configuration.rowConstantTables ) {
Column valueColumn;
var orderIsSpecified = !table.orderByColumn.IsNullOrWhiteSpace();
var values = new List<string>();
var names = new List<string>();
try {
var columns = new TableColumns( cn, table.tableName, false );
valueColumn = columns.AllColumnsExceptRowVersion.Single( column => column.Name.ToLower() == table.valueColumn.ToLower() );
var nameColumn = columns.AllColumnsExceptRowVersion.Single( column => column.Name.ToLower() == table.nameColumn.ToLower() );
var cmd = new InlineSelect(
new[] { valueColumn.Name, nameColumn.Name },
"FROM " + table.tableName,
false,
orderByClause: orderIsSpecified ? "ORDER BY " + table.orderByColumn : "" );
cmd.Execute(
cn,
reader => {
while( reader.Read() ) {
if( reader.IsDBNull( reader.GetOrdinal( valueColumn.Name ) ) )
values.Add( valueColumn.NullValueExpression.Any() ? valueColumn.NullValueExpression : "null" );
else {
var valueString = valueColumn.ConvertIncomingValue( reader[ valueColumn.Name ] ).ToString();
values.Add( valueColumn.DataTypeName == typeof( string ).ToString() ? "\"{0}\"".FormatWith( valueString ) : valueString );
}
names.Add( nameColumn.ConvertIncomingValue( reader[ nameColumn.Name ] ).ToString() );
}
} );
}
catch( Exception e ) {
throw new UserCorrectableException(
"Column or data retrieval failed for the " + table.tableName + " row constant table. Make sure the table and the value, name, and order by columns exist.",
e );
}
CodeGenerationStatics.AddSummaryDocComment( writer, "Provides constants copied from the " + table.tableName + " table." );
var className = table.tableName.TableNameToPascal( cn ) + "Rows";
writer.WriteLine( "public class " + className + " {" );
// constants
for( var i = 0; i < values.Count; i++ ) {
CodeGenerationStatics.AddSummaryDocComment( writer, "Constant generated from row in database table." );
// It's important that row constants actually *be* constants (instead of static readonly) so they can be used in switch statements.
writer.WriteLine( "public const " + valueColumn.DataTypeName + " " + StandardLibraryMethods.GetCSharpIdentifier( names[ i ] ) + " = " + values[ i ] + ";" );
}
// one to one map
var dictionaryType = "OneToOneMap<" + valueColumn.DataTypeName + ", string>";
writer.WriteLine( "private static readonly " + dictionaryType + " " + dictionaryName + " = new " + dictionaryType + "();" );
writeStaticConstructor( writer, className, names, values, valueColumn.DataTypeName );
// methods
writeGetNameFromValueMethod( writer, valueColumn.DataTypeName );
writeGetValueFromNameMethod( writer, valueColumn.DataTypeName );
if( orderIsSpecified ) {
writeGetValuesToNamesMethod( writer, valueColumn.DataTypeName );
writeFillListControlMethod( writer, valueColumn );
}
writer.WriteLine( "}" ); // class
}
writer.WriteLine( "}" ); // namespace
}
