Date Added

[kilroy]

Good day -
Does Griffith have a field in the database (I am using MySQL) for the date that a movie was added to the collection?

I run a Crystal report to create a paper file, of my movie collection, and it would be nice to have a recently added report, so that friends and visitors that come over, and stay, know that movies x, y, and z were added in the last 90 days or something?

Thanks
Andrew

[mike]

If you need it only for some reports you can try to add a custom timestamp column manually.
Look into the reference manual:
http://dev.mysql.com/doc/refman/5.1/en/timestamp.html
You can create a column which is only updated at insert or one that is updated with every insert and update commands.
This is done by the mysql server. No changes at griffith side.

[kilroy]

Mike
You are wonderful, thank you - never thought about that.

Might be soemthing to add to a future release though, I doubt that I am the only one who could use it.

Thank you again.

Andrew

[mike]

Thx.  

And you are right. There are some others who ask for it. I will think about it.
https://blueprints.launchpad.net/griffith/+spec/add-date

[kilroy]

Hey Mike
I was just looking at the Mysql structure and it looks like there is a created and added date - Is this something that was added within the latest update?

Thanks

[mike]

Yes, the fields were added with version 0.12.

[Simeon]

A Suggestion:
Why is the one date (creation) deleted and the other one used once I changed something in the movie?
The creation date should remain what it is in my opinion as it could be used as an indicator when the DVD was bought.

[mike]

You know it, it is a bug.  

Fixed in rev. 1486
http://svn.berlios.de/svnroot/repos/griffith/trunk/lib/add.py

[Simeon]

Thanks Mike.