pc-pdx

## sony_bravia.md

      
              1 file
            
          
              8 forks
            
          
              27 comments
            
          
              65 stars
            
          
                kalleth
                / sony_bravia.md
            
            
              Last active
              June 18, 2024 06:56
            
          
    Sony Bravia HTTP API

The sony bravia has a HTTP API interacted with using a Pre-Shared key. There's
a more complex auth flow but I've not described it here.
There wasn't any documentation, so I've written some. If you're a TV integrator
don't read this, you'll laugh. I'm probably just getting confused by UPnP.
Disclaimer: I've only tested this on my TV, which is a KDL-50W829B. Your TV
might not have all of the services; see Available services section for how to
discover what your TV supports.

  
## Umbraco - Delete Older Versions.sql
-- set how many versions to keep using @numberOfVersionToKeep, this can be set to anything from 0 and above. 0 will clean all versions except the current of course.
-- actually delete stuff by modifying last line to 'commit tran'

begin tran
go

DECLARE @numberOfVersionToKeep int = 20

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP Table #tmp
create table #tmp (versionid uniqueidentifier)