[web2py] Re: Getting only the latest "version" in a query of items with versions.

2016-08-24 Thread Encompass solutions
On Thursday, August 25, 2016 at 8:36:58 AM UTC+3, Dave S wrote: > > > > On Wednesday, August 24, 2016 at 10:29:09 PM UTC-7, Encompass solutions > wrote: >> >> Does this seem sensible? It seems to work with my initial tests. >> >> latest_versions = db( (db

[web2py] Re: Getting only the latest "version" in a query of items with versions.

2016-08-24 Thread Encompass solutions
) & (db.item_version.id > 0) ).select(db.item.ALL, db.item_version.ALL, db.item_version.version_date.max(), groupby=db.item.id) On Thursday, August 25, 2016 at 8:29:09 AM UTC+3, Encompass solutions wrote: > > Does this seem sensible? It

[web2py] Re: Getting only the latest "version" in a query of items with versions.

2016-08-24 Thread Encompass solutions
item.id) the .max() feature, at least what I found, was totally undocumented. We should have an example database as part of the documentation with a collection of examples around it so we can all relate better. :/ On Monday, August 22, 2016 at 10:52:55 AM UTC+3, Encompass solutions wrote: >

[web2py] Re: Getting only the latest "version" in a query of items with versions.

2016-08-23 Thread Encompass solutions
, 2016 at 10:52:55 AM UTC+3, Encompass solutions wrote: > > Consider the following pseudo model. > > item > ->name = "string" > > version > ->item_id = item.id > ->version_date = "datetime" > > > While I can easily create a collection

[web2py] Getting only the latest "version" in a query of items with versions.

2016-08-22 Thread Encompass solutions
Consider the following pseudo model. item ->name = "string" version ->item_id = item.id ->version_date = "datetime" While I can easily create a collection of the item with it's versions. all_items = db((db.item.id > 0) & (db.version.item_id == db.item.id)).select(orderby=db.item.name |

[web2py] Re: populating the values in a SQLFORM with default data in a field type of list:string

2016-08-05 Thread Encompass solutions
Could someone test something similar to this out? Am I getting this wrong with setting the default values in this field? It feels like a bug in web2py. On Wednesday, August 3, 2016 at 1:20:50 PM UTC+3, Encompass solutions wrote: > > It seems that my SQLFORM.factory won't populate d

[web2py] populating the values in a SQLFORM with default data in a field type of list:string

2016-08-03 Thread Encompass solutions
It seems that my SQLFORM.factory won't populate default values. Are you guys getting similar or am I doing this wrong? Here is what I am doing. emails = [] for member in members: emails.append(member.email) form = SQLFORM.factory(Field("members", "list:string",

[web2py] Re: Ho to maintain the sequence serial numbers for table row id's even if we delete any row from table.+

2016-06-23 Thread Encompass solutions
The id field sequences like this so that any referencing items don't get screwed up. You would need to renumber the sequence, that's a bad thing. What is it your wanting to do actually? If you simply query the items they are sorted by id value. On Thursday, June 23, 2016 at 12:22:57 PM UTC+3,

[web2py] Issue with the cheatsheet for web2py

2016-06-23 Thread Encompass solutions
I was using this: http://web2py.com/examples/static/web2py_cheatsheet.pdf And was getting the request.http_host After some research I found it was actually, request.env.http_host Should we update the cheatsheet? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Using web2py's template parser in an interesting way.

2016-04-06 Thread Encompass solutions
The application has to be in a png format, the application builders are designers that use vector. And the system passes the png to a very simple view that can only handle still images in png or jpg format, maybe one a minute with web2py as the "Application framework". Otherwise, yes, on every

[web2py] Grouping by date in a query...

2016-02-29 Thread Encompass solutions
Not much documentation about this, as far as I can find. I want to count and group by the date without the time or day. That is... https://groups.google.com/forum/#!searchin/web2py/group$20and$20count$20by$20date/web2py/G6xRnfONnSo/bXaG4bhigwIJ But with the date. Obviously .date() doesn't work

[web2py] Re: block tags replace the content, but also still print where they stand.

2015-12-14 Thread Encompass solutions
the except line. On Saturday, December 12, 2015 at 2:31:24 PM UTC+2, Encompass solutions wrote: > > It seems that I have a block in my main layout but when I insert a block > in the included view it print the text where it stands as well as replace > the item in the block. &

[web2py] block tags replace the content, but also still print where they stand.

2015-12-12 Thread Encompass solutions
It seems that I have a block in my main layout but when I insert a block in the included view it print the text where it stands as well as replace the item in the block. What am I doing wrong, or is this a bug? BR, Jason Brower -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] FEATURE REQUEST: Case Insensitive Field types

2015-12-02 Thread Encompass solutions
I am not sure this exists yet, but it would be nice to take a string field (or anything string like) and make it case insensitive. That way I don't have to worry the j...@example.com is the same as j...@example.com What do you guys think? -- Resources: - http://web2py.com -

[web2py] Using web2py's template parser in an interesting way.

2015-10-30 Thread Encompass solutions
I have been trying to understand web2py's builtins for some fun features I am working on. Basically I am trying to make a renderer for svg files and want to convert escaped charactors like quot; back to there actual charactors. This would encable me to create SVG's that can use the templating

Re: [web2py] Buying a template for the community...

2015-10-11 Thread Encompass solutions
Sure, that probably works just fine too. :) I just think we should start cleaning up that interface and make it more UX friendly than now. BR, Jason Brower On Sunday, October 11, 2015 at 10:34:26 AM UTC+3, AngeloC wrote: > > I Jason, > > 2015-10-11 9:24 GMT+02:00 Jason (spot) Brower

[web2py] Re: Static content seems to load with a 404 error... uwsgi nginx

2015-10-05 Thread Encompass solutions
SERVER_SOFTWAREnginx/$nginx_version; } } On Sunday, October 4, 2015 at 1:24:03 PM UTC+3, Encompass solutions wrote: > > I have setup uwsgi and I seem to be very close to having everything > working. > It just seems that my static data is not loaded now. (css, images,

[web2py] Static content seems to load with a 404 error... uwsgi nginx

2015-10-04 Thread Encompass solutions
I have setup uwsgi and I seem to be very close to having everything working. It just seems that my static data is not loaded now. (css, images, so forth) This is my nginx file with the web2py applicaiton in it. Any ideas into the issue? My web2py installation is located in /var/www/web2py/. #

[web2py] Re: Static content seems to load with a 404 error... uwsgi nginx

2015-10-04 Thread Encompass solutions
include uwsgi_params; uwsgi_param UWSGI_SCHEME $scheme; uwsgi_param SERVER_SOFTWAREnginx/$nginx_version; } On Sunday, October 4, 2015 at 1:24:03 PM UTC+3, Encompass solutions wrote: > > I have setup uwsgi and I seem to be very close to h

[web2py] Is there a way to user response.render with a string object.

2015-09-08 Thread Encompass solutions
It seems I have to use response.render with a file location. Is it possible to use a string response? Sorry haven't tested but I assume it can't because it's a string to string check. I really I hope to use this in a new template system I am setting up. It will be pulling the templates from

[web2py] Re: Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

2015-08-14 Thread Encompass solutions
Is there any progress with this issue? I have lighttpd setup and it seems to still have the issue. Take a look at this screenshot to see. It's a real bummer as the NGINX has proven hard to install on centos 6.6. At least for us. :) On Sunday, March 1, 2015 at 10:38:37 AM UTC+2, Niphlod

[web2py] Re: How do I check of the version of pysimplesoap in web2py.

2015-06-28 Thread Encompass solutions
: response = ERROR {0}: {1}.format(e.faultcode, e.faultstring) On Thursday, 25 June 2015 06:32:00 UTC+12, Dave S wrote: On Wednesday, June 24, 2015 at 4:39:57 AM UTC-7, Encompass solutions wrote: Found it. it's in the init.py file in gluon/contrib/pysimplesoap/ It's version 1.11

[web2py] Re: How do I check of the version of pysimplesoap in web2py.

2015-06-24 Thread Encompass solutions
Found it. it's in the init.py file in gluon/contrib/pysimplesoap/ It's version 1.11 which is a little behind, but there are some regression as of last year, we should check before bumping up the version. On Wednesday, June 24, 2015 at 9:52:08 AM UTC+3, Encompass solutions wrote: I am trying

[web2py] Re: Restricting Access to database based on roles at the Database level.

2015-05-14 Thread Encompass solutions
://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Common-filters functionality. Anthony On Thursday, May 14, 2015 at 5:58:20 AM UTC-4, Encompass solutions wrote: I am building a database that needs to be very secure for all those just in case situations. I want

[web2py] Trying to post a small improvement to web2py source.

2014-09-13 Thread Encompass solutions
How do I submit a small change I have made the the Web2py source? It's a small improvement. But when I try to git push I get a 403 error. I also don't know much about pull requests, but I think those are involved too. BR, Jason Brower -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Sass support example for web2py.

2014-09-07 Thread Encompass solutions
I use templates from wrapbootstrap a lot. 3 times a month even. Sadly however, it's getting harder and harder to use those templates with web2py due to no support be it built-in or not, for SASS, LESS, and others getting much more popular. How can I make it so I code my css in SASS but to the

Re: [web2py] Sass support example for web2py.

2014-09-07 Thread Encompass solutions
I understand. Gulp might be my ticket here. Let me learn more about it. BR, Jason Brower On Sunday, September 7, 2014 9:30:34 PM UTC+3, Niphlod wrote: BTW: there's a reason why they're called PRE-processors. Because they are meant to refresh the dest just when the source is changed, not

[web2py] Web2py, nginx, installation on Raspberry Pi

2014-08-24 Thread Encompass solutions
Hi, Currently I am getting a 502 Bad Gateway Error when trying to access my web2py server running on Raspberry Pi. I first tried the setup with the script setup-web2py-nginx-ubuntu.sh as it's nearly identical to the instructoins found here. http://web2py.com/books/default/chapter/29/13#Nginx

[web2py] Re: Web2py vs ruby on rails for a startup?

2014-08-24 Thread Encompass solutions
I think about the easy of handing the server off to others to test and setup. Web2py is much easier. BY FAR. BR, Jason On Sunday, August 10, 2014 9:43:02 AM UTC+3, Suresh Mali wrote: I am trying to zero on web framework for our startup, requirements a. Security ( we are working on

[web2py] Re: Web2py vs ruby on rails for a startup?

2014-08-24 Thread Encompass solutions
I have worked with 10s of python people and there transition to web2py was easy. Ruby itself is hard to find, but python is much more popular. On Sunday, August 10, 2014 8:20:43 PM UTC+3, Massimo Di Pierro wrote: In my opinion the server costs are negligible whichever way you go. Most RoR

[web2py] Re: Feature Request: IS_IN_SET with list:string field type

2014-04-11 Thread Encompass solutions
Thanks! On Saturday, March 29, 2014 2:50:42 PM UTC+2, Encompass solutions wrote: I would love to have a list set with strings but I am able to define if they should be of a certain string type. Does this already exist and I did it wrong, or would this be a good idea to implement. BR

[web2py] Re: Password feild type seems to save in plain text for me.

2014-03-26 Thread Encompass solutions
to set the CRYPT validator explicitly. Anthony On Tuesday, March 18, 2014 1:04:54 PM UTC-4, Encompass solutions wrote: I am trying to create a model with an encrypted key so it's harder for someone to maliciously screw over my customers. I have the following snippet. Field('public_gram

[web2py] Re: Voting system without users.

2014-03-22 Thread Encompass solutions
. The session way of holdding back votes seem to work for now. We will see if people abuse it. So far, I don't think there is much point in it. BR, Jason Brower On Tuesday, March 4, 2014 9:39:11 AM UTC+2, Encompass solutions wrote: I was thinking of a voting system without users, but I wanted to get

[web2py] Admin interface doesn't allow me to code very well from an android device.

2014-03-22 Thread Encompass solutions
When I try to view an admin page in my Android desktop it shows the mobile view. I have clicked the Request desktop site. option and the admin interface is still returned in the mobile view. I don't like this view when I run in on my android desktop at III have a full hd screen.

[web2py] Re: Problems with the server stalling out. Setting up debuging.

2014-03-21 Thread Encompass solutions
The issue was fixed. Sorry for not seeing the follow up. I switched to NGIX and everything works perfectly. Haven't seen this issue since. BR, Jason Brower On Sunday, February 2, 2014 8:14:21 PM UTC+2, Encompass solutions wrote: It seems that I have an issue I can't resolve. Every once

[web2py] Re: Password feild type seems to save in plain text for me.

2014-03-21 Thread Encompass solutions
I was using the admin pages to add the value to the database. Interesting to ssee that SQLFORM was not used in the admin panel. BR, Jason On Tuesday, March 18, 2014 7:04:54 PM UTC+2, Encompass solutions wrote: I am trying to create a model with an encrypted key so it's harder for someone

[web2py] Password feild type seems to save in plain text for me.

2014-03-18 Thread Encompass solutions
I am trying to create a model with an encrypted key so it's harder for someone to maliciously screw over my customers. I have the following snippet. Field('public_gram', 'boolean', default=False), Field('tag_name', 'list:string'), Field('deletion_key', 'password') ) You can see

Re: [web2py] Virtual Fields not working on print.

2014-02-19 Thread Encompass solutions
To try to triage the bug I did the following... import os import pygeoip #gi = pygeoip.GeoIP(os.path.join(request.folder, 'private', 'GeoIP.dat')) def get_country(row): return what? # -*- coding: utf-8 -*- db.define_table('melodigram_play', Field('melodigram_id', 'reference melodigram'),

[web2py] Re: Autodelete, uploadseparate: implementing in production.

2014-02-14 Thread Encompass solutions
uploaded files yourself. autodete will not delete existing files until the records that point to them are deleted. On Monday, 10 February 2014 22:14:56 UTC-6, Encompass solutions wrote: I want to add autodelete and uploadseparate in production but I have some worries. I doubt the files are moved

[web2py] Re: Problems with the server stalling out. Setting up debuging.

2014-02-02 Thread Encompass solutions
is incomplete) [Sun Feb 02 17:44:39 2014] [error] [client 83.145.241.129] HTTP: 400 BAD REQUEST avconv version 0.8.9-4:0.8.9-0ubuntu0.12.04.1, Copyright (c) 2000-2013 the Libav developers built on Nov 9 2013 19:08:00 with gcc 4.6.3 . On Sunday, February 2, 2014 8:14:21 PM UTC+2, Encompass solutions

[web2py] Re: Script timed out before returning headers: wsgihandler.py

2014-02-02 Thread Encompass solutions
Hi there. I am having similar errors, but don't know how to change those settings. Could I get a few more details on how this is done? BR, Jason Brower On Wednesday, November 20, 2013 1:51:14 PM UTC+2, Niphlod wrote: raising the timeout isn't gonna solve the issue that some request are

[web2py] Best practice when making downloads more private.

2013-11-09 Thread Encompass solutions
I need a way to make downloads private/one time for the user. What is the best practice for this? * Should I need a special download script? My guess is yes. * Should I have a special directory and how would I best do that? * Is there a way to create one time downloads without authentication?