root / DB.hs

DB.hs

View | Annotate | Download (13.2 KB)

# Date Author Comment
3d9db7bd 02/16/2008 11:06 PM John Goerzen

Really fixed DB logic this time

refs deb#465038, deb#404977.
f0d42e6a 02/16/2008 10:45 PM John Goerzen

Added debugging info
5aeecc7b 02/16/2008 10:43 PM John Goerzen

Clean up GUID handling

We had a situation in which a podcast contained two episodes with the
same URL but different GUIDs. This would make our UPDATE command
match both.

refs deb#465038, deb#404977
64e63f6b 01/04/2008 12:21 AM John Goerzen

Fix doc build error
fabc996d 10/19/2007 02:50 AM John Goerzen

Re-add guid patch
9f25093a 09/29/2007 10:44 PM Jason Creighton

UNDO: Support for the <guid> RSS element

Some feeds contain episodes whose URL changes with time. (For example, to
archive old episodes to a different server) Unfortunately, hpodder will see
this as a new episode and re-download it.

This patch treats the <guid> RSS element, if present (the <guid> element is
optional), as an additional unique identifier for an episode. If the URL for an
episode with a GUID changes, the URL of the old episode will be updated and the
episode will not be re-downloaded.
79374f3f 09/29/2007 10:44 PM Jason Creighton

Support for the <guid> RSS element

Some feeds contain episodes whose URL changes with time. (For example, to
archive old episodes to a different server) Unfortunately, hpodder will see
this as a new episode and re-download it.

This patch treats the <guid> RSS element, if present (the <guid> element is
optional), as an additional unique identifier for an episode. If the URL for an
episode with a GUID changes, the URL of the old episode will be updated and the
episode will not be re-downloaded.
654d9f85 08/03/2007 08:45 AM John Goerzen

Fix error with hpodder add

fixes deb#435738
2c8d5218 07/29/2007 07:10 AM John Goerzen

s/eplastdownload/epfirstattempt/g
1d607ac7 07/29/2007 07:05 AM John Goerzen

Rename eplastupdate -> eplastdownload
fe2a3f59 07/29/2007 06:51 AM John Goerzen

Misc cleanups
25dc0c06 07/29/2007 06:48 AM John Goerzen

Update db handling of episodes
4a6518fd 07/29/2007 06:45 AM John Goerzen

New columns in episodes
a4b4ce84 07/29/2007 04:52 AM John Goerzen

Fix SQL query
966826db 07/29/2007 01:44 AM John Goerzen

Removed lastsuccess remnants
2808de5b 07/29/2007 01:30 AM John Goerzen

Added last success data to podcasts
94ac6c56 05/04/2007 09:56 PM John Goerzen

UNDO: Step 1 of db updates
47ffd2d7 05/04/2007 09:56 PM John Goerzen

Step 1 of db updates
4d4f43f6 05/04/2007 02:44 AM John Goerzen

Start of working on better locking
468b1da7 12/08/2006 05:38 PM John Goerzen

First set of updates for MissingH 0.18
750378f2 11/24/2006 11:18 AM John Goerzen

Move DB code from Utils to DB
dc66af55 11/24/2006 11:14 AM John Goerzen

Delete tmp files as appropriate
3ef5a1f2 11/23/2006 12:53 PM John Goerzen

Store estimated size in DB where available
7954f2d4 08/04/2006 08:08 PM John Goerzen

Note upgraded schema version
034b0498 07/25/2006 03:40 AM John Goerzen

Don't vacuum sqlite for now

It doesn't work from within a transaction -- perhaps should do this
automatically periodically.
cf0635fd 07/25/2006 03:36 AM John Goerzen

Fix compile error
63c87a5d 07/25/2006 03:34 AM John Goerzen

Added debugging to DB.hs
be6a1346 07/25/2006 03:31 AM John Goerzen

All upgradeSchema calls chain forward
25685250 07/25/2006 03:12 AM John Goerzen

Syntax fix
8fc744c2 07/25/2006 03:12 AM John Goerzen

Fixed add to set all fields
36797512 07/25/2006 03:11 AM John Goerzen

Fix bug in updatePodcast
036ae7a1 07/25/2006 02:46 AM John Goerzen

Updated
5cbbf9bd 07/25/2006 02:45 AM John Goerzen

Fix strictness
221896dd 07/25/2006 02:36 AM John Goerzen

SQLite tweaks

We use a separate dbh' handle because it seems that there is a synchronization issue somewhere
6e5a9443 07/25/2006 02:32 AM John Goerzen

Fix compilation errors
384dbe22 07/25/2006 02:26 AM John Goerzen

Added lastupdate, pcenabled DB code and wrote lastupdate support in Update.hs
7230ef3b 06/30/2006 02:39 AM John Goerzen

Added command rm
522c8194 06/28/2006 08:48 PM John Goerzen

New download command
f5e18533 06/28/2006 04:33 PM John Goerzen

Checkpointing
710bf61a 06/28/2006 04:00 PM John Goerzen

Added id support to lscasts
22a68593 06/28/2006 03:52 PM John Goerzen

Update works
03ad94a6 06/28/2006 03:45 PM John Goerzen

More checkpointing
1c411f1e 06/28/2006 03:36 PM John Goerzen

Initial work on Update
48a5bf97 06/28/2006 02:20 PM John Goerzen

More hspod -> hpodder renaming
2f2d252d 06/28/2006 08:45 AM John Goerzen

checkpointing
4747b890 06/28/2006 08:32 AM John Goerzen

Spiffied up feedback for add
13fec1cf 06/28/2006 07:35 AM John Goerzen

Lots o updates

Added Download capability
Added support for per-command long help
Added Update command skeleton
Added global info to pass to commands
0442bcae 06/28/2006 01:33 AM John Goerzen

Compilation works
4fd43e40 06/28/2006 12:48 AM John Goerzen

Work on DB stuff
9f58a807 06/27/2006 09:14 PM John Goerzen

Checkpointing
9e836330 06/27/2006 08:36 PM John Goerzen

DB coding
8a42cc73 06/27/2006 07:46 PM John Goerzen

Renamed to hspod
818ea60c 06/27/2006 07:45 PM John Goerzen

Added new code files