Re: [web2py] Very Soft Pre-Alpha Launch: Pricetack ecommerce service

2011-05-04 Thread Bruno Rocha
VEry good, good luck! are this based on e-store appliance? I would buy this item http://cheekob.pricetack.com/item/25 but paypal button raised an error... -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] On Thu, May 5, 2011 at 2:41 AM, pbreit wrote: > Hey everyone, I am getting close

Re: [web2py] Very Soft Pre-Alpha Launch: Pricetack ecommerce service

2011-05-04 Thread Jason (spot) Brower
Nifty! Good luck! BR, Jason On Thu, May 5, 2011 at 8:41 AM, pbreit wrote: > Hey everyone, I am getting close to releasing the service I've been working > on and wanted to give you all the very first look. 100% Web2py underneath > the hood! > > It's like eBay but the prices go...down. I envision

[web2py] Very Soft Pre-Alpha Launch: Pricetack ecommerce service

2011-05-04 Thread pbreit
Hey everyone, I am getting close to releasing the service I've been working on and wanted to give you all the very first look. 100% Web2py underneath the hood! It's like eBay but the prices go...down. I envision that it will be used to sell new and pre-owned items that you might consider sellin

Re: [web2py] Re: MongoDBAdapter -- in DAL

2011-05-04 Thread joseph simpson
OK, I will find some time in the next few days to look at this.. Thanks for your quick response to the question.. On Wed, May 4, 2011 at 8:02 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Please help me try if > > db=DAL('mongodb://127.0.0.1:5984/db') > db.define_table('mytable'

[web2py] Re: can anyone guess what's wrong with this?

2011-05-04 Thread mart
crap! that's what it was :) changed it to 'sender', and much better! :) thanks for that! db.commit() is because here DAL is being used in script (BTW - running on trunk LATEST, and no issues to report :) ) Mart On May 4, 11:54 pm, Massimo Di Pierro wrote: > I think from is a SQL keyword the

[web2py] Re: can anyone guess what's wrong with this?

2011-05-04 Thread Massimo Di Pierro
I think from is a SQL keyword therefore it cannot be a field name. You do not need db.commit() in models. On May 4, 10:49 pm, mart wrote: > Hi, > > I think I may have been looking at this too long... its giving the > following error, and I can't see why... > (using DAL in script) > > Thanks in ad

[web2py] can anyone guess what's wrong with this?

2011-05-04 Thread mart
Hi, I think I may have been looking at this too long... its giving the following error, and I can't see why... (using DAL in script) Thanks in advance, Mart :) db.define_table('mail', Field('uuid',length=64,default=uuid.uuid4()), Field('recipients','list:string')

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread Massimo Di Pierro
Basically now if you just write a controller and input modules from yourapp/modules/... web2py can works a lot like Flask while preserving all the other functionality that web2py normally provides.

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread pbreit
Fixed in fe58378e989b. Thanks!

[web2py] Re: Binary file in blob

2011-05-04 Thread Massimo Di Pierro
You may be able a SQLCutomField but there are subtleties with escaping blogs that are engine specific. On May 4, 2:28 am, Fredrik wrote: > Hi, > > we're trying to use web2py to upload a binary file to a MySQL > database. After reading some examples we landed on this table > defenition: > > ts_db.

[web2py] Re: Web2py Security some info

2011-05-04 Thread Massimo Di Pierro
for the record, the author found one issues (single quotes in attributes where not being escaped in attributes) he reported it to us and was fixed in 1.80.1. That is what the two red boxes refer to. On May 4, 6:13 pm, ADE wrote: > Here is some info on web2py security a friend of mine pointed out

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread Massimo Di Pierro
This is correct in trunk, else you can impersonate without being logged in yourself. On May 4, 6:16 pm, pbreit wrote: > My bad, I forgot about an edit I made to tools.py. > > If it matters, to get impersonate working, I needed to make this edit: > >         #if not self.is_logged_in() or not > se

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread Massimo Di Pierro
try again, please. ;-) On May 4, 6:27 pm, pbreit wrote: > Here's a problem I ran into. I have sub-classed (proper terminology?) Auth() > in order to customize navbar(). I'll probably re-write it not to sub-class > Auth(). > > auth = MyAuth(globals(),db) > > class MyAuth(Auth): > >     def navbar(

[web2py] Re: py-appscript

2011-05-04 Thread mart
I never cared much for applescript (used it only when I had to), but this looks fun. Just installed it and will give it a try :) great find! thanks, Mart :) On May 4, 4:20 pm, Massimo Di Pierro wrote: > For example you can make a web2py app (of a django app or rails for > what matters) that open

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread Massimo Di Pierro
... and Pierre for the custom import which is a critical piece. On May 4, 4:35 pm, Martín Mulone wrote: > +1 Thank you Massimo and Jonathan (of course all the other collaborators) > > 2011/5/4 Bruno Rocha > > > > > > > > > > > I am testing right now, at this point I have 2 apps running with no >

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread pbreit
Here's a problem I ran into. I have sub-classed (proper terminology?) Auth() in order to customize navbar(). I'll probably re-write it not to sub-class Auth(). auth = MyAuth(globals(),db) class MyAuth(Auth): def navbar(self, prefix='', action=None): request = self.environment.req

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread pbreit
My bad, I forgot about an edit I made to tools.py. If it matters, to get impersonate working, I needed to make this edit: #if not self.is_logged_in() or not self.environment.request.post_vars: if not self.is_logged_in():

[web2py] Web2py Security some info

2011-05-04 Thread ADE
Here is some info on web2py security a friend of mine pointed out to me http://www.pythonsecurity.org/wiki/web2py/ *cheers

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread pbreit
I got this: Traceback (most recent call last): File "/Users/pbreit/web2py/gluon/restricted.py", line 181, in restricted exec ccode in environment File "applications/init/models/0_settings.py", line 2, in from gluon.tools import Mail File "/Users/pbreit/web2py/gluon/custom_import.py"

Re: [web2py] Re: Install sqlite3 driver for web2py

2011-05-04 Thread Vasile Ermicioi
if you install from sources you need also to install sqlite from sources from http://sqlite.org/download.html (http://sqlite.org/sqlite-amalgamation-3070602.zip)

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread DenesL
+1 On May 4, 5:09 pm, Massimo Di Pierro wrote: > Hello everybody > > Jonathan and I have been working on an internal web2py rewrite that while > keeping everything backward compatible will allow you to do this > > modules/mymodule.py > from gluon import * > def f(): return DIV(A(current

Re: [web2py] Re: Install sqlite3 driver for web2py

2011-05-04 Thread David J.
I am having the same issue; I think it is the python installation you can try on yours 'easy_install pysqlite' providing you have setuptools installed I am trying to rebuild my python from SRC. Not on solaris; Redhat. On 5/4/11 5:10 PM, PlanetUnknown wrote: Interesting.. On a plain pytho

Re: [web2py] some new cool stuff in trunk under testing

2011-05-04 Thread Martín Mulone
+1 Thank you Massimo and Jonathan (of course all the other collaborators) 2011/5/4 Bruno Rocha > I am testing right now, at this point I have 2 apps running with no > problems! > > models subfolder, custom importer and current scope are great improvements > to web2py, I am waiting to rely on thi

[web2py] Re: some new cool stuff in trunk under testing

2011-05-04 Thread Gregory Hellings
On May 4, 4:09 pm, Massimo Di Pierro wrote: > Hello everybody > > Jonathan and I have been working on an internal web2py rewrite that while > keeping everything backward compatible will allow you to do this > > modules/mymodule.py > from gluon import * > def f(): return DIV(A(current.r

Re: [web2py] some new cool stuff in trunk under testing

2011-05-04 Thread Anthony
On Wednesday, May 4, 2011 5:29:32 PM UTC-4, rochacbruno wrote: > > @web2py "the framework that evolves every two weeks" > ...without breaking backward compatibility. :-)

Re: [web2py] some new cool stuff in trunk under testing

2011-05-04 Thread Bruno Rocha
I am testing right now, at this point I have 2 apps running with no problems! models subfolder, custom importer and current scope are great improvements to web2py, I am waiting to rely on this for the app I am working now. Thank you Massimo and Jonathan (of course all the other collaborators), @w

Re: [web2py] some new cool stuff in trunk under testing

2011-05-04 Thread Jonathan Lundell
On May 4, 2011, at 2:09 PM, Massimo Di Pierro wrote: > > Also error messages in validators (including default error messages) should > not be by T(...) by default. s/not/now/

[web2py] Re: Install sqlite3 driver for web2py

2011-05-04 Thread PlanetUnknown
Interesting.. On a plain python shell when I do "import sqlite3" I get -> "File "/var/opt/python2.6.2/usr/local/lib/python2.6/sqlite3/ dbapi2.py", line 27, in from _sqlite3 import * ImportError: No module named _sqlite"" Something wrong with the python installation itself ? On May 4, 5:03 p

[web2py] some new cool stuff in trunk under testing

2011-05-04 Thread Massimo Di Pierro
Hello everybody Jonathan and I have been working on an internal web2py rewrite that while keeping everything backward compatible will allow you to do this modules/mymodule.py from gluon import * def f(): return DIV(A(current.request.function,_href=URL())) end default/controll

[web2py] Re: Install sqlite3 driver for web2py

2011-05-04 Thread PlanetUnknown
Now I see that sqlite does come with python-2.6.2. I do see "../usr/local/lib/python2.6/sqlite3" directory inside by python installation. Wonder why web2py doesn't see it. I'm on Solaris 10 On May 4, 4:46 pm, PlanetUnknown wrote: > I'm using python-2.6.2 and the latest stable web2py. > When I st

Re: [web2py] Install sqlite3 driver for web2py

2011-05-04 Thread Vasile Ermicioi
usually sqlite comes with python, you also can install pysqlite http://code.google.com/p/pysqlite/

[web2py] Install sqlite3 driver for web2py

2011-05-04 Thread PlanetUnknown
I'm using python-2.6.2 and the latest stable web2py. When I start web2py, it says : >Created by Massimo Di Pierro, Copyright 2007-2011 >Version 1.95.1 (2011-04-25 15:04:14) >Database drivers available: pymysql >Starting hardcron... Which I think means that it only has the driver for MySQL and not

[web2py] Re: py-appscript

2011-05-04 Thread Massimo Di Pierro
For example you can make a web2py app (of a django app or rails for what matters) that opens your mac documents and display the text them as web pages relatively easily (assuming it works, I have not tried myself). On May 4, 12:56 pm, Chris May wrote: > I love the thought that Web2Py can do this.

[web2py] Re: py-appscript

2011-05-04 Thread Chris May
I love the thought that Web2Py can do this. I find it fascinating that this power / opportunity exists, but I could use someone's perspective on practical uses for this. I have my head a little too far in the sky to harness this functionality. On May 4, 1:25 pm, Massimo Di Pierro wrote: > http://

Re: [web2py] py-appscript

2011-05-04 Thread Ovidio Marinho
more than one hand on the wheel Ovidio Marinho Falcao Neto ovidio...@gmail.com 88269088 Paraiba-Brasil 2011/5/4 Massimo Di Pierro > http://appscript.sourceforge.net/py-appscript/index.html >

[web2py] py-appscript

2011-05-04 Thread Massimo Di Pierro
http://appscript.sourceforge.net/py-appscript/index.html

[web2py] Re: Binary file in blob

2011-05-04 Thread Fredrik
..maybe there is a way to insert the file without using the DAL wrapper from web2py? On 4 Maj, 09:28, Fredrik wrote: > Hi, > > we're trying to use web2py to upload a binary file to a MySQL > database. After reading some examples we landed on this table > defenition: > > ts_db.define_table('firmwa

[web2py] Computed fields from multiple tables

2011-05-04 Thread pbreit
I'm guessing you might want to put this logic in the controller.

[web2py] DAL issue with SQL Server: Connection is busy with results for another hstmt

2011-05-04 Thread Roman Bataev
I have recently upgraded our web2py instance on production to v.1.95.1 from very old version (1.81.5 or something). After a few hours of work it started throwing the following error on every request that does db IO: ('HY000', '[HY000] [Microsoft][ODBC SQL Server Driver]Connection is busy with

[web2py] please sign your bug reports

2011-05-04 Thread Massimo Di Pierro
Please sign your posts on google code when you report an issue or submit a patch. Without your name I do not know who to acknowledge. Massimo

[web2py] Re: CRUD.search sorting order

2011-05-04 Thread villas
I should have also said that I think the fields should be fields and not strings: i.e. fields = [db.auth_user.id, db.auth_user.last_name, ] On May 4, 2:47 pm, niknok wrote: > I'm using v1.94.6 and retrieving ordered search results from crud.search > always produces a list sorted by id > > T

[web2py] Re: Component's non-ascii response.flash does not show well in IE and Firefox

2011-05-04 Thread Iceberg
As expected, that causes a ticket. Because my source code file is already in utf8 encoding, and you can not do a "already-utf8- string".encode('utf8') On May 4, 9:37 pm, Massimo Di Pierro wrote: > can you try replace > > response.flash = 'Erro na inserção' > > with > > response.flash = 'Erro na i

[web2py] Re: CRUD.search sorting order

2011-05-04 Thread villas
Did you try the orderby fields without the .lower() ? I don't think you can do that. On May 4, 2:47 pm, niknok wrote: > I'm using v1.94.6 and retrieving ordered search results from crud.search > always produces a list sorted by id > > Tried various combinations: > >     orderby=db.auth_user.last_

[web2py] Re: Seperating HTML from JavaScript (while preserving templating with {{= }} in JS ) ... BUG

2011-05-04 Thread DenesL
Hi selecta, the DIV is rendered fine in my tests, no need to add any prefix such as '.html' or '.load' for it to work. But having a LOAD in the controller generates an unnecessary ajax call, and having the script action and view just makes web2py work harder instead of letting the web server do i

[web2py] Re: how to set the value of textarea form field on accept, upload without storing files

2011-05-04 Thread Massimo Di Pierro
You can use jquery notation: species_form.element("#no_table_species")[0] = 'foobar' On May 4, 9:47 am, selecta wrote: > YEEEHA > > > species_form.element(_id="no_table_species").components[0] = 'foobar' > > thank you this is what I wanted to, know :D

[web2py] Re: MongoDBAdapter -- in DAL

2011-05-04 Thread Massimo Di Pierro
Please help me try if db=DAL('mongodb://127.0.0.1:5984/db') db.define_table('mytable',...) db.mytable.insert(...) try different field types and let me know which ones fail. works. On May 4, 9:42 am, "David J." wrote: > Ahh; Ok; > > Perhaps I will use MongEngine for now and then come back to DA

[web2py] a chance to vote for web2py

2011-05-04 Thread Massimo Di Pierro
http://list.ly/list/9E-tools-and-services-for-a-lean-startup

[web2py] Re: how to set the value of textarea form field on accept, upload without storing files

2011-05-04 Thread selecta
YEEEHA > species_form.element(_id="no_table_species").components[0] = 'foobar' thank you this is what I wanted to, know :D

Re: [web2py] Re: MongoDBAdapter -- in DAL

2011-05-04 Thread David J.
Ahh; Ok; Perhaps I will use MongEngine for now and then come back to DAL once we have time for it; I think its not worth your time to build in support for something not so many people are using; Besides anyone can use MongoEngine with Web2py without much difficulty; I did some simple tests

[web2py] Re: how to set the value of textarea form field on accept, upload without storing files

2011-05-04 Thread DenesL
For my tests I defined a table, so you are right in that it probably does not work for factory fields. Why can't you use a table? you don't have to save any records if you don't want to. species_form.element(_id="no_table_species") gives you the textarea element but _value is part of the attribut

[web2py] Re: MongoDBAdapter -- in DAL

2011-05-04 Thread Massimo Di Pierro
mongodb with DAL does not currently work but, if you help with tests, we could make it work On May 4, 8:56 am, "David J." wrote: > Is this in trunk; > > I will start a new project today and use Mongo For DB > > I think I tried it last month and I had some problems; I didnt have the > time to loo

Re: [web2py] Re: Help with broken migration

2011-05-04 Thread Richard Vézina
If you manually edit your database frequently you may consider set your table to migrate=false... Do what ever you want as long as you think manually synced your model at db level an web2py level congruent will work... More works for sure, but more control and fine tuning at db level is easier... Y

Re: [web2py] Re: MongoDBAdapter -- in DAL

2011-05-04 Thread David J.
Is this in trunk; I will start a new project today and use Mongo For DB I think I tried it last month and I had some problems; I didnt have the time to look into it. I will update and try again. Thanks. On 5/4/11 9:30 AM, Massimo Di Pierro wrote: fixing it now. Looks like not many people t

[web2py] Re: Component's non-ascii response.flash does not show well in IE and Firefox

2011-05-04 Thread Massimo Di Pierro
can you try replace response.flash = 'Erro na inserção' with response.flash = 'Erro na inserção'.encode('utf8') On May 4, 5:39 am, Iceberg wrote: > Hi there, > > I just noticed that, component's non-ascii response.flash does not > show well in IE7, IE8, Firefox 3.0.19. > > def visit_me(): >  

[web2py] Re: compressed field

2011-05-04 Thread szimszon
Than we just need to have SQLCustomType documented (be stable and backward compatible:) and/or made a crypt db field type basic as string, text... :)

[web2py] Re: compressed field

2011-05-04 Thread Massimo Di Pierro
Good point. Then one can do: # http://eli.thegreenplace.net/2010/06/25/aes-encryption-of-files-in-python-with-pycrypto/ from Crypto.Cipher import AES secret_key = '0123456789abcdef' encryptor = AES.new(secret_key, AES.MODE_CBC) from gluon.dal import SQLCustomType compressed = SQLCustomType(

[web2py] Re: MongoDBAdapter -- in DAL

2011-05-04 Thread Massimo Di Pierro
fixing it now. Looks like not many people testing it. :-) On May 3, 9:56 pm, joseph simpson wrote: > The current dal.py file contains the following code, between lines > 3381 and 3404: > > ADAPTERS = { >     'sqlite': SQLiteAdapter, >     'sqlite:memory': SQLiteAdapter, >     'mysql': MySQLAdapte

[web2py] Seperating HTML from JavaScript (while preserving templating with {{= }} in JS ) ... BUG

2011-05-04 Thread selecta
I always wondered how I could separate my JavaScript from the rest of my HTML It came to me and it worked almost well controllers/default.py def index(): response.files.append(URL(request.application,'default','script.js')) return dict(content = LOAD('default', 'strange', ajax=True)) def scrip

[web2py] Re: routes_out protocol

2011-05-04 Thread LightOfMooN
No, i didn't On 4 май, 02:37, Dan wrote: > Hi, did you find any solution to your problem? > > I have the same problem. The Url function should build a link over ssl > (https) if the url contains the controller "user". e.g. /myapp/user/ > login or /myapp/user/register > > On Apr 12, 4:43 am, Light

[web2py] Re: how to set the value of textarea form field on accept, upload without storing files

2011-05-04 Thread selecta
I tried it but it did not work, also it would be nice if i could do something with the uploaded information first (apply some filter, reformating ...) >   Field('species_file', 'upload', label="Upload Names", > uploadfield='species') > > uploadfield = True # means store file on disk > uploadfield =

Re: [web2py] Skytoop : a web desktop like, created with Web2Py on server side

2011-05-04 Thread Syed Mushtaq
Looks really beautiful :) Are you planning on open-sourcing it ? Thanks -Syed On Wed, May 4, 2011 at 11:37 AM, Jason (spot) Brower wrote: > It would be fun to put a widget for online radio. > quality='high' bgcolor='#ff' width='398' height='104' > name='popupPlayer_V19' align='middle' allow

[web2py] Computed fields from multiple tables

2011-05-04 Thread Happy Rob
Computed fields from multiple columns I'm new to programming and have a question How can I make a computed field that adds up from another table depending on the contents of the first table? eg A multi choice exam has the results entered by formfactory. The answers and their scores are stored in a

[web2py] AppAdmin Notification feature

2011-05-04 Thread blackthorne
I was testing Instantpress app and finding it very good. Congratulations. Wondering if there is any option to show up notifications like in InstantPress for AppAdmin. If now, do you it makes sense? Thank you

[web2py] Component's non-ascii response.flash does not show well in IE and Firefox

2011-05-04 Thread Iceberg
Hi there, I just noticed that, component's non-ascii response.flash does not show well in IE7, IE8, Firefox 3.0.19. def visit_me(): return {'':LOAD('default', 'component.load', ajax=True)} def component(): response.flash = 'Erro na inserção' return {'':'Testing'} But Chrome 11.x is f

[web2py] Re: text field display when writable=False

2011-05-04 Thread szimszon
Hmmm... not exactly good. I had to make a function def replace_to_html( s ): try: return XML( s.replace( '\n', '' ) ) except: return s because s is None it has no replace function... And call: db.some_table.some_text.represent = lambda s: replace_to_html( s )

[web2py] Binary file in blob

2011-05-04 Thread Fredrik
Hi, we're trying to use web2py to upload a binary file to a MySQL database. After reading some examples we landed on this table defenition: ts_db.define_table('firmwares', Field('file', 'upload', uploadfield='file_data'), Field('file_data','blob', default=''), Field('crc',

[web2py] Re: compressed field

2011-05-04 Thread szimszon
But there could be a situation you don't own the database server...

[web2py] Re: text field display when writable=False

2011-05-04 Thread szimszon
Works. Thank you!