[web2py] Re: Is there anyone who running web2py application on Redhat openshift?

2012-05-21 Thread JungHyun Kim
Hello Changju. Frankly speaking, I didn't know either pythonanywhere or fluxflex. So after read your mail, I compared their free tiers roughly. 1. OpenShift : 512MB of RAM, and 1GB of disk space(probably including DB storage) * 3 applications 2. Pythonanywhere : CPU(quota or p

[web2py] signature field's label should be translatable and _archive.current_record too...

2012-05-21 Thread szimszon
Hi All! I think it could be good to have auth.signature. ... .label wrapped with T(). And _archive.current_record too... Thanks! http://code.google.com/p/web2py/issues/detail?id=812 http://code.google.com/p/web2py/issues/detail?id=813

[web2py] Re: Little problem with scheduler_task - has no signature Fields

2012-05-21 Thread szimszon
Wrong project. Sorry. http://code.google.com/p/web2py/issues/detail?id=814 2012. május 21., hétfő 8:40:43 UTC+2 időpontban szimszon a következőt írta: > > Here it is: http://code.google.com/p/osmand/issues/detail?id=1012 > > Thank you! > > 2012. május 20., vasárnap 23:19:33 UTC+2 időpontban Massi

[web2py] MongoDB 'document' or 'dict' filetype

2012-05-21 Thread Francisco Costa
At the moment MongodbAdapter only has these filetypes class MongoDBAdapter(NoSQLAdapter): uploads_in_blob = True types = { 'boolean': bool, 'string': str, 'text': str, 'password': str, 'blob': str,

Re: [web2py] MongoDB table definitions

2012-05-21 Thread Francisco Costa
requested here: https://groups.google.com/d/topic/web2py/pqdYpUbMXKQ/discussion On Wednesday, March 7, 2012 7:10:28 PM UTC, rdodev wrote: > > Bruno, > > Yes, it would seem that the only two options right now would be to > implement a document type (which I'm not sure how time consuming that woul

[web2py] Re: MongoDB Adapter error in select

2012-05-21 Thread Francisco Costa
requested here: https://groups.google.com/d/topic/web2py/pqdYpUbMXKQ/discussion On Monday, May 14, 2012 2:35:43 AM UTC+1, Massimo Di Pierro wrote: > > I think you can already > > db.table.insert(**dict()) > > Are you asking for something different? > > On Saturday, 12 May 2012 05:25:02 UTC-5,

[web2py] OverflowError: long int too large to convert to int (SQLFORM.grid)

2012-05-21 Thread szimszon
File "applications/szegedarchive/compiled/controllers_default_index.py", line 127, in index File "/srv/web2py/gluon/sqlhtml.py", line 1905, in grid tr.append(TD(link['body'](row))) File "applications/szegedarchive/compiled/controllers_default_index.py", line 120, in File "/srv/web2

[web2py] Re: OverflowError: long int too large to convert to int (SQLFORM.grid)

2012-05-21 Thread szimszon
Sorry, invalid. 2012. május 21., hétfő 12:21:29 UTC+2 időpontban szimszon a következőt írta: > > File "applications/szegedarchive/compiled/controllers_default_index.py", > line 127, in index > File "/srv/web2py/gluon/sqlhtml.py", line 1905, in grid > tr.append(TD(link['body'](row))) > F

[web2py] time event

2012-05-21 Thread Hassan Alnatour
Dear ALL, How can let my web2py application send an email every day at 12 pm ?? Best regards,

Re: [web2py] time event

2012-05-21 Thread Manuele Pesenti
Il 21/05/2012 14:14, Hassan Alnatour ha scritto: Dear ALL, How can let my web2py application send an email every day at 12 pm ?? try read this... http://web2py.com/books/default/chapter/29/4?search=scheduler cheers M. Best regards,

Re: [web2py] time event

2012-05-21 Thread hasan alnator
But this is experimental !! i need somthing done before On Mon, May 21, 2012 at 3:21 PM, Manuele Pesenti wrote: > Il 21/05/2012 14:14, Hassan Alnatour ha scritto: > > Dear ALL, >> >> How can let my web2py application send an email every day at 12 pm ?? >> > > try read this... > > http://web2py

Re: [web2py] How to prevent delete of a row with SQLFORM.grid -

2012-05-21 Thread Johann Spies
On 21 May 2012 08:01, François Delpierre wrote: > I must ensure there is always at least one row in a table. (My application > parameter table) > How can I prohibit delete of the last row of a table ? > As it looks the ondelete is executed AFTER deletion... > Not tested but what about something l

Re: [web2py] Re: jqgrid assistance

2012-05-21 Thread Larry Wapnitsky
Any ideas, Massimo? This would really be great, as my database is growing. Thanks. On Tuesday, May 15, 2012 9:55:57 AM UTC-4, Larry Wapnitsky wrote: > > right...realized that after I sent it (long day) > > any ideas? > > On 5/15/2012 9:53 AM, Massimo Di Pierro wrote: > > It is not really a co

Re: [web2py] time event

2012-05-21 Thread Manuele Pesenti
Il 21/05/2012 14:23, hasan alnator ha scritto: But this is experimental !! i need somthing done before what about http://web2py.com/books/default/chapter/29/4?search=cron#Cron ? M.

Re: [web2py] Routing stuff in apache instead of web2py

2012-05-21 Thread Jonathan Lundell
On May 20, 2012, at 10:36 PM, Jason Brower wrote: > > A suppose it would be a little off topic, but I need it for my web2py > application. > The book tells me I shouldn't use routes in web2py and use apache. > I have mod_proxy install, as I used the setup-web2py-ubuntu.sh script and it > seems t

Re: [web2py] time event

2012-05-21 Thread hasan alnator
Can you Please Show me An Example Or Something , I cant understand it Best Regards,

[web2py] examples database

2012-05-21 Thread alazar baharu
am new to web2py and am trying to develop some database driven application and am reading the quick example for web2py on the officila site but it is not working for me in creating the db.py. the eror looks like unexpected character after line continuation character (C:/Users/Alazar/Desktop/we

[web2py] Re: ExecuteSQL, nested selects

2012-05-21 Thread Massimo Di Pierro
This comes up once in a while you can do >>> from gluon dal import Expression >>> db=DAL() >>> db.define_table('a',Field('name')) >>> db.define_table('b',Field('name'),Field('a',db.a)) >>> print db(db.a)._update(name=Expression(db,db(db.b.a==db.a.id)._select(db.b.id))) UPDATE a SET name=(SELECT

[web2py] Re: MongoDB 'document' or 'dict' filetype

2012-05-21 Thread Massimo Di Pierro
I think if that is what you want to do, you go beyond the scope of the dal and perhaps you should use the mongodb api instead of the dal. Perhaps we should discuss it on web2py developers. Anyway, feel free to open a ticket about this. On Monday, 21 May 2012 04:55:01 UTC-5, Francisco Costa wrot

Re: [web2py] examples database

2012-05-21 Thread Ivica Kralj
error report is saying you have a problem with this line purchased = \n(db.person.id==db.purchase.buyer_id)&\n (db.product.id==db.purchase.product_id) try replacing above line with this one purchased = (db.person.id==db.purchase.buyer_id) & (db.product.id ==db.purchase.product_id) On 2

Re: [web2py] time event

2012-05-21 Thread Massimo Di Pierro
In a model: from gluon.scheduler import Scheduler def mytask(): # do something return scheduler=Scheduler(db,tasks=dict(mytask=mytask) if db(db.scheduler_task).isempty(): db.scheduler_task.insert( application_name = 'yourapp', task_name = 'mytask',

[web2py] View not serializing SELECT() - What am I missing?

2012-05-21 Thread Cliff
I cannot see what I'm doing wrong. In the controller, I have functions like this: def mk_select(rows): out = SELECT() for row in rows: out.append(row.somefield) return out def edit(): rows = get_rows() return dict(my_select=get_select(rows)) Then in the view, I do: {{=my_select}}

Re: [web2py] time event

2012-05-21 Thread hasan alnator
But if i want a website to do that forever , i just need to go to the shell i do python web2py.py -K yourapp one time

[web2py] Re: View not serializing SELECT() - What am I missing?

2012-05-21 Thread Massimo Di Pierro
What's get_select()? On Monday, 21 May 2012 10:06:42 UTC-5, Cliff wrote: > > I cannot see what I'm doing wrong. > > In the controller, I have functions like this: > > def mk_select(rows): > out = SELECT() > for row in rows: > out.append(row.somefield) > return out > > def edit(): > row

Re: [web2py] time event

2012-05-21 Thread Massimo Di Pierro
Yes. You just need to make sure the background process is running. From appadmin you start, stop, restart, count your tasks and check their status. On Monday, 21 May 2012 10:10:30 UTC-5, Hassan Alnatour wrote: > > But if i want a website to do that forever , i just need to go to the > shell i do

[web2py] Re: View not serializing SELECT() - What am I missing?

2012-05-21 Thread Cliff
Typo. Should be mk_select(): As you can see, I don't seem to functioning well this AM. On Monday, May 21, 2012 11:16:24 AM UTC-4, Massimo Di Pierro wrote: > > What's get_select()? > > On Monday, 21 May 2012 10:06:42 UTC-5, Cliff wrote: >> >> I cannot see what I'm doing wrong. >> p >> In the co

[web2py] no solution for logging on gae?

2012-05-21 Thread castanets
I deployed very simple web2py app on gae in order to check logging on gae. I followed the guide of "logging.example.conf" which is in web2py package. But I can not find log message of that app in gae console. It was very easy with "hello world" gae example. Please let me know if there is somethi

[web2py] trouble in logging on gae

2012-05-21 Thread castanets
I deployed a very simple web2py app in order to check logging on gae. I just followed the guide of "logging.example.conf" which is in web2py package. But I failed logging on gae. It was very easy to do with "hello world" gae example. Please let me know if there is something to do.

[web2py] Best way to save a value between methods in default.py

2012-05-21 Thread Madu
Hi, I thought this could be trivial but so far I couldn't figure out how to. All I need to do is have a global variable in default.py. When I call one method it will store a value in this variable, and later another method will use it. What I have is something like this: --- default.py

Re: [web2py] Routing stuff in apache instead of web2py

2012-05-21 Thread Jason Brower
How... How does it work? http://www.youtube.com/watch?v=xOrgLj9lOwk I haven't a clue how to check for that. :/ BR, Jason On 05/21/2012 04:05 PM, Jonathan Lundell wrote: On May 20, 2012, at 10:36 PM, Jason Brower wrote: A suppose it would be a little off topic, but I need it for my web2py applic

[web2py] Re: Best way to save a value between methods in default.py

2012-05-21 Thread Anthony
Controller and model files are not Python modules. Rather, they are re-executed (in a separate thread) on each request, so a change you make to a global variable in one request will not affect other requests. You probably want to use the cache for this purpose: http://web2py.com/books/default/c

Re: [web2py] Routing stuff in apache instead of web2py

2012-05-21 Thread Jonathan Lundell
On May 21, 2012, at 9:32 AM, Jason Brower wrote: > > How... How does it work? > http://www.youtube.com/watch?v=xOrgLj9lOwk > I haven't a clue how to check for that. :/ I'm not an expert here, so anyone who cares to correct me: feel free to jump in. Your setup file created an Apache configuration

Re: [web2py] Routing stuff in apache instead of web2py

2012-05-21 Thread Anthony
> > How to test? What I do is to use curl -I to look at the http response > headers; you could presumably use any browser that lets you see the > headers. There should be a difference between the headers for a static file > response depending on whether the above section is in the configuration

Re: [web2py] Routing stuff in apache instead of web2py

2012-05-21 Thread Jason Brower
Fantastic! I looked and on the dynamic parts it shows the powered by tag and on the other parts it doesn't so it clearly is using the other service, apache. Thanks! BR, Jason On 05/21/2012 08:04 PM, Anthony wrote: How to test? What I do is to use curl -I to look at the http response

[web2py] Re: View not serializing SELECT() - What am I missing?

2012-05-21 Thread Massimo Di Pierro
This cannot be the complete code. Somewhere you have an unwanted XML(...). Anyway, you can simplify this a lot: {{=SELECT(*[r.somefield for r in rows])}} On Monday, 21 May 2012 10:38:33 UTC-5, Cliff wrote: > > Typo. Should be mk_select(): > > As you can see, I don't seem to functioning well this

[web2py] I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Brandon Reynolds
Hello, I am new to web2py and pretty new to programming in general. I am getting the following error when trying to insert a new record with a form made with crud.create: home.yearstring may not be NULL I have nothing in my model/view/controllers at all that mentions the year string. I tried

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Anthony
In your model, there is no "yearstring" field defined (there is a "year" field, though) -- so that's why you get a key error when trying to set db.home.yearstring.default. You might be getting the integrity error because the database itself does include a "yearstring" field (with a notnull requ

[web2py] Re: DAL IMAP errors

2012-05-21 Thread Alan Etkin
Sorry, I was not aware of your message from the mail list. It works for my gmail account, with web2py stable and the built-in server. I have not tested IMAPAdapter with any other mail brand. I forgot to upload the app installer to the project page. Now it's available here: http://code.google.co

[web2py] Anyone using BootSwatch with new web2py layout

2012-05-21 Thread Andrew
Hello, I'm trying a few bootswatch themes over a new "welcome" app.see http://bootswatch.com/ The first thing I noticed is that the menus don't display correctly. Is anyone playing with this ? Seeing that web2py uses bootstrap, it would be great to drop in a bootswatch theme.

[web2py] Unable to connect to mssql database

2012-05-21 Thread Random
Hello everyone, It seems that I'm unable to connect to a mssql database. I am getting the error: Traceback (most recent call last): File "gluon/dal.py", line 5955, in __init__ File "gluon/dal.py", line 2280, in __init__ RuntimeError: Unable to import driver when using the connection string

[web2py] Unable to connect to mssql database

2012-05-21 Thread Andrew
Have you installed pyodbc ? It's needed for mssql http://www.web2py.com/books/default/chapter/29/6#Dependencies

Re: [web2py] Re: nginx+uWSGI+Web2Py for Ubuntu Precise 12.04

2012-05-21 Thread orsomannaro
Il 19/05/2012 21:43, Massimo Di Pierro ha scritto: can you please open an issue in google code and link your patch there. done

[web2py] SQLFORM.grid: sorting

2012-05-21 Thread Keith Edmunds
Two questions re SQLFORM.grid sorting. 1. Is it possible to specify the initial sort order? 2. I'm displaying a table that includes a foreign field. When I click on the header to sort by that field, it sorts by the field id rather than by the (displayed) foreign field. Can I sort by the displaye

[web2py] Autologin via janrain?

2012-05-21 Thread Rene Dohmen
Hi List, I'm building an app where users can make quiz content together; login via janrain (only facebook provider). We also have a small iOS app (game) to test the quiz content; it reads the data from a xml that is composed on the fly by a controller function. Is there an easy way to authenticat

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Brandon Reynolds
How do I insert the value into that yearstring field? I understand i got the key error because of the field not being defined. I was trying that only as a troubleshooting step to see what happened. Should i make a yearstring field in the db and then just assing it a default value? Or how else t

[web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Anthony
Yes, web2py uses pyodbc for MSSQL as well as a few other databases: http://code.google.com/p/web2py/source/browse/gluon/dal.py#2529. On Monday, May 21, 2012 3:09:31 PM UTC-4, Andrew wrote: > > Have you installed pyodbc ? It's needed for mssql > http://www.web2py.com/books/default/chapter/29/6#De

Re: [web2py] SQLFORM.grid: sorting

2012-05-21 Thread Jim Steil
You can specify the sort order using the orderby parameter. But, I don't know how you get it to sort by the displayed value of a foreign key column. Ex: orderby = [~db.asset.acquiredOn, db.asset.assetTag, db.asset.description] ~ orders descending. -Jim On 5/21/2012 2:23 PM, Keith Edmun

Re: [web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Jim Steil
This may be way off-base, but can you check your model to make sure the line you have below as: Field('year', 'string', requires=IS_NOT_EMPTY()), is not mistakenly typed as: Field('yearstring', requires=IS_NOT_EMPTY()), Also, for string fields you don't need to specify the type ('string'), t

[web2py] Re: View not serializing SELECT() - What am I missing?

2012-05-21 Thread Cliff
Thank you Massimo. Using the syntax you suggested fixed it. Odd, though, because grep for XML didn't yield anything in the controller, model or view even remotely related to the select I was trying to make. On Monday, May 21, 2012 1:40:22 PM UTC-4, Massimo Di Pierro wrote: > > This cannot be

[web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Random
On Monday, May 21, 2012 2:45:52 PM UTC-5, Anthony wrote: > > Yes, web2py uses pyodbc for MSSQL as well as a few other databases: > http://code.google.com/p/web2py/source/browse/gluon/dal.py#2529. > > On Monday, May 21, 2012 3:09:31 PM UTC-4, Andrew wrote: >> >> Have you installed pyodbc ? It's

Re: [web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Brandon Reynolds
I checked it and it was year not year string. I also tried deleting the whole year field and that had not effect i still got the same error. So i don't think this is an issue with my field. What is the next step i should take? -Brandon On Monday, May 21, 2012 1:54:01 PM UTC-6, Jim S wrote: >

[web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Random
I am also getting the same error when I try to setup a DB connection in Django. It is automatically putting two forward slashes on my username. On Monday, May 21, 2012 1:48:34 PM UTC-5, Random wrote: > > Hello everyone, > > It seems that I'm unable to connect to a mssql database. I am getting t

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-05-21 Thread Massimo Di Pierro
That is the problem that is holding up web2py 2.0. web2py uses bootstrap but superfish for menus. Therefore it tweaks the slyle of menus. How can we avoid it, use bootstrap and still have submenus? On Monday, 21 May 2012 13:42:38 UTC-5, Andrew wrote: > > Hello, > I'm trying a few bootswatch the

Re: [web2py] SQLFORM.grid: sorting

2012-05-21 Thread Massimo Di Pierro
foreign key. You can do a join. On Monday, 21 May 2012 14:49:06 UTC-5, Jim S wrote: > > You can specify the sort order using the orderby parameter. But, I > don't know how you get it to sort by the displayed value of a foreign > key column. > > Ex: > > orderby = [~db.asset.acquiredOn, db.asse

[web2py] Help me prepare a talk on Web2py for the June Meetup of the Atlanta Python User Group (PyATL).

2012-05-21 Thread Cliff
I will have about 20 minutes. Certainly I will mine Massimo's (and any other I can find) talks for ideas. Also the Web2py site. I expect there will be Django users in the group. All ideas gratefully accepted.

[web2py] Re: View not serializing SELECT() - What am I missing?

2012-05-21 Thread Massimo Di Pierro
I'd like to get to bottom of this in case it is a bug Something cases {{=my_select}} to display my_select.__repr__() instead of my_select.__str__() as it should. I do not see in your code where that is happening. On Monday, 21 May 2012 15:03:18 UTC-5, Cliff wrote: > > Thank you Massimo.

Re: [web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Massimo Di Pierro
Please re-post your code. clearly there are some inconstancies between year and yearstring and that is confusing some of us. Moreover, if you are using sqlite and have no important data in db, delete everything in databases/ then try again. On Monday, 21 May 2012 15:04:19 UTC-5, Brandon Reynold

Re: [web2py] SQLFORM.grid: sorting

2012-05-21 Thread Keith Edmunds
Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo.dipie...@gmail.com said: > foreign key. You can do a join. Thanks Massimo; however, that's a little cryptic. Could you explain how a join can be used to determine the sort order

Re: [web2py] SQLFORM.grid: sorting

2012-05-21 Thread Jim Steil
Massimo - Is there a way to do it with a .smartgrid. I know the question wasn't on .smartgrid, but I'm using that extensively and too would like some sort of solution. -Jim On 5/21/2012 3:11 PM, Massimo Di Pierro wrote: foreign key. You can do a join. On Monday, 21 May 2012 14:49:06 UTC

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Anthony
Can you inspect the database directly (not using web2py)? Is there in fact a "yearstring" field in the "home" table of the database, and if so, is there a NOT NULL constraint on it. Anthony On Monday, May 21, 2012 3:40:14 PM UTC-4, Brandon Reynolds wrote: > > How do I insert the value into that

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-05-21 Thread Anthony
Here are a couple options: http://jsfiddle.net/2Smgv/ http://jsfiddle.net/4nMkh/4/ Anthony On Monday, May 21, 2012 4:10:35 PM UTC-4, Massimo Di Pierro wrote: > > That is the problem that is holding up web2py 2.0. > > web2py uses bootstrap but superfish for menus. Therefore it tweaks the > slyle

Re: [web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Jonathan Lundell
You're using backslashes. Try forward slashes. (The doubling itself is harmless though; just display.) On May 21, 2012, at 1:08 PM, Random wrote: > I am also getting the same error when I try to setup a DB connection in > Django. It is automatically putting two forward slashes on my username.

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-05-21 Thread Andrew
Looks Good. Are they "swatchable" ? On Tuesday, May 22, 2012 9:05:19 AM UTC+12, Anthony wrote: > Here are a couple options: > http://jsfiddle.net/2Smgv/ > http://jsfiddle.net/4nMkh/4/ > > Anthony > > On Monday, May 21, 2012 4:10:35 PM UTC-4, Massimo Di Pierro wrote: >> >> That is the problem

Re: [web2py] SQLFORM.grid: sorting

2012-05-21 Thread Massimo Di Pierro
something like this? SQLFORM.grid(db.table1.field1==db.table2.id,fields=db.table1.ALL,orderby=db.table2.field2) smartgrid cannot do this. On Monday, 21 May 2012 15:24:23 UTC-5, backseat wrote: > > Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid > > On Mon, 21 May 2012 13:11

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-05-21 Thread Anthony
Not sure, haven't tried them. They're based on the standard Bootstrap menu, so hopefully they're easily swatchable. Anthony On Monday, May 21, 2012 5:20:25 PM UTC-4, Andrew wrote: > > Looks Good. Are they "swatchable" ? > > > On Tuesday, May 22, 2012 9:05:19 AM UTC+12, Anthony wrote: > >> Her

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-05-21 Thread Massimo Di Pierro
They both look good to me. If you send me a patch for welcome I will take it. On Monday, 21 May 2012 16:05:19 UTC-5, Anthony wrote: > > Here are a couple options: > http://jsfiddle.net/2Smgv/ > http://jsfiddle.net/4nMkh/4/ > > Anthony > > On Monday, May 21, 2012 4:10:35 PM UTC-4, Massimo Di Pierr

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Brandon Reynolds
I did in fact inspect the database and there was a yearstring field. I think what happened is when i defined the field year i forgot the comma between year and string so 'year' 'string became yearstring. Then when i noticed and fixed the issue it added year field but left yearstring in the db.

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Brandon Reynolds
It is also worth mentioning that this form that now has the error was working fine before i deleted the db files. Please advise. -Brandon On Monday, May 21, 2012 4:05:20 PM UTC-6, Brandon Reynolds wrote: > > I did in fact inspect the database and there was a yearstring field. I > think what hap

[web2py] Where is the path for sqlite db storage defined?

2012-05-21 Thread Andrew
I've put together a web2py skeleton for OpenShift PaaS ( https://github.com/prelegalwonder/openshift_web2py) and am trying to tweak it for things like persisting sqlite through git pushes. In order to do that I need to change where web2py stores it's sqlite db files from applications/app/databas

[web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Derek
I've always setup a sql server login specific to my app. The "active directory" integrated mode doesn't seem to sit too well with Web2Py and MSSQL. On Monday, May 21, 2012 1:08:59 PM UTC-7, Random wrote: > > I am also getting the same error when I try to setup a DB connection in > Django. It

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread villas
> However i since erased the db(since i am only working on a test right now) and used fake_migrate to replace the tables. Don't use fake_migrate. If you are using Sqlite then delete the entire contents of databases/ directory and make sure migrate =True. It should then build a clean DB and m

Re: [web2py] Where is the path for sqlite db storage defined?

2012-05-21 Thread Jonathan Lundell
On May 21, 2012, at 3:40 PM, Andrew wrote: > I've put together a web2py skeleton for OpenShift PaaS > (https://github.com/prelegalwonder/openshift_web2py) and am trying to tweak > it for things like persisting sqlite through git pushes. In order to do that > I need to change where web2py stores

Re: [web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Jonathan Lundell
On May 21, 2012, at 1:08 PM, Random wrote: > I am also getting the same error when I try to setup a DB connection in > Django. It is automatically putting two forward slashes on my username. The web2py parser wants forward slashes ('/'), not backslashes. db = SQLDB('mssql://username:password@/s

[web2py] Re: I keep getting the error: home.yearstring can't be null.

2012-05-21 Thread Anthony
> > Field('park_fax', 'string', requires=IS_EMPTY_OR(IS_MATCH('[\d\-\(\) > ]+'))), Field('park_phone_2', 'string', requires=IS_EMPTY_OR(('[\d\-\(\) > ]+'))), > Looks like you're missing an IS_MATCH there. Should be: Field('park_phone_2', 'string', requires=IS_EMPTY_OR(IS_MATCH('[\d\-\(\) ]+' )

[web2py] Re: Help me prepare a talk on Web2py for the June Meetup of the Atlanta Python User Group (PyATL).

2012-05-21 Thread howesc
while i have not attended any of the talks i do like in many of massimo's videos he builds a (simple) but impressive demo app live. "building a functional app live is worth a thousand words" that is the quote right? ;) cfh On Monday, May 21, 2012 1:11:35 PM UTC-7, Cliff wrote: > > I will

[web2py] Re: trouble in logging on gae

2012-05-21 Thread howesc
i don't use logging.conf. either i'm not smart enough or something else went wonky. with no logging.conf i got everything info (perhaps debug i can't remember) and higher. one day i decided i did not want the logging from gluon and debug logging. the only way i could restrict that was by mod

[web2py] Restricting access to auth action and issues with overriding the default user actions

2012-05-21 Thread csantos
1) In http://web2py.com/books/default/chapter/29/9, under Authentication, it is said (regarding the user actions): > > By default they are all exposed, but it is possible to restrict access to > only some of these actions Question: How? There are no explanations or examples on what's the best wa

[web2py] trouble in logging on gae

2012-05-21 Thread castanets
deployed a very simple web2py app in order to check logging on gae. I just followed the guide of "logging.example.conf" which is in web2py package. But I failed logging on gae. It was very easy to do with "hello world" gae example. Please let me know if there is something to do.

[web2py] Re: Restricting access to auth action and issues with overriding the default user actions

2012-05-21 Thread csantos
Another info: Unlike registrations made by /user/register, the red and blue registrations are added to the DB with the registration_key field filled. On Monday, May 21, 2012 9:42:32 PM UTC-3, csantos wrote: > > 1) In http://web2py.com/books/default/chapter/29/9, under Authentication, > it is sai

[web2py] Re: Restricting access to auth action and issues with overriding the default user actions

2012-05-21 Thread Anthony
> > 1) In http://web2py.com/books/default/chapter/29/9, under Authentication, > it is said (regarding the user actions): >> >> By default they are all exposed, but it is possible to restrict access to >> only some of these actions > > Question: How? There are no explanations or examples on what'

[web2py] Issues with running GAE and web2py with python2.5

2012-05-21 Thread Pystar
I tried running web2py with the latest GAE and python2.5 This is the traceback I got. Traceback (most recent call last): File "C:\Program Files\Google\google_appengine\google\appengine\tools\dev_appserver.py", line 2781, in _HandleRequest self._Dispatch(dispatcher, self.rfile, outfile, e

[web2py] Re: Restricting access to auth action and issues with overriding the default user actions

2012-05-21 Thread csantos
Thanks for the answers. Your suggestion for one single form worked well. As for the verification issue, it didn't happen when I used the default user() action (that is, it only happens when I overwrite the register() action). Perhaps this is a bug? On Monday, May 21, 2012 9:55:41 PM UTC-3, Anth

[web2py] Re: View not serializing SELECT() - What am I missing?

2012-05-21 Thread Cliff
Can't reproduce it, otherwise I would post all the applicable code. Sorry. On Monday, May 21, 2012 4:13:14 PM UTC-4, Massimo Di Pierro wrote: > > I'd like to get to bottom of this in case it is a bug Something cases > > {{=my_select}} to display my_select.__repr__() instead of > my_selec

[web2py] Re: Help me prepare a talk on Web2py for the June Meetup of the Atlanta Python User Group (PyATL).

2012-05-21 Thread Massimo Di Pierro
Perhaps this can be useful. Sample: http://dl.dropbox.com/u/18065445/MarkminSlides/test.html Source: https://github.com/mdipierro/markmin-reveal-slides It turns a markmin file into a reveal.js+mathjax.js+highlight.js presentation (code is automatically syntax-highlighted). You can of course us

Re: [web2py] Re: Best way to save a value between methods in default.py

2012-05-21 Thread Maduranga Liyanage
Thank you very much Anthony. I will read up on the cache. On Tue, May 22, 2012 at 1:37 AM, Anthony wrote: > Controller and model files are not Python modules. Rather, they are > re-executed (in a separate thread) on each request, so a change you make to > a global variable in one request will n

[web2py] Re: Restricting access to auth action and issues with overriding the default user actions

2012-05-21 Thread Anthony
On Monday, May 21, 2012 9:32:04 PM UTC-4, csantos wrote: > > Thanks for the answers. Your suggestion for one single form worked well. > As for the verification issue, it didn't happen when I used the default > user() action (that is, it only happens when I overwrite the register() > action). Per

Re: [web2py] Re: Best way to save a value between methods in default.py

2012-05-21 Thread Bruno Rocha
you can use session. http://zerp.ly/rochacbruno Em 21/05/2012 22:48, "Maduranga Liyanage" escreveu: > Thank you very much Anthony. > I will read up on the cache. > > > On Tue, May 22, 2012 at 1:37 AM, Anthony wrote: > >> Controller and model files are not Python modules. Rather, they are >> re-

[web2py] Re: trouble in logging on gae

2012-05-21 Thread castanets
castanets writes: > > deployed a very simple web2py app in order to check logging on gae. I just > followed the guide of "logging.example.conf" which is in web2py package. But > I > failed logging on gae. It was very easy to do with "hello world" gae example. > Please let me know if there i

[web2py] auth.has_membership(None) == True # is this correct?

2012-05-21 Thread weheh
I'm seeing auth.has_membership(None) == True. How can this be a good thing?

[web2py] Re: What to expect in web2py 2.0

2012-05-21 Thread Matt
Hi Massimo, Quick question if I may, Will the upcoming 2.0 bootstrap code support the html style forms that bootstrap uses? Thanks in advance, Matt On Sunday, 20 May 2012 08:10:13 UTC+12, Massimo Di Pierro wrote: > > Basically the same features we have in trunk now. Just lots of bug fixes

[web2py] How to create a user account programmatically?

2012-05-21 Thread Luca
To validate a user-password pair, I can use auth.login_bare. Two questions: 1. Auth.login_bare does not cause the user to be logged in: for instance, auth.user_id is not set afterwards. Is there a way to also log in a user, not only validate the username/password pair? 2. Suppose

Re: [web2py] examples database

2012-05-21 Thread alazar baharu
hi Ivica Kralj your posts are help full to me and now i have fixed my problem with your great full help thanks and again let me ask you one question is there any application developed for an attendance system in one organization using web2py what can you will recommend me. 10ks ok man On Mon, May