[web2py:37932] Problems with CRUD + Auth
Hi all, I followed the tutorial on http://wiki.web2py.com/build_wiki_with_versioning_and_auth_in_3_minutes_and_deploy_on_google_cloudto quickly add a wiki to an existing application I have, but I'm having acess denied messages when trying to create a wiki page. I boiled down to the current user not having permission to alter the wiki tables, but I can't seem to find a way to add that permission. Trying to add it directly to the db with the db administration page doesn't let me to select the correct table name (only auth_* tables are listed). Any ideas? Btw, I want every user in the system to be able to alter the wiki, how I do that? Thanks, Alexandre -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py:37946] Re: Problems with CRUD + Auth
On Mon, Dec 28, 2009 at 13:05, mdipierro wrote: > I cannot find the page you link. Do you refer to this: > http://www.vimeo.com/6782736 > ? > Yes, it's exactly that tutorial but it's written down. Weird, the link is working for me. I didn't followed the tutorial line by line because I already had a default controller so the wiki became just another controller, but otherwise it's almost the same. So, any suggestions why I can't create any pages and how do I let everyone edit pages? Thanks, Alexandre > > On Dec 28, 3:12 am, Alexandre wrote: > > Hi all, > > > > I followed the tutorial onhttp:// > wiki.web2py.com/build_wiki_with_versioning_and_auth_in_3_minut... > > quickly add a wiki to an existing application I have, but I'm having > > acess denied messages when trying to create a wiki page. I boiled down to > > the current user not having permission to alter the wiki tables, but I > can't > > seem to find a way to add that permission. > > Trying to add it directly to the db with the db administration page > doesn't > > let me to select the correct table name (only auth_* tables are listed). > Any > > ideas? > > > > Btw, I want every user in the system to be able to alter the wiki, how I > do > > that? > > > > Thanks, > > Alexandre > > -- > > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py:38272] Total size of uploaded files
Hi, I want to get the number of uploaded files and also the total size of them, how I do that? Can I assume all files are in the uploaded files? Also, I want to display the size of each individual file next to their name, how I do that? Thanks -- Alexandre Rosenfeld Eng Comp 06 - USP São Carlos FoG - http://fog.icmc.usp.br IM Team - AIESEC @SC -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py:38276] Re: Total size of uploaded files
But I didnt want to query the size of the files every time I needed them, isnt there a way I can keep them on the db? Also, how to retrieve the original filename of the uploaded file? Thanks, Alexandre On 03/01/2010, mdipierro wrote: > def filesize(filename): >import os, stat >return os.stat(os.path.join(request.folder,filename)) > [stat.ST_MTIME] > > > On Jan 3, 6:20 pm, Alexandre wrote: >> Hi, >> >> I want to get the number of uploaded files and also the total size of >> them, how I do that? Can I assume all files are in the uploaded files? >> >> Also, I want to display the size of each individual file next to their >> name, how I do that? >> >> Thanks >> >> -- >> Alexandre Rosenfeld >> >> Eng Comp 06 - USP São Carlos >> FoG -http://fog.icmc.usp.br >> IM Team - AIESEC @SC > > -- > > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > -- Alexandre Rosenfeld Eng Comp 06 - USP São Carlos FoG - http://fog.icmc.usp.br IM Team - AIESEC -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py:38390] SQLFORM without tables
Hi, I would like to get SQLFORM without tables, just one field on top of the other, is that possible? It would be nice if instead of a table, we could iterate through the fields in SQLFORM, so that we could represent it anyway we would like. Thanks, Alexandre Rosenfeld Eng Comp 06 - USP São Carlos FoG - http://fog.icmc.usp.br IM Team - AIESEC -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Debug on GAE
Hi, I want to debug my app on Google AppEngine, because some errors are occuring on GAE that do not exist running directly on web2py. But admin is disabled and the traceback I'm getting is not being very useful. Any ideas? Thanks, Alexandre Rosenfeld -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Replacing template engine
Hi, I want to replace web2py's template engine with Jinja 2<http://jinja.pocoo.org/2/>, anyone has some experience doing something similar? I'm trying to assign response._caller with a custom function, but I'm not having much success, is that the right way? Thanks, Alexandre Rosenfeld Eng Comp 06 - USP São Carlos FoG - http://fog.icmc.usp.br IM Team - AIESEC -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Adding a new domain
I put a example vhost file at http://alexandremas.blogspot.com/2010/02/como-configurar-web2py-e-php-no-mesmo.html (the original language is portuguese, but you can use the example) Alexandre Andrade 2010/5/11 Andrew Evans > Hello I am using web2py on my server and would like to set up a new > domain to add to it > > right now it sits at http://serv.cyber-samurai.de > > I am running apache + wsgi I have my additional domain pointed to the > server but I am unsure how to configure web2py how to use it. > > Do I create a new application with that domain? > > suggestions > > Thank You > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Adding a new domain
Please, don't read/use my previous email..., it is for another situation: using php and web2py at same server. Alexandre Andrade. 2010/5/11 Alexandre Andrade > I put a example vhost file at > http://alexandremas.blogspot.com/2010/02/como-configurar-web2py-e-php-no-mesmo.html > > (the original language is portuguese, but you can use the example) > > Alexandre Andrade > > > > 2010/5/11 Andrew Evans > > Hello I am using web2py on my server and would like to set up a new >> domain to add to it >> >> right now it sits at http://serv.cyber-samurai.de >> >> I am running apache + wsgi I have my additional domain pointed to the >> server but I am unsure how to configure web2py how to use it. >> >> Do I create a new application with that domain? >> >> suggestions >> >> Thank You >> > > > > -- > Atenciosamente > > -- > = > Alexandre Andrade > Hipercenter.com > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
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/*.html and so on. -- Atenciosamente -- = Alexandre Andrade Hipercenter.com 2010/5/13 thedangler > 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. If not is there a proper way to build large applications. > > Thank you. >
[web2py] Who use a VCS - Give examples
I have the following problem: I have a app on production, but have to make major changes on them. So I want to use a development environment, and use a VCS (version control system- baazar, cvs, subversion) to syncronize to production. What I want to know is: How others have done it? Syncronize changes between the development and production? and someone uses a VCS and how? -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Sending html emails [bug?]
I have sucess with:
for person in db(db.cme.id==request.args(0)).select():
context = dict(person=person)
messagehtml = response.render('email.html', context)
status = mail.send(to=[person.email],
subject='My Subject',
message=[None,messagehtml])
where 'email.html' is a view.
2010/5/18 Jon Romero
> It seems that I cannot send emails as html (they are displaying as
> text).
>
> mail = Mail()
> mail.settings = ...
> mail.send(to=user.email, subjest=subject, message=(message_text,
> message_html))
>
> Any clues?
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] MySQL failure to connect
the correct driver is not python-mysql, but mysqldb.
2010/5/18 Avik Basu
> Hello,
>
> I am having some trouble connecting to a MySQL server running on my
> local machine (Macbook Pro running Snow Leopard with My SQL 5.1.46).
> I use the following connection string:
>
> db = DAL('mysql://root:passw...@localhost/test', pool_size=10)
>
> and I get the following error:
>
> Traceback (most recent call last):
> File "gluon/restricted.py", line 178, in restricted
> File "/Applications/web2py.app/Contents/Resources/applications/
> FWv7_12/models/db.py", line 9, in
> File "gluon/sql.py", line 3840, in DAL
> RuntimeError: Failure to connect to DB. Tried 5 times
>
> I do have the python-mysql driver properly installed. Also, I am able
> to connect to the database named 'test' both from the shell and using
> a third party MySQL app (Sequel Pro). There are no existing tables in
> the 'test' database to begin with. Any ideas why the connection may be
> failing?
>
> Avik
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
[web2py] Script to generate schema (models) from mysql
Some time ago I talk about to do it.
Finally I have to do it.
It can be improved to a form in appadmin, use the model to another db
(postgresql, etc), and generate the file in /models.
You can see the code below:
--
#!/usr/bin/env python
# -*- coding: utf-8 -*-
#script to generate schemas from dbs
#by Alexandre Andrade alexandrema...@gmail.com
#www.hipercenter.com
#config it here
passwd="mypass"
user="myuser"
host="localhost"
db = 'mydb'
port='3306'
def query(bd,sql):
bd.query(sql)
r = bd.store_result()
rows = r.fetch_row(maxrows=0,how=1)
return rows
def get_tables():
rows = query(bd,'show tables')
tables=[]
for row in rows:
tables.append(row['Tables_in_'+db])
return tables
#tables()
def get_fields(table):
print table
rows = query(bd,'show fields from '+ table)
fields=[]
for row in rows:
#print row
fields.append(row)
return fields
def field_type(field):
if field['Type'][0:7]=='varchar':
tipo = ",'string'"
elif field['Type'][:8]=='longtext':
tipo = ",'text'"
elif field['Type'][:3]=='int':
tipo = ",'integer'"
elif field['Type'][:4]=='date':
tipo = ",'date'"
elif field['Type'][:7]=='tinyint':
tipo = ",'int'"
elif field['Type'][:11]=='mediumtext':
tipo = ",'text'"
elif field['Type'][:4]=='char':
tipo = ",'text'"
else:
print field['Type'][0:10]
return tipo
def primarykey(field):
if field['Extra']=='auto_increment':
pk = True
else:
pk = False
return pk
def define_table(table):
fields = get_fields(table)
result = []
head = 'db = DAL("mysql://'+ user+ ':'+passwd+'@'+host+':'+port+'/'+db+'",
pool_size=10)\r\r'
line = "db.define_table('"+table+"'"
result.append(line)
for field in fields:
if primarykey(field) == True:
pk =field['Field']
#print pk
tipo = field_type(field)
line = "Field('"+field['Field']+"'"+tipo+")"
result.append(line)
line
try:
line = "primarykey=['"+pk+"']"
result.append(line)
except:
pass
out = ',\r'.join(result)
output = head + out + '\r)'
print output
return output
def define_db():
tables = get_tables()
r = []
for table in tables:
r.append(define_table(table))
result = '\r \r'.join(r)
return result
r = define_db()
f = open('db_'+db+'.py', 'w')
f.write(r)
f.close()
---
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
#!/usr/bin/env python
# -*- coding: utf-8 -*-
#script to generate schemas from dbs
#by Alexandre Andrade alexandrema...@gmail.com
#www.hipercenter.com
#place your config here
passwd="mypass"
user="myuser"
host="localhost"
db = 'mydb'
port='3306'
import MySQLdb
bd=MySQLdb.connect(host=host,user=user,passwd=passwd,db = db, use_unicode=True)
def query(bd,sql):
bd.query(sql)
r = bd.store_result()
rows = r.fetch_row(maxrows=0,how=1)
return rows
def get_tables():
rows = query(bd,'show tables')
tables=[]
for row in rows:
tables.append(row['Tables_in_'+db])
return tables
#tables()
def get_fields(table):
print table
rows = query(bd,'show fields from '+ table)
fields=[]
for row in rows:
#print row
fields.append(row)
return fields
def field_type(field):
if field['Type'][0:7]=='varchar':
tipo = ",'string'"
elif field['Type'][:8]=='longtext':
tipo = ",'text'"
elif field['Type'][:3]=='int':
tipo = ",'integer'"
elif field['Type'][:4]=='date':
tipo = ",'date'"
elif field['Type'][:7]=='tinyint':
tipo = ",'int'"
elif field['Type'][:11]=='mediumtext':
tipo = ",'text'"
elif field['Type'][:4]=='char':
tipo = ",'text'&
Re: [web2py] Script to generate schema (models) from mysql
To each new database, need to be adusted ( in a new script):
1 - the database driver (mysqlb is for mysql)
2 - maybe the sql sintax to select table and fields
3 - the treatment of result of select tables and field can need adjustments
4 - the field_type function have to be adjusted.
My first option to do it was postgresql, but I have to do for mysql first
2010/5/21 Jean Guy
> Hi,
>
> Really nice!
>
> I haven't try it, but I have to do the importation of postgresql database
> into a web2py model. I was just wondering if you can pointed the place that
> should be adapt for postgresql, I will change it and return the running
> code for postgresql.
>
> Thanks.
>
> Jonhy
>
> 2010/5/20 Alexandre Andrade
>
> Some time ago I talk about to do it.
>>
>> Finally I have to do it.
>>
>> It can be improved to a form in appadmin, use the model to another db
>> (postgresql, etc), and generate the file in /models.
>>
>> You can see the code below:
>>
>> --
>>
>> #!/usr/bin/env python
>> # -*- coding: utf-8 -*-
>> #script to generate schemas from dbs
>> #by Alexandre Andrade alexandrema...@gmail.com
>> #www.hipercenter.com
>>
>> #config it here
>> passwd="mypass"
>> user="myuser"
>> host="localhost"
>> db = 'mydb'
>> port='3306'
>>
>>
>> def query(bd,sql):
>> bd.query(sql)
>> r = bd.store_result()
>> rows = r.fetch_row(maxrows=0,how=1)
>> return rows
>>
>> def get_tables():
>> rows = query(bd,'show tables')
>> tables=[]
>> for row in rows:
>> tables.append(row['Tables_in_'+db])
>> return tables
>>
>> #tables()
>>
>> def get_fields(table):
>> print table
>> rows = query(bd,'show fields from '+ table)
>> fields=[]
>> for row in rows:
>> #print row
>> fields.append(row)
>> return fields
>>
>> def field_type(field):
>> if field['Type'][0:7]=='varchar':
>> tipo = ",'string'"
>> elif field['Type'][:8]=='longtext':
>> tipo = ",'text'"
>> elif field['Type'][:3]=='int':
>> tipo = ",'integer'"
>> elif field['Type'][:4]=='date':
>> tipo = ",'date'"
>> elif field['Type'][:7]=='tinyint':
>> tipo = ",'int'"
>> elif field['Type'][:11]=='mediumtext':
>> tipo = ",'text'"
>> elif field['Type'][:4]=='char':
>> tipo = ",'text'"
>> else:
>> print field['Type'][0:10]
>> return tipo
>>
>> def primarykey(field):
>> if field['Extra']=='auto_increment':
>> pk = True
>> else:
>> pk = False
>> return pk
>>
>> def define_table(table):
>> fields = get_fields(table)
>> result = []
>> head = 'db = DAL("mysql://'+ user+
>> ':'+passwd+'@'+host+':'+port+'/'+db+'",
>> pool_size=10)\r\r'
>>
>> line = "db.define_table('"+table+"'"
>> result.append(line)
>> for field in fields:
>> if primarykey(field) == True:
>> pk =field['Field']
>> #print pk
>> tipo = field_type(field)
>> line = "Field('"+field['Field']+"'"+tipo+")"
>> result.append(line)
>> line
>> try:
>> line = "primarykey=['"+pk+"']"
>> result.append(line)
>> except:
>> pass
>> out = ',\r'.join(result)
>> output = head + out + '\r)'
>> print output
>> return output
>>
>> def define_db():
>> tables = get_tables()
>> r = []
>> for table in tables:
>> r.append(define_table(table))
>> result = '\r \r'.join(r)
>> return result
>>
>> r = define_db()
>> f = open('db_'+db+'.py', 'w')
>> f.write(r)
>> f.close()
>>
>> ---
>>
>> --
>> Atenciosamente
>>
>> --
>> =
>> Alexandre Andrade
>> Hipercenter.com
>>
>
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] Script to generate schema (models) from mysql
I will need to be adapted.
look my answer to Jonhy email.
2010/5/21 Nicol van der Merwe
> Nice! This is super excellent.
>
> Just a simple question : will this work on SQL Server?
>
>
> On Fri, May 21, 2010 at 1:37 AM, Alexandre Andrade <
> alexandrema...@gmail.com> wrote:
>
>> Some time ago I talk about to do it.
>>
>> Finally I have to do it.
>>
>> It can be improved to a form in appadmin, use the model to another db
>> (postgresql, etc), and generate the file in /models.
>>
>> You can see the code below:
>>
>> --
>>
>> #!/usr/bin/env python
>> # -*- coding: utf-8 -*-
>> #script to generate schemas from dbs
>> #by Alexandre Andrade alexandrema...@gmail.com
>> #www.hipercenter.com
>>
>> #config it here
>> passwd="mypass"
>> user="myuser"
>> host="localhost"
>> db = 'mydb'
>> port='3306'
>>
>>
>> def query(bd,sql):
>> bd.query(sql)
>> r = bd.store_result()
>> rows = r.fetch_row(maxrows=0,how=1)
>> return rows
>>
>> def get_tables():
>> rows = query(bd,'show tables')
>> tables=[]
>> for row in rows:
>> tables.append(row['Tables_in_'+db])
>> return tables
>>
>> #tables()
>>
>> def get_fields(table):
>> print table
>> rows = query(bd,'show fields from '+ table)
>> fields=[]
>> for row in rows:
>> #print row
>> fields.append(row)
>> return fields
>>
>> def field_type(field):
>> if field['Type'][0:7]=='varchar':
>> tipo = ",'string'"
>> elif field['Type'][:8]=='longtext':
>> tipo = ",'text'"
>> elif field['Type'][:3]=='int':
>> tipo = ",'integer'"
>> elif field['Type'][:4]=='date':
>> tipo = ",'date'"
>> elif field['Type'][:7]=='tinyint':
>> tipo = ",'int'"
>> elif field['Type'][:11]=='mediumtext':
>> tipo = ",'text'"
>> elif field['Type'][:4]=='char':
>> tipo = ",'text'"
>> else:
>> print field['Type'][0:10]
>> return tipo
>>
>> def primarykey(field):
>> if field['Extra']=='auto_increment':
>> pk = True
>> else:
>> pk = False
>> return pk
>>
>> def define_table(table):
>> fields = get_fields(table)
>> result = []
>> head = 'db = DAL("mysql://'+ user+
>> ':'+passwd+'@'+host+':'+port+'/'+db+'",
>> pool_size=10)\r\r'
>>
>> line = "db.define_table('"+table+"'"
>> result.append(line)
>> for field in fields:
>> if primarykey(field) == True:
>> pk =field['Field']
>> #print pk
>> tipo = field_type(field)
>> line = "Field('"+field['Field']+"'"+tipo+")"
>> result.append(line)
>> line
>> try:
>> line = "primarykey=['"+pk+"']"
>> result.append(line)
>> except:
>> pass
>> out = ',\r'.join(result)
>> output = head + out + '\r)'
>> print output
>> return output
>>
>> def define_db():
>> tables = get_tables()
>> r = []
>> for table in tables:
>> r.append(define_table(table))
>> result = '\r \r'.join(r)
>> return result
>>
>> r = define_db()
>> f = open('db_'+db+'.py', 'w')
>> f.write(r)
>> f.close()
>>
>> ---
>>
>> --
>> Atenciosamente
>>
>> --
>> =
>> Alexandre Andrade
>> Hipercenter.com
>>
>
>
>
> --
> Old Gregg: Ever drink baileys from a shoe? Wanna go to a club where people
> wee on each other? I'm gonna hurt you. I like you. What do ya think of me?
> Howard:I think your a nice..modern gentleman
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] Script to generate schema (models) from mysql
To each new database, need to be adusted ( in a new script):
1 - the database driver (mysqlb is for mysql)
2 - maybe the sql sintax to select table and fields
3 - the treatment of result of select tables and field can need adjustments
4 - the field_type function have to be adjusted.
My first option to do it was postgresql, but I have to do for mysql first.
Its possible because each database server has sql comands to describe their
structure (databases, tables and fields).
So, its only a matter of study the result of this queries and treat them and
generate the web2py schemas.
My script is like a logical model, to be adapted.
2010/5/21 Jean Guy
> Hi,
>
> Could it be port to all database this way :
> http://blog.gmane.org/gmane.comp.python.sqlobject/month=20100101
>
> SQLObject
>
> ??
>
> Jonhy
>
>
>
> 2010/5/20 Alexandre Andrade
>
> Some time ago I talk about to do it.
>>
>> Finally I have to do it.
>>
>> It can be improved to a form in appadmin, use the model to another db
>> (postgresql, etc), and generate the file in /models.
>>
>> You can see the code below:
>>
>> --
>>
>> #!/usr/bin/env python
>> # -*- coding: utf-8 -*-
>> #script to generate schemas from dbs
>> #by Alexandre Andrade alexandrema...@gmail.com
>> #www.hipercenter.com
>>
>> #config it here
>> passwd="mypass"
>> user="myuser"
>> host="localhost"
>> db = 'mydb'
>> port='3306'
>>
>>
>> def query(bd,sql):
>> bd.query(sql)
>> r = bd.store_result()
>> rows = r.fetch_row(maxrows=0,how=1)
>> return rows
>>
>> def get_tables():
>> rows = query(bd,'show tables')
>> tables=[]
>> for row in rows:
>> tables.append(row['Tables_in_'+db])
>> return tables
>>
>> #tables()
>>
>> def get_fields(table):
>> print table
>> rows = query(bd,'show fields from '+ table)
>> fields=[]
>> for row in rows:
>> #print row
>> fields.append(row)
>> return fields
>>
>> def field_type(field):
>> if field['Type'][0:7]=='varchar':
>> tipo = ",'string'"
>> elif field['Type'][:8]=='longtext':
>> tipo = ",'text'"
>> elif field['Type'][:3]=='int':
>> tipo = ",'integer'"
>> elif field['Type'][:4]=='date':
>> tipo = ",'date'"
>> elif field['Type'][:7]=='tinyint':
>> tipo = ",'int'"
>> elif field['Type'][:11]=='mediumtext':
>> tipo = ",'text'"
>> elif field['Type'][:4]=='char':
>> tipo = ",'text'"
>> else:
>> print field['Type'][0:10]
>> return tipo
>>
>> def primarykey(field):
>> if field['Extra']=='auto_increment':
>> pk = True
>> else:
>> pk = False
>> return pk
>>
>> def define_table(table):
>> fields = get_fields(table)
>> result = []
>> head = 'db = DAL("mysql://'+ user+
>> ':'+passwd+'@'+host+':'+port+'/'+db+'",
>> pool_size=10)\r\r'
>>
>> line = "db.define_table('"+table+"'"
>> result.append(line)
>> for field in fields:
>> if primarykey(field) == True:
>> pk =field['Field']
>> #print pk
>> tipo = field_type(field)
>> line = "Field('"+field['Field']+"'"+tipo+")"
>> result.append(line)
>> line
>> try:
>> line = "primarykey=['"+pk+"']"
>> result.append(line)
>> except:
>> pass
>> out = ',\r'.join(result)
>> output = head + out + '\r)'
>> print output
>> return output
>>
>> def define_db():
>> tables = get_tables()
>> r = []
>> for table in tables:
>> r.append(define_table(table))
>> result = '\r \r'.join(r)
>> return result
>>
>> r = define_db()
>> f = open('db_'+db+'.py', 'w')
>> f.write(r)
>> f.close()
>>
>> ---
>>
>> --
>> Atenciosamente
>>
>> --
>> =
>> Alexandre Andrade
>> Hipercenter.com
>>
>
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] Re: bug2py
Let me know if you advance in something. This project interest me. Alexandre Andrade 2010/5/21 Abhishek Mishra > Hi Massimo, > > I was thinking of porting BugBase (a base bug tracker written in php > as a college project) to web2py to learn and speed up with it. The > original PHP code is here - http://github.com/ideamonk/bugbase with > demo available at http://bugs.madetokill.com > > Its a bit buggy and insecure (assumed not tested or found yet), but I > think a web2py version would solve any lacking security issues by > taking care of many things in the back. > > Couldn't do much today, would love to finish a php-to-web2py port > within short time of a day / two... > Let me know if this project comes of any fruitful use. > Thanks, > > Abhishek > > On May 22, 1:34 am, mdipierro wrote: > > I found thishttp://github.com/ideamonk/Bug2Py > > seems interesting. Anybody has any info? > > > > Massimo > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Script to generate schema (models) from mysql
I can adapt it on demand to any database for just $100.
Obviously it will be returned to community too.
I usualy use only mysql, postresql, sqlite and now mongo (nosql).
This are the only one I will maybe do it sometime for free.
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
2010/5/21 Nicol van der Merwe
> Nice! This is super excellent.
>
> Just a simple question : will this work on SQL Server?
>
>
> On Fri, May 21, 2010 at 1:37 AM, Alexandre Andrade <
> alexandrema...@gmail.com> wrote:
>
>> Some time ago I talk about to do it.
>>
>> Finally I have to do it.
>>
>> It can be improved to a form in appadmin, use the model to another db
>> (postgresql, etc), and generate the file in /models.
>>
>> You can see the code below:
>>
>> --
>>
>> #!/usr/bin/env python
>> # -*- coding: utf-8 -*-
>> #script to generate schemas from dbs
>> #by Alexandre Andrade alexandrema...@gmail.com
>> #www.hipercenter.com
>>
>> #config it here
>> passwd="mypass"
>> user="myuser"
>> host="localhost"
>> db = 'mydb'
>> port='3306'
>>
>>
>> def query(bd,sql):
>> bd.query(sql)
>> r = bd.store_result()
>> rows = r.fetch_row(maxrows=0,how=1)
>> return rows
>>
>> def get_tables():
>> rows = query(bd,'show tables')
>> tables=[]
>> for row in rows:
>> tables.append(row['Tables_in_'+db])
>> return tables
>>
>> #tables()
>>
>> def get_fields(table):
>> print table
>> rows = query(bd,'show fields from '+ table)
>> fields=[]
>> for row in rows:
>> #print row
>> fields.append(row)
>> return fields
>>
>> def field_type(field):
>> if field['Type'][0:7]=='varchar':
>> tipo = ",'string'"
>> elif field['Type'][:8]=='longtext':
>> tipo = ",'text'"
>> elif field['Type'][:3]=='int':
>> tipo = ",'integer'"
>> elif field['Type'][:4]=='date':
>> tipo = ",'date'"
>> elif field['Type'][:7]=='tinyint':
>> tipo = ",'int'"
>> elif field['Type'][:11]=='mediumtext':
>> tipo = ",'text'"
>> elif field['Type'][:4]=='char':
>> tipo = ",'text'"
>> else:
>> print field['Type'][0:10]
>> return tipo
>>
>> def primarykey(field):
>> if field['Extra']=='auto_increment':
>> pk = True
>> else:
>> pk = False
>> return pk
>>
>> def define_table(table):
>> fields = get_fields(table)
>> result = []
>> head = 'db = DAL("mysql://'+ user+
>> ':'+passwd+'@'+host+':'+port+'/'+db+'",
>> pool_size=10)\r\r'
>>
>> line = "db.define_table('"+table+"'"
>> result.append(line)
>> for field in fields:
>> if primarykey(field) == True:
>> pk =field['Field']
>> #print pk
>> tipo = field_type(field)
>> line = "Field('"+field['Field']+"'"+tipo+")"
>> result.append(line)
>> line
>> try:
>> line = "primarykey=['"+pk+"']"
>> result.append(line)
>> except:
>> pass
>> out = ',\r'.join(result)
>> output = head + out + '\r)'
>> print output
>> return output
>>
>> def define_db():
>> tables = get_tables()
>> r = []
>> for table in tables:
>> r.append(define_table(table))
>> result = '\r \r'.join(r)
>> return result
>>
>> r = define_db()
>> f = open('db_'+db+'.py', 'w')
>> f.write(r)
>> f.close()
>>
>> ---
>>
>> --
>> Atenciosamente
>>
>> --
>> =
>> Alexandre Andrade
>> Hipercenter.com
>>
>
>
>
> --
> Old Gregg: Ever drink baileys from a shoe? Wanna go to a club where people
> wee on each other? I'm gonna hurt you. I like you. What do ya think of me?
> Howard:I think your a nice..modern gentleman
>
Re: [web2py] Re: Changes in Development environment
Well, if it don't get problems with new tables/fields (migrating), its is
the solution I was looking for.
I just sugest separate the db connections config out of db.py in models,
creating a file 0db_config.py (or similar), to be preserved.
Usually, the settings of database connection(s) are diferent between local
an production environments, and haven't to be overwritten.
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
2010/5/26 mdipierro
> How about a flag when replacing an app via admin that preserves the
> content of databases/ sessions/ errors/ uploads/ cache/ ?
>
>
> On May 26, 1:08 pm, greenpoise wrote:
> > Hmmm..I see. Tough stuff. I wonder if there is room for improvement in
> > that area for web2py. Something that is transparent between the
> > developer and the production site.
> >
> > Thanks
> >
> > Dan
> >
> > On May 26, 1:28 pm, Yarko Tymciurak
> > wrote:
> >
> > > On May 26, 11:53 am, greenpoise wrote:
> >
> > > > Oh no, I am not developing where the live data resides. But when I
> > > > make changes to my application on my development environment, how do
> I
> > > > transfer/update those changes on my production site?
> >
> > > You have to work out a procedure that works with your production
> > > environment.
> >
> > > Typically, you will want a way to easily "undo" is anything goes
> > > wrong: I use hg on my production site (and include things like the
> > > databases files - i.e. table migrations - in that versioning).
> >
> > > Then, you will want to work out a cut-over procedure: if you make
> > > changes to modules, you will typically need to restart the web2py
> > > server; otherwise, you can push changes to a running site (!).You
> > > will probably want a staging area somewhere - either locally, or on
> > > your production site - where you will have some way to ensure the
> > > correct connection strings, etc. for your production site, before
> > > pushing out to it.
> >
> > > You could run your changes on your production server in a "beta"
> > > server (to make sure the environment doesn't affect anything, and that
> > > you have removed all your debug info, and that the correct connection
> > > string changes are in effect - I like to have mine automatically
> > > change on environment).
> >
> > > Then you need some way to move the files over to the production
> > > server, and finally the production instance. I use rsync, but you
> > > could use a graphical system, something life filezilla.
> >
> > > Basically, you have to work out your deployment procedure, and
> > > recovery paths.
> >
> > > Regards,
> > > - Yarko
> >
> > > > On May 26, 12:36 pm, Thadeus Burgess wrote:
> >
> > > > > You probably don't want to develop on your live data.
> >
> > > > > To be able to migrate data the DAL includes two functions..
> >
> > > > > db.export_to_csv_file(open('/path.csv', 'w'))
> > > > > db.import_from_csv_file(open('/path.csv', 'r'))
> >
> > > > > So you can export your data, and then stick it on the server and
> > > > > re-import it. This also has the advantage that you can use
> something
> > > > > like PostgreSQL on your production machine.
> >
> > > > > --
> > > > > Thadeus
> >
> > > > > On Wed, May 26, 2010 at 9:39 AM, greenpoise <
> danel.sega...@gmail.com> wrote:
> > > > > > I have web2py production and my development environment. How
> would I
> > > > > > go for leaving the data intact in my production? Is there a way?
> What
> > > > > > I did is I packedAll the project and took it to my production but
> I
> > > > > > will keep working on it on my development environment. Is this
> how it
> > > > > > should be done?
> >
> > > > > > Thanks
>
Re: [web2py] Planet web2py
>or, is >there any repository for web2py related application/plugins/slices?) yes. The web2py.com has a place for applications (appliances) http://web2py.com/appliances Just send it to Massimo: mdipie...@cs.depaul.edu 2010/5/26 Mariano Reingart > I'm working with rss2 and feedparser, reached a simple and minimal > web2py based planet. > > See working examples at: > > http://www.web2py.com.ar/planet/ > http://planeta.arpug.com.ar/ > > Uploaded web2py slice at: > > http://web2pyslices.com/main/slices/take_slice/82 > > > > It would be nice to have a real web2py planet (even better with > multiple languages support). > I remember some discussions about that here, but I don't know the current > state. > I can help with the code, hosting, etc. > > Best regards, > > Mariano Reingart > http://www.web2py.com.ar > http://www.sistemasagiles.com.ar > http://reingart.blogspot.com > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] where is : scripts/web2py-wsgi.conf
using the script setup***ubuntu.sh will work fine. 2010/5/27 Jean Guy > Hi dear web2py crew, > > I was trying to deploy web2py in production with apache2 under ubuntu > server. I follow those informations in the web2py book : > http://web2py.com/book/default/section/11/2 > > I got : admin disabled because unable to access password file > > What do I have to do... > > scripts/web2py-wsgi.conf doesn't exist in the web2py build I have 1.7.8.3 > > Do I should give access by .htaccess?? > > In wich folder I should do, if the preceding answer is yes? > > Thanks > > Jonhy > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: parsehtml
see: http://chardet.feedparser.org/ 2010/6/7 mdipierro > Amazing. Very similar. One thing that web2py TAG is missing it the > ability to guess encoding. It fails and.or does mistakes if the source > is not UTF8 encoded. > > On Jun 6, 10:57 pm, Álvaro Justen wrote: > > This project:http://github.com/gabrielfalcao/dominic#readme > > was created by a Brazilian. > > Maybe it can helps with web2py HTMLParser. > > > > -- > > Álvaro Justen - Turicas > > http://blog.justen.eng.br/ > > 21 9898-0141 > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: parsehtml
Try also: http://code.activestate.com/recipes/52257/ 2010/6/7 mdipierro > Amazing. Very similar. One thing that web2py TAG is missing it the > ability to guess encoding. It fails and.or does mistakes if the source > is not UTF8 encoded. > > On Jun 6, 10:57 pm, Álvaro Justen wrote: > > This project:http://github.com/gabrielfalcao/dominic#readme > > was created by a Brazilian. > > Maybe it can helps with web2py HTMLParser. > > > > -- > > Álvaro Justen - Turicas > > http://blog.justen.eng.br/ > > 21 9898-0141 > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] dynamic database schema based on wsdl
Its possible make a script to conect, compare and write the new schema. Its better mantain this schema separated of db.py, in a file db_wsdl.py, to make it easier. 2010/7/2 winti > Hello, > is there a simple way to keep a web2py database table schema > synchronized with a wsdl document consumed with the SOAPpy library ? > > Stefan -- Atenciosamente -- ===== Alexandre Andrade Hipercenter.com
Re: [web2py] Rename a Table
it's not a ideal way, but you can backup your data to a csv file, rename the table, and import the csv. 2010/7/14 yamandu > Well, I´ve got in situation that could not ocurr but situations seem > not to respect some rules. > > I need simply to rename a table. > I can imagine some ways to do that. > > I tried rename in MySql and rename respective .table file but didn´t > worked. > I gives me error with keys. > > Another way I think is create another table with the new name and copy > everything. > I think this is inneficient and might not work because of the ID if I > use DAL. > Use SQL so? And .table file? > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: Rename a Table
well, rename them too 2010/7/14 mdipierro > but references from other tables may be broken. > > On 14 Lug, 16:41, Alexandre Andrade wrote: > > it's not a ideal way, but you can backup your data to a csv file, rename > the > > table, and import the csv. > > > > 2010/7/14 yamandu > > > > > > > > > Well, I´ve got in situation that could not ocurr but situations seem > > > not to respect some rules. > > > > > I need simply to rename a table. > > > I can imagine some ways to do that. > > > > > I tried rename in MySql and rename respective .table file but didn´t > > > worked. > > > I gives me error with keys. > > > > > Another way I think is create another table with the new name and copy > > > everything. > > > I think this is inneficient and might not work because of the ID if I > > > use DAL. > > > Use SQL so? And .table file? > > > > -- > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
[web2py] Example of sending email from database text
In the book is a example of sending email using template system. Someone has a example of using it from a database field, instead of a file on the system (views) ? -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: Example of sending email from database text
thanks. 2010/8/6 mdipierro > Look into the render function in the gluon/template.py it can take a > filename or a file stream or template text. > > On Aug 6, 1:33 pm, Alexandre Andrade wrote: > > In the book is a example of sending email using template system. > > > > Someone has a example of using it from a database field, instead of a > file > > on the system (views) ? > > > > -- > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Sessions
You just have to set a time limit to your session/cookie, like a week, month or year. I'm sure massimo answer how to set a diferent time limit to a cookie before. 2010/8/5 Cody > Hello, > > I just started using web2py this summer to create a website. > > Currently, I am having an issue with sessions. I am trying to store > information in session variables without having the user login, but > whenever the browser closes and reopens all the session variables are > reset. I am only storing strings and integers, and the code works as > long as the browser does not close. > > Is there anyway to prevent this? Also, how long do sessions last, and > how can I change that? -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Sessions
I think that to maintain the state, you can store the session in db, (someone puts a link about it ) If there is a cookie, web2py checks if the session data exists automatically. 2010/8/6 Bruno Rocha > If I understand, he wants to save session values, even the user closes the > browser and returns after. > > if you set e.g one week to the cookie time limit, this will keep the > reference to the session ID, but I dont think this will automaticaly keep > the session values. ( what if the server restarts?) > > To maintain the state, I guess you have to store the values anywhere, even > inside the cookie. Then you have to check if the cookie exists Am I > wrong? > > > > 2010/8/6 Alexandre Andrade > > You just have to set a time limit to your session/cookie, like a week, >> month or year. >> >> I'm sure massimo answer how to set a diferent time limit to a cookie >> before. >> >> >> >> 2010/8/5 Cody >> >>> Hello, >>> >>> >>> I just started using web2py this summer to create a website. >>> >>> Currently, I am having an issue with sessions. I am trying to store >>> information in session variables without having the user login, but >>> whenever the browser closes and reopens all the session variables are >>> reset. I am only storing strings and integers, and the code works as >>> long as the browser does not close. >>> >>> Is there anyway to prevent this? Also, how long do sessions last, and >>> how can I change that? >>> >> >> >> >> -- >> Atenciosamente >> >> -- >> = >> Alexandre Andrade >> Hipercenter.com >> > > > > -- > > http://rochacbruno.com.br > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
[web2py] Help with Paypal Mass Payment, API
Someone has experience with Paypal Mass Payment API? I want a working implementation to web2py and want pay to develop it. -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
[web2py] Job: Paypal Mass Payment API to web2py
I need someone to implement Paypal MassPayment API (SOAP or NVP) into a web2py app. Please respond to alexandrema...@gmail.com -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
[web2py] For who will plugin MongoDB for DAL : Mingo
Maybe it can help adapt Mongo to DAL: The goal of Ming is to allow you to specify the schema for your data in Python code and then develop in confidence, knowing the format of data you get from a query. http://merciless.sourceforge.net/tour.html -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: generate pdf example
on debian/ubuntu: apt-get install python-reportlab 2010/2/5 ceriox > thanks for help!! > > but i need reportlab ? > how can install it? > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from thiis group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Customizing Auth
I customize auth using the reference of page 245 (229 ) of the book, but after the login's of existents users don't work. I tried with a new app, created a user, and works. Its not possible alter it after. How make it work with a existent auth_user table? -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Customizing Auth
ok. thanks 2010/2/8 mdipierro > Please use the example in here: > http://www.web2py.com/examples/default/tools#authentication > > you probably have a too short password length, should be 512. > > On Feb 8, 8:16 am, Alexandre Andrade wrote: > > I customize auth using the reference of page 245 (229 ) of the book, but > > after the login's of existents users don't work. > > > > I tried with a new app, created a user, and works. Its not possible alter > it > > after. > > > > How make it work with a existent auth_user table? > > > > -- > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Customizing Auth
Now, using the other example, get the error:
Traceback (most recent call last):
File "gluon/restricted.py", line 173, in restricted
exec ccode in environment
File "/home/web2py/applications/convenios/controllers/default.py"
<https://hipercenter.com/admin/default/edit/convenios/controllers/default.py>,
line 354, in
File "gluon/globals.py", line 96, in
self._caller = lambda f: f()
File "/home/web2py/applications/convenios/controllers/default.py"
<https://hipercenter.com/admin/default/edit/convenios/controllers/default.py>,
line 321, in user
return dict(form=auth())
File "gluon/tools.py", line 729, in __call__
return self.retrieve_password()
File "gluon/tools.py", line 1621, in retrieve_password
return self.reset_password_deprecated(next,onvalidation,onaccept,log)
File "gluon/tools.py", line 1460, in reset_password_deprecated
d = {passfield: user[passfield].validate(password)[0],
AttributeError: 'str' object has no attribute 'validate'
2010/2/8 mdipierro
> Please use the example in here:
> http://www.web2py.com/examples/default/tools#authentication
>
> you probably have a too short password length, should be 512.
>
> On Feb 8, 8:16 am, Alexandre Andrade wrote:
> > I customize auth using the reference of page 245 (229 ) of the book, but
> > after the login's of existents users don't work.
> >
> > I tried with a new app, created a user, and works. Its not possible alter
> it
> > after.
> >
> > How make it work with a existent auth_user table?
> >
> > --
> > Atenciosamente
> >
> > --
> > =
> > Alexandre Andrade
> > Hipercenter.com
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Customizing Auth
I used the sample code of
http://www.web2py.com/examples/default/tools#authentication:
---
auth=Auth(globals(),db) # authentication/authorization
auth.settings.hmac_key='sha512:e2976f55-309d-40fc-b69d-59fc032a6438'
auth.messages.access_denied = 'Insufficient privileges'
auth.messages.logged_in = 'Logged in'
auth.messages.email_sent = 'Email sent'
auth.messages.unable_to_send_email = 'Unable to send email'
auth.messages.email_verified = 'Email verified'
auth.messages.logged_out = 'Logged out'
auth.messages.registration_successful = 'Registration successful'
auth.messages.invalid_email = 'Invalid email'
auth.messages.invalid_login = 'Invalid login'
auth.messages.invalid_user = 'Invalid user'
auth.messages.mismatched_password = "As senhas não conferem"
#auth.messages.verify_email = 'Click on the link
http://...verify_email/%(key)s
to verify your email'
auth.messages.verify_email_subject = 'Password verify'
auth.messages.username_sent = 'Seu nome de usuário foi enviado para você'
auth.messages.new_password_sent = 'Uma nova senha foi enviada para você'
auth.messages.password_changed = 'Senha Alterada'
auth.messages.retrieve_username = 'Seu nome de usuário é: %(username)s'
auth.messages.retrieve_username_subject = 'Recupear nome de usuário'
auth.messages.retrieve_password = 'Sua Senha: %(password)s'
auth.messages.retrieve_password_subject = 'Recuperar senha'
auth.messages.profile_updated = 'Perfil atualizado'
auth.messages.new_password = 'Nova senha'
auth.messages.old_password = 'Senha atual'
auth.settings.table_user = db.define_table(
auth.settings.table_user_name,
Field('first_name', length=512,default=''),
Field('last_name', length=512,default=''),
Field('email', length=512,default='',
requires = [IS_EMAIL(),
IS_NOT_IN_DB(db,'%s.email'%auth.settings.table_user_name)]),
Field('password', 'password', readable=False,
label='Password', requires=CRYPT()),
Field('registration_key', length=512,
writable=False, readable=False,default=''))
auth.define_tables() # creates all needed tables
and I just get flash (from session.flash) responding: "invalid login" when
trying to login.
When I try to retrieve password, Is when I get:
Traceback (most recent call last):
File "gluon/restricted.py", line 173, in restricted
exec ccode in environment
File "/home/web2py/applications/convenios/controllers/default.py"
<https://hipercenter.com/admin/default/edit/convenios/controllers/default.py>,
line 354, in
File "gluon/globals.py", line 96, in
self._caller = lambda f: f()
File "/home/web2py/applications/convenios/controllers/default.py"
<https://hipercenter.com/admin/default/edit/convenios/controllers/default.py>,
line 321, in user
return dict(form=auth())
File "gluon/tools.py", line 729, in __call__
return self.retrieve_password()
File "gluon/tools.py", line 1621, in retrieve_password
return self.reset_password_deprecated(next,onvalidation,onaccept,log)
File "gluon/tools.py", line 1460, in reset_password_deprecated
d = {passfield: user[passfield].validate(password)[0],
I'm using postgresql 8.3.8 and the field in postgresl is character
varying(512)
When I drops the code above, the auth works perfectly.
2010/2/8 mdipierro
> I am going to need your help here. from tools.py
>
>user = self.db(table_user.email ==
> form.vars.email).select().first()
>
> d = {passfield: user[passfield].validate(password)[0],
> 'registration_key': ''}
>
> according to your error it says user[passfield] is a str. It cannot be
> be. From the code above it is clearly a record. Can you add a print
> statement as see what is going on?
>
> Can you also print your code for custom auth?
>
> Massimo
>
>
> On Feb 8, 12:03 pm, Alexandre Andrade
> wrote:
> > Now, using the other example, get the error:
> >
> > Traceback (most recent call last):
> > File "gluon/restricted.py", line 173, in restricted
> > exec ccode in environment
> > File "/home/web2py/applications/convenios/controllers/default.py"
> > <https://hipercenter.com/admin/default/edit/convenios/controllers/defa..
> .>,
> > line 354, in
> > File "gluon/globals.py", line 96, in
> > self._c
Re: [web2py] Re: PDF manual soon available online in HTML (maybe)
Well, I never discuss about my clients needs. I just understand it and make the specification. 1. Documentation about web2py is poor. Everyone agree. 2. One reason for this is Massimo defines the new versions, and there is no roadmap. New features are added 'ad hoc' 3. Since Massimo decides what will be in new versions and when, only him know about the new functionalities. 4. Since anyone is talking about roadmaps and planned versions, and colaborative developing, documentation depends almost of Massimo 5. So, what him want is what we have. He wants a tool/script to convert latex/wiki and wiki/latex. Talk, talk, talk, is no resolving anything. My sugestion is: 1. Can someone make a budget do develop this tool (wiki in web2py and conversion latex/wiki/latex)? 2. Who agrees to donate (and how much) do pay developing this? To me, open source is not about 'not paid to develop', but once developed, be free to be used. If someone can do it, and enough people agree the value need, we can advance by this way. If none, its time to search another solution. 2010/2/8 mdipierro > I am not sure this is something people should vote on. > Let me resolve some of the issues on my side first. > This should not be stopping anybody from writing howtos, examples and > tutorials. > this is complementary and putting everything together is a secondary > step. > > If people know of a good tool to convert latex to wiki format and vice > versa, I could use that. > > Massimo > > On Feb 8, 6:39 pm, Richard wrote: > > In case you missed it Massimo is considering making the manual > > available online in HTML: > > > > On Feb 9, 3:33 am, mdipierro wrote: > > > > > I am considering posting most of the book on line in HTML. This may be > > > possible with a disclaimer about "do not reproduce in print". The main > > > issue is that the book is in latex and not easy to convert. > > > > http://groups.google.com/group/web2py/browse_thread/thread/ce1c7614ce... > > > > There have been a number of complaints lately about the documentation > > so it is good this is being considered. > > > > Some points to ponder: > > - How would the online manual best be hosted? - the wiki app? A > > djangobook clone? > > - Should the PDF/latex be manually inserted into this app, or is there > > an automatic method? > > - How would online edits be fed back into the official PDF version? > > > > Richard > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] How much memory does web2py need on Unix
I run a web2py with apache2, wsgi and postgresql. I have 384MB, but it usually uses 106-120MB, at minimum. I install php, and mysql, and it goes to 180MB. 2010/2/10 raven > web2py is working very well for me on my MSWINDOWS desktop. > > I am ready to deploy my first application on a virtual private server > running Ubuntu with 64K of guaranteed RAM > > I loaded the web2py source and typed > > python2.5 web2py.py > > and immediatly ran out of memory. > > How much memory do I need to purchase? > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Error in plugin install
I'm trying to install the plugin webfolder ( http://jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.webfolder.w2p) and get this error: Traceback (most recent call last): File "gluon/restricted.py", line 173, in restricted exec ccode in environment File "/home/www-data/web2py/applications/admin/controllers/default.py" <https://127.0.0.1/admin/default/edit/admin/controllers/default.py>, line 1034, in File "gluon/globals.py", line 96, in self._caller = lambda f: f() File "/home/www-data/web2py/applications/admin/controllers/default.py" <https://127.0.0.1/admin/default/edit/admin/controllers/default.py>, line 565, in design request, filename): File "gluon/admin.py", line 314, in plugin_install os.unlink(upfile) TypeError: coercing to Unicode: need string or buffer, file found -- what could be? a bug in plugin, web2py, or a wrong deployment? -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] 2 cents - web2py a little more portable
Web2py is almost portable, but when changing the server two lines have to be manually adapted: auth.messages.verify_email = \ 'Click on the link http://.../user/verify_email/%(key)s to verify your email' auth.messages.reset_password = \ 'Click on the link http://.../user/reset_password/%(key)s to reset your password' Massimo, just change it in db.py to # auth.messages.verify_email = \ # 'Click on the link http://'+ request.env.http_host+URL(r=request,c='default',f='user', args=['verify_email'])+'/%(key)s to verify your email' # auth.settings.reset_password_requires_verification = True # auth.messages.reset_password = \ # 'Click on the link http://'+ request.env.http_host+URL(r=request,c='default',f='user', args=['reset_password'])+'/%(key)s to reset your password' I just don't want this bugging me in new apps. -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Error in plugin install
thanks, but I used the 'brute force' method: changed the .w2p to tgz, unpacked and copy the folders/files to my app. But anyway, I think is a bug of web2py. 2010/2/10 Jonathan Lundell > On Feb 10, 2010, at 4:00 PM, Alexandre Andrade wrote: > > I'm trying to install the plugin webfolder ( > http://jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.webfolder.w2p<http://jaguar.biologie.hu-berlin.de/%7Efkrause/web2py.plugin.webfolder.w2p>) > > > > Try changing gluon/admin.py line 314 to os.unlink(upname) (instead of > upfile). > > Also, Massimo, the docstring says: > > Returns > --- > upname: > name of the file where app is temporarily stored or `None` on > failure > > > ...but in fact it returns False on failure. > > > > > and get this error: > > > Traceback (most recent call last): > > File "gluon/restricted.py", line 173, in restricted > > > exec ccode in environment > File "/home/www-data/web2py/applications/admin/controllers/default.py" > <https://127.0.0.1/admin/default/edit/admin/controllers/default.py>, line > 1034, in > > > File "gluon/globals.py", line 96, in > > > self._caller = lambda f: f() > > > File "/home/www-data/web2py/applications/admin/controllers/default.py" > <https://127.0.0.1/admin/default/edit/admin/controllers/default.py>, line > 565, in design > > > request, filename): > File "gluon/admin.py", line 314, in plugin_install > > > os.unlink(upfile) > TypeError: coercing to Unicode: need string or buffer, file found > > > > -- > > what could be? a bug in plugin, web2py, or a wrong deployment? > -- > Atenciosamente > > -- > = > Alexandre Andrade > Hipercenter.com > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Error in plugin install
maybe it extract to a tmp folder? 2010/2/10 Jonathan Lundell > On Feb 10, 2010, at 5:07 PM, Alexandre Andrade wrote: > > thanks, > > but I used the 'brute force' method: > > changed the .w2p to tgz, unpacked and copy the folders/files to my app. > > But anyway, I think is a bug of web2py. > > > At least one bug. There's still the question of why it got to the unlink in > the first place. > > > > > 2010/2/10 Jonathan Lundell > >> On Feb 10, 2010, at 4:00 PM, Alexandre Andrade wrote: >> >> I'm trying to install the plugin webfolder ( >> http://jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.webfolder.w2p<http://jaguar.biologie.hu-berlin.de/%7Efkrause/web2py.plugin.webfolder.w2p>) >> >> >> >> Try changing gluon/admin.py line 314 to os.unlink(upname) (instead of >> upfile). >> >> Also, Massimo, the docstring says: >> >> Returns >> --- >> upname: >> name of the file where app is temporarily stored or `None` on >> failure >> >> >> ...but in fact it returns False on failure. >> >> >> >> >> and get this error: >> >> >> Traceback (most recent call last): >> >> File "gluon/restricted.py", line 173, in restricted >> >> >> >> exec ccode in environment >> File "/home/www-data/web2py/applications/admin/controllers/default.py" >> <https://127.0.0.1/admin/default/edit/admin/controllers/default.py>, line >> 1034, in >> >> >> >> File "gluon/globals.py", line 96, in >> >> >> >> self._caller = lambda f: f() >> >> >> >> File "/home/www-data/web2py/applications/admin/controllers/default.py" >> <https://127.0.0.1/admin/default/edit/admin/controllers/default.py>, line >> 565, in design >> >> >> >> request, filename): >> File "gluon/admin.py", line 314, in plugin_install >> >> >> >> os.unlink(upfile) >> TypeError: coercing to Unicode: need string or buffer, file found >> >> >> >> -- >> >> what could be? a bug in plugin, web2py, or a wrong deployment? >> -- >> Atenciosamente >> >> > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Default create_user_groups
Massimo, I don't know why you put auth.settings.create_user_groups = True as default. I think is not the most used way of Access Control, because creates so many groups and make it dificult to manage. But if you think it cannot be changed, because backward compatibility (maybe few people really implemented it), at least put #change to False if you don't want to create groups to each user. # auth.settings.create_user_groups = True Because at least for me, is a change in every new app. -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Duplicate session keys / uuids
> > > crossed over (and users seeing other users' accounts when logged in). > > > So those two things don't seem to be directly correlated. We're still > > > trying to diagnose this session bleed issue, rolling back revisions > > > and hoping to see if it was a code issue or an environment leak > > > somehow. > > > > > Thanks! > > > > > On Feb 9, 9:49 pm, mdipierro wrote: > > > > > > This is not normal. > > > > Can you share more details about the setup? The amount of traffic and > > > > the problem you encountered? > > > > > > In web2py all sessions are uuid and the probablility that two uuid > are > > > > the same is null (unless these machine are one clone of the others in > > > > which case I am not sure how the python uuid depends on the time and > > > > ip of the machine. > > > > > > Massimo > > > > > > On Feb 9, 11:30 am, Dmitri Zagidulin wrote: > > > > > > > I've been experiencing some session bleed across accounts (several > > > > > instances of users crossing over into other users' sessions, and > being > > > > > able to see other users' accounts). And while investigating that > (by > > > > > the way, has anybody else run into this?), I've noticed that the > > > > > database in which I keep my sessions has several duplicate session > > > > > keys. > > > > > > > So, my main question is -- is this by design, or is something > wrong? > > > > > When you store sessions in database (using session.connect - to > MySQL > > > > > in this case), are there supposed to be duplicate entries with the > > > > > same uuid/session key? Would it benefit me to put in a unique > > > > > constraint on the unique_key db column? > > > > > > > A little more about my setup: > > > > > web2py version 1.67.2 > > > > > running behind Apache/WSGI, load balanced across 3 servers. (Hence > why > > > > > I'm keeping sessions in a db rather than on disk). > > > > > Sessions being stored in a MySQL db. > > > > > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Bug in webfolder plugin
When I try to delete a folder/file, it creates repeats the last action. (Usually creating a second file/folder) How solves it? -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Default create_user_groups
If is like unix, the name of user group could be more usefull. Unix creates a group www-data to user www-data web2py creates a group user_1, user_2, that makes dificulty to associate with the user, even in a GUI maybe the default group name - role, could be a combination of first_name and last_name, lowercase and without spaces - ' ' 2010/2/10 mdipierro > Yes you have one group for every user but it make it easy to add more > access control structure later. > If you do not have those groups membership becauses a nightmare. Unix > does the same. > > > > On Feb 10, 7:27 pm, Alexandre Andrade > wrote: > > Massimo, > > > > I don't know why you put > > > > auth.settings.create_user_groups = True > > > > as default. > > > > I think is not the most used way of Access Control, because creates so > many > > groups and make it dificult to manage. > > > > But if you think it cannot be changed, because backward compatibility > (maybe > > few people really implemented it), at least put > > > > #change to False if you don't want to create groups to each user. > > # auth.settings.create_user_groups = True > > > > Because at least for me, is a change in every new app. > > > > -- > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Bug in webfolder plugin
I'm developing access management, it is a client's requirement. I will use auth of web2py. Soon its ready, I will post it back. 2010/2/11 selecta > ok should be fixed too, I appreciate your bug reports please tell me > it something else does not work > > eventually I want to build in access management, but this will take > some time since I am not quite sure how to do access management in a > proper way so all plugins/... can use the same access management > system > > > On Feb 11, 2:41 pm, selecta wrote: > > ok should be fixedhttp:// > jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.webfolder.w2p<http://jaguar.biologie.hu-berlin.de/%7Efkrause/web2py.plugin.webfolder.w2p> > > same problem should occur with selecting/deselecting folders, will fix > > that soon > > > > On Feb 11, 1:00 pm, selecta wrote: > > > > > > > > > let me see, I improved it a bit lately, I will check and upload a new > > > version if i found the bug > > > > > On Feb 11, 2:45 am, Alexandre Andrade > > > wrote: > > > > > > When I try to delete a folder/file, it creates repeats the last > action. > > > > (Usually creating a second file/folder) > > > > > > How solves it? > > > > > > -- > > > > Atenciosamente > > > > > > -- > > > > = > > > > Alexandre Andrade > > > > Hipercenter.com > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] auth_user registration, password field: Order is relevant (OR other reason) OR bug?
I'm trying to customize auth for a long time, without sucess.
Massimo said have a bug fixed in trunk, so I'm waiting the new version to
see if it works.
But in your case, I think its not possible CRYPT() nothing... so makes
sense IS_NOT_EMPTY first.
2010/2/11 aure
> Hi everyone,
>
> I have customised my table for authentificaition, as shown by Massimo
> here:
>
> http://groups.google.com/group/web2py/browse_thread/thread/f4ae0f4c5b9336d0/327ff8e49d88fbb3?lnk=gst&q=custom+authentication+form#327ff8e49d88fbb3
>
> If I put CRYPT() before IS_NOT_EMPTY(...) in the list of requirements
> for the field 'password', users can register with an empty password.
> If IS_NOT_EMPTY(...) comes first, everything works fine.
>
> Problematic Code:
>
> Field('password', 'password', readable=False, label=T('Password'),
> requires=[CRYPT(),IS_NOT_EMPTY(error_message=T('enter a value'))]),
>
> Non Problematic Code:
> Field('password', 'password', readable=False, label=T('Password'),
> requires=[IS_NOT_EMPTY(error_message=T('enter a value')),CRYPT()]),
>
> Aurelien
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: How to deploy my first app
To see the tickets, use https protocol. 2010/2/11 Al > Thank you for your input. I am using Windows server so I cannot use > the ubuntu scripts you mentioned. How about my second part of the > question? I understand why web2py is designed in such a "secure" > fashion. I am just trying to find a way around it so that I can deploy > my first app. I theory I should be able to type from any machine > http://myserver/myfirstapp, but it gives me an internal error - Ticket > issues. When I click the ticket link, it gives "Admin is disabled > because insecure channel". I have two instances of web2py running. I > can run http://myserver/example or https://myserver/myfirstapp without > any issues. What's so special about the built-in examples app? Do I > have to cut out some code from my app to get rid of all the admin menu > and authentication for a general users? > > On Feb 10, 11:38 pm, mdipierro wrote: > > It depends. For development if you use the built in web server you > > need to start it twice for http and https. This is in general a > > security measure. You do not want the same process to listen to two > > sockets else if something happens (like a memory leak) you may get > > locked out. > > > > In deployment you should be using apache+mod_wsgi > > > > just download and run this: > http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh > > > > It will setup everything for you behind a single apache server. > > I think this easier than rails actually. > > > > Massimo > > > > On Feb 10, 9:27 am, Al wrote: > > > > > Hi, > > > > > Now that I get my secure channel (using self-signed certificate) > > > working, I can remotely login from another computer to access the > > > admin interface thru https. Todeploythis app for general users for > > > http access, do I have to run another instance of web2py on another > > > port - say port 80? Also how do I make these 2 instances to run as a > > > service in windows 2003 server? Also do I have to change the code so > > > that the general user just get directly to that single app? This whole > > > thing seems a lot more complicated than ruby on rails. I would > > > appreciate if people can explain this in more detail to me or point me > > > to the right documentations. Thanks. > > > > > Cheers > > > Al > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] auth_user registration, password field: Order is relevant (OR other reason) OR bug?
Others parts of web2py code can rely in a non-empty password.
2010/2/11 Jonathan Lundell
> On Feb 11, 2010, at 7:57 AM, Alexandre Andrade wrote:
>
> I'm trying to customize auth for a long time, without sucess.
>
> Massimo said have a bug fixed in trunk, so I'm waiting the new version to
> see if it works.
>
> But in your case, I think its not possible CRYPT() nothing... so makes
> sense IS_NOT_EMPTY first.
>
>
> The hash function is happy to hash an empty string, so if you put
> IS_NOT_EMPTY after CRYPT, it sees the (non-empty) hash.
>
>
>
> 2010/2/11 aure
>
>> Hi everyone,
>>
>> I have customised my table for authentificaition, as shown by Massimo
>> here:
>>
>> http://groups.google.com/group/web2py/browse_thread/thread/f4ae0f4c5b9336d0/327ff8e49d88fbb3?lnk=gst&q=custom+authentication+form#327ff8e49d88fbb3
>>
>> If I put CRYPT() before IS_NOT_EMPTY(...) in the list of requirements
>> for the field 'password', users can register with an empty password.
>> If IS_NOT_EMPTY(...) comes first, everything works fine.
>>
>> Problematic Code:
>>
>> Field('password', 'password', readable=False, label=T('Password'),
>> requires=[CRYPT(),IS_NOT_EMPTY(error_message=T('enter a value'))]),
>>
>> Non Problematic Code:
>> Field('password', 'password', readable=False, label=T('Password'),
>> requires=[IS_NOT_EMPTY(error_message=T('enter a value')),CRYPT()]),
>>
>> Aurelien
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To post to this group, send email to web...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> web2py+unsubscr...@googlegroups.com
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/web2py?hl=en.
>>
>>
>
>
> --
> Atenciosamente
>
> --
> =
> Alexandre Andrade
> Hipercenter.com
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
[web2py] error in appliances
http://www.web2py.com/appliances get the error: Ticket issued: appliances/127.0.0.1.2010-02-11.12-32-19.4017a4e3-ebbe-4441-a9cb-52365eb60b69<http://www.web2py.com/admin/default/ticket/appliances/127.0.0.1.2010-02-11.12-32-19.4017a4e3-ebbe-4441-a9cb-52365eb60b69> -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: How to deploy my first app
I have 2 sugestions for the setup-web2py-ubuntu.sh: remove install emacs (what emacs have to do with web2py)? install postgresql-8.4 instead obsolete 8.3 2010/2/11 Álvaro Justen [Turicas] > On Wed, Feb 10, 2010 at 13:38, mdipierro wrote: > > It depends. For development if you use the built in web server you > > need to start it twice for http and https. This is in general a > > security measure. You do not want the same process to listen to two > > sockets else if something happens (like a memory leak) you may get > > locked out. > > > > In deployment you should be using apache+mod_wsgi > > > > just download and run this: > > http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh > > This script is included in web2py_src.zip, just see web2py/scripts/ > directory for this and other useful scripts. > I think we need better deploy scripts (like some script to just update > some app on server etc.) and document them. > > > It will setup everything for you behind a single apache server. > > I think this easier than rails actually. > > > > Massimo > > > > > > On Feb 10, 9:27 am, Al wrote: > >> Hi, > >> > >> Now that I get my secure channel (using self-signed certificate) > >> working, I can remotely login from another computer to access the > >> admin interface thru https. To deploy this app for general users for > >> http access, do I have to run another instance of web2py on another > >> port - say port 80? Also how do I make these 2 instances to run as a > >> service in windows 2003 server? Also do I have to change the code so > >> that the general user just get directly to that single app? This whole > >> thing seems a lot more complicated than ruby on rails. I would > >> appreciate if people can explain this in more detail to me or point me > >> to the right documentations. Thanks. > >> > >> Cheers > >> Al > > > > -- > > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > > To post to this group, send email to web...@googlegroups.com. > > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > > > > > > -- > Álvaro Justen - Turicas > http://blog.justen.eng.br/ > 21 9898-0141 > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Bug in webfolder plugin
thanks, I will look at it and improve. 2010/2/12, selecta : > While waiting for Alexandres access management you can have a look at > my unfinished user admin plugin > I thought I would get around to improve it sooner but it does not seem > like that now. Some of you might take this as a base for writing > something more sophisticated. > Blocking and deleting users does not work, should take 30 min max to > add this functionality! > > Screenshot: > http://jaguar.biologie.hu-berlin.de/~fkrause/screenshot_useradmin.png > Download: > http://jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.useradmin.w2p > > > > On Feb 11, 7:15 pm, mdipierro wrote: >> Please make it into a plugin. >> >> On Feb 11, 9:10 am, Alexandre Andrade >> wrote: >> >> >> >> > I'm developing access management, it is a client's requirement. >> >> > I will use auth of web2py. >> >> > Soon its ready, I will post it back. >> >> > 2010/2/11 selecta >> >> > > ok should be fixed too, I appreciate your bug reports please tell me >> > > it something else does not work >> >> > > eventually I want to build in access management, but this will take >> > > some time since I am not quite sure how to do access management in a >> > > proper way so all plugins/... can use the same access management >> > > system >> >> > > On Feb 11, 2:41 pm, selecta wrote: >> > > > ok should be fixedhttp:// >> > > jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.webfolder.w2p<http://jaguar.biologie.hu-berlin.de/%7Efkrause/web2py.plugin.webfolde...> >> > > > same problem should occur with selecting/deselecting folders, will >> > > > fix >> > > > that soon >> >> > > > On Feb 11, 1:00 pm, selecta wrote: >> >> > > > > let me see, I improved it a bit lately, I will check and upload a >> > > > > new >> > > > > version if i found the bug >> >> > > > > On Feb 11, 2:45 am, Alexandre Andrade >> > > > > wrote: >> >> > > > > > When I try to delete a folder/file, it creates repeats the last >> > > action. >> > > > > > (Usually creating a second file/folder) >> >> > > > > > How solves it? >> >> > > > > > -- >> > > > > > Atenciosamente >> >> > > > > > -- >> > > > > > = >> > > > > > Alexandre Andrade >> > > > > > Hipercenter.com >> >> > > -- >> > > You received this message because you are subscribed to the Google >> > > Groups >> > > "web2py-users" group. >> > > To post to this group, send email to web...@googlegroups.com. >> > > To unsubscribe from this group, send email to >> > > web2py+unsubscr...@googlegroups.com >> > > . >> > > For more options, visit this group at >> > >http://groups.google.com/group/web2py?hl=en. >> >> > -- >> > Atenciosamente >> >> > -- >> > = >> > Alexandre Andrade >> > Hipercenter.com > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] web2py 1.75.1 is Out
If minor fixes, why 1.15.1 and not 1.74.12? Between the fixes, is the one about change/personalize auth tables? 2010/2/12, mdipierro : > Please check it out. Minor fixes. > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: web2py 1.75.1 is Out
In 8/Feb/2010 you wrote about the subject "Customizing Auth"
It is combinations of two things:
1) a bug (just fixed in trunk)
2) the example is missing something (I fixed it). Should be:
auth.settings.table_user = db.define_table('auth_user',
Field('first_name', length=512,default=''),
Field('last_name', length=512,default=''),
Field('email', length=512,default='',
requires = [IS_EMAIL(),IS_NOT_IN_DB(db,'
auth_user.email')]),
Field('password', 'password',
readable=False, label='Password',
requires=CRYPT(auth.settings.hmac_key)),
Field('registration_key', length=512,
writable=False, readable=False,default=''),
Field('reset_password_key', length=512,
writable=False, readable=False, default=''))
Sorry about this and thanks for help in debugging.
Massimo
---
I'm asking about the 1) a bug fixed in trunck
2010/2/13 mdipierro
> If this something you sent me? I do not recall anything on the
> subject.
>
> On Feb 12, 6:52 pm, Alexandre Andrade
> wrote:
> > If minor fixes, why 1.15.1 and not 1.74.12?
> >
> > Between the fixes, is the one about change/personalize auth tables?
> >
> > 2010/2/12, mdipierro :
> >
> > > Please check it out. Minor fixes.
> >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "web2py-users" group.
> > > To post to this group, send email to web...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > web2py+unsubscr...@googlegroups.com
> .
> > > For more options, visit this group at
> > >http://groups.google.com/group/web2py?hl=en.
> >
> > --
> > Atenciosamente
> >
> > --
> > =
> > Alexandre Andrade
> > Hipercenter.com
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Displaying a gantt like chart...
Once a create a graphic class in php to do that. In a graphic, it is easier, because you create the ''all days'' plot, and then, create your planned date over. I think the logic is similar. The gantt class is in http://www.phpclasses.org/browse/package/2737.html In html you have to adjust, because you can't plot 'over', but 'while' A way I think this work is draw 'line' by 'line, as a printer. Think drawing this like a printer: A table, creating each row, a cell for each day. 2010/2/15 Jason Brower > I am making a scheduling application and am getting fairly close. > I have it displaying a charts relative to the size of screen. > The data configured in the controller and built on the screen with only > html and css. > But I have a few issues. > I need to create a date that I can add one day to another over and over > to get the day and date and most of all be able to print it to the > screen. Do I really need to do that all before I get to the view > without importing datetime in both the controller and the view? > > This view will mark across the screen with tick marks representing each > day. > I can get each day, but I can't get the date for each day. > I need this and then be able to mark when ever there is a saturday and > sunday. (As the business will be closed. Any idea how this could be > best done? > Enclosed is the view I am using for it... > I also have encloded my css so you get the idea of how it would look. > > Hope you can help out. > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Example of apache2 configuration where web2py exists along other sites
A way it works is a subdomain: www.hipercenter.com (web2py) php.hipercenter.com(php, obvious) the recipe is in (portuguese, translate with google) : http://alexandremas.blogspot.com/2010/02/como-configurar-web2py-e-php-no-mesmo.html 2010/2/13 Johann Spies > I am becoming desperate about this problem. I could so far not > succeed to get web2py working behind apache where web2py is not root > (e.g. the setup of the ubuntu-setup script). > > Is there somewhere an working example of a setup where web2py is > working with wsgi alongside a php site behind apache2? > > If I do not get this one solved, I will be forced to stop trying to > use web2py in a production environment and look for other (maybe php) > solutions. My preference is to work with python and I have invested a > lot of time trying to learn web2py and get it working. > > Regards > Johann > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Roadmap - or wishlist
I think is a recorrent subject, but would be good have a roadmap or at least a wishlist. It can provide some help to achieve the roadmap, and help with documentation too. -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] apache prefork
Well, I use prefork (non-thread) to allow use php in the same server. Sometimes my apache stop, I'm not sure why, yet. While I used only apache2-mpm-worker (and not php), it don't happens If you will use only web2py, I recomend use apache2-mpm-worker (multi-thread) 2010/2/18 mdipierro > I have been having memory issues with apache+mod_wsgi+web2py on the > new hosting (256MB). I followed somebody instructions online and and I > did: > > apt-get install apache2-mpm-prefork > > Any body has any positive or negative experience with this? > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: apache prefork
really, your script setup-web2py-ubuntu.sh install apache2-mpm-worker. if you want change, just # apt-get install apache2-mpm-worker it will replace apache2-mpm-prefork. 2010/2/18 mdipierro > I am having a problem with apache running out of memory. Not sure if > this is a problem with web2py caching or web2py. Can you provide an > example of how to use ONLY > > apache2-mpm-worker > > Massimo > > On Feb 18, 8:59 am, Alexandre Andrade > wrote: > > Well, > > > > I use prefork (non-thread) to allow use php in the same server. Sometimes > my > > apache stop, I'm not sure why, yet. > > > > While I used only apache2-mpm-worker (and not php), it don't happens > > > > If you will use only web2py, > > > > I recomend use apache2-mpm-worker (multi-thread) > > > > 2010/2/18 mdipierro > > > > > > > > > I have been having memory issues with apache+mod_wsgi+web2py on the > > > new hosting (256MB). I followed somebody instructions online and and I > > > did: > > > > > apt-get install apache2-mpm-prefork > > > > > Any body has any positive or negative experience with this? > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "web2py-users" group. > > > To post to this group, send email to web...@googlegroups.com. > > > To unsubscribe from this group, send email to > > > web2py+unsubscr...@googlegroups.com > > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/web2py?hl=en. > > > > -- > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: apache prefork
from description of apache2-mpm-worker package: The worker MPM provides the default threaded implementation. It is recommended especially for high-traffic sites because it is faster and has a smaller memory footprint than the traditional prefork MPM. 2010/2/18 Alexandre Andrade > really, your script setup-web2py-ubuntu.sh install apache2-mpm-worker. > > if you want change, just > > # apt-get install apache2-mpm-worker > > it will replace apache2-mpm-prefork. > > > > 2010/2/18 mdipierro > >> I am having a problem with apache running out of memory. Not sure if >> >> this is a problem with web2py caching or web2py. Can you provide an >> example of how to use ONLY >> >> apache2-mpm-worker >> >> Massimo >> >> On Feb 18, 8:59 am, Alexandre Andrade >> wrote: >> > Well, >> > >> > I use prefork (non-thread) to allow use php in the same server. >> Sometimes my >> > apache stop, I'm not sure why, yet. >> > >> > While I used only apache2-mpm-worker (and not php), it don't happens >> > >> > If you will use only web2py, >> > >> > I recomend use apache2-mpm-worker (multi-thread) >> > >> > 2010/2/18 mdipierro >> > >> > >> > >> > > I have been having memory issues with apache+mod_wsgi+web2py on the >> > > new hosting (256MB). I followed somebody instructions online and and I >> > > did: >> > >> > > apt-get install apache2-mpm-prefork >> > >> > > Any body has any positive or negative experience with this? >> > >> > > -- >> > > You received this message because you are subscribed to the Google >> Groups >> > > "web2py-users" group. >> > > To post to this group, send email to web...@googlegroups.com. >> > > To unsubscribe from this group, send email to >> > > web2py+unsubscr...@googlegroups.com >> >> > >> > > . >> > > For more options, visit this group at >> > >http://groups.google.com/group/web2py?hl=en. >> > >> > -- >> > Atenciosamente >> > >> > -- >> > = >> > Alexandre Andrade >> > Hipercenter.com >> >> -- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To post to this group, send email to web...@googlegroups.com. >> To unsubscribe from this group, send email to >> web2py+unsubscr...@googlegroups.com >> . >> For more options, visit this group at >> http://groups.google.com/group/web2py?hl=en. >> >> > > > -- > Atenciosamente > > -- > = > Alexandre Andrade > Hipercenter.com > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Re: [web2py:38005] Re: auth.settings.controller
I'm using Version 1.75.4 and not solved (always go to default/user) There is a special place to put auth.settings.controller (models?) 2009/12/29 mdipierro > It is a bug. > > On Dec 28, 11:54 pm, Thadeus Burgess wrote: > > When I set > > > > auth.settings.controller = 'admin' > > > > Shouldn't it then default to that? > > > > When I request an action that requries login, it takes me > tohttp://127/init/default/user/loginwhich is... well wrong. > > > > Looking at the code, the login_url, etc... uses self.url() however the > > setttings.controller references 'default'. So when you are setting > > this in your model its already too late, and you need to set every > > single one of the url's (again). > > > > Is this part of the design or... ? > > > > -Thadeus > > -- > > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: [web2py:38005] Re: auth.settings.controller
Patch: Massimo, It don't work because every time auth initialize, it defines controller as 'default' in line 544 at tools.py self.settings.controller = 'default' I have hacked it to if session and session.auth_controller: self.settings.controller = session.auth_controller else: self.settings.controller = 'default' so it works defining session.auth_controller before defining auth. can you patch it in the trunk? 2010/2/23 Thadeus Burgess > You have to specify all of the urls manually. > > Take a look at gluon/tools.py and see all of the settings you can change. > > -Thadeus > > > > > > On Tue, Feb 23, 2010 at 7:50 PM, Alexandre Andrade > wrote: > > I'm using Version 1.75.4 and not solved (always go to default/user) > > > > There is a special place to put auth.settings.controller (models?) > > > > 2009/12/29 mdipierro > >> > >> It is a bug. > >> > >> On Dec 28, 11:54 pm, Thadeus Burgess wrote: > >> > When I set > >> > > >> > auth.settings.controller = 'admin' > >> > > >> > Shouldn't it then default to that? > >> > > >> > When I request an action that requries login, it takes me > >> > tohttp://127/init/default/user/loginwhich is... well wrong. > >> > > >> > Looking at the code, the login_url, etc... uses self.url() however the > >> > setttings.controller references 'default'. So when you are setting > >> > this in your model its already too late, and you need to set every > >> > single one of the url's (again). > >> > > >> > Is this part of the design or... ? > >> > > >> > -Thadeus > >> > >> -- > >> > >> You received this message because you are subscribed to the Google > Groups > >> "web2py-users" group. > >> To post to this group, send email to web...@googlegroups.com. > >> To unsubscribe from this group, send email to > >> web2py+unsubscr...@googlegroups.com > . > >> For more options, visit this group at > >> http://groups.google.com/group/web2py?hl=en. > >> > >> > > > > > > > > -- > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > > > > -- > > You received this message because you are subscribed to the Google Groups > > "web2py-users" group. > > To post to this group, send email to web...@googlegroups.com. > > To unsubscribe from this group, send email to > > web2py+unsubscr...@googlegroups.com > . > > For more options, visit this group at > > http://groups.google.com/group/web2py?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Plugin system status
ote:
> > >> > > Alternately you could simply create another container class for
> > >> > > plugins to use and pass the preferred DAL instance to it just like
> you
> > >> > > can with auth and crud:
> >
> > >> > > db = DAL('...')
> > >> > > db2 = DAL('...')
> > >> > > auth = Auth(globals(),db)
> > >> > > crud = Crud(globals(),db)
> > >> > > plugins = Plugins(globals(),db2)
> >
> > >> > > This seems more consistent with how things currently work. What
> do
> > >> > > you think?
> >
> > >> > > On Feb 24, 5:40 am, "mr.freeze" wrote:
> > >> > >> Then no auth would mean no plugins. What if an attribute was
> added to
> > >> > >> DAL to let the user specify:
> > >> > >> db = DAL('...')
> > >> > >> db.plugin_db = True
> >
> > >> > >> Then create a global plugin_db object for the plugins to use. All
> > >> > >> plugins could then assume:
> > >> > >> db = plugin_db
> > >> > >> or just use plugin_db directly
> >
> > >> > >> There may be a better way but the point is that it would be
> > >> > >> configurable. Users could dedicate a separate DAL instance for
> their
> > >> > >> plugins so they don't pollute databases containing important
> business
> > >> > >> objects.
> >
> > >> > >> On Feb 23, 11:48 pm, mdipierro wrote:
> >
> > >> > >> > what if plugins were to use auth.db ? they rely on auth anyway.
> Or
> > >> > >> > should we relax that?
> >
> > >> > >> > On Feb 23, 11:32 pm, mdipierro
> wrote:
> >
> > >> > >> > > OK but the I would call that variable db because that is what
> it is
> > >> > >> > > called in welcome/models/db.py
> >
> > >> > >> > > On Feb 23, 11:25 pm, "mr.freeze"
> wrote:
> >
> > >> > >> > > > I think the most important thing is that users can install
> plugins
> > >> > >> > > > without needing to modify the plugin. This would make
> upgrades a real
> > >> > >> > > > problem. I'm sure you've heard this all before but if the
> plugin
> > >> > >> > > > system was initialized in some way by the user with their
> preferred
> > >> > >> > > > instance of a DAL object then all plugins could use this.
> Otherwise
> > >> > >> > > > naming your DAL object anything other than db mean you
> can't use
> > >> > >> > > > plugins. What do you think?
> >
> > >> > >> > > > On Feb 23, 11:18 pm, mdipierro
> wrote:
> >
> > >> > >> > > > > when I said "yes" I mean current plugins assume it.
> >
> > >> > >> > > > > I agree we need a superstructure to manage conventions.
> Instead of a
> > >> > >> > > > > new global vars, I would prefer that each plugins has its
> own
> > >> > >> > > > > plugin__settings.db and users can customize
> each individual
> > >> > >> > > > > plugin.
> >
> > >> > >> > > > > On Feb 23, 11:12 pm, "mr.freeze"
> wrote:
> >
> > >> > >> > > > > > That still feels wrong to me. What about making a
> plugin_db parameter
> > >> > >> > > > > > in option_std.py for the database instance name you
> want to use for
> > >> > >> > > > > > the plugin subsystem?
> >
> > >> > >> > > > > > On Feb 23, 10:29 pm, mdipierro <
> mdipie...@cs.depaul.edu> wrote:
> >
> > >> > >> > > > > > > yes
> >
> > >> > >> > > > > > > On Feb 23, 10:18 pm, "mr.freeze" <
> nat...@freezable.com> wrote:
> >
> > >> > >> > > > > > > > What about the second question? Is 'db' a required
> naming convention
> > >> > >> > > > > > > > for the plugin system?
> >
> > >>
Re: [web2py] auth.settings.registration_requires_approval
I have adapted a plugin. I will post it soon. 2010/2/25, baloan : > When setting > > auth.settings.registration_requires_approval = True > > new user registration seem to keep sitting in pending state. The admin > needs a user interface to approve or reject new registrations. > > Is there any preconfigured approval pages/process built into web2py or > do I have to implement one by myself? Any template code out there? > > Regards, Andreas > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Plugin useradmin (membership manager)
I corrected some functions in the plugin posted before (is no more ajax, but works). to make it work, unzip in your app folder. -- Atenciosamente -- = Alexandre Andrade Hipercenter.com -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Re: Using the Template System to Generate Emails
the trick is that
message is first text, then html
mail.send(to=[recipient],subject='Controleer uw adresgegevens in
Fitwise',message=message)
will result in a text message.
to render as html, is :
mail.send(to=[recipient],subject='Controleer uw adresgegevens in
Fitwise',message=[None,message])
2010/3/19 DenesL
> Annet,
> maybe this will help
> http://groups.google.com/g/4247fb7b/t/4b6d3b0c8a822c83/d/7964e5b019d1c3d9
>
>
> On Mar 19, 12:49 pm, annet wrote:
> > In my application all functions related to sending mail from it work.
> > The main function reads like:
> >
> > def send_mail():
> >
> > nfas=db(db.nfa.nfatype==4).select(db.nfa.ALL,orderby=db.nfa.bedrijf)
> > for nfa in nfas:
> > context=dict(nfa=nfa)
> > message=response.render('clublocatormail/
> > send_mail.html',context)
> > recipient=nfa.adres
> > mail.send(to=[recipient],subject='Controleer uw adresgegevens
> > in Fitwise',message=message)
> > return True
> >
> > The send_mail.html view reads like (I removed the irrelevant parts):
> >
> >
> >
> >
> >Template - Single Column
> >
> >
> > body {
> > background-color: #ee;
> > }
> >
> >
> > > class="bg1">
> >
> >
> > > class="bg2">
> >
> >
> > {{if not request.function=='browser_version':}}
> > Having trouble viewing this email?
> > {{=A('View it in your browser',
> >
> _href="{{=URL(r=request,a='mock_crm',c='clublocatormail',f='browser_version',args=[nfa.bedrijf])")}}. > h1>
> > {{pass}}
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >> cellpadding="0">
> >
> >
> >
> > > src="{{=URL(r=request,c='static',f='template/hr.gif')}}" alt="Header"
> > width="560" height="3" />
> >{{=nfa.bedrijf}}
> >{{=nfa.adres}} > p>
> >
> >
> >
> >
> >
> >
> >
> > > height="61">
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I based this code on this article:
> http://articles.sitepoint.com/article/code-html-email-newsletters
> > and the templates referred to. I had hoped the view would display
> > without trouble, but it doesn't. In all mail clients and web based
> > apps, it displays as plain text, so the html is not rendered. I have
> > been trying to find out why for two days now, and hope one of you can
> > come to my rescue.
> >
> > Kind regards,
> >
> > Annet.
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
Re: [web2py] Why am I getting this error ?
TypeError: 'NoneType' object is not callable
usually is a object not instancied.
Verify your objects and put "try" around to help to debug or flow your code.
2010/4/12 topher.baron
> Traceback (most recent call last):
> File "gluon/main.py", line 478, in wsgibase
> File "gluon/main.py", line 193, in serve_controller
> File "gluon/compileapp.py", line 435, in run_controller_in
> TypeError: 'NoneType' object is not callable
>
>
>
> I make a jquery ajax call to a url that calls the following function :
>
> def addNewick():
>
>try:
>import applications.tred.modules.newick as newick
>reload(newick)
>node = newick.parse( request.vars.newickString )
>except:
>return 'parseError'
>
>if auth.is_logged_in():
>id=db.userNewick.insert( user_id = auth.user.id, name =
> request.vars.newickName, newick = request.vars.newickString, comments
> = request.vars.newickComment )
>
>else :
>id = ''.join( [ 's', str(len(session.trees)) ] )
>session.trees.append( { 'id': id,
>'name': request.vars.newickName,
>'string': request.vars.newickString,
>'comment':
> request.vars.newickComment } );
>
>return id
>
>
> I've written to a debug file during each part of the function. The
> return line is being executed and somewhere something is going wrong.
> If anyone could help out that would be great.
>
>
> --
> To unsubscribe, reply using "remove me" as the subject.
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] global name 'psycopg2' is not defined
You restart the webserver after installng psycopg2? 2010/8/13 Dave O > I used this script (http://code.google.com/p/web2py/source/browse/ > scripts/setup-web2py-ubuntu.sh<http://code.google.com/p/web2py/source/browse/%0Ascripts/setup-web2py-ubuntu.sh>) > to install web2py on a fresh > linode.com VPS with Lucid. I created my postgres user and database as > outlined in the web2py manual (http://web2py.com/book/default/chapter/ > 11#PostgreSQL <http://web2py.com/book/default/chapter/%0A11#PostgreSQL>). > When I try and connect to the postgres databse I get a > "global name 'psycopg2' is not defined" error. I've done some > searching and maybe it's due to mod_wsgi not being configured to the > python version I am running (2.6.5) but when I use "ldd mod_wsgi.so" I > get this output: > > linux-gate.so.1 => (0xf57fe000) > libpython2.6.so.1.0 => /usr/lib/libpython2.6.so.1.0 (0xb75ee000) > libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb75d5000) > libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb75d1000) > libutil.so.1 => /lib/tls/i686/cmov/libutil.so.1 (0xb75cc000) > libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb75a6000) > libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb744c000) > libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0xb7406000) > libcrypto.so.0.9.8 => /lib/i686/cmov/libcrypto.so.0.9.8 (0xb72b4000) > libz.so.1 => /lib/libz.so.1 (0xb729e000) > /lib/ld-linux.so.2 (0xb7869000) > > Is that what it should be? I've tried extensive Google searches but am > stumped at this point. importing psycopg2 from the python interpreter > works. > > Thanks for any suggestions, > Dave -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Bug in URL(..,..,vars={})
I really don't know how it works with json, but the sintaxe for URL haven't
'vars' but args=['a','b','etc']
2010/8/19 Phyo Arkar
> Trunk version Rev 853
>
> in view:
> $("#list").jqGrid({
>
> url:"{{=URL(r=request,f='listMIME.json',vars={'extracted_path':extracted_path,'source_path':source_path})}}",
>
> HTML Result:
> $("#list").jqGrid({
> url:"/sExtract/extraction/listMIME.json?source_path=home*&*
> ;extracted_path=target",
>
> it insert &instead of &
>
> that screwed up all my sites :D ..
>
> have not tested with released version ..
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] My editor ...
It's really impressive. So cool. it would be nice if it works in linux and over ssh, but is already so good at this point. +1 to make the application available. 2010/8/19 Stef Mientki > hello, > > I made a movie about the most important features of the editor I'm using, > you can see it here: > > http://mientki.ruhosting.nl/movies/web2py_1.html > > If there's enough interest, I'll make the application available under BSD > license. > At this moment, only under windows all features are available. > > cheers, > Stef > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: My editor ...
>The wysiwyg html editor is a docked Delphi application, so only suited for windows. Since Delphi is Pascal language, maybe it can reworked as a Lazarus project http://www.lazarus.freepascal.org/ 2010/8/19 Stef Mientki > On 19-08-2010 22:24, mdipierro wrote: > > This is impressive. > thanks > > I would like to distribute this with web2py (under > > contrib with its own license) > > What do you think? > I feel honored, > so sounds like a good idea to me. > > What are the prerequisites? > AFAIK (I always use a very full blown Python version, and I'm totally not > aware of which parts I'm > using), > but the most important things are Python 2.6 and wxPython 2.8. > The wysiwyg html editor is a docked Delphi application, so only suited for > windows. > For Mac and Linux this should be replaced by something else, maybe webkit, > but that doesn't run > (easy) under windows > > Do you have binaries for windows and mac? > No, > I can only make binaries for windows and even these are not very suitable > for distro, > because my builder always include the whole full blown python sources. > As I see there's enough interest, here is my global plan > - fix some bugs > - remove the non-standard libs > - make wysiswyg editor only included in windows > - make some basic doc > - make a windows binary + source distro (due to way my builder works, > that's almost the same) > Depending on my spare time, this should take a couple of weeks. > > then I need someone to test it (and probably make some changes) under Linux > and Mac > > then we can distibute it. > I mentioned BSD, because it's the easiest I know, > but any license is good for me, as long as it's free enough. > > cheers, > Stef > > > > > Massimo > > > > > > On Aug 19, 3:12 pm, Stef Mientki wrote: > >> hello, > >> > >> I made a movie about the most important features of the editor I'm > using, you can see it here: > >> > >> http://mientki.ruhosting.nl/movies/web2py_1.html > >> > >> If there's enough interest, I'll make the application available under > BSD license. > >> At this moment, only under windows all features are available. > >> > >> cheers, > >> Stef > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: Should we have a feature freeze and stability maintenance period in future?
t reported by any web2py > > >> installation! mmm too easy... that would be dangerous! ;-) > > > > >> ciao, > > >> mic > > > > >> 2010/8/24 mart : > > > > >> > I don't know if you are currently using a specific bug tracking > > >> > system, but they are typically easy to interface with and made part > of > > >> > build/release & test processes/automation. I.e. As part of a release > > >> > process, I would set rules with the source control system where non- > > >> > bugTraking releated changes can either be automatically rejected, or > > >> > moved to another set of prioritiesArea, etc... the build (or > packaged > > >> > fileset, or whatever the output is) contains a detailed inventory of > > >> > bug fixes/features/etc... as part of an automated delivery system > > >> > (these are part of the build notes)... > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
[web2py] Universal Database Interface - UDI
(this text was translated by google) Hi folks, I'll have to develop an application on my service that uses data from several databases. I'm the one time looking for a way to solve this problem within the web2py and the solution is pictured below. I wonder if anyone has a similar situation and considerations that would have the following possible solution: -- -- -- A Universal Interface for Databases is a webservice that centralizes access to all databases of a company. Although in most cases applications use only one database, on the whole, a company has multiple databases. In many cases they are redundant and have duplicate information in several ways. This means that in practice, developers or duplicate the information have to create ad hoc solutions to integrate systems. This also requires that to generate management information, there is a need to create "data warehouses" to gather all the information and extract reports. The purpose of the UDI is to serve as sole access to all information from all databases of the company. Thus, the developer connects your application to a single point, and calls through the UDI all the information your application needs, as well as forward all information necessary for the UDI provide storage. The functions of the IDU are: 0. Manage the connection and communication with all legacy databases. 1. List all databases, tables and data fields available, with metadata, if any 2. Allow queries that retrieve information from different databases, as if they were one (least of records) 3. Let me set the mapping between the data required by the application with the various databases in a visual interface, even to the programmer. 4. Store information received as a single record distributing it in different fields of databases and tables if needed. 5. Setting a standard database application, which will store the mappings of the data with all other existing databases, and to store the application specific data, not available elsewhere. 6.Possuir a tool for generating reports and dashboards for nontechnical users. In web2py, it would be a standalone application as well as the admin, and would be used in applications as a substitute for DAL, yet remains easy to generate the forms. The big difference, and allows using data from several sources, is that the data (tables and fields) present in other banks would not need to be defined, but only mapped, and both the mapping and the possible creation of tables and fields would be in a graphical interface. -- Atenciosamente -- ===== Alexandre Andrade Hipercenter.com
Re: [web2py] Re: Universal Database Interface - UDI
The case is the databases and tables are not similar.
Sample case:
database1: city_population_data
database2:city_financial_data
database3: city_sports_data
while the 3 databases have SOME common information (cities), the other data
are not common.
so, in my application, I need to get cities data from diferent sources.
What I think to do is create a interface like phpmyadmin, that discover and
show the data from databases.
But, unlike phpmyadmin, is database neutral, so it can be conected to
postgresql and others databases.
>The last 4 operations are performed at the web2py level, not the db
>level so they may use lots memory and IO.
I think to improve performance, it can use temporary tables, kind of a
ad-hoc datawarehouse.
2010/10/2 mdipierro
> say you have two databases
>
> db1=DAL(...)
> db2=DAL(...)
>
> and they contains a similar table
>
> table1=db1.define_table('person',Field('name'))
> table2=db2.define_table('person',table1) # same fields a table1
>
> and you want all records from both
>
> rows=db(table1.id>0).select()&db(table2.id>0).select()
>
> now you can sort them by name
>
> rows=rows.sort(lambda row: row.name)
>
> or you can get all records without duplicates
>
> rows=db(table1.id>0).select()|db(table2.id>0).select()
>
> and filter those that start with 'a'
>
> rows=rows.find(lambda row: row.name.startswith('a'))
>
> etc.
>
> The last 4 operations are performed at the web2py level, not the db
> level so they may use lots memory and IO.
>
>
> Massimo
>
>
>
>
>
> On Oct 2, 3:59 am, Alexandre Andrade wrote:
> > (this text was translated by google)
> >
> > Hi folks,
> >
> > I'll have to develop an application on my service that uses data from
> > several databases.
> >
> > I'm the one time looking for a way to solve this problem within the
> web2py
> > and the solution is pictured below.
> >
> > I wonder if anyone has a similar situation and considerations that would
> > have the following possible solution:
> >
> > --
> > --
> > --
> >
> > A Universal Interface for Databases is a webservice that centralizes
> access
> > to all databases of a company.
> >
> > Although in most cases applications use only one database, on the whole,
> a
> > company has multiple databases.
> >
> > In many cases they are redundant and have duplicate information in
> several
> > ways.
> >
> > This means that in practice, developers or duplicate the information have
> to
> > create ad hoc solutions to integrate systems.
> >
> > This also requires that to generate management information, there is a
> need
> > to create "data warehouses" to gather all the information and extract
> > reports.
> >
> > The purpose of the UDI is to serve as sole access to all information from
> > all databases of the company.
> >
> > Thus, the developer connects your application to a single point, and
> calls
> > through the UDI all the information your application needs, as well as
> > forward all information necessary for the UDI provide storage.
> >
> > The functions of the IDU are:
> >
> > 0. Manage the connection and communication with all legacy databases.
> > 1. List all databases, tables and data fields available, with metadata,
> if
> > any
> > 2. Allow queries that retrieve information from different databases, as
> if
> > they were one (least of records)
> > 3. Let me set the mapping between the data required by the application
> > with the various databases in a visual interface, even to the programmer.
> > 4. Store information received as a single record distributing it in
> > different fields of databases and tables if needed.
> > 5. Setting a standard database application, which will store the
> mappings
> > of the data with all other existing databases, and to store the
> application
> > specific data, not available elsewhere.
> > 6.Possuir a tool for generating reports and dashboards for nontechnical
> > users.
> >
> > In web2py, it would be a standalone application as well as the admin, and
> > would be used in applications as a substitute for DAL, yet remains easy
> to
> > generate the forms.
> >
> > The big difference, and allows using data from several sources, is that
> the
> > data (tables and fields) present in other banks would not need to be
> > defined, but only mapped, and both the mapping and the possible creation
> of
> > tables and fields would be in a graphical interface.
> >
> > --
> > Atenciosamente
> >
> > --
> > =
> > Alexandre Andrade
> > Hipercenter.com
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
Re: [web2py] Re: Universal Database Interface - UDI
Well, I know I have a long way ahead.
2010/10/2 mdipierro
> I do not see an easy solution.
>
> On Oct 2, 9:48 am, Alexandre Andrade wrote:
> > The case is the databases and tables are not similar.
> >
> > Sample case:
> >
> > database1: city_population_data
> > database2:city_financial_data
> > database3: city_sports_data
> >
> > while the 3 databases have SOME common information (cities), the other
> data
> > are not common.
> >
> > so, in my application, I need to get cities data from diferent sources.
> >
> > What I think to do is create a interface like phpmyadmin, that discover
> and
> > show the data from databases.
> > But, unlike phpmyadmin, is database neutral, so it can be conected to
> > postgresql and others databases.
> >
> > >The last 4 operations are performed at the web2py level, not the db
> > >level so they may use lots memory and IO.
> >
> > I think to improve performance, it can use temporary tables, kind of a
> > ad-hoc datawarehouse.
> >
> > 2010/10/2 mdipierro
> >
> >
> >
> > > say you have two databases
> >
> > > db1=DAL(...)
> > > db2=DAL(...)
> >
> > > and they contains a similar table
> >
> > > table1=db1.define_table('person',Field('name'))
> > > table2=db2.define_table('person',table1) # same fields a table1
> >
> > > and you want all records from both
> >
> > > rows=db(table1.id>0).select()&db(table2.id>0).select()
> >
> > > now you can sort them by name
> >
> > > rows=rows.sort(lambda row: row.name)
> >
> > > or you can get all records without duplicates
> >
> > > rows=db(table1.id>0).select()|db(table2.id>0).select()
> >
> > > and filter those that start with 'a'
> >
> > > rows=rows.find(lambda row: row.name.startswith('a'))
> >
> > > etc.
> >
> > > The last 4 operations are performed at the web2py level, not the db
> > > level so they may use lots memory and IO.
> >
> > > Massimo
> >
> > > On Oct 2, 3:59 am, Alexandre Andrade wrote:
> > > > (this text was translated by google)
> >
> > > > Hi folks,
> >
> > > > I'll have to develop an application on my service that uses data from
> > > > several databases.
> >
> > > > I'm the one time looking for a way to solve this problem within the
> > > web2py
> > > > and the solution is pictured below.
> >
> > > > I wonder if anyone has a similar situation and considerations that
> would
> > > > have the following possible solution:
> >
> > > > --
> > > > --
> > > > --
> >
> > > > A Universal Interface for Databases is a webservice that centralizes
> > > access
> > > > to all databases of a company.
> >
> > > > Although in most cases applications use only one database, on the
> whole,
> > > a
> > > > company has multiple databases.
> >
> > > > In many cases they are redundant and have duplicate information in
> > > several
> > > > ways.
> >
> > > > This means that in practice, developers or duplicate the information
> have
> > > to
> > > > create ad hoc solutions to integrate systems.
> >
> > > > This also requires that to generate management information, there is
> a
> > > need
> > > > to create "data warehouses" to gather all the information and extract
> > > > reports.
> >
> > > > The purpose of the UDI is to serve as sole access to all information
> from
> > > > all databases of the company.
> >
> > > > Thus, the developer connects your application to a single point, and
> > > calls
> > > > through the UDI all the information your application needs, as well
> as
> > > > forward all information necessary for the UDI provide storage.
> >
> > > > The functions of the IDU are:
> >
> > > > 0. Manage the connection and communication with all legacy
> databases.
> > > > 1. List all databases, tables and data fields available, with
> metadata,
> > > if
> > > > any
> > > > 2. Allow queries that retrieve information from differen
Re: [web2py] Script to generate schema (models) from mysql
Alvaro, I didn't see this post before. this can be a great feature and I will trye to adapt it to postgresql and mysql, at least. if massimo already don't use it, with sqlite, postresql and mysql, it can worth the value. 2010/6/11 Álvaro Justen > Hello Alexandre, nice work. > I did it in past for SQLite and made it integrated to DAL > I think we can union the implementations and try to get more databases > working with this code. > > The email I sent to Massimo talking about my work (in the end of 2009) > is copied and my code is attached: > > Note: I think we should discuss it in web2py-dev list. > > -- > > Hi Massimo, > Some weeks ago I had an idea: db.discover_tables() - a function that > will search DB and map it into web2py's DAL. > Today a user asked about it in mail list, so I decided to try: and my > first result is good, I think. > > My implementation only have support to SQLite, but we can add all > databases with a little effort - I think you could help me in this > task. > > I modified that simple 'news' app an gluon/sql.py. My modification is > NOT based on SVN, it is based in 1.62 rc1. > To test: modify db.py, uncomment define_table and comment > discover_tables. So, web2py will create tables. Enter in appadmin and > populate them. After that, comment all define_table and uncomment > discover_tables. So, enter in: > > http://localhost:8000/news/appadmin/select/db?query=db.authors.id%3E0 > http://localhost:8000/news/appadmin/select/db?query=db.news.id%3E0 > http://localhost:8000/news/default/test > http://localhost:8000/news/default/create_code > > In gluon/sql.py I added: > - method discover_tables in class SQLDB. > - some code in __init__ in class SQLDB. > - keys 'show_tables' and 'table_fields' in SQL_DIALECTS['sqlite'] -> > please add keys to other databases and test if you could. > > I'm sure that this code can be optimized. > > What do you think? > > -- > Álvaro Justen - Turicas > http://blog.justen.eng.br/ > 21 9898-0141 > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Troubleticketing application?
This is a recorrent issue, and I think we haven't this kind of solution yet. 2010/10/6 Vincent Borghi > Hello, > > Is there a web2py application available somewhere that could be used as a > trouble ticketing (issue tracking) system, or could serve as a basis > to build on > for implementing such a system? > > Thanks > -- Atenciosamente -- ===== Alexandre Andrade Hipercenter.com
[web2py] Managing permissions
The book says about auth_permission: auth_permission links groups and permissions. A permission is identified by a name and, optionally, a table and a record. For example, members of a certain group can have "update" permissions on a specific record of a specific table. But in 1.87.2, Its requires a table to works. its limits the use of permissions, while make easy when it applies to a table. I think it was enforced to make the form easier, but its not cool. What I can expect? Fix to work optionally with tables, or I will have to manage my own solution? Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: Managing permissions
let's explain. The book talks in auth_permission about 'object' as a generic subject of permissions. I think this as controller or a part of application, or group of functions you want to grant permissions. While a user is member of a group, a permission subject/object can granted to several groups. In a app, you can have three groups: admin, managers and users. users can have permissions to create and update functions/controllers admin and managers only can delete and see report functions. admin only can access site management controllers. Permissions can be granted to several groups, It can be used not only to tables, but to sections/controllers/functions: user, datamaintenance, reports, sitemanagement, A workaround is break the groups into smaller scope, mimic permissions, and assign several groups to a user, but its not the best option: user, datamaintenance, reports, sitemanagement, etc. My desire is REMOVE the table-only aspect of permissions, making them optional, like described in the book. The concept is perfect as is. The fact is web2py doesn't work as described in the book. 2010/10/13 mdipierro > Not sure I understand the problem. Can you provide a test case and > what you expect? > > On Oct 13, 5:07 pm, Alexandre Andrade > wrote: > > The book says about auth_permission: > > > > auth_permission links groups and permissions. A permission is identified > by > > a name and, optionally, a table and a record. For example, members of a > > certain group can have "update" permissions on a specific record of a > > specific table. > > > > But in 1.87.2, Its requires a table to works. its limits the use of > > permissions, while make easy when it applies to a table. > > > > I think it was enforced to make the form easier, but its not cool. > > > > What I can expect? Fix to work optionally with tables, or I will have to > > manage my own solution? > > > > Atenciosamente > > > > -- > > = > > Alexandre Andrade > > Hipercenter.com > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
Re: [web2py] Re: Managing permissions
thanks 2010/10/14, mdipierro : > >> My desire is REMOVE the table-only aspect of permissions, making them >> optional, like described in the book. The concept is perfect as is. >> >> The fact is web2py doesn't work as described in the book. > > I understand everything you say but this. You can just say: > > db.auth_permission.table_name.requires = None > > or > > db.auth_permission.table_name.requires = IS_IN_SET(whatever) > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com
[web2py] Upload a file to db and store all metadata to separated db fields
Hi Massimo and Cesar. First of all another one zillion thxz to the
Extremely Amazing Framework ever created !
I have a sittuation that is not the same as Cesar:
http://groups.google.com/group/web2py/browse_thread/thread/c83cd69dee02c9b1/065c44106598d69b?lnk=gst&q=upload+#065c44106598d69b
but somehow it is related..
and I did spent like 6 days trying many things and I could not make it
right... hope you could help me out..
and maybe this solves many others problems...
*In a nut shell, I'm trying to upload the file, store it on the
database (using the two fields upload and blob ),
and save all meta-data and common information to different fields on
the same record *
*By meta-data I refer to file Mime types*
1. MIME-Version
2. Content-ID
3. Content-Type
[ 4. File header signature, extracted from the file first data
block -- not sure one of the 3 fields above provide this incase not ]
*and common infomation*
I mean all user information that could be associated to the file:
5. Full file name ( 'C:\My Documents\pics\agape.jpg' )
6. File Extension ( '.jpg' )
7. File Size ( ' 230 kb ' )
n. ...or any other metadata information available for the file
I could make the upload/ and blob/ work but I'm not having success to
gather and extract this information from the file at the same time I'm
uploading and storing it on the DB..
This is for my Computer Science Bachelor Graduation Work at Unip, São
Paulo University, once i get it more mature I'm going to release it
to the community, as I'm aiming to create an Open Source Project
similar what happened to Instant Press but on a different scope
application some sort of ECM tool.. Even being aware that may not be
wise to store all these and some could be derivative from other
fields, I need to make this work for the proof of concept to develop
other concepts in the project.
So my model is like this
# Model
db.define_table("image",
Field('pic','upload',default=''),
Field('file','upload', default="", autodelete=True,
uploadfield='file_binary_data') ,
Field('file_binary_data', 'blob'),
Field('physical_file_name'), # the full file name.. is it possible
grab the folder from where it was uploaded ?
Field('file_extension'),
Field('file_size'),
Field('MIME_Version'),
Field('Content_ID'),
Field('Content_Type'),
Field('file_header'), #File header footprint extracted from X top
chars from file
)
#Controller
def Upload():
form=SQLFORM(db.image)
if form.accepts(request.vars, session):
file_name = request.vars.pic
try: ext = re.compile('\.\w+
$').findall(file_name.filename.strip())[0]
except IndexError: ext = '.txt'
#pic_filename = 'image.'+'pic.'+str(random.random())[2:] + ext
#pic_filename = 'image.'+'pic.' +
str(uuid.uuid4()).replace('-','') + ext
#pic_filename = pic.filename
file_path = os.path.join(request.folder, 'uploads/',
file_name)
file_handler = open(file_path,'wb')
file_handler.close()
raw_file_size = file_handler.?file_size()
MIME_Version = ?get_MIME()
Content_ID= file_handler.?file_handler()
Content_Type = file_handler.?file_type()
file_header = ?get_Phys_File_Header(file_handler)
image_id = db.image.insert(
pic = file_name.uuid64 ,
file_binary_data = file_name ,
physical_file_name = file_path ,
file_extension = ext ,
file_size = raw_file_size ,
MIME_Version = MIME_Version ,
Content_ID = Content_ID ,
Content_Type = Content_Type ,
file_header = file_header ,
)
response.flash = 'File Uploaded'
return dict(form=form)
###
I tried to update the response.post_var trying to avoid the manual
record insert directly but the change didn't went to db
on the manual insert I added fictitious properties and method trying
to access the properties array directly of
FieldStorage object.. they are marked with questions marks (?) to
indicate where I'm looking for help
Is it possible to do store everything on the same moment file is
uploaded ?
Any help on how to store these columns are welcome ! thanks much
___
Alexandre A. Almeida
Ax3
"Any intelligent fool can make things bigger and more complex... It
takes a touch of genius - and a lot of courage to move in the opposite
direction." -- Albert Einstein
[web2py] Re: flow charts
Hey Mart, If you like visual appealing JavaScript Framework you may also be interested in Raphaël—JavaScript Library What is it? Raphaël is a small JavaScript library that should simplify your work with vector graphics on the web. If you want to create your own specific chart or image crop and rotate widget, for example, you can achieve it simply and easily with this library. Raphaël ['ræfeɪəl] uses the SVG W3C Recommendation and VML as a base for creating graphics. This means every graphical object you create is also a DOM object, so you can attach JavaScript event handlers or modify them later. Raphaël’s goal is to provide an adapter that will make drawing vector art compatible cross-browser and easy. Raphaël currently supports Firefox 3.0+, Safari 3.0+, Chrome 5.0+, Opera 9.5+ and Internet Explorer 6.0+. http://raphaeljs.com/ On Nov 10, 10:14 pm, mart wrote: > Mic, now that's what I'm talking about! That looks awesome! :) > > Thanks for that! > > Mart :) > > On Nov 10, 5:33 pm, Michele Comitini > wrote: > > > Hi mart, > > > Not a flowchart app, a library, but you can make very nice charts if > > you need to show them with web2py: > > >http://morrisonpitt.com/jsPlumb/html/jquery/demo.html > > > mic > > > 2010/11/10 mart : > > > > Hey, > > > > Anybody know of any relatively decent flow chart app out there that > > > would be compatible with web2py? > > > > Thanks, > > > Mart :) > >
[web2py:25470] Re: Feature IDEA: Auto Deploy Web2py Apps
If I understand your idea: 1. besides you can generate a .w2p package and upload using a browser (what web2py already do) you want a option to deploy it putting it in the server and web2py 'magically' install it? Maybe it can be interesting for big aplications, that don't fit so well to upload in browser. 2009/7/1 Jason Brower > > I like the feature in tomcat, it's the only feature I like, that let's > you take a complressed directory, WAR file, put it in a certain > directory and after restarting tomcat it unpacks it and has it ready to > do. > I wonder if we could create something like this, as I have to login to a > computer with ssh, run a text based browser and then install the program > that way. Not fun. I would rather code here, then deploy it with ftp to > a directory on the server and restart the server. > Regards, > Jason Brower > > > > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:25848] Re: new chapters for the book CRUD and AUTH
I think I good information to put in 'auth' section, besides the "Renaming
Auth tables" is how translate auth tables fields:
db.auth_user.first_name.label=T("First Name")
etc.
etc.
I take some time to figure how get it.
IDEA: I sugest, to make web2py more friendly to l10n, the labels was default
as above, so we need only to translate xx-xx.py language file
2009/7/6 mdipierro
>
> Let me add that only one chapter needs to be added the book (about web
> services) and two chapters need minor revisions. Aside for that all
> new features are stable and described in the book. If I get some help
> with proofreading and screenshots I can have a web2py book 2nd edition
> in by the end of July, mid August at most.
>
> Then nobody can say the docs do not keep pace with development.
>
> Massimo
>
>
> Massimo Di Pierro wrote:
> > Here are two very very draft chapters for the second edition of the
> > book.
> > Chapter 7 has been amended to include CRUD
> > Chapter 8 has been added and discusses AUTH
> >
> > This is very draft because I just wrote, I did not not update/add
> > screenshots and I did not even read it back. This means it is will of
> > typos.
> > I will appreciate if you could help me proof read it and perhaps try
> > some of the examples.
> >
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---
[web2py:26165] Re: ssh tunnel from windows (putty) client [ security and admin ]
You should save the information of the connection (session) and from the left side (below categories), Connection->SSH->Tunnels: (look at the right side now) Add new forwarded port: Source Port (8000) or the port you use in web2py Destination (localhost:8000) or the port you use in web2py Click add and go back to session (left side) and save session again. Now you can just open the connection, login, password and access http://localhost:8000/admin from your browser. 2009/7/10 Jeffield > > goal: to be able to publicly view the admin interface from a windows > client. > ( my web2py server is running on a linux) > > the instructions in this page are very good. > http://mdp.cti.depaul.edu/AlterEgo/default/show/68 > > However, how can I make an ssh tunnel in windows? ( note: putty is > installed) > > Thanks > Jeff > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:27294] Re: import SQL Schemma Database into model.py
Leandro, I announced some time ago start in a script/aplication in web2py to do that with postgresql. But since them I have so many projects, and could not advanced. I posted a roadmap to do that too. (search for my posts at google groups). What database you use? Mail me in private email to talk about this. 2009/7/23 Leandro - ProfessionalIT > > Hi, > It's possible import a SQL Schemma Database into a model.py ? > > I have a big legacy database(with many tables) and I want generate > the model class from database( If this possbile !). > > Any idea ? > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:27315] Re: import SQL Schemma Database into model.py
Massimo, I think the idea work best is adapt the database to work with web2py. Some time ago I post a kind of workflow to it: 1.Define a connection 2. List all databases* 3. choose a database 4 List all tables of database. 5. choose the *tables* to work 6.list all fields of choosen tables 7 auto-detect field relationships 8 manually define field relationships 9 check for necessary requirements for DAL and suggest solutions; the user choose the most appropriate solution and apply. (for me, solutions are only: create or rename the necessary field, especially id, would be could if DAL could accept declare a existent autoincrement field as id, while this real name is not. A possible solution is Postgresql is create a view redeclaring the name the field = my_id as id. ) 10 DAL, as almost every orm, have a limited subset of fieldtypes, for compatibility for all databases. If a existent database have a non-standard DAL's fieldtype, is necessary define a solution how treat the data. So is necessary define a kind of conversion routine reading and writing for every non-standart fieldtype. The wizard would sugest some options or let the user define their own code. 11. Finally, everything checked, generates the db model, including migrate=False. The above workflow could be a "Complete" solution. I think in a more simple way to implement: 1.the user generate a sql schema with database tool 2. a python script "read" the sql schema, check for necessary requirements for DAL and write a second sql schema(*a)with the necessary "alter"'s to database and web2py db model(*b), including migrate=false. 3. the user aply the second schema (*a) to database and put the model(*b) in web2py. 2009/7/24 mdipierro > > This functionality could be included in the new DAl but there is a > workflow issue perhaps you can help me brainstorm it and resolve it. > > If we do, web2py will have three source of information that may be > conflicting: > 1) the table description from the model > 2) the table description from the metadata > 3) the table description as surrently in DB > > without 3) web2oy assume that 1) overrides 2) and eventually does a > migration. If we have 3 sources of conflicting information how do we > decide which action to take (migrate? how? what is right?). To me the > workflow become nontrivial and may not be obvious what needs to be > done. > > Massimo > > On Jul 24, 2:03 am, Boriel wrote: > > The script I sent several days ago is about that, but at the moment it > only > > accepts mysql databases. > > I'll be working on it the next week. > > > > Regards, > > Boriel > > > > > > > > On Fri, Jul 24, 2009 at 07:51, Hans Donner > wrote: > > > > > I think this would be a perfect tool for a web2py toolkit (seperate > > > from the main web2py). > > > > > On Fri, Jul 24, 2009 at 05:38, Alexandre > > > Andrade wrote: > > > > Leandro, > > > > > > I announced some time ago start in a script/aplication in web2py to > do > > > that > > > > with postgresql. But since them I have so many projects, and could > not > > > > advanced. > > > > > > I posted a roadmap to do that too. (search for my posts at google > > > groups). > > > > > > What database you use? > > > > > > Mail me in private email to talk about this. > > > > > > 2009/7/23 Leandro - ProfessionalIT > > > > > >> Hi, > > > >> It's possible import a SQL Schemma Database into a model.py ? > > > > > >> I have a big legacy database(with many tables) and I want generate > > > >> the model class from database( If this possbile !). > > > > > >> Any idea ? > > > > > > -- > > > > Atenciosamente > > > > > > -- > > > > = > > > > Alexandre Andrade > > > > Hipercenter.com > > > > -- > > Boriel http://www.boriel.com > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:27584] Some sugestions to improvements in translation/localization
Massimo,
I have a few sugestions to improve the localization of app welcome, so it
will be easier to international users:
1.
Set the labels of registration table :
db.auth_user.first_name.label=T("First Name")
db.auth_user.last_name.label=T("Last Name")
db.auth_user.email.label=T("Email")
db.auth_user.password.label=T("Password")
1.
alter views/default/user.html to :
{{extend 'layout.html'}}
{{=request.args(0).replace('_',' ').capitalize()}}
{{=form}}
{{if request.args(0)=='login':}}
{{T('register')}}
{{T('lost
password')}}
{{pass}}
3. Alter the menu in portal/views/layout.html to:
{{if response.menu_auth:}}
{{T(Authentication)}}
{{=MENU(response.menu_auth)}}
{{pass}}
{{if response.menu:}}
{{T(Main Menu)}}
{{=MENU(response.menu)}}
{{pass}}
{{if response.menu_edit:}}
{{T(Edit This App)}}
{{=MENU(response.menu_edit)}}
{{pass}}
1.
I can't find how translate the h2 title of auth pages, so I can't
translate “register”, “login” and “retrieve password “
Look it is generated in code, note in layouts. If someone have some tip, I
will be pleased:
Register
Nome:
Sobrenome:
Email:
Password:
Verificar Senha:
-
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---
[web2py:27616] Re: Some sugestions to improvements in translation/localization
It works.
Thanks, Fran !
2009/7/30 Fran
>
> On Jul 30, 6:43 am, Alexandre Andrade
> wrote:
> > I can't find how translate the h2 title of auth pages, so I can't
> > translate “register”, “login” and “retrieve password “
> > Look it is generated in code, note in layouts.
>
> It is in the view: user.html
>
> However it is not Internationalisable as-is:
> {{=request.args(0).replace('_',' ').capitalize()}}
>
> I think this needs replacing with something like:
>
> {{if request.args(0)=='login':}}
> {{=T('Login')}}
> {{elif request.args(0)=='register':}}
> {{=T('Register')}}
> {{elif request.args(0)=='retrieve_password':}}
> {{=T('Retrieve Password')}}
> {{elif request.args(0)=='profile':}}
> {{=T('Profile')}}
> {{pass}}
>
>
> F
> >
>
--
Atenciosamente
--
=
Alexandre Andrade
Hipercenter.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---
[web2py:27827] Re: Hosting and Future
I offer "Web2py Ready" hosting plans using wsgi: 1. Starter Ssh access (/home/user/ and web2py in /home/user/web2py/) 1 GB disk 1 GB postgresql or mysql database 1 database/user 50 GB network traffic/month Price: $5/month or $50/year 2. Simple Ssh access (/home/user/ and web2py in /home/user/web2py/) 2 GB disk 2 GB postgresql or mysql database 2 database/user 100 GB network traffic/month Price: $8 dollars/month or $80/year 3. Intermediate Ssh access (/home/user/ and web2py in /home/user/web2py/) 5 GB disk 5 GB postgresql or mysql database 10 database/users 400 GB network traffic/month Price: $15 dollars/month or $150/year 4. VPS configured for web2py full ssh root access (debian or ubuntu distro choice) web2py pre-configured, with https access to /admin until 50 domains human staff support 13 gb disk (database included) unlimited databases (limit disk) 500 GB network traffic/month Price: $35/month or $350/year Contact: hipercen...@gmail.com 2009/8/2 mdipierro > > use FastCGI, CGI should really be a last resort. > > > On Aug 2, 10:33 am, Pynthon wrote: > > My host said that FastCGI and CGI are available. > > > > On 2 aug, 13:43, Pynthon wrote: > > > > > I will ask my hoster. Is it also possible to rent some space on > > > someones VPS? > > > > > Thanks > > > > > On 2 aug, 13:30, Fran wrote: > > > > > > On Aug 2, 11:44 am, Pynthon wrote: > > > > > > > Aha, because then I already have a host. It has Python support but > no > > > > > SSH acces. However, is there a tutorial to set W2P on a host > without > > > > > SSH access? > > > > > > Plenty:http://www.web2py.com/AlterEgo > > > > > > What do you have available: > > > > * Ideally WSGI > > > > * if not, FastCGI > > > > * if not, mod_python > > > > * if not, CGI > > > > > > F > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:28210] Re: hipercenter anybody?
I am the owner. The hipercenter site itself is we2py. 2009/8/8 mdipierro > > Who is running this? > > http://www.hipercenter.com/init/hospedagem/python > > Excellent idea! > > Massimo > > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:28253] Re: hipercenter anybody?
thanks for sugestion. I will move it for after my login. 2009/8/8 Yarko Tymciurak > You might want to remove the link to admin, perhaps make it a site on it's > own (perhaps even change the name of the admin app). > > On Sat, Aug 8, 2009 at 8:27 AM, Alexandre Andrade < > alexandrema...@gmail.com> wrote: > >> I am the owner. >> >> The hipercenter site itself is we2py. >> >> 2009/8/8 mdipierro >> >>> >>> Who is running this? >>> >>> http://www.hipercenter.com/init/hospedagem/python >>> >>> Excellent idea! >>> >>> Massimo >>> >>> >>> >> >> >> -- >> Atenciosamente >> >> -- >> = >> Alexandre Andrade >> Hipercenter.com >> >> >> >> > > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:28257] Re: hipercenter anybody?
Massimo, We have a small firm at Belo Horizonte, Minas Gerais, Brazil. Our expertise is setup special server configurations to specific applications and also provide special hosting. A client we can refer is a group member, "Miguel Lopes" < mig.e.lo...@gmail.com>. we provide consulting to him setup http://www.tecnicon.pt/ As you see, if the client prefer, we can provide consulting to setup web2py anywhere, $25/hour. The amount of support time depends of knowledge of client, but we estimate in 4-8 hours, until the client reply all the steps needed to have a environment with updated debian, webmin, Apache, mod_wsgi, web2py, ssl, and mysql or postgresql database. About Hosting and VPS: Datacenter: We are colocated in Dallas, Texas at the Colo4Dallas Facility It' s utilize InterNAP powered bandwidth to 8 of the "Tier 1" backbones of the Internet. http://www.colo4dallas.com/flash_tour.php The operation's center is fully equipped with a 48v dc power plant, and all of our equipment is fed with conditioned dc power. In the unlikely event of complete power failure, back-up power supplies will come on-line. In case of extended power failure, a backup generator is also on standby. All servers also utilize redundant power supplies in event of a failure. The datacenter is cooled and heated 24-hours a day for an optimal environment. Network: The providers we are connected to via Colo4Dallas include InterNAP (aggregation of: Verizon Business, Savvis, AT&T, Sprint, Level (3), NTT/Verio, Global Crossing), Time Warner Telecom, XO Communications, and 2 additional redundant connections to Level (3) All of our connections are kept at a low utilization to allow high bursting and resistence to denial of service (DoS) attacks. The network makes use of InterNAP Flow Control Platform (FCP) intelligent BGP to provide smart routing across the global internet. FCP adaptive networking software provides adaptive management for network infrastructure. The software can monitor, assess, and adjust the network environment in real time to maximize applications availability, while optimizing between cost and performance. The result is a network infrastructure that is self-healing and self-optimizing. It detects and routes around the 20% of network issues such as IP network brownouts and slowdowns that cause the 80% of application issues that impact revenue and productivity Hardware: All of our servers feature Quad Intel Xeon processors with ECC Registered RAM and 300MB/s hot swap SATA II drives with a hardware RAID controller configured for RAID-10 for superior performance and fault tolerance. Our exact hardware configuration changes every 3-8 months to keep current with technology and the market. VPS environment: Debian Stable 32bits (Lenny/5.1) - all upgrades installed. webmin Apache 2.2 mod_wsgi Postgresql or mysql ssl_enabled (autosigned or signed, if the client have one) web2py ready Method of Payment: Only Paypal (http://www.paypal.com) Order Processing: Because of configuration of web2py is made by human staff, we need some time to get it: 1. Apache/Mod_wsgi/Hosting Plans: After payment confirmation, 12-24 hours; 2.VPS configured for web2py After payment confirmation, 24 - 36 hours; The client will be notified by email when it's ready. Setup cost: Only monthly payment. No setup cost. How to order: Send a email to hipercen...@gmail.com with: - Domain: (we offer *subdomain*.hipercenter.com for free) Company Name E-mail * Address * City * State Country Zip/Postal code * Phone Hosting Plan (Starter, Simple, Intermediate or VPS for web2py) We adapt/create a plan for your needs, since our expertise is special hosting environments. Just describe your needs. - We will receive your email, confirm the order and inform about how to make the payment with paypal. After confirmation of payment, in 12-36 hours your domain will be ready to you. Our Human Suport that know web2py, by email or chat (google talk), . = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:28563] Re: logo
A, 2009/8/13 Massimo Di Pierro > Two logos have been proposed for web2py. I love them both and I would > like your opinions. Here they are attached. > > Which one should go on the main web2py page and the book? > > Vote A for the logo with the W and B for the logo with the globe. > > Poll is open for 48 hours starting now. > > Massimo > -- Atenciosamente -- ===== Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:29286] Re: fyi
Well, I think a more correct title would be "number of stable releases cumulative", it make easy to understand. 2009/8/24 mdipierro > > > http://www.reddit.com/r/programming/comments/9dkek/release_early_release_often_ok/ > > > -- Atenciosamente -- ===== Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:29529] Re: New Book Spanish Translations
Well, its a good idea. I can help translate to portuguese, if needed. 2009/8/27 mdipierro > > I am glad you volunteered to do it. We have volunteers for portuguese, > Chinese and german as well. > It would be nice to have somebody in charge of coordinating this > project and keep track of progess independently of the specific > language, and keep all translations in one place. > > Massimo > > On Aug 27, 7:13 am, Alfonso de la Guarda wrote: > > Hi, > > > > After a little mail conversation with Massimo, he agrees allows me > > translate the new book to the spanish. I'll post this mail to avoid > > duplicate work or communications problem, after receive the sources > > i'll estimate the translation time. > > > > Thanks to all (and specially Massimo)!!! > > > > Saludos, > > > > > > Alfonso de la Guarda > > Centro Open Source(COS) > > alfonsodg.blogspot.com > > alfonsodg.wordpress.com > > Agenda:http://tinyurl.com/djmjol > >Telef. 991935157 > > 1024D/B23B24A4 > > 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 > > > -- Atenciosamente -- = Alexandre Andrade Hipercenter.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
