public DBModule() : base("/DB") { Get["/latest/{count}/{page}"] = p => { return(Response.AsHTML(RinDB.GetLatest((int)p.count, (int)p.page))); }; Get["/search/{query}/{count}/{page}"] = p => { return(Response.AsHTML(RinDB.GetSearch((string)p.query, (int)p.count, (int)p.page))); }; Get["/tags/description/{tag}"] = p => { return(RinDB.GetTag(((string)p.tag).ToBase60()).description); }; }
public ImageModule() : base("/image") { Get["/dl/{id}"] = p => { ImageModel img = RinDB.GetImage((string)p.id); if (img == null) { return($"{(string)p.id} Not found"); } else { return(Response.FromImage(img.fileUri)); } }; Get["/thumb/{id}"] = p => { ImageModel img = RinDB.GetImage((string)p.id); if (img == null) { return($"{(string)p.id} Not found"); } else { return(GetOrGenerateThumb(img)); } }; Get["/{id}"] = p => { ImageModel img = RinDB.GetImage((string)p.id); if (img == null) { return($"{(string)p.id} Not Found"); } else { return(View["image", new { img = img, user = UserStateModel.DEFAULT }]); } }; }
internal static void Start() { StartTimer("RinDB.DatabaseQueue", i => { if (_IS_RUNNING) { return; } if (_DB_UPDATE_QUEUE.Count == 0) { return; } if (_CONNECTION == null) { _CONNECTION = RinDB.GetConnection(); _CONNECTION.Open(); _COMMAND = _CONNECTION.CreateCommand(); } //_CONNECTION.Open(); _IS_RUNNING = true; string query = ""; while (_DB_UPDATE_QUEUE.Count != 0 && query.Length <= 5000) { query += $"{_DB_UPDATE_QUEUE.Dequeue()};"; COMPLEDTED_COUNT++; } _COMMAND.CommandText = query; _COMMAND.ExecuteNonQuery(); if (!_JOB_DONE && _DB_UPDATE_QUEUE.Count == 0) { _JOB_DONE = true; Write("DB Updates Done!"); } _IS_RUNNING = false; }, 0, 500); }
public List <TagModel> GetTags() => RinDB.GetTags(id);
public bool HasTag(TagModel tag) => RinDB.HasTag(id, tag.id);
public bool HasTag(string tagid) => RinDB.HasTag(id, tagid);
public ImageModel AddTag(TagModel tag) { RinDB.AddTag(id, tag.id); return(this); }
public ImageModel AddTag(string tagID) { RinDB.AddTag(id, tagID); return(this); }