[web2py] Re: large sites/application.

I assume those tables are not all referencing each other but they can be group based on their function and the groups can be organized in a tree where the children may refer a table in the parent group. I would create a module for each group of tables and have a function in the module that takes db

Re: [web2py] Re: Idea: Appliance remote management

Do we need any hosting? I can provide that if needed. I am using dreamhost and have a virtual server there. BR, Jason - Original message - > I agree. > > On May 13, 9:02 pm, Thadeus Burgess wrote: > > Massimo, we can take the ideas for plugin metadata and use it for > > applications as w

[web2py] Re: Idea: Appliance remote management

I agree. On May 13, 9:02 pm, Thadeus Burgess wrote: > Massimo, we can take the ideas for plugin metadata and use it for > applications as well? > > Change the name from plugincentral to web2pycentral. We can start an > open source version of the web2pycentral and decide who can work on > it. > >

Re: [web2py] large sites/application.

On Thu, May 13, 2010 at 23:07, Thadeus Burgess wrote: > But the problem with web2py is that what if you don't want portal > models to execute when they are on the public portion of the site? But > the public depends on the portals models and visa versa. No matter > which way you hash it, your goin

Re: [web2py] Re: Idea: Appliance remote management

Massimo, we can take the ideas for plugin metadata and use it for applications as well? Change the name from plugincentral to web2pycentral. We can start an open source version of the web2pycentral and decide who can work on it. -- Thadeus On Thu, May 13, 2010 at 2:07 PM, Jason Brower wrote

Re: [web2py] large sites/application.

But the problem with web2py is that what if you don't want portal models to execute when they are on the public portion of the site? But the public depends on the portals models and visa versa. No matter which way you hash it, your going to have a massive web2py spaghetti on your plate with some gi

Re: [web2py] large sites/application.

to build large app, you can: 1. split you tables over several models, like db.py db_000_user_management.py db_001_portal.py db_002_ecommerce.py and so on. 2. split your code and html over several controllers: default.py portal.py shop.py views/default/*.html views/portal/*.html views/shop/*.ht

[web2py] Re: hello

On May 13, 8:51 pm, ciprian wrote: > thanks for trying to help. but i already spent two days trying to > figure it out. i can install web2py with no problems - but i dont have > too much experience withmod_wsgi(google doesnt help) no web2py > tutorials and i guess this is the end. i really need

[web2py] Form Checkbox how to Use efectively

hello I have a form I would like to use multiple check boxes to select data to use. I am not using any sql an example of how I am generating the check boxes TR(INPUT(_type="checkbox", name="browser"), "Browser"), TR(INPUT(_type="checkbox", name="pageDepth"), "Page Depth"), this is not t

[web2py] large sites/application.

I'm confused when to make apps. I'll be making a pretty decent size website and it has over 30 tables. The site will have different functionalities and for the most part i have only seen code for apps that do two or one thing. So do i make multiple apps. If so how do i know when to make a new one.

[web2py] Re: Idea: Appliance remote management

i support the idea. On 13 Mayıs, 22:07, Jason Brower wrote: > I say we move forward with this one as it doesn't need so much work as > with the plugins.  At least at first thought.  It's just additional > metadata in the application.  I think some simple xml/html would do the > trick.  Just what

[web2py] Re: New to web development? Watch this!

thanks chef, great resource. On 14 Mayıs, 00:28, b00m_chef wrote: > http://academicearth.org/courses/building-dynamic-websites > > Watch all the videos in the series. Lots of NEED TO KNOW stuff for all > those starting out.

[web2py] Re: Belongs orders results by id

yes, i have also tried with sqlite3 and it didn't work. see how awesome mysql is? any postgresql users, does psql support this? On 13 Mayıs, 20:37, Francisco Costa wrote: > Thank you Mengu > I've converted my DB to MySQL. In SQLite didn't work. > > On May 13, 3:48 pm, Mengu wrote: > > > > > ye

[web2py] Re: agregate login method

I forget, I copy the file to web2py/gluon/contrib/login_methods and I aggregate that whit from gluon.contrib.login_methods.ldap import Ldap

[web2py] agregate login method

Hi, I have a file called ldap whit the following code: class Ldap(object): def __init__(self,usuario=None, passwd=None): self.objLDAP = None self.dir = 'xx.xx.xx.xx' self.ldap_host = 'xxx.xx' self.puerto = 389 self.AD_SEARCH_DN = 'OU=xxx Domain U

Re: [web2py] Re: SSL Error on windows [SOLVED] [SOLVED]

On Thu, May 13, 2010 at 9:02 PM, Timothy Farrell wrote: > While Rocket supports listening on multiple sockets, web2py does not. You > will need to run two separate instances of web2py (one for SSL, one > unencrypted) to do what you are asking. > > -tim > > Txs for the reply. Always nice to know

[web2py] "SSL is OFF" error message when starting the server

I have web2py installed on a remote Debian server. When connecting via my local Windows box, the admin is disabled for Web2py because of the unsecure channel. I set up an SSH tunnel for the connection, and I've created a private certificate authority for the SSL connection. When starting the serve

[web2py] New to web development? Watch this!

http://academicearth.org/courses/building-dynamic-websites Watch all the videos in the series. Lots of NEED TO KNOW stuff for all those starting out.

[web2py] Re: left outer join problem on db2

I have no objection to changing this. Can you want to submit a patch and help with testing? On May 13, 4:16 pm, salbefe wrote: > Hello, > > Only a question, athttp://pypi.python.org/pypi/ibm_db/there is a > Python DBI driver for DB2. Why web2py is still using ODBC?? Will not > be better to use th

[web2py] Re: UTF-8 question and link

Awesome! Just might want to mention that MySQL doesn't do utf-8, and might screw-up the DB if you expect your data to be utf-8. Check the info about fixing the problem in mySQL in that link I posted in my OP. Might be a good idea to put that in the book somewhere. On May 13, 1:09 pm, mdipierro

[web2py] Re: left outer join problem on db2

Hello, Only a question, at http://pypi.python.org/pypi/ibm_db/ there is a Python DBI driver for DB2. Why web2py is still using ODBC?? Will not be better to use this one instead of pyodbc?? Thanks On 11 mayo, 16:27, mdipierro wrote: > Thank you. will look into it. > > Massimo > > On May 11, 6:31

[web2py] Re: Problem with IS_URL

> My point with the book is that the information is already there, but > scattered and hard to find. +1

[web2py] Re: Problem with IS_URL

Then epydoc is very useful... useful to find problems with the docstrings! On May 13, 3:52 pm, Jonathan Lundell wrote: > On May 13, 2010, at 1:47 PM, mdipierro wrote: > > > True but there is always epydoc > > >http://web2py.com/examples/static/epydoc/ > >http://web2py.com/examples/static/epydoc/w

Re: [web2py] Re: Problem with IS_URL

On May 13, 2010, at 1:47 PM, mdipierro wrote: > True but there is always epydoc > > http://web2py.com/examples/static/epydoc/ > http://web2py.com/examples/static/epydoc/web2py.gluon.validators-module.html I've always found the source easier to read than epydoc. And the summaries leave a lot to

[web2py] Re: Problem with IS_URL

True but there is always epydoc http://web2py.com/examples/static/epydoc/ http://web2py.com/examples/static/epydoc/web2py.gluon.validators-module.html On May 13, 3:22 pm, Jonathan Lundell wrote: > On May 13, 2010, at 1:01 PM, weheh wrote: > > > @mdp: thanks for the clarification. I like having 1

[web2py] Re: Using LOAD from a controller? [SOLVED]

LOL. I have a solution. Thank for the help and change the title to [SOLVED] so the email becomes useful. On May 13, 3:13 pm, Keith Edmunds wrote: > It's always a conundrum: does one thank people for helping, and thus > contribute an otherwise content-free mail to the list? Or should one thank > t

Re: [web2py] Re: Problem with IS_URL

On May 13, 2010, at 1:01 PM, weheh wrote: > @mdp: thanks for the clarification. I like having 1 way of doing > things, which is why I dumped perl years ago. Perhaps IS_NULL_OR > should be officially deprecated? Is there a place for that? It'd be nice to be able to look that up. Maybe an appendix

Re: [web2py] Re: Using LOAD from a controller?

It's always a conundrum: does one thank people for helping, and thus contribute an otherwise content-free mail to the list? Or should one thank those who helped with a personal mail, thus suggesting to everyone else that you are ungrateful? Iceberg, Selecta: thanks for your valuable help. I'm goin

[web2py] Re: SSL Error on windows [SOLVED]

Since rocket does it, is there any way we can add support for 80+443 with one rocket and one web2py instance? On May 13, 3:02 pm, Timothy Farrell wrote: > While Rocket supports listening on multiple sockets, web2py does not.   > You will need to run two separate instances of web2py (one for SSL,

[web2py] Re: UTF-8 question and link

All utf8 On May 13, 2:15 pm, b00m_chef wrote: > I was wondering where web2py stands on this issue? Is the framework > utf-8 by default or something else? Is there any documentation on how > to implement utf-8 in web2py if it is not the default? > > http://lobstertech.com/2009/jun/07/python_unicode

Re: [web2py] Re: SSL Error on windows [SOLVED]

While Rocket supports listening on multiple sockets, web2py does not. You will need to run two separate instances of web2py (one for SSL, one unencrypted) to do what you are asking. -tim On 5/13/2010 1:40 PM, Miguel Lopes wrote: On Wed, May 12, 2010 at 7:45 PM, Timothy Farrell

[web2py] Re: Problem with IS_URL

@mdp: thanks for the clarification. I like having 1 way of doing things, which is why I dumped perl years ago. Perhaps IS_NULL_OR should be officially deprecated?

[web2py] Re: Encoding using as_dict not using UTF-8?

Note that if you are using mySQL that might be because mySQL, if not set to use utf-8 uses a latin encoding. You have to manually tell MySQL to use utf-8, and even then you will still have problems with it...mySQL sux http://lobstertech.com/2009/jun/07/python_unicode_tutorial/ On Apr 12, 6:59 p

[web2py] UTF-8 question and link

I was wondering where web2py stands on this issue? Is the framework utf-8 by default or something else? Is there any documentation on how to implement utf-8 in web2py if it is not the default? http://lobstertech.com/2009/jun/07/python_unicode_tutorial/ Thx.

Re: [web2py] Re: Idea: Appliance remote management

I say we move forward with this one as it doesn't need so much work as with the plugins. At least at first thought. It's just additional metadata in the application. I think some simple xml/html would do the trick. Just what data if for someone else to think about. :D But I think it's awesome.

Re: [web2py] web2pyslices source code

Thanks for sharing. Miguel On Thu, May 13, 2010 at 4:50 PM, mr.freeze wrote: > This has been updated for anyone interested: > http://www.web2pyslices.com/main/static/share/web2py.app.web2pyslices.w2p > >

Re: [web2py] Re: SSL Error on windows [SOLVED]

On Wed, May 12, 2010 at 7:45 PM, Timothy Farrell wrote: > This is the error that Jon Lundell's guys found already. Note that it's > trying to connect to port 8000 as HTTP. Connect as HTTPS and it should > work. > > Also try upgrading to trunk, that should issue a "400 Bad Request". > > -tim > >

[web2py] Re: group by weeks

will try. Thanks On May 13, 1:50 pm, Vasile Ermicioi wrote: > this is working > > db(db.orders.id > 0).select("count(1) as nr, round(id/10) as gr", > groupby='gr') > > so I think you can use database datetime function to compute week and then > grouping, > most database have such functions

Re: [web2py] Re: group by weeks

this is working db(db.orders.id > 0).select("count(1) as nr, round(id/10) as gr", groupby='gr') so I think you can use database datetime function to compute week and then grouping, most database have such functions

[web2py] Re: Belongs orders results by id

Thank you Mengu I've converted my DB to MySQL. In SQLite didn't work. On May 13, 3:48 pm, Mengu wrote: > yes, this is possible. i don't know other databases but possible with > MySQL. > > db(db.space.id.belongs((result_id))).select(orderby="FIELD(id, > 1,6,136,2,18,119,122)") > > On 13 Mayıs, 17:

Re: [web2py] web2pyslices source code

On Thu, May 13, 2010 at 12:50, mr.freeze wrote: > This has been updated for anyone interested: > http://www.web2pyslices.com/main/static/share/web2py.app.web2pyslices.w2p Very good, thanks! -- Álvaro Justen - Turicas http://blog.justen.eng.br/ 21 9898-0141

[web2py] Re: Idea: Appliance remote management

stage 3, do the "same" to plugins and slices. On May 13, 5:33 pm, Jonathan Lundell wrote: > On May 13, 2010, at 9:26 AM, Thadeus Burgess wrote: > > > This is similar to how PluginCentral will be designed, if we ever get > > that spec finalised =) > > It'd be reasonable to do both at the same site

Re: [web2py] Re: Idea: Appliance remote management

On May 13, 2010, at 9:26 AM, Thadeus Burgess wrote: > This is similar to how PluginCentral will be designed, if we ever get > that spec finalised =) It'd be reasonable to do both at the same site. > > -- > Thadeus > > > > > > On Thu, May 13, 2010 at 11:14 AM, blackthorne wrote: >> One mor

Re: [web2py] Re: Idea: Appliance remote management

This is similar to how PluginCentral will be designed, if we ever get that spec finalised =) -- Thadeus On Thu, May 13, 2010 at 11:14 AM, blackthorne wrote: > One more thing, web2py could have a list of repositories url, with the > default the one we can find on the official website but also

Re: [web2py] web2pyslices source code

nice, thanks! -- Thadeus On Thu, May 13, 2010 at 10:50 AM, mr.freeze wrote: > This has been updated for anyone interested: > http://www.web2pyslices.com/main/static/share/web2py.app.web2pyslices.w2p > >

[web2py] Re: group by weeks

I see. So there has to be some time range. Python has a calendar module, I thought perhaps putting all the weeks on a table? Will keep diggin. Thanks Dan On May 13, 12:15 pm, mdipierro wrote: > the dal has no weekday function but datetime.date does. That means if > you select the records by so

[web2py] Re: Cross reference error in DAL

I would use an intermediate table to achieve the many to many relationship: db.define_table('test', Field('name') ) db.define_table('test2', Field('name') ) db.define_table('test_relation', Field('test', 'reference test2'), Field('test2, 'reference test')) test_and_test2 = db((db.test.id=

[web2py] Re: group by weeks

the dal has no weekday function but datetime.date does. That means if you select the records by some time range we you can maniputale them at the Python/web2py level. How really depends on details. You could also create a function that uses datetime weekday to build query ranges for dal. On May 13

[web2py] Re: Idea: Appliance remote management

One more thing, web2py could have a list of repositories url, with the default the one we can find on the official website but also the possibility to add other non-official ones as well as mirrors. Technically web2py could interact with each repository by a simple specification in XML-RPC or somet

[web2py] Re: Idea: Appliance remote management

This is a good idea. On May 13, 11:09 am, blackthorne wrote: > ok, this one may be interesting... > > Currently, we can install web2py apps in one of 3 ways. uploading it, > providing its url or putting the files in the applications folder > manually. Nothing wrong with this but seems to me that

[web2py] group by weeks

Is there such thing? i need to group a result set by weeks. Sort of like total sales of the week. How could I accomplish this? I really dont want the user to be entering a range of dates. The weeks will always start on Monday and finish on Sunday. My table takes daily sales. Thanks

[web2py] Idea: Appliance remote management

ok, this one may be interesting... Currently, we can install web2py apps in one of 3 ways. uploading it, providing its url or putting the files in the applications folder manually. Nothing wrong with this but seems to me that with little effort we could take this beyond. Think about an integrated

[web2py] web2pyslices source code

This has been updated for anyone interested: http://www.web2pyslices.com/main/static/share/web2py.app.web2pyslices.w2p

Re: [web2py] Re: ORM-like DAL

Why not... define_table('post', Field('title'), Field('content', 'text')) class Post(object): @staticmethod def get_permalinkI(post): return URL(slugify(post.title)) Then just for post in db().select(db.post.ALL): print Post.get_permalink(post) -- Thadeus On Thu, May 13, 20

[web2py] Re: hello

http://alexandremas.blogspot.com/2010/02/como-configurar-web2py-e-php-no-mesmo.html On May 13, 9:40 am, mdipierro wrote: > Did you look at that web2py/scripts/stup-web2py-ubuntu.sh? > > On May 13, 5:51 am, ciprian wrote: > > > > > thanks for trying to help. but i already spent two days trying to

[web2py] Re: Belongs orders results by id

yes, this is possible. i don't know other databases but possible with MySQL. db(db.space.id.belongs((result_id))).select(orderby="FIELD(id, 1,6,136,2,18,119,122)") On 13 Mayıs, 17:28, Francisco Costa wrote: > yes, then 2,18,119,122 > > On May 13, 3:22 pm, Mengu wrote: > > > > > so you want the

[web2py] Re: Belongs orders results by id

yes, then 2,18,119,122 On May 13, 3:22 pm, Mengu wrote: > so you want them to be ordered as first 1 then 6, then 136 etc? > > On 13 Mayıs, 13:53, Francisco Costa wrote: > > > I have this query db(db.space.id.belongs(result_id)).select() > > the result id is an unsorted array of ids > > I don't w

[web2py] Re: design issue

On May 13, 2:24 pm, annet wrote: > I know web2py can connect to multiple databases, and I wonder whether > it would be possible to have two db.py files: db1.py and db2.py, where > db1.py connects to the database containing the first type of data and > db2.py connects to the company's database. db2

[web2py] Re: Belongs orders results by id

so you want them to be ordered as first 1 then 6, then 136 etc? On 13 Mayıs, 13:53, Francisco Costa wrote: > I have this query db(db.space.id.belongs(result_id)).select() > the result id is an unsorted array of ids > I don't want the query results to be order by id > > The SQL list this > SELECT

[web2py] Re: [PATCH] Make decorators well behaved

excellent! On May 13, 8:02 am, mathieu.clab...@gmail.com wrote: > Without this patches, all decorated functions __name__ is set to f, which > is not desirable in testing environment where on sometimes want to access > the name of the function under test. > Seehttp://wiki.python.org/moin/PythonDeco

[web2py] Re: Do you use web2py in your company?

I guess I should add I made three apps for DePaul University: 1) Computes and projects students headcount, credit hours and revenue by school and year. 2) Allow students to apply for assistantships and randly assignes them to faculty for anonymous review 3) A simple class management system for post

[web2py] Re: Belongs orders results by id

how can i sort results in the array order then? On May 13, 2:42 pm, mdipierro wrote: > I think this is a SQL feature they sort list to use binary search in > the index for the table for efficiency). > > On May 13, 6:57 am, Francisco Costa wrote: > > > is this a SQL Bug/feature? how can I change

[web2py] Re: Belongs orders results by id

I think this is a SQL feature they sort list to use binary search in the index for the table for efficiency). On May 13, 6:57 am, Francisco Costa wrote: > is this a SQL Bug/feature? how can I change it? > > On May 13, 11:53 am, Francisco Costa wrote: > > > I have this query db(db.space.id.belong

[web2py] Re: hello

Did you look at that web2py/scripts/stup-web2py-ubuntu.sh? On May 13, 5:51 am, ciprian wrote: > thanks for trying to help. but i already spent two days trying to > figure it out. i can install web2py with no problems - but i dont have > too much experience with mod_wsgi (google doesnt help) no we

[web2py] Re: ToscaWidgets

They do have lots of functionality. So keep up posted about progress. Anyway, the {{=LOAD(...)}} function is a way to submit web2py forms via ajax. On May 13, 3:00 am, lannick wrote: > Hi, > > Thank you for your answer. > > Massimo, I agree with you using tw-forms is not the best way to > constru

[web2py] Re: duplicate ids on using auth.login and auth.register forms on same page

please post an example of the controller and view. If I understand the problem, this should work. On May 13, 1:54 am, Rohan wrote: > i am using  latest version 1.77.3 (2010-04-20 02:48:54) > > On May 12, 8:29 pm, mdipierro wrote: > > > This was fixed. What version of web2py are you using? > > >

[web2py] Re: Django GenericForeignKey

isn't that just an integer? On May 13, 1:43 am, vihang wrote: > Hello, > > would anyone know how would one implement GenericForeignKey using > DAL?? > > Thanks > Vihang

[web2py] [PATCH] Make decorators well behaved

Without this patches, all decorated functions __name__ is set to f, which is not desirable in testing environment where on sometimes want to access the name of the function under test. See http://wiki.python.org/moin/PythonDecoratorLibrary#CreatingWell-BehavedDecorators.2BAC8.22Decoratordecorator.

[web2py] design issue

I have multiple applications connecting to the same database, some of them query the database for data on multiple companies others query the database for data on one company, apart from a company table containing the company id there is no overlap. I know web2py can connect to multiple databases,

[web2py] Re: Do you use web2py in your company?

I made several small apps, and installed a CAS to centralize the authentication but there are not enterprise grade... I made an Inventory app where we can follow the history of a piece of hardware installed and removed from computers, with categories, subcategories, sellers, invoice, warranty, e-m

[web2py] Re: Belongs orders results by id

is this a SQL Bug/feature? how can I change it? On May 13, 11:53 am, Francisco Costa wrote: > I have this query db(db.space.id.belongs(result_id)).select() > the result id is an unsorted array of ids > I don't want the query results to be order by id > > The SQL list this > SELECT space.id, space

[web2py] Cross reference error in DAL

Hi, Why am I getting an error here? model.py db=SQLDB("sqlite://db.db") db.define_table('test', Field('t', 'reference test2')) db.define_table('test2', Field('t1', 'reference test')) Error: Traceback (most recent call last): File "c:\web2py\gluon\restricted.py", line 178, in restr

[web2py] Belongs orders results by id

I have this query db(db.space.id.belongs(result_id)).select() the result id is an unsorted array of ids I don't want the query results to be order by id The SQL list this SELECT space.id, space.name FROM space WHERE space.id IN (1,6,136,2,18,119,122) i want the result to be in the order of the id

[web2py] Re: hello

thanks for trying to help. but i already spent two days trying to figure it out. i can install web2py with no problems - but i dont have too much experience with mod_wsgi (google doesnt help) no web2py tutorials and i guess this is the end. i really need to run php too on the same apache but i cant

[web2py] Re: How to auto-login into an account from an specific computer.

On May 13, 10:06 am, Benigno wrote: > We have made an app with web2py to present data from a home-automated > home as a web service. There is a certain hardware at the home that > sends all the information that transverses the bus into our server, > and from there on, we process and present the da

Re: [web2py] Re: Web2py Utils now on the CheeseShop, With a new unittesting module

Oups.. Just seen "Warning You must use web2py version 1.77.4, or at least source revision 445." on the documentation page... Sorry for the noise. -Mathieu On Thu, May 13, 2010 at 10:27, Mathieu Clabaut wrote: > Hello Thadeus, > Trying to use the testing environment, I got the following tracebac

Re: [web2py] Re: Web2py Utils now on the CheeseShop, With a new unittesting module

Hello Thadeus, Trying to use the testing environment, I got the following traceback : File "/home/clabaut/.virtualenvs/web2py/lib/python2.6/site-packages/web2py_utils/test_runner.py", line 170, in new_env 'TEST_METHOD': 'FakeEnv' TypeError: env() got an unexpected keyword argument 'extra_reque

[web2py] How to auto-login into an account from an specific computer.

We have made an app with web2py to present data from a home-automated home as a web service. There is a certain hardware at the home that sends all the information that transverses the bus into our server, and from there on, we process and present the data using web2py. There are several homes usi

[web2py] Re: ToscaWidgets

Hi, Thank you for your answer. Massimo, I agree with you using tw-forms is not the best way to construct forms. But with toscawidgets I don't want to use tw-forms but all others widgets. you can see them here : http://toscawidgets.org/hg I am a beginner in python and web2py. I don't want to learn