All Questions
10 questions
0
votes
1
answer
338
views
How to run a script when ever there is a new entry in database using SQLalchemy in python?
I am new to SQL Alchemy and need a way to run a script whenever a new entry is added to a table. I am currently using the following method to get the task done but I am sure there has to be a more ...
- 99
0
votes
0
answers
67
views
UnicodeDecodeError when appending pandas dataframe to Microsoft SQL table using Pandas
I am using python 2 to append dataframe to a Microsoft SQL table using Pandas to_sql function. The funny thing is when I run my code in environment A, which writes the dataframe to Table A, it can ...
- 1,428
6
votes
1
answer
6k
views
SQL Alchemy Check Connection
I created the below method to connect to SQL Server using SQL Alchemy and Pyodbc.
def getDBEngine(server, database):
Params = urllib.quote_plus("DRIVER={SQL Server};SERVER="+server+";DATABASE="+...
- 75
0
votes
1
answer
786
views
SQLAlchemy won't connect correctly but pyodbc and pymssql will
I have been trying to diagnose the issue in a Windows Python 2.7 (Anaconda installed) environment running SQLAlchemy=1.1.11, pyodbc=4.0.17, and pymssql=2.1.3.
Both pyodbc and pymssql connections will ...
- 797
0
votes
1
answer
936
views
Infer column type SQLAlchemy
Suppose I am using SQLAlchemy to upload a generic .csv file to an mssql server.
How can I infer the type of each column? It seems that one has to declare a column explicitly eg {'myvar' : Column(...
- 1,248
2
votes
1
answer
66
views
What is pythonic way with SQLAchemy to update dataset?
I want to implement a simple flow in my utils:
Get rs=Query() from DB
Iterate over rs and send request requests.get(rs['http'])
Parse response and get logo_url value
Update rs dataset
import requests
...
- 2,225
2
votes
1
answer
1k
views
Python mssql passing procedure user defined data type as parameter
My original purpose was to bulk insert into my db
I tried pyodbc, sqlalchemy and ceodbc to do this with executemany function but my dba checked and they execute each row individually.
his solution ...
- 351
0
votes
2
answers
431
views
How do I escape multiple query params for an IN() clause?
I am trying to perform a SELECT query with an IN() clause, and have sqlalchemy perform the
parameter escaping for me. I am using pyodbc as my database connector.
This is the code I have written so ...
- 91.2k
4
votes
1
answer
2k
views
single backslash needed in SQL Server query from Python / SQLAlchemy
I am trying to write a query using the BULK INSERT function in SQL Server 2014 via a python script to insert a large CSV file into a table in a database. I have the following example code:
import ...
- 1,083
0
votes
1
answer
469
views
Using existing table in sqlalchemy
Is there a way where I can use an existing table in my sql server with SQLAlchemy? I want to insert data and I want to use an existing table, a table I didn't define using classes.
I am using Python ...
- 477