semvec/pypi-packages huggingface dataset:
python-tds 1.8.2
Python DBAPI driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation
License: MIT

pytds
=====

.. image:: https://secure.travis-ci.org/denisenkom/pytds.png?branch=master
   :target: https://travis-ci.org/denisenkom/pytds


`Python DBAPI`_ driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation.
Doesn't depend on ADO or FreeTDS.  Can be used on any platform, including Linux, MacOS, Windows.

It can be used with https://pypi.python.org/pypi/django-sqlserver as a Django database backend.

Features
--------

* Fully supports new MSSQL 2008 date types: datetime2, date, time, datetimeoffset
* MARS

Missing Features
----------------

* SSL encryption

Installation
------------

To install run this command:

.. code-block:: bash

    $ pip install python-tds

For a better performance install bitarray package too:

.. code-block:: bash

    $ pip install bitarray

Documentation
-------------
Documentation is available at http://python-tds.readthedocs.org/en/latest/.

Example
-------

To connect to database do

.. code-block:: python

    import pytds
    with pytds.connect('server', 'database', 'user', 'password') as conn:
        with conn.cursor() as cur:
            cur.execute("select 1")
            cur.fetchall()


.. _Python DBAPI: http://legacy.python.org/dev/peps/pep-0249/
musichaos 0.1.0
tool to tidy up your music chaos
License: MIT

Musichaos
=========

    Bring tidiness into your music chaos

--------------

``musichaos`` is a tool to tidy up the chaos in your local music library
on a file basis. It pulls the tags from the audio files and structures
the audio files like this:

::

    ~/music
    │   ├── Artist 01
    │   │   └── Album 01
    │   │   │   └── Title 01
    │   │   │   │── Title 02
    │   ├── Artist 02
    │   │   └── Album 01
    │   │   │   └── Title 01
    │   │   │   │── Title 02

Installation
------------

From pip:

.. code:: bash

    pip install musichaos

From source:

::

    git clone https://github.com/timofurrer/musichaos
    cd musichaos
    pip install .

Usage - Command Line Interface
------------------------------

``musichaos`` can be used as a CLI tool.

To use it just specify the root directory which contains your music
chaos and a target directory where to put the clean structure. They can
point to the same location.

::

    musichaos ~/downloads ~/music

This will end up in the following structure

::

    ~/music
    │   ├── Artist 01
    │   │   └── Album 01
    │   │   │   └── Title 01
    │   │   │   │── Title 02
    │   ├── Artist 02
    │   │   └── Album 01
    │   │   │   └── Title 01
    │   │   │   │── Title 02

If you do not want to move the audio file but link them instead - run
the following command:

::

    musichaos ~/downloads ~/music --link

This will end up in the following structure

::

    ~/music
    │   ├── Artist 01
    │   │   └── Album 01
    │   │   │   └── Title 01 -> ../../../downloads/Some_weird_audio_file_01.mp3
    │   │   │   │── Title 02 -> ../../../downloads/Some_weird_audio_file_02.mp3
    │   ├── Artist 02
    │   │   └── Album 01
    │   │   │   └── Title 01 -> ../../../downloads/Some_weird_audio_file_03.mp3
    │   │   │   │── Title 02 -> ../../../downloads/Some_weird_audio_file_04.mp3

If you are not sure what ``musichaos`` will do - just do a dry run:

::

    musichaos ~/downloads ~/music --dry-run

Let's have a look at the help message:

::

    Usage: __main__.py [OPTIONS] ROOTDIR TARGETDIR

      Tidy up your music chaos.

    Options:
      -l, --link  Link audio files instead of move.
      --dry-run   Run a dry run.
      --help      Show this message and exit.

Usage - Python Package
----------------------

``musichaos`` can be imported in your python project, too. Just install
it in your python environment and ``import musichaos``:

.. code:: python

    from musichaos import Musichaos

    chaos = Musichaos(rootdir)
    chaos.tidy_up(targetdir, link, dry_run)

Supported Audio File Formats
----------------------------

At the moment the following file formats are supported:

-  ASF (\*.asf)
-  FLAC (\*.flac)
-  M4A (\*.m4a)
-  Monkey's Audio (\*.ape)
-  MP3 (\*.mp3)
-  Musepack (*.mpc, *.mp+, \*.mpp)
-  Ogg Opus, Ogg FLAC, Ogg Speex, Ogg Theora, Ogg Vorbis (*.ogg, *.ogv,
   *.oga, *.ogx, *.ogm, *.spx, \*opus)
-  True Audio (\*.tta)
-  WavPack (\*.wv)
-  OptimFROG (\*.mp3)
-  AIFF (*.aiff, *.aif, \*.aifc)