[web2py] orderby and NULLS last

Hello, is it possible to sort NULLS last with orderby desc? orderby=~db.table.last_login I want the empty last_login last in desc sorting. On postgresql: ORDER BY sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }] Thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Fwd: Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

YouTube videos of U.S. Congress money laundering hearing of Saudi Billionaire " Maan Al sanea" with *bank of America* and The owner of Saad Hospital and Schools in the Eastern Province in *Saudi Arabia* and the Chairman of the Board of Directors of Awal Bank in *Bahrain* Wit

[web2py] Re: As an MVC framework, does web2py allows updating model from view?

Thanks On Thursday, November 9, 2017 at 6:25:00 PM UTC+5:30, Leonel Câmara wrote: > > It's not recommended because the logic in web2py is that you use the same > controller for many different views (html, json, pdf, etc) so if you put > the getting of data in the view you will have to replicate

[web2py] Re: As an MVC framework, does web2py allows updating model from view?

So in the same way, can it make updates in the db? And why is it not recommended in web2py if the diagram doesn't say so? On Thursday, November 9, 2017 at 6:17:42 PM UTC+5:30, Leonel Câmara wrote: > > In the way shown in that diagram yes it can. You can make > db(query).select() inside a view so

[web2py] As an MVC framework, does web2py allows updating model from view?

Can mo

[web2py] How to speed up query processing in web2py's sqlite?

I see that with a million of rows, the search takes almost 15-20 seconds. How do I speed it up? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You recei

[web2py] Can't show images from database in web2py 2.14.6?

I used the following snippet before in the old versions of web2py. They worked like charm there. However doesn't work here. What am I losing? controller: row1=db(db.slideshow).select().first().picture in view: the image doesn't display at all! -- Resources: - http://web2py.com - http://web2

[web2py] IMMD NEED !! SAP IM/MM Consultant - Woodbury, NY.

with peers, end-users and executive management. Exceptional organizational and documentation skills. Strong analytical and problem-solving skills. Ability to work both independently and within a team. Willing to travel on occasion, as required. *Mike Smith - IT RecruiterDirect: (630) 444-7490E

[web2py] IMMD NEED !! Financial Analyst - Phila, PA

tical and problem solving skills Strong organizational and interpersonal skills *Best Regards,* *Mike Smith - IT Recruiter* *Direct: (630) 444-7490* *Email: msm...@ayrglobal.com * *AYR Global IT Solutions Inc. | * *1431 Opus Pl, Suite 110, Downers Grove, IL - 60515* -- Resources: - http://web2p

[web2py] Date selector doesn't display properly after changing layout(see screenshot).What can be the reason?

Any idea on what must be wrong in any of the external css file in the layout. What I should do to rectify this? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

[web2py] Why the response.flash can't be dismissed here?

I am using this layout from web2py's official site: web2py.plugin.layout_Chasmogamous However I see that the response.flash can't be dismissed. I guess there is a problem with this snippet in its layout.html: {{=response.flash or ''}} How do I make it work like it does in default layout? This sn

[web2py] How to make Web2py not block 'get' as well as 'post' requests from external sources?

$().ready(function () { //here any https will work but below is not working because of cross origin ..code is correct, just change url or put some json string or file var url = 'http://biglibrary.pythonanywhere.com/app/phonegap/temp.json'; $.get(url, function (data) { alert(data); }); })

Re: [web2py] This is not working as expected. Please correct this.

I am not getting the day of the month On Monday, November 28, 2016 at 10:47:13 PM UTC+5:30, Yoel Benitez Fonseca wrote: > > and what value are u getting on 'k', the day of month i suppose !? > > 2016-11-28 9:56 GMT-05:00 Mike Stephenson >: > > > form3 = S

[web2py] This is not working as expected. Please correct this.

form3 = SQLFORM.factory(Field('ddate','date', label='Enter a date')).process() if form3.accepted: k=form3.vars.ddate.day() redirect(URL('readings', 'check', args=[k,k,k])) K doesn't read value as expected. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: Why is this query not giving me the correct set of rows as expected?

request.args[0] is just a number representing a day. What's wrong here? On Thursday, November 24, 2016 at 7:14:55 PM UTC+5:30, Marlysson Silva wrote: > > what is request.args[0] ? a datetime? > > Em quinta-feira, 24 de novembro de 2016 08:38:29 UTC-3, Mike Stephenson > esc

[web2py] Re: Why is this query not giving me the correct set of rows as expected?

Just to make sure both are strings. request.args[0] is just a number representing a day. What's wrong here? On Thursday, November 24, 2016 at 6:57:59 PM UTC+5:30, Leonel Câmara wrote: > > str??? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

[web2py] Re: Howto override login_bare?

Am Donnerstag, 24. November 2016 14:07:07 UTC+1 schrieb Leonel Câmara: > > You can actually use login_user which just takes a user Row and makes it > be the logged in user, which is what login_bare and the other login methods > use after verifying the password. I think this is a bad idea even f

[web2py] Re: Howto override login_bare?

Strictly speaking I want the original login_bare plus an login_bare_without_password, which allows login only with username. This is only for intranet use. Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Howto override login_bare?

password works. But with auth.mc_login_bare("Username", "password") I get user = auth.mc_login_bare("Username", "password") request = current.request NameError: global name 'current' is not defined This is my first try to ovveride an method...

[web2py] Why is this query not giving me the correct set of rows as expected?

rows=db((str(db.emeter.instant.month) == str(request.args[0])) & (db.emeter.userid==auth.user_id) ).select() emeter: db.define_table('emeter', Field('userid'), Field('instant', 'datetime', default=request.utcnow+datetime.timedelta(0,19800), writable=False, read

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

Yeah exactly that doesn't work. How do I avoid that error? It says:" XMLHttpRequest cannot load https://biglibrary.pythonanywhere.com/app/phonegap/temp.json. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'null' is therefore not allowed access." when I use

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

wDKduE0mVQ> On Friday, November 11, 2016 at 7:05:00 PM UTC+5:30, Anthony wrote: > > On Friday, November 11, 2016 at 7:29:06 AM UTC-5, Mike Stephenson wrote: >> >> Hi Dave. for example how do I read the json from this link: >> https://biglibrary.pythonanywhere.com/app/phonegap

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

:02 PM UTC-8, Mike Stephenson wrote: >> >> It's messed up. >> > > How so? What does it do? What do you expect it to do? > > Can you show us how your controller prepares the json? What does your > view look like? > > >> Can you help out with a

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

It's messed up. Can you help out with a code snippet? Will be of much help. On Thursday, November 10, 2016 at 12:17:17 AM UTC+5:30, Leonel Câmara wrote: > > What do you mean? What are you trying to do? How are you putting the json > there? Are you getting it using $.getJSON or something like that

[web2py] I am unable to parse contents from a json view in javascript? How do I do it?

I have totally messed up. Can you write the required snippet for me or share a helpful link? Thanks for the same. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Iss

[web2py] What kind of application is web2py good for designing and what kind of application it isn't as good?

for example, you may compare chatting and other kinds. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribe

[web2py] What kind of application is web2py for designing and what kind of application it isn't as good?

for example, you may compare chatting and other kinds. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribe

[web2py] Re: readonly field only in SQLFORgrid edit page if field is not empty

atetime. > timedelta(hours=1) > db.foobar.text.writable = not (record.text and older_than_an_hour) > form = SQLFORM.grid(db.foobar) > return dict(form=form) > Thank you Anthony, this works perfectly. Also thank you Val. Regards, Mike -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] readonly field only in SQLFORgrid edit page if field is not empty

he db.foobar.text.writable = False? I can use request.args(1) = 'edit', but how can I then take the row, test it and set the writable to false? I don't want to validate after sending the form. The input field should be initially readonly. Regards, Mike -- Resources: -

[web2py] Re: Upload file using the LOAD (....., ajax = True)

Hello Massimo, Am Sonntag, 27. März 2016 17:18:42 UTC+2 schrieb Massimo Di Pierro: > > Hello Mike, > > could you explain your patch to web2py-developers? it is quite extensive. > > I think you misunderstood me (or I didn't explain it well). This "patch" is

[web2py] Re: Upload file using the LOAD (....., ajax = True)

found are >5 years old. This one is the one which seems the most usable. Regards, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received

[web2py] Re: Additional field type for real boolean

Am Montag, 18. Januar 2016 18:06:32 UTC+1 schrieb Anthony: > > Maybe this will work: > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Custom-Field-types--experimental- > This looks good. Don't know why I didn't see this before... This seems to work: from gluo

[web2py] Additional field type for real boolean

domains/umweltanalyse-portal.de/docs/gluon/packages/dal/pydal/adapters/base.py" , line 1524, in parse_value return self.parsemap[key](value,field_type) KeyError: 'boolean2' What is the correct code to archieve this? I need the regular web2py boolean field plus a new field type in

[web2py] Re: Can you have multiple plugins use Web2py Scheduler in the same App?

ey are installed in an App separately. If they are both >> isnstalled in the same App only one of the plugins scheduled tasks get run. >> (The one with the last loaded model alphabetically). Can someone point me >> in the right direction to get this working? >> >> Than

[web2py] Can you have multiple plugins use Web2py Scheduler in the same App?

the right direction to get this working? Thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are

[web2py] Logger works locally but not when deployed to a server

e silly permissions issue, and I see nothing. I'm running web2py's built in server via a cronjob like this: @reboot python /home/mike/web2py/web2py.py -i 0.0.0.0 -p 80 -a "" The reason I'm adding the logging is because I was trying to run a subprocess in order to

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

On Wednesday, February 25, 2015 at 12:18:29 PM UTC-8, Niphlod wrote: > > reaally strange, although I don't use lighttpd since nginx came out. > request.vars are parsed out of request.QUERY_STRING. could you please > doublecheck what request.get('QUERY_STRING') dumps ? > > > request.get('QUERY_

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

TTP["scheme"] == "http" { $HTTP["host"] =~ ".*" { url.redirect = ("^/ccs/.*" => "https://%0$0";) } } fastcgi.server = ( ".fcgi" => ( "localhost" => ( #name for logs "debug&q

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

_cmd() is empty: ** Although, the request.env.query_string contents are valid: *'query_string': 'id=2&src=cmd'* Any suggestions to resolve this issue would be greatly appreciated, thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: howto: ajax call in FORM with signed URL

king vars > into consideration. > Please review the book about the signature process... > > http://web2py.com/books/default/chapter/29/04/the-core?search=signed#Digitally-signed-urls > > BTW: auth.requires_signature() takes hash_vars as a parameter too. > > On Wednesday,

[web2py] Re: howto: ajax call in FORM with signed URL

signature=True), 'target');"), _name= > "search_type"))) > > Regards > > On Wednesday, March 19, 2014 1:59:38 PM UTC+1, Mike Constabel wrote: >> >> Hi, >> >> in a form i have >> >> TD(INPUT(_id='keyword', _name='k

[web2py] howto: ajax call in FORM with signed URL

is displayed in target. This works. But now I want to sign the URL. If I add @auth.requires_signature() to callback function, it no longer works. The ajax call must be signed. @auth.requires_signature() def callback(): return P("foo") But how can I add "user_signature=True&

[web2py] Re: Best way to use a standalone DAL

UTC+8, Anthony wrote: > > In a script, you can just import it like any other Python module. Not sure > what you mean by calling it from "the webgui". > > Anthony > > On Monday, March 3, 2014 3:58:39 AM UTC-5, Gwayne aka Mike Veltman wrote: >> >> I will act

[web2py] Best way to use a standalone DAL

I will actually call dal from within some scripts and from the webgui. What would be the best and cleanest way to do that ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (R

[web2py] web2py + gae + google:sql : Not authorized to access (database) instance

I have started working with web2py + gae and a Cloud SQL database. The application db connection string is : db = DAL('google:sql://cloud1:ctm-manager/ctmdb') Logs on GAE show the following: File "/base/data/home/runtimes/python27/python27_lib/versions/1/google/storage/speckle/python/api/rdb

[web2py] Re: Multiple SOLIDFORMs from table rows

Yes. same error. Am Montag, 10. Februar 2014 16:21:57 UTC+1 schrieb Cliff Kachinske: > > Have you tried it without the showid arg? > > On Monday, February 10, 2014 3:12:36 AM UTC-5, Mike Constabel wrote: >> >> Hi, >> >> I try to generate multiple SOLIDFORMS fr

Re: [web2py] Multiple SOLIDFORMs from table rows

Hi, Am Montag, 10. Februar 2014 16:05:49 UTC+1 schrieb viniciusban: > > Maybe I missed something, but what is a SOLIDFORM? > Sorry, forget to mention it. SOLIDFORM is an "extended" SQLFORM http://dev.s-cubism.com/plugin_solidform -- Resources: - http://web2py.com - http://web2py.com/book (Do

[web2py] Re: Multiple SOLIDFORMs from table rows

Am Montag, 10. Februar 2014 16:21:57 UTC+1 schrieb Cliff Kachinske: > > Have you tried it without the showid arg? > Yes, same error. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/is

[web2py] Multiple SOLIDFORMs from table rows

rm3 = CAT(form3, SOLIDFORM(db.foo_analysis, a, fields=fields3, showid=True, readonly=True), P()) return dict(form3=form3) Here I got ('Row' object has no attribute 'id') I tried many other "combinations" of fields, forms, selects, but got every time error

[web2py] Re: github - please follow

Done! up to 528 now. On Sunday, 25 August 2013 00:26:03 UTC+1, Massimo Di Pierro wrote: > > web2py has many users but few github followers. This is a problem because > the number of followers is a metric that can be used to guess popularity. > > You can help. > > Get a github account and click o

Re: [web2py] 1071, 'Specified key was too long; max key length is 767 bytes'

label=T('Frame State record ID')), Field('created_on','datetime',default=request.now, label=T('Created On'),writable=False,readable=False), Field('modified_on','datetime',default=request.now, label=T('Mod

[web2py] 1071, 'Specified key was too long; max key length is 767 bytes'

Ok, I am now fighting with it for two days and it drives me crazy. My gut feeling says mysql 5.1 --> mysql 5.5 upgrade is the cause. Am I right ? And how do I solve it. :-) *Error ticket for "adeploy"* *Ticket ID* 192.168.2.106.2013-10-08.12-46-19.24f3f1a5-d637-4522-965b-fed4958115ed * (1071, 'Sp

[web2py] 1071, 'Specified key was too long; max key length is 767 bytes

My gut feeling says mysql 5.1 --> mysql 5.5 upgrade is the cause. Am I right ? And how do I solve it. :-) *Error ticket for "adeploy"* *Ticket ID* 192.168.2.106.2013-10-08.12-46-19.24f3f1a5-d637-4522-965b-fed4958115ed * (1071, 'Specified key was too long; max key length is 767 bytes')* *Versio

Re: [web2py] Re: Changelog for 2.6.3?

ednesday, 18 September 2013 12:37:50 UTC-5, Dave S wrote: >> >> On Wednesday, September 18, 2013 3:52:38 AM UTC-7, Niphlod wrote: >>> >>> http://web2py.com/init/**default/changelog<http://web2py.com/init/default/changelog> >>> >> >> Mike mig

Re: [web2py] Re: [web2pyy] Mysql 2 Mongodb

On Wednesday 24 July 2013 18:34:08 Alan Etkin wrote: Note: If you are restoring data with the DAL method import_from_csv_file (not the Table class method) using id_map={}, which is the method that should be used to keep references in sync, you should not have issues keeping reference values. I

Re: [web2py] Re: [web2pyy] Mysql 2 Mongodb

On Wednesday 24 July 2013 11:52:36 Alan Etkin wrote: > Also I concluded that because all the references are replaced by mongodb id's > it is not possible to say > dump a table with references in one database and > then restore it on mongodb. Neither you can (or should) with other adapters, for

[web2py] Re: [web2pyy] Mysql 2 Mongodb

On Monday 22 July 2013 05:16:56 Alan Etkin wrote: I am just playing around with mongodb and web2py I noticed that when I just make a web2py dump of my mysql db and then upload it to mongodb some of the "joins" now just rec id's are right and some are newly generated. Also would it be possib

[web2py] [web2pyy] Mysql 2 Mongodb

and to use _id for mongodb ? I was wondering if it was a bug. In this case in the setup table the pointers to the frame work fine, but the pointers in the setupprofile named lparprofile do not exist anymore in the lparprofile table. Mike db.define_table('frame', Field(

[web2py] Re: No module named plural_rules errro after upgrade

web2py.py and it all worked fine. Thanks for your help. On Monday, 10 June 2013 16:38:12 UTC+1, Niphlod wrote: > > do you have a VERSION file in the folder ? > > Il giorno domenica 9 giugno 2013 22:44:36 UTC+2, mike dawson ha scritto: >> >> I downloaded the latest zip fi

[web2py] Re: No module named plural_rules errro after upgrade

:43 PM UTC+2, mike dawson wrote: >> >> >> Hi guys new user here >> >> I just upgraded my folder at /usr/share/web2py >> >> to new version: Version 2.5.1-stable+timestamp.2013.06.06.15.39.19 >> >> and I'm getting this startup

[web2py] No module named plural_rules errro after upgrade

ne 110, in raise RuntimeError, "Cannot determine web2py version" RuntimeError: Cannot determine web2py version Can anyone advise whats missing? I'm running Linux Mint 14 thanks Mike -- --- You received this message because you are subscribed to the Google Groups "web2p

Re: [web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

Yeah, been a long day it should be: db.define_table( 'contact', Field ('name'), Field ('address'), format = '%(name)s') db.define_table( 'courses' , Field

[web2py] Custom User Registration

matic stuff. The reason I ask is I have a desktop client that talks to my web2py server via JSON RPC and I'd like to enable users to register from there without having to do everything else myself. Thanks, Mike -- --- You received this message because you are subscribed to the Google Group

Re: [web2py] Mongodb error in appadmin

On 03/21/2013 08:06 PM, Alan Etkin wrote: > > I would love to have some pointers about how though define mongo in > db.py in a proper nosql way. > > > Could you open an issue at the project page? > Done :-) Issue 1401 : Mongodb error

Re: [web2py] Mongodb error in appadmin

Op 21-03-13 17:50, Niphlod schreef: > seems to me that a lot of people are interested in using mongodb but > really few are contributing back with tests and patches. > > BTW: you DO know that Mongo generally doesn't play well with joins, > right ? Using references in mongodb is not a smart des

[web2py] Mongodb error in appadmin

Created the following table mdb.define_table('syscommands', Field('commandname', type='string', unique=True, label=T('Commandname')), Field('commandline', type='string', label=T('Command')), Field('host_id', mdb.hoststable, comment="Like nim or

[web2py] Mongodb error in appadmin

The action I have a table/collection with 3 objects In the table this is reverenced as Field('host_id', mdb.hoststable, comment="Like nim or hmc server.", label=T('Destination Host ID')), But when in appadmin I select a other object to change then it throws a error. The err

[web2py] Re: RPC Versioning Scheme

w controller for a new version. So your old client gets /app/v1 > and your new client gets /app/v2 > > On Tuesday, February 19, 2013 3:50:05 PM UTC-7, Mike D wrote: >> >> Hi, >> >> I'm using web2py to serve RPC methods to a desktop client that a user can >>

[web2py] RPC Versioning Scheme

I'm trying to avoid having to copy each function into every new version of the API so that I can just fix any bugs in one spot. Any thoughts on this? Too hard? Won't work? If anyone has done this before and can help me out I'd appreciate it. Thanks, Mike -- --- You received thi

[web2py] grid, user_signature, and apache auth

ange user_signature to False. I assume I am not mapping the login function correctly? Can anyone offer me some pointers here? Thanks in advance for any assistance. --Mike -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To u

Re: [web2py] Possible bug in JSONRPC in v2.3.2

b2py/5kCYP-wiELo/discussion >> >> >> >> On Saturday, December 22, 2012 7:04:18 AM UTC+1, rochacbruno wrote: >>> >>> >>> >>> On Sat, Dec 22, 2012 at 3:57 AM, Mike D wrote: >>> >>>> s = methods[method](**params) >>> >>> >>> I guess it should be >>> >>> s = methods[method](*args, **params) >>> >>> to be more flexible >>> >> --

[web2py] Possible bug in JSONRPC in v2.3.2

d from: s = methods[method](*params) to s = methods[method](**params) I changed it back and everything works perfectly now. Is this a bug or am I doing something incorrectly? Thanks, Mike --

[web2py] Mongodb and db.py

Hello People, I am looking into converting my mysql database setup into a mongodb and I was wondering about how at the moment db.py does translate the tables. Because I would like to have some control/understanding about it. --

[web2py] Re: Web2py scheduler timeout

I have now tried with two different browsers to attach the log with no success. I keep getting error (340) occurred while communicating with the server. Do you want me to just email you the log? On Monday, December 17, 2012 12:45:45 PM UTC-8, Mike D wrote: > > Sorry about that. I just tr

[web2py] Re: Web2py scheduler timeout

Sorry about that. I just tried to attach the log and it keeps giving me an error. The scheduler_task record is marked QUEUED and the last scheduler_run record is marked COMPLETED. The task just isn't being run for some reason. On Monday, December 17, 2012 12:29:34 PM UTC-8, Niphlod wrote: > > y

[web2py] Re: Web2py scheduler timeout

quot; task coordinating those > and it doesn't block. > "Upgrading" to Mysql or PostgreSQL will fix the issue if the issue is > dependant on database locking. It's fairly easy to install both, so it's > surely worth the effort. > Anyway, I'm

[web2py] Re: Web2py scheduler timeout

I have only this one task. I am certainly going to change the retry_failed and hopefully that will be a sufficient solution. I actually tried your other solution a while ago and that "monitoring" task actually ended up in a TIMEOUT state as well. Sad face. Any idea on that one? Do you think tha

[web2py] Re: Web2py scheduler timeout

annot fix it I will have to find a different solution for directory >> monitoring and not use the scheduler. >> > > Can't you use a task with retry_failed ? > > Next step is enabling debug logging of the scheduler to see what goes on > when the task timeouts > > On T

[web2py] Web2py scheduler timeout

he reason I have added in such granular logging is to find exactly where the timeout was occurring so I could fix it but I cannot find the problem anywhere. Please let me know if anyone has any ideas on what could be causing this issue. Any help would be very much appreciated. If I cannot fix it I will have to find a different solution for directory monitoring and not use the scheduler. Thanks again, Mike --

Re: [web2py] Re: Truncate Sqlite DB

ls will just create also the 3 > tables the scheduler needs to work (just as the auth_* tables if you're > using web2py's Auth system). > > On Monday, December 3, 2012 9:16:47 PM UTC+1, Mike Anson wrote: >> >> Yes I did delete everything from /databases before but my

Re: [web2py] Re: Truncate Sqlite DB

ecember 3, 2012 8:47:45 PM UTC+1, viniciusban wrote: > >> Do you want a code snippet to clear you database? Try this: >> >>> for t in db.tables: >> >>>db[t].truncate() >> >>>db.commit() >> >> >> >> On Mon, De

[web2py] Re: Truncate Sqlite DB

Can anyone else give my advice on clearing out my database? On Wednesday, November 28, 2012 12:10:13 PM UTC-5, Mike Anson wrote: > > *Database: Sqlite v3.7* > > Hello all, > > I have thousands of test records accumulated through testing my > application. > > Forgive m

[web2py] Re: Querying on 1:M Relationships in SQLFORM.grid and SQLFORM.smartgrid

FYI, I did create an issue for this (#979) in google code. Best, Mike L On Monday, November 26, 2012 3:51:52 PM UTC-5, Adi wrote: > > +1 > > this would be a great and needed feature... just stumbled into this > problem, and working around it :) > > On Friday, August 31,

[web2py] Truncate Sqlite DB

truncate the DB? Cheers, -Mike --

Re: [web2py] Re: Extracting row id from url using request.args

Wow Cliff thank you for this superb bit of info. Like all the best problems it seems glaringly obvious to me now. Thank you everyone for your help. Mike On Wed, Nov 21, 2012 at 2:40 AM, Cliff Kachinske wrote: > It's been a while since I've played with smartgrid, but I seem to

[web2py] Changing Validators for SQLFORM on same table

properly before every SQLFORM. Is there a better way to do this? Is there perhaps some way to reach into the SQLFORM and pull out the fields and their validators? I went spelunking in that code but came up empty-handed. It's pretty dense stuff. Thanks, -Mike --

[web2py] Extracting row id from url using request.args

"Contact Manager") return locals() View Code: {{extend 'layout.html'}} {{if 'view' in request.args:}} Do something with {{=memberId}} Manage Contact{{=form}} {{else:}} Manage Contact{{=form}} {{pass}} Thanks in advance. Mike --

Re: [web2py] Re: DB insert confusion

Thanks very much for your help Niphlod. On Wednesday, 14 November 2012 16:10:35 UTC-5, Niphlod wrote: > > > Yes I understand your point. The reason it is currently like this is >> because if I use your suggestion (which I obviously had originally) >> >> {"id": 1, "method": "savemessage", "params"

Re: [web2py] Re: DB insert confusion

Speediest response as ever Niphlod! Yes I understand your point. The reason it is currently like this is because if I use your suggestion (which I obviously had originally) {"id": 1, "method": "savemessage", "params": { "*message*": "variableholdingmessage", "*uid*" : "variableholdingmail"}} I g

[web2py] DB insert confusion

il@localhost Have I got the script syntax correct? At a push I could live with this except sporadically, even the value of ${message} gets saved as the uid in the DB and visa versa. I can't seem to consistently replicate this behavior. It just does it from time to time. When I print out $message and $uid from my curl script, the values are correct at this point so it has to be the curl script. Can anyone see something I clearly cannot? Thanks in advance. -Mike --

Re: [web2py] OperationalError: database is locked

I do indeed have greater than 3.7 so I'll see if that prevents the locking. So far so good although it was very sporadic and the scheduler ran over 70 times before it crapped out before adding the line you suggested. Thanks again for your responses. -Mike On Wednesday, 14 November 2012

Re: [web2py] OperationalError: database is locked

Hi Vasile, Where would I put this in my script to run it once? Within the script itself say near the db.commit()? Cheers, -Mike On Friday, 9 November 2012 10:33:01 UTC-5, Vasile Ermicioi wrote: > > PS: > it is enough to execute that only once > db.executesql('PRAGMA

Re: [web2py] OperationalError: database is locked

I really appreciate your input Vasile. I will round back on to your advice should Niphlod's advice of separating the scheduler DB and my messaging DB not help me out here. On Friday, 9 November 2012 10:33:01 UTC-5, Vasile Ermicioi wrote: > > PS: > it is enough to execute that only once > db.ex

[web2py] Re: OperationalError: database is locked

table('messages', .) > > from gluon.scheduler import Scheduler > mysched = Scheduler(db2) > > and to queue tasks you can then use > > db2.scheduler_tasks.validate_and_insert() > > or, with the new API > > mysched.queue_task(***) > > > > On

[web2py] OperationalError: database is locked

Greetings... I may have a problem with my database (sqlite) locking. Traceback (most recent call last): File "/home/web2py/src/web2py/gluon/scheduler.py", line 218, in executor result = dumps(_function(*args,**vars)) File "applications/ircmessage/models/tasks.py", line 57, in send_unsent

[web2py] Re: 'id'

So the value of ${message} is saved rather than "mymessage" Many thanks for your time Nyphlod. On Wednesday, 7 November 2012 16:03:08 UTC-5, Niphlod wrote: > > supposedly you have call() and save_message() in default.py > > The url to call the webservice would then be /appnam

[web2py] Re: 'id'

mymessage", "uid" : "myemail@localhost"}}' $url I guess my url is probably incorrect. Cheers again Niphlod. On Wednesday, 7 November 2012 15:16:42 UTC-5, Niphlod wrote: > > Yes, but without that I wouldn't have been able to tell you: "Follow the >

[web2py] Re: 'id'

t; table is there, curl is there, but how about something you coded in the > controller ? Without that we can't help you . > > On Wednesday, November 7, 2012 7:48:28 PM UTC+1, Mike Anson wrote: >> >> >> Greetings... >> >> I have a bash script that uses cURL t

[web2py] 'id'

Greetings... I have a bash script that uses cURL to send a json packet of data in order to save it in sqlite DB. #!/bin/bash message=$1 uid=$2 url="https://somehost"; curl -v -k -X POST -H "Content-Type: application/json" --data "{\"message\": \"This will prbbly be my lst post.\", \"uid\": \"

[web2py] Re: Scheduler conflict

applicationName -X > does what > ./web2py.py -i xxx.xxx.xx.xx -p 8000 -c /etc/ssl/certs/cert-file.crt -k > /etc/ssl/certs/key-file.key -a apassword > and > ./web2py.py -K applicationName > previously did in older versions. > > > On Friday, October 19, 2012 4:55:26 PM UTC+2, Mike

  1   2   3   >