00001 00002 using System; 00003 using NUnit.Framework; 00004 00005 namespace Foodolini.Database.Test 00006 { 00010 [TestFixture] 00011 public class UserTest : DatabaseTest 00012 { 00013 [Test] 00014 public void CreateTable(){ 00015 this.repository.CreateTable<User>(); 00016 } 00017 00021 [Test] 00022 public void Save(){ 00023 User user = new User(); 00024 user.BirthDate = new DateTime(1988, 1, 9); 00025 user.DietId = null; 00026 user.UserName = "Jopsen"; 00027 user.FullName = "Jonas Finnemann Jensen"; 00028 user.Gender = 1; 00029 user.Height = 1.79; 00030 user.Weight = 78; 00031 this.repository.Add<User>(user); 00032 00033 Assert.AreEqual(1, user.UserId); 00034 } 00035 00040 [Test] 00041 public void SaveAndLoad(){ 00042 User user = new User(); 00043 user.BirthDate = new DateTime(1988, 1, 9); 00044 user.DietId = null; 00045 user.UserName = "Jopsen"; 00046 user.FullName = "Jonas Finnemann Jensen"; 00047 user.Gender = 5; 00048 user.Height = 1.79; 00049 user.Weight = 78; 00050 00051 this.repository.Add<User>(user); 00052 00053 user.UserName = "Karsten"; 00054 user.FullName = "Karsten Jacobsen"; 00055 this.repository.Add<User>(user); 00056 00057 int reg = 0; 00058 foreach(var u in this.repository.Query<User>("SELECT * from USERS")){ 00059 if(u.UserName == "Karsten" || u.UserName == "Jopsen") 00060 reg++; 00061 } 00062 Assert.AreEqual(2, reg); 00063 } 00064 } 00065 }