Hello all
I'm new to python and web2py, and I'm evaluating them to make new
developments accessing legacy databases (MSSQL 2000, MySQL 3 and MySQL 5 ).
I've tried the connection strings shown in the web2py book, but I can
connect only to MySQL 5.
- The error connecting to MySQL 3 is "access den
You need to define your tables in web2py. As of yet there is no db
introspection for db.
db.define_table('tablename', *Fields)
There is also a thing called "keyedtables" which is for legacy databases.
-Thadeus
On Fri, Mar 19, 2010 at 10:44 AM, pacopyc wrote:
> Hi, I need to develope a web
Hi, I need to develope a web application with legacy database
(Oracle). Database's tables have an auto increment field (id) and then
this is ok. I tried to build a new application and I set database
connection (db.py). No error (connection string is ok) but if I try to
use "appadmin" application I
Thanks for the update, David.
On Mon, Apr 6, 2009 at 8:51 AM, David Niergarth wrote:
>
> On Apr 1, 9:20 pm, Yarko Tymciurak wrote:
> > > http://www.postgresql.org/docs/8.3/interactive/sql-createrule.html
> >
> > and looking at this, it seems fairly straight forward:
>
> Yes it does. The manual
On Apr 1, 9:20 pm, Yarko Tymciurak wrote:
> > http://www.postgresql.org/docs/8.3/interactive/sql-createrule.html
>
> and looking at this, it seems fairly straight forward:
Yes it does. The manual threw me when it said that "*Currently* views
are read only" but that "you can get the *effect* of a
On Wed, Apr 1, 2009 at 8:32 PM, David Niergarth wrote:
>
> Yes, I meant SQL UPDATE/INSERT statements. As it turns out, in
> PostgreSQL views are read-only.
>
>Currently, views are read only: the system will not allow an
> insert, update,
>or delete on a view. You can get the effect of an
Yes, I meant SQL UPDATE/INSERT statements. As it turns out, in
PostgreSQL views are read-only.
Currently, views are read only: the system will not allow an
insert, update,
or delete on a view. You can get the effect of an updatable view
by creating
rules that rewrite inserts, etc. on
On Wed, Apr 1, 2009 at 3:22 PM, David Niergarth wrote:
>
> But how would you handle updates (views being read-only).
Views are not read-only. SQLite only supports READ-ONLY views.
When derived columns are from multiple sources, there are constraints - but
for what we're talking about here, th
But how would you handle updates (views being read-only).
--David
On Apr 1, 2:34 pm, Yarko Tymciurak wrote:
> On Wed, Apr 1, 2009 at 12:34 AM, mdipierro wrote:
>
> > Can you create a custom database view and map the field?
>
> Yes - this is the way to do it in your db server. You also want to
On Wed, Apr 1, 2009 at 12:34 AM, mdipierro wrote:
>
> Can you create a custom database view and map the field?
Yes - this is the way to do it in your db server. You also want to set your
web2py table definition to migrate=False (so that an ALTER TALE is not
attempted by web2py). NOTE: you onl
Can you create a custom database view and map the field?
On Apr 1, 12:06 am, Kevin Butler wrote:
> This was posted as a comment
> tohttp://mdp.cti.depaul.edu/AlterEgo/default/show/55:
> Which reads:
>
> > web2py can import tables saved in csv format therefore it can access legacy
> > data.
> >
This was posted as a comment to
http://mdp.cti.depaul.edu/AlterEgo/default/show/55:
Which reads:
> web2py can import tables saved in csv format therefore it can access legacy
> data.
> web2py can also access existing databases directly (MySQL, PostgreSQL, SQLite
> and Oracle) if
> each table h
12 matches
Mail list logo
