PowerShell

PowerShell cmdlets

ACMA comes with a set of PowerShell cmdlets that are installed with the UI component. These cmdlets can be used to modify both the ACMA database schema, as well as objects within the database.

The PowerShell quick reference guide contains the most commonly used commands and example scripts.

Cmdlet Reference by Category

Database Management

Core cmdlets for database operations and connections:

• Connect-AcmaEngine - Establish connection to ACMA database
• Disconnect-AcmaEngine - Disconnect from ACMA database
• New-AcmaDatabase - Create new ACMA database
• Update-AcmaDatabase - Update database schema
• Invoke-AcmaUnitTests - Execute unit tests

Schema Management

Constants

Manage system-wide constants:

• Add-AcmaConstant - Create new constants
• Get-AcmaConstantValue - Retrieve constant values
• Remove-AcmaConstant - Delete constants
• Set-AcmaConstantValue - Update constant values

Attributes

Define and manage object attributes:

• Add-AcmaSchemaAttribute - Create schema attributes
• Remove-AcmaSchemaAttribute - Delete schema attributes
• Rename-AcmaSchemaAttribute - Rename attributes
• Set-AcmaSchemaAttribute - Modify attribute properties

Bindings

Control attribute bindings to object classes:

• Add-AcmaSchemaBinding - Bind attributes to object classes
• Remove-AcmaSchemaBinding - Remove attribute bindings

Reference Back-links

Manage bidirectional reference relationships:

• Add-AcmaSchemaReferenceBackLink - Create reference back-links
• Remove-AcmaSchemaReferenceBackLink - Remove back-link relationships

Sequences

Control unique sequence generators:

• Add-AcmaSequence - Create sequences
• Remove-AcmaSequence - Delete sequences
• Set-AcmaSequence - Modify sequence properties

Shadow Object Links

Manage shadow object relationships:

• Add-AcmaShadowObjectLink - Create shadow object links
• Remove-AcmaShadowObjectLink - Remove shadow links

Object Operations

CRUD Operations

Fundamental object management:

• Add-AcmaObject - Create objects
• Remove-AcmaObject - Delete objects
• Get-AcmaObject - Retrieve single objects
• Get-AcmaObjects - Query multiple objects
• Save-AcmaObject - Save object changes

Query Operations

Database querying and filtering:

• New-AcmaPresenceQuery - Create attribute presence queries
• New-AcmaQuery - Build database queries
• New-AcmaQueryGroup - Create query groups with logic operators

Data Import/Export

Bulk operations for data migration:

• Export-AcmaObjects - Export objects to XML
• Import-AcmaObjects - Import objects from XML