Exemplo n.º 1
0
 public void Adds_New_Record()
 {
     // How many to start with?
       int initialCount = _Clients.Count();
       var newClient = new Client() { FirstName = "John", LastName = "Atten", Email = "*****@*****.**" };
       _Clients.Add(newClient);
       int idToFind = newClient.ClientId;
       _Clients = new PGList<Client>(connectionStringName: _connectionStringName, tableName: "clients", primaryKeyName: "client_id");
       var found = _Clients.FirstOrDefault(c => c.ClientId == idToFind);
       Assert.True(found.Email == "*****@*****.**" && _Clients.Count > initialCount);
 }
 public void Adds_New_Record()
 {
     int initialCount = _MismatchedClients.Count;
       var newMonkey = new MismatchedClient() {
     Last = "Jimbo",
     First = "Jones",
     EmailAddress = "*****@*****.**"
       };
       _MismatchedClients.Add(newMonkey);
       int newID = newMonkey.Id;
       _MismatchedClients = new PGList<MismatchedClient>(_connectionStringName, "wtf");
       var found = _MismatchedClients.FirstOrDefault(c => c.Id == newID);
       Assert.True(found.Id == newID && _MismatchedClients.Count > initialCount);
 }
Exemplo n.º 3
0
        public void Adds_New_Record()
        {
            int initialCount = _clients.Count;
              var newMonkey = new Client() {
            LastName = "Jimbo",
            FirstName = "Jones",
            Email = "*****@*****.**"
              };
              _clients.Add(newMonkey);
              int newID = newMonkey.ClientId;

              // Reload from scratch to be sure:
              _clients = new PGList<Client>(_connectionStringName, "wtf");
              var found = _clients.FirstOrDefault(c => c.ClientId == newID);
              Assert.True(found.ClientId == newID && _clients.Count > initialCount);
        }
Exemplo n.º 4
0
        public static void Run()
        {
            var sw = new Stopwatch();

            Console.WriteLine("Loading up films From Postgres Store");
            sw.Start();
            //use the dvds db
            var films = new PGList <Film>("dvds", "film", "film_id");

            sw.Stop();
            Console.WriteLine("Loaded {0} records in {1}ms", films.Count(), sw.ElapsedMilliseconds);

            sw.Reset();
            sw.Start();
            Console.WriteLine("Querying Middle 100 Documents");
            var found = films.Where(x => x.Film_ID > 10 && x.Film_ID < 500);

            sw.Stop();
            Console.WriteLine("Queried {0} records in {1}ms", found.Count(), sw.ElapsedMilliseconds);
        }
Exemplo n.º 5
0
 public LIstCRUD()
 {
     actors = new PGList <Actor>("dvds", "actor", "actor_id");
 }
Exemplo n.º 6
0
        public static void Run()
        {
            var sw = new Stopwatch();
              Console.WriteLine("===========================================================");
              Console.WriteLine("POSTGRES - SOME FANCY QUERYING");
              Console.WriteLine("===========================================================");

              Console.WriteLine("Loading up Artists from Chinook...");
              sw.Start();
              var _artists = new PGList<Artist>(_connectionStringName, "artist");

              sw.Stop();
              Console.WriteLine("\tLoaded {0} Artist records in {1} ms", _artists.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Loading up Albums from Chinook...");
              sw.Reset();
              sw.Start();
              var _albums = new PGList<Album>(_connectionStringName, "album");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} Albums in {1} ms", _artists.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Loading up tracks from Chinook...");
              sw.Reset();
              sw.Start();
              var _tracks = new PGList<Track>(_connectionStringName, "track");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} Tracks in {1} ms", _tracks.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Grab the record for AC/DC...");
              sw.Reset();
              sw.Start();
              var acdc = _artists.FirstOrDefault(a => a.Name == "AC/DC");
              sw.Stop();
              Console.WriteLine("\tFound AC/DC from memory in {0} ms", sw.ElapsedMilliseconds);

              Console.WriteLine("Find all the albums by AC/DC ...");
              sw.Reset();
              sw.Start();
              var acdcAlbums = _albums.Where(a => a.ArtistId == acdc.ArtistId);
              sw.Stop();
              Console.WriteLine("\tFound All {0} AC/DC albums from memory in {1} ms", acdcAlbums.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Find all the Tracks from Albums by AC/DC ...");
              sw.Reset();
              sw.Start();
              var acdcTracks = from t in _tracks
                       join a in acdcAlbums on t.AlbumId equals a.AlbumId
                       select t;
              sw.Stop();
              Console.WriteLine("\tFound All {0} tracks by ACDC using in-memory JOIN in {1} ms:", acdcTracks.Count(), sw.ElapsedMilliseconds);
              foreach (var track in acdcTracks)
              {
            Console.WriteLine("\t-{0}", track.Name);
              }
              Console.WriteLine(Environment.NewLine);
              Console.WriteLine("===========================================================");
              Console.WriteLine("POSTGRES - BASIC CRUD OPERATIONS");
              Console.WriteLine("===========================================================");

              sw.Reset();
              Console.WriteLine("Loading up customers from Chinook...");
              sw.Start();
              var customers = new PGList<Customer>(_connectionStringName, "customer");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} records in {1}ms", customers.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("INSERTING a NEW Customer into Chinook...");
              var newCustomer = new Customer() { LastName = "Atten", FirstName = "John", Email = "*****@*****.**" };
              sw.Start();
              customers.Add(newCustomer);
              sw.Stop();
              Console.WriteLine("\tWrote 1 record for a new count of {0} records in {1} ms", customers.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("UPDATING the new Customer record in Chinook...");
              newCustomer.FirstName = "Fred";
              sw.Start();
              customers.Update(newCustomer);
              sw.Stop();
              Console.WriteLine("\tUpdated 1 record for a new count of {0} records in {1} ms", customers.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("DELETE the new Customer record in Chinook...");
              sw.Start();
              customers.Remove(newCustomer);
              sw.Stop();
              Console.WriteLine("\tDeleted 1 record for a new count of {0} records in {1} ms", customers.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine(Environment.NewLine);
              Console.WriteLine("===========================================================");
              Console.WriteLine("POSTGRES - BULK INSERTS AND DELETIONS");
              Console.WriteLine("===========================================================");

              Console.WriteLine("Creating Test Table...");
              Benchmarks.SetUpClientTable();

              sw.Reset();
              int INSERT_QTY = 10000;
              Console.WriteLine("BULK INSERTING  {0} client records in Chinook...", INSERT_QTY);
              var _clients = new PGList<Client>(_connectionStringName, "clients");

              var inserts = new List<Client>();
              for (int i = 0; i < INSERT_QTY; i++)
              {
            inserts.Add(new Client() { LastName = string.Format("Atten {0}", i.ToString()), FirstName = "John", Email = "*****@*****.**" });
              }
              sw.Start();
              var inserted = _clients.AddRange(inserts);
              sw.Stop();
              Console.WriteLine("\tInserted {0} records in {1} ms", inserted, sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("Loading up Bulk inserted CLients from Chinook...");
              sw.Start();
              _clients = new PGList<Client>(_connectionStringName, "clients");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} records in {1}ms", _clients.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("DELETING added records from Chinook...");
              var toRemove = _clients.Where(x => x.Email == "*****@*****.**");
              sw.Start();
              int removed = _clients.RemoveSet(toRemove);
              sw.Stop();
              Console.WriteLine("\tDeleted {0} records in {1}ms", removed, sw.ElapsedMilliseconds);
        }
Exemplo n.º 7
0
 public FullText()
 {
     films = new PGList <Film>("dvds", "film", "film_id");
 }
 public PGList_Attribute_Mapping()
 {
     // Set up a table with mangled column names:
       this.SetUpWTFTable();
       _MismatchedClients = new PGList<MismatchedClient>(_connectionStringName, "wtf");
 }
 public void Updates_Record()
 {
     var newMonkey = new MismatchedClient() {
     Last = "Jones",
     First = "Davey",
     EmailAddress = "*****@*****.**"
       };
       _MismatchedClients.Add(newMonkey);
       int currentCount = _MismatchedClients.Count;
       int newID = newMonkey.Id;
       _MismatchedClients = new PGList<MismatchedClient>(_connectionStringName, "wtf");
       var found = _MismatchedClients.FirstOrDefault(c => c.Id == newID);
       found.First = "Mick";
       _MismatchedClients.Update(found);
       Assert.True(found.Id == newID && _MismatchedClients.Count == currentCount);
 }
Exemplo n.º 10
0
 public PGList_Column_Mapping()
 {
     // Set up a table with mangled column names:
       this.SetUpWTFTable();
       _clients = new PGList<Client>(_connectionStringName, "wtf");
 }
Exemplo n.º 11
0
        public void Updates_Record()
        {
            var newMonkey = new Client() {
            LastName = "Jones",
            FirstName = "Davey",
            Email = "*****@*****.**"
              };
              _clients.Add(newMonkey);
              int currentCount = _clients.Count;
              int newID = newMonkey.ClientId;

              // Reload from scratch to be sure:
              _clients = new PGList<Client>(_connectionStringName, "wtf");
              var found = _clients.FirstOrDefault(c => c.ClientId == newID);
              found.FirstName = "Mick";
              _clients.Update(found);
              Assert.True(found.ClientId == newID && _clients.Count == currentCount);
        }
Exemplo n.º 12
0
 // Runs before every test:
 public PGList_CRUD()
 {
     // Drops and re-creates table each time:
       this.SetUpClientTable();
       _Clients = new PGList<Client>(connectionStringName: _connectionStringName, tableName: "clients", primaryKeyName: "client_id");
 }
Exemplo n.º 13
0
 public PGFullText()
 {
     films = new PGList<Film>("chinookPG", "film");
 }