Beispiel #1
0
        private void CleanUpDB(DocumentStore documentStore)
        {
            // This can fail the very first time the application runs as it will not yet have created the necessary schema objects,
            //  so we can just quietly move on
            try
            {
                var docSession = documentStore.OpenSession();
                var configInfo = docSession.Load<Config>("DinnerParty/Config");

                if(configInfo == null)
                {
                    configInfo = new Config();
                    configInfo.Id = "DinnerParty/Config";
                    configInfo.LastTruncateDate = DateTime.Now.AddHours(-48);
                    //No need to delete data if config doesnt exist but setup ready for next time

                    docSession.Store(configInfo);
                    docSession.SaveChanges();

                    return;
                }


                if((DateTime.Now - configInfo.LastTruncateDate).TotalHours < 24)
                    return;

                long docCount = 0, dbSize = 0;

                using(var cmd = docSession.Connection.CreateCommand())
                {
                    var dinnerTableName = documentStore.Schema.MappingFor(typeof(Dinner)).Table.QualifiedName;
                    cmd.CommandText = $"SELECT COUNT(*) FROM {dinnerTableName}";
                    docCount = (long)cmd.ExecuteScalar();
                }

                using(var cmd = docSession.Connection.CreateCommand())
                {
                    var dinnerPartyDbName = docSession.Connection.Database;
                    cmd.CommandText = $"SELECT pg_database_size('{dinnerPartyDbName}')";
                    dbSize = (long)cmd.ExecuteScalar();

                    configInfo.LastTruncateDate = DateTime.Now;
                    docSession.SaveChanges();
                }

                //If database size >15mb or 1000 documents delete documents older than a week
                if(docCount > 1000 || dbSize > 15000000) //its actually 14.3mb but goood enough
                {
                    docSession.DeleteWhere<Dinner>(dp => dp.LastModified < DateTime.Now.AddDays(-7));
                }
            }
            catch(Exception ex)
            {
                LogManager.GetCurrentClassLogger().Warn(ex, "Failed to clean up database");
            }
        }
Beispiel #2
0
        private void CleanUpDB(DocumentStore documentStore)
        {
            var docSession = documentStore.OpenSession();
            var configInfo = docSession.Load<Config>("DinnerParty/Config");

            if (configInfo == null)
            {
                configInfo = new Config();
                configInfo.Id = "DinnerParty/Config";
                configInfo.LastTruncateDate = DateTime.Now.AddHours(-48); //No need to delete data if config doesnt exist but setup ready for next time

                docSession.Store(configInfo);
                docSession.SaveChanges();

                return;
            }
            else
            {
                if ((DateTime.Now - configInfo.LastTruncateDate).TotalHours < 24)
                    return;


                configInfo.LastTruncateDate = DateTime.Now;
                docSession.SaveChanges();

                //If database size >15mb or 1000 documents delete documents older than a week

#if DEBUG
                var jsonData =
                    documentStore.JsonRequestFactory.CreateHttpJsonRequest(null, "http://localhost:8080/database/size", "GET", documentStore.Credentials, documentStore.Conventions).ReadResponseJson();
#else
                var jsonData =
                    documentStore.JsonRequestFactory.CreateHttpJsonRequest(null, "https://aeo.ravenhq.com/databases/DinnerParty-DinnerPartyDB/database/size", "GET", documentStore.Credentials, documentStore.Conventions).ReadResponseJson();
#endif
                int dbSize = int.Parse(jsonData.SelectToken("DatabaseSize").ToString());
                long docCount = documentStore.DatabaseCommands.GetStatistics().CountOfDocuments;


                if (docCount > 1000 || dbSize > 15000000) //its actually 14.3mb but goood enough
                {

                    documentStore.DatabaseCommands.DeleteByIndex("Raven/DocumentsByEntityName",
                                              new IndexQuery
                                              {
                                                  Query = docSession.Advanced.LuceneQuery<object>()
                                                  .WhereEquals("Tag", "Dinners")
                                                  .AndAlso()
                                                  .WhereLessThan("LastModified", DateTime.Now.AddDays(-7)).ToString()
                                              },
                                              false);
                }
            }
        }