public virtual List <Daffodil> ReadDaffodils() { var daffodils = new List <Daffodil>(); var client = this.GetClient(); var request = new SelectRequest { SelectExpression = "SELECT * FROM daffodil", }; var response = client.Select(request); var items = response.SelectResult.Item; foreach (var item in items) { var idFromDb = item.Attribute.First(x => x.Name == "Id").Value; var dataFromDb = item.Attribute.First(x => x.Name == "Data").Value; var daffodil = new Daffodil { Id = idFromDb, Data = dataFromDb, }; daffodils.Add(daffodil); } return(daffodils); }
public List <List <object> > Select(string dbName, string tableName, int top, int offset, Dictionary <string, List <IValidator> > conditions) { var url = RequestBuilder.StartBuild(_settings.Host) .AddUrl(_settings.Constants.TableController, dbName, tableName, _settings.Endpoints.Data, _settings.Endpoints.Select) .Build(); var conditionsDto = new Dictionary <string, List <Dto.Validator> >(); foreach (var item in conditions) { conditionsDto.Add(item.Key, _mapper.GetDtoValidators(item.Value)); } var selectRequest = new SelectRequest { Offset = offset, Top = top, Conditions = conditionsDto }; var data = PostRequest <List <List <object> > >(url, selectRequest); return(data); }
private static void Query(ISolrServerHandler server, string queryString = null) { if (server == null) { return; } queryString = queryString ?? TestQuery; var sbOutput = new StringBuilder(); var queryRequest = new SelectRequest(server.GetUriBuilder(), new SimpleQueryBuilder(queryString)); var query = server.Request <SelectResponse>(queryRequest); sbOutput.AppendFormat("querying for {0}, ResultCount: {1}\n", queryString, query.Documents != null ? query.Documents.NumFound : 0); if (query.Documents != null) { foreach (var doc in query.Documents) { var line = new StringBuilder(); line.AppendFormat("{0}", doc.Fields["id"]); if (doc.Fields.ContainsKey("price")) { line.AppendFormat(", {0}", doc.Fields["price"]); } if (doc.Fields.ContainsKey("name")) { line.AppendFormat(", {0}", doc.Fields["name"]); } sbOutput.AppendLine(line.ToString()); } } Console.WriteLine(sbOutput.ToString()); }
public Routes GetAllRoutes() { Routes routes = new Routes(); using (AmazonSimpleDBClient client = new AmazonSimpleDBClient(_publicKey, _secretKey)) { SelectRequest request = new SelectRequest().WithSelectExpression( string.Format("SELECT * FROM Routes ")); SelectResponse response = client.Select(request); foreach (Item item in response.SelectResult.Item) { string value = item.Attribute.GetValueByName("Id"); Route route = new Route { Id = Guid.Parse(item.Attribute.GetValueByName("Id")), Distance = item.Attribute.GetDoubleValueByName("Distance"), LastTimeRidden = item.Attribute.GetDateTimeValueByName("LastTimeRidden"), Name = item.Attribute.GetValueByName("Name"), Location = item.Attribute.GetValueByName("Location"), }; routes.Add(route); } } return(routes); }
public IQueryable <TModel> Apply <TModel, TConditionMessage>(IQueryable <TModel> queryableData, TConditionMessage conditionMessage) { var _conditionAdapter = _serviceProvider.GetRequiredService <IConditionAdapter <TConditionMessage> >(); SelectRequest _selectRequest = _conditionAdapter.Convert(conditionMessage); var _queryableData = _selectRequest.RootSelectConditionCase switch { SelectRequest.RootSelectConditionOneofCase.None => queryableData, SelectRequest.RootSelectConditionOneofCase.WhereSimple => Apply(queryableData, _selectRequest.WhereSimple), SelectRequest.RootSelectConditionOneofCase.Where => Apply(queryableData, _selectRequest.Where), _ => throw new ArgumentOutOfRangeException(nameof(_selectRequest.RootSelectConditionCase), _selectRequest.RootSelectConditionCase, "Unexpected value") }; if (_selectRequest.Lines.NotNullOrEmpty()) { _queryableData = FilterRowsByIndex(_queryableData, _selectRequest.Lines); } return(_queryableData); }
public void InitializeRequest() { #region Url string urlGetUsuario = Endpoints.URL_SERVIDOR + Endpoints.GET_USUARIO; string urlGetLikes = Endpoints.URL_SERVIDOR + Endpoints.GET_LIKES; string urlGetPublicacionesSeguidos = Endpoints.URL_SERVIDOR + Endpoints.GET_PUBLICACIONES_SEGUIDOS; string urlGetPublicacionesUsuario = Endpoints.URL_SERVIDOR + Endpoints.GET_PUBLICACIONES_USUARIO; string urlDeletePublicacion = Endpoints.URL_SERVIDOR + Endpoints.DELETE_PUBLICACIONES; #endregion Url #region API GetUsuario = new SelectRequest <UsuarioModel>(); GetUsuario.SelectStrategy("GET", urlGetUsuario); DeletePublicacion = new SelectRequest <PublicacionModel>(); DeletePublicacion.SelectStrategy("POST", urlDeletePublicacion); GetPublicacionesSeguidos = new SelectRequest <BaseModel>(); GetPublicacionesSeguidos.SelectStrategy("GET", urlGetPublicacionesSeguidos); GetPublicacionesUsuario = new SelectRequest <BaseModel>(); GetPublicacionesUsuario.SelectStrategy("GET", urlGetPublicacionesUsuario); GetLikes = new SelectRequest <BaseModel>(); GetLikes.SelectStrategy("GET", urlGetLikes); #endregion API }
/// <summary> /// Select /// </summary> /// <param name="request">Select request</param> /// <remarks> /// The Select operation returns a set of item names and associate attributes that match the /// query expression. Select operations that run longer than 5 seconds will likely time-out /// and return a time-out error response. /// </remarks> public void Select(SelectRequest request) { IDictionary <string, string> parameters = ConvertSelect(request); SDBAsyncResult result = new SDBAsyncResult(parameters, null); invoke <SelectResponse>(result); }
public string[] Fetch(string storeIdentifier, string requestIdentifier) { EnsureDomain(storeIdentifier); var response = new List <string>(); var select = string.Format("select * from `{0}` where RequestId = '{1}'", storeIdentifier, requestIdentifier); var selectRequest = new SelectRequest().WithSelectExpression(select); var selectResponse = _simpleDb.Select(selectRequest); Console.WriteLine("Fetching select: {0}", select); if (selectResponse.IsSetSelectResult()) { var selectResult = selectResponse.SelectResult; foreach (Item item in selectResult.Item) { Console.WriteLine(" Item"); if (item.IsSetName()) { Console.WriteLine(" Name: {0}", item.Name); } foreach (var attribute in item.Attribute) { if (attribute.IsSetName() && attribute.Name == "ResponseItem") { response.Add(attribute.Value); break; } } } } return(response.ToArray()); }
public override T Get(Guid id) { try { SelectRequest request = new SelectRequest(); request.SelectExpression = "select * from " + m_objectMapper.TableName + " where itemName() = '" + id + "'"; SelectResponse response = m_simpleDBClient.Select(request); if (response.IsSetSelectResult() && response.SelectResult.Item.Count == 1) { SimpleDBObjectReader <T> objectReader = new SimpleDBObjectReader <T>(response.SelectResult, m_objectMapper.SetValue); return(objectReader.First()); } else if (response.IsSetSelectResult() && response.SelectResult.Item.Count == 1) { throw new ApplicationException("Multiple rows were returned for Get with id=" + id + "."); } else { return(default(T)); } } catch (Exception excp) { logger.Error("Exception SimpleDBAssetPersistor Get(for " + typeof(T).Name + "). " + excp.Message); throw; } }
public SelectRequest Convert(TMessage message) { SelectRequest _selectRequest = new SelectRequest(); _selectRequest.MergeFrom(new CodedInputStream(((IMessage)message).ToByteArray())); return(_selectRequest); }
public IActionResult GetProductsAutoComplete(SelectRequest request) { var companies = CacheHelper.GetProducts(_cache, _ctx).AsQueryable(); var result = companies.GetSelectItems(request); return(Json(result)); }
public IEnumerable <T> Get <T>(ICondition condition = null, DataEntityListLoadOptions options = null) { SelectRequest request; if (options == null) { request = new SelectRequest(); } else if (options.PageSize > 0 && !string.IsNullOrWhiteSpace(options.OrderBy)) { request = new SelectRequest(options.PageSize, options.PageNumber, options.OrderBy, options.OrderAsc); } else if (!string.IsNullOrWhiteSpace(options.OrderBy)) { request = new SelectRequest(options.OrderBy, options.OrderAsc); } else { request = new SelectRequest(options.PageSize, options.PageNumber); } if (condition != null) { request.AddCondition(condition); } request.SetTargetType <T>(); request.SetResponseType <T>(); return(Requests.Execute <T>(request)); }
public async Task <IActionResult> PostSelect([FromBody] SelectRequest request) { string response = null; if (request.Index == null) { Response.StatusCode = 400; return(new JsonResult("Index property is missing")); } if (request.Type == RequestType.Select) { try { response = await SelectData(request.Index, request.Query, request.Page); } catch (Exception e) { Console.WriteLine(e.StackTrace); Response.StatusCode = 500; return(Content("Server error")); } } if (response == null) { Response.StatusCode = 400; return(new JsonResult("Incorrect request for this endpoint.")); } return(Content(response)); }
public async Task <ActionResult <StringResult> > Select([FromBody] SelectRequest request) { var site = await _siteRepository.GetAsync(request.SiteId); var image = await _materialImageRepository.GetAsync(request.MaterialId); var materialFilePath = PathUtils.Combine(_settingsManager.WebRootPath, image.Url); if (!FileUtils.IsFileExists(materialFilePath)) { return(this.Error("图片文件不存在,请重新选择")); } var localDirectoryPath = await _pathManager.GetUploadDirectoryPathAsync(site, UploadType.Image); var filePath = PathUtils.Combine(localDirectoryPath, _pathManager.GetUploadFileName(site, materialFilePath)); DirectoryUtils.CreateDirectoryIfNotExists(filePath); FileUtils.CopyFile(materialFilePath, filePath); var imageUrl = await _pathManager.GetVirtualUrlByPhysicalPathAsync(site, filePath); return(new StringResult { Value = imageUrl }); }
public bool Exists(string storeIdentifier, string requestIdentifier) { EnsureDomain(storeIdentifier); var count = 0; var select = string.Format("select count(*) from `{0}` where RequestId = '{1}'", storeIdentifier, requestIdentifier); var selectRequest = new SelectRequest().WithSelectExpression(select); var selectResponse = _simpleDb.Select(selectRequest); Console.WriteLine("Fetching select: {0}", select); if (selectResponse.IsSetSelectResult()) { var selectResult = selectResponse.SelectResult; foreach (Item item in selectResult.Item) { foreach (var attribute in item.Attribute) { if (attribute.IsSetName() && attribute.Name == "Count") { int.TryParse(attribute.Value, out count); break; } } } } return(count > 0); }
internal SelectResponse Select(SelectRequest request) { var marshaller = new SelectRequestMarshaller(); var unmarshaller = SelectResponseUnmarshaller.Instance; return(Invoke <SelectRequest, SelectResponse>(request, marshaller, unmarshaller)); }
public IActionResult GetSuppliers(SelectRequest request) { var companies = CacheHelper.GetCompanies(_cache, _ctx).AsQueryable(); var result = companies.GetSelectItems(request); return(Json(result)); }
public FileFilter(SelectRequest request, string RepositoryPath) { _PathToSearch = string.IsNullOrEmpty(request.Owner) ? RepositoryPath : Path.Combine(RepositoryPath, request.Owner.ToUpper()); SetFileExtensionsFilter(request.FileTypes); SetPatternFilter(request.Pattern); }
public override string GetUserNameByEmail(string email) { this.VerifyKeys(); if (!String.IsNullOrEmpty(email)) { DomainHelper.CheckForDomain(Settings.Default.AWSMembershipDomain, _simpleDBClient); SelectRequest request = new SelectRequest(); request.SelectExpression = String.Concat( "Select * from `", Settings.Default.AWSMembershipDomain, "` where Email='", email, "'" ); SelectResponse response = this._simpleDBClient.Select(request); if (response.Items.Count == 0) { return(String.Empty); } else { return(response.Items[0].Name); } } throw new ArgumentNullException("email", "The email passed in is null"); }
private SelectResponse ProcessSimpleSelectRecursive(SelectRequest pRequest, SelectResponse pResponse) { if (pResponse.SelectResult.IsSetNextToken()) { pRequest.NextToken = pResponse.SelectResult.NextToken; SelectResponse mNewResponse; try { mNewResponse = this.aSimpleDBClient.Select(pRequest); } catch (System.OutOfMemoryException) { this.SetSimpleDBClient(); mNewResponse = this.aSimpleDBClient.Select(pRequest); } mNewResponse.SelectResult.Item.AddRange(pResponse.SelectResult.Item); return(this.ProcessSimpleSelectRecursive(pRequest, mNewResponse)); } else { return(pResponse); } }
public void InitializeRequest() { #region Url string urlUpdateUsuario = Endpoints.URL_SERVIDOR + Endpoints.UPDATE_USUARIO; string urlDeleteUsuario = Endpoints.URL_SERVIDOR + Endpoints.DELETE_USUARIO; string urlCreateSeguir = Endpoints.URL_SERVIDOR + Endpoints.CREATE_SEGUIR; string urlGetSeguidos = Endpoints.URL_SERVIDOR + Endpoints.GET_SEGUIDOS; string urlGetSeguidores = Endpoints.URL_SERVIDOR + Endpoints.GET_SEGUIDORES; string urlDeleteSeguir = Endpoints.URL_SERVIDOR + Endpoints.DELETE_SEGUIR; string urlGetPublicacionesUsuario = Endpoints.URL_SERVIDOR + Endpoints.GET_PUBLICACIONES_USUARIO; #endregion Url #region API UpdateUsuario = new SelectRequest <UsuarioModel>(); UpdateUsuario.SelectStrategy("POST", urlUpdateUsuario); DeleteUsuario = new SelectRequest <BaseModel>(); DeleteUsuario.SelectStrategy("POST", urlDeleteUsuario); GetSeguidos = new SelectRequest <BaseModel>(); GetSeguidos.SelectStrategy("GET", urlGetSeguidos); GetSeguidores = new SelectRequest <BaseModel>(); GetSeguidores.SelectStrategy("GET", urlGetSeguidores); DeleteSeguir = new SelectRequest <PeticionesDosUsuariosModel>(); DeleteSeguir.SelectStrategy("POST", urlDeleteSeguir); GetPublicacionesUsuario = new SelectRequest <BaseModel>(); GetPublicacionesUsuario.SelectStrategy("GET", urlGetPublicacionesUsuario); #endregion API }
protected void Page_Load(object sender, EventArgs e) { this._domainName = String.Format(Settings.Default.SimpleDbDomainNameFormat, this.Context.User.Identity.Name); if (!this.Page.IsPostBack) { using (AmazonSimpleDBClient sdbClient = new AmazonSimpleDBClient(Amazon.RegionEndpoint.USWest2)) { DomainHelper.CheckForDomain(this._domainName, sdbClient); SelectRequest selectRequest = new SelectRequest() { SelectExpression = String.Format("select * from `{0}`", this._domainName) }; SelectResponse selectResponse = sdbClient.Select(selectRequest); List <Item> items = selectResponse.Items; List <Pet> pets = items.Select(l => new Pet { Id = l.Name, PhotoThumbUrl = l.Attributes.First(a => a.Name == "PhotoThumbUrl").Value, Name = l.Attributes.First(a => a.Name == "Name").Value, Birthdate = l.Attributes.First(a => a.Name == "Birthdate").Value, Sex = l.Attributes.First(a => a.Name == "Sex").Value, Type = l.Attributes.First(a => a.Name == "Type").Value, Breed = l.Attributes.First(a => a.Name == "Breed").Value }).ToList(); this.PetRepeater.DataSource = pets; this.PetRepeater.DataBind(); } } }
public Profiles GetProfileList() { Profiles profiles = new Profiles(); using (AmazonSimpleDBClient client = new AmazonSimpleDBClient(_publicKey, _secretKey)) { SelectRequest request = new SelectRequest { SelectExpression = "SELECT * FROM Profiles" }; SelectResponse response = client.Select(request); var list = from item in response.SelectResult.Item select new Profile() { Id = Guid.Parse(item.Attribute.GetValueByName("Id")), Description = item.Attribute.GetValueByName("Description"), Location = item.Attribute.GetValueByName("Location"), Name = item.Attribute.GetValueByName("Name") }; foreach (Profile profile in list) { profiles.Add(profile); } } return(profiles); }
/// <summary> /// The <code>Select</code> operation returns a set of attributes for <code>ItemNames</code> /// that match the select expression. <code>Select</code> is similar to the standard SQL /// SELECT statement. /// /// /// <para> /// The total size of the response cannot exceed 1 MB in total size. Amazon SimpleDB /// automatically adjusts the number of items returned per page to enforce this limit. /// For example, if the client asks to retrieve 2500 items, but each individual item is /// 10 kB in size, the system returns 100 items and an appropriate <code>NextToken</code> /// so the client can access the next page of results. /// </para> /// /// <para> /// For information on how to construct select expressions, see Using Select to Create /// Amazon SimpleDB Queries in the Developer Guide. /// </para> /// </summary> /// <param name="request">Container for the necessary parameters to execute the Select service method.</param> /// /// <returns>The response from the Select service method, as returned by SimpleDB.</returns> /// <exception cref="Amazon.SimpleDB.Model.InvalidNextTokenException"> /// The specified NextToken is not valid. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.InvalidNumberPredicatesException"> /// Too many predicates exist in the query expression. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.InvalidNumberValueTestsException"> /// Too many predicates exist in the query expression. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.InvalidParameterValueException"> /// The value for a parameter is invalid. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.InvalidQueryExpressionException"> /// The specified query expression syntax is not valid. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.MissingParameterException"> /// The request must contain the specified missing parameter. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.NoSuchDomainException"> /// The specified domain does not exist. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.RequestTimeoutException"> /// A timeout occurred when attempting to query the specified domain with specified query /// expression. /// </exception> /// <exception cref="Amazon.SimpleDB.Model.TooManyRequestedAttributesException"> /// Too many attributes requested. /// </exception> public virtual SelectResponse Select(SelectRequest request) { var marshaller = SelectRequestMarshaller.Instance; var unmarshaller = SelectResponseUnmarshaller.Instance; return(Invoke <SelectRequest, SelectResponse>(request, marshaller, unmarshaller)); }
/// <summary> /// Query items based on query expression. Consistent read is by default set to false to ensure performance /// </summary> public async Task <IEnumerable <SdbItem> > QueryItemsAsync(string query, bool consistentRead = false) { try { var selectRequest = new SelectRequest() { SelectExpression = query, ConsistentRead = consistentRead }; var response = await _client.SelectAsync(selectRequest); if (response.HttpStatusCode != HttpStatusCode.OK) { return(new List <SdbItem>()); } return(!response.Items.Any() ? new List <SdbItem>() : SimpleDbHelper.ConvertSimpleDbItemsToMetaStoreItems(response.Items)); } catch (AmazonSimpleDBException e) { Console.WriteLine(e.StackTrace); throw; } }
/// <summary> /// Initiates the asynchronous execution of the Select operation. /// <seealso cref="Amazon.SimpleDB.IAmazonSimpleDB.Select"/> /// </summary> /// /// <param name="request">Container for the necessary parameters to execute the Select operation.</param> /// <param name="cancellationToken"> /// A cancellation token that can be used by other objects or threads to receive notice of cancellation. /// </param> /// <returns>The task object representing the asynchronous operation.</returns> public Task <SelectResponse> SelectAsync(SelectRequest request, CancellationToken cancellationToken = default(CancellationToken)) { var marshaller = new SelectRequestMarshaller(); var unmarshaller = SelectResponseUnmarshaller.GetInstance(); return(Invoke <IRequest, SelectRequest, SelectResponse>(request, marshaller, unmarshaller, signer, cancellationToken)); }
// ======================================== // method // ======================================== public static ICommand RequestSelect(this IEditor editor, SelectKind value, bool deselectOthers) { var req = new SelectRequest(); req.DeselectOthers = deselectOthers; req.Value = value; return(editor.PerformRequest(req)); }
/// <summary> /// Initiates the asynchronous execution of the Select operation. /// </summary> /// /// <param name="request">Container for the necessary parameters to execute the Select operation.</param> /// <param name="cancellationToken"> /// A cancellation token that can be used by other objects or threads to receive notice of cancellation. /// </param> /// <returns>The task object representing the asynchronous operation.</returns> public virtual Task <SelectResponse> SelectAsync(SelectRequest request, System.Threading.CancellationToken cancellationToken = default(CancellationToken)) { var marshaller = SelectRequestMarshaller.Instance; var unmarshaller = SelectResponseUnmarshaller.Instance; return(InvokeAsync <SelectRequest, SelectResponse>(request, marshaller, unmarshaller, cancellationToken)); }
//private bool _isImeOn; // ======================================== // constructor // ======================================== internal MemoEditorScenario(IHandle handle) : base(handle) { Contract.Requires(handle is IEditorHandle); _selectRequest = new SelectRequest(); _rubberbandRequest = new RubberbandRequest(); //_isImeOn = false; }
public async Task <List <Member> > GetMembers() { _logger.LogWarning($"Getting members at : {DateTime.Now.ToString("HH:mm:ss.000")}"); var members = new List <Member>(); var client = GetClient(); SelectRequest request = new SelectRequest(); request.SelectExpression = $"SELECT * FROM {Domain} WHERE ItemName() LIKE '{IdPrefix}:%' AND Name > '' ORDER BY Name"; SelectResponse response = await client.SelectAsync(request); foreach (var item in response.Items) { var member = new Member(); member.DbKey = item.Name; foreach (var attribute in item.Attributes) { switch (attribute.Name) { case "Name": member.Name = attribute.Value; break; case "MembershipNumber": member.MembershipNumber = Convert.ToInt32(attribute.Value); break; case "Admin": member.Admin = attribute.Value == "0" ? false : true; break; case "LastPaid": member.LastPaid = DateTime.Parse(attribute.Value); break; case "Enabled": member.Enabled = attribute.Value == "0" ? false : true; break; case "Pin": member.Pin = Convert.ToInt32(attribute.Value); break; default: break; } } members.Add(member); } return(members); }