public bool IsRestored(string connectionName) { MongoServer server = null; var connectionString = ConfigurationManager.ConnectionStrings[connectionName]?.ConnectionString; if (string.IsNullOrEmpty(connectionString)) { return(false); } try { var mongoUrl = new MongoUrl(connectionString); var mongoClient = new MongoClient(mongoUrl); server = mongoClient.GetServer(); return(server.GetDatabase(mongoUrl.DatabaseName).CollectionExists(MongoRestoreSettings.RestoredDbTokenCollection)); } catch (FormatException ex) { Log.Error("Wrong connection string format", ex, this); throw; } finally { server?.Disconnect(); } }
/// <summary> /// 导入按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnImport_Click(object sender, EventArgs e) { innerServer = MongoServer.Create(@"mongodb://localhost:28030"); innerServer.Connect(); innerDatabase = innerServer.GetDatabase("HearthStone"); innerCollection = innerDatabase.GetCollection("Card"); if (String.IsNullOrEmpty(ExcelPicker.SelectedPathOrFileName)) return; Import(); GC.Collect(); innerServer.Disconnect(); }
static void Main(string[] args) { MongoServer dbServer = MongoServer.Create(); dbServer.Connect(); MongoDatabase db = dbServer.GetDatabase("test"); var collection = db.GetCollection("items").AsQueryable(); var result = collection.FirstOrDefault(); Console.WriteLine(result); dbServer.Disconnect(); Console.ReadLine(); }
private void MarkAsRestored(MongoUrl mongoUrl) { MongoServer server = null; try { var mongoClient = new MongoClient(mongoUrl); server = mongoClient.GetServer(); server.GetDatabase(mongoUrl.DatabaseName).CreateCollection(MongoRestoreSettings.RestoredDbTokenCollection); } finally { server?.Disconnect(); } }
static void Main(string[] args) { MongoServer dbServer = MongoServer.Create(); dbServer.Connect(); MongoDatabase database = dbServer.GetDatabase("test"); foreach (var doc in database["test"].FindAll()) { Console.WriteLine(doc); } Console.ReadLine(); dbServer.Disconnect(); }
public void Run() { try { MongoDbServer = MongoServer.Create(MongoDbLocation); MongoDb = MongoDbServer.GetDatabase(MongoDbName); MongoCollection docs = MongoDb.GetCollection("docs"); docs.Save(new { Id = Guid.NewGuid(), Name = "John"}); } finally { Console.WriteLine("Finished"); MongoDbServer.Disconnect(); } }
/// <summary> /// 测试连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdTest_Click(object sender, EventArgs e) { CreateConnection(); try { MongoServer srv = MongoDbHelper.CreateMongoServer(ref ModifyConn); srv.Connect(); srv.Disconnect(); MyMessageBox.ShowMessage("Connect Test", "Connected OK."); } catch (MongoAuthenticationException ex) { //需要验证的数据服务器,没有Admin权限无法获得数据库列表 if (!SystemManager.IsUseDefaultLanguage) { MyMessageBox.ShowMessage( SystemManager.MStringResource.GetText(StringResource.TextType.Exception_AuthenticationException), SystemManager.MStringResource.GetText( StringResource.TextType.Exception_AuthenticationException_Note), ex.ToString(), true); } else { MyMessageBox.ShowMessage("MongoAuthenticationException:", "Please check UserName and Password", ex.ToString(), true); } } catch (Exception ex) { //暂时不处理任何异常,简单跳过 //无法连接的理由: //1.服务器没有启动 //2.认证模式不正确 if (!SystemManager.IsUseDefaultLanguage) { MyMessageBox.ShowMessage( SystemManager.MStringResource.GetText(StringResource.TextType.Exception_NotConnected), SystemManager.MStringResource.GetText(StringResource.TextType.Exception_NotConnected_Note), ex.ToString(), true); } else { MyMessageBox.ShowMessage("Exception", "Mongo Server may not Startup or Auth Mode is not correct", ex.ToString(), true); } } }
private void Dispose(bool disposing) { if (!this.disposed) { if (disposing) { try { if (_Server != null) { _Server.Disconnect(); } } catch { } } disposed = true; } }
public void SetData(string IdSession, string data, DateTime lastAccess) { MongoServer conn = GetConnection(); MongoCollection sessionCollection = GetSessionCollection(conn); BsonDocument insertDoc = null; SafeMode _safeMode = new SafeMode(false); string sessItems = data; var ApplicationName = "IOL"; Double timeout = this.GetTimeoutSet(); object lockId = new object(); try { if (!this.Exist(conn, IdSession, sessionCollection)) { insertDoc = new BsonDocument(); insertDoc.Add("_id", IdSession); insertDoc.Add("ApplicationName", ApplicationName); insertDoc.Add("Created", DateTime.Now.ToUniversalTime()); insertDoc.Add("Expires", DateTime.Now.AddMinutes((Double)timeout).ToUniversalTime()); insertDoc.Add("SessionItems", sessItems); var query = Query.And(Query.EQ("_id", IdSession), Query.EQ("ApplicationName", ApplicationName), Query.LT("Expires", DateTime.Now.ToUniversalTime())); sessionCollection.Remove(query, _safeMode); sessionCollection.Insert(insertDoc, _safeMode); } else { var query = Query.And(Query.EQ("_id", IdSession), Query.EQ("ApplicationName", ApplicationName)); var update = Update.Set("Expires", DateTime.Now.AddMinutes((Double)timeout).ToUniversalTime()); update.Set("SessionItems", sessItems); sessionCollection.Update(query, update, _safeMode); } } catch (Exception e) { } finally { conn.Disconnect(); } }
private void MarkAsRestored(MongoUrl mongoUrl) { MongoServer server = null; try { var mongoClient = new MongoClient(mongoUrl); #pragma warning disable CS0618 // Type or member is obsolete server = mongoClient.GetServer(); #pragma warning restore CS0618 // Type or member is obsolete server.GetDatabase(mongoUrl.DatabaseName).CreateCollection(MongoRestoreSettings.RestoredDbTokenCollection); } finally { server?.Disconnect(); } }
private static void mongoCountVerb(string verbStringRepresentation, long article, int sentence_index, int verb_index) { string connectionString = "mongodb://localhost"; string databaseName = "crawler"; string collectionName = "verbs"; MongoServer server = MongoServer.Create(connectionString); MongoDatabase database = server.GetDatabase(databaseName); MongoCollection <BsonDocument> collection = database.GetCollection <BsonDocument>(collectionName); BsonDocument seenOn = new BsonDocument().Add("article", article).Add("sentence_index", sentence_index).Add("verb_index", verb_index); QueryComplete whereQuery = Query.EQ("verb", verbStringRepresentation); UpdateBuilder updateQuery = Update.Inc("count", 1).Push("seen_on_sentence", seenOn); collection.Update(whereQuery, updateQuery, UpdateFlags.Upsert); server.Disconnect(); }
static public void Add_action(String login,String akcja,DateTime data) { var connectionString = "mongodb://localhost"; var mongoClient = new MongoClient(connectionString); MongoServer mongoServer = mongoClient.GetServer(); var database = mongoServer.GetDatabase("new_db"); var collection = database.GetCollection<BsonDocument>("Akcje"); var document = new BsonDocument { {"Login",login}, {"Działanie",akcja}, {"Data",data} }; collection.Insert(document); mongoServer.Disconnect(); }
/// <summary> /// 根据企业的设备列表获取数据的最小时间 /// </summary> /// <param name="deviceList"></param> /// <returns></returns> public DateTime getMinDate(string DeviceSN) { //创建数据库链接 MongoClient mc = new MongoClient(ConnectionManager.MongodbConectionStr); MongoServer server = mc.GetServer(); server.Connect(); //获得数据库 MongoDatabase db = server.GetDatabase("InspectDB"); MongoCollection colOdata = db.GetCollection("InspectOriginalData"); try { //插入原始监测数据 QueryDocument query = new QueryDocument(); //查询全部集合里的数据 List <InspectItemData> list = colOdata.FindAllAs <InspectItemData>().Where(x => x.DeviceSN == DeviceSN).ToList(); DateTime minDateTime = DateTime.Now; foreach (InspectItemData iid in list) { if (iid.InspectTime < minDateTime) { minDateTime = iid.InspectTime; } } return(minDateTime); } catch (Exception ex) { throw ex; } finally { //关闭数据库连接 if (server != null) { server.Disconnect(); } } }
public override Server creack(String ip, int port, String username, String password, int timeOut) { MongoServer conn = null; Server server = new Server(); try { String connectionstr = "mongodb://" + username + ":" + password + "@" + ip + ":" + port; if (password.Equals("空")) { connectionstr = "mongodb://" + ip + ":" + port; } MongoServerSettings config = MongoServerSettings.FromUrl(MongoUrl.Create(connectionstr)); //最大闲置时间 config.MaxConnectionIdleTime = TimeSpan.FromSeconds(timeOut); //最大存活时间 config.MaxConnectionLifeTime = TimeSpan.FromSeconds(timeOut); //链接时间 config.ConnectTimeout = TimeSpan.FromSeconds(timeOut); //socket超时时间 config.SocketTimeout = TimeSpan.FromSeconds(timeOut); conn = new MongoServer(config); conn.Connect(); if (conn.State.Equals(MongoServerState.Connected)) { server.isSuccess = true; server.banner = conn.BuildInfo.VersionString; } } catch (Exception e) { throw e; } finally { if (conn != null) { conn.Disconnect(); } } return(server); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Params.HasKeys()) { try { string id = Request.Params.GetValues("id")[0].ToString(); if (id == null) { lblTitle.Text = "Error no: id given!"; } else { string connectionstring = "mongodb://localhost"; MongoServer server = MongoServer.Create(connectionstring); MongoDatabase pq = server.GetDatabase("pq"); MongoCollection <BsonDocument> images = new MongoCollection <BsonDocument>(pq, new MongoCollectionSettings <BsonDocument>(pq, "images")); var q = Query.EQ("_id", new ObjectId(id)); BsonDocument image = images.FindOne(q); if (image.Contains("title")) { lblTitle.Text = image["title"].ToString(); } lblImageId.Text = image["_id"].ToString(); lblOwner.Text = image["owner"].ToString(); lblMime.Text = image["mime"].ToString(); lblSize.Text = image["size"].ToString(); string url = "http://localhost:8085/?id=" + image["_id"].ToString(); if (image["height"] > 400 || image["width"] > 400) { url += "&width=400&height=400"; } imgImage.ImageUrl = url; server.Disconnect(); } } catch (Exception ex) { lblTitle.Text = "Error no: id given!"; } } }
/// <summary> /// Creates the Schema which displays information about the connection to the user, /// and dynamically generates the driver as an assembly. /// </summary> /// <param name="cxInfo">the serialized connection properties.</param> /// <param name="assemblyToBuild">The location where the dynamically generated assembly should be created</param> /// <param name="nameSpace">The namespace of the driver class</param> /// <param name="typeName">The name of the driver class</param> /// <returns>A tree of ExplorerItem objects which is shown to the user in LinqPad's UI</returns> public override List <ExplorerItem> GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, ref string nameSpace, ref string typeName) { var props = propsSerializer.Deserialize(cxInfo.DriverData); List <Assembly> assemblies = props.AssemblyLocations.Select(LoadAssemblySafely).ToList(); //refresh the init query if (props.InitializationQuery != null) { props.InitializationQuery = LinqPadQuery.CreateFrom(props.InitializationQuery.Location); } //refresh DB collections MongoServer mongo = null; try { mongo = MongoServer.Create(props.ConnectionString); mongo.TrimDatabaseMappings(props.CollectionTypeMappings); } finally { if (mongo != null) { mongo.Disconnect(); } } var code = new[] { GenerateDynamicCode(props, assemblies, nameSpace, typeName) } .Concat(GetStaticCodeFiles()); //write inner class CustomInitQuery if (props.InitializationQuery != null) { code = code.Concat(new[] { this.GenerateCustomInitQuery(props.InitializationQuery, nameSpace) }); } BuildAssembly(props, code, assemblyToBuild, GetDriverFolder); return(BuildSchema(props, assemblies)); }
public void FixtureTearDown() { // Disconnects from Mongo if (mongoServer != null) { mongoServer.Disconnect(); mongoServer = null; } // Close mongo if (mongoProcess != null) { mongoProcess.Kill(); mongoProcess = null; } // Remove local folder Thread.Sleep(1000); Directory.Delete(mongoDir, true); }
static void Main(string[] args) { //链接字符串 string connectionString = "mongodb://localhost"; //数据库名 string databaseName = "myDatabase"; //定义Mongo服务 MongoServer server = MongoServer.Create(connectionString); //获取databaseName对应的数据库,不存在则自动创建 MongoDatabase mongoDatabase = server.GetDatabase(databaseName) as MongoDatabase; MongoCollection <BsonDocument> books = mongoDatabase.GetCollection <BsonDocument>("books"); //链接数据库 server.Connect(); try { BsonDocument book = new BsonDocument { { "author", "Ernest Hemingway" }, { "title", "For Whom the Bell Tolls" } }; books.Insert(book); var query = new QueryDocument("author", "Ernest Hemingway"); foreach (BsonDocument bookItem in books.Find(query)) { Console.WriteLine(book["author"]); } } finally { //关闭链接 server.Disconnect(); } Console.Read(); }
public Exercise CreateExerciseCollection(Exercise exercise) { var exerciseResponse = new Exercise(); if (exercise.CreatePassword == CreatePassword) { MongoServer mongo = MongoServer.Create(DbConnectionString); try { MongoDatabase database = null; if (DbLocation.Equals("Local")) { database = mongo.GetDatabase("workout"); } else { //below is for mongolab MongoCredentials mc = new MongoCredentials(DbLogin, DbPassword); database = mongo.GetDatabase(DbName, mc); //end of monglab } MongoCollection <ExerciseInternal> exercises = database.GetCollection <ExerciseInternal>("exercise"); var exerciseInternal = new ExerciseInternal(); exerciseInternal = Maps.Map(exercise); //var result = exercises.Insert(exerciseInternal); } catch (Exception ex) { //TODO: Add some logging... } finally { mongo.Disconnect(); } } return(exercise); }
private void getAllUser() { // connect to database to get user informations MongoServerSettings settings = new MongoServerSettings(); MongoServer server = new MongoServer(settings); server.Connect(); MongoDatabase db = server.GetDatabase("DigitalPriceCenter"); var users = db.GetCollection("Users"); this.userList = new List <User>(); foreach (User user in users.FindAllAs <User>()) { this.userList.Add(user); } server.Disconnect(); }
public List <Exercise> GetExerciseCollection() { var modelExercises = new List <Exercise>(); MongoServer mongo = MongoServer.Create(DbConnectionString); try { MongoDatabase database = null; if (DbLocation.Equals("Local")) { database = mongo.GetDatabase("workout"); } else { //below is for mongolab MongoCredentials mc = new MongoCredentials(DbLogin, DbPassword); database = mongo.GetDatabase(DbName, mc); //end of monglab } var exerciseCollection = database.GetCollection("exercise"); var exercises = database.GetCollection("exercise").FindAllAs <ExerciseInternal>().ToList(); foreach (var exercise in exercises) { modelExercises.Add(Maps.Map(exercise)); } } catch (Exception ex) { throw (ex); } finally { mongo.Disconnect(); } return(modelExercises); }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null || Session["user_id"] == null) { Response.Redirect("login.aspx"); } if (IsPostBack) { if (imgFileUpload.HasFile) { string connectionstring = "mongodb://localhost"; Configuration config = WebConfigurationManager.OpenWebConfiguration("~/"); MongoServer server = MongoServer.Create(connectionstring); MongoDatabase pq = server.GetDatabase("pq"); MongoCollection <BsonDocument> images = new MongoCollection <BsonDocument>(pq, new MongoCollectionSettings <BsonDocument>(pq, "images")); BsonDocument doc = new BsonDocument { { "owner", Session["user_id"].ToString() }, { "mime", imgFileUpload.PostedFile.ContentType }, { "ext", imgFileUpload.FileName.Substring(imgFileUpload.FileName.LastIndexOf(".")) }, { "size", imgFileUpload.PostedFile.ContentLength }, { "title", (String.IsNullOrWhiteSpace(txtTitle.Text) ? null : txtTitle.Text) } }; System.Drawing.Image img = System.Drawing.Image.FromStream(imgFileUpload.PostedFile.InputStream); doc.Add("height", img.Height); doc.Add("width", img.Width); images.Insert(doc); string fname = "C:\\mongo\\" + doc["_id"].ToString() + doc["ext"]; imgFileUpload.SaveAs(fname); server.Disconnect(); Response.Redirect("image.aspx?id=" + doc["_id"].ToString()); } } lblUsername.Text = Session["username"].ToString(); }
private void TestMongoConnection(MongoServer server, string database, string loggerName) { var db = server.GetDatabase(database); var collection = db.GetCollection(loggerName); // Clear out test collection collection.RemoveAll(); var logger = LogManager.GetLogger(loggerName); logger.LogException( LogLevel.Error, "Test Log Message", new Exception("Test Exception", new Exception("Inner Exception"))); Thread.Sleep(2000); collection.FindAll().Count().Should().Be(1); var logEntry = collection.FindAll().First(); Assert.IsTrue(logEntry.Contains("_id")); logEntry["level"].Should().Be(LogLevel.Error.ToString()); logEntry["message"].Should().Be("Test Log Message"); var exception = logEntry["exception"].AsBsonDocument; exception["message"].Should().Be("Test Exception"); var innerException = exception["innerException"].AsBsonDocument; innerException["message"].Should().Be("Inner Exception"); // Clean-up db.DropCollection(loggerName); server.Disconnect(); }
protected void EnsureAccessRights() { var url = new MongoUrl(this.ConnectionString); MongoClientSettings settings = MongoClientSettings.FromUrl(url); settings.DefaultCredentials = null; MongoCredentials adminCredentials = this.GetAdminCredentials(); var client = new MongoClient(settings); MongoServer server = client.GetServer(); MongoDatabase adminDatabase = server.GetDatabase(this.MongoAdministratorDatabase); MongoUser user = adminDatabase.FindUser(this.MongoAdministratorName); if (IsUserAdmin(user)) { return; } user = new MongoUser(adminCredentials, false); adminDatabase.AddUser(user); server.Disconnect(); }
public Hashtable CheckDB() { Hashtable status = new Hashtable(); GetCon(); try { con.Connect(); status["Connection :"] = "OK"; return(status); } catch (MongoException e) { status["Connection :"] = "Error"; status["Error"] = e.HResult.ToString(); status["Has occurred :"] = e.Message.ToString(); return(status); } finally { con.Disconnect(); } }
public bool create(Atributo t) { try { coll.Insert(t); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } finally { server.Disconnect(); } }
static void Main(string[] args) { var mongoServerAddress = new MongoServerAddress("127.0.0.1", 27017); var mongoServerSettings = new MongoServerSettings(); mongoServerSettings.Server = mongoServerAddress; var mongoServer = new MongoServer(mongoServerSettings); mongoServer.Connect(); IEnumerable<string> databases = mongoServer.GetDatabaseNames(); var mongoDatabase = mongoServer.GetDatabase("classfrogdb"); var classCollection = mongoDatabase.GetCollection("classes"); classCollection.RemoveAll(); var documents = classCollection.FindAll(); ClassInstance instance = new ClassInstance(); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); classCollection.Insert(instance.NewDocument()); mongoServer.Disconnect(); }
public List <InspectOriginalData> GetOriginalDatas(InspectOriginalData oData) { //创建数据库链接 MongoClient mc = new MongoClient(ConnectionManager.MongodbConectionStr); MongoServer server = mc.GetServer(); server.Connect(); //获得数据库 MongoDatabase db = server.GetDatabase("InspectDB"); MongoCollection colOdata = db.GetCollection("InspectOriginalData"); try { //插入原始监测数据 var query = new QueryDocument { }; //查询全部集合里的数据 MongoCursor <InspectOriginalData> inspectOriginalData = colOdata.FindAs <InspectOriginalData>(query); return(inspectOriginalData.ToList <InspectOriginalData>()); } catch (Exception ex) { throw ex; } finally { //关闭数据库连接 if (server != null) { server.Disconnect(); } } }
/// <summary> /// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. /// </summary> public void Dispose() { _mongoServer.Disconnect(); }
private void CleanUp() { _server.DropDatabase(DataBase); _server.Disconnect(); }
private void SetupStore(MongoServer mongoServer, string databaseName, string collectionName) { Contract.Requires<ArgumentNullException>(mongoServer != null); Contract.Requires<ArgumentNullException>(!string.IsNullOrEmpty(databaseName)); Contract.Requires<ArgumentNullException>(!string.IsNullOrEmpty(collectionName)); mongoServer.Connect(); var db = _mongoServer.GetDatabase(databaseName); var coll = db.GetCollection(collectionName); coll.EnsureIndex("Events.EventSourceId", "Events.EventSequence"); mongoServer.Disconnect(); }
private void TestMongoConnection( MongoServer server, string database, string loggerName) { var db = server.GetDatabase(database); var collection = db.GetCollection(loggerName); // Clear out test collection collection.RemoveAll(); var logger = LogManager.GetLogger(loggerName); logger.LogException( LogLevel.Error, "Test Log Message", new Exception("Test Exception", new Exception("Inner Exception"))); Thread.Sleep(2000); collection.FindAll().Count() .Should().Be(1); var logEntry = collection.FindAll().First(); logEntry["level"] .Should().Be(LogLevel.Error.ToString()); logEntry["message"] .Should().Be("Test Log Message"); var exception = logEntry["exception"].AsBsonDocument; exception["message"] .Should().Be("Test Exception"); var innerException = exception["innerException"].AsBsonDocument; innerException["message"] .Should().Be("Inner Exception"); // Clean-up db.DropCollection(loggerName); server.Disconnect(); }
static void Main() { // Create seed data BsonDocument[] seedData = CreateSeedData(); // Standard URI format: mongodb://[dbuser:dbpassword@]host:port/dbname String uri = "mongodb://*****:*****@host:port/db"; MongoUrl url = new MongoUrl(uri); MongoClient client = new MongoClient(url); MongoServer server = client.GetServer(); MongoDatabase db = server.GetDatabase(url.DatabaseName); /* * First we'll add a few songs. Nothing is required to create the * songs collection; it is created automatically when we insert. */ var songs = db.GetCollection <BsonDocument>("songs"); // Use Insert for single BsonDocument insertion. songs.InsertBatch(seedData); /* * Then we need to give Boyz II Men credit for their contribution to * the hit "One Sweet Day". */ QueryDocument updateQuery = new QueryDocument { { "Title", "One Sweet Day" } }; songs.Update(updateQuery, new UpdateDocument { { "$set", new BsonDocument("Artist", "Mariah Carey ft. Boyz II Men") } }); /* * Finally we run a query which returns all the hits that spent 10 * or more weeks at number 1. */ QueryDocument findQuery = new QueryDocument { { "WeeksAtOne", new BsonDocument { { "$gte", 10 } } } }; var cursor = songs.Find(findQuery).SetSortOrder(SortBy.Ascending("Decade")); foreach (var song in cursor) { var test = song["Decade"]; Console.WriteLine("In the {0}, {1} by {2} topped the charts for {3} straight weeks", song["Decade"], song["Title"], song["Artist"], song["WeeksAtOne"]); } // Since this is an example, we'll clean up after ourselves. songs.Drop(); // Only disconnect when your app is terminating. server.Disconnect(); }
public void Dispose() { _server.Disconnect(); }
public void Close() { Console.WriteLine("close connection"); _server.Disconnect(); }
private static bool TestConnection(MongoServer server) { bool result = false; try { server.Connect(); if (server.State == MongoServerState.Connected || server.State == MongoServerState.ConnectedToSubset) { result = true; } } finally { server.Disconnect(); } return result; }