Re: [web2py] Re: DAL and schema

2013-07-08 Thread Johann Spies
On 28 June 2013 01:08, Alex wrote: > I'd also appreciate schema support for web2py. > +1 -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- You received this message because you are subscribed to the Google Groups "web2py-users

Re: [web2py] Re: DAL and schema

2013-06-28 Thread mcamel
Yes, the word ACROSS clarifies it. Besides, i've got another problem escaping SQL. I want to add this to the SQL sentence: WHERE b.type LIKE 'L''%' E.g. all types beggining with an L and following with an apostrophe. I've escaped the apostrophe writing it twice, but if filter is user input i

Re: [web2py] Re: DAL and schema

2013-06-27 Thread Alex
I'd also appreciate schema support for web2py. I'm working on a project with Postgres and different schemas. For now I could solve the problem with adding the schema to the db search path. Since we are creating new tables we can make sure they are unique, for legacy systems it could be problema

Re: [web2py] Re: DAL and schema

2013-06-27 Thread Vinicius Assef
Sorry, my fault. On Thu, Jun 27, 2013 at 8:53 AM, Anthony wrote: > On Thursday, June 27, 2013 7:42:54 AM UTC-4, viniciusban wrote: >> >> See this: http://web2py.com/books/default/chapter/29/06#Inner-joins > > > He was asking about joining tables across MySQL schemas. > > -- > > --- > You received

Re: [web2py] Re: DAL and schema

2013-06-27 Thread Anthony
On Thursday, June 27, 2013 7:42:54 AM UTC-4, viniciusban wrote: > See this: http://web2py.com/books/default/chapter/29/06#Inner-joins > He was asking about joining tables across MySQL schemas. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" gr

Re: [web2py] Re: DAL and schema

2013-06-27 Thread Vinicius Assef
See this: http://web2py.com/books/default/chapter/29/06#Inner-joins On Thu, Jun 27, 2013 at 7:45 AM, mcamel wrote: > Hi, > > I have the same problem with a legacy MySQL database. > > We have different Schemas and need to use plenty of JOINs of tables from > different Schemas. I've couldn't find a

Re: [web2py] Re: DAL and schema

2013-06-27 Thread mcamel
Hi, I have the same problem with a legacy MySQL database. We have different Schemas and need to use plenty of JOINs of tables from different Schemas. I've couldn't find any solution for this in the documentation, so the only way i've found is writing the SQL of my own, like in: SELECT b.seria

Re: [web2py] Re: DAL and schema

2012-05-09 Thread Johann Spies
I made some progress. I was trying to connect to the wrong database. That caused my 'hanging' problem of yesterday. I have succeeded in creating auth_user in a different schema than 'public' using MyDAL but when I try to access it with appadmin it does not know about the schema. The model was in

Re: [web2py] Re: DAL and schema

2012-04-10 Thread adesantoasman
Nice to hear that you would test it. I've tested MyDAL with Postgre 8.4, and works as expected. +adesst -Original Message- From: Johann Spies Sender: web2py@googlegroups.com Date: Tue, 10 Apr 2012 10:02:10 To: Reply-To: web2py@googlegroups.com Subject: Re: [web2py] Re: DA

Re: [web2py] Re: DAL and schema

2012-04-10 Thread Johann Spies
On 5 April 2012 15:02, adesst wrote: > @johann, have you tried MyDAL to connect and follow the how to? > https://github.com/adesst/web2py > > > I have not tried again. Maybe this week. Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you.

Re: [web2py] Re: DAL and schema

2012-03-27 Thread adesst
On Tuesday, March 27, 2012 5:35:57 PM UTC+7, spyker wrote: > > > > On 26 March 2012 20:22, adesst wrote: > >> @Johann, i don't know if you would copy paste the diff i've made into >> PgAdapter, >> and do some tests and post the results. Pg and Oracle schema works in >> the same way. >> >> > I have

Re: [web2py] Re: DAL and schema

2012-03-27 Thread Johann Spies
On 26 March 2012 20:22, adesst wrote: > @Johann, i don't know if you would copy paste the diff i've made into > PgAdapter, > and do some tests and post the results. Pg and Oracle schema works in > the same way. > > I have downloaded and looked at MyDal and the README but I am not sure which 'diff

Re: [web2py] Re: DAL and schema

2012-03-26 Thread Johann Spies
I would really appreciate it if we can have that in DAL. I am a Postgresql user. Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)

Re: [web2py] Re: DAL and schema

2012-03-24 Thread Massimo Di Pierro
Please open an issue and ask to be mrged to trunk

Re: [web2py] Re: DAL and schema

2012-03-24 Thread Adesanto Asman
I don't know if this going to help. But i've made an extend of DAL, OracleAdapter and Table so they could work with schema/database descriptor. https://github.com/adesst/MyDAL So far what i did is to meet my need, and yes there are lots of work to make my extension work well with inner join and