// Use this for initialization void Start () { // create a new server before connecting database var server = new CouchServer (db_host, db_port); var database = server.GetDatabase (db); // Gets entire database. Use GetDocuments("id"); for getting specific document. IEnumerable<StarInfo> stars = database.GetAllDocuments<StarInfo>(); IEnumerator<StarInfo> stars_iter = stars.GetEnumerator (); //iterates thourgh documents while (stars_iter.MoveNext()) { var star = stars_iter.Current; // Examples to reach spesific object starting from star. It is recommended that using a null check when necessary. Debug.Log ("Name: " + star.name + "\nCoordinates: " + star.coordinates[0] + "," + star.coordinates[1] + "," + star.coordinates[2] + "\nPlanets: \n"); foreach(var planet in star.planets){ Debug.Log ("\nPNAME:" + planet.name); Debug.Log ("\nPCOR:" + planet.coordinates[0] + "," + planet.coordinates[1] + "," + planet.coordinates[2]); Debug.Log ("\nPSAT:" + planet.satellites[0].name + ", "+ planet.satellites[0].type); //Such as here we need null check otherwise an exception ill be thrown because first planet does not have any facilities. //Debug.Log ("\nPSATF:" + planet.satellites[0].facilities[0].name + ", "+ planet.satellites[0].facilities[0].type); Debug.Log ("\nPSAT:" + planet.satellites[1].name + ", "+ planet.satellites[1].type); Debug.Log ("\nPSATF:" + planet.satellites[1].facilities[0].name + ", "+ planet.satellites[1].facilities[0].type); Debug.Log ("\nPOWN:" + planet.owner); foreach (var tile in planet.tiles) { Debug.Log ("\nPTILEID:" + tile.id); Debug.Log ("\nPTILET:" + tile.type); Debug.Log ("\nPTILEB:" + tile.building.id + " " + tile.building.name + " " + tile.building.level + " " + tile.building.type); } } } }
public bool UpdateTourToCouch(List <dtoTour> inpar) { try { var server = new CouchServer(host, port); var cdb = server.GetDatabase("dbsendill"); foreach (dtoTour par in inpar) { jtour jt = new jtour(); jt.id = par.id; jt.idcar = par.idcar; jt.idcustomer = par.idcustomer; jt.taddress = par.taddress; jt.tcontact = par.tcontact; jt.tdatetime = par.tdatetime; jt.tnote = par.tnote; jt.tphone = par.tphone; cdb.SaveDocument(jt); } return(true); } catch (Exception) { return(false); } }
static void Main(string[] args) { var dbName = "couch_demo"; string host = "localhost"; int port = 5984; var server = new CouchServer(host, port); if (server.HasDatabase(dbName)) { server.DeleteDatabase(dbName); } var db = server.GetDatabase(dbName); Console.WriteLine("Created database '{0}'", dbName); Car car = null; for (int i = 0; i < 10; i++) { car = new Car("Saab", "93", 170 + i); db.SaveDocument(car); } Console.WriteLine("Saved 10 Cars with 170-180 hps each."); var firstCar = db.GetAllDocuments().First(); Console.WriteLine("Here is the first of the Cars: \n\n" + firstCar); car.HorsePowers = 400; db.SaveDocument(car); Console.WriteLine("Modified last Car with id " + car.Id); var sameCar = db.GetDocument<Car>(car.Id); Console.WriteLine("Loaded last Car " + sameCar.Make + " " + sameCar.Model + " now with " + sameCar.HorsePowers + "hps."); var cars = db.GetAllDocuments<Car>(); Console.WriteLine("Loaded all Cars: " + cars.Count()); var tempView = db.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); var linqCars = tempView.LinqQuery<Car>(); var fastCars = from c in linqCars where c.HorsePowers >= 175 select c;//.Make + " " + c.Model; foreach (var fastCar in fastCars) Console.WriteLine(fastCar); db.DeleteDocument(tempView.Doc); foreach (var eachCar in cars.Where(x => x.HorsePowers > 175)) { db.DeleteDocument(eachCar); Console.WriteLine("Deleted car with id " + eachCar.Id); } // Get all cars again and see how many are left. Console.WriteLine("Cars left: " + db.GetAllDocuments<Car>().Count()); Console.Write("\r\nPress any key to close. "); Console.ReadKey(false); }
public void SetUp() { var host = ConfigurationManager.AppSettings["CouchHost"] ?? "localhost"; var port = Convert.ToInt32(ConfigurationManager.AppSettings["CouchPort"] ?? "5984"); server = new CouchServer(host, port); db = server.GetNewDatabase(DbName); }
static void Main() { //This is real username and password and must work with them CouchServer server = new CouchServer("testuser.cloudant.com", 5984, "testuser", "testpassword"); ICouchDatabase database = server.GetDatabase("dictionary"); bool isWorking = true; ICouchDocument doc = database.GetDocument("game"); while (isWorking) { Console.WriteLine("For add new word press : 1"); Console.WriteLine("For finding a translation for given word press 2"); Console.WriteLine("For list all words and their translations press 3"); Console.WriteLine("For exit press 4"); string command = Console.ReadLine(); switch (command) { case "1": { Console.WriteLine("Enter word"); string word = Console.ReadLine(); Console.WriteLine("Enter translation"); string translation = Console.ReadLine(); CreateWord(word, translation, database); } break; case "2": { Console.WriteLine("Enter word"); string word = Console.ReadLine(); GetWordTranslation(word, database); } break; case "3": { ListAllLords(database); } break; case "4": { isWorking = false; } break; default: { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Unknown Command"); Console.ResetColor(); } break; } } }
public void SetUp() { var host = ConfigurationManager.AppSettings["CouchHost"] ?? "localhost"; var port = Convert.ToInt32(ConfigurationManager.AppSettings["CouchPort"] ?? "5984"); server = new CouchServer(host, port); db = server.GetNewDatabase(DbName); }
static void Main(string[] args) { string host = "localhost"; int port = 5984; var server = new CouchServer(host, port); var db = server.GetDatabase("messages"); Console.WriteLine("Created database 'trivial'"); }
static void Main(string[] args) { string host = "localhost"; int port = 5984; var server = new CouchServer(host, port); var db = server.GetDatabase("messages"); Console.WriteLine("Created database 'trivial'"); }
public static void InsertItemToCloudant(FeedItemSP item) { CouchServer server = new CouchServer("xamfia.cloudant.com", 5984, "xamfia", "123400"); ICouchDatabase database = server.GetDatabase("docs"); //var docs = database.GetAllDocuments(); //string doc = "{'title':'test','tags':'mn,jv'}"; database.WriteDocument(ItemToJson(item), item.FeedItemId.ToString()); }
public ActionResult Index() { ViewData["Message"] = "Welcome to ASP.NET MVC!"; string host = "192.168.1.6"; int port = 5918; var server = new CouchServer(host, port); var db = server.GetDatabase("contacts"); Console.WriteLine("Created database 'contacts'"); return View(); }
public void SetUp() { var host = ConfigurationManager.AppSettings["CouchHost"] ?? "localhost"; var port = Convert.ToInt32(ConfigurationManager.AppSettings["CouchPort"] ?? "5984"); server = new CouchServer(host, port); db = server.GetNewDatabase(DbName); Car car = null; for (int i = 0; i < 10; i++) { car = new Car("Saab", "93", 170 + i); db.SaveDocument(car); } tempView = db.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); }
public void SetUp() { var host = ConfigurationManager.AppSettings["CouchHost"] ?? "localhost"; var port = Convert.ToInt32(ConfigurationManager.AppSettings["CouchPort"] ?? "5984"); server = new CouchServer(host, port); DbName = GetNewDbName(); db = server.GetNewDatabase(DbName); Car car = null; for (int i = 0; i < 10; i++) { car = new Car("Saab", "93", 170 + i); db.SaveDocument(car); } tempView = db.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); }
public void SetUp() { var host = ConfigurationManager.AppSettings["CouchHost"] ?? "localhost"; var port = Convert.ToInt32(ConfigurationManager.AppSettings["CouchPort"] ?? "5984"); var username = ConfigurationManager.AppSettings["Username"] ?? String.Empty; var password = ConfigurationManager.AppSettings["Password"] ?? String.Empty; if (username.Equals(String.Empty)) { server = new CouchServer(host, port); } else { server = new CouchServer(host, port, username, password); } DbName = GetNewDbName(); db = server.GetNewDatabase(DbName); }
// Use this for initialization void Awake () { // Singleton if (gameMaster == null) { DontDestroyOnLoad (gameObject); gameMaster = this; } else if (gameMaster != this) Destroy (gameObject); // Establish connection with the database var server = new CouchServer (db_host, db_port); database = server.GetDatabase (db); // Fetch the home planet details from the database // and create a global planet object called myPlanet // If some attribute which belongs to a star will be called, // then it is necessary that a Star object to be created. // starID should be recognized from beginning and it should be // known that which planet we are on. string starID = "star-1"; // Subject to change -> string to int Star currentStar = gameObject.AddComponent<Star>(); selectedStar = currentStar; currentStar.GetStar(database, starID); // Fetch all stars for the galaxy generation currentStar.GetAllStars(database); stars = currentStar.starDBIter; // Get planet from current selected star. Planet currentPlanet = currentStar.planets[2]; myPlanet = currentPlanet; myPlanet.initTiles(); myTiles = currentPlanet.tiles; // Where iz ma tiles? foreach (Tile tile in myTiles) { } // Start Resource Generation InvokeRepeating("UpdateResources", 0, 1); }
public bool UpdateTourToCouch(List <dtoTour> inpar) { try { var server = new CouchServer(host, port); var cdb = server.GetDatabase("dbsendill_newtours"); foreach (dtoTour par in inpar) { jcar jc = new jcar(); cdb.SaveDocument(jc); } return(true); } catch (Exception) { return(false); } }
/// <summary> /// Connects to the server and builds a list of databases. /// </summary> /// <param name="connection">The connection.</param> private void LoadServer(string connection) { try { _svr = null; _currentNode = null; buffer = null; tvMain.Nodes.Clear(); rtSource.Clear(); var parts = connection.Split(':'); _svr = CreateServer(parts); if (_svr == null) { return; } tvMain.Nodes.Clear(); var svrNode = tvMain.Nodes.Add(parts[0], parts[0]); svrNode.Tag = _svr; svrNode.ImageIndex = 5; svrNode.SelectedImageIndex = 5; foreach (var db in _svr.GetDatabaseNames()) { var node = svrNode.Nodes.Add(db, db); node.Tag = new CouchDatabase(db, _svr); node.Nodes.Add(String.Empty); node.ImageIndex = 0; node.SelectedImageIndex = 0; } toolStripStatusLabel1.Text = "Connected to " + connection; settings.Connection = connection; } catch (WebException ex) { MessageBox.Show(ex.Message, "Unable to connect", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <dtoCustomer> LoadCustomersFromCouch() { List <dtoCustomer> lcustomer = new List <dtoCustomer>(); var server = new CouchServer(host, port); var cdb = server.GetDatabase("dbsendill_newcustomers"); var tempView = cdb.NewTempView("dbsendill_newcustomerss", "dbsendill_newcustomer", "if (doc.docType && doc.docType == 'customer') emit(doc.carnumber, doc);"); var linqCustomer = tempView.LinqQuery <jcustomer>(); var qalldoc = cdb.QueryAllDocuments().View.LinqQuery <jcustomer>(); var mycustomer = from c in linqCustomer select c; foreach (var par in mycustomer) { dtoCustomer jc = new dtoCustomer(); jc.id = par.id; jc.address = par.address; jc.area = par.area; jc.areacode = par.areacode; jc.cumbaf = par.cumbaf; jc.email = par.email; jc.fax = par.fax; jc.isdel = par.isdel; jc.kt = par.kt; jc.mobile = par.mobile; jc.name = par.name; jc.number = par.number; jc.phone1 = par.phone1; jc.phone2 = par.phone2; jc.streetnr = par.streetnr; jc.svaedi = par.svaedi; jc.umbaf = par.umbaf; jc.url = par.url; lcustomer.Add(jc); } return(lcustomer); //var tempView = cdb.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); //var linqCars = tempView.LinqQuery<Car>(); }
public bool UpdateCustomersToCouch(List <dtoCustomer> inpar) { try { var server = new CouchServer(host, port); var cdb = server.GetDatabase("dbsendill_customers"); foreach (dtoCustomer par in inpar) { jcustomer jc = new jcustomer(); jc.id = par.id; jc.address = par.address; jc.area = par.area; jc.areacode = par.areacode; jc.cumbaf = par.cumbaf; jc.email = par.email; jc.fax = par.fax; jc.isdel = par.isdel; jc.kt = par.kt; jc.mobile = par.mobile; jc.name = par.name; jc.number = par.number; jc.phone1 = par.phone1; jc.phone2 = par.phone2; jc.streetnr = par.streetnr; jc.svaedi = par.svaedi; jc.umbaf = par.umbaf; jc.url = par.url; cdb.SaveDocument(jc); } return(true); } catch (Exception) { return(false); } }
public bool UpdataCarsToCouch(List <dtoCars> inpar) { try { var server = new CouchServer(host, port); var cdb = server.GetDatabase("dbsendill_newcars"); foreach (dtoCars par in inpar) { jcar jc = new jcar(); if (par.id == null) { jc.id = 9999; } else { jc.id = par.id; }; if (par.stationid == null) { jc.stationid = 9999; } else { jc.stationid = par.stationid; } if (par.carnumber == null) { jc.carnumber = "null"; } else { jc.carnumber = par.carnumber; } if (par.code == null) { jc.code = "null"; } else { jc.code = par.code; } if (par.listed == null) { jc.listed = false; } else { jc.listed = par.listed; } if (par.carname == null) { jc.carname = "null"; } else { jc.carname = par.carname; } if (par.car1 == null) { jc.car1 = false; } else { jc.car1 = par.car1; } if (par.car2 == null) { jc.car2 = false; } else { jc.car2 = par.car2; } if (par.car3 == null) { jc.car3 = false; } else { jc.car3 = par.car3; } if (par.car4 == null) { jc.car4 = false; } else { jc.car4 = par.car4; } if (par.car5 == null) { jc.car5 = false; } else { jc.car5 = par.car5; } if (par.car6 == null) { jc.car6 = false; } else { jc.car6 = par.car6; } if (par.car7 == null) { jc.car7 = false; } else { jc.car7 = par.car7; } if (par.car8 == null) { jc.car8 = false; } else { jc.car8 = par.car8; } if (par.car9 == null) { jc.car9 = false; } else { jc.car9 = par.car9; } if (par.car10 == null) { jc.car10 = false; } else { jc.car10 = par.car10; } if (par.length == null) { jc.length = 9999; } else { jc.length = par.length; } if (par.backdoorheight == null) { jc.backdoorheight = 9999; } else { jc.backdoorheight = par.backdoorheight; } if (par.backdoorlength == null) { jc.backdoorlength = 9999; } else { jc.backdoorlength = par.backdoorlength; } if (par.sidedoorheight == null) { jc.sidedoorheight = 9999; } else { jc.sidedoorheight = par.sidedoorheight; } if (par.sidedoorlength == null) { jc.sidedoorlength = 9999; } else { jc.sidedoorlength = par.sidedoorlength; } if (par.weightlimit == null) { jc.weightlimit = 9999; } else { jc.weightlimit = par.weightlimit; } if (par.liftsize == null) { jc.liftsize = 9999; } else { jc.liftsize = par.liftsize; } if (par.volume == null) { jc.volume = 9999; } else { jc.volume = par.volume; } if (par.width == null) { jc.width = 9999; } else { jc.width = par.width; } if (par.model == null) { jc.model = "null"; } else { jc.model = par.model; } if (par.maxcarry == null) { jc.maxcarry = 9999; } else { jc.maxcarry = par.maxcarry; } if (par.owner == null) { jc.owner = "null"; } else { jc.owner = par.owner; } if (par.kt == null) { jc.kt = "null"; } else { jc.kt = par.kt; } if (par.address == null) { jc.address = "null"; } else { jc.address = par.address; } if (par.town == null) { jc.town = "null"; } else { jc.town = par.town; } if (par.postcode == null) { jc.postcode = "null"; } else { jc.postcode = par.postcode; } if (par.phone == null) { jc.phone = "null"; } else { jc.phone = par.phone; } if (par.mobile == null) { jc.mobile = "null"; } else { jc.mobile = par.mobile; } if (par.driver == null) { jc.driver = "null"; } else { jc.driver = par.driver; } if (par.dkt == null) { jc.dkt = "null"; } else { jc.dkt = par.dkt; } if (par.daddress == null) { jc.daddress = "null"; } else { jc.daddress = par.daddress; } if (par.dtown == null) { jc.dtown = "null"; } else { jc.dtown = par.town; } if (par.postcode == null) { jc.postcode = "null"; } else { jc.postcode = par.postcode; } if (par.dphone == null) { jc.dphone = "null"; } else { jc.dphone = par.dphone; } if (par.dmobile == null) { jc.dmobile = "null"; } else { jc.dmobile = par.dmobile; } if (par.heightofbox == null) { jc.heightofbox = 9999; } else { jc.heightofbox = par.heightofbox; } if (par.isdel == null) { jc.isdel = false; } jc.isdel = par.isdel; if (par.size == null) { jc.size = 9999; } else { jc.size = par.size; } cdb.SaveDocument(jc); } return(true); } catch (Exception) { return(false); } }
public List <dtoCars> LoadCarsFromCouch() { List <dtoCars> lcar = new List <dtoCars>(); var server = new CouchServer(host, port); var cdb = server.GetDatabase("dbsendill_newcars"); var tempView = cdb.NewTempView("dbsendill_cars", "dbsendill_cars", "if (doc.docType && doc.docType == 'car') emit(doc.carnumber, doc);"); var linqCars = tempView.LinqQuery <jcar>(); var mycar = from c in linqCars select c; foreach (var par in mycar) { dtoCars jc = new dtoCars(); jc.id = par.id; jc.stationid = par.stationid; jc.carnumber = par.carnumber; jc.code = par.code; jc.listed = par.listed; jc.carname = par.carname; jc.car1 = par.car1; jc.car2 = par.car2; jc.car3 = par.car3; jc.car4 = par.car4; jc.car5 = par.car5; jc.car6 = par.car6; jc.car7 = par.car7; jc.car8 = par.car8; jc.car9 = par.car9; jc.car10 = par.car10; jc.length = par.length; jc.backdoorheight = par.backdoorheight; jc.backdoorlength = par.backdoorlength; jc.sidedoorheight = par.sidedoorheight; jc.sidedoorlength = par.sidedoorlength; jc.weightlimit = par.weightlimit; jc.liftsize = par.liftsize; jc.volume = par.volume; jc.width = par.width; jc.model = par.model; jc.maxcarry = par.maxcarry; jc.owner = par.owner; jc.kt = par.kt; jc.address = par.address; jc.town = par.town; jc.postcode = par.postcode; jc.phone = par.phone; jc.mobile = par.mobile; jc.driver = par.driver; jc.dkt = par.dkt; jc.daddress = par.daddress; jc.dtown = par.town; jc.postcode = par.postcode; jc.dphone = par.dphone; jc.dmobile = par.dmobile; jc.heightofbox = par.heightofbox; jc.isdel = par.isdel; jc.size = par.size; lcar.Add(jc); } return(lcar); //var tempView = cdb.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); //var linqCars = tempView.LinqQuery<Car>(); }
static void Main() { //This is real username and password and must work with them CouchServer server = new CouchServer("testuser.cloudant.com", 5984, "testuser", "testpassword"); ICouchDatabase database = server.GetDatabase("dictionary"); bool isWorking = true; ICouchDocument doc = database.GetDocument("game"); while (isWorking) { Console.WriteLine("For add new word press : 1"); Console.WriteLine("For finding a translation for given word press 2"); Console.WriteLine("For list all words and their translations press 3"); Console.WriteLine("For exit press 4"); string command = Console.ReadLine(); switch (command) { case "1": { Console.WriteLine("Enter word"); string word = Console.ReadLine(); Console.WriteLine("Enter translation"); string translation = Console.ReadLine(); CreateWord(word, translation, database); } break; case "2": { Console.WriteLine("Enter word"); string word = Console.ReadLine(); GetWordTranslation(word, database); } break; case "3": { ListAllLords(database); } break; case "4": { isWorking = false; } break; default: { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Unknown Command"); Console.ResetColor(); } break; } } }
protected static void CreateJSON () { StringBuilder json = new StringBuilder(); TempSensor t; json.AppendLine("{"); for (int i = 0; i < TempSensors.Length; i++) { t = TempSensors[i]; json.Append("\"" + t.Description +"\":\"" + t.CurrentValue + "\""); if ( i < TempSensors.Length - 1) { json.Append(","); } json.AppendLine(); } json.AppendLine("}"); TextWriter tw = new StreamWriter("temp.json", false, Encoding.UTF8); tw.WriteLine(json); tw.Close(); // und in couchDB mit Divan var cdb_server = new CouchServer(cdb_host, cdb_port); var db = cdb_server.GetDatabase(cdb_DBName); log("Created database " + cdb_DBName); for (int i = 0; i < TempSensors.Length; i++) { TemperaturClass tc = new TemperaturClass(TempSensors[i]); db.SaveDocument(tc); } log("all values written"); try { var tempView = db.NewTempView("test", "test", "if (doc.docType && doc.docType == 'TemperaturClass') emit(doc.ts.TimeStamp, doc);"); var linqCars = tempView.LinqQuery<TemperaturClass>(); var fastCars = from c in linqCars where c.ts.TimeStamp == "13.09.2015 17:09:30" select c; foreach (var fastCar in fastCars) Console.WriteLine(fastCar); } catch(Exception E) { log("Error reading from couchdb" + E.Message); } }
static void Main(string[] args) { string host = ""; int port = 5984; String username = ""; String password = ""; // Lets you see all HTTP requests made by Divan Trace.Listeners.Add(new ConsoleTraceListener()); // Trivial parse of args to get host and port switch (args.Length) { case 0: Console.WriteLine("Using " + host + ":" + port); break; case 1: Console.WriteLine("Using " + args[0] + ":5984"); host = args[0]; break; case 2: Console.WriteLine("Using " + args[0] + ":" + args[1]); host = args[0]; port = int.Parse(args[1]); break; } // Get a server instance. It only holds host, port and a string database prefix. // For non trivial usage of Divan you typically create your own subclass of CouchServer. var server = new CouchServer(host, port, username, password); /* This has issues with the windows build of couch db - something about file locking * // a little bit of cleanup * if (server.HasDatabase("trivial")) * server.DeleteDatabase("trivial"); */ // Get (creates it if needed) a CouchDB database. This call will create the db in CouchDB // if it does not exist, create a CouchDatabase instance and then send Initialize() to it // before returning it. The base class CouchDatabase also has very little state, it knows // only the server that it belongs to and its own name. var db = server.GetDatabase("trivial"); Console.WriteLine("Created database 'trivial'"); // Create and save 10 Cars with automatically allocated Ids by CouchDB. // Divan stores ICouchDocuments and there are several ways you can go: // - Create a subclass of CouchDocument (like Car is here). // - Create a class that implements ICouchDocument. // - Create a subclass of CouchJsonDocument. Car car = null; for (int i = 0; i < 10; i++) { car = new Car("Saab", "93", 170 + i); db.SaveDocument(car); } Console.WriteLine("Saved 10 Cars with 170-180 hps each."); // Load all Cars as CouchJsonDocuments and print one of them Console.WriteLine("Here is the first of the Cars: \n\n" + db.GetAllDocuments().First().ToString()); // Modify the last Car we saved... car.HorsePowers = 400; // ...and save the change. // We could also have used WriteDocument if we knew it was an existing doc db.SaveDocument(car); Console.WriteLine("Modified last Car with id " + car.Id); // Load a Car by known id (we just pick it from car), the class to instantiate is given using generics (Car) var sameCar = db.GetDocument <Car>(car.Id); Console.WriteLine("Loaded last Car " + sameCar.Make + " " + sameCar.Model + " now with " + sameCar.HorsePowers + "hps."); // Load all Cars. If we dwelve into the GetAllDocuments() method we will see that // QueryAllDocuments() gives us a CouchQuery which we can configure. We tell it to IncludeDocuments() // which means that we will get back not only ids but the actual documents too. GetResult() will perform the // HTTP request to CouchDB and return a CouchGenericViewResult which we in turn can ask to produce objects from JSON, // in this case we pick out the actual documents and instantiate them as instances of the class Car. var cars = db.GetAllDocuments <Car>(); Console.WriteLine("Loaded all Cars: " + cars.Count()); // Now try some linq var tempView = db.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); var linqCars = tempView.LinqQuery <Car>(); var fastCars = from c in linqCars where c.HorsePowers >= 175 select c; //.Make + " " + c.Model; foreach (var fastCar in fastCars) { Console.WriteLine(fastCar); } var twoCars = from c in linqCars where c.HorsePowers == 175 || c.HorsePowers == 176 select c; //.Make + " " + c.Model; foreach (var twoCar in twoCars) { Console.WriteLine(twoCar); } var hps = new int[] { 176, 177 }; var twoMoreCars = from c in linqCars where hps.Contains(c.HorsePowers) select c.Make + " " + c.Model + " with " + c.HorsePowers + "HPs"; foreach (var twoCar in twoMoreCars) { Console.WriteLine(twoCar); } // cleanup for later db.DeleteDocument(tempView.Doc); // Delete some Cars one by one. CouchDB is an MVCC database which means that for every operation that modifies a document // we need to supply not only its document id, but also the revision that we are aware of. This means that we must supply id/rev // for each document we want to delete. foreach (var eachCar in cars.Where(x => x.HorsePowers > 175)) { db.DeleteDocument(eachCar); Console.WriteLine("Deleted car with id " + eachCar.Id); } cars = db.GetAllDocuments <Car>(); // Get all cars again and see how many are left. Console.WriteLine("Cars left: " + cars.Count()); // We can actually also delete in a single bulk call using DeleteDocuments(). db.DeleteDocuments(cars.ToArray()); Console.WriteLine("Deleted the rest of the cars"); // test out the arbitrary conventions Console.WriteLine("Trying arbitrary documents"); var littleCar = new LittleCar() { docType = "car", Make = "Yugo", Model = "Hell if i know" }; littleCar = db.SaveArbitraryDocument(littleCar); Console.Write("\r\nDelete database (y/n)? "); if (Console.ReadLine().Trim().Equals("y", StringComparison.OrdinalIgnoreCase)) { // Delete the db itself db.Delete(); Console.WriteLine("Deleted database."); } Console.WriteLine("\r\nPress enter to close. "); Console.ReadLine(); }
static void Main(string[] args) { string host = ""; int port = 5984; String username = ""; String password = ""; // Lets you see all HTTP requests made by Divan Trace.Listeners.Add(new ConsoleTraceListener()); // Trivial parse of args to get host and port switch (args.Length) { case 0: Console.WriteLine("Using " + host + ":" + port); break; case 1: Console.WriteLine("Using " + args[0] + ":5984"); host = args[0]; break; case 2: Console.WriteLine("Using " + args[0] + ":" + args[1]); host = args[0]; port = int.Parse(args[1]); break; } // Get a server instance. It only holds host, port and a string database prefix. // For non trivial usage of Divan you typically create your own subclass of CouchServer. var server = new CouchServer(host, port,username,password); /* This has issues with the windows build of couch db - something about file locking // a little bit of cleanup if (server.HasDatabase("trivial")) server.DeleteDatabase("trivial"); */ // Get (creates it if needed) a CouchDB database. This call will create the db in CouchDB // if it does not exist, create a CouchDatabase instance and then send Initialize() to it // before returning it. The base class CouchDatabase also has very little state, it knows // only the server that it belongs to and its own name. var db = server.GetDatabase("trivial"); Console.WriteLine("Created database 'trivial'"); // Create and save 10 Cars with automatically allocated Ids by CouchDB. // Divan stores ICouchDocuments and there are several ways you can go: // - Create a subclass of CouchDocument (like Car is here). // - Create a class that implements ICouchDocument. // - Create a subclass of CouchJsonDocument. Car car = null; for (int i = 0; i < 10; i++) { car = new Car("Saab", "93", 170 + i); db.SaveDocument(car); } Console.WriteLine("Saved 10 Cars with 170-180 hps each."); // Load all Cars as CouchJsonDocuments and print one of them Console.WriteLine("Here is the first of the Cars: \n\n" + db.GetAllDocuments().First().ToString()); // Modify the last Car we saved... car.HorsePowers = 400; // ...and save the change. // We could also have used WriteDocument if we knew it was an existing doc db.SaveDocument(car); Console.WriteLine("Modified last Car with id " + car.Id); // Load a Car by known id (we just pick it from car), the class to instantiate is given using generics (Car) var sameCar = db.GetDocument<Car>(car.Id); Console.WriteLine("Loaded last Car " + sameCar.Make + " " + sameCar.Model + " now with " + sameCar.HorsePowers + "hps."); // Load all Cars. If we dwelve into the GetAllDocuments() method we will see that // QueryAllDocuments() gives us a CouchQuery which we can configure. We tell it to IncludeDocuments() // which means that we will get back not only ids but the actual documents too. GetResult() will perform the // HTTP request to CouchDB and return a CouchGenericViewResult which we in turn can ask to produce objects from JSON, // in this case we pick out the actual documents and instantiate them as instances of the class Car. var cars = db.GetAllDocuments<Car>(); Console.WriteLine("Loaded all Cars: " + cars.Count()); // Now try some linq var tempView = db.NewTempView("test", "test", "if (doc.docType && doc.docType == 'car') emit(doc.Hps, doc);"); var linqCars = tempView.LinqQuery<Car>(); var fastCars = from c in linqCars where c.HorsePowers >= 175 select c;//.Make + " " + c.Model; foreach (var fastCar in fastCars) Console.WriteLine(fastCar); var twoCars = from c in linqCars where c.HorsePowers == 175 || c.HorsePowers == 176 select c;//.Make + " " + c.Model; foreach (var twoCar in twoCars) Console.WriteLine(twoCar); var hps = new int[] { 176, 177 }; var twoMoreCars = from c in linqCars where hps.Contains(c.HorsePowers) select c.Make + " " + c.Model + " with " + c.HorsePowers + "HPs"; foreach (var twoCar in twoMoreCars) Console.WriteLine(twoCar); // cleanup for later db.DeleteDocument(tempView.Doc); // Delete some Cars one by one. CouchDB is an MVCC database which means that for every operation that modifies a document // we need to supply not only its document id, but also the revision that we are aware of. This means that we must supply id/rev // for each document we want to delete. foreach (var eachCar in cars.Where(x => x.HorsePowers > 175)) { db.DeleteDocument(eachCar); Console.WriteLine("Deleted car with id " + eachCar.Id); } cars = db.GetAllDocuments<Car>(); // Get all cars again and see how many are left. Console.WriteLine("Cars left: " + cars.Count()); // We can actually also delete in a single bulk call using DeleteDocuments(). db.DeleteDocuments(cars.ToArray()); Console.WriteLine("Deleted the rest of the cars"); // test out the arbitrary conventions Console.WriteLine("Trying arbitrary documents"); var littleCar = new LittleCar() { docType = "car", Make = "Yugo", Model = "Hell if i know" }; littleCar = db.SaveArbitraryDocument(littleCar); Console.Write("\r\nDelete database (y/n)? "); if (Console.ReadLine().Trim().Equals("y", StringComparison.OrdinalIgnoreCase)) { // Delete the db itself db.Delete(); Console.WriteLine("Deleted database."); } Console.WriteLine("\r\nPress enter to close. "); Console.ReadLine(); }
public CouchDB() { this.server = new CouchServer("localhost", 5984); this.db = server.GetDatabase("ticks"); this.m_random = new Random(DateTime.Now.Millisecond); }