NextPVR Forums
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Developers v
« Previous 1 … 30 31 32 33 34 … 93 Next »
accessing database

 
  • 0 Vote(s) - 0 Average
accessing database
fluffykeith
Offline

Senior Member

Posts: 398
Threads: 69
Joined: Nov 2007
#1
2008-07-08, 02:57 PM
Hi I have a script that does a few things to the database and is run from updateEPG and postUpdateEPG. I think the script works but....

Is there any issue (and what is the way round it) for a script called in this way accessing the database?
Is PVRX2 prevented from accessing the databaise when these batch files are running?


I also noticed this on the latest release:
added a 'watched' indicator in the recordings screen
Thanks sub that is exactly what I'm looking for, I assume its in the database is it a flag on the playback position? Has the database structure changed.


cheers

Keith
Old broken setup - Zalman HD160+ box,  AMD Athlon 5400+, 3GB DDR2, Motherboard Gigabyte GA-M61P-S3
Hauppauge Nova-T PCI
Hauppauge Nova-S PCI
BlackGold Dual T2, S2 PCI
1x 2TB SATA
Windows 7 Pro
sub
Online

Administrator

NextPVR HQ, New Zealand
Posts: 102,403
Threads: 742
Joined: Nov 2003
#2
2008-07-09, 03:07 AM
fluffykeith Wrote:Is there any issue (and what is the way round it) for a script called in this way accessing the database?
Is PVRX2 prevented from accessing the databaise when these batch files are running?
If the duration of any updates are short then it should be fine. As aways though, directly updating the database can be risky if you do it wrong, or if you leave locks in the database. Simply reading the database is less of a problem.


Quote:I also noticed this on the latest release:
added a 'watched' indicator in the recordings screen
Thanks sub that is exactly what I'm looking for, I assume its in the database is it a flag on the playback position? Has the database structure changed.
Yes, the playback position table has changed slightly.
fluffykeith
Offline

Senior Member

Posts: 398
Threads: 69
Joined: Nov 2007
#3
2008-07-09, 02:54 PM
Thanks for the reply Sub.

When I finally get to writing my plugin I will use the correct methods, this is a kind of err hack I'm doing. Basically tidy up the db links to moved files, unreferenced recordings to programs that have changed (fixes the problem I have with overlapping recordings from the same channel) and some archiving to another disk based on playback position - hence my interest in the watched indicator.

When does the watched indicator get set? I am guessing it is a sticky flag that is set when the program end is reached. I assume playback position is still reset at that point.

I will upgrade and play.

Thanks for doing that update.

Cheers

Keith
Old broken setup - Zalman HD160+ box,  AMD Athlon 5400+, 3GB DDR2, Motherboard Gigabyte GA-M61P-S3
Hauppauge Nova-T PCI
Hauppauge Nova-S PCI
BlackGold Dual T2, S2 PCI
1x 2TB SATA
Windows 7 Pro
sub
Online

Administrator

NextPVR HQ, New Zealand
Posts: 102,403
Threads: 742
Joined: Nov 2003
#4
2008-07-09, 05:43 PM
fluffykeith Wrote:When does the watched indicator get set? I am guessing it is a sticky flag that is set when the program end is reached. I assume playback position is still reset at that point.
This is a known problem. It'll currently delete the entry if you play until the end. I intended to leave it there, and make the determination of whether to show the resume prompt based on the playback current position vs duration.
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Delete recordings from database but not from disk? spinnaker 8 2,753 2013-10-26, 10:51 PM
Last Post: spinnaker
  trying to fake npvr database for unit tests reven 3 1,691 2013-05-20, 08:53 AM
Last Post: reven
  Accessing music file metadata in C# bgowland 6 2,556 2013-01-26, 05:14 AM
Last Post: bgowland
  Merged database queries mvallevand 4 1,507 2011-06-26, 09:56 PM
Last Post: mvallevand
  NPVR database questions mvallevand 25 7,800 2011-01-06, 12:58 AM
Last Post: jksmurf
  NPVR database - why so stringy with the fields?? :0) carpeVideo 4 1,427 2010-09-21, 01:48 AM
Last Post: sub
  NPVR Database connection ralphy 4 1,866 2010-09-15, 12:09 AM
Last Post: sub
  How can I reset the Music plugin's database? mkenyon2 1 1,548 2009-10-15, 06:43 PM
Last Post: psycik
  SheduleRecording() locks database cb123 3 1,919 2009-02-14, 06:33 PM
Last Post: sub
  SQL database and backticks idkpmiller 6 3,431 2008-05-26, 08:32 AM
Last Post: idkpmiller

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode