Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            var con = new MongoDBConnection("Server=127.0.0.1;Port=27017;Database=cdactraining;");
            var cmd = new MongoDBCommand("SELECT * FROM employees", con);

            try
            {
                con.Open();
                var reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine(reader["empName"]);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
Ejemplo n.º 2
0
        public override bool Delete(string id)
        {
            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();

                using (MongoDBCommand cmd = new MongoDBCommand("delete from assets where id=?id", dbcon))
                {
                    cmd.Parameters.AddWithValue("?id", id);
                    cmd.ExecuteNonQuery();
                }
            }

            return true;
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Check if the assets exist in the database.
        /// </summary>
        /// <param name="uuidss">The assets' IDs</param>
        /// <returns>For each asset: true if it exists, false otherwise</returns>
        public override bool[] AssetsExist(UUID[] uuids)
        {
            if (uuids.Length == 0)
                return new bool[0];

            HashSet<UUID> exist = new HashSet<UUID>();

            string ids = "'" + string.Join("','", uuids) + "'";
            string sql = string.Format("SELECT id FROM assets WHERE id IN ({0})", ids);

            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();
                using (MongoDBCommand cmd = new MongoDBCommand(sql, dbcon))
                {
                    using (MongoDBDataReader dbReader = cmd.ExecuteReader())
                    {
                        while (dbReader.Read())
                        {
                            UUID id = DBGuid.FromDB(dbReader["id"]);
                            exist.Add(id);
                        }
                    }
                }
            }

            bool[] results = new bool[uuids.Length];
            for (int i = 0; i < uuids.Length; i++)
                results[i] = exist.Contains(uuids[i]);

            return results;
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Returns a list of AssetMetadata objects. The list is a subset of
        /// the entire data set offset by <paramref name="start" /> containing
        /// <paramref name="count" /> elements.
        /// </summary>
        /// <param name="start">The number of results to discard from the total data set.</param>
        /// <param name="count">The number of rows the returned list should contain.</param>
        /// <returns>A list of AssetMetadata objects.</returns>
        public override List<AssetMetadata> FetchAssetMetadataSet(int start, int count)
        {
            List<AssetMetadata> retList = new List<AssetMetadata>(count);

            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();

                using (MongoDBCommand cmd
                    = new MongoDBCommand(
                        "SELECT name,description,assetType,temporary,id,asset_flags,CreatorID FROM assets LIMIT ?start, ?count",
                        dbcon))
                {
                    cmd.Parameters.AddWithValue("?start", start);
                    cmd.Parameters.AddWithValue("?count", count);

                    try
                    {
                        using (MongoDBDataReader dbReader = cmd.ExecuteReader())
                        {
                            while (dbReader.Read())
                            {
                                AssetMetadata metadata = new AssetMetadata();
                                metadata.Name = (string)dbReader["name"];
                                metadata.Description = (string)dbReader["description"];
                                metadata.Type = (sbyte)dbReader["assetType"];
                                metadata.Temporary = Convert.ToBoolean(dbReader["temporary"]); // Not sure if this is correct.
                                metadata.Flags = (AssetFlags)Convert.ToInt32(dbReader["asset_flags"]);
                                metadata.FullID = DBGuid.FromDB(dbReader["id"]);
                                metadata.CreatorID = dbReader["CreatorID"].ToString();

                                // Current SHA1s are not stored/computed.
                                metadata.SHA1 = new byte[] { };

                                retList.Add(metadata);
                            }
                        }
                    }
                    catch (Exception e)
                    {
                        m_log.Error(
                            string.Format(
                                "[ASSETS DB]: MongoDB failure fetching asset set from {0}, count {1}.  Exception  ", 
                                start, count), 
                            e);
                    }
                }
            }

            return retList;
        }
Ejemplo n.º 5
0
        private void UpdateAccessTime(AssetBase asset)
        {

            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();

                using (MongoDBCommand cmd
                    = new MongoDBCommand("update assets set access_time=?access_time where id=?id", dbcon))
                {
                    try
                    {
                        using (cmd)
                        {
                            // create unix epoch time
                            int now = (int)Utils.DateTimeToUnixTime(DateTime.UtcNow);
                            cmd.Parameters.AddWithValue("?id", asset.ID);
                            cmd.Parameters.AddWithValue("?access_time", now);
                            cmd.ExecuteNonQuery();
                        }
                    }
                    catch (Exception e)
                    {
                        m_log.Error(
                            string.Format(
                                "[ASSETS DB]: Failure updating access_time for asset {0} with name {1}.  Exception  ", 
                                asset.FullID, asset.Name), 
                            e);
                    }
                }
            }
        }