Skip to content
master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
sql
 
 
 
 
 
 
 
 
 
 
 
 
 
 

lsdb

lsdb is a python/pyobjc command line utility for Macintosh that inspects files and directories and stores the file info and metadata in a MySQL database.

lsdb and its associated MySQL database files are part of a larger asset management system.

installation

Source available via github. Installations steps are the usual:

git clone git://github.com/donbro/lsdb.git
cd lsdb
python setup.py install
python setup.py test

or to install just for the local user:

python setup.py install --prefix=${HOME}

or, to use it without installing, e.g., for development work:

python setup.py develop

In this case the lsdb script points to the working version, not an installed version.

In the future we would like to have something like:

$ sudo pip install lsdb

but for now this is just an in-house utility.

license

Please read LICENSE.txt in this directory.

database

The MySQL database can be created using

vi `lsdb --create-tables`

Basic usage

Usage: lsdb [options] [filename(s)] 

Options:
  --version             show program's version number and exit
  -h, --help            show this help message and exit
  -r, --recursive       Recursively process subdirectories. Recursion can be
                        limited by setting DEPTH.
  -v, --verbose         increment verbose count by one.  default=1
  -q, --quiet           Normal operation is to output one status line per
                        file, status being "inserted", "existing", etc. This
                        option will prevent any output to stdout, Significant
                        errors are still output to stderr.
  -d DEPTH, --depth-limit=DEPTH, --depth=DEPTH
                        limit recusion DEPTH. using DEPTH = 0 means process
                        the directory only.  DEPTH=None means no depth limit
                        (use with caution). Recursion is implied when any
                        depth-limit is specified. default is none.
  -f, --force-folder-scan
                        explicitly check contents of directories even if
                        directory timestamp not newer thandatabase value.
                        Normal operation does not check the contents of a
                        directory if its timestamp equalsthat in the database.
                        default = False

inspecting and storing file info on a single file can involve building a chain downwards from the root of the volume:

$ lsdb "/Volumes/Saratoga/TV Series/Sanctuary/S03/Sanctuary - 3x20 - Into the Black.mkv"

might create output like:

creating   None     Thu 2012-07-05 15:53:24 EDT /Volumes/Saratoga
create     vol0008  Wed 2013-01-23 02:40:12 EST /Volumes/Saratoga
insert     vol0008  Thu 2013-01-17 02:11:11 EST /Volumes/Saratoga/TV Series
insert     vol0008  Thu 2012-07-05 19:30:13 EDT /Volumes/Saratoga/TV Series/Sanctuary
insert     vol0008  Wed 2012-01-04 21:56:45 EST /Volumes/Saratoga/TV Series/Sanctuary/S03
insert     vol0008  Thu 2011-10-27 03:18:02 EDT /Volumes/Saratoga/TV Series/Sanctuary/S03/Sanctuary - 3x20 - Into the Black.mkv
insert     vol0008                              AAC4CF1B-3C63-3A18-A85C-05F8FA37761D

a different file in the same directory will now find as existing the volume and all of the same directories:

$ lsdb "/Volumes/Saratoga/TV Series/Sanctuary/S03/Sanctuary - 3x10 - Hollow Men.avi" 

might create:

found      vol0008  Thu 2012-07-05 15:53:24 EDT /Volumes/Saratoga
existing   vol0008  Wed 2013-01-23 02:40:12 EST /Volumes/Saratoga
existing   vol0008  Thu 2013-01-17 02:11:11 EST /Volumes/Saratoga/TV Series
existing   vol0008  Thu 2012-07-05 19:30:13 EDT /Volumes/Saratoga/TV Series/Sanctuary
existing   vol0008  Wed 2012-01-04 21:56:45 EST /Volumes/Saratoga/TV Series/Sanctuary/S03
insert     vol0008  Mon 2010-12-20 02:40:46 EST /Volumes/Saratoga/TV Series/Sanctuary/S03/Sanctuary - 3x10 - Hollow Men.avi
existing   vol0008                              AAC4CF1B-3C63-3A18-A85C-05F8FA37761D

Advanced usage

import tvdb_api
t = tvdb_api.Tvdb()
episode = t['My Name Is Earl'][1][3] # get season 1, episode 3 of show
print episode['episodename'] # Print episode name

Or, if you want to run in the background:

python -d -f /path/to/sabnzbd.ini

Most of the documentation is in docstrings. The examples are tested (using doctest) so will always be up to date and working.

The docstring for Tvdb.__init__ lists all initialisation arguments, including support for non-English searches, custom "Select Series" interfaces and enabling the retrieval of banners and extended actor information. You can also override the default API key using apikey, recommended if you're using tvdb_api in a larger script or application

Features include:

  • automatically retrieves new episode torrent or nzb files
  • can scan your existing library and then download any old seasons or episodes you're missing
  • can watch for better versions and upgrade your existing episodes (to from TV DVD/BluRay for example)
  • XBMC library updates, poster/fanart downloads, and NFO/TBN generation
  • configurable episode renaming
  • sends NZBs directly to SABnzbd, prioritizes and categorizes them properly
  • available for any platform, uses simple HTTP interface
  • can notify XBMC, Growl, or Twitter when new episodes are downloaded
  • specials and double episode support

Sick Beard makes use of the following projects:

Dependencies

To run Sick Beard from source you will need Python 2.5+ and Cheetah 2.1.0+. The binary releases are standalone.

Bugs

If you find a bug please report it or it'll never get fixed. Verify that it hasn't already been submitted and then log a new bug. Be sure to provide as much information as possible.

About

lsdb converts between filesystem metadata, data format files, and database

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages