public IHttpActionResult Sendotp(string id) { Otp model = new Otp(); try { model.MobileOtp = sendOtp.GenerateOtp(); var userDocument = _bucket.Query <object>(@"SELECT mobileNo,emailId From ICADB where id= '" + id + "'").ToList(); if (userDocument.Count == 0) { return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "175-please enter valid emiratid"), new JsonMediaTypeFormatter())); } else { JObject jsonObj = JObject.Parse(userDocument[0].ToString()); //string mobileNo = (string)jsonObj["mobileNo"]; model.Email = (string)jsonObj["emailId"];; model.MobileNo = (string)jsonObj["mobileNo"]; model.MobileOtp = model.MobileOtp; mobileSMS.SendOtpViaMobile(model.MobileNo, model.MobileOtp, model.Email); return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Add, model.Email), new JsonMediaTypeFormatter())); } } catch (Exception ex) { return(Content(HttpStatusCode.Forbidden, MessageResponse.Message(HttpStatusCode.Forbidden.ToString(), ex.Message), new JsonMediaTypeFormatter())); } }
public void Test_QueryNoDeadlock() { // Using an asynchronous HttpClient request within an MVC Web API action may cause // a deadlock when we wait for the result synchronously. var context = new Mock<SynchronizationContext> { CallBase = true }; SynchronizationContext.SetSynchronizationContext(context.Object); try { _bucket.Query<dynamic>("SELECT * FROM `beer-sample` LIMIT 10"); // If view queries are incorrectly awaiting on the current SynchronizationContext // We will see calls to Post or Send on the mock context.Verify(m => m.Post(It.IsAny<SendOrPostCallback>(), It.IsAny<object>()), Times.Never); context.Verify(m => m.Send(It.IsAny<SendOrPostCallback>(), It.IsAny<object>()), Times.Never); } finally { SynchronizationContext.SetSynchronizationContext(null); } }
public int GetCountOfAllSessions() { var n1ql = @"SELECT VALUE COUNT(*) FROM `" + _bucket.Name + "`"; var query = QueryRequest.Create(n1ql); return(_bucket.Query <int>(query).Rows.First()); }
public List <dynamic> GetTaskById(string taskId) { var queryStr = @"SELECT p._id AS projectId, (SELECT _id, (SELECT a.* FROM `" + _bucket.Name + @"` a USE KEYS c.assignedTo)[0] AS assignedTo, createdON, description, (select t.log, t.createdAt, (SELECT u.* FROM `" + _bucket.Name + @"` u USE KEYS t.`user`)[0] AS `user` FROM `" + _bucket.Name + @"` r UNNEST r.history t WHERE r._id = $1) AS history, name, (SELECT o.*FROM `" + _bucket.Name + @"` o USE KEYS c.owner)[0] as owner, (SELECT u.* FROM `" + _bucket.Name + @"` u USE KEYS c.users) AS users, permalink FROM `" + _bucket.Name + @"` c WHERE c._id= $1)[0] AS task FROM `" + _bucket.Name + @"` p WHERE ANY x IN tasks SATISFIES x = $1 END "; var query = QueryRequest.Create(queryStr); query.ScanConsistency(ScanConsistency.RequestPlus); query.AddPositionalParameter(taskId); var queryResult = _bucket.Query <dynamic>(query); return(ExtractResultOrThrow(queryResult)); }
public IEnumerable <Type> ExecQueryReturnList(IQueryRequest queryRequest) { var result = _bucket.Query <Type>(queryRequest); if (result.Errors.Count > 0) { throw new Exception(result.Errors[0].Message); } return(result.Rows); }
public IHttpActionResult GetCommonMasters(string name) { //string query = @"SELECT Contents." + name + " From " + _bucket.Name + " as cmt where meta().id='REF_EN_US'"; string query = @"SELECT r.* FROM APTCREF AS d USE KEYS[""REF_EN_US""] UNNEST d.['"+ name + "'] AS r"; var CommonMasterDocument = _bucket.Query<object>(query).ToList(); return Content(HttpStatusCode.OK, CommonMasterDocument); }
public ActionResult GetByIp(string ip) { var n1ql = $"SELECT *, META().id FROM {ConfigurationDefaults.COUCHBASE_COLLECTIONNAME} WHERE Ip = $ip"; var query = QueryRequest.Create(n1ql); query.AddNamedParameter("$ip", ip); query.ScanConsistency(ScanConsistency.RequestPlus); var result = _bucket.Query <object>(query); return(new JsonResult(result)); }
public void Execute_Query() { const string statement = "SELECT \"hello\" as greeting;"; var query = new AnalyticsRequest(statement); var result = _bucket.Query <TestRequest>(query); Assert.IsTrue(result.Success); Assert.AreEqual("hello", result.Rows.First().Greeting); }
public List <Company> GetCompanyById(string companyId) { var queryStr = "SELECT companies.* FROM `" + _bucket.Name + @"` AS companies WHERE _type = 'Company' AND META(companies).id = $1"; var query = QueryRequest.Create(queryStr); query.ScanConsistency(ScanConsistency.RequestPlus); query.AddPositionalParameter(companyId); var queryResult = _bucket.Query <Company>(query); return(ExtractResultOrThrow(queryResult)); }
public List <User> GetUserById(string userId) { var queryStr = @"SELECT users.* FROM `" + _bucket.Name + @"` AS users WHERE _type = 'User' AND META(users).id = $1"; var query = QueryRequest.Create(queryStr); query.ScanConsistency(ScanConsistency.RequestPlus); query.AddPositionalParameter(userId); var queryResult = _bucket.Query <User>(query); return(ExtractResultOrThrow(queryResult)); }
public IActionResult GetAll() { //var n1ql = @" select g.*, META(g).Id // from demo g where g.type='wishlistItem';"; var n1ql = @" SELECT id,country,name,type FROM `travel-sample`;"; var query = QueryRequest.Create(n1ql); query.ScanConsistency(ScanConsistency.RequestPlus); var result = _buckate.Query <WishlistItem>(query); return(Ok(result.Rows)); }
/// <summary> /// Lists the indexes for the current <see cref="IBucket" />. /// </summary> /// <returns></returns> public virtual IndexResult ListN1qlIndexes() { var request = new QueryRequest(string.Format(Statements.ListIndexes, BucketName)); var result = _bucket.Query <IndexInfo>(request); return(new IndexResult { Value = result.Rows, Exception = result.Exception, Message = result.Message, Success = result.Success }); }
public IActionResult Login(string email, string pass) { var n1ql = "SELECT t.* FROM todoBucket t WHERE t.email = $email AND t.pass = $pass "; var query = QueryRequest.Create(n1ql); query.AddNamedParameter("$email", email).AddNamedParameter("$pass", pass); var result = _bucket.Query <User>(query).FirstOrDefault(); if (result == null) { return(BadRequest()); } return(Ok(result)); }
/// <summary> /// Execute a <see cref="LinqQueryRequest"/>. /// </summary> /// <typeparam name="T">Type returned by the query.</typeparam> /// <param name="queryRequest">Request to execute.</param> /// <returns>List of objects returned by the request.</returns> public IEnumerable <T> ExecuteCollection <T>(LinqQueryRequest queryRequest) { if (!queryRequest.ScalarResultBehavior.ResultExtractionRequired) { var result = _bucket.Query <T>(queryRequest); return(ParseResult(result)); } else { var result = _bucket.Query <ScalarResult <T> >(queryRequest); return(queryRequest.ScalarResultBehavior.ApplyResultExtraction(ParseResult(result))); } }
public void GetAllCouncils() { var n1ql = @"SELECT c.*, META(c).id FROM lawyermanagementdb c WHERE c.type = 'Council';"; var query = QueryRequest.Create(n1ql); query.ScanConsistency(ScanConsistency.RequestPlus); var result = _bucket.Query <Council>(query); foreach (Council council in result) { _councils.Add(council); } }
public void GetAllBookings() { var n1ql = @"SELECT b.*, META(b).id FROM lawyermanagementdb b WHERE b.type = 'Booking';"; var query = QueryRequest.Create(n1ql); query.ScanConsistency(ScanConsistency.RequestPlus); var result = _bucket.Query <Booking>(query); foreach (Booking booking in result) { _bookings.Add(booking); } }
public IHttpActionResult GetDepartments() { try { string Query = @"SELECT * From " + _bucket.Name + " as APTCREF where meta().id='Departments'"; var userDocument = _bucket.Query <object>(Query).ToList(); JObject jsonObj = JObject.Parse(userDocument[0].ToString()); JObject jsonDept = JObject.Parse(jsonObj["APTCREF"]["Dept"].ToString()); return(Content(HttpStatusCode.OK, ((System.Collections.Generic.IDictionary <string, Newtonsoft.Json.Linq.JToken>)jsonDept).Keys)); } catch (Exception ex) { return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter())); } }
// tag::GetTenLatestUpdates[] public List <Update> GetTenLatestUpdates() { var n1ql = @"SELECT up.body, up.postedDate, { 'id': META(u).id, u.name} AS `user` FROM `sqltocb` up JOIN `sqltocb` u ON KEYS up.`user` WHERE up.type = 'Update' ORDER BY STR_TO_MILLIS(up.postedDate) DESC LIMIT 10;"; var query = QueryRequest.Create(n1ql); query.ScanConsistency(ScanConsistency.RequestPlus); var result = _bucket.Query <Update>(query); return(result.Rows); }
public IHttpActionResult GetLogin(string id) { try { var userDocument = _bucket.Query <object>(@"SELECT loginDetails From " + _bucket.Name + " where email= '" + id + "'").ToList(); if (userDocument.Count == 0) { return(Content(HttpStatusCode.NoContent, "176-plaese enter valid user id.")); } else { JObject jsonObj = JObject.Parse(userDocument[0].ToString()); Login login = new Login(); login.UserId = id; login.Password = jsonObj["loginDetails"]["password"].ToString(); login.Type = (string)jsonObj["loginDetails"]["type"].ToString(); login.LoginStatus = (bool)jsonObj["loginDetails"]["loginStatus"]; JObject jsonmobRoleObj = JObject.Parse(jsonObj["loginDetails"]["userRole"].ToString()); //Department userDepartment = new Department(); //userDepartment.DepartmentName = jsonmobRoleObj["userRoleName"].ToString(); //login.Department= mod; return(Content(HttpStatusCode.OK, login)); } } catch (Exception ex) { return(Content(HttpStatusCode.Forbidden, ex.Message)); } }
/* Função para demonstrar o uso do */ static void MapReduce() { Console.WriteLine("Map/Reduce"); Console.WriteLine(""); ClientConfiguration config = new ClientConfiguration() { Servers = new List <Uri>() { new Uri("http://localhost:8091") } }; config.SetAuthenticator(new PasswordAuthenticator("test", "123456")); using (Cluster cluster = new Cluster(config)) using (IBucket bucket = cluster.OpenBucket("viajanet")) { IViewQuery query = new ViewQuery().From("clients", "clientCountNavigation").GroupLevel(2); IViewResult <dynamic> clientNavigation = bucket.Query <dynamic>(query); string userToken = ""; foreach (var client in clientNavigation.Rows) { if (client.Key[0] != userToken) { Console.WriteLine("Client {0}", client.Key[0]); userToken = client.Key[0]; } Console.WriteLine(" Function: {0} -> Count: {1}", client.Key[1], client.Value); } } }
public IActionResult SearchAddress(string address = "") { if (!string.IsNullOrEmpty(address)) { var query = new SearchQuery { Index = "fts_index", Query = new MatchQuery(address) } .Limit(10); var result = bucket.Query(query); List <Landmark> landmarks = new List <Landmark>(); ISearchQueryResult searchQueryRows = result; foreach (var item in searchQueryRows) { var landmark = bucket.GetDocument <Landmark>(item.Id).Document.Content; landmarks.Add(landmark); } return(View(landmarks)); } else { List <Landmark> landmarks = new List <Landmark>(); return(View(landmarks)); } }
public string PostNotification(PostNotificationParameters objPostNotificationParameters) { strnotificationDescription = @"SELECT NM.notificationText, NM.notificationType, NM.notificationDescription FROM " + _bucketRef.Name + " r use keys 'NotificationTypeMaster' " + "unnest r.['notificationTypeMaster'] NM where NM.['roleCode'] = '" + objPostNotificationParameters.RoleCode + "' " + "and NM.['deptCode'] = '" + objPostNotificationParameters.DeptCode + "' and NM.notificationType = " + objPostNotificationParameters.NotificationType + ""; var notificationDescriptionDocument = _bucket.Query <NotificationMessage>(strnotificationDescription).FirstOrDefault(); if (notificationDescriptionDocument != null) { string notificationText = string.Empty; switch (notificationDescriptionDocument.NotificationType) { case (int)AspectEnums.NotificationType.IndividualCreation: notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Status); break; case (int)AspectEnums.NotificationType.VehicleRegistration: notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status); break; case (int)AspectEnums.NotificationType.PermitRequest: notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status); break; case (int)AspectEnums.NotificationType.CompanyRegistration: notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status); break; case (int)AspectEnums.NotificationType.FineRequest: notificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.Value, objPostNotificationParameters.Status); break; } var NotificationDoc = new Document <Notification>() { Id = "notification_" + DateTime.Now.Ticks.ToString(), Content = new Notification { NotificationDescription = notificationDescriptionDocument.NotificationDescription, NotificationType = objPostNotificationParameters.NotificationType, RoleCode = objPostNotificationParameters.RoleCode, DeptCode = objPostNotificationParameters.DeptCode, UserCode = objPostNotificationParameters.UserCode, //NotificationText = string.Format(notificationDescriptionDocument.NotificationText, objPostNotificationParameters.KeyID, objPostNotificationParameters.RegistrationNumnber, objPostNotificationParameters.Status), NotificationText = notificationText, NotificationCreatedDate = DateTime.Now.ToString(), ReadReceipt = false, Validity = 24, }, }; var NotificationResult = _bucket.Insert(NotificationDoc); } else { return("notification not configured for Dept Code " + objPostNotificationParameters.DeptCode + " and Role Code " + objPostNotificationParameters.RoleCode + ""); } return("notification has been created"); }
// For testing purposes only!!! public void ClearBucket() { var n1ql = $"delete from `{_bucket.Name}`"; var query = QueryRequest.Create(n1ql); _bucket.Query <dynamic>(query); }
public void Submitting_View_Query_To_Ephemeral_Bucket_Fails() { var viewQuery = _bucket.CreateQuery("designDoc", "viewName"); var result = _bucket.Query <dynamic>(viewQuery); Assert.IsFalse(result.Success); Assert.AreEqual(result.Error, ExceptionUtil.EphemeralBucketViewQueries); }
public void GetEvents(string actorName, int eventIndexStart, Action <object> callback) { var q = $"SELECT b.* FROM `{_bucket.Name}` b WHERE b.actorName='{actorName}' AND b.eventIndex>={eventIndexStart} AND b.type='event' ORDER BY b.eventIndex ASC"; var req = QueryRequest.Create(q); req.ScanConsistency(ScanConsistency.RequestPlus); var res = _bucket.Query <Envelope>(req); ThrowOnError(res); var envelopes = res.Rows; foreach (var envelope in envelopes) { callback(envelope.Event); } }
private void ProcessFlightRequest(string incomingMessage, string id) { // expecting messages that contain "{flight} from {airport} to {airport2}" var matches = Regex.Matches(incomingMessage, "from (\\w+) to (\\w+)"); if (matches.Count < 1) { SendTextMessage("Sorry, I can't help you with those flights.", id); return; } if (matches[0].Groups.Count != 3) { SendTextMessage("Sorry, I can't help you with those flights.", id); return; } // uppercase the matches var sourceairport = matches[0].Groups[1].Value.ToUpper(); var destinationairport = matches[0].Groups[2].Value.ToUpper(); var dayOfTheWeek = (int)DateTime.Now.DayOfWeek; var n1ql = @"SELECT VALUE COUNT(*) FROM ( select r.sourceairport, r.destinationairport, a.name, s.flight, s.utc from `travel-sample` r unnest r.schedule s inner join `travel-sample` a ON KEYS r.airlineid where r.type = 'route' and r.sourceairport = $sourceairport and r.destinationairport = $destinationairport and s.day = $dayOfTheWeek order by s.utc ) flights;"; var query = QueryRequest.Create(n1ql); query.AddNamedParameter("sourceairport", sourceairport); query.AddNamedParameter("destinationairport", destinationairport); query.AddNamedParameter("dayOfTheWeek", dayOfTheWeek); var result = _bucket.Query <int>(query); var count = result.Rows.First(); var resultMessage = $"There are {count} flights from {sourceairport} to {destinationairport} on {DateTime.Now.DayOfWeek.ToString()}"; SendTextMessage(resultMessage, id); }
// end::SaveShoppingCart[] public ShoppingCart GetCartByUserName(string userName) { var n1ql = $"SELECT c.* FROM `{_bucket.Name}` c WHERE c.userName = $UserName LIMIT 1"; var query = QueryRequest.Create(n1ql); query.ScanConsistency(ScanConsistency.RequestPlus); query.AddNamedParameter("UserName", userName); return(_bucket.Query <ShoppingCart>(query).Rows.FirstOrDefault()); }
public ActionResult N1qlExample() { var query = QueryRequest.Create("SELECT b.foo, b.bar FROM `" + _bucket.Name + "` b"); query.ScanConsistency(ScanConsistency.RequestPlus); var results = _bucket.Query <FooBar>(query).Rows; return(View(results)); }
public IList <DataTracking> Get(string ip, string pageName) { var queryRequest = new QueryRequest() .Statement("SELECT ip, pageName, browser, pageParameters FROM `ViajaNet` Where ip = $ip and pageName = $pageName") .AddNamedParameter("$ip", ip) .AddNamedParameter("$pageName", pageName); return(_bucket.Query <DataTracking>(queryRequest)?.Rows); }
public void Cleanup() { Console.WriteLine("Delete all users..."); var result = _bucket.Query <dynamic>("DELETE FROM `sqltocb` WHERE type='User';"); if (!result.Success) { Console.WriteLine($"{result.Exception?.Message}"); Console.WriteLine($"{result.Message}"); } Console.WriteLine("Delete all updates..."); result = _bucket.Query <dynamic>("DELETE FROM `sqltocb` WHERE type='Update';"); if (!result.Success) { Console.WriteLine($"{result.Exception?.Message}"); Console.WriteLine($"{result.Message}"); } }
static void BasicQuery(IBucket bucket) { var query = bucket.CreateQuery("beer", "brewery_beers"). Limit(5); var result = bucket.Query<dynamic>(query); foreach (var row in result.Rows) { Console.WriteLine(row); } }