there are two issues:
1) this
db(db.devtasklist.projectid == db.Project.id).select(db.Project.ProjectName)
does not do anything as it.
2) this
row.devtasklist.projectid
is an Project object but you do not access its attributes.
SOLUTION II (one extra query per record)
*In views:*
Thank you dave for those answers. I don’t have a lot of time at the moment
to move forward on this as I would like, but I will take your comments into
account as I move forward. I’ll keep you informed.
Thank you again
Arthur!
Le mercredi 17 avril 2019 00:17:25 UTC+2, Dave S a écrit :
>
>
>
> O
On Tuesday, April 16, 2019 at 5:54:54 AM UTC-7, learth...@gmail.com wrote:
>
> Hello,
>
> I'm sorry if I did not post my tests but I’m really beginner with web2py,
> python... and I was a little afraid to look ridiculous.. (Sorry again but
> my English is ridiculous too !!).
>
> First I tried w
On Tuesday, April 16, 2019 at 5:54:54 AM UTC-7, learth...@gmail.com wrote:
>
> [skipping to what caught my eye first]
>
Then I tried to do it by referring to what I found in the web2py manual.
>
> That’s where I am now. This is only for the price but it’s the same for
> the delay.
>
>
>
> pa
Hello,
I'm sorry if I did not post my tests but I’m really beginner with web2py,
python... and I was a little afraid to look ridiculous.. (Sorry again but
my English is ridiculous too !!).
First I tried with Mysql trough MysqlWorkbench and I quickly success to get
the minimum but only for a
On Thursday, April 11, 2019 at 6:48:14 AM UTC-7, learth...@gmail.com wrote:
>
> Hello everybody,
> Nobody can help me to solve my problem ? :(
>
>
> Le vendredi 5 avril 2019 11:42:26 UTC+2, learth...@gmail.com a écrit :
>>
>> Hello everybody.
>>
>> I ask you because I can’t make queries in my da
El jueves, 11 de abril de 2019, 10:48:14 (UTC-3), learth...@gmail.com
escribió:
>
> Hello everybody,
> Nobody can help me to solve my problem ? :(
>
>
If you don't show what effort have you made to try to solve the problem,
basically you are asking that people on the internet do this for you, for
Hello everybody,
Nobody can help me to solve my problem ? :(
Le vendredi 5 avril 2019 11:42:26 UTC+2, learth...@gmail.com a écrit :
>
> Hello everybody.
>
> I ask you because I can’t make queries in my database with the DAL as I
> wish.
>
> Here my context. I have two tables like this:
>
>
>
I had another *.py file as backup in my model folder. I changed the
extension and all is works fine.
thanks for the hint
On Monday, September 3, 2018 at 4:42:07 PM UTC+2, Anthony wrote:
>
> Is it possible you have a second definition of the table that does not
> include the c_total_difference c
Is it possible you have a second definition of the table that does not
include the c_total_difference column?
On Monday, September 3, 2018 at 7:13:26 AM UTC-4, Yebach wrote:
>
> Hello
>
> When I add a field to my db.py I get an error saying field does not exist.
> If I check the sql log file ther
> On top of that the user will be able to add features not there, in a tag
cloud format using string:list (I assume that's the best method for
freeform data of this sort). So for example, you can add tags that say
420-friendly or piano
There's your answer. Forget the 60 boolean fields and just
Thank you, Anthony. I will mull over the computed field idea, which I've
skirted over in my web2py reading. I don't quite understand it & think it's
time to hit the books again.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source
If performance is not likely to be an issue, two list:string fields might
simplify the logic. You could even combine them into a computed field for
easier searching.
Anthony
On Wednesday, May 9, 2018 at 2:52:49 PM UTC-4, Management Backoffice wrote:
>
> App has a venue listing feature. Many boo
I'm assuming other migrations work just fine - is that correct?
If that is the case then I'm thinking it is a problem with foreign keys.
If not that, then I'm stumped.
If it were me, I'd do the following:
1. Make a backup of the database
2. Delete the database
3. Recreate the database with
I changed the signature =True in my "auth.define_tables" which created
extra fields in the auth_user table and after that I am getting this error.
Yes Web2py is installed in /opt directory. This is a production machine.
On Monday, January 22, 2018 at 6:31:44 PM UTC-6, Jim S wrote:
>
> Seems like
On Monday, January 22, 2018 at 5:49:30 PM UTC-6, SR wrote:
>
> When I try to open my Database Administration window I am getting this
> error ticket:
> Error ticket for "cryoem"Ticket ID
>
> 10.51.133.94.2018-01-22.17-44-57.ddaeb556-9bc8-46b4-8dde-99a3c6eee6e7
> (1025, "Error on rename of
> '.
Seems like you might have a permissions error. Are you running web2py as
root?
Looks like web2py is install in the /opt directory. Is this a production
or development machine?
-Jim
On Monday, January 22, 2018 at 5:49:30 PM UTC-6, SR wrote:
>
> When I try to open my Database Administration wi
I'm pretty sure I tried that as well without success...
However, the problem is solved now. Something was wrong with the databases
files (or I was missing something) and also I had comiled files that was
recreating this field whenever I tried to remove it. My solution was
perhaps not so pretty
Using the old version without the column you need both migrate=True and
fake_migrate=True to rebuild the table files.
Then add the new field and fake_migrate=False.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https
Thanks for your reply!
I did as you said and reverted back to a version without the new field,
turned fake_migrate_all on like :
"db = DAL(myconf.get('db.uri'),
pool_size = myconf.get('db.pool_size'),
#migrate_enabled = myconf.get('db.migrate'),
check_rese
Also, I'm assuming you've also read through this:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=migrate#Other-DAL-constructor-parameters
-Jim
On Tuesday, February 7, 2017 at 9:14:54 AM UTC-6, Jim S wrote:
>
> Can you show the migrate options you've tried?
>
Can you show the migrate options you've tried?
I do this all the time with MySQL and it works great.
Another possibility is that it ran through migration already on a different
instance of the database. If so, turn on fake_migrate_all and remove the
column. That should remove it from the file
On Thursday, December 29, 2016 at 4:00:36 AM UTC-8, Nabil Ontour wrote:
>
> Thank you Dave, that fixed it for me, so that I can access the page again.
>
> The table is defined like that:
>
> db.define_table('income',
> Field('description','string',label='Description *'
> ,
Thank you Dave, that fixed it for me, so that I can access the page again.
The table is defined like that:
db.define_table('income',
Field('description','string',label='Description *',
requires=IS_NOT_EMPTY()),
Field('category','reference inc_categories',la
On Wednesday, December 28, 2016 at 6:10:27 PM UTC-8, Nabil Ontour wrote:
>
> Hello,
>
> I can't access my web2py page anymore, as it is showing the following
> error:
>
> month must be in 1..12
>
> Variables
>
> datetime.date
> val '2016-14-12'
> global datetime datetime.x86_64-linux-gnu.so'>
A simple reboot and it unlocked
damned computers
--
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 subsc
uhm. it stays locked no matter what ? sqlite locks the entire db when
writing, so make sure your app is the only one accessing the db...
On Tuesday, November 24, 2015 at 5:54:32 PM UTC+1, Pierre wrote:
>
> Hi everyone,
> I tried to unlock with db.executesql('PRAGMA journal_mode=WAL')
when you fetch fields from different tables, as you highlighted already,
you don't have a resultset holding just columns, you have a dict holding
table that hold fields.
i.e. single table, named "test_table" with 2 fields, "field_1" and
"field_2" will return a structure like
{'field_1': value1
it seems that you updated also the databases folder of your production app
or ... dunno.
I don't see why so many peoples are running into this kind of errors (there
are others intricacies but adding column ISN'T one of them). What DAL does
with migration is pretty documented and understandable.
You can only see and use tables and fields you define in a model file, see
> the web2py book for details.
>
Specifically the Legacy database section:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=legacy#markmin_LegacyDatabases
Pay special attention to
Yes, but it is in python... I would use it as a starting point and
transform it into a web app... But I don't know what you are doing and what
you already have... But what you were talking about seems to me as a pretty
big undertake for a single man!! (but again you maybe not alone).
Richard
On W
One more thing, if you are worried about the speed, you can always cache
the results in memory.
On Tuesday, April 21, 2015 at 10:05:32 AM UTC-5, John wrote:
>
> New to programming and web2py. Been dabbling in web design for a while,
> building sites with wordpress, plugging things in. My first r
Hey John,
Welcome to the community.
I'm not sure I understand your requirements exactly, but here is my
thoughts on a schema:
For the initial MVP, I usually like to keep the amount of tables to a
minimum, then as I figure out the common queries I can separate them out
into multiple tables.
F
Gramps is a desktop program for building a family tree. We have a web based
version that we're fine with although I'd like to tie it into the actual
site sometime for joint login purposes. This other part of the site is the
individual transcriptions of old records. The data you would reference/c
I would say postgresql is better than MySQL, not just web2py but for
everything.
--
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 messag
granma said : 'everything is wonthefull if you know how to appreciate it'
everything has a good side n bad side, imho better is which database you
familiar n comfortable with, then please use it.
best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
For the first question, you can create either a field that's computed or a
virtual field. For the second question, yes, you can create a
Field.Method('age_group', lambda row: ...))
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Sour
If you use the latest web2py there is this code on
welcome/controllers/default.py
@auth.requires_login()
def api():
"""
this is example of API with access control
Now somebody tries that with Django. ;-)
On Tuesday, 29 July 2014 08:33:58 UTC-5, Ruud Schroen wrote:
>
> That was indeed easy. Thanks!
>
>
> On Tue, Jul 29, 2014 at 3:31 PM, Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> very easy:
>>
>> if request.env.host_name == 'domain1': db_ur
That was indeed easy. Thanks!
On Tue, Jul 29, 2014 at 3:31 PM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> very easy:
>
> if request.env.host_name == 'domain1': db_uri='sqlite://domain1.db'
> elif request.env.host_name == 'domain2': db_uri='sqlite://domain2.db'
> else: raise HTTP(40
very easy:
if request.env.host_name == 'domain1': db_uri='sqlite://domain1.db'
elif request.env.host_name == 'domain2': db_uri='sqlite://domain2.db'
else: raise HTTP(404)
db = DAL(db_uri)
On Tuesday, 29 July 2014 07:23:03 UTC-5, Ruud Schroen wrote:
>
> Hi list,
>
> I'm working on a portal where
~cd.value.contains(filter_value_inc, all=False)
~ = NOT
On Thursday, 26 June 2014 09:52:02 UTC-5, Douglas Campbell wrote:
>
> Hello,
>
> I am trying to filter out specific values in an SQLFORM.grid but I can not
> figure out how to do this in the Query. Right now I have something like:
>
>
On Monday, April 14, 2014 11:10:28 AM UTC-4, horridohobbyist wrote:
>
> Sonovagun, you're right! But that rather diminishes the usefulness of
> 'compute', IMO.
>
Yes, though I suppose the alternative would add a lot of complexity (and
potentially inefficiency). Maybe at least when .update_record
Sonovagun, you're right! But that rather diminishes the usefulness of
'compute', IMO.
On Monday, 14 April 2014 08:15:14 UTC-4, Anthony wrote:
>
> Yes, otherwise the DAL would have to do a db query to retrieve all the
> records being updated and issue a separate update for each record (since
>
Yes, otherwise the DAL would have to do a db query to retrieve all the
records being updated and issue a separate update for each record (since
they may not all have the same price value and therefore might require
different updated values in the computed field).
On Monday, April 14, 2014 7:09:
Are you saying I have to update the price field, regardless of whether it
has changed or not?? That's not very logical.
On Sunday, 13 April 2014 18:39:51 UTC-4, Anthony wrote:
>
> I believe you have to provide the price field in your update as well.
--
Resources:
- http://web2py.com
- http://w
now, i know the reason why, thank you so much for your explaination,
niphlod.
best regards,
stifan
On Wednesday, April 9, 2014 4:49:26 AM UTC+7, Niphlod wrote:
>
>
>
> On Tuesday, April 8, 2014 2:44:52 PM UTC+2, 黄祥 wrote:
>>
>> hi,
>>
>> consider this :
>> # e.g. 1 work
>> for row in db(db.prod
On Tuesday, April 8, 2014 2:44:52 PM UTC+2, 黄祥 wrote:
>
> hi,
>
> consider this :
> # e.g. 1 work
> for row in db(db.product).select():
> print row.rack.branch
> # e.g. 2 not work
> print db(db.product.rack.branch == 1).select()
>
> is it possible to have the example 2 work?
>
no, you can't.
d
John Resig wrote a 'prettydate' that is probably what he wants...
http://ejohn.org/blog/javascript-pretty-date/
On Wednesday, April 10, 2013 7:31:35 AM UTC-7, Niphlod wrote:
>
> I did say "see it" prettydate as it is takes a date and calculates
> automatically the timedelta to "now".
>
>
On Wednesday, April 10, 2013 7:31:35 AM UTC-7, Niphlod wrote:
>
> I did say "see it" prettydate as it is takes a date and calculates
> automatically the timedelta to "now".
>
> You need to have your own prettydate to be able to pass a timedelta of
> your own.
>
>
If you've got a datetime.
hi,
consider this :
# e.g. 1 work
for row in db(db.product).select():
print row.rack.branch
# e.g. 2 not work
print db(db.product.rack.branch == 1).select()
is it possible to have the example 2 work?
thanks and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (D
I can't point you to any, you are welcome to do tests yourself. (note: this
is why i said "believe it or not")
On Thursday, March 20, 2014 6:22:20 AM UTC-7, Cliff Kachinske wrote:
>
> Derek, the conventional wisdom is connecting to a db is expensive.
>
> I'm willing to be convinced, but I need so
Derek, the conventional wisdom is connecting to a db is expensive.
I'm willing to be convinced, but I need some data. Can you point me to some?
Because if your statement is true, we could eliminate some pretty hairy
code in the DAL to support pooling.
On Wednesday, March 19, 2014 7:44:10 PM UTC
I'd say the answer to 2 is 'not really'. Believe it or not, opening and
dropping database connections is a fast operation.
On Tuesday, March 18, 2014 11:33:04 PM UTC-7, tec...@gmail.com wrote:
>
> Dear Sirs,
>
>
> I understand it's possible to use databases without DAL.
> For example function in
Well, if you want to do it without the DAL, there are several options that
might just work without any additional code:
- check if specific python libs that you'll use for the db connection
already provide a similar pooling function, they might
- check if the database backend natively provides su
Hello Massimo,
Thank you for reply.
On Wednesday, March 19, 2014 7:20:27 PM UTC+5, Massimo Di Pierro wrote:
>
> I am not sure about pymongo but if you use
>
> DAL('mongodb:')
>
> the dal will do pooling for you.
>
Ok, I will check this.
Actually I don't want to use pymongo only, it could a
I am not sure about pymongo but if you use
DAL('mongodb:')
the dal will do pooling for you.
On Wednesday, 19 March 2014 01:33:04 UTC-5, tec...@gmail.com wrote:
>
> Dear Sirs,
>
>
> I understand it's possible to use databases without DAL.
> For example function in controller:
>
> def values(
any idea why this happens? or there is a limitation on bulk_insert and the
database callback.
thanks and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list
>
> Does this need the original validator to have been defined as a list to
> work?
>
it depend, wheter you need 1 validator or more than 1 validator, if more
than 1 validator please use list of validators [].
> db.table.field.requires = first_validator
>
use it if you only need 1 validator
Does this need the original validator to have been defined as a list to
work?
Is there a difference between
db.table.field.requires = first_validator
and
db.table.field.requires = [first_validator]
Does your append code work in either case? If there is a difference, when
you declare a field
db.table.field.requires.append(what_you_need)
On Wednesday, November 13, 2013 6:43:38 AM UTC+1, User wrote:
>
> So since a time field automatically has an IS_TIME validator how would you
> specify additional validators after the db.define_table statement?
>
> On Tuesday, November 12, 2013 3:51:12
So since a time field automatically has an IS_TIME validator how would you
specify additional validators after the db.define_table statement?
On Tuesday, November 12, 2013 3:51:12 AM UTC-5, Niphlod wrote:
>
> requires can be a list of validators.
>
> On Tuesday, November 12, 2013 9:32:27 AM U
requires can be a list of validators.
On Tuesday, November 12, 2013 9:32:27 AM UTC+1, User wrote:
>
> Just realized I added the following lines after my db.define_table
> statement:
>
> db.sometable.start_time.notnull = True
> db.sometable.start_time.requires = IS_NOT_EMPTY()
>
>
> I'm th
Just realized I added the following lines after my db.define_table
statement:
db.sometable.start_time.notnull = True
db.sometable.start_time.requires = IS_NOT_EMPTY()
I'm thinking that my assignment of IS_NOT_EMPTY() overwrote the default
IS_TIME() validator associated with time fields. Doe
I cannot reproduce this.
On Friday, 11 October 2013 09:03:00 UTC-5, Michele Comitini wrote:
>
> I have same problem it must be ipython 1.0.0...
>
> https://code.google.com/p/web2py/issues/detail?id=1710&start=100
>
>
>
>
> 2013/10/11 Tim Richardson >
>
>> work for me, python 2.7.5, ipython 1.1 on
I have same problem it must be ipython 1.0.0...
https://code.google.com/p/web2py/issues/detail?id=1710&start=100
2013/10/11 Tim Richardson
> work for me, python 2.7.5, ipython 1.1 on OS X
>
>
> On Friday, 11 October 2013 13:16:17 UTC+11, Mark Li wrote:
>>
>> I recently upgraded to the new ve
work for me, python 2.7.5, ipython 1.1 on OS X
On Friday, 11 October 2013 13:16:17 UTC+11, Mark Li wrote:
>
> I recently upgraded to the new version of web2py from 2.5 (on
> Pythonanywhere); everything seems to work fine except for the interactive
> shell.
>
> Using the command "python web2py.py
On Monday, August 12, 2013 4:37:08 AM UTC-4, sasogeek wrote:
> how do i explicitly update the auth.user.money?
> I thought that's what I did here "...{'money':auth.user.money+100}..."
>
No, your code updates the db.auth_user record *in the database*. auth.user
is just an attribute of the auth ob
how do i explicitly update the auth.user.money?
I thought that's what I did here "...{'money':auth.user.money+100}..."
On Sunday, 11 August 2013 17:54:14 UTC+1, Anthony wrote:
>
> Upon login, the auth.user object is stored in the session and is not
> updated again until next login (i.e., updating
Upon login, the auth.user object is stored in the session and is not
updated again until next login (i.e., updating the db.auth_user record does
not update auth.user). So, you'll have to explicitly update auth.user.money
as well.
Anthony
On Sunday, August 11, 2013 12:42:45 PM UTC-4, sasogeek w
because datetime.datetime.now() is NOT deterministic every time you
call it, it replies with the current time.
What do you need specifically ?
On Thursday, August 1, 2013 1:56:48 PM UTC+2, Apoorve Mohan wrote:
>
>
> Hello
>
> I am storing datetime.datetime.now() as default value of an attribu
wow!! many many thanks.. :)
On Tue, Jul 2, 2013 at 10:15 AM, Anthony wrote:
> You left out some critical code from the original question -- your
> Javascript sends each post request twice:
>
> function send_data(id){
> $.post("{{=URL('contest','flip_contest_status')}}", {id: id} );
>
You left out some critical code from the original question -- your
Javascript sends each post request twice:
function send_data(id){
$.post("{{=URL('contest','flip_contest_status')}}", {id: id} );
$.post("{{=URL('contest','flip_contest_status')}}", {id: id} )
.done
here is the database definition:
db.define_table('contest', Field('name', length=128 ),
Field('contest_host', length=128,), Field('duration', 'time' ),
Field('time_passed','time', default = 0), Field('rank_frozen','time',
default = 0), Field('running',length= 10, readable=False, default = "no"),
F
Can you show the code you are now using and describe the workflow of how
the record gets updated and how you are then attempting to view the updated
record?
Anthony
On Monday, July 1, 2013 8:37:32 PM UTC-4, Ahmad Faiyaz wrote:
> weird things happening, when i check the db table with appadmin,
weird things happening, when i check the db table with appadmin, it shows
for contest.running = yes [ updated the value with sqlform.grid ] , but
when i fetch the row with DAL on app, it shows contest.running = no [ which
is the default ]
why ?
On Tue, Jul 2, 2013 at 6:18 AM, Ahmad Faiyaz wrote:
thanks, but it sometimes work, sometimes doesn't !! what can be the problem
!
On Tue, Jul 2, 2013 at 5:34 AM, Alex wrote:
> from the documentation:
> update_record should not be confused with
> >>> row.update(name='Curt')
> because for a single row, the method update updates the row object but n
from the documentation:
update_record should not be confused with
>>> row.update(name='Curt')
because for a single row, the method update updates the row object but not
the database record, as in the case of update_record
so you should use update_record instead. or even better:
db(db.contest.id =
I grabbed SQLite Manager firefox extension, did an integrity check,
restarted web2py and message was no longer there..Phew..thanks.
On Wednesday, June 26, 2013 2:05:06 PM UTC-7, Niphlod wrote:
>
> whoopsie. If that is indeed web2py's sqlite database, follow these steps
>
>
> http://techblog.do
whoopsie. If that is indeed web2py's sqlite database, follow these steps
http://techblog.dorogin.com/2011/05/sqliteexception-database-disk-image-is.html
On Wednesday, June 26, 2013 11:01:47 PM UTC+2, Niphlod wrote:
>
> sure that is web2py's database ?
> That message is usually outputted when yum
sure that is web2py's database ?
That message is usually outputted when yum (the package manager) database
has something wrong in it.
On Wednesday, June 26, 2013 10:53:25 PM UTC+2, greenpoise wrote:
>
> The DB still works but I can see that in my terminal. Just noticed it. Is
> this normal?
--
Just got email from a PA developer saying they're hoping to have Postgres
9.2 out next month. Good news!
On Tue, May 28, 2013 at 8:23 AM, Cliff Kachinske wrote:
> They [PythonAnywhere] list Psycopg2 among the installed gadgets. This
> will definitely push me in their direction.
--
---
You
They list Psycopg2 among the installed gadgets. This will definitely push
me in their direction.
On Monday, May 27, 2013 9:08:30 PM UTC-4, Monte Milanuk wrote:
>
> On 05/27/2013 09:29 AM, Ricardo C�rdenas wrote:
> >
> > PythonAnywhere is a terrific option; I'm a bit surprised they don't
>
On 05/27/2013 09:29 AM, Ricardo Cárdenas wrote:
PythonAnywhere is a terrific option; I'm a bit surprised they don't
offer Postgres. Maybe someone with influence on the PythonAnywhere folks
can give them a nudge? Could push many projects their way.
I've been following their 'forum' for a littl
I can't give you any specifics right now as I haven't done any migrations
in a long time but the next time I come across what I think to be a bug
I'll be sure to post here.
It'll be really great if we can fix those glitches.
On Sun, May 26, 2013 at 8:38 PM, Massimo Di Pierro <
massimo.dipie...@g
Can you tell us more. I believe firebird does not support multiple alter
tables in transaction and that is cause of some problems. Make sure you
always mgrate one table at the time.
On Sunday, 26 May 2013 06:24:49 UTC-5, Alexei Vinidiktov wrote:
>
> I use Firebird with web2py but I often have pr
I use Firebird with web2py but I often have problems migrating db schemas
because of incorrect sql migration scripts that web2py issues.
On Sat, Mar 9, 2013 at 1:04 AM, pjag wrote:
> web2py works nicely with Firebird DB. Highly recommended.
>
>
> On Thursday, March 7, 2013 3:41:18 PM UTC-5, Bl
there's no functionality to write triggers . They're too much dependant
(syntax-wise) on the db backend.
But, web2py exposes some nice callbacks that can deal with most of the
corner-cases where you'd need a database triggers
http://web2py.com/books/default/chapter/29/06#before-and-after-callbac
I did say "see it" prettydate as it is takes a date and calculates
automatically the timedelta to "now".
You need to have your own prettydate to be able to pass a timedelta of your
own.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" gro
when i tried to using prettydate it return [invalid date]
e.g.
*from gluon.tools import prettydate*
def __onvalidation_check_out(form):
if form.vars.check_in:
rows = db(db.check_in.id==form.vars.check_in).select()
for row in rows:
form.vars.room = row.room
check prettydate
http://web2py.com/books/default/chapter/29/14?search=prettydate
On Wednesday, April 10, 2013 3:45:19 PM UTC+2, 黄祥 wrote:
>
> brilliant, very simple solution, it's work now.
> thank you so much for your solution and suggestion, massimo
> i've followed your hints and make it on my
brilliant, very simple solution, it's work now.
thank you so much for your solution and suggestion, massimo
i've followed your hints and make it on my controller :
def __onvalidation_check_out(form):
if form.vars.check_in:
rows = db(db.check_in.id==form.vars.check_in).select()
f
PS. Anyway, I would copy the price into check_in and check_out tables. I
know this is redundant but in any hotel you will have to handle discounts
for each individual client (to handle complaints, friends, etc.) This will
give you flexibility and make it faster.
On Wednesday, 10 April 2013 08:1
check_in = db.check_in[id]
print check_in.room.category.price
On Wednesday, 10 April 2013 04:38:08 UTC-5, 黄祥 wrote:
>
> hi folks,
>
> i want to get the value of table row that have 3 nested values. my goal is
> to get the price value from table room_category from function check_out in
> my cont
sorry the table for check out is
db.define_table('check_out',
Field('check_in', 'reference check_in'),
Field('room'),
Field('guest'),
Field('description', 'text'),
Field('duration'),
format='%(guest)s %(room)s')
i extract the room and guest value from check_in table and in
2013/4/7 vince
> from my experience if u running web2py on apache with mod_wsgi u will get
> database locked more often than running web2py alone with it's buildin
> webserver.
web2py + apache + mod_wsgi is my configuration.
ok, I will try the internal webserver.
>
> u should also avoid using
from my experience if u running web2py on apache with mod_wsgi u will get
database locked more often than running web2py alone with it's buildin
webserver.
u should also avoid using session on sqlite database.
On Saturday, April 6, 2013 11:14:16 PM UTC+8, BlueShadow wrote:
>
> I know that I wi
If I would change from SQlite to another system, what do you propose?
2013/4/6 BlueShadow
> [(u'wal',)]thats what the db.executesql("PRAGMA journal_mode") returns. :(
> I guess I have to migrate faster.
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
[(u'wal',)]thats what the db.executesql("PRAGMA journal_mode") returns. :(
I guess I have to migrate faster.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
this statement
PRAGMA journal_mode
returns the current journal mode. By default should return "delete", while
if the db is in WAL mode, it returns "wal"
On Saturday, April 6, 2013 5:11:16 PM UTC+2, BlueShadow wrote:
>
> How can I test if wal is enabled?
>
> On Saturday, April 6, 2013 3:54:10 P
1 - 100 of 301 matches
Mail list logo
