14893e62a5
This MVP release provides a complete full-stack solution for managing action mappings in Geutebruck's GeViScope and GeViSoft video surveillance systems. ## Features ### Flutter Web Application (Port 8081) - Modern, responsive UI for managing action mappings - Action picker dialog with full parameter configuration - Support for both GSC (GeViScope) and G-Core server actions - Consistent UI for input and output actions with edit/delete capabilities - Real-time action mapping creation, editing, and deletion - Server categorization (GSC: prefix for GeViScope, G-Core: prefix for G-Core servers) ### FastAPI REST Backend (Port 8000) - RESTful API for action mapping CRUD operations - Action template service with comprehensive action catalog (247 actions) - Server management (G-Core and GeViScope servers) - Configuration tree reading and writing - JWT authentication with role-based access control - PostgreSQL database integration ### C# SDK Bridge (gRPC, Port 50051) - Native integration with GeViSoft SDK (GeViProcAPINET_4_0.dll) - Action mapping creation with correct binary format - Support for GSC and G-Core action types - Proper Camera parameter inclusion in action strings (fixes CrossSwitch bug) - Action ID lookup table with server-specific action IDs - Configuration reading/writing via SetupClient ## Bug Fixes - **CrossSwitch Bug**: GSC and G-Core actions now correctly display camera/PTZ head parameters in GeViSet - Action strings now include Camera parameter: `@ PanLeft (Comment: "", Camera: 101028)` - Proper filter flags and VideoInput=0 for action mappings - Correct action ID assignment (4198 for GSC, 9294 for G-Core PanLeft) ## Technical Stack - **Frontend**: Flutter Web, Dart, Dio HTTP client - **Backend**: Python FastAPI, PostgreSQL, Redis - **SDK Bridge**: C# .NET 8.0, gRPC, GeViSoft SDK - **Authentication**: JWT tokens - **Configuration**: GeViSoft .set files (binary format) ## Credentials - GeViSoft/GeViScope: username=sysadmin, password=masterkey - Default admin: username=admin, password=admin123 ## Deployment All services run on localhost: - Flutter Web: http://localhost:8081 - FastAPI: http://localhost:8000 - SDK Bridge gRPC: localhost:50051 - GeViServer: localhost (default port) Generated with Claude Code (https://claude.com/claude-code) Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
85 lines
2.9 KiB
PowerShell
85 lines
2.9 KiB
PowerShell
# Test direct database access
|
|
|
|
$ErrorActionPreference = "Continue"
|
|
|
|
Write-Host "========================================" -ForegroundColor Cyan
|
|
Write-Host "Testing Direct Database Access" -ForegroundColor Cyan
|
|
Write-Host "========================================" -ForegroundColor Cyan
|
|
Write-Host ""
|
|
|
|
$dbPath = "C:\GEVISOFT\DATABASE\GeViDB.mdb"
|
|
$connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$dbPath;Mode=Read;"
|
|
|
|
try {
|
|
Write-Host "Connecting to database..." -ForegroundColor Yellow
|
|
$conn = New-Object -ComObject ADODB.Connection
|
|
$conn.Open($connectionString)
|
|
Write-Host " [OK] Connected" -ForegroundColor Green
|
|
Write-Host ""
|
|
|
|
# List all tables
|
|
Write-Host "Listing tables..." -ForegroundColor Yellow
|
|
$schema = $conn.OpenSchema(20) # adSchemaTables = 20
|
|
$tables = @()
|
|
while (-not $schema.EOF) {
|
|
$tableName = $schema.Fields.Item("TABLE_NAME").Value
|
|
if (-not $tableName.StartsWith("MSys")) {
|
|
$tables += $tableName
|
|
}
|
|
$schema.MoveNext()
|
|
}
|
|
$schema.Close()
|
|
|
|
Write-Host " Found $($tables.Count) user tables:" -ForegroundColor Gray
|
|
foreach ($table in $tables | Sort-Object) {
|
|
Write-Host " - $table" -ForegroundColor White
|
|
}
|
|
Write-Host ""
|
|
|
|
# Check if Alarms table exists
|
|
if ($tables -contains "Alarms") {
|
|
Write-Host "Querying Alarms table..." -ForegroundColor Yellow
|
|
$rs = $conn.Execute("SELECT COUNT(*) FROM Alarms")
|
|
$count = $rs.Fields.Item(0).Value
|
|
$rs.Close()
|
|
Write-Host " [OK] Alarms table has $count records" -ForegroundColor Green
|
|
Write-Host ""
|
|
|
|
# Get sample records
|
|
Write-Host "Sample alarm records:" -ForegroundColor Yellow
|
|
$rs = $conn.Execute("SELECT TOP 5 * FROM Alarms")
|
|
$fieldCount = $rs.Fields.Count
|
|
Write-Host " Fields: $fieldCount" -ForegroundColor Gray
|
|
|
|
for ($i = 0; $i -lt $fieldCount; $i++) {
|
|
Write-Host " $($i): $($rs.Fields.Item($i).Name) ($($rs.Fields.Item($i).Type))" -ForegroundColor Gray
|
|
}
|
|
$rs.Close()
|
|
} else {
|
|
Write-Host "[WARN] Alarms table not found" -ForegroundColor Yellow
|
|
}
|
|
|
|
# Check if Actions table exists
|
|
if ($tables -contains "Actions") {
|
|
Write-Host ""
|
|
Write-Host "Querying Actions table..." -ForegroundColor Yellow
|
|
$rs = $conn.Execute("SELECT COUNT(*) FROM Actions")
|
|
$count = $rs.Fields.Item(0).Value
|
|
$rs.Close()
|
|
Write-Host " [OK] Actions table has $count records" -ForegroundColor Green
|
|
} else {
|
|
Write-Host ""
|
|
Write-Host "[WARN] Actions table not found" -ForegroundColor Yellow
|
|
Write-Host " The database schema might be different than expected" -ForegroundColor Gray
|
|
}
|
|
|
|
$conn.Close()
|
|
|
|
} catch {
|
|
Write-Host ""
|
|
Write-Host "[ERROR] $($_.Exception.Message)" -ForegroundColor Red
|
|
}
|
|
|
|
Write-Host ""
|
|
Write-Host "========================================" -ForegroundColor Cyan
|