Comments (9)
Couldn't you just remove the unwanted tables from the output?
from sqlacodegen.
Agreed!
from sqlacodegen.
Couldn't you just remove the unwanted tables from the output?
Also posted against #39.
Unsupported data types cause sqlacodegen to fail without producing any output. My example is spatial datatypes (geography and geometry) in MSSQL.
I still want to use SQLAlchemy for almost all my CRUD. I can hand roll my own CRUD for tables with spatial data, but it would be nice to be able to dump the model for most of my DB using sqlacodegen.
from sqlacodegen.
It would seem that the right solution then is for sqlacodegen to automatically skip tables it cannot handle. Agreed?
from sqlacodegen.
Also, if you can point me to a library which adds those geography/geometry types to MSSQL, I'd be happy to add a conditional import for that.
from sqlacodegen.
It would seem that the right solution then is for sqlacodegen to automatically skip tables it cannot handle. Agreed?
Ta, perfectly great for me. Would need some sort of feedback to user letting them know why the table was skipped.
Also, if you can point me to a library which adds those geography/geometry types to MSSQL, I'd be happy to add a conditional import for that.
The geoalchemy project would appear to add sqlalchemy support for MSSQL spatial datatypes but is not supported for Python >2.6.
The geoalchemy2 project, unfortunately does not support MSSQL, only PostGIS/Postgresql
Not found anyother liibraries to support MSSQL spatial types in SQLAlchemy.
from sqlacodegen.
Ta, perfectly great for me. Would need some sort of feedback to user letting them know why the table was skipped.
That's what I'll do then, assuming there are no problems with this approach coming from the sqlalchemy reflection process itself (which I do not control).
Not found anyother liibraries to support MSSQL spatial types in SQLAlchemy.
Are those types native to MSSQL? If they are, then it would be best to file a PR against SQLAlchemy itself.
from sqlacodegen.
Are those types native to MSSQL? If they are, then it would be best to file a PR against SQLAlchemy itself.
Yes, native types since sql server 2008. Will do. Thanks.
from sqlacodegen.
So are they native to MSSQL or not?
Yup, since MSSQL 2008.
from sqlacodegen.
Related Issues (20)
- Enhancement: Add Support for pgvector extension HOT 2
- SQLModel codegen produces syntax errors HOT 6
- Syntax Error in 3.0.0rc3 HOT 5
- No poetry package which supports SQLAlchemy 2.0 HOT 5
- AssertionError: TypeDecorator implementations require a class-level variable 'impl' HOT 14
- sqlalchemy.exc.OperationalError HOT 6
- Database URL is split on & HOT 1
- No module named 'pkg_resources' HOT 2
- ImportError: cannot import name 'ArgSpec' from 'inspect' HOT 1
- Can we push more versions to PyPi HOT 5
- Using types instead of strings in return values of methods in generators
- Issue when generating Postgres DOMAIN type HOT 2
- Could not assemble any primary key when using the SQLModel generator
- UUID for postgreSQL HOT 1
- Attribute error module 'sqlalchemy' has no attribute '__all__'. Did you mean: '__file__'? for mysql HOT 2
- MySQL DOUBLE(11,2) is converted to Double(11, True)
- Child table ORM classes inheriting from base tables are not generated HOT 5
- Installed on my windows10 python 3.12.4, get incompatible error HOT 3
- Missing many-to-many relationship HOT 1
- Error when reading vector column of pgvector HOT 6
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 sqlacodegen.