ProductReview Example: Difference between revisions

← Older edit

ProductReview Example (view source)

Revision as of 15:14, 8 April 2020

533 bytes added , 8 April 2020

m

Changed from Web Programming to Web Applications category

Hsymington

Administrators

280

edits

@@ Line 1: / Line 1: @@
-Here I will build a example application using the VDF Ajax library and note the steps taken underway.
+= Introduction =
+This page contains a description of an example project that can be used to study different implementation techniques using VDF as a backend.
-== Functionality ==
+In this example the overall goal is to be able to see what users think about a particular item . As an added benefit - users can also share information about where to buy the particular items.
-To have an example AJAX application  to share assessments about known items .
 To accomplish this, then users should be able to:
 *login
-*create a user account
 *choose an item from a list
 *enter information about a known item
-*supply a rating of an item
+*supply information about the place where an item was bought.
+*supply a review of an item
+*Overview supplied reviews from other users
-The overall goal is to be able to see what users think about a particular item.
+The workspace is available here https://github.com/jacobandresen/ProductReview
-The system should be implemented using as a web application, showcasing the possibilities in the VDF AJAX library.
+= [[DataDictionary|Data Dictionaries]] =
+We want to store information about users, places and known items. The other tables should hold sufficient information about the items and how the users liked them.
-==Development ==
+The following data dictionaries  should now be available (Note that attributes like "UserId" in Token implies a index  on UserId on Token and a relation to the table "User")
-=== Designing the tables ===
+==User==
+*UserId (Numeric)
+*LoginName (Ascii)
+*FirstName (Ascii)
+*LastName (Ascii)
+*Password (Ascii)
+*EmailAddress (Ascii)
+*Rights (Ascii)
+*StreetAddress (Ascii)
+*City (Ascii)
+*ZIPCode (Ascii)
+*Country (Ascii)
-We want to store information about users, places, purchases and known items. A user should be either a normal user or an administrator. The other tables should hold sufficient information about the items purchased and how the users liked them.
+==Token==
+*UserId (Numeric)
+*TokenValue (Ascii)
+*LastAccessed (Date)
+==Shop==
+*ShopId (Numeric)
+*Name (Ascii)
+*Type (Numeric)
+*Description (Ascii)
+*StreetAddress (Ascii)
+*City (Ascii)
+*ZIPCode (Ascii)
+*Country (Ascii)
-=== Using the AJAX Library ===
+==Product==
+*ProductId (Numeric)
+*Name (Ascii)
+*Type (Numeric)
+*Description (Ascii)
+*ShopId (Numeric)
+*Price (Numeric)
-Fetch the library from : http://www.dataaccess.nl/IframeText.asp?pageid=1378
+==Review==
-install it
+*ReviewId (Numeric)
+*ItemId (Numeric)
+*UserId (Numeric)
+*Rating (Numeric)
+*Comment (Ascii)
-*Right click in the class palette in VDF12.
+= Implementation =
-*press "add/remove libraries".
-*press "Add Library"
-*navigate to where you installed the VDF AJAX library. I installed mine in "c:\programmer\Visual DataFlex AJAX Library 1.0" .
-=== AJAX Session management ===
+[[ProductReview VDF AJAX implementation]]
-users logging in
-=== AJAX Masterdetail ===
+[[Category: Web Applications]]
-Listing user assements for items
+[[Category: Data Dictionaries]]