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
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 mrauc...@gmail.com 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
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
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
See this: http://web2py.com/books/default/chapter/29/06#Inner-joins
On Thu, Jun 27, 2013 at 7:45 AM, mcamel mca...@gmail.com 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
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
Sorry, my fault.
On Thu, Jun 27, 2013 at 8:53 AM, Anthony abasta...@gmail.com 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
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
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
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 = Storage()
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,'
On 5 April 2012 15:02, adesst adesantoas...@gmail.com 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
@googlegroups.com
Subject: Re: [web2py] Re: DAL and schema
On 5 April 2012 15:02, adesst adesantoas...@gmail.com 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
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
@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?
Yes.
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
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:
On Tuesday, March 27, 2012 5:35:57 PM UTC+7, spyker wrote:
On 26 March 2012 20:22, adesst adesantoasman@... 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 adesantoas...@gmail.com 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
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)
@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
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
Please open an issue and ask to be mrged to trunk
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