You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
<h1id="Create-A-Database">Create A Database<aclass="anchor-link" href="#Create-A-Database">¶</a></h1><p>For this tutorial, we'll use the <ahref="http://www.sqlalchemy.org/">sqlalchemy</a> Python library to communicate with a database.</p>
65
+
<h1id="Create-A-Database">Create A Database<aclass="anchor-link" href="#Create-A-Database">¶</a></h1><p>For this tutorial, we'll use the <ahref="http://www.sqlalchemy.org/">SQLAlchemy</a> Python library to communicate with a database.</p>
66
66
<p>Let's import it:</p>
67
67
68
68
</div>
@@ -85,10 +85,10 @@ <h1 id="Create-A-Database">Create A Database<a class="anchor-link" href="#Create
<p>Sqlalchemy uses an "engine" object to interact with a database.</p>
88
+
<p>SQLAlchemy uses an "engine" object to interact with a database.</p>
89
89
<p>To create an engine, we first need to choose a Database Management System (DBMS). We'll use <ahref="https://sqlite.org/index.html">SQLite</a> as our DBMS.</p>
90
-
<p>Next, we have to define a connection URL. The URL tells sqlalchemy which DBMS we have chosen and how to connect to our database.</p>
91
-
<p>SQLite uses a single file for each database and the structure of the URL we need for sqlalchemy is:</p>
90
+
<p>Next, we have to define a connection URL. The URL tells SQLAlchemy which DBMS we have chosen and how to connect to our database.</p>
91
+
<p>SQLite uses a single file for each database and the structure of the URL we need for SQLAlchemy is:</p>
92
92
93
93
<pre><code>sqlite:///<path to the database file></code></pre>
94
94
<p>Our example database will contain data about High Altitude Balloon flights. Let's name our database file <code>flight.db</code> and create an engine object for it:</p>
@@ -114,7 +114,7 @@ <h1 id="Create-A-Database">Create A Database<a class="anchor-link" href="#Create
<p>We can now connect to our database using the <code>connect()</code> method of our engine.</p>
117
-
<p>Sqlalchemy will look for the file we specified in our URL and establish a connection to our database. If the file doesn't exist, sqlalchemy will create and then make the connection.</p>
117
+
<p>SQLAlchemy will look for the file we specified in our URL and establish a connection to our database. If the file doesn't exist, sqlalchemy will create and then make the connection.</p>
0 commit comments