Right now I’m using Microsoft SQL Community to start a database, but for some reason I can’t command the server to do something that I want, is there any to use the library sqlite3 or pyodc to print a value that I want on the console?
PYTHON:
connection = sqlite3.connect("REPLICATED_STORAGE.db") cursor = connection.cursor() sql_file = open("Template.sql") sql_as_string = sql_file.read() cursor.executescript(sql_as_string) for row in cursor.execute("SELECT * FROM FRUITS"): print(row)
SQL:
USE [REPLICATED_STORAGE] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FRUITS]( [COLOR] [nchar](10) NOT NULL, [TYPE] [nchar](10) NULL, [NAME] [nchar](10) NULL, [WEIGHT] [nchar](10) NULL ) ON [PRIMARY] GO
Advertisement
Answer
sqlite3
talks to SQLite databases.
If you want to talk to a Microsoft SQL Server, Microsoft recommends using pyodbc
. Follow the instructions to connect and run queries and the pyodbc documentation. To execute queries from a file, read the contents of the file and run it like any other query.
Note that executescript
is specific to sqlite3. Use execute
.