static Database() { mongodb = MongoDB.Driver.MongoServer.Create( string.Format("mongodb://127.0.0.1:{0}/?safe=true;connectTimeoutMS=10000", StationRegistry.GetValue("dbPort", 10319))); // TODO: Remove Hard code wammer = mongodb.GetDatabase("wammer"); }
static void Main(string[] args) { var sw = new System.Diagnostics.Stopwatch(); sw.Start(); var settings = new MongoDB.Driver.MongoServerSettings(); var address = new MongoDB.Driver.MongoServerAddress(Properties.Settings.Default.Server, Properties.Settings.Default.Port); settings.Server = address; MongoDB.Driver.MongoServer server = new MongoDB.Driver.MongoServer(settings); var client = new MongoDB.Driver.MongoClient(); MongoDatabase database = server.GetDatabase("mc2db"); Console.WriteLine("Aloitetaan..."); var now = MC2DateTimeValue.Now().ToLocalTime(); var nowStr = string.Format("{0:0000}-{1:00}-{2:00}-{3:00}-{4:00}-{5:00}", now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); var logFile = Path.Combine(string.Format("{0}_{1}.txt", Properties.Settings.Default.ExcelPath + "\\Log", nowStr)); if (!Directory.Exists(Path.GetDirectoryName(logFile))) { Directory.CreateDirectory(Path.GetDirectoryName(logFile)); } var x = new PayrollExport(logFile, database); x.ExportDocuments(); Console.WriteLine("Valmis...aikaa kului {0} minuuttia", sw.Elapsed.TotalMinutes); }
} // End Sub CreateIndex // Following example show how to save file and read back from gridfs(using official mongodb driver): // http://www.mongovue.com/ public void Test() { MongoDB.Driver.MongoServer server = MongoServer.Create("mongodb://localhost:27020"); MongoDB.Driver.MongoDatabase database = server.GetDatabase("tesdb"); string fileName = "D:\\Untitled.png"; string newFileName = "D:\\new_Untitled.png"; using (System.IO.FileStream fs = new System.IO.FileStream(fileName, System.IO.FileMode.Open)) { MongoDB.Driver.GridFS.MongoGridFSFileInfo gridFsInfo = database.GridFS.Upload(fs, fileName); BsonValue fileId = gridFsInfo.Id; ObjectId oid = new ObjectId(fileId.AsByteArray); MongoDB.Driver.GridFS.MongoGridFSFileInfo file = database.GridFS.FindOne(Query.EQ("_id", oid)); using (System.IO.Stream stream = file.OpenRead()) { byte[] bytes = new byte[stream.Length]; stream.Read(bytes, 0, (int)stream.Length); using (System.IO.FileStream newFs = new System.IO.FileStream(newFileName, System.IO.FileMode.Create)) { newFs.Write(bytes, 0, bytes.Length); } // End Using newFs } // End Using stream } // End using fs } // End Sub Test
/// <summary> /// Dispose(bool disposing) executes in two distinct scenarios. /// If disposing equals true, the method has been called directly /// or indirectly by a user's code. Managed and unmanaged resources /// can be disposed. /// If disposing equals false, the method has been called by the /// runtime from inside the finalizer and you should not reference /// other objects. Only unmanaged resources can be disposed. /// </summary> protected virtual void Dispose(bool disposing) { // Check to see if Dispose has already been called. if (!this._disposed) { // Note disposing has been done. _disposed = true; // If disposing equals true, dispose all managed // and unmanaged resources. if (disposing) { if (_server != null) { try { // Disconnect from the server. _server.Disconnect(); } catch { } } } // Call the appropriate methods to clean up // unmanaged resources here. _server = null; _client = null; _serverAddress = null; _clientSettings = null; } }
public ActionResult JsonAction2() { var mongoServSettings = new MongoDB.Driver.MongoServerSettings(); mongoServSettings.Server = new MongoDB.Driver.MongoServerAddress("localhost"); var mongoServer = new MongoDB.Driver.MongoServer(mongoServSettings); mongoServer.Connect(); var db = mongoServer.GetDatabase("monitera"); var collection = db.GetCollection<db>("dbo.post"); //collection.Insert(new db { gender = "m"}); var pozitif = Query<db>.Where(f => f.sentimentid == 1); var notr = Query<db>.Where(f => f.sentimentid == 2); var negatif = Query<db>.Where(f => f.sentimentid == 3); var poznotr = Query<db>.Where(f => f.sentimentid == 4); var negnotr = Query<db>.Where(f => f.sentimentid == 5); var poz = collection.Count(pozitif); var no = collection.Count(notr); var ne = collection.Count(negatif); var pn = collection.Count(poznotr); var nn = collection.Count(negnotr); var oranlar = (new[]{ new{ Durum = "Pozitif", value = poz }, new { Durum = "Nötr", value = no }, new { Durum = "Negatif", value = ne }, new { Durum = "Pozitif - Nötr", value = pn }, new { Durum = "Negatif - Nötr", value = nn } } ); return Json(oranlar, JsonRequestBehavior.AllowGet); }
static MongoDBCurrentInfoMgr() { ip = ConfigHelper.GetConfig("mongodbserverIP"); port = int.Parse(ConfigHelper.GetConfig("mongodbserverPort")); MongoDB.Driver.MongoConnectionSettings setting = new MongoDB.Driver.MongoConnectionSettings(); setting.Address = new MongoDB.Driver.MongoServerAddress(ip, port); setting.DatabaseName = dbName; mongo = new MongoDB.Driver.MongoServer(setting); }
/// <summary> Mongo服务器 </summary> /// <returns></returns> private MongoDatabase Server() { var server = new MongoServer(new MongoServerSettings { Servers = Contains.Config.Mongo.Servers.Select(t => new MongoServerAddress(t.Host, t.Port)), Credentials = Contains.Config.Mongo.Credentials.Select( t => MongoCredential.CreateCredential(t.DataBase, t.User, t.Pwd)) }); return server.GetDatabase(_database); }
/// <summary> Mongo服务器 </summary> /// <returns></returns> private MongoDatabase Server() { var server = new MongoServer(new MongoServerSettings { Servers = Contains.Config.Mongo.Servers.Select(t => new MongoServerAddress(t.Host, t.Port)), Credentials = Contains.Config.Mongo.Credentials.Select( t => MongoCredential.CreateCredential(t.DataBase, t.User, t.Pwd)) }); return(server.GetDatabase(_database)); }
protected void btnGetConnlections_Click(object sender, EventArgs e) { BsonDocument docFind = new BsonDocument(); MongoDB.Driver.MongoServer server = MongoDB.Driver.MongoServer.Create(ConfigurationManager.AppSettings["mongoDBConfig"]); server.Connect(); //获取指定数据库 MongoDB.Driver.MongoDatabase db = server.GetDatabase(ConfigurationManager.AppSettings["mongoDBName"].ToString()); string collection = txtCollection.Text.Trim(); //获取表 MongoDB.Driver.MongoCollection <BsonDocument> col = db.GetCollection <BsonDocument>(collection); lblCollections.Text = "表大小:" + col.GetTotalDataSize() / (1024 * 1024) + "M";//db['119004logs'].totalIndexSize()+db['119004logs'].dataSize() this.listBoxCollections.DataSource = col.Database.GetCollectionNames(); listBoxCollections.DataBind(); lblDataBaseCount.Text = "数据库大小为:" + db.GetStats().StorageSize / (1024 * 1024) + "M"; }
protected void btnGetIndex_Click(object sender, EventArgs e) { BsonDocument docFind = new BsonDocument(); MongoDB.Driver.MongoServer server = MongoDB.Driver.MongoServer.Create(ConfigurationManager.AppSettings["mongoDBConfig"]); server.Connect(); //获取指定数据库 MongoDB.Driver.MongoDatabase db = server.GetDatabase(ConfigurationManager.AppSettings["mongoDBName"].ToString()); string collection = txtCollection.Text.Trim(); //获取表 MongoDB.Driver.MongoCollection <BsonDocument> col = db.GetCollection <BsonDocument>(collection); GetIndexesResult indexsResult = col.GetIndexes(); string strIndexs = string.Empty; for (int i = 0; i < indexsResult.Count; i++) { strIndexs += indexsResult[i].Key.ToString() + ";"; } txtGetIndexs.Text = strIndexs; }
public ActionResult JsonAction() { var mongoServSettings = new MongoDB.Driver.MongoServerSettings(); mongoServSettings.Server = new MongoDB.Driver.MongoServerAddress("localhost"); var mongoServer = new MongoDB.Driver.MongoServer(mongoServSettings); mongoServer.Connect(); var db = mongoServer.GetDatabase("monitera"); var collection = db.GetCollection<db>("dbo.post"); //collection.Insert(new db { gender = "m"}); var erkek = Query<db>.Where( f => f.gender == "e"); var kadin = Query<db>.Where( f => f.gender == "k"); var erk = collection.Count(erkek); var k = collection.Count(kadin); var chartData = (new[]{ new{ Gender = "Male", value = erk }, new { Gender = "Female", value = k } } ); return Json(chartData, JsonRequestBehavior.AllowGet); }
public ActionResult JsonAction3() { var mongoServSettings = new MongoDB.Driver.MongoServerSettings(); mongoServSettings.Server = new MongoDB.Driver.MongoServerAddress("localhost"); var mongoServer = new MongoDB.Driver.MongoServer(mongoServSettings); mongoServer.Connect(); var db = mongoServer.GetDatabase("monitera"); var collection = db.GetCollection<db>("dbo.post"); //collection.Insert(new db { gender = "m"}); var cs = Query<db>.Where(f => f.sourceid == 1); var cs1 = Query<db>.Where(f => f.sourceid == 2); var cs2 = Query<db>.Where(f => f.sourceid == 25); var cs3 = Query<db>.Where(f => f.sourceid == 31); var cs4 = Query<db>.Where(f => f.sourceid== 19); var tw = collection.Count(cs); var ff = collection.Count(cs1); var face = collection.Count(cs2); var rss = collection.Count(cs3); var blog = collection.Count(cs4); var kaynaklar = (new[]{ new{ Kaynak = "Twitter", value = tw }, new { Kaynak = "FriendFeed", value = ff }, new { Kaynak = "Facebook", value = face }, new { Kaynak = "HaberRss", value = rss }, new { Kaynak = "Blog", value = blog } } ); return Json(kaynaklar, JsonRequestBehavior.AllowGet); }
public MongoServer GetServer() { var serverSettings = MongoServerSettings.FromClientSettings(_settings); return(MongoServer.Create(serverSettings)); }
public MongoCursorConnectionProvider(MongoServer server, ReadPreference readPreference) { _server = server; _readPreference = readPreference; }
public override void ActivateOptions() { try { var mongoConnectionString = new StringBuilder(string.Format("Server={0}:{1}", Host, Port)); if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(Password)) { // use MongoDB authentication mongoConnectionString.AppendFormat(";Username={0};Password={1}", UserName, Password); } connection = MongoServer.Create(mongoConnectionString.ToString()); connection.Connect(); var db = connection.GetDatabase(DatabaseName); collection = db.GetCollection(CollectionName); } catch (Exception e) { ErrorHandler.Error("Exception while initializing MongoDB Appender", e, ErrorCode.GenericFailure); } }
public static void MyClassInitialize(TestContext testContext) { mongodb = MongoDB.Driver.MongoServer.Create("mongodb://localhost:10319/?safe=true"); }
public MongoDatabase(MongoServer server, string name, MongoDatabaseSettings settings) : this(server, name, settings, new DefaultLegacyOperationExecutor()) { }
public static MongoServer GetServer(this MongoClient client) { var serverSettings = MongoServerSettings.FromClientSettings(client.Settings); return(MongoServer.Create(serverSettings, client.OperationExecutor)); }
// constructors public RequestStartResult(MongoServer server) { _server = server; }
public MongoDatabase(MongoServer server, MongoDatabaseSettings settings) : this(server, settings.DatabaseName, settings) { }
public MongoDatabase(string _IPAddress, string _DatabaseName) { m_Client = new MongoDB.Driver.MongoClient("mongodb://" + _IPAddress); m_Server = m_Client.GetServer(); m_Database = m_Server.GetDatabase(_DatabaseName); }