示例#1
0
        /// <summary>
        /// Query the registration system for records
        /// </summary>
        public VersionedDomainIdentifier[] QueryRecord(IComponent queryParameters)
        {
            if (m_disposed)
            {
                throw new ObjectDisposedException("DatabasePersistenceService");
            }

            // TODO: Store consent policy override if applicable
            List <VersionedDomainIdentifier> retVal = new List <VersionedDomainIdentifier>(30);

            ISystemConfigurationService configService = this.Context.GetService(typeof(ISystemConfigurationService)) as ISystemConfigurationService;

            // Get the subject of the query
            var queryFilter = (queryParameters as HealthServiceRecordContainer).FindComponent(HealthServiceRecordSiteRoleType.FilterOf) as QueryParameters;

            // Query Filter
            if (queryFilter == null || queryFilter.MatchingAlgorithm == MatchAlgorithm.Unspecified)
            {
                queryFilter = new QueryParameters()
                {
                    MatchStrength     = DatabasePersistenceService.ValidationSettings.DefaultMatchStrength,
                    MatchingAlgorithm = DatabasePersistenceService.ValidationSettings.DefaultMatchAlgorithms
                }
            }
            ;

            // Subject of the query
            QueryEvent queryEvent = queryParameters as QueryEvent;

            // Connect to the database
            IDbConnection conn = m_configuration.ReadonlyConnectionManager.GetConnection();

            try
            {
                using (IDbCommand cmd = conn.CreateCommand())
                {
                    var    subject           = queryEvent.FindComponent(HealthServiceRecordSiteRoleType.SubjectOf);
                    string queryFilterString = String.Format("{0}", DbUtil.BuildQueryFilter(subject, this.Context, queryFilter.MatchingAlgorithm == MatchAlgorithm.Exact));
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = queryFilterString;

#if DEBUG
                    Trace.TraceInformation(cmd.CommandText);
#endif
                    try
                    {
                        using (IDataReader rdr = cmd.ExecuteReader())
                        {
                            // Read all results
                            while (rdr.Read())
                            {
                                // Id
                                var id = new VersionedResultIdentifier()
                                {
                                    Domain     = GetQueryPersister(subject.GetType()).ComponentTypeOid,
                                    Identifier = Convert.ToString(rdr[0]),
                                    Version    = Convert.ToString(rdr[1])
                                };
                                // Add the ID
                                retVal.Add(id);
                                if (retVal.Count % 30 == 29)
                                {
                                    retVal.Capacity += 30;
                                }
                            }
                        }
                    }
                    catch
                    {
                        Trace.TraceInformation("Query in error: {0}", queryFilterString);
                        throw;
                    }
                }
            }
            catch (Exception e)
            {
                throw new DataException("Query error : " + e.Message, e);
            }
            finally
            {
                m_configuration.ConnectionManager.ReleaseConnection(conn);
            }

            //retVal.Sort((a, b) => b.Identifier.CompareTo(a.Identifier));
#if DEBUG
            Trace.TraceInformation("{0} records returned by function", retVal.Count);
#endif
            return(retVal.ToArray());
        }