public CouncilController(ICouncilService councilService) { _bucket = ClusterHelper.GetBucket("lawyermanagementdb"); _councilService = councilService; }
public BreweryController() : this(new BreweryRepository(ClusterHelper.GetBucket("beer-sample"))) { }
static void Main(string[] args) { Console.WriteLine("Iniciando leitura da fila..."); var couchbaseServer = "http://:8091"; ClusterHelper.Initialize(new ClientConfiguration { Servers = new List <Uri> { new Uri(couchbaseServer) } }, new PasswordAuthenticator("", "")); var _bucket = ClusterHelper.GetBucket("Coleta"); var factory = new ConnectionFactory() { HostName = "", Port = 5672, UserName = "", Password = "" }; using (var dbContext = new viajanetContext()) using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { //channel.ExchangeDeclare("exchange.name", ExchangeType.Direct); channel.QueueDeclare(queue: "coletaqueue", durable: true, exclusive: false, autoDelete: false, arguments: null); var consumer = new EventingBasicConsumer(channel); consumer.Received += (model, ea) => { var body = ea.Body; var message = Encoding.UTF8.GetString(body); var command = JsonConvert.DeserializeObject <ColetaCommand>(message); Console.WriteLine("{2} Processando requisição da página {0}, IP {1}", command.Pagina, command.IP, command.Data); // Insere no Couchbase var ret = _bucket.Insert(Guid.NewGuid().ToString(), command); // Insere no SQL Sever var coleta = new tbColeta() { Ip = command.IP, Browser = command.Browser, Pagina = command.Pagina, Parametros = command.Pagina, Data = command.Data }; dbContext.Add(coleta); dbContext.SaveChanges(); }; channel.BasicConsume(queue: "coletaqueue", autoAck: true, consumer: consumer); Console.WriteLine("Finalizado."); Console.ReadLine(); } }
static void OpenBucket() { var bucket1 = ClusterHelper.GetBucket("default"); TwoThreadsCompleted.Signal(); }
public BookingController(IBookingService bookingService) { _bucket = ClusterHelper.GetBucket("lawyermanagementdb"); _bookingService = bookingService; }
public void When_GetBucket_Is_Called_And_NotInitialized_ThrowInitializationException() { Assert.Throws <InitializationException>(() => ClusterHelper.GetBucket("default")); }
public BookingService() { _bucket = ClusterHelper.GetBucket("lawyermanagementdb"); }
public IBucket Bucket(string bucketName) { return(ClusterHelper.GetBucket(bucketName)); }
public IQueryResult <dynamic> ExecuteQuery(IQueryRequest query) { return(ClusterHelper .GetBucket(CouchbaseConfigHelper.Instance.Bucket) .Query <dynamic>(query)); }
private static IQueryResult <dynamic> ExecuteSql(string sql) { return(ClusterHelper .GetBucket("default") .Query <dynamic>(new QueryRequest(sql).Timeout(TimeSpan.FromMinutes(5)))); }
public ProfileRepository() { _bucket = ClusterHelper.GetBucket("hello-couchbase"); }
public BeerSample() : this(ClusterHelper.GetBucket("beer-sample")) { }
public ApplicationDbContext() : base(ClusterHelper.GetBucket("beer-sample")) { }
public TravelBucketRepository(string bucketName) { _bucketContext = new BucketContext(ClusterHelper.GetBucket(bucketName)); }
public TemperatureController(IOptions <CouchbaseOptions> couchbaseOptions, TemperatureHub temperatureHub) { _temperatureHub = temperatureHub; _bucket = ClusterHelper.GetBucket(couchbaseOptions.Value.CouchbaseBucket); }
public IOperationResult <dynamic> Upsert(string id, object model, string bucket) { return(ClusterHelper .GetBucket(bucket) .Upsert <dynamic>(id, model)); }
public NavigationController() { _bucket = ClusterHelper.GetBucket(ConfigurationDefaults.COUCHBASE_COLLECTIONNAME); }
public IOperationResult <dynamic> Get(string id, string bucket) { return(ClusterHelper .GetBucket(bucket) .Get <dynamic>(id)); }
public HomeController() { _bucket = ClusterHelper.GetBucket("mybucket"); }
public bool Exists(string id, string bucket) { return(ClusterHelper .GetBucket(bucket) .Exists(id)); }
public TestController() { _bucket = ClusterHelper.GetBucket("default"); }
public UserController(IUserService userService) { _bucket = ClusterHelper.GetBucket("lawyermanagementdb"); _userService = userService; }
public CouchBaseDBExtension(ExtendedActorSystem system) { if (system == null) { throw new ArgumentNullException("system"); } // Initialize fallback configuration defaults system.Settings.InjectTopLevelFallback(CouchBaseDBPersistence.DefaultConfiguration()); var HOCON_CB_JournalConfig = system.Settings.Config.GetConfig("akka.persistence.journal.couchbase"); JournalSettings = new CouchBaseJournalSettings(HOCON_CB_JournalConfig); if (JournalSettings.UseClusterHelper) { JournalCBBucket = ClusterHelper.GetBucket(JournalSettings.BucketName); JournalCBCluster = JournalCBBucket.Cluster; } else { // Instantiate the connection to the cluster JournalCBCluster = new Cluster(JournalSettings.CBClientConfiguration); //Open the bucket and make a reference to the CB Client Configuration JournalCBBucket = (CouchbaseBucket)JournalCBCluster.OpenBucket(JournalSettings.BucketName); } // Throw an exception if we reach this point without a CB Cluster, CB Config, or Bucket if (JournalCBCluster == null) { throw new Exception("CouchBase Journal Cluster could not initialized."); } // Had to do it this way since by default CB always initializes the default bucket. if (JournalCBBucket.Name != JournalSettings.BucketName) { throw new Exception("CouchBase Journal bucket could not initialized."); } // Add Journal Indexes // Add here to create Global Secondary Indexes that cover (See covering Indexes in Couchbase website) to improve performance // First check if the index exists // SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_SequenceNr' // SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId' // Create using these: // CREATE INDEX idxDocumentType_PersistenceId_SequenceNr on `SSA` (PersistenceId,SequenceNr,DocumentType) USING GSI // CREATE INDEX idxDocumentType_PersistenceId on `SSA` (DocumentType,PersistenceId) USING GSI //string N1QLQueryString = "SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_SequenceNr'"; //var result = JournalCBBucket.Query<dynamic>(N1QLQueryString); //if (result.Rows.Count == 0 && result.Success == true) //{ // N1QLQueryString = "CREATE INDEX idxDocumentType_PersistenceId_SequenceNr on `" + JournalCBBucket.Name + "` (PersistenceId,SequenceNr,DocumentType) USING GSI"; // result = JournalCBBucket.Query<dynamic>(N1QLQueryString); // //if (result.Success != true) // // Debug.Write("Could not create index:idxDocumentType_PersistenceId_SequenceNr"); //} //N1QLQueryString = "SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId"; //result = JournalCBBucket.Query<dynamic>(N1QLQueryString); //if (result.Rows.Count == 0 && result.Success == true) //{ // N1QLQueryString = "CREATE INDEX idxDocumentType_PersistenceId on `" + JournalCBBucket.Name + "` (PersistenceId,DocumentType) USING GSI"; // result = JournalCBBucket.Query<dynamic>(N1QLQueryString); // //if (result.Success != true) // // Debug.Write("Could not create index:idxDocumentType_PersistenceId"); //} var HOCON_CB_SnapshotConfig = system.Settings.Config.GetConfig("akka.persistence.snapshot-store.couchbase"); SnapShotStoreSettings = new CouchbaseSnapshotSettings(HOCON_CB_SnapshotConfig); if (SnapShotStoreSettings.UseClusterHelper) { SnapShotStoreCBBucket = ClusterHelper.GetBucket(SnapShotStoreSettings.BucketName); SnapShotStoreCBCluster = SnapShotStoreCBBucket.Cluster; } else { // Are we using the same cluster as the journal? if (SnapShotStoreSettings.CBClientConfiguration.Servers.All(JournalSettings.CBClientConfiguration.Servers.Contains)) { SnapShotStoreCBCluster = JournalCBCluster; // Since we are using the same cluster are we using the same bucket? if (SnapShotStoreSettings.BucketName == JournalSettings.BucketName) { SnapShotStoreCBBucket = JournalCBBucket; } } else // Instantiate the connection to the new cluster { SnapShotStoreCBCluster = new Cluster(SnapShotStoreSettings.CBClientConfiguration); //Open the bucket and make a reference to the CB Client Configuration SnapShotStoreCBBucket = (CouchbaseBucket)JournalCBCluster.OpenBucket(SnapShotStoreSettings.BucketName); } } // Throw an exception if we reach this point without a CB Cluster, CB Config, or Bucket if (SnapShotStoreCBCluster == null) { throw new Exception("CouchBase Snapshot Store Cluster could not initialized."); } if (SnapShotStoreCBBucket == null) { throw new Exception("CouchBase Snapshot Store bucket could not initialized."); } // Add Snapshot indexes // Add here to create Global Secondary Indexes that cover (See covering Indexes in Couchbase website) to improve performance // First check if the index exists // SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_SequenceNr' // SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_Timestamp' // SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId' // Create it if it does not // CREATE INDEX idxDocumentType_PersistenceId_SequenceNr on `SSA` (PersistenceId,SequenceNr,DocumentType) USING GSI // CREATE INDEX idxDocumentType_PersistenceId_Timestamp on `SSA` (PersistenceId,Timestamp,DocumentType) USING GSI // CREATE INDEX idxDocumentType_PersistenceId on `SSA` (DocumentType,PersistenceId) USING GSI //N1QLQueryString = "SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_SequenceNr'"; //result = SnapShotStoreCBBucket.Query<dynamic>(N1QLQueryString); //if (result.Rows.Count == 0 && result.Success == true) //{ // N1QLQueryString = "CREATE INDEX idxDocumentType_PersistenceId_SequenceNr on `" + SnapShotStoreCBBucket.Name + "` (PersistenceId,SequenceNr,DocumentType) USING GSI"; // result = SnapShotStoreCBBucket.Query<dynamic>(N1QLQueryString); // //if (result.Success != true) // // Debug.Write("Could not create index:idxDocumentType_PersistenceId_SequenceNr"); //} //N1QLQueryString = "SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_Timestamp"; //result = SnapShotStoreCBBucket.Query<dynamic>(N1QLQueryString); //if (result.Rows.Count == 0 && result.Success == true) //{ // N1QLQueryString = "CREATE INDEX idxDocumentType_PersistenceId_Timestamp on `" + SnapShotStoreCBBucket.Name + "` (PersistenceId,Timestamp,DocumentType) USING GSI"; // result = SnapShotStoreCBBucket.Query<dynamic>(N1QLQueryString); // //if (result.Success != true) // // Debug.Write("Could not create index:idxDocumentType_PersistenceId_Timestamp"); //} //N1QLQueryString = "SELECT * FROM system:indexes WHERE name = 'idxDocumentType_PersistenceId_Timestamp"; //result = SnapShotStoreCBBucket.Query<dynamic>(N1QLQueryString); //if (result.Rows.Count == 0 && result.Success == true) //{ // N1QLQueryString = "CREATE INDEX idxDocumentType_PersistenceId on `" + SnapShotStoreCBBucket.Name + "` (DocumentType,PersistenceId) USING GSI"; // result = SnapShotStoreCBBucket.Query<dynamic>(N1QLQueryString); // //if (result.Success != true) // // Debug.Write("Could not create index:idxDocumentType_PersistenceId"); //} }
static void Main(string[] args) { var _dbContext = new UserBehaviorDbContext(); var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); ClusterHelper.Initialize(new ClientConfiguration { Servers = new List <Uri> { new Uri(configuration.GetSlnConfig("CouchbaseEndpoint")) } }, new PasswordAuthenticator(configuration.GetSlnConfig("CouchbaseUserName"), configuration.GetSlnConfig("CouchbasePassword"))); var factory = new ConnectionFactory() { HostName = configuration.GetSlnConfig("RabbitMQEndpoint") }; IBucket _bucket = ClusterHelper.GetBucket("TesteViajaNetUserBehavior"); try { using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { channel.QueueDeclare(queue: "UserBehavior", durable: false, exclusive: false, autoDelete: false, arguments: null); var consumer = new EventingBasicConsumer(channel); consumer.Received += (model, ea) => { var body = ea.Body; var message = Encoding.UTF8.GetString(body); PageAccess pageAccess = JsonConvert.DeserializeObject <PageAccess>(message); pageAccess.Id = Guid.NewGuid(); pageAccess.DateCreated = DateTime.Now; _dbContext.PageAccesses.Add(pageAccess); _dbContext.SaveChanges(); _bucket.Insert <PageAccess>(pageAccess.Id.ToString(), pageAccess); }; channel.BasicConsume(queue: "UserBehavior", autoAck: true, consumer: consumer); Console.WriteLine(" Press [enter] to exit."); Console.ReadLine(); } } catch (Exception e) { Console.Write(e.Message); } finally { ClusterHelper.Close(); } }
public CouchbaseService() { this._bucket = ClusterHelper.GetBucket("music"); }
public CrudController() { bucket = ClusterHelper.GetBucket("Test"); }
public GiftsController() { _buckate = ClusterHelper.GetBucket("travel-sample"); _buckate2 = ClusterHelper.GetBucket("test"); }
public ApplicationDbContext() : base(ClusterHelper.GetBucket("default")) { }
public ProjectController() { var bucket = ClusterHelper.GetBucket(ConfigurationManager.AppSettings["CouchbaseBucket"]); _dataAccess = new ProjectDataAccess(bucket); }
public void SetUp() { ClusterHelper.Initialize(TestConfigurations.DefaultConfig()); EnsurePrimaryIndexExists(ClusterHelper.GetBucket("beer-sample")); }