There is in fact a utiltiy named auto.py which will 'assist you' to
convert SQL schemas to web2py schemas.
It assumes you are able to script out your table schemas from your
database engine to a file.
You still need to do some simple editing of the SQL schema to
eliminate lines which auto.py will not handle, but that is
straightforward.
The official web2py version is experimental and has some bugs, so I
debugged it and released some patches a few days ago.
Please refer to my earlier posting regarding auto.py if you are
interested.
Good luck.
- Dave Lypka.
On May 21, 2:55 pm, "Elcimar L. Santos" <elci...@gmail.com> wrote:
> It worked!
>
> Not so hard as I thought. Just took some fields as example as you said (I
> think I am not going to use all of them anyway). I added this within my main
> model:
>
> rd = SQLDB('mysql://user:passw...@localhost/radius')
> rd.define_table("radcheck",
> SQLField("username", "string", length = 64, notnull = True),
> SQLField("value", "string", length = 253, notnull = True), migrate =
> False)
>
> My luck Freeradius's schema has the "id" field you mentioned. Now I can
> figure out the rest. What was I afraid of :D
>
> Atenciosamente,
>
> Elcimar Leandro -http://elcimar.blogspot.com
> Portal Net Fácil -http://www.nfacil.com.br
>
> 2009/5/21 Yarko Tymciurak <yark...@gmail.com>
>
>
>
> > On Thu, May 21, 2009 at 8:43 AM, Elcimar <elci...@gmail.com> wrote:
>
> >> Hello. I am a total newbie on web2py. I am starting a project of a web
> >> application which controls Freeradius's authentication server (user
> >> database being MySQL). Freeradius ships with an SQL file to generate
> >> all tables it needs. What should I do?
>
> > First, create a test setup!
>
> >> * Recreate all Freeradius table structures into db.py by hand?
> >> * Find a way to convert the SQL file to web2py? wwwsqldesigner (with
> >> patches) saves in web2py format, but only when I design something,
> >> never when importing an SQL/XML.
>
> > First, some concepts:
>
> > - To access a table, you only need to tell web2py about the data you
> > intend to access; entire table definitions are NOT necessary;
> > - TOUGH RESTRICTION: With web2py DAL, each table must have an
> > autoincrement primary key which is an integer AND CALLED "id"; The
> > most
> > likely scenario is that there are primary keys with some other name, in
> > which case you will need to figure out how - on your database server - to
> > create simple views which will remap the primary key to a field named
> > "id"
> > - In web2py, you will want to define the table with migrate=False (so
> > that web2py doesn't issue any "ALTER TABLE..." instruction, for instance
> > if
> > you accidentally make a typo on a field name)
>
> > Right now there is not automatic table reflection mechanism in web2py, so
> > you will need to create the table DAL table descriptions for the fields you
> > want to access.
>
> > Start with a test - create some entries (by hand if needed) in your target
> > MySQL db, and try to read and write the values you care about in web2py.
> > For example, start with just "id" and "name" fields of a more extensive
> > table.
>
> > Hope this is helpful.
>
> > Regards,
> > - Yarko- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
