this can be contributed. the basic idea can be emulated from the SQLite version of the type, given in this change:
https://github.com/sqlalchemy/sqlalchemy/commit/62d59088dfe86d7ecabd85ad626ee108b668acc5 note the main reason you'd want to make a JSON type is because you need the SQL expression support, like table.c.mycolumn['foo'] == 'bar'. if you just need to persist and load JSON, a simple UserDefinedType https://docs.sqlalchemy.org/en/latest/core/custom_types.html?highlight=userdefinedtype#creating-new-types can get you that. the main thing to determine is if the driver you're using, eg. pyodbc or pymssql, supports JSON natively, or if you need to be doing the loads() / dumps() explicitly. To sum up, two questions: 1. do you need SQL expression support (or are you just looking to contribute to SQLAlchemy in any case, in case, great!), or do you just need to store and retrieve JSON objects right now. 2. do pyodbc/pymssql support JSON or do we have to send/receive strings that we convert ourselves. from those questions we can figure out the best strategy. On Wed, Nov 28, 2018 at 9:41 AM sanjeev kumar <raj.rishi...@gmail.com> wrote: > > Do sqlalchemy have support for MSsql 2016 JSON type.Or any project is going > on for same,if any how i can contribute to that project. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
