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);
}
