Add reveal.js/sqlalchemy.html and reveal.js/dist/theme/fifty.css

3 files changed, 658 insertions, 0 deletions

diff --git a/reveal.js/dist/theme/fifty.css b/reveal.js/dist/theme/fifty.css
new file mode 100644
index 0000000..a55b3c2
--- /dev/null
+++ b/reveal.js/dist/theme/fifty.css
@@ -0,0 +1,297 @@
+/**
+ * A simple theme for reveal.js presentations, similar
+ * to the default theme. The accent color is brown.
+ *
+ * This theme is Copyright (C) 2012-2013 Owen Versteeg, http://owenversteeg.com - it is MIT licensed.
+ */
+.reveal a {
+  line-height: 1.3em; }
+
+section.has-dark-background, section.has-dark-background h1, section.has-dark-background h2, section.has-dark-background h3, section.has-dark-background h4, section.has-dark-background h5, section.has-dark-background h6 {
+  color: #fff; }
+
+/*********************************************
+ * GLOBAL STYLES
+ *********************************************/
+:root {
+  --background-color: #F0F1EB;
+  --main-font: Palatino Linotype, Book Antiqua, Palatino, FreeSerif, serif;
+  --main-font-size: 40px;
+  --main-color: #000;
+  --block-margin: 20px;
+  --heading-margin: 0 0 20px 0;
+  --heading-font: Palatino Linotype, Book Antiqua, Palatino, FreeSerif, serif;
+  --heading-color: #383D3D;
+  --heading-line-height: 1.2;
+  --heading-letter-spacing: normal;
+  --heading-text-transform: none;
+  --heading-text-shadow: none;
+  --heading-font-weight: normal;
+  --heading1-text-shadow: none;
+  --heading1-size: 3.77em;
+  --heading2-size: 2.11em;
+  --heading3-size: 1.55em;
+  --heading4-size: 1em;
+  --code-font: monospace;
+  --link-color: #51483D;
+  --link-color-hover: #8b7c69;
+  --selection-background-color: #26351C;
+  --selection-color: #fff; }
+
+.reveal-viewport {
+  background: #F0F1EB;
+  background-color: #F0F1EB; }
+
+.reveal {
+  font-family: "Palatino Linotype", "Book Antiqua", Palatino, FreeSerif, serif;
+  font-size: 24px;
+  font-weight: normal;
+  color: #000; }
+
+.reveal ::selection {
+  color: #fff;
+  background: #26351C;
+  text-shadow: none; }
+
+.reveal ::-moz-selection {
+  color: #fff;
+  background: #26351C;
+  text-shadow: none; }
+
+.reveal .slides section,
+.reveal .slides section > section {
+  line-height: 1.3;
+  font-weight: inherit; }
+
+/*********************************************
+ * HEADERS
+ *********************************************/
+.reveal h1,
+.reveal h2,
+.reveal h3,
+.reveal h4,
+.reveal h5,
+.reveal h6 {
+  margin: 0 0 20px 0;
+  color: #383D3D;
+  font-family: "Palatino Linotype", "Book Antiqua", Palatino, FreeSerif, serif;
+  font-weight: normal;
+  line-height: 1.2;
+  letter-spacing: normal;
+  text-transform: none;
+  text-shadow: none;
+  word-wrap: break-word; }
+
+.reveal h1 {
+  font-size: 3.77em; }
+
+.reveal h2 {
+  font-size: 2.11em; }
+
+.reveal h3 {
+  font-size: 1.55em; }
+
+.reveal h4 {
+  font-size: 1em; }
+
+.reveal h1 {
+  text-shadow: none; }
+
+/*********************************************
+ * OTHER
+ *********************************************/
+.reveal p {
+  margin: 20px 0;
+  line-height: 1.3; }
+
+/* Remove trailing margins after titles */
+.reveal h1:last-child,
+.reveal h2:last-child,
+.reveal h3:last-child,
+.reveal h4:last-child,
+.reveal h5:last-child,
+.reveal h6:last-child {
+  margin-bottom: 0; }
+
+/* Ensure certain elements are never larger than the slide itself */
+.reveal img,
+.reveal video,
+.reveal iframe {
+  max-width: 95%;
+  max-height: 95%; }
+
+.reveal strong,
+.reveal b {
+  font-weight: bold; }
+
+.reveal em {
+  font-style: italic; }
+
+.reveal ol,
+.reveal dl,
+.reveal ul {
+  display: inline-block;
+  text-align: left;
+  margin: 0 0 0 1em; }
+
+.reveal ol {
+  list-style-type: decimal; }
+
+.reveal ul {
+  list-style-type: disc; }
+
+.reveal ul ul {
+  list-style-type: square; }
+
+.reveal ul ul ul {
+  list-style-type: circle; }
+
+.reveal ul ul,
+.reveal ul ol,
+.reveal ol ol,
+.reveal ol ul {
+  display: block;
+  margin-left: 40px; }
+
+.reveal dt {
+  font-weight: bold; }
+
+.reveal dd {
+  margin-left: 40px; }
+
+.reveal blockquote {
+  display: block;
+  position: relative;
+  width: 70%;
+  margin: 20px auto;
+  padding: 5px;
+  font-style: italic;
+  background: rgba(255, 255, 255, 0.05);
+  box-shadow: 0px 0px 2px rgba(0, 0, 0, 0.2); }
+
+.reveal blockquote p:first-child,
+.reveal blockquote p:last-child {
+  display: inline-block; }
+
+.reveal q {
+  font-style: italic; }
+
+.reveal pre {
+  display: block;
+  position: relative;
+  width: 90%;
+  margin: 20px auto;
+  text-align: left;
+  font-size: 0.55em;
+  font-family: monospace;
+  line-height: 1.1em;
+  word-wrap: break-word; }
+  /* box-shadow: 0px 5px 15px rgba(0, 0, 0, 0.15); } */
+
+.reveal code {
+  font-family: monospace;
+  text-transform: none; }
+
+.reveal pre code {
+  display: block;
+  padding: 4px;
+  overflow: auto;
+  max-height: 520px;
+  word-wrap: normal; }
+
+.reveal table {
+  margin: auto;
+  border-collapse: collapse;
+  border-spacing: 0; }
+
+.reveal table th {
+  font-weight: bold; }
+
+.reveal table th,
+.reveal table td {
+  text-align: left;
+  padding: 0.2em 0.5em 0.2em 0.5em;
+  border-bottom: 1px solid; }
+
+.reveal table th[align="center"],
+.reveal table td[align="center"] {
+  text-align: center; }
+
+.reveal table th[align="right"],
+.reveal table td[align="right"] {
+  text-align: right; }
+
+.reveal table tbody tr:last-child th,
+.reveal table tbody tr:last-child td {
+  border-bottom: none; }
+
+.reveal sup {
+  vertical-align: super;
+  font-size: smaller; }
+
+.reveal sub {
+  vertical-align: sub;
+  font-size: smaller; }
+
+.reveal small {
+  display: inline-block;
+  font-size: 0.6em;
+  line-height: 1.2em;
+  vertical-align: top; }
+
+.reveal small * {
+  vertical-align: top; }
+
+.reveal img {
+  margin: 20px 0; }
+
+/*********************************************
+ * LINKS
+ *********************************************/
+.reveal a {
+  color: #51483D;
+  text-decoration: none;
+  transition: color .15s ease; }
+
+.reveal a:hover {
+  color: #8b7c69;
+  text-shadow: none;
+  border: none; }
+
+.reveal .roll span:after {
+  color: #fff;
+  background: #25211c; }
+
+/*********************************************
+ * Frame helper
+ *********************************************/
+.reveal .r-frame {
+  border: 4px solid #000;
+  box-shadow: 0 0 10px rgba(0, 0, 0, 0.15); }
+
+.reveal a .r-frame {
+  transition: all .15s linear; }
+
+.reveal a:hover .r-frame {
+  border-color: #51483D;
+  box-shadow: 0 0 20px rgba(0, 0, 0, 0.55); }
+
+/*********************************************
+ * NAVIGATION CONTROLS
+ *********************************************/
+.reveal .controls {
+  color: #51483D; }
+
+/*********************************************
+ * PROGRESS BAR
+ *********************************************/
+.reveal .progress {
+  background: rgba(0, 0, 0, 0.2);
+  color: #51483D; }
+
+/*********************************************
+ * PRINT BACKGROUND
+ *********************************************/
+@media print {
+  .backgrounds {
+    background-color: #F0F1EB; } }
diff --git a/reveal.js/images/sqlalchemy/sqla_arch.png b/reveal.js/images/sqlalchemy/sqla_arch.png
new file mode 100644
index 0000000..a1c0958
--- /dev/null
+++ b/reveal.js/images/sqlalchemy/sqla_arch.png
diff --git a/reveal.js/sqlalchemy.html b/reveal.js/sqlalchemy.html
new file mode 100755
index 0000000..956538f
--- /dev/null
+++ b/reveal.js/sqlalchemy.html
@@ -0,0 +1,361 @@
+<!doctype html>
+<html lang="en">
+  <head>
+    <meta charset="utf-8">
+    <title>SQLAlchemy &amp; Odin Data Access</title>
+    <meta name="author" content="Simeon Simeonov">
+    <meta name="apple-mobile-web-app-capable" content="yes">
+    <meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+    <link rel="stylesheet" href="dist/reset.css">
+    <link rel="stylesheet" href="dist/reveal.css">
+
+    <link rel="stylesheet" href="dist/theme/fifty.css" id="theme">
+
+    <!-- Theme used for syntax highlighting of code -->
+    <link rel="stylesheet" href="plugin/highlight/monokai.css" id="highlight-theme">
+    <!-- <link rel="stylesheet" href="plugin/highlight/zenburn.css" id="highlight-theme"> -->
+  </head>
+  <body>
+    <div class="reveal">
+
+      <!-- Any section element inside of this container is displayed as a slide -->
+      <div class="slides">
+
+        <section>
+          <h2>SQLAlchemy &amp; Odin Data Access</h2>
+          <h4>Fifty Data Science</h4>
+          </br>
+          <p><small>Simeon Simeonov</small></p>
+        </section>
+
+        <section>
+
+          <section id="fragments">
+            <h2>Agenda</h2>
+            </br>
+            <ul>
+              <span class="fragment"><li>SQLAlchemy - Design & overview</li></span>
+              <span class="fragment"><li>SQLAlchemy - A small practical example</li></span>
+              <span class="fragment"><li>Odin Data Access - Overview and examples</li></span>
+              <span class="fragment"><li>Q &amp; A</li></span>
+            </ul>
+          </section>
+
+        </section>
+
+        <section>
+          <h2>What is SQLAlchemy?</h2>
+          </br>
+          <p><em>SQLAlchemy</em> is a Python library created by Mike Bayer to provide a high-level Pythonic interface to RDBMS such as <em>PostgreSQL</em>, <em>SQLite</em>, <em>MySQL</em>, <em>Oracle</em>, <em>DB2</em>.</p>
+          <p><em>SQLAlchemy</em> includes RDBMS-independent SQL expression language and an <em>object-relational mapper (ORM)</em>.</p>
+        </section>
+
+        <section>
+          <h2>Why use SQLAlchemy?</h2>
+          </br>
+          <ul>
+            <li><p>portability - the programming interface is independent of the type of RDBMS and connector used</p></li>
+            <li><p>security - no more SQL injections</p></li>
+            <li><p>abstraction - no need to bother with complex JOINs</p></li>
+            <li><p>object-orientation - you work with objects and NOT tables and rows</p></li>
+            <li><p>performance - exploits the likehood of reusing a particular query</p></li>
+            <li><p>flexibility - you can override almost anything</p></li>
+          </ul>
+        </section>
+
+        <section>
+          <h2>Basic architecture</h2>
+          <p><em>SQLAlchemy</em> consists of several components, including the SQL expression language and the ORM.</p>
+          <p>In order to enable these components, <em>SQLAlchemy</em> also provides an <em>Engine</em> class and <em>MetaData</em> class.</p>
+          <ul>
+            <li><em>Engine</em>- manages the <em>SQLAlchemy</em> connection pool and the database-independent SQL dialect layer</li>
+            <li><em>MetaData</em> - used to collect and organize information about your table layout (schema)</li>
+            <li><em>Session</em> - establishes all conversations with the RDBMS and represents a "holding zone" for all the objects which you've loaded or associated with it during its lifespan</li>
+            <li><em>SQL expression language</em> - provides an API to execute your queries and updates against your tables, all from Python, and all in a database-independent way (low-level interface)</li>
+            <li><em>ORM</em> - provides a convenient way to add database persistence to your Python objects withoutrequiring you to design your objects around the database, or the database around the objects (high-level interface)</li>
+          </ul>
+          <img src="images/sqlalchemy/sqla_arch.png"></img>
+        </section>
+
+        <section data-auto-animate>
+          <h2>Example</h2>
+          <p><em>SQLAlchemy</em> gives us the choice between <em>classical mapping</em> and the newer <em>declarative mapping</em></p>
+          <pre data-id="code-animation">
+            <code class="python" data-trim data-line-numbers type="text/template">
+              import sqlalchemy
+              sqlalchemy.__version__
+
+              from sqlalchemy import create_engine
+
+              # engine = create_engine("postgresql+psycopg2://user:zipassword@localhost/mydb" , echo=True)
+              # The string form of the URL is dialect+driver://user:password@host/dbname[?key=value..],
+              # where dialect is a database name such as mysql, oracle, postgresql, etc.,
+              # and driver the name of a DBAPI, such as psycopg2, pyodbc, cx_oracle
+              # The echo flag is a shortcut to setting up SQLAlchemy logging,
+              # which is accomplished via Python’s standard logging module.
+              # With it enabled, we’ll see all the generated SQL produced.
+              # engine = create_engine("sqlite:///library.db", echo=True)
+              engine = create_engine("sqlite:///:memory:", echo=True)
+
+              metadata = MetaData()
+
+              from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
+
+              authors_table = Table(
+                  "authors",
+                  metadata,
+                  Column("id", Integer, primary_key=True),
+                  Column("name", String),
+              )  # Column("name", String(50)) is possible
+
+              books_table = Table(
+                  "books",
+                  metadata,
+                  Column("id", Integer, primary_key=True),
+                  Column("title", String),
+                  Column("description", String),
+                  Column("author_id", ForeignKey('authors.id')),
+              )
+
+              metadata.create_all(engine)  # creates the tables
+            </code>
+          </pre>
+        </section>
+
+        <section data-auto-animate>
+          <h2>Example (cont...)</h2>
+          <h4 data-id="code-title">Use of <em>SQL expression language</em></h4>
+          <pre data-id="code-animation">
+            <code class="python" data-trim data-line-numbers type="text/template">
+              insert_stmt = authors_table.insert(bind=engine)
+              type(insert_stmt)
+              # Out: &lt;class 'sqlalchemy.sql.expression.Insert'&gt;
+              print(insert_stmt)
+              # Out: INSERT INTO authors (id, name) VALUES (:id,:name)
+
+              compiled_stmt = insert_stmt.compile()
+              print(compiled_stmt.params)
+              # Out: {'id': None, 'name': None}
+
+              insert_stmt.execute(name="Alexandre Dumas")  # insert a single entry
+              insert_stmt.execute([{"name": 'Mr X'},{'name': 'Mr Y'}])  # a list of entries
+
+              metadata.bind = engine  # no need to explicitly bind the engine from now on
+              select_stmt = authors_table.select(authors_table.c.id==2)
+              result = select_stmt.execute()
+              result.fetchall()
+              # Out: [(1, u'Mr X')]
+
+              del_stmt = authors_table.delete()
+              del_stmt.execute(whereclause=text("name='Mr Y'"))
+              del_stmt.execute()  # delete all
+            </code>
+          </pre>
+        </section>
+
+        <section data-auto-animate>
+          <h2>Example (cont...)</h2>
+          <h4 data-id="code-title">Use of <em>classical mapping</em></h4>
+          <pre data-id="code-animation">
+            <code class="python" data-trim data-line-numbers type="text/template">
+              from sqlalchemy.orm import mapper
+              from sqlalchemy.orm import relationship, backref
+
+              class Author:
+                  def __init__(self, name):
+                      self.name = name
+
+                  def __str__(self):
+                      return self.name
+
+
+              class Book:
+                  def __init__(self, title, description, author):
+                      self.title = title
+                      self.description = description
+                      self.author = author
+
+                  def __str__(self):
+                      return self.title
+
+              mapper(Book, books_table)
+              mapper(Author, authors_table, properties = {"books": relation(Book, backref="author")})
+            </code>
+          </pre>
+        </section>
+
+        <section data-auto-animate>
+          <h2>Example (cont...)</h2>
+          <h4 data-id="code-title">Doing the same thing the easy way with <em>declarative mapping</em></h4>
+          <pre data-id="code-animation">
+            <code class="python" data-trim data-line-numbers type="text/template">
+              from sqlalchemy.ext.declarative import declarative_base
+              from sqlalchemy.orm import relationship, backref
+
+              Base = declarative_base()
+
+              class Author(Base):
+                  __tablename__ = "authors"
+
+                  id = Column(Integer, primary_key=True)
+                  name = Column(String)
+
+                  def __init__(self, name):
+                      self.name = name
+
+                  def __str__(self):
+                      return self.name
+
+
+              class Book(Base):
+                  __tablename__ = "books"  # self.__table__ will be available for our objects
+
+                  id = Column(Integer, primary_key=True)
+                  title = Column(String)
+                  description = Column(String)
+                  author_id = Column(Integer, ForeignKey("authors.id"))
+                  author = relationship(Author, backref=backref("books", order_by=title))
+
+                  def __init__(self, title, description, author):
+                      self.title = title
+                      self.description = description
+                      self.author = author
+
+                  def __str__(self):
+                      return self.title
+
+              Base.metadata.create_all(engine)# create tables
+            </code>
+          </pre>
+        </section>
+
+        <section data-auto-animate>
+          <h2>Example (cont...)</h2>
+          <h4 data-id="code-title">Creating instances</h4>
+          <pre data-id="code-animation">
+            <code class="python" data-trim data-line-numbers type="text/template">
+              from sqlalchemy.orm import sessionmaker
+
+              Session = sessionmaker(bind=engine)  # bound session
+              session = Session()
+
+              author_1 = Author("Richard Dawkins")
+              author_2 = Author("Matt Ridley")
+
+              book_1 = Book("The Red Queen", "A popular science book", author_2)
+              book_2 = Book("The Selfish Gene", "A popular science book", author_1)
+              book_3 = Book("The Blind Watchmaker", "The theory of evolutio", author_1)  # typo
+
+              session.add(author_1)
+              session.add(author_2)
+              session.add(book_1)
+              session.add(book_2)
+              session.add(book_3)  # or simply session.add_all([author_1, author_2, book_1, book_2, book_3])
+
+              # session.flush()
+              session.commit()  # flushes (issues the statements and sends them to the RDBMS) and commits
+
+              book_3.description = "The theory of evolution"  # update the object
+              book_3 in session   # check whether the object is in the session
+              # Out: True
+
+              session.commit()
+            </code>
+          </pre>
+        </section>
+
+        <section data-auto-animate>
+          <h2>Example (cont...)</h2>
+          <h4 data-id="code-title">Queries</h4>
+          <pre data-id="code-animation">
+            <code class="python" data-trim data-line-numbers type="text/template">
+              session.query(Book).order_by(Book.id)  # returns a Query instance with a .statement attribute
+              session.query(Book).order_by(Book.id).all()  # returns an object-list
+
+              # return all book objects where title == "The Selfish Gene"
+              session.query(Book).filter(Book.title == "The Selfish Gene").order_by(Book.id).all()
+
+              # using LIKE
+              session.query(Book).filter(Book.title.like("The%")).order_by(Book.id).all()
+
+              query = session.query(Book).filter(Book.id == 9).order_by(Book.id)
+              query.count()  # returns 0L
+              query.all()  # returns an empty list
+              query.first()  # returns None
+              query.one()  # raises NoResultFound exception
+
+              query = session.query(Book).filter(Book.id == 1).order_by(Book.id)
+              book_1 = query.one()
+              book_1.description  # returns "A popular science book"
+              book_1.author.books  # returns a list of Book-objects representing all the books from the same author.
+
+              # get a list of all Book-instances where the author"s name is "Richard Dawkins"
+              session.query(Book).filter(Book.author_id == Author.id).filter(Author.name == "Richard Dawkins").all()
+              session.query(Book).join(Author).filter(Author.name == "Richard Dawkins").all()
+              session.query(Book).\
+                  from_statement("SELECT b.* FROM books b, authors a WHERE b.author_id = a.id AND a.name=:name").\
+                  params(name="Richard Dawkins").all()
+            </code>
+          </pre>
+        </section>
+
+                <section data-background="http://i.giphy.com/90F8aUepslB84.gif">
+                  <h2>... simply amazing!</h2>
+                </section>
+
+                <section>
+                  <h2>Odin Data Access</h2>
+          <p><a href="https://gitlab.fifty.eu/odin/data-science/odin-data-access">https://gitlab.fifty.eu/odin/data-science/odin-data-access</a></p>
+          <p>Provides the <em>odin_data_access</em> module with some of the following entities:</p>
+          <ul>
+            <li><em>session</em> module for creating Session objects in a Fifty environment via <em>get_session</em> and <em>get_session_from_env</em></li>
+            <li><em>DBBase</em> - a tiny base-class that can be used as a mixin for mapping</li>
+            <li><em>DBTableAccessor</em> - tiny wrapper for <em>Session</em> and <em>Table</em> as well a "facade" for <em>Query</em> and <em>pandas</em></li>
+          </ul>
+          <p>The <em>DBTableAccessor</em>:</p>
+          <ul>
+            <li>represents a single RDBMS-table that is introspected during instance initialization (<em>__init__</em>)</li>
+            <li>uses a mix of <em>ORM</em> and <em>SQL expression language</em> functionality</li>
+            <li>contins a mapper for mapping custom classes to its corresponding <em>Table</em></li>
+            <span class="fragment"><li>used by Batman and Chuck Norris (source: incomplete Google search)</li></span>
+          </ul>
+                </section>
+
+        <section>
+          <h1>Demo</h1>
+          <p>Now watch this well-rehearsed demo...</p>
+        </section>
+
+        <section>
+          <h1>Q &amp; A</h1>
+        </section>
+
+      </div>
+    </div>
+    
+        <script src="dist/reveal.js"></script>
+        <script src="plugin/zoom/zoom.js"></script>
+        <script src="plugin/notes/notes.js"></script>
+        <script src="plugin/search/search.js"></script>
+        <script src="plugin/markdown/markdown.js"></script>
+        <script src="plugin/highlight/highlight.js"></script>
+        <script>
+
+          // Also available as an ES module, see:
+          // https://revealjs.netlify.app/initialization/
+          Reveal.initialize({
+                controls: true,
+                progress: true,
+                center: true,
+                hash: true,
+
+                // Learn about plugins: https://revealjs.netlify.app/plugins/
+                plugins: [ RevealZoom, RevealNotes, RevealSearch, RevealMarkdown, RevealHighlight ]
+          });
+      
+        </script>
+
+  </body>
+</html>