I am not able see the total_sales column in sqlite manager plugin of
firefox and sqlagrid of toscawidgets. But I can access the total_sales when
I use toscawidget's dbform. Any known reasons?
On Tuesday, 7 August 2012 20:56:07 UTC+5:30, jeetu wrote:
Just one minor update for future reference,
total_sales here is not a DB column here, it's just an attribute in your Python
model.
the most legit way to see total_sales in your SQLite database would be to
query for it.select sum(artist.sales) from artist where album_id=some
album.
Alternatively, a denomalized approach would be to
Hi,
I was naively trying to clear a db earlier in the day and I ran into this
problem: 'Cannot delete or update a parent row: a foreign key constraint
fails'
So as anyone would do I've been searching online and through the
documentation on how to turn the foreign keys off, on delete =
my code:
import sqlalchemy
db =
sqlalchemy.create_engine(mssql+pyodbc://root:123456@localhost/DumpResult)
conn = db.connect()
print db
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To view this discussion on the web visit