tableau · doulam · Nov 1, 2016 · Nov 2, 2016 · Nov 3, 2016 · Nov 3, 2016
diff --git a/.gitignore b/.gitignore
@@ -65,5 +65,11 @@ target/
 .DS_Store
 .idea
 
+#Editor things
+*.sublime-project
+*.sublime-workspace
+settings.json
+tasks.json
+
 #Jekyll
 docs/_site
diff --git a/.travis.yml b/.travis.yml
@@ -6,17 +6,18 @@ python:
   - "3.3"
   - "3.4"
   - "3.5"
+  - "3.6"
   - "pypy"
 # command to install dependencies
 install:
   - "pip install -e ."
-  - "pip install pep8"
+  - "pip install pycodestyle"
 # command to run tests
 script:
   # Tests
   - python setup.py test
-  # pep8
-  - pep8 .
+  # pycodestyle
+  - pycodestyle tableaudocumentapi test samples
   # Examples
   - (cd "samples/replicate-workbook" && python replicate_workbook.py)
   - (cd "samples/list-tds-info" && python list_tds_info.py)

diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -1,3 +1,11 @@
+## 06 (11 January 2017)
+
+* Initial SQL and query banding support (#123)
+* Fixed bug in xfiles to allow opening workbooks with external file caches (#117, #118)
+* Code Cleanup (#120, #121)
+* Added Py36 support (#124)
+* Switched to pycodestyle from pip8 on travis runs (#124)
+
 ## 05 (01 November 2016)
 
 * Added ability to set the port for connections (#97)

diff --git a/CONTRIBUTORS.md b/CONTRIBUTORS.md
@@ -6,6 +6,7 @@ The following people have contributed to this project to make it possible, and w
 
 * [Charley Peng](https://github.com/chid)
 * [Miguel Sánchez](https://github.com/MiguelSR)
+* [Ryan Richmond](https://github.com/r-richmond)
 
 ## Core Team
 

diff --git a/README.md b/README.md
@@ -4,6 +4,10 @@
 
 This repo contains Python source and example files for the Tableau Document API. We're just getting started and have plans to expand what you find here. Help us by submitting feedback, issues, and pull requests!
 
+For more information, see the documentation:
+
+<http://tableau.github.io/document-api-python>
+
 Document API
 ---------------
 The Document API provides a supported way to programmatically make updates to Tableau workbook and data source files. If you've been making changes to these file types by directly updating the XML--that is, by XML hacking--this SDK is for you :)
@@ -26,84 +30,3 @@ Features include:
   - Get all fields in use by certain sheets in a workbook
 
 We don't yet support creating files from scratch, adding extracts into workbooks or data sources, or updating field information
-
-
-###Getting Started
-To use this SDK, you must have Python installed. You can use either 2.7.X or 3.3 and later.
-
-#### Installing the latest stable version (preferred)
-
-```text
-pip install tableaudocumentapi
-```
-
-#### Installing From Source
-
-Download the `.zip` file that contains the SDK. Unzip the file and then run the following command:
-
-```text
-pip install -e <directory containing setup.py>
-```
-
-#### Installing the Development Version from Git
-
-*Only do this if you know you want the development version, no guarantee that we won't break APIs during development*
-
-```text
-    pip install git+https://github.com/tableau/document-api-python.git@development
-```
-
-If you go this route, but want to switch back to the non-development version, you need to run the following command before installing the stable version:
-
-```text
-pip uninstall tableaudocumentapi
-```
-
-###Basics
-The following example shows the basic syntax for using the Document API to update a workbook:
-
-```python
-from tableaudocumentapi import Workbook
-
-sourceWB = Workbook('WorkbookToUpdate.twb')
-
-sourceWB.datasources[0].connections[0].server = "MY-NEW-SERVER"
-sourceWB.datasources[0].connections[0].dbname = "NEW-DATABASE"
-sourceWB.datasources[0].connections[0].username = "benl"
-
-sourceWB.save()
-```
-
-With Data Integration in Tableau 10, a data source can have multiple connections. To access the connections simply index them like you would datasources.
-
-```python
-from tableaudocumentapi import Workbook
-
-sourceWB = Workbook('WorkbookToUpdate.twb')
-
-sourceWB.datasources[0].connections[0].server = "MY-NEW-SERVER"
-sourceWB.datasources[0].connections[0].dbname = "NEW-DATABASE"
-sourceWB.datasources[0].connections[0].username = "benl"
-
-sourceWB.datasources[0].connections[1].server = "MY-NEW-SERVER"
-sourceWB.datasources[0].connections[1].dbname = "NEW-DATABASE"
-sourceWB.datasources[0].connections[1].username = "benl"
-
-
-sourceWB.save()
-```
-
-
-**Notes**
-
-- Import the `Workbook` object from the `tableaudocumentapi` module.
-- To open a workbook, instantiate a `Workbook` object and pass the file name as the first argument.
-- The `Workbook` object exposes a list of `datasources` in the workbook
-- Each data source object has a `connection` object that supports a `server`, `dbname`, and `username` property.
 - Save changes to the workbook by calling the `save` or `save_as` method.
-
-
-
-###[Examples](samples)
-
-The downloadable package contains several example scripts that show more detailed usage of the Document API.
diff --git a/docs/_includes/analytics.html b/docs/_includes/analytics.html
@@ -0,0 +1,7 @@
+<!-- Google Tag Manager -->
+<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
+new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
+j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
+'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
+})(window,document,'script','dataLayer','GTM-BVCN');</script>
+<!-- End Google Tag Manager -->
diff --git a/docs/_includes/head.html b/docs/_includes/head.html
@@ -11,5 +11,7 @@
   <link rel="stylesheet" href="{{ site.baseurl }}/css/main.css">
   <link rel="stylesheet" href="{{ site.baseurl }}/css/github-highlight.css">
 
-  <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
+  <script src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
   <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
+
+{% if jekyll.environment == "production" %}{% include analytics.html %}{% endif %}
diff --git a/docs/docs/api-ref.md b/docs/docs/api-ref.md
@@ -48,6 +48,30 @@ class Datasource(dsxml, filename=None)
 class Connection(connxml)
 ```
 
+The Connection class represents a tableau data connection. It can be from any type of connection found in `dbclass.py` via `is_valid_dbclass`
+
+**Params:**
+
+**Raises:**
+
+**Methods:**
+
+**Properities:**
+
+`self.server:` Returns a string containing the server.
+
+`self.dbname:` Returns a string containing the database name.
+
+`self.username:` Returns a string containing the username.
+
+`self.dbclass:` Returns a string containing the database class.
+
+`self.port:` Returns a string containing the port.
+
+`self.query_band:` Returns a string containing the query band.
+
+`self.initial_sql:` Returns a string containing the initial sql.
+
 ## Fields
 ```python
 class Workbook(column_xml=None, metadata_xml=None)

diff --git a/docs/docs/dev-guide.md b/docs/docs/dev-guide.md
@@ -3,7 +3,6 @@ title: Developer Guide
 layout: docs
 ---
 
-<<<<<<< 6ee666bf06d5ab59931100b3955779c35693e33f
 ## Submitting your first patch
 
 1. Make sure you have [signed the CLA](http://tableau.github.io/#contributor-license-agreement-cla)
@@ -53,7 +52,7 @@ layout: docs
    Our documentation is written in markdown and built with Jekyll on Github Pages. All of the documentation source files can be found in `docs/docs`.
 
    When adding a new feature or improving existing functionality we may ask that you update the documentation along with your code.
-   
+
    If you are just making a PR for documentation updates (adding new docs, fixing typos, improving wording) the easiest method is to use the built in `Edit this file` in the Github UI
 
 1. Submit to your fork.

diff --git a/setup.py b/setup.py
@@ -5,7 +5,7 @@
 
 setup(
     name='tableaudocumentapi',
-    version='0.5',
+    version='0.6',
     author='Tableau',
     author_email='github@tableau.com',
     url='https://github.com/tableau/document-api-python',