public static ControlHistory ControlLetter(string board_id, string discussion_id, string letter_id, string delta_flags)
{
string partition_key = SandId.CombineId(board_id, discussion_id);
// todo: select only needed properties.
TableResult result = Warehouse.DiscussionLoadTable.Execute(TableOperation.Retrieve(partition_key, letter_id));
DynamicTableEntity entity = (DynamicTableEntity)result.Result;
// permanent deleting twice is not blocked.
GroupStore.CheckControlRight(board_id, discussion_id, letter_id, ref delta_flags, entity);
int ec = RevisionStore.IncreaseEditCount(entity);
RevisionStore.CreateRevision(entity, board_id, discussion_id, letter_id, ec);
int prev_report_cnt = SandFlags.GetNumber(entity.GetFlags(), SandFlags.MT_REPORT);
LetterConverter.ModifyLetterFlags(entity, null, delta_flags);
int new_report_cnt = SandFlags.GetNumber(entity.GetFlags(), SandFlags.MT_REPORT);
Warehouse.DiscussionLoadTable.Execute(TableOperation.Replace(entity)); // Throws StorageException ((412) Precondition Failed) if the entity is modified in between.
Warehouse.DiscussionLoadPond.Notify(board_id, discussion_id);
Warehouse.DiscussionSummaryPond.Notify(board_id, discussion_id);
HttpResponse.RemoveOutputCacheItem("/discussionload/" + board_id + "/" + discussion_id);
return(new ControlHistory {
ReportCount = new_report_cnt - prev_report_cnt
});
}
public static string /*board id*/ CreateBoard(string board_name)
{
int next_id = NextIdStore.Next(Warehouse.BoardListTable, null);
string board_id = SandId.MakeBoardId(next_id);
DynamicTableEntity entity = new DynamicTableEntity(board_id, EMPTY_ROW_KEY);
entity["boardname"] = new EntityProperty(board_name);
entity.OperateFlags(new FlagMergeOperation(SandFlags.MT_LOW_KEY + "1"));
#if OLD
entity["createtime"] = new EntityProperty(DateTime.Now);
entity["creatoruid"] = new EntityProperty(WebSecurity.CurrentUserId);
entity["creatormid"] = new EntityProperty(UserStore.CurrentUserMId);
#else
CreatorConverter.FillEntity(entity, CreatorConverter.Status.Editor, null);
#endif
Warehouse.BoardListTable.Execute(TableOperation.Insert(entity));
DiscussionListStore.CreateSkeleton(board_id);
//don't work for child action. //HttpResponse.RemoveOutputCacheItem("/boardlist");
Warehouse.BsMapPond.Notify();
return(board_id);
}
public static void EditLetter(string board_id, string discussion_id, string letter_id, string editor, string words,
string delta_flags, HttpFileCollectionBase files)
{
string partition_key = SandId.CombineId(board_id, discussion_id);
TableResult result = Warehouse.DiscussionLoadTable.Execute(TableOperation.Retrieve(partition_key, letter_id));
DynamicTableEntity entity = (DynamicTableEntity)result.Result;
GroupStore.CheckEditRight(board_id, discussion_id, entity);
HashSet <string> files_set = new HashSet <string>();
words = processUploadFiles(words, files, files_set);
words = processWords(words);
claimFiles(words, SandId.CombineId(board_id, discussion_id, letter_id), files_set);
// if (entity != null) // let it throw null reference exception.
int ec = RevisionStore.IncreaseEditCount(entity);
RevisionStore.CreateRevision(entity, board_id, discussion_id, letter_id, ec);
LetterConverter.EditLetterEntity(entity, editor, words, delta_flags, board_id, discussion_id);
Warehouse.DiscussionLoadTable.Execute(TableOperation.Replace(entity)); // Throws StorageException ((412) Precondition Failed) if the entity is modified in between.
Warehouse.DiscussionLoadPond.Notify(board_id, discussion_id);
Warehouse.DiscussionSummaryPond.Notify(board_id, discussion_id);
HttpResponse.RemoveOutputCacheItem("/discussionload/" + board_id + "/" + discussion_id);
}
public static void WriteForCrawler(TextWriter writer, DynamicTableEntity entity, Status status)
{
EntityProperty ep;
if (entity.Properties.TryGetValue(names[(int)status, 0], out ep))
{
//writer.WriteForCrawler("address", ep.StringValue);
string user_name = entity.GetString(names[(int)status, 6], null);
string link = null;
if (!SandId.IsLau(user_name))
{
int user_id = (int)entity[names[(int)status, 2]].Int32Value; // may be -1.
link = HtmlUtil.MakeUserLink(user_id);
}
writer.WriteStartTag("address");
writer.WriteAnchor(link, ep.StringValue);
writer.WriteEndTag("address");
}
if (entity.Properties.TryGetValue(names[(int)status, 1], out ep))
{
writer.WriteForCrawler("time", Convertor.ToString(ep.DateTimeOffsetValue));
}
}
private static string /*letter id*/ CreateLetterInternal(string board_id, string discussion_id,
string creator, string words, Subtype subtype, string delta_flags)
{
string partition_key = SandId.CombineId(board_id, discussion_id);
if (NextIdStore.GetLastId(Warehouse.DiscussionLoadTable, partition_key) >= HeartsConfiguration.MAX_NUM_OF_LETTERS_IN_A_DISCUSSION)
{
Util.ThrowBadRequestException("留言數超過上限（" + HeartsConfiguration.MAX_NUM_OF_LETTERS_IN_A_DISCUSSION + "）則。");
}
int next_id = NextIdStore.Next(Warehouse.DiscussionLoadTable, partition_key); // null reference exception for nonexistent board id.
string letter_id = SandId.MakeLetterId(next_id);
// if exception is thrown after getting id, the id is lost.
DynamicTableEntity entity = new DynamicTableEntity(partition_key, letter_id);
LetterConverter.CreateLetterEntity(entity, creator, words, subtype, delta_flags, board_id, discussion_id);
//
Warehouse.DiscussionLoadPond.Get(board_id, discussion_id).AddLetter(entity);
Warehouse.DiscussionSummaryPond.Get(board_id, discussion_id).AddLetter(entity);
Warehouse.DiscussionLoadTable.Execute(TableOperation.Insert(entity));
//
return(letter_id);
}
public static bool HasChairOwner(string board_id)
{
string role_name = SandId.CombineId(board_id, ChairOwnerGroupName);
return(false);
//2015-11-6 remove sql db. //return Roles.GetUsersInRole(role_name).Length > 0;
}
private static void upgradeTemporalAddBoardId()
{
string pkFilter = TableQuery.CombineFilters(
TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.GreaterThanOrEqual, "bldr1.b0"),
TableOperators.And,
TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.LessThanOrEqual, "bldr1.b999"));
TableQuery query = new TableQuery().Where(pkFilter);
foreach (DynamicTableEntity entity in Warehouse.TemporalTable.ExecuteQuery(query))
{
string board_id;
SandId.SplitId(entity.PartitionKey, out board_id);
string[] parts = entity["part0"].StringValue.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
StringBuilder builder = new StringBuilder();
foreach (string part in parts)
{
builder.AppendFormat("{0}.{1},", board_id, part);
}
Warehouse.TemporalTable.SaveLongString(SandId.CombineId("bldr2", board_id), "segment0", builder.ToString());
}
}
public static void SetBoardSetting(string board_id, string board_name)
{
TableResult result = Warehouse.BoardListTable.Execute(TableOperation.Retrieve(board_id, EMPTY_ROW_KEY));
DynamicTableEntity entity = (DynamicTableEntity)result.Result;
// if (entity != null) // let it throw null reference exception.
int ec = RevisionStore.IncreaseEditCount(entity);
string partition_key = SandId.CombineId(Warehouse.BoardListTable.Name, board_id);
RevisionStore.CreateHistory(entity, partition_key, ec, "boardname");
CreatorConverter.FillEntity(entity, CreatorConverter.Status.Editor, null);
entity["boardname"].StringValue = board_name;
Warehouse.BoardListTable.Execute(TableOperation.Replace(entity)); // Throws StorageException ((412) Precondition Failed) if the entity is modified in between.
//don't work for child action. //HttpResponse.RemoveOutputCacheItem("/boardlist");
//List<string> selection_list = SelectionBoardListResult.GetSelectionList(board_id);
//if (selection_list != null)
//foreach (string selection_id in selection_list)
//don't work for child action. //HttpResponse.RemoveOutputCacheItem("/discussionlist/" + selection_id);
Warehouse.BsMapPond.Notify();
Warehouse.DiscussionListPond.Notify(board_id);
Warehouse.BoardSettingPond.Notify(board_id);
}
public static bool IsCurrentUserDiscussionCreator(string board_id, string discussion_id)
{
string partition_key = SandId.CombineId(board_id, discussion_id);
TableResult result = Warehouse.DiscussionLoadTable.Execute(TableOperation.Retrieve(partition_key, SandId.HEADING_LETTER_ID));
DynamicTableEntity entity = (DynamicTableEntity)result.Result;
return(CreatorConverter.IsCurrentUserCreator(entity));
}
public static void Vote(string board_id, string discussion_id, string letter_id, string meta_title)
{
string partition_key = SandId.CombineId(board_id, discussion_id, letter_id);
string row_key = SandId.CombineId(meta_title, "uid", WebSecurity.CurrentUserId.ToString()); // CurrentUserId is -1 if not logged in.
DynamicTableEntity entity = new DynamicTableEntity(partition_key, row_key);
Warehouse.VoteBookTable.Execute(TableOperation.Insert(entity)); // (409) 衝突。 if already exists.
}
public static bool IsInsider(string board_id)
{
if (IsBoardOwner(board_id))
{
return(true);
}
string role_name = SandId.CombineId(board_id, InsiderGroupName);
return(HttpContext.Current.User.IsInRole(role_name));
}
public static string[] GetBoardGroup(string board_id, string group_id, out int[] user_ids)
{
string role_name = SandId.CombineId(board_id, group_id);
string[] user_names = Roles.GetUsersInRole(role_name); // zero length array for nonexistent role.
user_ids = UserNamesToUserIds(user_names);
return(user_names);
}
public void Notify(string board_id, string discussion_id)
{
string key = SandId.CombineId("discussionload1", board_id, discussion_id);
DiscussionLoadRoll obj = (DiscussionLoadRoll)HttpRuntime.Cache.Remove(key);
if (obj != null)
{
insertNew(key, board_id, discussion_id);
}
}
public void Notify(string board_id)
{
string key = SandId.CombineId("boardsetting1", board_id);
BoardSetting obj = (BoardSetting)HttpRuntime.Cache.Remove(key);
if (obj != null)
{
insertNew(key, obj.BoardId);
}
}
public void Notify(string board_id)
{
string key = SandId.CombineId("dlpond1", board_id);
DiscussionList obj = (DiscussionList)HttpRuntime.Cache.Remove(key);
if (obj != null)
{
insertNew(key, obj.BoardId);
}
}
public void Notify(string board_id, string discussion_id)
{
string key = SandId.CombineId("summary1", board_id, discussion_id);
DiscussionSummary obj = (DiscussionSummary)HttpRuntime.Cache.Remove(key);
if (obj != null)
{
insertNew(key, obj.BoardId, obj.DiscussionId);
}
// todo: remove only if the edited letter is in the DiscussionSummary.
}
public static void CreateRevision(DynamicTableEntity letter_entity, string board_id, string discussion_id,
string letter_id, int version)
{
string partition_key = SandId.CombineId(board_id, discussion_id, letter_id);
DynamicTableEntity entity = new DynamicTableEntity(partition_key, SandId.MakeRevisionId(version));
LetterConverter.CopyLetterRevision(letter_entity, entity, version);
Warehouse.RevisionTable.Execute(TableOperation.Insert(entity)); // If an exception is thrown after revision created but before edit count in letter entity is updated, next time edit will fail because the revision already exists.
}
public static void GetLastLetters(string board_id, string discussion_id, int cnt, Action <DynamicTableEntity> act)
{
string partition_key = SandId.CombineId(board_id, discussion_id);
int last_id = NextIdStore.GetLastId(Warehouse.DiscussionLoadTable, partition_key);
if (last_id != -1)
{
Warehouse.DiscussionLoadTable.EnumerateRowRange(partition_key, SandId.LETTER_ID_PREFIX, last_id - cnt + 1, cnt, act);
}
}
private BubblingRoll get(string id, int list_size)
{
string key = SandId.CombineId(BubblingRoll.PAR_KEY_PREFIX, id);
BubblingRoll obj = (BubblingRoll)HttpRuntime.Cache.Get(key);
if (obj == null)
{
obj = insertNew(key, id, list_size);
}
return(obj);
}
public string Get(string board_id, string discussion_id, bool insert_if_not_exist)
{
string key = SandId.CombineId("discussionkey1", board_id, discussion_id);
string obj = (string)HttpRuntime.Cache.Get(key);
if (obj == null)
{
obj = insertNew(key, board_id, discussion_id, insert_if_not_exist);
}
return(obj);
}
public BoardSetting Get(string board_id)
{
string key = SandId.CombineId("boardsetting1", board_id);
BoardSetting obj = (BoardSetting)HttpRuntime.Cache.Get(key);
if (obj == null)
{
obj = insertNew(key, board_id);
}
return(obj);
}
public DiscussionList Get(string board_id)
{
string key = SandId.CombineId("dlpond1", board_id);
DiscussionList obj = (DiscussionList)HttpRuntime.Cache.Get(key);
if (obj == null)
{
obj = insertNew(key, board_id);
}
return(obj);
}
public DiscussionSummary Get(string board_id, string discussion_id)
{
string key = SandId.CombineId("summary1", board_id, discussion_id);
DiscussionSummary obj = (DiscussionSummary)HttpRuntime.Cache.Get(key);
if (obj == null)
{
obj = insertNew(key, board_id, discussion_id);
}
return(obj);
}
public static void SplitFlags(string text, Action <string, string> callback)
{
SandId.SplitWithCallback2(text, FLAGS_SEPARATOR, flag =>
{
int start = flag.IndexOf(MTV_SEPARATOR);
if (start != -1)
{
string meta_title = flag.Substring(0, start);
string meta_value = flag.Substring(start + 1);
callback(meta_title, meta_value);
}
});
}
public DiscussionLoadRoll Get(string board_id, string discussion_id)
{
string key = SandId.CombineId("discussionload1", board_id, discussion_id);
DiscussionLoadRoll obj = (DiscussionLoadRoll)HttpRuntime.Cache.Get(key);
if (obj == null)
{
obj = insertNew(key, board_id, discussion_id);
}
return(obj);
}
public DiscussionListResult(string board_id /*or selection id*/)
{
//this.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
if (SandId.IsSelectionId(board_id, 0, board_id.Length))
{
this.selectionId = board_id;
this.boardList = Warehouse.BsMapPond.Get().GetBoardList(this.selectionId); // null for nonexistent selection.
}
else
{
this.boardList = new List <string>(1);
this.boardList.Add(board_id);
}
}
public void Save()
{
// nodes overwrite each other.
if (this.modified)
{
string serialized;
lock (this.list)
serialized = Util.Serialize(this.list);
// different nodes override each other.
string key = SandId.CombineId(PAR_KEY_PREFIX, this.Id);
Warehouse.TemporalTable.SaveLongString(key, "segment0", serialized);
// if Put() is called in another thread here, the modified flag is cleared wrongly.
this.modified = false;
}
}
public static void CreateActivity(string partition_key, string[] properties, object[] values)
{
int version = VersionCounterStore.Next(Warehouse.ActivityTable, partition_key);
DynamicTableEntity entity = new DynamicTableEntity(partition_key, SandId.MakeRevisionId(version));
for (int i = 0; i < properties.Length; i++)
{
if (values[i] is string)
{
entity[properties[i]] = new EntityProperty((string)values[i]);
}
else
{
throw new ProgramLogicException();
}
}
Warehouse.ActivityTable.Execute(TableOperation.Insert(entity)); // 409 conflict exception if already exists.
}
public static void SetBoardFlags(string board_id, string delta_flags)
{
TableResult result = Warehouse.BoardListTable.Execute(TableOperation.Retrieve(board_id, EMPTY_ROW_KEY));
DynamicTableEntity entity = (DynamicTableEntity)result.Result;
int ec = RevisionStore.IncreaseEditCount(entity);
string partition_key = SandId.CombineId(Warehouse.BoardListTable.Name, board_id);
RevisionStore.CreateHistory(entity, partition_key, ec, "flags2");
CreatorConverter.FillEntity(entity, CreatorConverter.Status.Editor, null);
entity.OperateFlags(new FlagMergeOperation(delta_flags));
Warehouse.BoardListTable.Execute(TableOperation.Replace(entity)); // Throws StorageException ((412) Precondition Failed) if the entity is modified in between.
Warehouse.BoardSettingPond.Notify(board_id);
}
public static bool VoteLetter(string board_id, string discussion_id, string letter_id, string delta_flags)
{
try
{
SandFlags.SplitFlags(delta_flags, (meta_title, meta_value) =>
{
VoteBookStore.Vote(board_id, discussion_id, letter_id, meta_title);
});
}
catch (StorageException ex)
{
return(false);
}
string partition_key = SandId.CombineId(board_id, discussion_id);
string pkFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, partition_key);
string rkFilter = TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, letter_id);
string combinedFilter = TableQuery.CombineFilters(pkFilter, TableOperators.And, rkFilter);
TableQuery query = new TableQuery().Where(combinedFilter).Select(new string[] { "flags2" });
foreach (DynamicTableEntity entity in Warehouse.DiscussionLoadTable.ExecuteQuery(query))
{
entity.OperateFlags(new FlagOperation
{
type = FlagOperation.Type.AddMultiple,
DeltaFlags = delta_flags,
});
if (entity.Properties.Count == 0) // TableOperation.Merge cannot be used to remove property. if "flags" becomes empty, it will be removed from properties and the merge will have no effect.
{
throw new ProgramLogicException();
}
Warehouse.DiscussionLoadTable.Execute(TableOperation.Merge(entity));
}
Warehouse.DiscussionLoadPond.Notify(board_id, discussion_id);
Warehouse.DiscussionSummaryPond.Notify(board_id, discussion_id);
HttpResponse.RemoveOutputCacheItem("/discussionload/" + board_id + "/" + discussion_id);
// Cache of ViewDiscussion is not removed so may serve old version.
return(true);
}