docs/about_PSCsvSQLiteORM.help.txt
|
TOPIC about_PSCsvSQLiteORM SHORT DESCRIPTION PowerShell 5.1 ORM for SQLite with CSV import, schema inference, dynamic models, relationships, joins, upserts, and migrations. LONG DESCRIPTION PSCsvSQLiteORM provides a lightweight ORM-like experience over SQLite for Windows PowerShell 5.1. It enables: - Importing CSV data into SQLite with automatic type inference - Dynamic model generation from a catalog - Relationship discovery and join support (INNER, LEFT; RIGHT/FULL emulated) - Upsert helpers and migration tracking - Logging and configurable defaults via settings script Settings Script You can configure defaults by providing a settings script that returns a hashtable with keys: DbPath, LogPath, LogLevel. Example: @{ DbPath='C:\\data\\app.db'; LogPath='C:\\logs\\db.log'; LogLevel='INFO' } Apply it: Initialize-ORMVars -SettingsPath .\orm.settings.ps1 EXAMPLES Import a CSV and build the schema: Import-CsvToSqlite -CsvPath .\assets.csv -Database .\sample.db -TableName assets Generate models and set dynamic class: $types = Export-DynamicModelsFromCatalog -Database .\sample.db Set-DynamicORMClass SEE ALSO Import-CsvToSqlite Initialize-ORMVars Export-DynamicModelsFromCatalog Invoke-DbQuery Update-DbCatalog LINK https://github.com/joeymiles/PSCsvSQLiteORM |