Results 1 to 5 of 5
  1. #1

    First DB design an stored procedure - beginner questions and feedback requested

    I made my first database design. A screenshot can be found here:https://i.imgsafe.org/7b/7b689c7679.png

  2. #2

    First DB design an stored procedure - beginner questions and feedback requested

    The idea is to keep a list of approved posts. Every post has an author, a permlink, a reviewer and belongs to a category. A discoverer is optional. Reviewers can be enabled or disabled. Every post also has a list of keywords.

    I want to achieve the following: I want to call the stored procedure or function with the following input parameters: author, permlink, discoverer, reviewer and category.

  3. #3

    First DB design an stored procedure - beginner questions and feedback requested

    I got something to work but I'm not sure how to do the input parameter validation and how to 'report' when something is wrong. In a later stadium this stored procedure or function will be used from a php page.

    I'm not sure if a stored procedure is the correct way to handle this.

    If the category does not exist -> error
    If the reviewer does not exist or is not enabled -> error
    If the author does not exist -> add
    If the discoverer does not exist -> add

  4. #4

    First DB design an stored procedure - beginner questions and feedback requested

    If validation ok -> add

    I was going to add to this post what I had this far but somehow I managed to delete my SP...

    The issue I was having is that the SP continued when I detected an input was incorrect.

    Any guidance is appreciated.






  5. #5

    First DB design an stored procedure - beginner questions and feedback requested

    I would handle the business logic out of db and without stored procedures.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •