this thread is quite old, in the meantime there is already schema support
in web2py with rname. e.g.
db.define_table('mytable',
rname='myschema.mytable')
Alex
On Friday, March 11, 2016 at 8:31:07 PM UTC+1, Ben Wolski wrote:
>
> executing the following query after defining my db in db.p
executing the following query after defining my db in db.py helped me query
an Oracle db that requires a schema:
db_prod.executesql("ALTER SESSION SET CURRENT_SCHEMA = BDR;")
El viernes, 2 de marzo de 2012, 3:58:35 (UTC-8), Wuwei escribió:
>
> Hello,
> I'm trying to use DAL with a MSSQL db.
> I
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
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
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
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
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
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
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
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
Apologies. Here is the remainder of my reply:
In models/db.py (the process hangs in the last line of this code.:
from applications.toets.modules.mydal import *
db.define_table('auth_user',
Field('id','id',
represent=lambda id:SPAN(id,' ',A('view',_href=URL(
On Thursday, 5 April 2012 15:02:49 UTC+2, adesst wrote:
>
> @johann, have you tried MyDAL to connect and follow the how to?
> https://github.com/adesst/web2py
>
>
> I have tried MyDAL without success today.
My code:
In models/0.py:
from applications.toets.modules.mydal import *
settings = Storag
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
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.
@johann, have you tried MyDAL to connect and follow the how to?
https://github.com/adesst/web2py
On Thursday, April 5, 2012 1:46:48 PM UTC+7, Johann Spies wrote:
>
>
>
> On Thursday, 5 April 2012 01:17:48 UTC+2, Massimo Di Pierro wrote:
>>
>> Can a query involve tables from different schemas?
>>
>
On Thursday, 5 April 2012 01:17:48 UTC+2, Massimo Di Pierro wrote:
>
> Can a query involve tables from different schemas?
>
>
Yes. This query works in Postgresql:
select * from toets.wiesdaar
left join public.akb_authors on (surname = van)
where surname is not null
Regards
Johann
Can a query involve tables from different schemas?
Massimo
On Wednesday, 4 April 2012 16:46:30 UTC-5, Wuwei wrote:
>
> Massimo,
> I think it is very simple to support schemas: you should simply allow a .
> (dot) in table name.
> So that we can define a table like this:
> db.define_table('myschem
Massimo,
I think it is very simple to support schemas: you should simply allow a .
(dot) in table name.
So that we can define a table like this:
db.define_table('myschema.mytable', Field(), ...)
This syntax now raises an exception:
SyntaxError: only [0-9a-zA-Z_] allowed in table and field nam
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
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
@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 currently focusing to dev the MyDAL to support all the joins of
Oracle and doing
some tests on reference (many/one-to-many)
On Mar
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)
Please open an issue and ask to be mrged to trunk
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
I am not sure if this can be done or not. If not supported, we can add
support. Can you open a ticket and post an example of how to do it in SQL?
On Friday, 2 March 2012 05:58:35 UTC-6, Wuwei wrote:
>
> Hello,
> I'm trying to use DAL with a MSSQL db.
> I need to work with tables from 2 different
25 matches
Mail list logo
