tests/Performance/PerformanceTests.cs

   1 //
   2 // PerformanceTests.cs
   3 //
   4 // Author:
   5 //   Gabriel Burt <gburt@novell.com>
   6 //
   7 // Copyright (C) 2009 Novell, Inc.
   8 //
   9 // Permission is hereby granted, free of charge, to any person obtaining
  10 // a copy of this software and associated documentation files (the
  11 // "Software"), to deal in the Software without restriction, including
  12 // without limitation the rights to use, copy, modify, merge, publish,
  13 // distribute, sublicense, and/or sell copies of the Software, and to
  14 // permit persons to whom the Software is furnished to do so, subject to
  15 // the following conditions:
  16 //
  17 // The above copyright notice and this permission notice shall be
  18 // included in all copies or substantial portions of the Software.
  19 //
  20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  21 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  22 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  23 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  24 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  25 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  26 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  27 //
  28
  29 using System;
  30 using System.Threading;
  31 using NUnit.Framework;
  32
  33 using Hyena;
  34 using Hyena.Data;
  35 using Hyena.Data.Sqlite;
  36 using Hyena.Query;
  37 using Hyena.CommandLine;
  38
  39 using Banshee.Base;
  40 using Banshee.Collection;
  41 using Banshee.Collection.Database;
  42 using Banshee.Query;
  43 using Banshee.ServiceStack;
  44
  45 namespace Banshee.Tests
  46 {
  47     [TestFixture]
  48     public class PerformanceTests
  49     {
  50         const int NUM = 50;
  51         private string select_single_command;
  52
  53 #region Reload tests
  54
  55         private void ReloadMusicLibrary (string filter)
  56         {
  57             ReloadMusicLibrary (filter, 1.0);
  58         }
  59
  60         private void ReloadMusicLibrary (string filter, double runFactor)
  61         {
  62             music_library.FilterQuery = filter;
  63             for (int i = 0; i < NUM*runFactor; i++) {
  64                 music_library.Reload ();
  65             }
  66         }
  67
  68         [Test]
  69         [Category ("Performance")]
  70         public void Reload ()
  71         {
  72             ReloadMusicLibrary ("", .25);
  73         }
  74
  75         [Test]
  76         [Category ("Performance")]
  77         public void ReloadD ()
  78         {
  79             ReloadMusicLibrary ("d", .25);
  80         }
  81
  82         [Test]
  83         [Category ("Performance")]
  84         public void ReloadDave ()
  85         {
  86             ReloadMusicLibrary ("dave");
  87         }
  88
  89         [Test]
  90         [Category ("Performance")]
  91         public void ReloadByDave ()
  92         {
  93             ReloadMusicLibrary ("by:dave");
  94         }
  95
  96         [Test]
  97         [Category ("Performance")]
  98         public void ReloadFavorites ()
  99         {
 100             ReloadMusicLibrary ("rating>3");
 101         }
 102
 103         [Test]
 104         [Category ("Performance")]
 105         public void ReloadGenreRock ()
 106         {
 107             ReloadMusicLibrary ("genre:rock");
 108         }
 109
 110 #endregion
 111
 112 #region Access tests
 113
 114         [Test]
 115         [Category ("Performance")]
 116         public void ScrollLinear ()
 117         {
 118             music_library.FilterQuery = "";
 119             int count = Math.Min (2500, music_library.FilteredCount);
 120             bool any_null = false;
 121
 122             for (int i = 0; i < 6; i++) {
 123                 for (int j = 0; j < count; j++) {
 124                     any_null |= music_library.TrackModel [j] == null;
 125                 }
 126                 music_library.DatabaseTrackModel.InvalidateCache (false);
 127             }
 128
 129             Assert.IsFalse (any_null);
 130         }
 131
 132         [Test]
 133         [Category ("Performance")]
 134         public void FetchTrack ()
 135         {
 136             var track = music_library.TrackModel[0] as DatabaseTrackInfo;
 137             int track_id = track.TrackId;
 138             var cmd = new HyenaSqliteCommand (select_single_command, track_id);
 139             var db = ServiceManager.DbConnection;
 140
 141             for (int i = 0; i < NUM * 30; i++) {
 142                 using (IDataReader reader = db.Query (cmd)) {
 143                     if (reader.Read ()) {
 144                     }
 145                 }
 146             }
 147         }
 148
 149         [Test]
 150         [Category ("Too")]
 151         public void LoadTrack ()
 152         {
 153             var track = music_library.TrackModel[0] as DatabaseTrackInfo;
 154             var provider = DatabaseTrackInfo.Provider;
 155             int track_id = track.TrackId;
 156             var cmd = new HyenaSqliteCommand (select_single_command, track_id);
 157             var db = ServiceManager.DbConnection;
 158             IDataReader reader = db.Query (cmd);
 159             Assert.IsTrue (reader.Read ());
 160
 161             for (int i = 0; i < NUM*1000; i++) {
 162                 provider.Load (reader, track);
 163             }
 164
 165             reader.Dispose ();
 166         }
 167
 168         private void Select<T> (T val)
 169         {
 170             T res = default(T);
 171             var cmd = new HyenaSqliteCommand ("SELECT ?", val);
 172             Log.DebugFormat ("Select<T> cmd is {0}", cmd.Text);
 173             var db = ServiceManager.DbConnection;
 174
 175             for (int i = 0; i < NUM * 250; i++) {
 176                 res = db.Query<T> (cmd);
 177             }
 178             Assert.AreEqual (val, res);
 179         }
 180
 181         [Test]
 182         [Category ("Performance")]
 183         public void SelectStrings ()
 184         {
 185             Select ("Foo bar");
 186         }
 187
 188         [Test]
 189         [Category ("Performance")]
 190         public void SelectInt ()
 191         {
 192             Select ((int)42);
 193         }
 194
 195         [Test]
 196         [Category ("Performance")]
 197         public void SelectLong ()
 198         {
 199             Select ((long)42);
 200         }
 201
 202         [Test]
 203         [Category ("Performance")]
 204         public void SelectDateTime ()
 205         {
 206             Select (new DateTime (1999, 2, 3));
 207         }
 208
 209         [Test]
 210         [Category ("Performance")]
 211         public void SelectBool ()
 212         {
 213             Select (true);
 214         }
 215
 216 #endregion
 217
 218 #region Sort tests
 219
 220         private void SortMusicLibrary (QueryField field)
 221         {
 222             SortableColumn column = new SortableColumn (field);
 223             music_library.FilterQuery = "";
 224
 225             for (int i = 0; i < NUM/2; i++) {
 226                 music_library.DatabaseTrackModel.Sort (column);
 227                 music_library.Reload ();
 228             }
 229         }
 230
 231         [Test]
 232         [Category ("Performance")]
 233         public void SortTrack ()
 234         {
 235             SortMusicLibrary (BansheeQuery.TrackNumberField);
 236         }
 237
 238         [Test]
 239         [Category ("Performance")]
 240         public void SortArtist ()
 241         {
 242             SortMusicLibrary (BansheeQuery.ArtistField);
 243         }
 244
 245         [Test]
 246         [Category ("Performance")]
 247         public void SortRating ()
 248         {
 249             SortMusicLibrary (BansheeQuery.RatingField);
 250         }
 251
 252         [Test]
 253         [Category ("Performance")]
 254         public void SortLastPlayed ()
 255         {
 256             SortMusicLibrary (BansheeQuery.LastPlayedField);
 257         }
 258
 259 #endregion
 260
 261 #region Helpers
 262
 263         private Thread main_thread;
 264         private HeadlessClient client;
 265         private Banshee.Library.MusicLibrarySource music_library;
 266
 267         [TestFixtureSetUp]
 268         public void Setup ()
 269         {
 270             ApplicationContext.CommandLine = new CommandLineParser (new string [] {
 271                 "--uninstalled",
 272                 Environment.GetEnvironmentVariable ("BANSHEE_DEV_OPTIONS") }, 0);
 273             Log.Debugging = false;
 274             Paths.ApplicationName = Application.InternalName;
 275
 276             Application.TimeoutHandler = RunTimeout;
 277             Application.IdleHandler = RunIdle;
 278             Application.IdleTimeoutRemoveHandler = IdleTimeoutRemove;
 279             Application.Initialize ();
 280
 281             client = new HeadlessClient ();
 282             main_thread = new Thread (RunBanshee);
 283             main_thread.Start ();
 284             while (!client.IsStarted) {}
 285         }
 286
 287         private void RunBanshee ()
 288         {
 289             try {
 290                 Gtk.Application.Init ();
 291                 ThreadAssist.InitializeMainThread ();
 292                 ThreadAssist.ProxyToMainHandler = Banshee.ServiceStack.Application.Invoke;
 293                 Application.PushClient (client);
 294                 Application.Run ();
 295
 296                 music_library = ServiceManager.SourceManager.MusicLibrary;
 297
 298                 var provider = DatabaseTrackInfo.Provider;
 299                 select_single_command = String.Format (
 300                         "SELECT {0} FROM {1} WHERE {2}{3}{4} = ?",
 301                         provider.Select, provider.From, provider.Where,
 302                         (String.IsNullOrEmpty (provider.Where) ? String.Empty : " AND "),
 303                         provider.PrimaryKey
 304                 );
 305
 306                 client.Start ();
 307             } catch (Exception e) {
 308                 Console.WriteLine (e);
 309                 throw;
 310             }
 311         }
 312
 313         [TestFixtureTearDown]
 314         [Category ("Performance")]
 315         public void Teardown ()
 316         {
 317             ThreadAssist.ProxyToMain (Application.Shutdown);
 318             main_thread.Join ();
 319             main_thread = null;
 320         }
 321
 322         protected uint RunTimeout (uint milliseconds, TimeoutHandler handler)
 323         {
 324             return GLib.Timeout.Add (milliseconds, delegate { return handler (); });
 325         }
 326
 327         protected uint RunIdle (IdleHandler handler)
 328         {
 329             return GLib.Idle.Add (delegate { return handler (); });
 330         }
 331
 332         protected bool IdleTimeoutRemove (uint id)
 333         {
 334             return GLib.Source.Remove (id);
 335         }
 336
 337 #endregion
 338
 339         public static void Main (string [] args)
 340         {
 341             var tests = new PerformanceTests ();
 342             tests.Setup ();
 343
 344             using (new Hyena.Timer ("Performance.exe Tests")) {
 345                 tests.ScrollLinear ();
 346             }
 347
 348             tests.Teardown ();
 349         }
 350
 351     }
 352
 353     public class SortableColumn : ISortableColumn
 354     {
 355         QueryField field;
 356         SortType sort_type;
 357
 358         public SortableColumn (QueryField field)
 359         {
 360             this.field = field;
 361         }
 362
 363         public string SortKey { get { return field.Name; } }
 364
 365         public SortType SortType {
 366             get { return sort_type; }
 367             set { sort_type = value; }
 368         }
 369
 370         public Hyena.Query.QueryField Field { get { return field; } }
 371
 372         public string Id { get { return field.Name; } }
 373     }
 374
 375     public class HeadlessClient : Client
 376     {
 377         public override string ClientId {
 378             get { return "Headless"; }
 379         }
 380
 381         public HeadlessClient ()
 382         {
 383         }
 384
 385         public void Start ()
 386         {
 387             OnStarted ();
 388         }
 389     }
 390 }