[web2py] Re: help needed with migration: ProgrammingError: column does not exist

2016-01-31 Thread Antonio Salazar
As a web2py user with a few months of experience, this is my experience with migrations: - Most of the time they work, specially if you use PostgreSQL - Sometimes they won't, and fake_migrate plus the sql log usually help to fix it. - In very rare occasions, fake_migrate might actual

[web2py] TechEmpower analysed the performance of many web frameworks, web2py included

2016-01-31 Thread Antonio Salazar
It doesn't look good on web2py, we're consistently in the last places. Other python frameworks like Django or Flask fared better. https://www.techempower.com/benchmarks/#section=data-r11&hw=peak&test=update Test source is here: https://github.com/TechEmpower/FrameworkBenchmarks/tree/master/framew

[web2py] one select form multiple table

2016-01-31 Thread Imre
Hi, I want to make a form which can search in multiple db tables. The tables has a same structure. /models/db.py: dbmy = DAL('mysql://test:test@localhost/checkpoint') dbmy.define_table('sam_hosts', Field('name','text'), Field('IP','text')) dbmy.define_t

[web2py] Auth User split by tables

2016-01-31 Thread rajmathur6431
Hello web2py community. I am a new user and I have to say, web2py saves the day by saving so much time over a full stack framework which requires so much work. Anyway, going to ask a question tothe community. How to custom create auth_user so instead of adding extra fields to the auth_user we c

[web2py] Use Of multiple databases

2016-01-31 Thread Ali Baig
I am cloud app developer but new on web2py framwork i want to know how to use multiple databases in web2py application according to the client login details. Actually i have different groups of user in my saas app and want to use database according to group of client. -- Resources: - http://we

[web2py] web2py fails to read words in utf8 format with db.executesql()

2016-01-31 Thread Fábio Filho
I'm having a problem with my web2py website When I execute a sql command, for all fields that has "ç", I got this message: 'utf8' codec can't decode byte 0xc7 in position 15: invalid continuation byteError This is my method: def get_something(): mRow=dbFb.executesql("select first 1 C

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread Ron Chatterjee
There are few videos on Vimeo. Good luck! On Sunday, January 31, 2016 at 5:11:38 PM UTC-5, 黄祥 wrote: > > perhaps you can learn a lot from web2py appliances or web2py slices : > http://www.web2py.com/appliances > http://www.web2pyslices.com > > best regards, > stifan > -- Resources: - http://web2

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread 黄祥
perhaps you can learn a lot from web2py appliances or web2py slices : http://www.web2py.com/appliances http://www.web2pyslices.com best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

[web2py] print landscape

2016-01-31 Thread lucas
is there anyway to direct the printer to print the webpage in landscape using only HTML, CSS, and/or jQuery, native to our current version of web2py v2.12 or v2.13? thanx in advance, lucas -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web

[web2py] Re: help needed with migration: ProgrammingError: column does not exist

2016-01-31 Thread Alex Glaros
This finally worked. ALTER TABLE RelationshipType ADD COLUMN relationship_type_name varchar(512); Can it be assumed that it is generally easier doing DB work on the Postgres side and just leaving w2p set to migrate = False? Alex -- Resources: - http://web2py.com - http://web2py.com/book (Docu

[web2py] Re: help needed with migration: ProgrammingError: column does not exist

2016-01-31 Thread Alex Glaros
I have the same problem. Fake migrate didn't work. Tried deleting table in "databases" folder, stopped and started PostGres and w2p servers, etc. Any ideas I can try? db = DAL('postgres://postgres:myPasswrod@localhost:5432/postgres', migrate= False,fake_migrate=True ) *ProgrammingError: column

[web2py] Re: sequence of actions / general rules for code organization

2016-01-31 Thread Anthony
On Sunday, January 31, 2016 at 8:57:31 AM UTC-5, Pierre wrote: > > where is the preferred location for callbacks function: after_delete, > after_insert, etc.can these go to a module instead of a .db file ? > Put them wherever you want. A module is fine if that organization works better for

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread Anthony
> > Rather than trying to learn everything from the examples page, you > should > > probably proceed to the book. > > > Yes, I'm beginning to realise that, however I was expecting 'simple > examples' to allow me to create something that worked that I could > look at to see how it all hang

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread Anthony
> > > It takes you to an entire chapter of the book on the Database > Abstraction > > Layer -- with *lots* of examples. > > > Yes, I followed it to the book but couldn't see any examples there. > Let me try again No, sorry, I can't see any. I mean I don't > really count things like th

[web2py] Nested queries

2016-01-31 Thread Alfonso Serra
Given the following model: A company has departments and each department has subdepartments. How would i query all subdepartments from a company? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.g

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread cl
Anthony wrote: > [-- multipart/alternative, encoding 7bit, 161 lines --] > > [-- text/plain, encoding 7bit, charset: UTF-8, 77 lines --] > > > > > > > > The first (minor) problem is that it says something like "In > > controller: simple_examples.py" above each example. On my system > > s

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread cl
Anthony wrote: > [-- multipart/alternative, encoding 7bit, 48 lines --] > > [-- text/plain, encoding 7bit, charset: UTF-8, 23 lines --] > > > > > ... and the link from the Simple Examples which says "You can find > > more examples of the web2py Database Abstraction Layer here" doesn't >

[web2py] sequence of actions / general rules for code organization

2016-01-31 Thread Pierre
where is the preferred location for callbacks function: after_delete, after_insert, etc.can these go to a module instead of a .db file ? is redirect(URL('controller',args=,vars=) the preferred choice for 'actions concatenation' ? is there a way to pass form.vars to another contro

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread Anthony
> ... and the link from the Simple Examples which says "You can find > more examples of the web2py Database Abstraction Layer here" doesn't > take you to any more examples, or none that I could see. > It takes you to an entire chapter of the book on the Database Abstraction Layer -- with *lo

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread Anthony
> > > The first (minor) problem is that it says something like "In > controller: simple_examples.py" above each example. On my system > simple_examples.py is in > /applications/examples/controllers/simple_examples.py > which isn't quite what it says. > Not sure what you mean. According to t

[web2py] Re: Probably very naive question from new user

2016-01-31 Thread cl
c...@isbd.net wrote: > Then (though this is maybe trying to run before I can walk as I can't > really understand the simplest examples) when you get down to the > database examples (which is what I'm particularly interested in) there > are various oddities:- > > The 'try it here' link suddenly

[web2py] Re: where are the widgets ?

2016-01-31 Thread Pierre
sorry to have bothered you with this but from the root search box it takes 3 layers of results to traverse until one can reach this url. I got lost in between thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Probably very naive question from new user

2016-01-31 Thread cl
I have just installed web2py on an xubuntu system (latest stable download rather then from the Ubuntu repository). That's all OK and I can run web2py.py and, after entering a password, the 'Welcome' page appears in my browser. I'm fairly experienced with the LAMP admin side of things so that was

[web2py] Re: where are the widgets ?

2016-01-31 Thread Niphlod
really ? http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=widgets On Saturday, January 30, 2016 at 5:21:20 PM UTC+1, Pierre wrote: > > I can read this in the web2py book : "a list of available widgets will be > discussed later" where is this list located ? I cannot rea

[web2py] Re: scheduler -- tracking the last time

2016-01-31 Thread Niphlod
On Sunday, January 31, 2016 at 7:12:41 AM UTC+1, Dave S wrote: > > > > On Saturday, January 30, 2016 at 8:50:32 PM UTC-8, Niphlod wrote: >> >> scheduler_run is the only way to keep track of executions. >> > > And there is no session to carry a value over in, is there? > sorry, what ? > > >>

[web2py] Re: Is there a Debian/Ubuntu PPA for web2py?

2016-01-31 Thread cl
Anthony wrote: > > > > Is there any way that web2py can at least *tell* me that there's a new > > version available? > > > > Not automatically, though the home page of the admin app indicates when an > update is available. > Ah, good, I'm fairly happy with that. It's the same sort of thing t

Re: [web2py] Re: Is there a Debian/Ubuntu PPA for web2py?

2016-01-31 Thread José Luis Redrejo
Hi, https://packages.debian.org/sid/python-web2py Debian package is on version 2.12.3 As usual, Ubuntu will pick that package for the next release they do. 2016-01-30 20:25 GMT+01:00 : > Anthony wrote: > > > > > > I run xubuntu on my home server, the current 15.10 version. > > > > > > The web2p