/// <summary>
/// 获取文件流
/// </summary>
/// <param name="host"></param>
/// <param name="id">文件id，fs.files中的_id，也对应fs.chunks的files_id</param>
/// <param name="options">下载选项</param>
public static Stream DownloadFileToStream(MongodbHost host, BsonValue id, GridFSDownloadOptions options = null)
{
Stream destination = new MemoryStream();
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
bucket.DownloadToStream(id, destination, options);
return(destination);
}
/// <summary>
/// 上传文件流，并附上元数据
/// </summary>
/// <param name="host"></param>
/// <param name="fileName"></param>
/// <param name="source"></param>
/// <param name="metadata"></param>
/// <returns></returns>
public static ObjectId UploadFileFromStream(MongodbHost host, string fileName, Stream source, IDictionary <string, object> metadata)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
GridFSUploadOptions options = new GridFSUploadOptions
{
Metadata = new BsonDocument(metadata)
};
return(bucket.UploadFromStream(fileName, source, options));
}
/// <summary>
///
/// </summary>
/// <param name="host"></param>
/// <param name="filePath">文件完整路径</param>
/// <param name="options"></param>
/// <returns></returns>
public static ObjectId UploadFileFromPath(MongodbHost host, string filePath, GridFSUploadOptions options = null)
{
if (!File.Exists(filePath))
{
throw new Exception($"{filePath} does not exist");
}
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
FileStream fileStream = new FileStream(filePath, FileMode.Open);
return(bucket.UploadFromStream(Path.GetFileName(filePath), fileStream, options));
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="filter">删除的条件</param>
/// <returns></returns>
public static DeleteResult DeleteMany(MongodbHost host, FilterDefinition <T> filter)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
return(client.DeleteMany(filter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <param name="database"></param>
/// <param name="filter"></param>
/// <returns></returns>
public static DeleteResult DeleteMany(IMongoDatabase database, FilterDefinition <T> filter)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(database);
return(client.DeleteMany(filter));
}
catch (Exception ex)
{
throw ex;
}
}
public static async Task <DeleteResult> DeleteManyAsync(IMongoDatabase host, FilterDefinition <T> filter)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
return(await client.DeleteManyAsync(filter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据条件获取总数
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="filter">条件</param>
/// <returns></returns>
public static long Count(MongodbHost host, FilterDefinition <T> filter)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
return(client.CountDocuments(filter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 异步根据条件获取总数
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="filter">条件</param>
/// <returns></returns>
public static async Task <long> CountAsync(MongodbHost host, FilterDefinition <T> filter)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
return(await client.CountAsync(filter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="t">添加的实体</param>
/// <param name="host">mongodb连接信息</param>
/// <returns></returns>
public static int Add(MongodbHost host, T t)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
client.InsertOne(t);
return(1);
}
catch
{
return(0);
}
}
/// <summary>
/// 重命名所有匹配的文件
/// </summary>
/// <param name="host"></param>
/// <param name="oldFilename"></param>
/// <param name="newFilename"></param>
public static void RenameAllfile(MongodbHost host, string oldFilename, string newFilename)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
var filter = Builders <GridFSFileInfo> .Filter.Eq(x => x.Filename, oldFilename);
var filesCursor = bucket.Find(filter);
var files = filesCursor.ToList();
foreach (var file in files)
{
bucket.Rename(file.Id, newFilename);
}
}
/// <summary>
/// 插入记录
/// </summary>
/// <param name="mongoDataBase"></param>
/// <param name="t"></param>
/// <returns></returns>
public static int Add(IMongoDatabase mongoDataBase, T t)
{
try
{
var collection = MongodbManager <T> .GetMongodbCollection(mongoDataBase);
collection.InsertOne(t);
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 异步添加一条数据
/// </summary>
/// <param name="t">添加的实体</param>
/// <param name="host">mongodb连接信息</param>
/// <returns></returns>
public static async Task <int> AddAsync(MongodbHost host, T t)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
await client.InsertOneAsync(t);
return(1);
}
catch
{
return(0);
}
}
/// <summary>
/// 批量插入
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="t">实体集合</param>
/// <returns></returns>
public static int InsertMany(MongodbHost host, List <T> t)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
client.InsertMany(t);
return(1);
}
catch (Exception ex)
{
LOG.Error(ex);
return(0);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="id">objectId</param>
/// <returns></returns>
public static DeleteResult Delete(MongodbHost host, string id)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
FilterDefinition <T> filter = Builders <T> .Filter.Eq("_id", new ObjectId(id));
return(client.DeleteOne(filter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 异步删除一条数据
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="id">objectId</param>
/// <returns></returns>
public static async Task <DeleteResult> DeleteAsync(MongodbHost host, string id)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
//修改条件
FilterDefinition <T> filter = Builders <T> .Filter.Eq("_id", new ObjectId(id));
return(await client.DeleteOneAsync(filter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 从本地路径上传文件
/// </summary>
/// <param name="host"></param>
/// <param name="filePath"></param>
/// <param name="metadata"></param>
/// <returns></returns>
public static ObjectId UploadFileFromPath(MongodbHost host, string filePath, IDictionary <string, object> metadata)
{
if (!File.Exists(filePath))
{
throw new Exception($"{filePath} does not exist");
}
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
GridFSUploadOptions options = new GridFSUploadOptions
{
Metadata = new BsonDocument(metadata)
};
FileStream fileStream = new FileStream(filePath, FileMode.Open);
return(bucket.UploadFromStream(fileStream.Name, fileStream, options));
}
/// <summary>
/// 根据文件名查找所有匹配的文件
/// </summary>
/// <param name="host">mongo服务器信息</param>
/// <param name="fileName">文件名称</param>
/// <returns></returns>
public static IAsyncCursor <GridFSFileInfo> FindFiles(MongodbHost host, string fileName)
{
var filter = Builders <GridFSFileInfo> .Filter.And(
Builders <GridFSFileInfo> .Filter.Eq(x => x.Filename, fileName)
// Builders<GridFSFileInfo>.Filter.Eq("metadata.UserID", fileName)
);
var sort = Builders <GridFSFileInfo> .Sort.Descending(x => x.UploadDateTime);
var options = new GridFSFindOptions
{
// Limit = 1,
Sort = sort
};
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
return(bucket.Find(filter, options));
}
/// <summary>
/// 根据元数据查找文件集合
/// </summary>
/// <param name="host"></param>
/// <param name="metadatas"></param>
/// <returns></returns>
public static IAsyncCursor <GridFSFileInfo> FindFiles(MongodbHost host, IDictionary <string, object> metadatas)
{
IList <FilterDefinition <GridFSFileInfo> > filters = new List <FilterDefinition <GridFSFileInfo> >();
foreach (var item in metadatas)
{
filters.Add(Builders <GridFSFileInfo> .Filter.Eq(item.Key, item.Value));
}
var sort = Builders <GridFSFileInfo> .Sort.Descending(x => x.UploadDateTime);
var options = new GridFSFindOptions
{
Limit = 1,
Sort = sort
};
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
return(bucket.Find(Builders <GridFSFileInfo> .Filter.And(filters), options));
}
/// <summary>
/// 分页查询集合
/// </summary>
/// <param name="host">mongodb连接信息</param>
/// <param name="filter">查询条件</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">页容量</param>
/// <param name="count">总条数</param>
/// <param name="field">要查询的字段,不写时查询全部</param>
/// <param name="sort">要排序的字段</param>
/// <returns></returns>
public static List <T> FindListByPage(MongodbHost host, FilterDefinition <T> filter, int pageIndex, int pageSize, out long count, string[] field = null, SortDefinition <T> sort = null)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(host);
count = client.CountDocuments(filter);
//不指定查询字段
if (field == null || field.Length == 0)
{
if (sort == null)
{
return(client.Find(filter).Skip((pageIndex - 1) * pageSize).Limit(pageSize).ToList());
}
//进行排序
return(client.Find(filter).Sort(sort).Skip((pageIndex - 1) * pageSize).Limit(pageSize).ToList());
}
//制定查询字段
var fieldList = new List <ProjectionDefinition <T> >();
for (int i = 0; i < field.Length; i++)
{
fieldList.Add(Builders <T> .Projection.Include(field[i].ToString()));
}
var projection = Builders <T> .Projection.Combine(fieldList);
fieldList?.Clear();
//不排序
if (sort == null)
{
return(client.Find(filter).Project <T>(projection).Skip((pageIndex - 1) * pageSize).Limit(pageSize).ToList());
}
//排序查询
return(client.Find(filter).Sort(sort).Project <T>(projection).Skip((pageIndex - 1) * pageSize).Limit(pageSize).ToList());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查找唯一文件
/// </summary>
/// <param name="database"></param>
/// <param name="metadatas"></param>
/// <returns></returns>
public static GridFSFileInfo FindSingleFile(IMongoDatabase database, IDictionary <string, object> metadatas)
{
IList <FilterDefinition <GridFSFileInfo> > filters = new List <FilterDefinition <GridFSFileInfo> >();
foreach (var item in metadatas)
{
filters.Add(Builders <GridFSFileInfo> .Filter.Eq(item.Key, item.Value));
}
var sort = Builders <GridFSFileInfo> .Sort.Descending(x => x.UploadDateTime);
var options = new GridFSFindOptions
{
Limit = 1,
Sort = sort
};
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(database);
using (var cursor = bucket.Find(Builders <GridFSFileInfo> .Filter.And(filters), options))
{
return(cursor.ToList().FirstOrDefault());
}
}
public static List <T> FindList(IMongoDatabase database, FilterDefinition <T> filter, string[] field = null, SortDefinition <T> sort = null)
{
try
{
var client = MongodbManager <T> .GetMongodbCollection(database);
//不指定查询字段
if (field == null || field.Length == 0)
{
if (sort == null)
{
return(client.Find(filter).ToList());
}
//进行排序
return(client.Find(filter).Sort(sort).ToList());
}
//制定查询字段
var fieldList = new List <ProjectionDefinition <T> >();
for (int i = 0; i < field.Length; i++)
{
fieldList.Add(Builders <T> .Projection.Include(field[i].ToString()));
}
var projection = Builders <T> .Projection.Combine(fieldList);
fieldList?.Clear();
if (sort == null)
{
return(client.Find(filter).Project <T>(projection).ToList());
}
//排序查询
return(client.Find(filter).Sort(sort).Project <T>(projection).ToList());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据文件名下载文件字节数组
/// </summary>
/// <param name="host"></param>
/// <param name="fileName"></param>
/// <returns></returns>
public static Byte[] DownloadFileAsBytesByName(MongodbHost host, string fileName)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
return(bucket.DownloadAsBytesByName(fileName));
}
/// <summary>
/// 同步上传
/// </summary>
/// <param name="database"></param>
/// <param name="fileName"></param>
/// <param name="source"></param>
/// <param name="options"></param>
/// <returns></returns>
public static ObjectId UploadFileFromStream(IMongoDatabase database, string fileName, Stream source, GridFSUploadOptions options = null)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(database);
return(bucket.UploadFromStream(fileName, source, options));
}
/// <summary>
/// 获取文件字节数组
/// </summary>
/// <param name="database"></param>
/// <param name="fileName"></param>
/// <returns></returns>
public static Byte[] DownloadFileAsBytesByName(IMongoDatabase database, string fileName)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(database);
return(bucket.DownloadAsBytesByName(fileName));
}
/// <summary>
/// 异步通过字节流上传文件
/// </summary>
/// <param name="host"></param>
/// <param name="fileName">文件名</param>
/// <param name="source">文件字节</param>
/// <param name="options"></param>
/// <returns></returns>
public static Task <ObjectId> UploadFileFromBytesAsync(MongodbHost host, string fileName, byte[] source, GridFSUploadOptions options = null)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
return(bucket.UploadFromBytesAsync(fileName, source, options));
}
/// <summary>
/// 查找操作
/// </summary>
/// <param name="host">mongodb服务器信息</param>
/// <param name="filter">查询过滤器</param>
/// <param name="options">查找选项</param>
/// <returns></returns>
public static IAsyncCursor <GridFSFileInfo> FindFiles(MongodbHost host, FilterDefinition <GridFSFileInfo> filter, GridFSFindOptions options = null)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
return(bucket.Find(filter, options));
}
/// <summary>
/// 重命名
/// </summary>
/// <param name="host">mongo服务器信息</param>
/// <param name="id">文件id，fs.files中的_id，也对应fs.chunks的files_id</param>
/// <param name="newFileName">新文件名称</param>
public static void RenameFile(MongodbHost host, BsonValue id, string newFileName)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
bucket.Rename(id, newFileName);
}
/// <summary>
/// 根据ObjectId删除文件
/// </summary>
/// <param name="database"></param>
/// <param name="id"></param>
public static void DeleteFileById(IMongoDatabase database, ObjectId id)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(database);
bucket.Delete(id);
}
/// <summary>
/// 根据ObjectId删除文件
/// </summary>
/// <param name="host"></param>
/// <param name="id">ObjectId</param>
public static void DeleteFileById(MongodbHost host, ObjectId id)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
bucket.Delete(id);
}
/// <summary>
/// 删除fs数据库
/// </summary>
/// <param name="host"></param>
public static void DropFS(MongodbHost host)
{
var bucket = MongodbManager <GridFSBucket> .GetGridFSBucket(host);
bucket.Drop();
}