BaşlayınÜcretsiz Başlayın

Creating Database Connections

Before wiring a database into an MCP server, you'll get some practice with creating the connection, executing parameterized queries, and closing the connections.

A database called currencies.db, containing supported currencies from the European Central Bank, is already set up and available for you to connect to.

Bu egzersiz

Introduction to Model Context Protocol (MCP)

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Connect to the database file "currencies.db" and assign the connection to a variable named conn.
  • Execute the parameterized query, either with the "USD" test currency code, or with a valid code of your choosing.
  • Close the database connection.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

import sqlite3

# Connect to currencies.db
conn = sqlite3.____("currencies.db")
conn.row_factory = sqlite3.Row

# Execute the query
cursor = conn.____("SELECT code, name FROM currencies WHERE code = ? LIMIT 1", ("USD",))
row = cursor.fetchone()
print(dict(row))

# Close the connection
conn.____()
Kodu Düzenle ve Çalıştır