public BookRepository()
{
var mClient = new MongoClient(LibraryMongo.Properties.Settings.Default.LibraryConnectionString);
mDb = mClient.GetDatabase("Library");
books = mDb.GetCollection <Books>("Books");
}
public CustomerService(ICustomerDatabaseSettings settings)
{
var client = new MongoClient(settings.ConnectionString);
var database = client.GetDatabase(settings.DatabaseName);
_customers = database.GetCollection <Customer>(settings.CustomersCollectionName);
}
public DataModelsController()
{
MongoDB.Driver.MongoClient client = new MongoDB.Driver.MongoClient();
_db = client.GetDatabase(ConfigurationManager.AppSettings["dbname"]);
_models = _db.GetCollection <DataModel>("data_models");
_entityController = new EntityModelsController();
}
public InformationService(IOptions <BoMayDatabaseSettings> setting)
{
_settings = setting.Value;
var client = new MongoClient(_settings.ConnectionString);
var database = client.GetDatabase(_settings.DatabaseName);
Informations = database.GetCollection <Information>(_settings.BoMaysCollectionName);
}
public UserService(IOptions <AppSettings> appSettings)
{
_appSettings = appSettings.Value;
var client = new MongoClient(_appSettings.ConnectionString);
var database = client.GetDatabase(_appSettings.Database);
_users = database.GetCollection <User>("Users");
}
public UserService()
{
try
{
var mClient = new MongoClient(FixedAsset_MVC.Properties.Settings.Default.FixedAssetsConnectionString);
mDb = mClient.GetDatabase("FIXED_ASSET");
users = mDb.GetCollection <User>("users");
}
catch (Exception)
{
serverDown = true;
}
}
/// <summary>
/// For a given VHO #, add any new unique AltCodes into our member vho
/// When completed a VHO, cache this in the DB
/// </summary>
/// <param name="vhoNumber"></param>
public async Task <bool> AddUniqueFromVHOAsync(MongoDB.Driver.IMongoCollection <CatalogObject> collection)
{
Dictionary <string, CatalogObject> vho = new Dictionary <string, CatalogObject>();
string path = GetTemplate(vhoNumber, "d:\\img\\img\\", new DateTime(2015, 7, 21));
if (path != string.Empty)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Processing VHO : " + vhoNumber);
Console.ForegroundColor = ConsoleColor.White;
try
{
String tempFile = Decompress(path);
using (StreamReader file = new System.IO.StreamReader(tempFile, Encoding.UTF8))
{
string line;
while ((line = await file.ReadLineAsync()) != null)
{
CatalogObject json = JsonConvert.DeserializeObject <CatalogObject>(line);
if ((json.AltCode == string.Empty))//blank AltCode, prob single screen
{
if (singleScreen)
{
//Use the PID PAID since the AltCode is missing
json.AltCode = json.ProviderID + ":" + json.ProviderAssetID.Substring(4);
await AddMediaAsync(collection, json);
}
}
else if (multiScreen)
{
await AddMediaAsync(collection, json);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception caught opening file :" + ex.Message);
}
}
//and Upsert the vho!
//await collection.InsertManyAsync(vho.Values);
return(true);
}
public UserRepository()
{
//var credential = MongoCredential.CreateMongoCRCredential("admin", "mongoAdmin", "$cR@m$H@1");
//var settings = new MongoClientSettings
//{
// Credentials = new[] { credential },
// Server = new MongoServerAddress("DEMO",4509)
//};
//var mClient = new MongoClient(settings);
var mClient = new MongoClient(Settings.Default.LibraryConnectionString);
mDb = mClient.GetDatabase("Library");
users = mDb.GetCollection <User>("Users");
try
{
//var mServer=mClient.GetServer();
//mServer.Ping();
}
catch (System.Exception ex)
{
serverDown = true;
}
}
public MongoRepository(IDatabaseSettings settings)
{
var db = new MongoClient(settings.ConnectionString).GetDatabase(settings.DatabaseName);
_collection = db.GetCollection <T>(GetCollectionName(typeof(T)));
}
static void MongoInsertFromAuthorities()
{
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
watch.Start();//开始计时
//DataSet ds = MySQLHelper.Query("SELECT Zone,Host,Data,Type,TTL,Mbox,Serial,Refresh,Retry,Expire,Minimum FROM authorities WHERE Zone IN (SELECT distinct Zone from zones WHERE NSState=1 ORDER BY Zone LIMIT 0,10000) ORDER BY Zone");
//DataSet ds = MySQLHelper.Query("SELECT a.Zone,Host,Data,Type,TTL,Mbox,Serial,Refresh,Retry,Expire,Minimum,t.userid FROM (SELECT DISTINCT zone,userid from zonestemp where nsstate=1 and isload=1 order BY zone LIMIT 0,500)as t inner join authorities as a on t.zone=a.Zone");
DataSet ds = MySQLHelper.Query("SELECT a.Zone,Host,Data,Type,TTL,Mbox,Serial,Refresh,Retry,Expire,Minimum,t.userid FROM (SELECT zone,userid,id from zonestemp where id in(1782993))as t inner join authorities as a on t.id=a.Zoneid");
long q = watch.ElapsedMilliseconds;
DataTable dt = ds.Tables[0];
int count = dt.Rows.Count;
Console.WriteLine("query use time：" + q.ToString() + ";" + count + " rows data");
int idx = 0;
List <AuthoritiesSimple>[] ala = new List <AuthoritiesSimple>[16] {
new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>(), new List <AuthoritiesSimple>()
};
List <AuthoritiesSimple> dl = new List <AuthoritiesSimple>();
List <DataRow> drl = new List <DataRow>();
string domain = "";
while (idx < count)
{
domain = dt.Rows[idx][0].ToString().ToLower() + ".";
string collectionname = StringHelper.CalculateMD5Hash(domain).ToLower().Substring(0, 1);
drl.Add(dt.Rows[idx]);
while (idx < (count - 1) && dt.Rows[idx][0].ToString() == dt.Rows[idx + 1][0].ToString())
{
drl.Add(dt.Rows[idx + 1]);
idx++;
}
if (drl.Count > 1)
{
dl = Row2Authorities(drl);
}
foreach (AuthoritiesSimple a in dl)
{
ala[Int32.Parse(collectionname, System.Globalization.NumberStyles.HexNumber)].Add(a);
}
idx++;
dl.Clear();
drl.Clear();
domain = "";
}
var client = DriverConfiguration.Client;
var db = client.GetDatabase(DriverConfiguration.DatabaseNamespace.DatabaseName);
for (int i = 0; i < 16; i++)
{
MongoDB.Driver.IMongoCollection <AuthoritiesSimple> collection = db.GetCollection <AuthoritiesSimple>(i.ToString("x"));
if (ala[i].Count > 0)
{
collection.InsertMany(ala[i]);
}
Console.WriteLine("List " + i.ToString("x") + " obj count " + ala[i].Count);
}
Console.WriteLine("{0} row inserted;use time {1}", idx, watch.ElapsedMilliseconds);
watch.Stop();//停止计时
//Console.WriteLine("{0} row inserted;use time {1}", idx, watch.ElapsedMilliseconds);
watch.Stop();//停止计时//305049 913076
}
public CourseRepository()
{
_context = ConnectionManager.GetContext().GetCollection <Course>("courses");
}
public async Task AddMediaAsync(MongoDB.Driver.IMongoCollection <CatalogObject> collection, CatalogObject json)
{
try
{
//var found = vho.TryGetValue(json.AltCode, out r);
var filter = Builders <CatalogObject> .Filter.Eq("AltCode", json.AltCode);
var found = await collection.Find(filter).ToListAsync();
if (found.Count > 0)
{
//check to see if its an exact copy, if it is then skip
var r = found[0];
if (r.GetHashCode() != json.GetHashCode())
{
if (json.IsHD)//only add values/updates from the HD version
{
//vho[json.AltCode] = json;
if (null != collection.Find(json.AltCode))
{
await collection.ReplaceOneAsync(x => x.AltCode == json.AltCode, json);
}
else
{
await collection.InsertOneAsync(json);
}
Compare(r, json);
}
else
{
//need to Add Avails data for nonHD here which requires making the private fields into a list of...
}
}
}
else
{
//Not this is unusual and an error
//So possible outcome here is we have same content but first four chars dont match, but content is same
//var dict = vho.Where(kvp => json.ProviderAssetID.Substring(4)).SelectMany(kvp => kvp.Value);
//var dict = vho.SelectMany(m => m).Where(k => vho.Keys.Contains(json.ProviderAssetID.Substring(4)));
/*var selectValues = (from keyValuePair in vho
* where keyValuePair.Key.Contains(json.ProviderAssetID.Substring(4))
* select keyValuePair.Value).ToList();
* if (selectValues.Count > 1)
* Console.WriteLine(vhoNumber + " : " + json.AltCode);
*/
//vho[json.AltCode] = json;
if (null == collection.Find(json.AltCode))
{
await collection.ReplaceOneAsync(x => x.AltCode == json.AltCode, json);
}
else
{
await collection.InsertOneAsync(json);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public EntityModelsController()
{
MongoDB.Driver.MongoClient client = new MongoDB.Driver.MongoClient();
_db = client.GetDatabase(ConfigurationManager.AppSettings["dbname"]);
_models = _db.GetCollection <EntityDefinition>("entity_definitions");
}
public AuthorRepository()
{
_context = ConnectionManager.GetContext().GetCollection <Author>("authors");
}
