Re: connecting to MS SQL server in addition to default MySQL

2013-08-11 Thread Larry Martell
On Wed, Aug 7, 2013 at 3:03 PM, Andre Terra wrote: > You can use django-mssql[0] as a backend, and then either use the ORM as > usual, write RAW queries with Django[1] or just use SQL directly[2]. > > > Cheers, > AT > > [0] http://django-mssql.readthedocs.org/en/latest/ > [1] https://docs.djangopr

Re: connecting to MS SQL server in addition to default MySQL

2013-08-09 Thread Larry Martell
On Friday, August 9, 2013, Javier Guerra Giraldez wrote: > On Fri, Aug 9, 2013 at 8:53 AM, Larry Martell > > > wrote: > > On Friday, August 9, 2013, Javier Guerra Giraldez wrote: > >> > >> On Thu, Aug 8, 2013 at 9:22 PM, Larry Martell > >> > > > >> wrote: > >> > So all I can do is execute sql >

Re: connecting to MS SQL server in addition to default MySQL

2013-08-09 Thread Javier Guerra Giraldez
On Fri, Aug 9, 2013 at 8:53 AM, Larry Martell wrote: > On Friday, August 9, 2013, Javier Guerra Giraldez wrote: >> >> On Thu, Aug 8, 2013 at 9:22 PM, Larry Martell >> wrote: >> > So all I can do is execute sql >> > queries against it. >> >> >> good news: that's all the ORM needs. :-) > > > Don't

Re: connecting to MS SQL server in addition to default MySQL

2013-08-09 Thread Larry Martell
On Friday, August 9, 2013, Javier Guerra Giraldez wrote: > On Thu, Aug 8, 2013 at 9:22 PM, Larry Martell > > > wrote: > > So all I can do is execute sql > > queries against it. > > > good news: that's all the ORM needs. :-) Don't I need a models file that describes the schema? I don't even hav

Re: connecting to MS SQL server in addition to default MySQL

2013-08-09 Thread Javier Guerra Giraldez
On Thu, Aug 8, 2013 at 9:22 PM, Larry Martell wrote: > So all I can do is execute sql > queries against it. good news: that's all the ORM needs. :-) still, i've found myself on some situations where getting the ORM to work correctly wasn't worth the effort. mostly because of badly configured

Re: connecting to MS SQL server in addition to default MySQL

2013-08-08 Thread Larry Martell
I just have read-only access to the MS SQL server database. I can't install anything on the Windows box. So all I can do is execute sql queries against it. On Thu, Aug 8, 2013 at 9:19 AM, Michael Manfre wrote: > Any particular reason you want to completely avoid the ORM? My main project > that u

Re: connecting to MS SQL server in addition to default MySQL

2013-08-08 Thread Michael Manfre
Any particular reason you want to completely avoid the ORM? My main project that uses django-mssql started off with a lot of raw queries (including stored procedure calls) to work with the legacy business database. It was a maintenance headache and one of the main reasons I added support to dja

Re: connecting to MS SQL server in addition to default MySQL

2013-08-07 Thread Andre Terra
You can use django-mssql[0] as a backend, and then either use the ORM as usual, write RAW queries with Django[1] or just use SQL directly[2]. Cheers, AT [0] http://django-mssql.readthedocs.org/en/latest/ [1] https://docs.djangoproject.com/en/dev/topics/db/sql/ [2] https://docs.djangoproject.com/

connecting to MS SQL server in addition to default MySQL

2013-08-07 Thread Larry Martell
I have a django app that connects to a MySQL server in the usual way. I've noe been asked to add some new functionality that requires that I pull data from a MS SQL server database running on a Windows box. I don't want to use the django ORM with the db, just access it directly with some sql in my