/
OrmLiteUserAuthTests.cs
55 lines (47 loc) · 1.75 KB
/
OrmLiteUserAuthTests.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
using System;
using System.IO;
using NUnit.Framework;
using ServiceStack.Common.Utils;
using ServiceStack.OrmLite;
using ServiceStack.OrmLite.Sqlite;
using ServiceStack.ServiceInterface.Auth;
using ServiceStack.Text;
namespace ServiceStack.Common.Tests.OAuth
{
[TestFixture]
public class OrmLiteUserAuthTests
{
[Test]
public void Can_insert_table_with_UserAuth()
{
OrmLiteConfig.DialectProvider = SqliteOrmLiteDialectProvider.Instance;
var connectionString = "~/App_Data/db.sqlite".MapAbsolutePath();
if (File.Exists(connectionString))
File.Delete(connectionString);
using (var db = connectionString.OpenDbConnection())
using (var dbCmd = db.CreateCommand())
{
dbCmd.CreateTable<UserAuth>(true);
//var userAuth = new UserAuth {
// Id = 1,
// UserName = "UserName",
// Email = "a@b.com",
// PrimaryEmail = "c@d.com",
// FirstName = "FirstName",
// LastName = "LastName",
// DisplayName = "DisplayName",
// Salt = "Salt",
// PasswordHash = "PasswordHash",
// CreatedDate = DateTime.Now,
// ModifiedDate = DateTime.UtcNow,
//};
var jsv = "{Id:0,UserName:UserName,Email:as@if.com,PrimaryEmail:as@if.com,FirstName:FirstName,LastName:LastName,DisplayName:DisplayName,Salt:WMQi/g==,PasswordHash:oGdE40yKOprIgbXQzEMSYZe3vRCRlKGuqX2i045vx50=,Roles:[],Permissions:[],CreatedDate:2012-03-20T07:53:48.8720739Z,ModifiedDate:2012-03-20T07:53:48.8720739Z}";
var userAuth = jsv.To<UserAuth>();
dbCmd.Insert(userAuth);
var rows = dbCmd.Select<UserAuth>(q => q.UserName == "UserName");
Console.WriteLine(rows[0].Dump());
Assert.That(rows[0].UserName, Is.EqualTo(userAuth.UserName));
}
}
}
}