Can you email the new auto to me?
On May 22, 1:19 am, dlypka <dly...@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
