| | This file copyright (c) 2004 SO.MUS.AR. s.a.s. | Subject to the license published at | http://www.somusar.com/contact/poc_request | book "Book" | A book unique_id book_id "Book Id." string title[80] "Title" string isbn[80] "ISBN" link author author_id "Author Id." link publisher publisher_id "Publisher Id." enum status "Status" range num_copies "Num. copies" author.name author_name "Author name" author.pen_name pen_name "Author pen name" publisher.name publisher_name "Publisher name" function get_all_by_title "Query by title" function get_all_by_author_name "Query by author name" function update_status_by_publisher "Update by publisher" list book query_result "Query result" enum new_status "New status" --------------------- DEFS status: ebook_only "Ebook only" hardcopy "Hardcopy available" sold_out "Sold out" num_copies: 0/1000000 get_all_by_title: title -> query_result get_all_by_author_name: author_name -> query_result update_status_by_publisher: publisher_id, new_status -> 0 new_status: ebook_only "Ebook only" hardcopy "Hardcopy available" sold_out "Sold out" --------------------- DB table: book_id, title, isbn, author_id, publisher_id, status, num_copies pkey: book_id fkey: author_id, publisher_id extension: author_name, pen_name, publisher_name custom: get_all_by_title, get_all_by_author_name, update_status_by_publisher --------------------- LOGIC --------------------- UI full_view: title isbn author_name publisher_name status num_copies get_all_by_title get_all_by_author_name update_status_by_publisher --------------------- ADJUST DB.test_data_available = "yes" DB.extension.label = "BookWithNames" DB.table.isbn.column_id = "ISBN" DB.table.isbn.member_id = "ISBN" DB.custom.get_all_by_title.function_type = "queryExtension" DB.custom.get_all_by_author_name.function_type = "queryExtension" DB.custom.update_status_by_publisher.function_type = "updateBy" UI.full_view.title.colspan = 3 UI.full_view.title.textwidth = 60 UI.full_view.isbn.colspan = 3 UI.full_view.isbn.textwidth = 60 UI.full_view.update_status_by_publisher.colspan = 3