public void Load(BCRUser user) { using (SQLiteDataReader reader = Database.Instance.ExecuteReader(@"SELECT open_current_comic_at_launch, open_next_comic, page_fit_mode, zoom_on_tap, toggle_paging_bar, use_page_turn_drag, page_turn_drag_threshold, use_page_change_area, page_change_area_width, use_comicrack_progress FROM user_settings WHERE user_id = " + user.UserId + " LIMIT 1;")) { if (reader.Read()) { try { open_current_comic_at_launch = reader.GetBoolean(0); open_next_comic = reader.GetBoolean(1); page_fit_mode = reader.GetInt32(2); zoom_on_tap = reader.GetInt32(3); toggle_paging_bar = reader.GetInt32(4); use_page_turn_drag = reader.GetBoolean(5); page_turn_drag_threshold = reader.GetInt32(6); use_page_change_area = reader.GetBoolean(7); page_change_area_width = reader.GetInt32(8); use_comicrack_progress = reader.GetBoolean(9); full_name = user.FullName; } catch (Exception ex) { Trace.WriteLine(ex); } } } }
// TODO: add timeout for apikey. public static IUserIdentity GetUserFromApiKey(string apiKey) { if (apiKey == null) { return(null); } BCRUser user; if (users.TryGetValue(apiKey, out user)) { return(user); } NameValueCollection result = Database.Instance.QuerySingle("SELECT user.id as id, username, apikey, fullname FROM user JOIN user_apikeys ON user.id=user_apikeys.user_id WHERE apikey = '" + apiKey + "' LIMIT 1;"); if (result == null) { return(null); } user = new BCRUser { UserName = result["username"], UserId = Convert.ToInt32(result["id"]), FullName = result["fullname"] }; user.Initialize(); lock (lockObject) { users[apiKey] = user; } return(user); }
// Cache expensive properties // Drawback: any updates to the original ComicBook will not be propagated. // However, this Comic class is not meant to be used for a long time. It is used for providing a // json serializable class for returning search results. //private readonly Lazy<string> _caption = null; //public string Caption { get { return _caption.Value; } } #endregion Fields #region Constructors public Comic(ComicBook source, BCRUser user) { book = source; useComicrackProgress = user.settings.use_comicrack_progress; progress = useComicrackProgress ? null : user.GetComicProgress(source.Id); //_caption = new Lazy<string>(() => { return book.Caption; }); }
public void Save(BCRUser user) { string s = String.Format("UPDATE user_settings SET open_current_comic_at_launch={0}, open_next_comic={1}, page_fit_mode={2}," + "zoom_on_tap={3}, toggle_paging_bar={4}, use_page_turn_drag={5}, page_turn_drag_threshold={6}, use_page_change_area={7}," + "page_change_area_width={8}, use_comicrack_progress={9} WHERE user_id={10};", open_current_comic_at_launch?1:0, open_next_comic?1:0, page_fit_mode, zoom_on_tap, toggle_paging_bar, use_page_turn_drag?1:0, page_turn_drag_threshold, use_page_change_area?1:0, page_change_area_width, use_comicrack_progress?1:0, user.UserId); Database.Instance.ExecuteNonQuery(s); }
// Get all comics added within x days public static IEnumerable <Comic> GetMostRecentlyAdded(BCRUser user, int days) { //comicrack format = "Added": "10/15/2018 10:51:25 AM" //string dateformat = "MM/dd/yyyy HH':'mm':'ss "; var books = ComicRackAPIServer.Plugin.Application.GetLibraryBooks(); var recent = books.Where(x => x.AddedTime >= DateTime.Today.AddDays(-(days))); var list = recent.Select(x => x.ToComic(user)) .OrderBy(x => x.Added).ToList(); return(list); }
public static IEnumerable <Comic> GetComicsForList(BCRUser user, Guid id) { var list = Program.Database.ComicLists.FindItem(id); if (list == null) { return(Enumerable.Empty <Comic>()); } return(list.GetBooks().Select(x => x.ToComic(user))); }
// Get all comics from a specific series and volume public static IEnumerable <Comic> GetComicsFromSeriesVolume(BCRUser user, Guid id, int volume) { var books = ComicRackAPIServer.Plugin.Application.GetLibraryBooks(); var book = books.Where(x => x.Id == id).First(); var series = books.Where(x => x.ShadowSeries == book.ShadowSeries) .Where(x => x.ShadowVolume == volume) .Select(x => x.ToComic(user)) .OrderBy(x => x.ShadowNumber).ToList(); return(series); }
/* * */ public static IEnumerable <Comic> GetSeries(BCRUser user, Guid id, NancyContext context) { var books = ComicRackAPIServer.Plugin.Application.GetLibraryBooks(); var book = books.Where(x => x.Id == id).First(); var series = books.Where(x => x.ShadowSeries == book.ShadowSeries) .Where(x => x.ShadowVolume == book.ShadowVolume) .Select(x => x.ToComic(user)) .OrderBy(x => x.ShadowNumber).ToList(); int totalCount = 0; return(context.ApplyODataUriFilter(series, ref totalCount).Cast <Comic>()); }
public static Comic GetComic(BCRUser user, Guid id) { try { var comic = GetComics().First(x => x.Id == id); return(comic.ToComic(user)); } catch//(Exception e) { //MessageBox.Show(e.ToString()); return(null); } }
public static Comic ToComic(this ComicBook x, BCRUser user) { return(new Comic(x, user)); }
public BCRModule() : base(Database.Instance.GlobalSettings.url_base + "/BCR") { // The user must be authenticated in order to use the BCR API. this.RequiresAuthentication(); Get["/"] = x => { return(Response.AsText("Authentication OK")); }; /////////////////////////////////////////////////////////////////////////////////////////////// // Retrieve a list of all (smart)lists. Get["/Lists"] = x => { try { //var user = (BCRUser)this.Context.CurrentUser; //Gui guid = user.GetHomeList(); //ComicListItem item = Program.Database.ComicLists.GetItems<ComicListItem>(false).FirstOrDefault((ComicListItem cli) => cli.Id == s); int depth = Request.Query.depth.HasValue ? int.Parse(Request.Query.depth) : -1; return(Response.AsOData(Program.Database.ComicLists.Select(c => c.ToComicList(depth)))); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Retrieve the contents of the specified list. Get["/Lists/{id}"] = x => { try { int depth = Request.Query.depth.HasValue ? int.Parse(Request.Query.depth) : -1; IEnumerable <ComicList> list = Program.Database.ComicLists.Where(c => c.Id == new Guid(x.id)).Select(c => c.ToComicList(depth)); if (list.Count() == 0) { return(Response.AsError(HttpStatusCode.NotFound, "List not found", Request)); } return(Response.AsOData(list)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // For OData compatibility, count should be $count, but I don't know how to parse the $ with Nancy.... Get["/Lists/{id}/Comics/count"] = x => { try { BCRUser user = (BCRUser)this.Context.CurrentUser; int totalCount = 0; return(Response.AsText(Context.ApplyODataUriFilter(BCR.GetComicsForList(user, new Guid(x.id)), ref totalCount).Count().ToString())); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Return the comics of the specified list using OData to filter the comic properties and the list paging. Get["/Lists/{id}/Comics"] = x => { try { BCRUser user = (BCRUser)this.Context.CurrentUser; var rawcomics = BCR.GetComicsForList(user, new Guid(x.id)); int propCount = rawcomics.Count(); var result = new { totalCount = propCount, items = rawcomics }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Return the Library Totals. Get["/Totals"] = x => { try { BCRUser user = (BCRUser)this.Context.CurrentUser; var comics = BCR.GetComics().Select(c => c.ToComic(user)); var series = BCR.GetSeries(); var publishers = BCR.GetPublishers(); int issuesCount = comics.Count(); int seriesCount = series.Count(); int publishersCount = publishers.Count(); var result = new { issues = issuesCount, series = seriesCount, publishers = publishersCount }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Returns a list of all the comics as comic excerpts Get["/Comics"] = x => { try { BCRUser user = (BCRUser)this.Context.CurrentUser; var comics = BCR.GetComics().Select(c => c.ToComic(user)); int propCount = comics.Count(); var result = new { totalCount = propCount, items = comics }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Return the comicbook info as an OData filtered bag of properties. Get["/Comics/{id}"] = x => { try { BCRUser user = (BCRUser)this.Context.CurrentUser; Comic comic = BCR.GetComic(user, new Guid(x.id)); if (comic == null) { return(Response.AsError(HttpStatusCode.NotFound, "Comic not found", Request)); } return(Response.AsOData(new List <Comic> { comic })); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Retrieve the specified page as a jpg file with the specified dimensions. Get["/Comics/{id}/Pages/{page}"] = x => { try { int width = Request.Query.width.HasValue ? int.Parse(Request.Query.width) : -1; int height = Request.Query.height.HasValue ? int.Parse(Request.Query.height) : -1; int maxWidth = Request.Query.maxWidth.HasValue ? int.Parse(Request.Query.maxWidth) : -1; int maxHeight = Request.Query.maxHeight.HasValue ? int.Parse(Request.Query.maxHeight) : -1; return(BCR.GetPageImage(new Guid(x.id), int.Parse(x.page), width, height, Response)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Retrieve the original size (in pixels) of the requested page. Get["/Comics/{id}/Pages/{page}/size"] = x => { try { int width = 0; int height = 0; BCR.GetPageImageSize(new Guid(x.id), int.Parse(x.page), ref width, ref height); return(Response.AsJson(new { width = width, height = height }, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; Get["/Comics/{id}/pagesizes"] = x => { try { // int width = 0; // int height = 0; // int pageCnt = 0; // List<PageSizes> pagesizes = new List<PageSizes>(); // BCRUser user = (BCRUser)this.Context.CurrentUser; // Comic comic = BCR.GetComic(user, new Guid(x.id)); var pages = BCR.GetPagesInfo(new Guid(x.id)); if (pages == null) { return(Response.AsError(HttpStatusCode.NotFound, "Comic not found", Request)); } // pageCnt = comic.PageCount; // for (int i = 0; i < pageCnt; i++) // { //BCR.GetPageImageSize(new Guid(x.id), i, ref width, ref height); //pagesizes.Add(new PageSizes { pageNbr = i, height = height, width = width, ratio = width / height }); // } return(Response.AsJson(pages, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get one property. /* * Get["/Comics/{id}/{property}"] = x => { * try * { * Comic comic = BCR.GetComic(new Guid(x.id)); * if (comic == null) * { * return Response.AsError(HttpStatusCode.NotFound, "Comic not found", Request); * } * * PropertyInfo property = comic.GetType().GetProperty(x.property); * object value = property.GetValue(comic, null); * * return Response.AsJson(value); * } * catch(Exception e) * { * return Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request); * } * }; */ /////////////////////////////////////////////////////////////////////////////////////////////// // Update properties of the specified comicbook. /* * Put["/Comics/{id}"] = x => { * try * { * // Get the ComicBook entry from the library, so we can change it. * ComicBook book = BCR.GetComicBook(new Guid(x.id)); * if (book == null) * { * return Response.AsError(HttpStatusCode.NotFound, "Comic not found", Request); * } * * // Convert form values to temporary ComicBook object. * ComicBook info = this.Bind<ComicBook>(); * * IEnumerable<string> keys = Request.Form.GetDynamicMemberNames(); * * // This also triggers the update of the ComicRack application. * book.CopyDataFrom(info, keys); * * return HttpStatusCode.OK; * } * catch(Exception e) * { * return Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request); * } * }; */ /////////////////////////////////////////////////////////////////////////////////////////////// // Update properties of the specified comicbook for the current user Post["/Comics/{id}/Progress"] = x => { try { // Check if the comic exists. Guid comicId = new Guid(x.id); ComicBook book = BCR.GetComics().FirstOrDefault(comic => comic.Id == comicId); if (book == null) { return(Response.AsError(HttpStatusCode.NotFound, "Comic not found", Request)); } BCRUser user = (BCRUser)this.Context.CurrentUser; user.UpdateComicProgress(book, int.Parse(this.Request.Form.CurrentPage)); //if using multiple users do we update the master file with a users progress? //book.SetValue("CurrentPage", int.Parse(this.Request.Form.CurrentPage)); return(HttpStatusCode.OK); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Update one property /* * Put["/Comics/{id}/{property}"] = x => { * try * { * // Convert form values to temporary Comic object. * string info = this.Bind<string>(); * * * // Now get the ComicBook entry from the library, so we can change it. * ComicBook book = BCR.GetComicBook(x.id); * if (book == null) * { * return Response.AsError(HttpStatusCode.NotFound, "Comic not found", Request); * } * * // Setting one of these values also triggers the update of the ComicRack application. * book.SetValue(x.property, info); * * * return HttpStatusCode.OK; * } * catch(Exception e) * { * return Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request); * } * }; */ /////////////////////////////////////////////////////////////////////////////////////////////// // Get the BCR settings. Get["/Settings"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; return(Response.AsJson(user.GetSettings(), HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Update the BCR settings. Put["/Settings"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; user.UpdateSettings(this.Bind <UserSettings>()); return(HttpStatusCode.OK); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get a list of series Get["/Series"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; var series = BCR.GetSeriesList(); int propCount = series.Count(); var result = new { totalCount = propCount, items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; // Get a list of series added in the last 2 days Get["/Series/Recent/{days}"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; int days = x.days; var series = BCR.GetMostRecentlyAdded(user, days); int propCount = series.Count(); var result = new { totalCount = propCount, items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; // Get a list of series Read in the last 2 days Get["/Series/RecentlyRead/{days}"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; int days = x.days; var series = BCR.GetMostRecentlyRead(user, days); int propCount = series.Count(); var result = new { totalCount = propCount, items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Retrieve a list of all comics in the specified list Get["/Series/{id}"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; var series = BCR.GetComicsFromSeries(user, new Guid(x.id)); int propCount = series.Count(); var result = new { totalCount = propCount, items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Retrieve the number of comics in the specified list Get["/Series/{id}/count"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; int totalCount = 0; return(Response.AsText(Context.ApplyODataUriFilter(BCR.GetComicsFromSeries(user, new Guid(x.id)), ref totalCount).Count().ToString())); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get["/Series/{id}/Volumes"] = x => { try { return(Response.AsOData(BCR.GetVolumesFromSeries(new Guid(x.id)), HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get["/Series/{id}/Volumes/{volume}"] = x => { try { BCRUser user = (BCRUser)this.Context.CurrentUser; int volume = int.Parse(x.volume); var comics = BCR.GetComicsFromSeriesVolume(user, new Guid(x.id), volume); return(Response.AsOData(comics, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get a list of publishers Get["/Publishers"] = x => { try { var publishers = BCR.GetPublishers(); int propCount = publishers.Count(); var result = new { totalCount = propCount, items = publishers }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; Get["/Publishers/{publisher}/Imprint/{imprint}/"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; var pub = x.publisher; var imprint = x.imprint; if (string.IsNullOrEmpty(imprint)) { imprint = ""; } var series = BCR.GetSeries(pub, imprint); // int propCount = series.Count(); var result = new { items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; Get["/Ratings"] = x => { try { var series = BCR.GetAgeRatings(); int propCount = series.Count(); var result = new { totalCount = propCount, items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; Get["/Rating/{rating}/"] = x => { try { var user = (BCRUser)this.Context.CurrentUser; string rating = x.rating; // replace ~ with + rating = rating.Replace('~', '+'); if (string.IsNullOrEmpty(rating)) { rating = ""; } var series = BCR.GetSeriesByAgeRating(rating); int propCount = series.Count(); var result = new { totalCount = propCount, items = series }; return(Response.AsJson(result, HttpStatusCode.OK)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get["/Log"] = x => { try { string severity = Request.Query.sev.HasValue ? Request.Query.sev : ""; string message = Request.Query.msg.HasValue ? Request.Query.msg : ""; // TODO: write log entry to a file. return(Response.AsRedirect("/tablet/resources/images/empty_1x1.png", RedirectResponse.RedirectType.Permanent)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get the list of watched folders. Get["/WatchFolder"] = x => { try { //return Response.AsOData(BCR.GetPublishers(), HttpStatusCode.OK); var folders = Program.Database.WatchFolders as cYo.Projects.ComicRack.Engine.Database.WatchFolderCollection; List <string> books = BCRExtensions.GetFolderBookList2(folders.Folders.First(), true); return(Response.AsJson(books, HttpStatusCode.OK)); //return Response.AsRedirect("/tablet/resources/images/empty_1x1.png", RedirectResponse.RedirectType.Permanent); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; /////////////////////////////////////////////////////////////////////////////////////////////// // Get list of all files in the folder Get["/WatchFolder/{folder}"] = x => { try { return(Response.AsRedirect("/tablet/resources/images/empty_1x1.png", RedirectResponse.RedirectType.Permanent)); } catch (Exception e) { return(Response.AsError(HttpStatusCode.InternalServerError, e.ToString(), Request)); } }; }