How do I compile web2py application in release mode?
gt; to rebuild metadata. Once done, remove the fake_migrate option.
>
> On Sep 9, 4:19 am,vortex wrote:
>
>
>
>
>
>
>
> > What should be the definition so that web2py only alters the mysql
> > table to correspond to the new definition but if
Can it be a problem with permissions? Does web2py need to create a
database for migration or something?
Because it can create the table just never alters it.
On Sep 12, 11:12 am, vortex wrote:
> I don't understand. I was working with sqlite and it worked OK. Now I
> am using m
ot know it means something is wrong with the
> database metadata and needs rebuilding. You can do
>
> db.define_tables(...,migrate=True,fake_migrate=True)
>
> to rebuild metadata. Once done, remove the fake_migrate option.
>
> On Sep 9, 4:19 am,vortex wrote:
>
>
>
>
>
What should be the definition so that web2py only alters the mysql
table to correspond to the new definition but if it exists not to
create it.
db_server.define_table('db_version',
Field('major', 'integer', default = 0),
Field('minor', 'integer', default
How do I create a remote master database and a replicated local
database with DAL?
Am I allowed to reopen it?
On Feb 16, 4:29 pm, Massimo Di Pierro
wrote:
> Please do so and I will take care.
>
> On Feb 16, 10:16 am, vortex wrote:
>
> > I have made tests and bug of issue 172 seems to be still present in
> > the windows version of the code.
>
>
I have made tests and bug of issue 172 seems to be still present in
the windows version of the code.
I just downloaded and it says: version 1.91.6
Also I think issue 172 is still present in the windows version.
On Feb 16, 3:04 pm, Marin Pranjic wrote:
> I wanted to update from admin app but it gives me neverending "Checking for
> upgrades..."
> Not sure what is the problem, so better to repo
I just downloaded the windows version and I think this issue still
continues in that version.
On Jan 31, 3:22 pm, vortex wrote:
> It has been reported as issue 172.
>
> On Jan 31, 2:56 pm,vortex wrote:
>
> > I will do that now.
>
> > Thanks.
>
> > O
I would like to obtain the filename string from request.vars.xls_file
such as:
filename = request.vars.xls_file
"filename" 'backup_2011-02-08_11h24.xls'
but I get the FieldStorage:
filename = request.vars.xls_file
"filename" FieldStorage: FieldStorage('xls_file',
'backup_2011-02-08_11h
How do I explicitly close a database connection?
Never mind. I think this is due to IS_HEX24 function.
On Feb 4, 10:39 am, vortex wrote:
> I am setting a table column 'code' as Unique. When I insert repeated
> rows it doesn't raise exception.
>
> db.define_table('tag',
> Field('code&#
I am setting a table column 'code' as Unique. When I insert repeated
rows it doesn't raise exception.
db.define_table('tag',
Field('code', 'string', length=24, unique=True, requires=[
IS_HEX24(error_message=err_is_hex24)]),
Field('of_client', 'reference client', requires=IS_IN_D
Is it possible to make the default value of one column the
mathematical result of two other columns?
It has been reported as issue 172.
On Jan 31, 2:56 pm, vortex wrote:
> I will do that now.
>
> Thanks.
>
> On Jan 31, 2:27 pm, Massimo Di Pierro
> wrote:
>
> > You found a bug. What is the model?
>
> > Can you post the model (just relevant field) and th
I will do that now.
Thanks.
On Jan 31, 2:27 pm, Massimo Di Pierro
wrote:
> You found a bug. What is the model?
>
> Can you post the model (just relevant field) and this example as an
> issue in google code. I will fix it asap.
>
> Massimo
>
> On Jan 31, 7:42 am, vortex
More info on this:
the (db.read.of_section != db.item.of_section) part is translating
into:
(rfid_read.of_section IS NOT NULL)
On Jan 31, 1:26 pm, vortex wrote:
> SELECT * FROM item JOIN read on read.of_item=item.id WHERE
> item.of_section <> read.of_section
>
> I tried:
...
>
> Mart :)
>
> On Jan 31, 5:13 am, vortex wrote:
>
> > Let me rephrase my question:
>
> > I need to implement a inventory management system with web2py. Is it
> > practical to have a local web2py database for each store which allows
> > users to read and writ
SELECT * FROM item JOIN read on read.of_item=item.id WHERE
item.of_section <> read.of_section
I tried:
db((db.item.id == db.read.of_of_item) & (db.read.of_section !=
db.item.of_section)).select()
but I don't want a join. I just want the where cause to be:
(db.read.of_section != db.item.of_sectio
Can't find anything about using _extra with DAL in the official web2py
documentation. It seems a very powerful method and I wanted to know
more on how to use it.
Let me rephrase my question:
I need to implement a inventory management system with web2py. Is it
practical to have a local web2py database for each store which allows
users to read and write and then synchronize all the different
databases across the network?
On Jan 28, 2:56 pm, vortex wrote
, DenesL wrote:
> It can be done, but why do you want to do it?.
>
> On Jan 28, 10:42 am, vortex wrote:
>
> > Is it possible to join to tables and create a new table based on this
> > join using only DAL?
>
> > CREATE TABLE newtable AS SELECT ta.key, ta.col1, tb.
Is it possible to join to tables and create a new table based on this
join using only DAL?
CREATE TABLE newtable AS SELECT ta.key, ta.col1, tb.col2 FROM ta
JOIN tb.col1 on (ta.key=tb.key)
Hi,
I would like to implement a system of several databases on for each
store and then have the master database stored at a sever for all
company. Each store can read/write data to the local database and then
synchronize the databases. Or should I enforce read/write only on
master server database
Thank you very much!
On Jan 28, 2:43 pm, Massimo Di Pierro
wrote:
> This is not supported because I am not sure all supported RDBS support
> count(distinct ...).
>
> As a way around it you can do
>
> len(db().select(db.item.of_variant,distinct=True))
>
> Massimo
>
&
How to do a count distinct with DAL?
like:
db().count(db.item.of_variant, distinct=True)
SELECT code FROM tags WHERE code NOT IN (SELECT code FROM tags JOIN
items ON tags.id=items.of_tag);
28 matches
Mail list logo
