param(
    [string]$db_query = "SELECT id,summary,description,created_at FROM Tickets",
    [string]$db_data_source = "C:\spiceworksTmp\spiceworks_prod.db"
)

# REQUIRES: system.data.sqlite
# http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki

[string]$sqlite_library_path = "C:\Program Files\System.Data.SQLite\2008\bin\System.Data.SQLite.dll"

[void][System.Reflection.Assembly]::LoadFrom($sqlite_library_path)

$db_dataset = New-Object System.Data.DataSet
$db_data_adapter = New-Object System.Data.SQLite.SQLiteDataAdapter($db_query,"Data Source=$db_data_source")
[void]$db_data_adapter.Fill($db_dataset)

$db_dataset.Tables[0]