Comments (5)
I wrote to the sqlalchemy mailing list to address this issue: https://groups.google.com/forum/#!topic/sqlalchemy/fCJ7MTe6lKc
from sqlalchemy-exasol.
I took the liberty and mentioned your post in Exasol's IDEA area:
IDEA-193: Allow using CTE as source for MERGE, DELETE, UPDATE, SELECT INTO TABLE
from sqlalchemy-exasol.
@JoergRittinger - Do you have an example for the bad delete syntax? I have a small PR that I know fixes things for the insert case, and if you have a sqlalchemy expression that demonstrates the bad DELETE
syntax, I can see if I can fix that as well as part of my PR #81
from sqlalchemy-exasol.
I would suppose that you just replace the last line of the above example into something like
delete = table_C.delete(whereclause=table_C.c.int == query.c.int)
from sqlalchemy-exasol.
@JoergRittinger sorry for taking so long to get back to this.
I tried writing a few SQL queries that perform a DELETE
using a CTE and wasn't able to get Exasol to accept any version of the syntax I could come up with.
I looked at the Exasol documentation, and from my reading it doesn't seem like Exasol supports a CTE based DELETE
.
Given that I think PR #81 fixes all the issues that can be addressed by SQLAlchemy.
from sqlalchemy-exasol.
Related Issues (20)
- ✨ Add caching support for Exasol Dialects in respect to SQLA 1.4
- ✨ Add support for HASHTYPE, GEOMETRY and INTERVAL type
- ✨ Add list of un/supported SQLAlchemy features to documentation
- 🔧 Rework Integration Test Setup
- 🔧 Update Integration Test Docker Environment to 1.5.0
- 🐞 Difficult qmarks roundtrip tests fails
- 📦 Update SqlAlchemy package to version >=1.4 < 2.0.0
- Loosen version requirements on "packaging" HOT 1
- 🐞 After calling get_lastrowid through an insert, we see commit in the database. HOT 5
- 🐞 Prepared statements send the wrong types as parameters to the server HOT 1
- 🐞 Various SQLA compliance tests are failing for the websocket based dialect
- 🔧 Make pyodbc an optional dependency (feature) through setuptools extras HOT 3
- problem with Exasol driver's WebSocket connection cleanup process HOT 9
- 🔧 Add in code deprecation warnings for `[pyodbc, turbodbc]`
- 🔧 Remove `turbodbc` support
- 🔧 Remove `pyodbc` support
- 🔧 Remove tests/testing against Exasol 7.0.x
- ✨ Add support for testing of Exasol 8.x
- Support SQLAlchemy 2 HOT 3
- ✨ Make websocket types PEP-249 compliant HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlalchemy-exasol.