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 me for not taking the advice
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, Dec 3, 2012 at 5:17 PM, Mike Anson mojor...@gmail.com wrote:
Can anyone else give my advice on clearing out my database
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 problems could
have arisen from not having migrations
*Database: Sqlite v3.7*
Hello all,
I have thousands of test records accumulated through testing my application.
Forgive me for not taking the advice previously posted on here about
truncating tables in my database. I ran in to all sorts of problems when I
simply deleted the contents of the
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
Greetings.
I have some strange behavior when saving to my DB.
Here is my DB schemer:
db.define_table('messages',
Field https://apps00.cs.lldns.net:8000/examples/global/vars/Field('uid',
'string'),
Field
https://apps00.cs.lldns.net:8000/examples/global/vars/Field('message',
'text'),
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 get message and
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: { *message*:
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 journal_mode=WAL')
then
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
)
and to queue tasks you can then use
db2.scheduler_tasks.validate_and_insert()
or, with the new API
mysched.queue_task(***)
On Friday, November 9, 2012 3:56:59 PM UTC+1, Mike Anson wrote:
Greetings...
I may have a problem with my database (sqlite) locking.
Traceback (most recent call
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
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\:
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 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
Thanks very much Niphlod. I am much closer now..
However I am getting this response:
{version: 1.1, id: 1, error: {message: method \save_message\
does not exist, code: 100, name: JSONRPCError}}
from this script:
url=https://domain.net:8000/ircmessage/rpc/call/jsonrpc;
curl -v -k -X POST -H
UTC-5, Niphlod wrote:
supposedly you have call() and save_message() in default.py
The url to call the webservice would then be /appname/default/call/jsonrpc
.
On Wednesday, November 7, 2012 9:31:51 PM UTC+1, Mike Anson wrote:
Thanks very much Niphlod. I am much closer now..
However I am
I upgraded to the newest web2py (2.1.1)
Launch it with:
./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 -K applicationName
When I run the -K application (ie scheduler) I am then unable to access the
admin or front end of the
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 Anson wrote:
I upgraded to the newest web2py (2.1.1)
Launch
I would like to have posted my question right here but with I was unable to
post it perhaps due to character count of the question being +800
So I posted it on
Stackoverflowhttp://stackoverflow.com/questions/12960138/web2py-cron-task-debug
.
Any help would be greatly appreciated.
--
Hey Massimo,
Where should we make this change. Not in web2py.egg-info/top_level.txt as I
can see this gets overwritten somewhere else.
Thanks.
On Tuesday, 4 September 2012 08:04:59 UTC-4, Massimo Di Pierro wrote:
The package was renamed fpdf
On Monday, 3 September 2012 23:38:10 UTC-5, Joe
edit setup.py line #59
from: $ gluon/contrib/pyfpdf
to: $ gluon/contrib/fpdf
Then run python setup.py install again
On Tuesday, 4 September 2012 00:38:10 UTC-4, Joe Repka wrote:
I tried 'python setup.py install' in the downloaded source directory for
2.0.6 but got
'error: package
21 matches
Mail list logo
