123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842 |
- /*
- * Copyright (c) Contributors, http://opensimulator.org/
- * See CONTRIBUTORS.TXT for a full list of copyright holders.
- *
- * Redistribution and use in source and binary forms, with or without
- * modification, are permitted provided that the following conditions are met:
- * * Redistributions of source code must retain the above copyright
- * notice, this list of conditions and the following disclaimer.
- * * Redistributions in binary form must reproduce the above copyright
- * notice, this list of conditions and the following disclaimer in the
- * documentation and/or other materials provided with the distribution.
- * * Neither the name of the OpenSim Project nor the
- * names of its contributors may be used to endorse or promote products
- * derived from this software without specific prior written permission.
- *
- * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
- * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
- * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
- * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
- * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
- * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
- * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
- * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
- * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
- * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
- */
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Reflection;
- using libsecondlife;
- using log4net;
- using Mono.Data.SqliteClient;
- using OpenSim.Framework;
- namespace OpenSim.Data.SQLite
- {
- /// <summary>
- /// An Inventory Interface to the SQLite database
- /// </summary>
- public class SQLiteInventoryStore : SQLiteUtil, IInventoryData
- {
- private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
- private const string invItemsSelect = "select * from inventoryitems";
- private const string invFoldersSelect = "select * from inventoryfolders";
- private DataSet ds;
- private SqliteDataAdapter invItemsDa;
- private SqliteDataAdapter invFoldersDa;
- /// <summary>
- /// <list type="bullet">
- /// <item>Initialises Inventory interface</item>
- /// <item>Loads and initialises a new SQLite connection and maintains it.</item>
- /// <item>use default URI if connect string string is empty.</item>
- /// </list>
- /// </summary>
- /// <param name="dbconnect">connect string</param>
- public void Initialise(string dbconnect)
- {
- if (dbconnect == string.Empty)
- {
- dbconnect = "URI=file:inventoryStore.db,version=3";
- }
- m_log.Info("[INVENTORY DB]: Sqlite - connecting: " + dbconnect);
- SqliteConnection conn = new SqliteConnection(dbconnect);
- conn.Open();
- Assembly assem = GetType().Assembly;
- Migration m = new Migration(conn, assem, "InventoryStore");
- // TODO: remove this line after changeset 6000
- TestTables(conn, m);
- m.Update();
- SqliteCommand itemsSelectCmd = new SqliteCommand(invItemsSelect, conn);
- invItemsDa = new SqliteDataAdapter(itemsSelectCmd);
- // SqliteCommandBuilder primCb = new SqliteCommandBuilder(primDa);
- SqliteCommand foldersSelectCmd = new SqliteCommand(invFoldersSelect, conn);
- invFoldersDa = new SqliteDataAdapter(foldersSelectCmd);
- ds = new DataSet();
- ds.Tables.Add(createInventoryFoldersTable());
- invFoldersDa.Fill(ds.Tables["inventoryfolders"]);
- setupFoldersCommands(invFoldersDa, conn);
- m_log.Info("[INVENTORY DB]: Populated Inventory Folders Definitions");
- ds.Tables.Add(createInventoryItemsTable());
- invItemsDa.Fill(ds.Tables["inventoryitems"]);
- setupItemsCommands(invItemsDa, conn);
- m_log.Info("[INVENTORY DB]: Populated Inventory Items Definitions");
- ds.AcceptChanges();
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="row"></param>
- /// <returns></returns>
- public InventoryItemBase buildItem(DataRow row)
- {
- InventoryItemBase item = new InventoryItemBase();
- item.ID = new LLUUID((string) row["UUID"]);
- item.AssetID = new LLUUID((string) row["assetID"]);
- item.AssetType = Convert.ToInt32(row["assetType"]);
- item.InvType = Convert.ToInt32(row["invType"]);
- item.Folder = new LLUUID((string) row["parentFolderID"]);
- item.Owner = new LLUUID((string) row["avatarID"]);
- item.Creator = new LLUUID((string) row["creatorsID"]);
- item.Name = (string) row["inventoryName"];
- item.Description = (string) row["inventoryDescription"];
- item.NextPermissions = Convert.ToUInt32(row["inventoryNextPermissions"]);
- item.CurrentPermissions = Convert.ToUInt32(row["inventoryCurrentPermissions"]);
- item.BasePermissions = Convert.ToUInt32(row["inventoryBasePermissions"]);
- item.EveryOnePermissions = Convert.ToUInt32(row["inventoryEveryOnePermissions"]);
- // new fields
- if (!Convert.IsDBNull(row["salePrice"]))
- item.SalePrice = Convert.ToInt32(row["salePrice"]);
- if (!Convert.IsDBNull(row["saleType"]))
- item.SaleType = Convert.ToByte(row["saleType"]);
- if (!Convert.IsDBNull(row["creationDate"]))
- item.CreationDate = Convert.ToInt32(row["creationDate"]);
- if (!Convert.IsDBNull(row["groupID"]))
- item.GroupID = new LLUUID((string)row["groupID"]);
- if (!Convert.IsDBNull(row["groupOwned"]))
- item.GroupOwned = Convert.ToBoolean(row["groupOwned"]);
- if (!Convert.IsDBNull(row["Flags"]))
- item.Flags = Convert.ToUInt32(row["Flags"]);
- return item;
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="row"></param>
- /// <param name="item"></param>
- private static void fillItemRow(DataRow row, InventoryItemBase item)
- {
- row["UUID"] = Util.ToRawUuidString(item.ID);
- row["assetID"] = Util.ToRawUuidString(item.AssetID);
- row["assetType"] = item.AssetType;
- row["invType"] = item.InvType;
- row["parentFolderID"] = Util.ToRawUuidString(item.Folder);
- row["avatarID"] = Util.ToRawUuidString(item.Owner);
- row["creatorsID"] = Util.ToRawUuidString(item.Creator);
- row["inventoryName"] = item.Name;
- row["inventoryDescription"] = item.Description;
- row["inventoryNextPermissions"] = item.NextPermissions;
- row["inventoryCurrentPermissions"] = item.CurrentPermissions;
- row["inventoryBasePermissions"] = item.BasePermissions;
- row["inventoryEveryOnePermissions"] = item.EveryOnePermissions;
- // new fields
- row["salePrice"] = item.SalePrice;
- row["saleType"] = item.SaleType;
- row["creationDate"] = item.CreationDate;
- row["groupID"] = item.GroupID;
- row["groupOwned"] = item.GroupOwned;
- row["flags"] = item.Flags;
- }
- /// <summary>
- /// Add inventory folder
- /// </summary>
- /// <param name="folder">Folder base</param>
- /// <param name="add">true=create folder. false=update existing folder</param>
- /// <remarks>nasty</remarks>
- private void addFolder(InventoryFolderBase folder, bool add)
- {
- lock (ds)
- {
- DataTable inventoryFolderTable = ds.Tables["inventoryfolders"];
- DataRow inventoryRow = inventoryFolderTable.Rows.Find(Util.ToRawUuidString(folder.ID));
- if (inventoryRow == null)
- {
- if (! add)
- m_log.ErrorFormat("Interface Misuse: Attempting to Update non-existant inventory folder: {0}", folder.ID);
- inventoryRow = inventoryFolderTable.NewRow();
- fillFolderRow(inventoryRow, folder);
- inventoryFolderTable.Rows.Add(inventoryRow);
- }
- else
- {
- if (add)
- m_log.ErrorFormat("Interface Misuse: Attempting to Add inventory folder that already exists: {0}", folder.ID);
- fillFolderRow(inventoryRow, folder);
- }
- invFoldersDa.Update(ds, "inventoryfolders");
- }
- }
- /// <summary>
- /// Move an inventory folder
- /// </summary>
- /// <param name="folder">folder base</param>
- private void moveFolder(InventoryFolderBase folder)
- {
- lock (ds)
- {
- DataTable inventoryFolderTable = ds.Tables["inventoryfolders"];
- DataRow inventoryRow = inventoryFolderTable.Rows.Find(Util.ToRawUuidString(folder.ID));
- if (inventoryRow == null)
- {
- inventoryRow = inventoryFolderTable.NewRow();
- fillFolderRow(inventoryRow, folder);
- inventoryFolderTable.Rows.Add(inventoryRow);
- }
- else
- {
- moveFolderRow(inventoryRow, folder);
- }
- invFoldersDa.Update(ds, "inventoryfolders");
- }
- }
- /// <summary>
- /// add an item in inventory
- /// </summary>
- /// <param name="item">the item</param>
- /// <param name="add">true=add item ; false=update existing item</param>
- private void addItem(InventoryItemBase item, bool add)
- {
- lock (ds)
- {
- DataTable inventoryItemTable = ds.Tables["inventoryitems"];
- DataRow inventoryRow = inventoryItemTable.Rows.Find(Util.ToRawUuidString(item.ID));
- if (inventoryRow == null)
- {
- if (! add)
- m_log.ErrorFormat("[INVENTORY DB]: Interface Misuse: Attempting to Update non-existant inventory item: {0}", item.ID);
- inventoryRow = inventoryItemTable.NewRow();
- fillItemRow(inventoryRow, item);
- inventoryItemTable.Rows.Add(inventoryRow);
- }
- else
- {
- if (add)
- m_log.ErrorFormat("[INVENTORY DB]: Interface Misuse: Attempting to Add inventory item that already exists: {0}", item.ID);
- fillItemRow(inventoryRow, item);
- }
- invItemsDa.Update(ds, "inventoryitems");
- }
- }
- /// <summary>
- /// TODO : DataSet commit
- /// </summary>
- public void Shutdown()
- {
- // TODO: DataSet commit
- }
- /// <summary>
- /// Closes the inventory interface
- /// </summary>
- public void Close()
- {
- }
- /// <summary>
- /// The name of this DB provider
- /// </summary>
- /// <returns>Name of DB provider</returns>
- public string getName()
- {
- return "SQLite Inventory Data Interface";
- }
- /// <summary>
- /// Returns the version of this DB provider
- /// </summary>
- /// <returns>A string containing the DB provider version</returns>
- public string getVersion()
- {
- Module module = GetType().Module;
- // string dllName = module.Assembly.ManifestModule.Name;
- Version dllVersion = module.Assembly.GetName().Version;
- return
- string.Format("{0}.{1}.{2}.{3}", dllVersion.Major, dllVersion.Minor, dllVersion.Build,
- dllVersion.Revision);
- }
- /// <summary>
- /// Returns a list of inventory items contained within the specified folder
- /// </summary>
- /// <param name="folderID">The UUID of the target folder</param>
- /// <returns>A List of InventoryItemBase items</returns>
- public List<InventoryItemBase> getInventoryInFolder(LLUUID folderID)
- {
- lock (ds)
- {
- List<InventoryItemBase> retval = new List<InventoryItemBase>();
- DataTable inventoryItemTable = ds.Tables["inventoryitems"];
- string selectExp = "parentFolderID = '" + Util.ToRawUuidString(folderID) + "'";
- DataRow[] rows = inventoryItemTable.Select(selectExp);
- foreach (DataRow row in rows)
- {
- retval.Add(buildItem(row));
- }
- return retval;
- }
- }
- /// <summary>
- /// Returns a list of the root folders within a users inventory
- /// </summary>
- /// <param name="user">The user whos inventory is to be searched</param>
- /// <returns>A list of folder objects</returns>
- public List<InventoryFolderBase> getUserRootFolders(LLUUID user)
- {
- return new List<InventoryFolderBase>();
- }
- // see InventoryItemBase.getUserRootFolder
- public InventoryFolderBase getUserRootFolder(LLUUID user)
- {
- lock (ds)
- {
- List<InventoryFolderBase> folders = new List<InventoryFolderBase>();
- DataTable inventoryFolderTable = ds.Tables["inventoryfolders"];
- string selectExp = "agentID = '" + Util.ToRawUuidString(user) + "' AND parentID = '" +
- Util.ToRawUuidString(LLUUID.Zero) + "'";
- DataRow[] rows = inventoryFolderTable.Select(selectExp);
- foreach (DataRow row in rows)
- {
- folders.Add(buildFolder(row));
- }
- // There should only ever be one root folder for a user. However, if there's more
- // than one we'll simply use the first one rather than failing. It would be even
- // nicer to print some message to this effect, but this feels like it's too low a
- // to put such a message out, and it's too minor right now to spare the time to
- // suitably refactor.
- if (folders.Count > 0)
- {
- return folders[0];
- }
- return null;
- }
- }
- /// <summary>
- /// Append a list of all the child folders of a parent folder
- /// </summary>
- /// <param name="folders">list where folders will be appended</param>
- /// <param name="parentID">ID of parent</param>
- protected void getInventoryFolders(ref List<InventoryFolderBase> folders, LLUUID parentID)
- {
- lock (ds)
- {
- DataTable inventoryFolderTable = ds.Tables["inventoryfolders"];
- string selectExp = "parentID = '" + Util.ToRawUuidString(parentID) + "'";
- DataRow[] rows = inventoryFolderTable.Select(selectExp);
- foreach (DataRow row in rows)
- {
- folders.Add(buildFolder(row));
- }
- }
- }
- /// <summary>
- /// Returns a list of inventory folders contained in the folder 'parentID'
- /// </summary>
- /// <param name="parentID">The folder to get subfolders for</param>
- /// <returns>A list of inventory folders</returns>
- public List<InventoryFolderBase> getInventoryFolders(LLUUID parentID)
- {
- List<InventoryFolderBase> folders = new List<InventoryFolderBase>();
- getInventoryFolders(ref folders, Util.ToRawUuidString(parentID));
- return folders;
- }
- /// <summary>
- /// See IInventoryData
- /// </summary>
- /// <param name="parentID"></param>
- /// <returns></returns>
- public List<InventoryFolderBase> getFolderHierarchy(LLUUID parentID)
- {
- List<InventoryFolderBase> folders = new List<InventoryFolderBase>();
- getInventoryFolders(ref folders, Util.ToRawUuidString(parentID));
- for (int i = 0; i < folders.Count; i++)
- getInventoryFolders(ref folders, Util.ToRawUuidString(folders[i].ID));
- return folders;
- }
- /// <summary>
- /// Returns an inventory item by its UUID
- /// </summary>
- /// <param name="item">The UUID of the item to be returned</param>
- /// <returns>A class containing item information</returns>
- public InventoryItemBase getInventoryItem(LLUUID item)
- {
- lock (ds)
- {
- DataRow row = ds.Tables["inventoryitems"].Rows.Find(Util.ToRawUuidString(item));
- if (row != null)
- {
- return buildItem(row);
- }
- else
- {
- return null;
- }
- }
- }
- /// <summary>
- /// Returns a specified inventory folder by its UUID
- /// </summary>
- /// <param name="folder">The UUID of the folder to be returned</param>
- /// <returns>A class containing folder information</returns>
- public InventoryFolderBase getInventoryFolder(LLUUID folder)
- {
- // TODO: Deep voodoo here. If you enable this code then
- // multi region breaks. No idea why, but I figured it was
- // better to leave multi region at this point. It does mean
- // that you don't get to see system textures why creating
- // clothes and the like. :(
- lock (ds)
- {
- DataRow row = ds.Tables["inventoryfolders"].Rows.Find(Util.ToRawUuidString(folder));
- if (row != null)
- {
- return buildFolder(row);
- }
- else
- {
- return null;
- }
- }
- }
- /// <summary>
- /// Creates a new inventory item based on item
- /// </summary>
- /// <param name="item">The item to be created</param>
- public void addInventoryItem(InventoryItemBase item)
- {
- addItem(item, true);
- }
- /// <summary>
- /// Updates an inventory item with item (updates based on ID)
- /// </summary>
- /// <param name="item">The updated item</param>
- public void updateInventoryItem(InventoryItemBase item)
- {
- addItem(item, false);
- }
- /// <summary>
- /// Delete an inventory item
- /// </summary>
- /// <param name="item">The item UUID</param>
- public void deleteInventoryItem(LLUUID itemID)
- {
- lock (ds)
- {
- DataTable inventoryItemTable = ds.Tables["inventoryitems"];
- DataRow inventoryRow = inventoryItemTable.Rows.Find(Util.ToRawUuidString(itemID));
- if (inventoryRow != null)
- {
- inventoryRow.Delete();
- }
- invItemsDa.Update(ds, "inventoryitems");
- }
- }
- /// <summary>
- /// Delete all items in the specified folder
- /// </summary>
- /// <param name="folderId">id of the folder, whose item content should be deleted</param>
- /// <todo>this is horribly inefficient, but I don't want to ruin the overall structure of this implementation</todo>
- private void deleteItemsInFolder(LLUUID folderId)
- {
- List<InventoryItemBase> items = getInventoryInFolder(Util.ToRawUuidString(folderId));
- foreach (InventoryItemBase i in items)
- deleteInventoryItem(Util.ToRawUuidString(i.ID));
- }
- /// <summary>
- /// Adds a new folder specified by folder
- /// </summary>
- /// <param name="folder">The inventory folder</param>
- public void addInventoryFolder(InventoryFolderBase folder)
- {
- addFolder(folder, true);
- }
- /// <summary>
- /// Updates a folder based on its ID with folder
- /// </summary>
- /// <param name="folder">The inventory folder</param>
- public void updateInventoryFolder(InventoryFolderBase folder)
- {
- addFolder(folder, false);
- }
- /// <summary>
- /// Moves a folder based on its ID with folder
- /// </summary>
- /// <param name="folder">The inventory folder</param>
- public void moveInventoryFolder(InventoryFolderBase folder)
- {
- moveFolder(folder);
- }
- /// <summary>
- /// Delete a folder
- /// </summary>
- /// <remarks>
- /// This will clean-up any child folders and child items as well
- /// </remarks>
- /// <param name="folderID">the folder UUID</param>
- public void deleteInventoryFolder(LLUUID folderID)
- {
- lock (ds)
- {
- List<InventoryFolderBase> subFolders = getFolderHierarchy(Util.ToRawUuidString(folderID));
- DataTable inventoryFolderTable = ds.Tables["inventoryfolders"];
- DataRow inventoryRow;
- //Delete all sub-folders
- foreach (InventoryFolderBase f in subFolders)
- {
- inventoryRow = inventoryFolderTable.Rows.Find(Util.ToRawUuidString(f.ID));
- if (inventoryRow != null)
- {
- deleteItemsInFolder(Util.ToRawUuidString(f.ID));
- inventoryRow.Delete();
- }
- }
- //Delete the actual row
- inventoryRow = inventoryFolderTable.Rows.Find(Util.ToRawUuidString(folderID));
- if (inventoryRow != null)
- {
- deleteItemsInFolder(Util.ToRawUuidString(folderID));
- inventoryRow.Delete();
- }
- invFoldersDa.Update(ds, "inventoryfolders");
- }
- }
- /***********************************************************************
- *
- * Data Table definitions
- *
- **********************************************************************/
- /// <summary>
- /// Create the "inventoryitems" table
- /// </summary>
- private static DataTable createInventoryItemsTable()
- {
- DataTable inv = new DataTable("inventoryitems");
- createCol(inv, "UUID", typeof (String)); //inventoryID
- createCol(inv, "assetID", typeof (String));
- createCol(inv, "assetType", typeof (Int32));
- createCol(inv, "invType", typeof (Int32));
- createCol(inv, "parentFolderID", typeof (String));
- createCol(inv, "avatarID", typeof (String));
- createCol(inv, "creatorsID", typeof (String));
- createCol(inv, "inventoryName", typeof (String));
- createCol(inv, "inventoryDescription", typeof (String));
- // permissions
- createCol(inv, "inventoryNextPermissions", typeof (Int32));
- createCol(inv, "inventoryCurrentPermissions", typeof (Int32));
- createCol(inv, "inventoryBasePermissions", typeof (Int32));
- createCol(inv, "inventoryEveryOnePermissions", typeof (Int32));
- // sale info
- createCol(inv, "salePrice", typeof(Int32));
- createCol(inv, "saleType", typeof(Byte));
- // creation date
- createCol(inv, "creationDate", typeof(Int32));
- // group info
- createCol(inv, "groupID", typeof(String));
- createCol(inv, "groupOwned", typeof(Boolean));
- // Flags
- createCol(inv, "flags", typeof(UInt32));
- inv.PrimaryKey = new DataColumn[] { inv.Columns["UUID"] };
- return inv;
- }
- /// <summary>
- /// Creates the "inventoryfolders" table
- /// </summary>
- /// <returns></returns>
- private static DataTable createInventoryFoldersTable()
- {
- DataTable fol = new DataTable("inventoryfolders");
- createCol(fol, "UUID", typeof (String)); //folderID
- createCol(fol, "name", typeof (String));
- createCol(fol, "agentID", typeof (String));
- createCol(fol, "parentID", typeof (String));
- createCol(fol, "type", typeof (Int32));
- createCol(fol, "version", typeof (Int32));
- fol.PrimaryKey = new DataColumn[] {fol.Columns["UUID"]};
- return fol;
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="da"></param>
- /// <param name="conn"></param>
- private void setupItemsCommands(SqliteDataAdapter da, SqliteConnection conn)
- {
- lock (ds)
- {
- da.InsertCommand = createInsertCommand("inventoryitems", ds.Tables["inventoryitems"]);
- da.InsertCommand.Connection = conn;
- da.UpdateCommand = createUpdateCommand("inventoryitems", "UUID=:UUID", ds.Tables["inventoryitems"]);
- da.UpdateCommand.Connection = conn;
- SqliteCommand delete = new SqliteCommand("delete from inventoryitems where UUID = :UUID");
- delete.Parameters.Add(createSqliteParameter("UUID", typeof(String)));
- delete.Connection = conn;
- da.DeleteCommand = delete;
- }
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="da"></param>
- /// <param name="conn"></param>
- private void setupFoldersCommands(SqliteDataAdapter da, SqliteConnection conn)
- {
- lock (ds)
- {
- da.InsertCommand = createInsertCommand("inventoryfolders", ds.Tables["inventoryfolders"]);
- da.InsertCommand.Connection = conn;
- da.UpdateCommand = createUpdateCommand("inventoryfolders", "UUID=:UUID", ds.Tables["inventoryfolders"]);
- da.UpdateCommand.Connection = conn;
- SqliteCommand delete = new SqliteCommand("delete from inventoryfolders where UUID = :UUID");
- delete.Parameters.Add(createSqliteParameter("UUID", typeof(String)));
- delete.Connection = conn;
- da.DeleteCommand = delete;
- }
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="row"></param>
- /// <returns></returns>
- private static InventoryFolderBase buildFolder(DataRow row)
- {
- InventoryFolderBase folder = new InventoryFolderBase();
- folder.ID = new LLUUID((string) row["UUID"]);
- folder.Name = (string) row["name"];
- folder.Owner = new LLUUID((string) row["agentID"]);
- folder.ParentID = new LLUUID((string) row["parentID"]);
- folder.Type = Convert.ToInt16(row["type"]);
- folder.Version = Convert.ToUInt16(row["version"]);
- return folder;
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="row"></param>
- /// <param name="folder"></param>
- private static void fillFolderRow(DataRow row, InventoryFolderBase folder)
- {
- row["UUID"] = Util.ToRawUuidString(folder.ID);
- row["name"] = folder.Name;
- row["agentID"] = Util.ToRawUuidString(folder.Owner);
- row["parentID"] = Util.ToRawUuidString(folder.ParentID);
- row["type"] = folder.Type;
- row["version"] = folder.Version;
- }
- /// <summary>
- ///
- /// </summary>
- /// <param name="row"></param>
- /// <param name="folder"></param>
- private static void moveFolderRow(DataRow row, InventoryFolderBase folder)
- {
- row["UUID"] = Util.ToRawUuidString(folder.ID);
- row["parentID"] = Util.ToRawUuidString(folder.ParentID);
- }
- /***********************************************************************
- *
- * Test and Initialization code
- *
- **********************************************************************/
- /// <summary>
- ///
- /// </summary>
- /// <param name="conn"></param>
- // private static void InitDB(SqliteConnection conn)
- // {
- // string createInventoryItems = defineTable(createInventoryItemsTable());
- // string createInventoryFolders = defineTable(createInventoryFoldersTable());
- // SqliteCommand pcmd = new SqliteCommand(createInventoryItems, conn);
- // SqliteCommand scmd = new SqliteCommand(createInventoryFolders, conn);
- // pcmd.ExecuteNonQuery();
- // scmd.ExecuteNonQuery();
- // }
- /// <summary>
- ///
- /// </summary>
- /// <param name="conn"></param>
- /// <param name="m"></param>
- /// <returns></returns>
- private static bool TestTables(SqliteConnection conn, Migration m)
- {
- SqliteCommand invItemsSelectCmd = new SqliteCommand(invItemsSelect, conn);
- SqliteDataAdapter pDa = new SqliteDataAdapter(invItemsSelectCmd);
- SqliteCommand invFoldersSelectCmd = new SqliteCommand(invFoldersSelect, conn);
- SqliteDataAdapter sDa = new SqliteDataAdapter(invFoldersSelectCmd);
- DataSet tmpDS = new DataSet();
- try
- {
- pDa.Fill(tmpDS, "inventoryitems");
- sDa.Fill(tmpDS, "inventoryfolders");
- }
- catch (SqliteSyntaxException)
- {
- m_log.Info("[INVENTORY DB]: SQLite Database doesn't exist... creating");
- return false;
- }
- if (m.Version == 0)
- m.Version = 1;
- return true;
- // pDa.Fill(tmpDS, "inventoryitems");
- // sDa.Fill(tmpDS, "inventoryfolders");
- // // Very clumsy way of checking whether we need to upgrade the database table version and then updating. Only
- // // putting up with this because this code should be blown away soon by nhibernate...
- // conn.Open();
- // SqliteCommand cmd;
- // try
- // {
- // cmd = new SqliteCommand("select salePrice from inventoryitems limit 1;", conn);
- // cmd.ExecuteNonQuery();
- // }
- // catch (SqliteSyntaxException)
- // {
- // m_log.Info("[INVENTORY DB]: Upgrading sqlite inventory database to version 2");
- // cmd = new SqliteCommand("alter table inventoryitems add column salePrice integer default 99;", conn);
- // cmd.ExecuteNonQuery();
- // cmd = new SqliteCommand("alter table inventoryitems add column saleType integer default 0;", conn);
- // cmd.ExecuteNonQuery();
- // cmd = new SqliteCommand("alter table inventoryitems add column creationDate integer default 2000;", conn);
- // cmd.ExecuteNonQuery();
- // cmd = new SqliteCommand("alter table inventoryitems add column groupID varchar(255) default '00000000-0000-0000-0000-000000000000';", conn);
- // cmd.ExecuteNonQuery();
- // cmd = new SqliteCommand("alter table inventoryitems add column groupOwned integer default 0;", conn);
- // cmd.ExecuteNonQuery();
- // cmd = new SqliteCommand("alter table inventoryitems add column flags integer default 0;", conn);
- // cmd.ExecuteNonQuery();
- // pDa.Fill(tmpDS, "inventoryitems");
- // }
- // finally
- // {
- // conn.Close();
- // }
- // foreach (DataColumn col in createInventoryItemsTable().Columns)
- // {
- // if (! tmpDS.Tables["inventoryitems"].Columns.Contains(col.ColumnName))
- // {
- // m_log.Info("[INVENTORY DB]: Missing required column:" + col.ColumnName);
- // return false;
- // }
- // }
- // foreach (DataColumn col in createInventoryFoldersTable().Columns)
- // {
- // if (! tmpDS.Tables["inventoryfolders"].Columns.Contains(col.ColumnName))
- // {
- // m_log.Info("[INVENTORY DB]: Missing required column:" + col.ColumnName);
- // return false;
- // }
- // }
- // return true;
- }
- }
- }
|