[web2py] jquery on block left_sidebar

2013-05-20 Thread 黄祥
hi folks, i'm using jquery().hide() in block left sidebar, when i load the page the jquery behaviour is not expected (not hidden the object) in the left sidebar, when i'm not using the block left_sidebar it works fine (hidden the object). is there a way to make jquery behave as usual when using

[web2py] MYSQL SQL Query to DAL

2013-05-20 Thread Christian Espinoza
Hi guys, please could somebody help me? from my tables: db.define_table('phone_line', Field('tel_plan',db.tel_plan), Field('phone_number',length=30), signature, format='%(phone_number)s' ) db.define_table('simcard', Field('serial',lengt

Re: [web2py] Re: Testing your app using py.test

2013-05-20 Thread Anthony
> Just as an example to how the absent of communication has led to > porrer-and-unnecessary implementation(s): > > In we2py_utils, I've seen Thadeus used 'sqlight:memory' in the > connection-string. This completely circumvent the entire issue that many > implementations I had seen have been ha

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread LightDot
Gmail's SMTP has a limit of 100 recipients per single message, max 500 different recipients per day. A large number of undeliverable messages will get you in trouble regardless of the limits. In case of a ban, the account gets locked for 24h. Yahoo has similar limitations as Gmail. Hotmail used

Re: [web2py] Suggestions for test driven development with web2py.

2013-05-20 Thread Vinicius Assef
There's some fix I'll make today. I need to create an in-memory sqlite database using sqlite:memory. Keep in touch. On Mon, May 20, 2013 at 8:00 PM, Aurelio Tinio wrote: > Awesome! Thanks viniciusban, this is helpful. > > I've gone ahead and forked your github repo and will *try* to contribute

Re: [web2py] Re: Testing your app using py.test

2013-05-20 Thread Vinicius Assef
web2py.test is not mentioned in the book because it's not part of Web2py. It's a project to make testing app easier in Web2py. Yes, it's a personal project (by myself), but it's not a nice learning experience. It's a work in progress to help people develop test driven apps in Web2py. It's been use

Re: [web2py] Suggestions for test driven development with web2py.

2013-05-20 Thread Aurelio Tinio
Awesome! Thanks viniciusban, this is helpful. I've gone ahead and forked your github repo and will *try* to contribute as time permits. On Monday, May 20, 2013 3:04:55 PM UTC-7, viniciusban wrote: > > Aurelio, visit http://github.com/viniciusban/web2py.test > > It's not fully documented yet and

Re: [web2py] Re: Testing your app using py.test

2013-05-20 Thread Arnon Marcus
Just as an example to how the absent of communication has led to porrer-and-unnecessary implementation(s): In we2py_utils, I've seen Thadeus used 'sqlight:memory' in the connection-string. This completely circumvent the entire issue that many implementations I had seen have been hammering on -

Re: [web2py] Re: Testing your app using py.test

2013-05-20 Thread Arnon Marcus
You see what I mean? I had no idea about this thing... And that is after about a full week's worth of time of research. This is very telling I think, and is exactly my point. I hate to be the 'nagging' persona here, but really, my problem is not about 'working out a solution". My problem is the wi

Re: [web2py] Suggestions for test driven development with web2py.

2013-05-20 Thread Vinicius Assef
Aurelio, visit http://github.com/viniciusban/web2py.test It's not fully documented yet and is a WIP. But it's usable. I'm using it with good results. But as you mentioned TDD, an advice: put your unit testable code in your_app/modules dir. On Mon, May 20, 2013 at 6:41 PM, Aurelio Tinio wrote: >

[web2py] Suggestions for test driven development with web2py.

2013-05-20 Thread Aurelio Tinio
Hi web2py'ers, As mentioned in other posts before, I'm a relatively new user of web2py and was wondering what the community suggests with regards to setting up a test driven development workflow. Any and all suggestions are appreciated, if you have any. Thanks, Aurelio -- --- You received

[web2py] Re: Add ondelete restriction

2013-05-20 Thread Niphlod
unless you drop the column and recreate it, web2py will not enforce a redefinition on ondelete actions cause they can end up in exceptions. On Monday, May 20, 2013 10:14:10 PM UTC+2, Denis Rykov wrote: > > I have field defenition: > > Field('company', 'reference company', notnull=True, label=

[web2py] Re: Adding extra form elements to SQLFORM

2013-05-20 Thread Anthony
Can you show your code? On Monday, May 20, 2013 4:50:34 PM UTC-4, Robin Manoli wrote: > > I'm wondering about further usage of "a*dding extra form elements to > SQLFORM", as written in the manual (link and code at the bottom). I have a > table that works fine to insert records into, fully automa

[web2py] Adding extra form elements to SQLFORM

2013-05-20 Thread Robin Manoli
I'm wondering about further usage of "a*dding extra form elements to SQLFORM", as written in the manual (link and code at the bottom). I have a table that works fine to insert records into, fully automated with SQLFORM. When I added an agree field to the SQLFORM, the form is still accepted upon

Re: [web2py] Excluding the controller name from the url

2013-05-20 Thread Monte Milanuk
Disregard... got 'routes.example.py' confused with 'router.example.py'... Looks like its working ATM. Thanks, Monte On Monday, May 20, 2013 1:22:59 PM UTC-7, Monte Milanuk wrote: > > > > On Monday, May 20, 2013 8:18:14 AM UTC-7, Jonathan Lundell wrote: >> >> >> The critical test at this point i

Re: [web2py] Excluding the controller name from the url

2013-05-20 Thread Monte Milanuk
On Monday, May 20, 2013 8:18:14 AM UTC-7, Jonathan Lundell wrote: > > > The critical test at this point is that the URL() function (it's used by > the menu) should be generating shortened URLs. If it's not, then web2py is > for some reason not seeing your routes.py, or it has perhaps a typo. >

[web2py] Add ondelete restriction

2013-05-20 Thread Denis Rykov
I have field defenition: Field('company', 'reference company', notnull=True, label='Company') and I want to add ondelete restriction: Field('company', 'reference company', notnull=True, label='Company', ondelete='NO ACTION') But web2py did not alter database. Is it expected behavior?

[web2py] Re: SPA vs ROCA (and greetings)

2013-05-20 Thread Jay Martin
Thanks for letting me know about web2py's flexibility, Derek. Per your take on OO relevance, I'll slow down on that and dig right into the nuts and bolts of web2py. Fun! On Monday, May 20, 2013 1:22:55 PM UTC-4, Derek wrote: > > Where does it fall? Probably more near ROCA than SPA, but you can

[web2py] Hey Massimo, how do you market and watch for web2py news, and other metrics and tricks.

2013-05-20 Thread smogzer
Hi Massimo, I'm launching a business and i need some launching + metrics lessons. I've followed you in reddit and Hacker news and i found you're are everywhere, monitoring and defending web2py. The ptional questions about that omnipresence are: 1) how do you market 2) and watch for web2py news, e

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Anthony
> > If your href doesn't start with a "/", the browser assumes the href is relative to the URL of the current page. So, if the current page is at http://www.yoursite.com/default/user, then the browser takes href="about.html" to mean http://www.yoursite.com/default/user/about.html. To get wh

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Lamps902
Yep. Changing this sort of stuff: to Didn't really give the scaffolding/template much thought. Just sort of assumed it all took care of itself. Thanks! On Monday, May 20, 2013 2:25:54 PM UTC-5, Niphlod wrote: > > always generate your urls with URL().. > > On Monday, May 20, 2013 9:1

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Niphlod
always generate your urls with URL().. On Monday, May 20, 2013 9:19:17 PM UTC+2, Lamps902 wrote: > > Oops. Just noticed something (sorry; gotten really out of practice lately, > and I'm forgetting to check the obvious). If the current page is one of the > 'user' pages, and I click on 'about'

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Lamps902
Oops. Just noticed something (sorry; gotten really out of practice lately, and I'm forgetting to check the obvious). If the current page is one of the 'user' pages, and I click on 'about', the page looks for 'default/user/about' instead of 'default/about' as it should. In layout.html. the links

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Niphlod
request.folder never changes. There's surely some bug in the code cause if you try to put , e.g. STATIC_SOMETHING = 'never changes' in models, and in a layout.html you do {{=STATIC_SOMETHING}} it gets printed in every page. PS: why the "dinamically" in the title ? it's pretty much static ^_^

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Lamps902
Just checked it out. request.folder stays exactly the same regardless of whether the current page is a user page or not. On Monday, May 20, 2013 2:04:11 PM UTC-5, Derek wrote: > > I'd start by debugging - the variable in question would be > 'request.folder'. does it change in some way when the c

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Derek
I'd start by debugging - the variable in question would be 'request.folder'. does it change in some way when the current page is a 'user' page? On Monday, May 20, 2013 11:53:06 AM UTC-7, Lamps902 wrote: > > I have a few pages (about, FAQ, terms of service) that are loaded from > text files in t

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Lamps902
That was pretty much it above. The corresponding html files are basically like this: {{extend 'layout.html'}} frequently asked questions {{=content_files_as_HTML['faq']}} What other code should I post? On Monday, May 20, 2013 1:56:23 PM UTC-5, Niphlod wrote: > > without the code you use to loa

[web2py] Re: Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Niphlod
without the code you use to load them, it's quite impossible to figure out why it doesn't work. On Monday, May 20, 2013 8:53:06 PM UTC+2, Lamps902 wrote: > > I have a few pages (about, FAQ, terms of service) that are loaded from > text files in the static folder. The setup is basically like this

[web2py] Dynamically loaded pages not found when link clicked from 'user' function/pages

2013-05-20 Thread Lamps902
I have a few pages (about, FAQ, terms of service) that are loaded from text files in the static folder. The setup is basically like this: content_files = Storage() file_handler = open(os.path.join(request.folder,"static","content","about.txt"),'r') content_files['about'] = file_handler.read() c

[web2py] Re: Save selected option after form submission

2013-05-20 Thread Denis Rykov
I've solved my problem by using 'value' instead '_value': SELECT(admin_units, _name='admin_unit', value=request.get_vars.get( 'admin_unit', None)) On Tuesday, May 21, 2013 12:39:01 AM UTC+7, Niphlod wrote: > > then you must set the selected attribute of your default option to > "selected". > >

[web2py] Re: What would be the best way to optimize/resize images after upload

2013-05-20 Thread Derek
It's using 'requires' because that will take the image and do something with it as a check, before validating the data and writing it to the database. In this case, it resizes the image as the "check". You might be able to find a validator that works with sqlform and replace it's check with the

[web2py] Re: What would be the best way to optimize/resize images after upload

2013-05-20 Thread Derek
That won't do anything. You want this: db.table_name.picture.requires = RESIZE(200, 200) Form.requires probably does absolutely nothing. Your table name is 'test' and your field with the image is called 'pic' so to adapt the imageutils.py example to your site would be this: db.test.pic.requires

[web2py] Re: Save selected option after form submission

2013-05-20 Thread Niphlod
then you must set the selected attribute of your default option to "selected". e.g. options = [OPTION(text, _value=value, _selected=True)] On Monday, May 20, 2013 7:05:11 PM UTC+2, Denis Rykov wrote: > > Thanks for response. But I build form manually, not from database table. > What I have to

[web2py] Re: SPA vs ROCA (and greetings)

2013-05-20 Thread Derek
Where does it fall? Probably more near ROCA than SPA, but you can build your apps however you want. It's open enough to allow both of those use cases. OO may be helpful, but it's not necessary with Web2py. Web2py just gives you all the help you need to build your app as quickly as possible. It

Re: [web2py] URL for complete Datetime in REST

2013-05-20 Thread Vinicius Assef
It's Python, right? ;-) So use urllib.urlencode() On Mon, May 20, 2013 at 2:06 PM, Mauricio cleveland wrote: > Hi, mi question is: > > How I can send the full datetime format for REST URL in a query? > > For example in a GET method: > > patterns = [ > ... > "/filas/{fila.

[web2py] URL for complete Datetime in REST

2013-05-20 Thread Mauricio cleveland
Hi, mi question is: How I can send the full datetime format for REST URL in a query? For example in a GET method: patterns = [ ... "/filas/{fila.datetime.ge}", ] In URL ".../api/filas/filas/fecha/2013-05-18" work fine, but i need for example: ".../api/filas/

[web2py] Re: Save selected option after form submission

2013-05-20 Thread Denis Rykov
Thanks for response. But I build form manually, not from database table. What I have to do in this case? On Monday, May 20, 2013 1:52:06 PM UTC+7, Niphlod wrote: > > when you receive the form value, it's probably inside a > form.vars.name_of_the_field . > > save it somewhere (database, session,

[web2py] Re: A more concise way to update or insert?

2013-05-20 Thread Derek
Right, well, it sounds like you know what you want then. Some kind of update mechanism that doesn't take null fields. Nothing like that exists in Web2py, so that answers your question. However, the way I see it, you can write one fairly easily. Get your 'update' row, make it a dict (dict a). If t

Re: [web2py] Re: web2py real time apps

2013-05-20 Thread António Ramos
also www.meteor.com 2013/5/20 António Ramos > excellent video from Bruno joining websockets with web2py > http://www.youtube.com/watch?v=MUWy-NSrvNQ > > > 2013/5/20 samuel bonilla > >> >> thanks massimo, wanna use mokshaproject.net, because if you can use with >> flask, i think that also can b

Re: [web2py] Re: web2py real time apps

2013-05-20 Thread António Ramos
excellent video from Bruno joining websockets with web2py http://www.youtube.com/watch?v=MUWy-NSrvNQ 2013/5/20 samuel bonilla > > thanks massimo, wanna use mokshaproject.net, because if you can use with > flask, i think that also can be integrated with web2py > > thaks... > > > 2013/5/20 Massim

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread Lamps902
On Monday, May 20, 2013 10:31:41 AM UTC-5, Niphlod wrote: > > I really don't think that smtp.live.com accepts happily more than a > few emails per day (same thing goes for google's SMTPs using a personal > account). > They're not meant to be used by servers :P > Which is exactly why I'm lo

[web2py] Re: A more concise way to update or insert?

2013-05-20 Thread David S
The issue with doing it that way is the files are not separated (in the same folder) and there's not really a good way to tell them apart as the file names are just numbers. I've also no control over where the files are stored, or the folder structure. I suppose I could do something that checks

[web2py] Re: Missing request.vars. when is being passed back by Ajax

2013-05-20 Thread Yuval
Even better! Thank you Anthony. On Monday, May 20, 2013 9:17:05 AM UTC-7, Anthony wrote: > > I hope that the document was better, it is somewhat lacking on this area. > > > The book does indicate that the second argument to the ajax() function > takes a list of names of input fields (not arbitrar

[web2py] Re: Mercurial not found

2013-05-20 Thread Niphlod
that's because the binary distribution doesn't ship with mercurial... if you fiddle with source code (and need version control) you're kinda "required" to use the source code distribution. On Monday, May 20, 2013 5:34:20 PM UTC+2, tim spear wrote: > > I had the same error with the web2py.exe ver

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Anthony
Setting a field's "writable" attribute to False prevents users from inputting values in forms, and setting the "readable" attribute to False prevents the field from appearing at all. Note, you can set these attributes dynamically, so they can default to False, but you can selectively set them t

[web2py] Re: A more concise way to update or insert?

2013-05-20 Thread Niphlod
given that you wrote your own parser, why are you having problems with updates ? just pass only the columns you need to update to the update_or_insert statement On Monday, May 20, 2013 5:41:11 PM UTC+2, David S wrote: > > I've got some csv files which need to be imported to a table. However

[web2py] Re: Missing request.vars. when is being passed back by Ajax

2013-05-20 Thread Anthony
> > I hope that the document was better, it is somewhat lacking on this area. The book does indicate that the second argument to the ajax() function takes a list of names of input fields (not arbitrary HTML element id's) -- it is meant to serialize form inputs. Anyway, there is a simpler appro

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Chris Teodorski
Sorry - it is a one to one relationship. So if I include it as part of the auth_user table -- I will need to prevent users form directly editing the challenge fields (and not expose them on registration) -- so I guess I now need to figure out how to do that. Thanks again for the help. On Mon

[web2py] Re: Missing request.vars. when is being passed back by Ajax

2013-05-20 Thread Yuval
Life saver, it works, I hope that the document was better, it is somewhat lacking on this area. Thanks, Yuval On Sunday, May 19, 2013 11:35:23 PM UTC-7, Lio wrote: > > Hi Yuval, > > I was trying to do the same as you passing vars to controller via DIV. The > fact is (as far as I tested), ajax(ur

[web2py] bonita bpm with web2py

2013-05-20 Thread António Ramos
hello i need a workflow engine in web2py. I saw some discussion about it in previous posts but seems a topic that few people care. recently i discovered bonita bpm , open source solution. It has a rest api that can be called from web2py. Also discovered pybonita on github to interface with bonit

[web2py] Re: How to embed Linux script into a web2py controllers

2013-05-20 Thread si...@ymail.com
Thanks so much for your reply! Your advice makes sense, but it doesn't return a list of the Network ESSID's it only returns a number. Is there a more secure way i can do this. I know the application running on the raspberry pi is trying to access this information as a "www-data". how would i gi

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Anthony
I assumed this was a one-to-many relationship, but given that it is actually one-to-one, you certainly could just put the t_teams fields directly in the auth_user table. Anthony On Monday, May 20, 2013 10:02:11 AM UTC-4, Chris Teodorski wrote: > > Let me try again to explain what I'm striving f

[web2py] A more concise way to update or insert?

2013-05-20 Thread David S
I've got some csv files which need to be imported to a table. However the import_from_csv_file function doesn't seem to work because the files can (and almost always do) contain errors and to the best of my knowledge that function cannot fix errors on the fly. Anyway, I decided to write my own

[web2py] Re: PythonAnywhere issue with mercurial

2013-05-20 Thread tim spear
I had the same error with the web2py.exe version of web2py I found the versioning button works ok though from the python source version (see http://ochiba77.blogspot.co.uk/2011/10/how-to-install-web2py-from-source.html ) On Wednesday, June 27, 2012 10:57:15 AM UTC+1, Nico Zanferrari wrote: >

[web2py] SPA vs ROCA (and greetings)

2013-05-20 Thread Jay Martin
Greetings All, I'm new here. Congratulations on building a great framework and community! I hope to learn and contribute along with you. I don't have a specific technical problem. However, I will share a question stemming from my current state of curiosity about web app architectures that you

[web2py] Re: Mercurial not found

2013-05-20 Thread tim spear
I had the same error with the web2py.exe version of web2py I found the versioning button works ok though from the python source version (see http://ochiba77.blogspot.co.uk/2011/10/how-to-install-web2py-from-source.html ) On Tuesday, August 28, 2012 4:59:25 PM UTC+1, Sergi Pons Freixes wrote:

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread Niphlod
I really don't think that smtp.live.com accepts happily more than a few emails per day (same thing goes for google's SMTPs using a personal account). They're not meant to be used by servers :P Il giorno lunedì 20 maggio 2013 17:14:29 UTC+2, Lamps902 ha scritto: > > correctly identified (rev

Re: [web2py] Excluding the controller name from the url

2013-05-20 Thread Jonathan Lundell
On 20 May 2013, at 7:55 AM, Monte Milanuk wrote: > On Sunday, May 19, 2013 9:56:45 PM UTC-7, Jonathan Lundell wrote: > You may need to restart web2py after making changes to routes.py > > Did that, several times. > > (changing it in web2py root is fine). > > If I have a routes.py in both an

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread Lamps902
> > correctly identified (reverse dns, mx, etc), so you don't get included in > a blacklist as soon as you start using it ^_^ Ironically, it happened with my Outlook account, although it seems to have been configured correctly (with a bit of assistance from my registrar's tech support)! In o

Re: [web2py] Excluding the controller name from the url

2013-05-20 Thread Monte Milanuk
On Sunday, May 19, 2013 9:56:45 PM UTC-7, Jonathan Lundell wrote: > You may need to restart web2py after making changes to routes.py > Did that, several times. > (changing it in web2py root is fine). > If I have a routes.py in both and in the application folder, which one takes precedenc

Re: [web2py] Re: web2py real time apps

2013-05-20 Thread samuel bonilla
thanks massimo, wanna use mokshaproject.net, because if you can use with flask, i think that also can be integrated with web2py thaks... 2013/5/20 Massimo Di Pierro > Interesting. I will take a look. Also look at > > https://www.firebase.com/ > > http://greg.thehellings.com/2011/04/web2py-webs

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread Niphlod
even with that piece of code there has to be an "host" :D Mail servers are easy to install. The not so easy part is configuring them to be secure (avoiding being used as spam relays) and correctly identified (reverse dns, mx, etc), so you don't get included in a blacklist as soon as you start us

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Chris Teodorski
Let me try again to explain what I'm striving for and see if that helps you guys help me. I'm really trying to explain as concisely as possible, without explaining the nitty gritty of what I'm trying to do. In my ideal situation, when a user registers, they create a team name as part of th

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread Lamps902
Is it necessary to have an SMTP server available on your system? I guess I was wondering if there is some kind of ad-hoc email server-like functionality that comes with web2py - for example, something like this: http://www.tutorialspoint.com/python/python_sending_email.htm - that can be readily

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Chris Teodorski
I'm going to give this a try -- but I'm honestly not sure exactly what this field definition does. I'm going to play with it a bit and RTFM to see if I can figure it out. On Monday, 20 May 2013 09:26:23 UTC-4, Anthony wrote: > > Would it work for you to just have a foreign key reference to th

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread LightDot
Short answer: yes, you can send email locally. For more details, you'll need to provide additional information like what is your local server's OS and it's version, etc...? Is it connected to the web directly, without NAT, firewalls, etc.? Regards, Ales On Monday, May 20, 2013 3:14:03 PM UTC+

[web2py] Re: Send registration email directly from local server?

2013-05-20 Thread Niphlod
if you have an smtp server on your server ready to be used, why not ? Il giorno lunedì 20 maggio 2013 15:14:03 UTC+2, Lamps902 ha scritto: > > At the moment, my custom domain is associated with Outlook, and my page's > email settings are configured this way: > > settings.email_server = 'smtp.live

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Anthony
Would it work for you to just have a foreign key reference to the auth_user primary key, which is the id field? You could set the "represent" attribute of the "name" field to display the "team_name" value from the referenced auth_user record. db.define_table('t_teams', Field('name', db.auth

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Anthony
> The *requires *I posted solves the problem if all the inserted data is > being validated (so, either by form or by, e.g., > db.table.validate_and_insert()), in the sense that the FK is checked by > web2py upon insertion. > Though that only helps with the initial record creation. If the user

[web2py] Send registration email directly from local server?

2013-05-20 Thread Lamps902
At the moment, my custom domain is associated with Outlook, and my page's email settings are configured this way: settings.email_server = 'smtp.live.com:587' settings.email_sender = '[sender_name]@[mydomain.com]' settings.email_login = '[username]:[pass]' It seems that every few emails I send, O

[web2py] Re: web2py real time apps

2013-05-20 Thread Massimo Di Pierro
Interesting. I will take a look. Also look at https://www.firebase.com/ http://greg.thehellings.com/2011/04/web2py-websockets-and-socket-io-part-i-basic-display/ On Sunday, 19 May 2013 19:31:33 UTC-5, samuel bonilla wrote: > > hi all... > > i like web2py, wanna develop an aplication in real time

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Niphlod
web2py executes all commands always within a transaction. Il giorno lunedì 20 maggio 2013 15:04:23 UTC+2, Paolo valleri ha scritto: > > At least with sqlite wrapping a list of insert by adding respectively at > the beginning and at the end > BEGIN TRANSACTION/END TRANSACTION > allows to speed up

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Paolo valleri
At least with sqlite wrapping a list of insert by adding respectively at the beginning and at the end BEGIN TRANSACTION/END TRANSACTION allows to speed up the performance, see: http://stackoverflow.com/questions/1711631/how-do-i-improve-the-performance-of-sqlite could we do something like that in

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Niphlod
this is the implementation def bulk_insert(self, table, items): return [self.insert(table,item) for item in items] no limits there, but it doesn't leverage any native BULK operation, so, don't pass a list of 1 zillion dicts. -- --- You received this message because you are subscribed

[web2py] Re: Caution when updating web2py- welcome app is overwritten

2013-05-20 Thread Rob_McC
Thanks, I knew of "init" but I didn't know the priority of loading. R The default loading app is "init", before "welcome". > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from

Re: [web2py] Re: Query not supported, but it generates a valid SQL-level query

2013-05-20 Thread Johann Spies
On 20/05/2013 14:17, Niphlod wrote: recently the code to count the records changed... did you try trunk without the cache_count argument ? Yes. I am working on the trunk as updated about 7 or 8 hours ago. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databe

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Paolo valleri
I didn't know that as well, Is there a limit in the number of dicts passed to the bulk_insert? Paolo On Monday, May 20, 2013 11:18:51 AM UTC+2, Niphlod wrote: > > there's a bulk_insert method too. > > http://web2py.com/books/default/chapter/29/06?search=bulk > > Il giorno lunedì 20 maggio 2013 1

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread Niphlod
when you started web2py for the first time you should have created it. The password is stored in a file that is called parameters_portnumber.py If you don't have that file, then log on the server with ssh, go into the web2py folder and do python from gluon.main import save_password save_password

Re: [web2py] Re: Query not supported, but it generates a valid SQL-level query

2013-05-20 Thread Niphlod
recently the code to count the records changed... did you try trunk without the cache_count argument ? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Niphlod
ok on the foreign key, but web2py doesn't allow "non-id" to be references unless all the tables involved are keyed tables. The *requires *I posted solves the problem if all the inserted data is being validated (so, either by form or by, e.g., db.table.validate_and_insert()), in the sense that t

[web2py] Re: Referencing auth_user custom field in another table

2013-05-20 Thread Chris Teodorski
What I'm trying to do -- and obviously not explaining well is to have t_teams.name to be a foreign key for the field custom field in auth_users. Does that explain it any better? On Monday, 20 May 2013 02:59:00 UTC-4, Niphlod wrote: > > uhm. > what do you want (as examples) in auth_user.team_nam

Re: [web2py] Re: Query not supported, but it generates a valid SQL-level query

2013-05-20 Thread Johann Spies
On 20/05/2013 12:53, Niphlod wrote: probably the bit that tries to count how many records are in it. Just to try it out, in trunk there's a new cache_count argument to the grid. can you try adding || cache_count=100 Spot-on. Thanks. Regards Johann -- Johann Spies

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Rocco
Many thanks, Niphlod! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.co

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread yashar
yes but what is the password? how could i set password? On Monday, May 20, 2013 3:10:23 PM UTC+4:30, Niphlod wrote: > > the appadmin is accessible if you previously logged in into the /admin/ > application (usually https://yourhost/admin/default/site page). > Did you do that step ? > > Il giorno

[web2py] Re: Query not supported, but it generates a valid SQL-level query

2013-05-20 Thread Niphlod
probably the bit that tries to count how many records are in it. Just to try it out, in trunk there's a new cache_count argument to the grid. can you try adding cache_count=100 to your grid instantiation ? If it doens't say "query not supported" we'll know that the failing part is in fact the

[web2py] Query not supported, but it generates a valid SQL-level query

2013-05-20 Thread Johann Spies
The following code results in an error: "Query not supported": query = db.akb_l1_journal.jnl_id ==db.akb_journals_mentioned_in_sa_list. jnl_id fields = [db.akb_l1_journal.title, db.akb_l1_journal.abbreviation, db.akb_l1_journal.issn] form = SQLFORM.grid(query, fields = fields

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread Niphlod
the appadmin is accessible if you previously logged in into the /admin/ application (usually https://yourhost/admin/default/site page). Did you do that step ? Il giorno lunedì 20 maggio 2013 12:31:31 UTC+2, yashar ha scritto: > > yes , if i want to run it from uwsgi. > > On Monday, May 20, 2013 2

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread yashar
yes , if i want to run it from uwsgi. On Monday, May 20, 2013 2:44:53 PM UTC+4:30, Niphlod wrote: > > so the problem is that you can't reach the > https://yourhost/appname/appadmin page ? > > > Il giorno lunedì 20 maggio 2013 11:58:48 UTC+2, yashar ha scritto: >> >> thanks for the fast reply, yes

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread Niphlod
so the problem is that you can't reach the https://yourhost/appname/appadmin page ? Il giorno lunedì 20 maggio 2013 11:58:48 UTC+2, yashar ha scritto: > > thanks for the fast reply, yes the problem is speed over ssh connection > but let me ask like this, is this possible to run appmin panel wit

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread yashar
thanks for the fast reply, yes the problem is speed over ssh connection but let me ask like this, is this possible to run appmin panel with uwsgi? i know i have to use ssh for connecting al last. On Monday, May 20, 2013 2:06:28 PM UTC+4:30, Niphlod wrote: > > honestly I don't get what you want.

[web2py] Re: admin panle with uwsgi

2013-05-20 Thread Niphlod
honestly I don't get what you want. When you use ssh to connect to the host you have the same exact speed than connecting through http to that host. Accessing the admin app with or without the ssh tunnelling can't generate problems on the speed side: the required bandwith is roughly the same. So

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Niphlod
there's a bulk_insert method too. http://web2py.com/books/default/chapter/29/06?search=bulk Il giorno lunedì 20 maggio 2013 10:36:32 UTC+2, Rocco ha scritto: > > Dear all, > > I've a loop to insert about 2K records into a postgres database (running > on same host). > > This is the used code: > >

[web2py] admin panle with uwsgi

2013-05-20 Thread yashar
using ssh for connecting to admin panel is slow, if it was possible to use something like connecting to application folder for retrieving models/controller/view.. files and using local admin panel could boost the speed. my question: is this possible to use uwsgi and pass password to it? --

[web2py] Bulk insert: how to improve performances?

2013-05-20 Thread Rocco
Dear all, I've a loop to insert about 2K records into a postgres database (running on same host). This is the used code: for row in cnv.data_matrix: sensor_n=0 for element in row: db.CTD_DATA.insert(CTD_STATION_ID=stationid,SENSOR= sen