[web2py] Updating database outside web2py

Hi, I am working on a project where I need to update the website database outside web2py, i mean outside an standard HTTP request. For example, I have another server where TCP request comes, and I need to update one table in the database. Also, I have views defined inside web2py which prints out

[web2py] Re: SQLEDITABLE plugin

Hi all. Thank you for your quick reply. kato 2014年7月1日火曜日 20時35分06秒 UTC-3 JorgeH: > > > Cool!! > > Great work > > On Tuesday, July 1, 2014 8:12:29 AM UTC-5, kato wrote: >> >> Hi. >> >> I tried to make SQLEDITABLE plugin. >> >> demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html >> >

[web2py] Web2py sessions table does not exist?

Recently after some updates to some of my models, I got this error in web2py. Traceback (most recent call last): File "/Users/acbart/web2py/gluon/main.py", line 457, in wsgibase session._try_store_in_db(request, response) File "/Users/acbart/web2py/gluon/globals.py", line 1116, in _try_

[web2py] How to conclude posts on one page sorted by creation date in separate blocks.

hello How to conclude posts on one page sorted by creation date in separate blocks. Example: unit - Today, the unit - This week, block - Long -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

[web2py] Re: Web2py sessions table does not exist?

did you turn migrations on ? if yes, please check that there isn't a *web2py_session_runestone*.table file into the database/ folder. If there is, delete it and web2py will recreate it. On Thursday, July 3, 2014 1:44:38 AM UTC+2, Austin Bart wrote: > > Recently after some updates to some of my m

[web2py] Re: Brainstorming

Here is a project which lists and compares a little javascript frameworks: todomvc.com Dne neděle, 15. června 2014 10:34:25 UTC+2 Massimo Di Pierro napsal(a): > > Often Angular comes up on this list. I tried it and I was un-impressed. > Instead today my favorite client-side stack is based on

[web2py] Web2py Rocks ... Again :)

Finally, have ironed out all the kinks and sorted out all the errors. Most of them come about because of user-problems (yes, me), because I don't deploy to production often enough to keep up with the versions of all other supporting platforms/software. In addition, my memory sometimes fail me an

Re: [web2py] Web2py Rocks ... Again :)

+1 2014-07-03 8:38 GMT-03:00 lyn2py : > Finally, have ironed out all the kinks and sorted out all the errors. Most > of them come about because of user-problems (yes, me), because I don't > deploy to production often enough to keep up with the versions of all other > supporting platforms/softwar

Re: [web2py] Web2py Rocks ... Again :)

+1 On Thu, Jul 3, 2014 at 7:40 AM, Carlos Costa wrote: > +1 > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because yo

[web2py] Re: response.js does not load div

Now I encounter a difference between a LOAD and a link like the following: {{=A(T("Add " + session.im_labels['vpu']) ,_href=URL('internal','add_entity.load', vars=dict(com=com, sif=sif)), ajax=True, cid='internal_data_div') }} I assume this link is equal to {{=LOAD('internal','add_entity.load',

[web2py] Re: tip of the day. The power of routes

I have a question for anyone using this… I realized that it only works for redirects to the functions within default.py. If I setup another controller, it can't route to that controller. Is this the intended behaviour? How can I include other controllers without having to add one controller for

[web2py] Re: response.js does not load div

On Thursday, July 3, 2014 7:56:39 AM UTC-4, Richard wrote: > > Now I encounter a difference between a LOAD and a link like the following: > > {{=A(T("Add " + session.im_labels['vpu']) > ,_href=URL('internal','add_entity.load', vars=dict(com=com, sif=sif)), > ajax=True, cid='internal_data_div') }}

Re: [web2py] Web2py Rocks ... Again :)

On Thu, Jul 3, 2014 at 8:38 AM, lyn2py wrote: > > If you are planning to deploy to production servers, I just want to reassure > you that what works on localhost will work on production servers. Not always. Be careful, specially if you use Windows or MacOS and have mixed case file or directory na

[web2py] Re: tip of the day. The power of routes

There is nothing "default" specific in the script. Something else must be the problem. On Thursday, 3 July 2014 07:04:44 UTC-5, lyn2py wrote: > > I have a question for anyone using this… I realized that it only works for > redirects to the functions within default.py. If I setup another > contr

[web2py] Re: create an update page (similar to profile page in default application)

Ok, I got it. Yes,there is only one record for one pro_id. The 2nd one works, but now a new problem arises. I am getting the record that I want to edit, but on submitting it, a new blank form is generated(which is undesired). When I submit this form with dummy values, this form is getting insert

[web2py] Re: create an update page (similar to profile page in default application)

And I didn't understand why should I pass the 'pro_id' by GET and not by POST. This is the view from where I am passing the parameter (using POST) {{for row in rows:}} {{=x}}{{x=x+1}} {{=row.product_id}}

[web2py] Ractive.js

My eyes struck Ractive.js and I want to test it with Web2py. Web2py however uses also {{ }} as the templating characters. Ractive uses these characters also. how i Can be done ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Web2py sessions table does not exist?

Migrations should be on. I have it enabled through my DAL: db = DAL(settings.database_uri, migrate_enabled=True) And through each individual table: db.define_table('courses', ... migrate='runestone_courses.table') I've emptied the entire databases/ folder of all the .table files. This seems to hav

[web2py] How to choose a subcategory to create a post

1) Post created in a particular category. - http://hostname/app/default/created_ad/ 2)The category tied subcategories. How to make that SQLFORM display only radio button of equal sub categories. Not show subcategories not belong to this category.

[web2py] Re: Importing an already existing MySQL database

Please how can I use the script? I mean, where will I save the script? anywhere online where I can just download it instead of copy & paste? On Wednesday, 15 July 2009 00:09:20 UTC+1, Boriel wrote: > > Hi, > > I'm rather new to web2py, but I think this script might be helpful to > others. > I've

[web2py] How can I import an existing database to my db.py model?

I have successfully changed the default sqlite connection to mysql. Now I want to import an exported file (database.sql) which is an existing database. I need help on how I can do this please -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/

[web2py] CAS not working

Hello, I have a problem in using the web2py CAS service. I have created a cas_provider and a cas_client. I have accessed to cas_client /cas_client from here went to /cas_client/default/user/login?_next=/cas_client/default/index and been redirected to /cas_provider/default/user/cas/login?service=

[web2py] Re: create an update page (similar to profile page in default application)

I am not sure about what you are doing. Why do you have one form per row that does not submit any data other than a hidden field with id? What is the purpose of that submission? On Thursday, 3 July 2014 05:03:19 UTC-5, Shubham Jain wrote: > > And I didn't understand why should I pass the 'p

[web2py] Re: How can I import an existing database to my db.py model?

You should be able from the shell to do: db = DAL('myql:') db.executesql(open('./database.sql').read()) assuming the file is not too big and fits in ram. On Thursday, 3 July 2014 08:08:55 UTC-5, Gideon George wrote: > > > I have successfully changed the default sqlite connection to mysql

[web2py] Re: can we make E-commerce web portal in web2py for multiple users and hits.

The concept of "simultaneous" in a web application does not mean much. You should be able to quantity the number of http request per second, the number of dynamic http requests per second, and the number of database queries per second (per category). One web2py instance can handle ~50 dynamic h

[web2py] Re: Ractive.js

I am using ractive.js with web2py a lot these days. In web2py I set: response.delimiters = ['<%','%>'] and then I use {{...}} for ractive. On Thursday, 3 July 2014 05:21:33 UTC-5, eric cuver wrote: > > My eyes struck Ractive.js and I want to test it with Web2py. Web2py > however uses also {{

[web2py] Re: Web2py sessions table does not exist?

who said "delete everything" ? :P now, do a fake_migrate_all=True, let web2py recreate table files, then turn off fake_migrations, then delete ONLY webp2y_session_runestone and retry. Simone On Thursday, July 3, 2014 11:30:35 AM UTC+2, Austin Bart wrote: > > Migrations should be on. I have it e

[web2py] Re: {{=XML(row.contents, sanitize=True)}} and

Hi Cliff, Thanks for your reply. I put the permitted-tags and allowed-attributes parameter into a module and added the tags and attributes I needed to the lists. Problem solved. Regards, Annet -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

[web2py] Re: Web2py Rocks ... Again :)

Windows and MAC OSx is no longer a problem with docker ( http://www.docker.com/ ) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this mess

Re: [web2py] Re: tip of the day. The power of routes

Hi Massimo, Lyn2py posted above is that issue I met, I post complete script : (I mark the only one line I changed with red color) -- routes.py --- config = ''' site1.com.vn /hhp/default site2.com.vn /welcome/default ''' def auto_in(apps): routes = [

[web2py] Re: Web2py Rocks ... Again :)

+1 !! On Thursday, July 3, 2014 6:38:02 AM UTC-5, lyn2py wrote: > > Finally, have ironed out all the kinks and sorted out all the errors. Most > of them come about because of user-problems (yes, me), because I don't > deploy to production often enough to keep up with the versions of all other >

[web2py] custom layout with args

I'm sure the answer to this question is trivial, but I couldn't find it anywhere in the documentation! I'm working on a very simple test application, a simple image blog, clicking on a picture brings up a detail page. Using args with the url helper appropriately redirects, however the pages ge

[web2py] Re: Ractive.js

ok thanks a lot massimo ! Le jeudi 3 juillet 2014 16:57:06 UTC+2, Massimo Di Pierro a écrit : > > I am using ractive.js with web2py a lot these days. In web2py I set: > > response.delimiters = ['<%','%>'] > > and then I use {{...}} for ractive. > > > > On Thursday, 3 July 2014 05:21:33 UTC-5, eric

[web2py] Re: Web2py sessions table does not exist?

Ah, apologies. I was a little over-enthusiastic with my deletions. So I did fake_migrate_all=True, let web2py create the tables, and then turned off fake_migrations. However, web2py did not create a web2py_session_runestone table file. All the other tables are there, just no web2py_session_rune

[web2py] Re: custom layout with args

To the views have a {{extend 'layout.html'}} ? On Thursday, 3 July 2014 17:27:27 UTC-5, Colin Shaw wrote: > > I'm sure the answer to this question is trivial, but I couldn't find it > anywhere in the documentation! > > I'm working on a very simple test application, a simple image blog, > clickin