tmlbl
diff --git a/Collapse file
‎.gitignore‎
Copy file name to clipboard
+56Lines changed: 56 additions & 0 deletions b/Collapse file
‎.gitignore‎
Copy file name to clipboard
+56Lines changed: 56 additions & 0 deletions
diff --git a/Collapse file
‎LICENSE‎
Copy file name to clipboard
+21Lines changed: 21 additions & 0 deletions b/Collapse file
‎LICENSE‎
Copy file name to clipboard
+21Lines changed: 21 additions & 0 deletions
diff --git a/Collapse file
‎README.md‎
Copy file name to clipboard
+4Lines changed: 4 additions & 0 deletions
Display the source diff
Display the rich diff b/Collapse file
‎README.md‎
Copy file name to clipboard
+4Lines changed: 4 additions & 0 deletions
Display the source diff
Display the rich diff
diff --git a/Collapse file
‎requirements.txt‎
Copy file name to clipboard
+3Lines changed: 3 additions & 0 deletions b/Collapse file
‎requirements.txt‎
Copy file name to clipboard
+3Lines changed: 3 additions & 0 deletions
diff --git a/Collapse file
‎shippable.yml‎
Copy file name to clipboard
+20Lines changed: 20 additions & 0 deletions b/Collapse file
‎shippable.yml‎
Copy file name to clipboard
+20Lines changed: 20 additions & 0 deletions
diff --git a/Collapse file
‎sql.py‎
Copy file name to clipboard
+32Lines changed: 32 additions & 0 deletions b/Collapse file
‎sql.py‎
Copy file name to clipboard
+32Lines changed: 32 additions & 0 deletions
diff --git a/Collapse file
‎test.py‎
Copy file name to clipboard
+19Lines changed: 19 additions & 0 deletions b/Collapse file
‎test.py‎
Copy file name to clipboard
+19Lines changed: 19 additions & 0 deletions
@@ -0,0 +1,56 @@
+.idea/
+
+# Byte-compiled / optimized / DLL files
+__pycache__/
+*.py[cod]
+
+# C extensions
+*.so
+
+# Distribution / packaging
+.Python
+env/
+bin/
+build/
+develop-eggs/
+dist/
+eggs/
+lib/
+lib64/
+parts/
+sdist/
+var/
+*.egg-info/
+.installed.cfg
+*.egg
+
+# Installer logs
+pip-log.txt
+pip-delete-this-directory.txt
+
+# Unit test / coverage reports
+htmlcov/
+.tox/
+.coverage
+.cache
+nosetests.xml
+coverage.xml
+
+# Translations
+*.mo
+
+# Mr Developer
+.mr.developer.cfg
+.project
+.pydevproject
+
+# Rope
+.ropeproject
+
+# Django stuff:
+*.log
+*.pot
+
+# Sphinx documentation
+docs/_build/
+
@@ -0,0 +1,21 @@
+The MIT License (MIT)
+
+Copyright (c) 2014 Tim
+
+Permission is hereby granted, free of charge, to any person obtaining a copy
+of this software and associated documentation files (the "Software"), to deal
+in the Software without restriction, including without limitation the rights
+to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+copies of the Software, and to permit persons to whom the Software is
+furnished to do so, subject to the following conditions:
+
+The above copyright notice and this permission notice shall be included in all
+copies or substantial portions of the Software.
+
+THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
+SOFTWARE.
@@ -0,0 +1,4 @@
+Python PostgreSQL Sample [![Build Status](https://apibeta.shippable.com/projects/537a42ba326b4d0f004a332c/badge/master)](https://beta.shippable.com/projects/537a42ba326b4d0f004a332c)
+======================
+
+Tests basic SQL commands using the psycopg2 driver for Python.
@@ -0,0 +1,3 @@
+psycopg2
+nose
+coverage
@@ -0,0 +1,20 @@
+language: python
+
+python:
+  - 2.7
+  
+install:
+  - pip install -r requirements.txt
+
+# Postgres binds to 127.0.0.1 by default and is started on boot. Default username is "postgres" with no password
+# Create a DB as part of before script to use it
+
+before_script:
+  - psql -c 'create database test;' -U postgres
+  - mkdir -p shippable/testresults
+  - mkdir -p shippable/codecoverage
+
+script:
+  - nosetests test.py --with-xunit --xunit-file=shippable/testresults/nosetests.xml
+  - which python && coverage run --branch test.py
+  - which python && coverage xml -o shippable/codecoverage/coverage.xml test.py
@@ -0,0 +1,32 @@
+import psycopg2 as pg
+
+
+class Postgres():
+    def __init__(self):
+        self.conn_string = "host='127.0.0.1' dbname='test' user='postgres' password=''"
+        self.conn = pg.connect(self.conn_string)
+        self.cursor = self.conn.cursor()
+
+    def populate(self):
+        self.cursor.execute("DROP TABLE IF EXISTS things;")
+        self.cursor.execute("CREATE TABLE things (name varchar(20));")
+        self.cursor.execute("INSERT INTO things(name) VALUES('Dre');")
+        self.cursor.execute("INSERT INTO things(name) VALUES('Smalls');")
+        self.cursor.execute("INSERT INTO things(name) VALUES('West');")
+        self.cursor.execute("INSERT INTO things(name) VALUES('Combs');")
+        self.cursor.execute("INSERT INTO things(name) VALUES('Flame');")
+
+    def read(self):
+        self.cursor.execute("SELECT * FROM things;")
+        count = self.cursor.fetchall()
+        return len(count)
+
+    def disconnect(self):
+        if self.conn:
+            self.conn.close()
+
+if __name__ == '__main__':
+    postgres = Postgres()
+    postgres.populate()
+    postgres.read()
+    postgres.disconnect()
@@ -0,0 +1,19 @@
+import unittest
+from sql import Postgres
+
+
+class Test(unittest.TestCase):
+
+    def test_db(self):
+        pg = Postgres()
+        pg.populate()
+        count = pg.read()
+        self.failIf(count != 5)
+        pg.disconnect()
+
+
+def main():
+    unittest.main()
+
+if __name__ == '__main__':
+    main()