/// <summary> /// Convenience method for creating a param location recognizer and /// initiating the parse. /// </summary> /// <param name="query">The query to be parsed for parameter locations. </param> /// <returns> The generated recognizer, with journaled location info. </returns> public static ParamLocationRecognizer ParseLocations(string query) { var recognizer = new ParamLocationRecognizer(); ParameterParser.Parse(query, recognizer); return(recognizer); }
public void CanFindParameterAfterComment() { string query = @" SELECT id FROM tablea /* Comment with ' number 2 */ WHERE Name = :name ORDER BY Name"; var recognizer = new ParamLocationRecognizer(); ParameterParser.Parse(query, recognizer); ParamLocationRecognizer.NamedParameterDescription p; Assert.DoesNotThrow(() => p = recognizer.NamedParameterDescriptionMap["name"]); }
private static ParameterMetadata BuildParameterMetadata(IParameterTranslations parameterTranslations, string hql) { long start = DateTime.Now.Ticks; ParamLocationRecognizer recognizer = ParamLocationRecognizer.ParseLocations(hql); long end = DateTime.Now.Ticks; if (log.IsDebugEnabled) { log.Debug("HQL param location recognition took " + (end - start) + " mills (" + hql + ")"); } int ordinalParamCount = parameterTranslations.OrdinalParameterCount; int[] locations = recognizer.OrdinalParameterLocationList.ToArray(); if (parameterTranslations.SupportsOrdinalParameterMetadata && locations.Length != ordinalParamCount) { throw new HibernateException("ordinal parameter mismatch"); } ordinalParamCount = locations.Length; OrdinalParameterDescriptor[] ordinalParamDescriptors = new OrdinalParameterDescriptor[ordinalParamCount]; for (int i = 1; i <= ordinalParamCount; i++) { ordinalParamDescriptors[i - 1] = new OrdinalParameterDescriptor(i, parameterTranslations.SupportsOrdinalParameterMetadata ? parameterTranslations.GetOrdinalParameterExpectedType(i) : null, locations[i - 1]); } Dictionary <string, NamedParameterDescriptor> namedParamDescriptorMap = new Dictionary <string, NamedParameterDescriptor>(); foreach (KeyValuePair <string, ParamLocationRecognizer.NamedParameterDescription> entry in recognizer.NamedParameterDescriptionMap) { string name = entry.Key; ParamLocationRecognizer.NamedParameterDescription description = entry.Value; namedParamDescriptorMap[name] = new NamedParameterDescriptor(name, parameterTranslations.GetNamedParameterExpectedType(name), description.BuildPositionsArray(), description.JpaStyle); } return(new ParameterMetadata(ordinalParamDescriptors, namedParamDescriptorMap)); }
private ParameterMetadata BuildNativeSQLParameterMetadata(string sqlString) { ParamLocationRecognizer recognizer = ParamLocationRecognizer.ParseLocations(sqlString); var ordinalDescriptors = new OrdinalParameterDescriptor[recognizer.OrdinalParameterLocationList.Count]; for (int i = 0; i < recognizer.OrdinalParameterLocationList.Count; i++) { int position = recognizer.OrdinalParameterLocationList[i]; ordinalDescriptors[i] = new OrdinalParameterDescriptor(i, null); } IDictionary <string, NamedParameterDescriptor> namedParamDescriptorMap = new Dictionary <string, NamedParameterDescriptor>(); foreach (KeyValuePair <string, ParamLocationRecognizer.NamedParameterDescription> entry in recognizer.NamedParameterDescriptionMap) { string name = entry.Key; ParamLocationRecognizer.NamedParameterDescription description = entry.Value; namedParamDescriptorMap[name] = new NamedParameterDescriptor(name, null, description.JpaStyle); } return(new ParameterMetadata(ordinalDescriptors, namedParamDescriptorMap)); }
/// <summary> /// Convenience method for creating a param location recognizer and /// initiating the parse. /// </summary> /// <param name="query">The query to be parsed for parameter locations. </param> /// <returns> The generated recognizer, with journaled location info. </returns> public static ParamLocationRecognizer parseLocations(string query) { ParamLocationRecognizer recognizer = new ParamLocationRecognizer(); ParameterParser.Parse(query, recognizer); return recognizer; }