UGGG! I have been fighting with this for a while. I never thought to just use an actual file for my db instead of using memory. I was using memory because I was only wanting to test things and didn't want to keep the data. Seems that perhaps due to cherrypy the database was being deleted. I later moved the create_all() statement into the index sub and found that it worked. Following that when I loaded a lot of info into the db and browsed to an outside website and back all the data was gone.
My original code now works, all I had to do it use a db file instead of a db in memory. I'm glad I found a solution. But the number of times I read through sqlalchemy docs to find my problem just to realize there really wasn't anything wrong all along is very frustrating lol. Thanks for the help. Again I am new to SQLAlchemy so if you know any "best practices" or have any suggestions in general for web development in python, please shoot them my way. V/R Kevin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
