2.1 release tasks - Githubissues

303248153 commented 6 years ago

[x] make ZKWeb.ORM.NHibernate supports netstandard 2.0
[x] update other packages
[x] add nhibernate logging support
[x] add mongodb logging support
[x] update toolkit
[x] release beta
- [x] update project templates
- [x] test dapper
- [x] test efcore
- [x] test nhibernate (on linux)
- [x] test mongodb
[x] update document
[x] bump version
[x] update zkweb.demo
[x] update zkweb.home
[x] update zkweb.mvvmdemo

303248153 commented 6 years ago

example sql log from nhibernate

SELECT TOP (1) id1_3_, type2_3_, username3_3_, password4_3_, createtime5_3_, updatetime6_3_, items7_3_, deleted8_3_ FROM (select user0_.Id as id1_3_, user0_.Type as type2_3_, user0_.Username as username3_3_, user0_.Password as password4_3_, user0_.CreateTime as createtime5_3_, user0_.UpdateTime as updatetime6_3_, user0_.Items as items7_3_, user0_.Deleted as deleted8_3_, ROW_NUMBER() OVER(ORDER BY user0_.CreateTime DESC) as __hibernate_sort_row from ZKWeb_User user0_ where user0_.Deleted=? and (user0_.Type in (? , ?))) as query WHERE query.__hibernate_sort_row > ? ORDER BY query.__hibernate_sort_row,
SELECT TOP (?) id1_3_, type2_3_, username3_3_, password4_3_, createtime5_3_, updatetime6_3_, items7_3_, deleted8_3_ FROM (select user0_.Id as id1_3_, user0_.Type as type2_3_, user0_.Username as username3_3_, user0_.Password as password4_3_, user0_.CreateTime as createtime5_3_, user0_.UpdateTime as updatetime6_3_, user0_.Items as items7_3_, user0_.Deleted as deleted8_3_, ROW_NUMBER() OVER(ORDER BY user0_.CreateTime DESC) as __hibernate_sort_row from ZKWeb_User user0_ where user0_.Deleted=? and (user0_.Type in (? , ?))) as query WHERE query.__hibernate_sort_row > ? ORDER BY query.__hibernate_sort_row,
SELECT TOP (?) id1_3_, type2_3_, username3_3_, password4_3_, createtime5_3_, updatetime6_3_, items7_3_, deleted8_3_ FROM (select user0_.Id as id1_3_, user0_.Type as type2_3_, user0_.Username as username3_3_, user0_.Password as password4_3_, user0_.CreateTime as createtime5_3_, user0_.UpdateTime as updatetime6_3_, user0_.Items as items7_3_, user0_.Deleted as deleted8_3_, ROW_NUMBER() OVER(ORDER BY user0_.CreateTime DESC) as __hibernate_sort_row from ZKWeb_User user0_ where user0_.Deleted=? and (user0_.Type in (? , ?))) as query WHERE query.__hibernate_sort_row > ? ORDER BY query.__hibernate_sort_row,
SELECT roles0_.User_id as user1_4_1_, roles0_.UserRole_id as userrole2_4_1_, userrole1_.Id as id1_5_0_, userrole1_.Name as name2_5_0_, userrole1_.Privileges as privileges3_5_0_, userrole1_.CreateTime as createtime4_5_0_, userrole1_.UpdateTime as updatetime5_5_0_, userrole1_.Remark as remark6_5_0_, userrole1_.Deleted as deleted7_5_0_ FROM ZKWeb_UserToUserRole roles0_ left outer join ZKWeb_UserRole userrole1_ on roles0_.UserRole_id=userrole1_.Id WHERE roles0_.User_id=?,
SELECT roles0_.User_id as user1_4_1_, roles0_.UserRole_id as userrole2_4_1_, userrole1_.Id as id1_5_0_, userrole1_.Name as name2_5_0_, userrole1_.Privileges as privileges3_5_0_, userrole1_.CreateTime as createtime4_5_0_, userrole1_.UpdateTime as updatetime5_5_0_, userrole1_.Remark as remark6_5_0_, userrole1_.Deleted as deleted7_5_0_ FROM ZKWeb_UserToUserRole roles0_ left outer join ZKWeb_UserRole userrole1_ on roles0_.UserRole_id=userrole1_.Id WHERE roles0_.User_id=?,
select TOP (1) scheduledt0_.Id as id1_1_, scheduledt0_.CreateTime as createtime2_1_, scheduledt0_.UpdateTime as updatetime3_1_ from ZKWeb_ScheduledTask scheduledt0_ where scheduledt0_.Id=?,
select TOP (1) scheduledt0_.Id as id1_1_, scheduledt0_.CreateTime as createtime2_1_, scheduledt0_.UpdateTime as updatetime3_1_ from ZKWeb_ScheduledTask scheduledt0_ where scheduledt0_.Id=?,
select TOP (1) scheduledt0_.Id as id1_1_, scheduledt0_.CreateTime as createtime2_1_, scheduledt0_.UpdateTime as updatetime3_1_ from ZKWeb_ScheduledTask scheduledt0_ where scheduledt0_.Id=?,
select TOP (1) scheduledt0_.Id as id1_1_, scheduledt0_.CreateTime as createtime2_1_, scheduledt0_.UpdateTime as updatetime3_1_ from ZKWeb_ScheduledTask scheduledt0_ where scheduledt0_.Id=?,
select TOP (1) scheduledt0_.Id as id1_1_, scheduledt0_.CreateTime as createtime2_1_, scheduledt0_.UpdateTime as updatetime3_1_ from ZKWeb_ScheduledTask scheduledt0_ where scheduledt0_.Id=?,
select TOP (1) scheduledt0_.Id as id1_1_, scheduledt0_.CreateTime as createtime2_1_, scheduledt0_.UpdateTime as updatetime3_1_ from ZKWeb_ScheduledTask scheduledt0_ where scheduledt0_.Id=?,

303248153 commented 6 years ago

example sql log from efcore

FROM [TestEntity] AS [x], exception = , category = Microsoft.EntityFrameworkCore.Database.Command }
Executed DbCommand (888ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN [x].[Name] LIKE N'abc' + N'%' AND (LEFT([x].[Name], LEN(N'abc')) = N'abc')
    THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
END
FROM [TestEntity] AS [x] { state = Executed DbCommand (888ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN [x].[Name] LIKE N'abc' + N'%' AND (LEFT([x].[Name], LEN(N'abc')) = N'abc')
    THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
END
FROM [TestEntity] AS [x], exception = , category = Microsoft.EntityFrameworkCore.Database.Command }
A data reader was disposed. { state = A data reader was disposed., exception = , category = Microsoft.EntityFrameworkCore.Database.Command }
A data reader was disposed. { state = A data reader was disposed., exception = , category = Microsoft.EntityFrameworkCore.Database.Command }

303248153 commented 6 years ago

example sql log from dapper

select * from ZKWeb_GenericConfig
select * from ZKWeb_GenericConfig
select * from ZKWeb_Session
select * from ZKWeb_User
select * from ZKWeb_Session
select * from ZKWeb_User
select * from ZKWeb_Session
update ZKWeb_Session set ReleatedId = @ReleatedId, Items = @Items, IpAddress = @IpAddress, RememberLogin = @RememberLogin, Expires = @Expires where Id = @Id
set nocount on insert into ZKWeb_Session (Id, ReleatedId, Items, IpAddress, RememberLogin, Expires) values (@Id, @ReleatedId, @Items, @IpAddress, @RememberLogin, @Expires) select cast(scope_identity() as int)
select * from ZKWeb_Session where value(ZKWeb.Plugins.Common.Base.src.Domain.Services.Bases.DomainServiceBase`2+<>c__DisplayClass11_0[ZKWeb.Plugins.Common.Base.src.Domain.Entities.Session,System.Guid]).ids.Contains(e.Id)
select * from ZKWeb_Session

303248153 commented 6 years ago

example command log from mongo

getLastError: { "getLastError" : 1 }
update: { "update" : "ZKWeb_Session", "ordered" : true, "updates" : [{ "q" : { "_id" : CSUUID("008489a5-8e88-103e-7660-183f19e407b5") }, "u" : { "_id" : CSUUID("008489a5-8e88-103e-7660-183f19e407b5"), "ReleatedId" : null, "Items" : { }, "IpAddress" : "::1", "RememberLogin" : false, "Expires" : ISODate("2018-03-21T07:55:07.974Z") }, "upsert" : true }] }
buildInfo: { "buildInfo" : 1 }
saslStart: { }
saslContinue: { }
saslContinue: { }
getLastError: { "getLastError" : 1 }
isMaster: { "isMaster" : 1 }
buildInfo: { "buildInfo" : 1 }
buildInfo: { "buildInfo" : 1 }
saslStart: { }
saslContinue: { }
saslContinue: { }
getLastError: { "getLastError" : 1 }
aggregate: { "aggregate" : "ZKWeb_User", "pipeline" : [{ "$match" : { "Deleted" : false } }, { "$match" : { "Username" : "admin" } }, { "$limit" : 1 }], "cursor" : { } }
buildInfo: { "buildInfo" : 1 }
saslStart: { }
saslContinue: { }
saslContinue: { }
getLastError: { "getLastError" : 1 }
isMaster: { "isMaster" : 1 }
buildInfo: { "buildInfo" : 1 }

zkweb-framework / ZKWeb

2.1 release tasks #5