Thanks Cliff and Niphlod... appreciate your assistance. I'll go through the book a little slower and get clear on this.
In the book it shows an example using the word "owner". When I copy and paste this in, I can't access the database administration option as I get an internal error with the message in the ticket stating: <type 'exceptions.SyntaxError'> invalid table/column name "owner" is a "ALL" reserved SQL keyword Anyway, so I just changed it to "owne" instead and it all works. Another thing, while going through the steps outlined in the book, I've been using the shell in Controllers. I type a line, for example: db.thing.insert(name='Chair', owne=1) and press enter and nothing happens. Then I'll type it again and hit enter and it outputs: In [11] : db.thing.insert(name='Chair', owne=1) 4 Showing that it worked. As I keep doing this and even change what I type in, it only works every second time. One time I hit enter and nothing happens, then after typing I hit enter and it seems to work. Am I doing something wrong or is this a bug in web2py or in my installation perhaps? Toby On Monday, 25 February 2013 18:24:48 UTC+11, Toby Wilson wrote: > > > Hi all, > > New to web development and web2py. Know a bit of Python. > > As a learning experience I’ve written a food tracking program that works > really well in Python and it just runs on my local PC. It just reads and > writes values into text files. > > Now I’m trying to transfer that into web2py as a next step learning > experience. I’m trying to figure out the database side of it (models). > > It seems what I’m dealing with is many-to-many relationships. I have a > list of meals and each meal has a list of associated ingredients. So one > ingredient can be in many meal and each meal has many ingredients. > > So essentially, what the program I've written can do is add 3 x “Meal 1” > to the quantity existing in the database for “Meal 1” and then after doing > that prompt the user with: > > “Do you want this to impact the level of the ingredient ‘carrot’?” Y/N > > And then: > > “Do you want this to impact the level of the ingredient ‘steak’? Y/N > > etc. > > And the program knows that “Meal 1” needs 3 carrots, so upon entering “Y” > to the first question, 3 carrots are automatically subtracted from the > stock level of carrots in the database. > > So as meals are added, the user is prompted with associated ingredients > and can choose to update or not update the level of that associated > ingredient. > > In the local Python program I’ve written, all of this is just done through > listing things in dictionaries and using functions to manipulate the data > and then read and write to text files. Now I want to use database tables > and I’m not sure how much of the association should be in the model and how > much (if any) should be in the controller (for example in the form of a > dictionary). > > I’ve read through the documentation on many to many relationships but > haven’t got a full grasp of it yet. > > I’ve coded a few different database structures but haven’t managed to get > it right yet. > > The way I've been thinking about it is, a table for meals, a table for > ingredients, and perhaps a table for associations? I've used "reference" to > get the drop down box associated, but I can't select more than ingredient. > I had a look at the Django admin login and it visually made this look a bit > easier - i.e. building the one to many relationship. How is this done in > web2py? > > Any help or advice would be much appreciated. > > Toby > > P.S. If I have a database file in web2py and open the file through the > web2py IDE and replace the contents with a totally different database > structure and save it, what happens? Does web2py just remove what was there > in the database and replace the database tables with the new ones or does > it manage it in a different way (i.e. only add new elements etc.)? > > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.