[web2py:18061] Re: any method to control column access

2009-03-14 Thread mdipierro
db.sometable.somefield.writable==True should work for SQLTABLE too. Does it not? Massimo On Mar 15, 12:29 am, phneoix wrote: > thanks a lot mdipierro, column privileges working quite nicely. > > is there any similar method for SQLTABLE whereby only columns with > readonly privileges are displa

[web2py:18060] Re: any method to control column access

2009-03-14 Thread phneoix
thanks a lot mdipierro, column privileges working quite nicely. is there any similar method for SQLTABLE whereby only columns with readonly privileges are displayed. thanks On Mar 9, 6:36 pm, mdipierro wrote: > SQLFORM(db.sometable) > > only displays somefield IF db.sometable.somefield.writabl

[web2py:18059] Re: db backend

2009-03-14 Thread Yarko Tymciurak
T-SQL and access use different db engines; see this for example: http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html On Sat, Mar 14, 2009 at 9:24 PM, Wes James wrote: > > On Sat, Mar 14, 2009 at 8:00 PM, mdipierro > wrote: > > > > As far

[web2py:18058] Re: The web2py wiki is now ready for your input!

2009-03-14 Thread Jonathan B
Hi maplye, On Mar 13, 10:44 am, maplye wrote: > > By that I mean I can see the index with the [+]s but the links are a > > bunch of numbers, letters and dashes. > > So which one is '/docs/examples' or '/docs/howto' ? Can you please be more specific? What kind of error do you get? --Jonathan

[web2py:18057] Re: The web2py wiki is now ready for your input!

2009-03-14 Thread Jonathan B
Hi DenesL, On Mar 13, 6:20 am, DenesL wrote: > I see there is a "Web2py Documentation" page that could serve as the > backbone but it is getting kinda lost in the page list, is there a way > to visualize the hierarchy?. > The instructions for creating pages recommend using the menu field to > e

[web2py:18056] Re: The web2py wiki is now ready for your input!

2009-03-14 Thread Jonathan B
On Mar 12, 9:00 pm, Yarko Tymciurak wrote: > On Thu, Mar 12, 2009 at 8:24 AM, Michael Wales wrote: > > > Certificate is invalid - can eventually get to the site, but requires > > some manual labor in Firefox. > > this is because DePaul has certificate for top level site;  I do not think > this

[web2py:18055] Re: The web2py wiki is now ready for your input!

2009-03-14 Thread Jonathan B
On Mar 12, 4:56 pm, "mr.freeze" wrote: > Looks good.  Will any of the content from > herehttps://mdp.cti.depaul.edu/web2py_wiki/default/wiki/mainbe moved over > or does it need to be recreated manually? Thanks for mentioning this link, since I wasn't even aware of it! :-) There doesn't seem t

[web2py:18054] Re: The web2py wiki is now ready for your input!

2009-03-14 Thread Jonathan B
On Mar 12, 4:34 pm, DenesL wrote: > IMHO we should create a basic structure, probably following the > current manual, so this does not turn into a collection of notes. Please feel free to add more structure if you like. --Jonathan --~--~-~--~~~---~--~~ You rec

[web2py:18053] Re: sql designer for web2py

2009-03-14 Thread mdipierro
I am very confused by this it is patching web2py? is it patching sqldesigner? What is the problem you are trying to fix? Massimo On Mar 14, 9:50 pm, Boris Manojlovic wrote: > as my script is not working with new versions of web2py > here it is updated to work and will visually give you idea

[web2py:18052] Re: Qusestion about the book?

2009-03-14 Thread Jeffield
I just posted a amazon review with the correct page count. > but I am shooting for a second edition by summer. who-hoo Please consider publishing your book to Safari. (www.oreilly.com). Joining Safari is the smartest thing I have ever done. you could even post "rough-cuts" of the book... there..

[web2py:18051] Re: any good examples of auth and crud implementations

2009-03-14 Thread Jeffield
"..Pain.. does not exists in this dojo does it." -- sorry could not resist -- I hate I am gona miss PyCon, I look forward to seeing the webcast. On Mar 14, 12:45 pm, Yarko Tymciurak wrote: > There will be a web2py dojo at PyCon2009 where some of these features will > be explored.  We expect to p

[web2py:18050] sql designer for web2py

2009-03-14 Thread Boris Manojlovic
as my script is not working with new versions of web2py here it is updated to work and will visually give you idea if patching went ok. Howto: Read it as README :) or just run it as ./README P.S. don't forget to reload web2py to make it work (after patching it is needed) -- "Only two things ar

[web2py:18049] Re: db backend

2009-03-14 Thread Wes James
On Sat, Mar 14, 2009 at 8:00 PM, mdipierro wrote: > > As far as I understand ODBC provides a standard API for database > connectivity but the SQL that goes through that connection still > depends on the database backed. For example web2py can talk to MSSQL > and DB2 and in both cases it uses pyOD

[web2py:18048] Re: db backend

2009-03-14 Thread mdipierro
As far as I understand ODBC provides a standard API for database connectivity but the SQL that goes through that connection still depends on the database backed. For example web2py can talk to MSSQL and DB2 and in both cases it uses pyODBC but the SQL translation strings in web2py are different.

[web2py:18047] Re: the need for an ID field

2009-03-14 Thread mdipierro
Mind this is not thread safe. On Mar 14, 7:22 pm, DenesL wrote: > Thanks for the explain Yarko, this could go in the new wiki. > > That is the understanding I had, my problem was to think about a class > only as an instance factory and not as an object itself, which can > also track the objects

[web2py:18046] Re: db backend

2009-03-14 Thread Wes James
On Sat, Mar 14, 2009 at 6:13 PM, mdipierro wrote: > > We do not claim we support MS Access. If the MS Access uses the same > SQL dialect as MS SQL than, we can add support easily but I am I do > not know. > > Massimo > I've accessed ms access via ODBC, so if web2py supports odbc then it can get

[web2py:18045] Re: the need for an ID field

2009-03-14 Thread DenesL
Thanks for the explain Yarko, this could go in the new wiki. That is the understanding I had, my problem was to think about a class only as an instance factory and not as an object itself, which can also track the objects that have been instanced by it. A simplified model of it would be: class

[web2py:18044] Re: db backend

2009-03-14 Thread mdipierro
We do not claim we support MS Access. If the MS Access uses the same SQL dialect as MS SQL than, we can add support easily but I am I do not know. Massimo On Mar 14, 4:12 pm, Pai wrote: > do we have support for MS Access? --~--~-~--~~~---~--~~ You received this m

[web2py:18043] db backend

2009-03-14 Thread Pai
do we have support for MS Access? --~--~-~--~~~---~--~~ 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 t

[web2py:18042] Re: the need for an ID field

2009-03-14 Thread Yarko Tymciurak
On Sat, Mar 14, 2009 at 10:19 AM, mdipierro wrote: > > or > > a=[d for d in globals() if isinstance(d,SQLDB)] ...nice... > > > Massimo > On Mar 13, 5:06 pm, DenesL wrote: > > 1) "Views" in sqlite: > > > >sqlite does not have ALTER TABLE ... DROP COLUMN so that explains > > the "extra" fi

[web2py:18041] Re: any good examples of auth and crud implementations

2009-03-14 Thread Yarko Tymciurak
There will be a web2py dojo at PyCon2009 where some of these features will be explored. We expect to post screen casts, and probably some slides after the conference (that will be in two weeks). In the meantime you might want to start by looking at the code @ https://code.launchpad.net/web2py-wiki

[web2py:18040] Re: SQLRows as dict?

2009-03-14 Thread rbuc
thanks anyways for your input and effort! ramon On Mar 11, 2:44 pm, carlo wrote: > I think there is no easy solution except serializing select responses > the way you did. Simplejson has problems even to serialize date > objects. > > carlo > > On 11 Mar, 13:55, rbuc wrote: > > > sorry, the ex

[web2py:18039] CAS a new auth system

2009-03-14 Thread David Marko
Is there anyone who used CAS (https://mdp.cti.depaul.edu/cas) with the new Auth system built-in in web2py? We have to create a several appliances with a shared authentication system and we are considering the right way. Is there any 'good practice' for following scenario? For one client we need

[web2py:18038] Re: Feature Request: darker cursor

2009-03-14 Thread Markus Gritsch
On Sat, Mar 14, 2009 at 4:26 PM, mdipierro wrote: > > CJ has completed porting the Amy editor to web2py with collapsible > items, auto completion, and lots of keyboard shortcuts (crtl+s to > save, etc.). It should be possible to change themes too. This will be > in 1.59 within the week. Has some

[web2py:18037] Re: Qusestion about the book?

2009-03-14 Thread mdipierro
Thanks Mike, I would appreciate if you could correct that wrong page count. There are some new features not mentioned in the book (cron, auth, crud, services, routes_on_error, etc.) but I am shooting for a second edition by summer. Massimo On Mar 14, 10:38 am, Mike Axelrod wrote: > Thanks ever

[web2py:18036] Re: Qusestion about the book?

2009-03-14 Thread Mike Axelrod
Thanks everyone, I just bought the book from lulu. And yes it is a full 246 pages + additional front matter. Just scanning it now, it does look like it will be very helpful. Someone ought to correct that guy's strange page number reference on the Amazon review. It does the author a disservic

[web2py:18035] Re: Feaure request: CRYPT with SHA1

2009-03-14 Thread mdipierro
Uploading to trunk now. Thanks Francisco. On Mar 14, 8:49 am, Francisco Gama wrote: > Here is the list of the currently supported algorithm's from the > hashlib documentation: > " Included are the FIPS secure hash algorithms SHA1, SHA224, SHA256, > SHA384, and SHA512 (defined in FIPS 180-2) as

[web2py:18034] Re: Feature Request: darker cursor

2009-03-14 Thread mdipierro
How is Francisco reading my mind CJ has completed porting the Amy editor to web2py with collapsible items, auto completion, and lots of keyboard shortcuts (crtl+s to save, etc.). It should be possible to change themes too. This will be in 1.59 within the week. Massimo On Mar 14, 8:53 am, F

[web2py:18033] Re: Feaure request: CRYPT with SHA1

2009-03-14 Thread mdipierro
Not correct. CRYPT uses MD5 (weak, default) or HMAC+SHA-512 (very very strong). To use the latter you must pass a key to CRYPT CRYPT(key='mykey') Do not lose your key or you will lose the ability to read your CRYPTed data. Massimo On Mar 14, 12:14 am, NguyendHEX wrote: > CRYPT validator work

[web2py:18032] Re: dia2model: a nifty feature I think we could have

2009-03-14 Thread mdipierro
Yes the latter is better. On Mar 14, 7:49 am, Francisco Gama wrote: > Try this > one...http://designer.bojanka.net/designer.html?keyword=web2pydesigner > > On Mar 14, 12:26 pm, Jason Brower wrote: > > > Oh my!  Your right!http://mdp.cti.depaul.edu/sqldesigner/default/sqldesigner > > Thanks for

[web2py:18031] Re: the need for an ID field

2009-03-14 Thread mdipierro
or a=[d for d in globals() if isinstance(d,SQLDB)] Massimo On Mar 13, 5:06 pm, DenesL wrote: > 1) "Views" in sqlite: > >    sqlite does not have ALTER TABLE ... DROP COLUMN so that explains > the "extra" fields. > > 2) Thanks for the ipython suggestion and the SQLDB._instances > explanation. >

[web2py:18030] Re: Plotting with web2py

2009-03-14 Thread mdipierro
flot (js based) and matplotlib are both easy to do. The latter requires running from source, installing matlolib and genering images serverside. Massimo On Mar 13, 11:32 pm, weheh wrote: > Anybody know what the state of the art is with regards to plotting > with web2py? > > It would be great t

[web2py:18029] Re: note to self: exciting stuff

2009-03-14 Thread mdipierro
Yes. I was thinking something along that lines... On Mar 13, 7:23 pm, "Zoom.Quiet" wrote: > On Sat, Mar 14, 2009 at 08:12, mdipierro wrote: > > > Web2py could be an excellent tool for this: > > abt. Semantic Web ; SNSaaS ? > hope make one app. for support Linked Data ? > i suggest, make all web

[web2py:18028] Re: Feature Request: darker cursor

2009-03-14 Thread Francisco Gama
You're right. Just don't worry about it. I believe that very soon, Massimo will introduce a very big change on the editor towards an improved one (that doesn't have that problem). On Mar 14, 11:36 am, Jason Brower wrote: > I can barely see the cursor on my computer.  It makes it annoying when

[web2py:18027] Re: Feaure request: CRYPT with SHA1

2009-03-14 Thread Francisco Gama
Here is the list of the currently supported algorithm's from the hashlib documentation: " Included are the FIPS secure hash algorithms SHA1, SHA224, SHA256, SHA384, and SHA512 (defined in FIPS 180-2) as well as RSA’s MD5 algorithm (defined in Internet RFC 1321) " On Mar 14, 1:45 pm, Francisco Gam

[web2py:18026] Feaure request: CRYPT with SHA1

2009-03-14 Thread Francisco Gama
Here goes: try something like: SQLField('password','password',requires=CRYPT(digest_alg='sha512')) with this patch web2py CRYPT validator supports all hashing algorithms supported by python's hashlib library just by defining that parameter in the example CRYPT(digest_alt='') Test it and give feed

[web2py:18025] Re: dia2model: a nifty feature I think we could have

2009-03-14 Thread Francisco Gama
Try this one... http://designer.bojanka.net/designer.html?keyword=web2pydesigner On Mar 14, 12:26 pm, Jason Brower wrote: > Oh my!  Your right!http://mdp.cti.depaul.edu/sqldesigner/default/sqldesigner > Thanks for the pointer. > Regards, > Jason Brower > > On Sat, 2009-03-14 at 05:02 -0700, Fran

[web2py:18024] Re: dia2model: a nifty feature I think we could have

2009-03-14 Thread Jason Brower
Oh my! Your right! http://mdp.cti.depaul.edu/sqldesigner/default/sqldesigner Thanks for the pointer. Regards, Jason Brower On Sat, 2009-03-14 at 05:02 -0700, Francisco Gama wrote: > there is a model designer in javascript, just needing a browser... > check web2py website > > On Mar 14, 10:57 am

[web2py:18023] any good examples of auth and crud implementations

2009-03-14 Thread phneoix
hi, i would like to know whether there are any good examples using auth and crud. iam struggling with crud quite a bit. thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post t

[web2py:18022] Re: dia2model: a nifty feature I think we could have

2009-03-14 Thread Francisco Gama
there is a model designer in javascript, just needing a browser... check web2py website On Mar 14, 10:57 am, Jason Brower wrote: > I use dia to create my DB designs.  Wouldn't it be nifty if we could > export that to python could that can be copy pasted into our model files > to create the basic

[web2py:18021] Feature Request: darker cursor

2009-03-14 Thread Jason Brower
I can barely see the cursor on my computer. It makes it annoying when I have to search for it and enter information in the wrong location. Can we have it black? Regards, Jason Brower --~--~-~--~~~---~--~~ You received this message because you are subscribed to t

[web2py:18020] dia2model: a nifty feature I think we could have

2009-03-14 Thread Jason Brower
I use dia to create my DB designs. Wouldn't it be nifty if we could export that to python could that can be copy pasted into our model files to create the basic database structure? Regards, Jason Brower --~--~-~--~~~---~--~~ You received this message because you