internal static XElement GetSimplePropertyHbmXml(ColumnMetadata entry, string xElementName)
{
if (entry == null)
{
return(null);
}
if (string.IsNullOrWhiteSpace(xElementName))
{
xElementName = Globals.HbmXmlNames.PROPERTY;
}
if (string.IsNullOrWhiteSpace(entry.data_type) &&
Sorting.DbContainers.AllColumns.Data.Any(
x => string.Equals(x.column_name, entry.constraint_name, Sorting.C)))
{
var acEntry =
Sorting.DbContainers.AllColumns.Data.First(
x => string.Equals(x.column_name, entry.constraint_name, Sorting.C));
entry.CopyFrom(acEntry);
}
else
{
entry.CopyFrom(Sorting.GetFromAllColumnMetadata(entry));
}
var simplePropName = Compose.PropertyName(entry.column_name);
var simplePropColumn = NfString.ExtractLastWholeWord(entry.column_name, null);
var simplePropDataType = Globals.HbmXmlNames.ANSI_STRING;
if (!Util.Lexicon.DotNet2HbmTypes.ContainsKey(string.Format("{0}", entry.data_type)) &&
!Util.Lexicon.Mssql2HbmTypes.ContainsKey(string.Format("{0}", entry.data_type)))
{
Console.WriteLine("{0:yyyy-MM-dd HH:mm:ss.ffff} '{1}' has no matching type in the Lexicon [{2}].",
DateTime.Now,
entry.data_type, entry.ToJsonString());
}
else
{
simplePropDataType = entry.data_type.StartsWith("System.")
? Util.Lexicon.DotNet2HbmTypes[entry.data_type]
: Util.Lexicon.Mssql2HbmTypes[entry.data_type];
}
var simplePropLen = simplePropDataType == Globals.HbmXmlNames.ANSI_STRING
? entry.string_length == null || entry.string_length <= 0 ? Globals.MSSQL_MAX_VARCHAR : entry.string_length
: null;
if (simplePropDataType == typeof(Boolean).Name)
{
if (simplePropName.StartsWith(NfString.DefaultNamePrefix))
{
simplePropName = simplePropName.Remove(0, NfString.DefaultNamePrefix.Length);
}
simplePropName = "Is" + simplePropName;
}
return(XeFactory.PropertyNode(xElementName, simplePropName, simplePropColumn,
simplePropDataType, simplePropLen.ToString(), entry.is_nullable.HasValue && entry.is_nullable == true,
entry.ToJsonString()));
}
/// <summary>
/// Produces a single hbm.xml with the sql-query node in tow.
/// </summary>
/// <param name="outputNamespace"></param>
/// <param name="storedProc"></param>
/// <returns>The path to the generated hbm.xml file.</returns>
public static string GetHbmNamedQueryXml(string outputNamespace, string storedProc)
{
if (Sorting.AllStoredProcNames == null || Sorting.AllStoredProcNames.Count <= 0)
{
throw new RahRowRagee("There doesn't appear to be any stored procs here.");
}
if (Settings.DoNotReference.Contains(storedProc) || !Sorting.AllStoredProx.ContainsKey(storedProc))
{
return(null);
}
var sp = Sorting.AllStoredProx[storedProc];
if (sp == null)
{
return(null);
}
var returnedData = sp.ReturnedData;
if (returnedData == null || returnedData.Count <= 0)
{
return(null);
}
if (returnedData.Keys.Count <= 0)
{
Settings.WriteToStoredProcLog(string.Format("Stored proc named '{0}' has an empty dataset", sp.ProcName));
if (!Sorting.EmptyDatasetProx.Contains(sp.ProcName))
{
Sorting.EmptyDatasetProx.Add(sp.ProcName);
}
return(null);
}
//both the return types and the callable sql-query are wrapped in this root node
var xe = XeFactory.HibernateMappingNode();
if (returnedData.Count > 1)
{
Settings.WriteToStoredProcLog(string.Format("Stored Proc named '{0}' returns a multi-table dataset", storedProc));
if (!Sorting.MultiTableDsProx.Contains(storedProc))
{
Sorting.MultiTableDsProx.Add(storedProc);
}
}
//possiable duplicate names handled within this
var className = Compose.ClassName(string.Format("{0}.{1}{2}", Globals.STORED_PROX_FOLDER_NAME, storedProc, "Table"), outputNamespace);
var classXe = XeFactory.ClassNode(className, null, null);
classXe.Add(XeFactory.IdNode(null));
var sqlQryName = NfString.SafeDotNetIdentifier(storedProc);
var returnsXe = XeFactory.ReturnNode(sqlQryName, className);
foreach (var cMeta in returnedData[returnedData.Keys.First()])
{
var simplePropName = Compose.PropertyName(cMeta.column_name, true);
var simplePropColumn = NfString.ExtractLastWholeWord(cMeta.column_name, null);
var simplePropDataType = Util.Lexicon.DotNet2HbmTypes[cMeta.data_type];
classXe.Add(XeFactory.PropertyNode(Globals.HbmXmlNames.PROPERTY, simplePropName, null, simplePropDataType,
(cMeta.data_type == "System.String"
? Globals.MSSQL_MAX_VARCHAR.ToString(CultureInfo.InvariantCulture)
: null), cMeta.is_nullable.HasValue && cMeta.is_nullable == true, string.Empty));
returnsXe.Add(XeFactory.ReturnPropertyNode(simplePropColumn, simplePropName));
}
var sqlQryXe = XeFactory.SqlQueryNode(sqlQryName);
sqlQryXe.Add(returnsXe);
sqlQryXe.Add(new XCData(sp.ToHbmSql()));
xe.Add(classXe);
xe.Add(sqlQryXe);
var hbmXmlOutputPath = Path.Combine(Settings.HbmStoredProcsDirectory,
Compose.HbmFileName(storedProc.Replace(" ", Globals.REPLACE_SPACE_WITH_SEQUENCE)));
var xmlContent = xe.ToString()
.Replace("<hibernate-mapping>", "<hibernate-mapping xmlns=\"urn:nhibernate-mapping-2.2\">");
File.WriteAllText(hbmXmlOutputPath, xmlContent);
CorrectHbmXmlDuplicateNames(hbmXmlOutputPath, true);
return(hbmXmlOutputPath);
}
