Home
About
Blog
Products
Forum
Support
Contact
Sunbelt Computer Software
PL/B Language Development and Support
Home
About
Blog
Products
Forum
Support
Contact
NpgsqlRest/NpgsqlRestTests/Setup/AuthSchemeTestFixture.cs at 3.19.0 · NpgsqlRest/NpgsqlRest · GitHub
Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
Uh oh!
There was an error while loading.
Please reload this page
.
NpgsqlRest
/
NpgsqlRest
Public
Uh oh!
There was an error while loading.
Please reload this page
.
Notifications
You must be signed in to change notification settings
Fork
11
Star
130
Code
Issues
0
Pull requests
4
Discussions
Actions
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Discussions
Actions
Security and quality
Insights
Files
Expand file tree
3.19.0
Breadcrumbs
NpgsqlRest
/
NpgsqlRestTests
/
Setup
/
AuthSchemeTestFixture.cs
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
164 lines (146 loc) · 6.52 KB
3.19.0
Breadcrumbs
NpgsqlRest
/
NpgsqlRestTests
/
Setup
/
AuthSchemeTestFixture.cs
Copy path
Top
File metadata and controls
Code
Blame
164 lines (146 loc) · 6.52 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
using
Microsoft
.
AspNetCore
.
Authentication
.
Cookies
;
using
Microsoft
.
AspNetCore
.
Authentication
.
JwtBearer
;
using
Microsoft
.
AspNetCore
.
Builder
;
using
Microsoft
.
AspNetCore
.
Hosting
;
using
Microsoft
.
Extensions
.
DependencyInjection
;
using
NpgsqlRest
.
Auth
;
using
NpgsqlRestClient
;
namespace
NpgsqlRestTests
.
Setup
;
[
CollectionDefinition
(
"AuthSchemeTestFixture"
)
]
public
class
AuthSchemeTestFixtureCollection
:
ICollectionFixture
<
AuthSchemeTestFixture
>
{
}
/// <summary>
/// End-to-end fixture for <c>Auth:Schemes</c> — verifies that the full login pipeline (PostgreSQL
/// function returns a scheme name in its `scheme` column → NpgsqlRest passes it to <c>Results.SignIn</c>
/// for cookies / <see cref="JwtLoginHandler"/> for JWT → ASP.NET Core writes a cookie or token-pair
/// scoped to that scheme's options) actually delivers the scheme-specific behavior end-to-end.
///
/// The fixture mirrors what <c>Builder.RegisterAuthSchemes</c> would produce from this config:
///
/// <code>
/// "Auth": {
/// "CookieAuth": true,
/// "CookieValid": "14 days",
/// "JwtAuth": true,
/// "JwtSecret": "...32+chars...",
/// "Schemes": {
/// "ast_short_session": { "Type": "Cookies", "CookieValid": "1 hour", "CookieMultiSessions": false },
/// "ast_jwt_admin": { "Type": "Jwt", "JwtSecret": "...different-32+chars...", "JwtExpire": "5 minutes" }
/// }
/// }
/// </code>
///
/// We don't go through Builder.cs here because the registration paths are already covered by
/// AuthSchemeRegistrationTests; this fixture exercises the integration with NpgsqlRest's LoginHandler
/// for both cookie and JWT scheme types.
/// </summary>
public
class
AuthSchemeTestFixture
:
IDisposable
{
private
readonly
WebApplication
_app
;
public
string
ServerAddress
{
get
;
}
/// <summary>
/// Distinct JWT signing secrets per scheme — proves the per-scheme secret override works.
/// Both ≥32 chars for HS256.
/// </summary>
public
const
string
MainJwtSecret
=
"main-scheme-secret-at-least-32-chars-long-x"
;
public
const
string
AdminJwtSecret
=
"admin-scheme-secret-totally-different-32-chars"
;
public
AuthSchemeTestFixture
(
)
{
var
connectionString
=
Database
.
Create
(
)
;
var
builder
=
WebApplication
.
CreateBuilder
(
)
;
builder
.
WebHost
.
UseUrls
(
"http://127.0.0.1:0"
)
;
// Main JwtTokenConfig — also registered with JwtLoginHandler so login functions returning the
// main scheme name get tokens minted with this secret.
var
mainJwtConfig
=
new
JwtTokenConfig
{
Scheme
=
JwtBearerDefaults
.
AuthenticationScheme
,
Secret
=
MainJwtSecret
,
Expire
=
TimeSpan
.
FromMinutes
(
60
)
,
RefreshExpire
=
TimeSpan
.
FromDays
(
7
)
,
}
;
// Per-scheme JWT config — different secret, much shorter expiration. Mirrors what
// RegisterJwtSchemeFromConfig would build from a Schemes:ast_jwt_admin config.
var
adminJwtConfig
=
new
JwtTokenConfig
{
Scheme
=
"ast_jwt_admin"
,
Secret
=
AdminJwtSecret
,
Expire
=
TimeSpan
.
FromMinutes
(
5
)
,
RefreshExpire
=
TimeSpan
.
FromHours
(
1
)
,
}
;
builder
.
Services
.
AddAuthentication
(
CookieAuthenticationDefaults
.
AuthenticationScheme
)
.
AddCookie
(
CookieAuthenticationDefaults
.
AuthenticationScheme
,
options
=>
{
options
.
ExpireTimeSpan
=
TimeSpan
.
FromDays
(
14
)
;
options
.
Cookie
.
Name
=
".main-cookie"
;
options
.
Cookie
.
MaxAge
=
TimeSpan
.
FromDays
(
14
)
;
options
.
Cookie
.
HttpOnly
=
true
;
}
)
.
AddCookie
(
"ast_short_session"
,
options
=>
{
options
.
ExpireTimeSpan
=
TimeSpan
.
FromHours
(
1
)
;
options
.
Cookie
.
Name
=
".short-cookie"
;
options
.
Cookie
.
MaxAge
=
null
;
// session-only — MultiSessions=false
options
.
Cookie
.
HttpOnly
=
true
;
}
)
.
AddJwtBearer
(
JwtBearerDefaults
.
AuthenticationScheme
,
options
=>
{
options
.
TokenValidationParameters
=
mainJwtConfig
.
GetTokenValidationParameters
(
)
;
options
.
SaveToken
=
true
;
}
)
.
AddJwtBearer
(
"ast_jwt_admin"
,
options
=>
{
options
.
TokenValidationParameters
=
adminJwtConfig
.
GetTokenValidationParameters
(
)
;
options
.
SaveToken
=
true
;
}
)
;
// Wire the multi-scheme JwtLoginHandler — the LoginHandler queries this when a function
// returns one of the registered JWT scheme names.
JwtLoginHandler
.
Initialize
(
mainJwtConfig
)
;
JwtLoginHandler
.
Register
(
adminJwtConfig
)
;
_app
=
builder
.
Build
(
)
;
_app
.
UseAuthentication
(
)
;
_app
.
UseNpgsqlRest
(
new
(
connectionString
)
{
IncludeSchemas
=
[
"public"
]
,
NameSimilarTo
=
"ast[_]%"
,
CommentsMode
=
CommentsMode
.
ParseAll
,
RequiresAuthorization
=
false
,
AuthenticationOptions
=
new
(
)
{
DefaultAuthenticationType
=
CookieAuthenticationDefaults
.
AuthenticationScheme
,
CustomLoginHandler
=
async
(
context
,
principal
,
scheme
)
=>
{
// Route JWT-scheme logins to JwtLoginHandler (token response), all others to the
// default cookie-style SignIn flow. Mirrors App.CreateJwtLoginHandler in production.
if
(
scheme
is
not
null
&&
JwtLoginHandler
.
IsScheme
(
scheme
)
)
{
return
await
JwtLoginHandler
.
HandleLoginAsync
(
context
,
principal
,
scheme
)
;
}
return
false
;
}
}
}
)
;
_app
.
StartAsync
(
)
.
GetAwaiter
(
)
.
GetResult
(
)
;
ServerAddress
=
_app
.
Urls
.
First
(
)
;
}
/// <summary>
/// Creates an HttpClient that does NOT auto-follow redirects (so we can inspect Set-Cookie on the
/// login response directly) and DOES preserve cookies (for follow-up authenticated requests).
/// </summary>
public
HttpClient
CreateClient
(
)
{
var
handler
=
new
HttpClientHandler
{
UseCookies
=
true
,
CookieContainer
=
new
System
.
Net
.
CookieContainer
(
)
,
AllowAutoRedirect
=
false
}
;
return
new
HttpClient
(
handler
)
{
BaseAddress
=
new
Uri
(
ServerAddress
)
,
Timeout
=
TimeSpan
.
FromMinutes
(
5
)
}
;
}
#pragma warning disable
CA1816
public
void
Dispose
(
)
#pragma warning restore
CA1816
{
_app
.
StopAsync
(
)
.
GetAwaiter
(
)
.
GetResult
(
)
;
_app
.
DisposeAsync
(
)
.
GetAwaiter
(
)
.
GetResult
(
)
;
}
}
You can’t perform that action at this time.