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>
91 lines
2.8 KiB
PowerShell
91 lines
2.8 KiB
PowerShell
# Explore GeViSoft Database Structure
|
|
|
|
$ErrorActionPreference = "Stop"
|
|
|
|
$dbPath = "C:\GEVISOFT\DATABASE\GeViDB.mdb"
|
|
|
|
Write-Host "========================================" -ForegroundColor Cyan
|
|
Write-Host "Exploring GeViSoft Database" -ForegroundColor Cyan
|
|
Write-Host "========================================" -ForegroundColor Cyan
|
|
Write-Host ""
|
|
Write-Host "Database: $dbPath" -ForegroundColor Gray
|
|
Write-Host ""
|
|
|
|
# Create ADODB connection
|
|
$conn = New-Object -ComObject ADODB.Connection
|
|
$connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$dbPath;Persist Security Info=False;Mode=Share Deny None;"
|
|
|
|
try {
|
|
$conn.Open($connectionString)
|
|
Write-Host "[OK] Connected to database" -ForegroundColor Green
|
|
Write-Host ""
|
|
|
|
# Get list of tables
|
|
$schema = $conn.OpenSchema(20) # adSchemaTables = 20
|
|
|
|
$tables = @()
|
|
while (-not $schema.EOF) {
|
|
$tableName = $schema.Fields.Item("TABLE_NAME").Value
|
|
$tableType = $schema.Fields.Item("TABLE_TYPE").Value
|
|
|
|
if ($tableType -eq "TABLE") {
|
|
$tables += $tableName
|
|
}
|
|
|
|
$schema.MoveNext()
|
|
}
|
|
|
|
$schema.Close()
|
|
|
|
Write-Host "Found $($tables.Count) tables:" -ForegroundColor Cyan
|
|
Write-Host ""
|
|
|
|
# Look for tables related to alarms, actions, mappings
|
|
$relevantTables = $tables | Where-Object {
|
|
$_ -like "*alarm*" -or
|
|
$_ -like "*action*" -or
|
|
$_ -like "*mapping*" -or
|
|
$_ -like "*event*" -or
|
|
$_ -like "*rule*"
|
|
} | Sort-Object
|
|
|
|
if ($relevantTables.Count -gt 0) {
|
|
Write-Host "Relevant tables (alarms/actions/mappings):" -ForegroundColor Yellow
|
|
foreach ($table in $relevantTables) {
|
|
# Get row count
|
|
$rs = $conn.Execute("SELECT COUNT(*) AS cnt FROM [$table]")
|
|
$count = $rs.Fields.Item("cnt").Value
|
|
$rs.Close()
|
|
|
|
Write-Host " - $table ($count records)" -ForegroundColor White
|
|
}
|
|
Write-Host ""
|
|
}
|
|
|
|
Write-Host "All tables:" -ForegroundColor Yellow
|
|
$tables | Sort-Object | ForEach-Object {
|
|
# Get row count
|
|
try {
|
|
$rs = $conn.Execute("SELECT COUNT(*) AS cnt FROM [$_]")
|
|
$count = $rs.Fields.Item("cnt").Value
|
|
$rs.Close()
|
|
Write-Host " - $_ ($count records)" -ForegroundColor Gray
|
|
} catch {
|
|
Write-Host " - $_ (error reading)" -ForegroundColor DarkGray
|
|
}
|
|
}
|
|
|
|
} catch {
|
|
Write-Host "[ERROR] Failed to connect: $($_.Exception.Message)" -ForegroundColor Red
|
|
Write-Host ""
|
|
Write-Host "You may need to install the Microsoft Access Database Engine:" -ForegroundColor Yellow
|
|
Write-Host " https://www.microsoft.com/en-us/download/details.aspx?id=54920" -ForegroundColor Cyan
|
|
} finally {
|
|
if ($conn.State -ne 0) {
|
|
$conn.Close()
|
|
}
|
|
}
|
|
|
|
Write-Host ""
|
|
Write-Host "========================================" -ForegroundColor Cyan
|