problem solved by using
rows = db.executesql(db(db.mytable.id0)._select(db.mytable.myfield,
db.mytable.id))
seems time is going to 0 ms
It's some hard to coding without dictionaries, but really much faster
for big massive of data
On 7 фев, 12:24, LightOfMooN vladsale...@yandex.ru wrote:
Hi
Just
On 7 February 2012 09:27, Bruce Wade bruce.w...@gmail.com wrote:
You are using a for loop with 10 inserts it is the for loop holding
you up not web2py. Plus who in their right mind would code something like
that in production
I understood him differently: the result of query after the
You should be using paging there is no point in query that much data at
once you could never visually display it
On Feb 6, 2012 11:36 PM, LightOfMooN vladsale...@yandex.ru wrote:
I'm using loop for 10 inserts just one time to insert 100k records
in database.
All next time I just try to get
I am having the same interest...
On Jan 19, 3:02 am, António Ramos ramstei...@gmail.com wrote:
is it dificult to do something like this in web2py?
http://blog.aizatto.com/2009/12/07/ruby-on-rails-finite-state-machine...
Sebastian,
Use mmap, or some wrapper around it. It does what you need, the work
is done by the O.S. It allows you to manage any size of buffer, even
16GB provided that your OS supports it. mmap is the underlying
mechanism used by almost any implementation that has to deal with
shared memory
Yes its known behaviour because using standard DAL query the system has to
convert every line into Python object, which is really time consuming for
100K documents.
Hello crowd!
I'm relatively new to web2py and being impressed with its feature set
to build our intranet apps I am currently through my way into reading
docs. However some major questions to common functionality we
currently use popped up which I could not find answers to in
documentation, it
You can use bulkinsert to insert huge amount of records, yes is fast. Also
if you are doing long time task, you can use scheduler, to schedule your
task, if you need to inform to the client browser you can use tornado ,
there are an example using with web2py out there, or reload the page after
5
You can use a multi-threaded webserver, permanently importing the data in
a module.
Also, you could use multiprocessing python module listener/client to do
basic RPC between the web process and a parallel process handling the data.
Best regards,
Mariano Reingart
http://www.sistemasagiles.com.ar
I can tell my experience, I'm working for 2 years with web2py or more I
think. I work in different projects, one I currently developing I think is
quite big, work with millons of records, and is very complex and has many
lines of code and many tables, is an internal application for a national
I did as you suggested (sent a request with the forum web interface)
and after some days my email digests are back.
Thanks
On 30 ene, 12:18, Anthony abasta...@gmail.com wrote:
If you view the group via the forum interface
(https://groups.google.com/forum/?fromgroups#!forum/web2py), at the far
I've gotten web2py working on my webfaction account with admin using
an https site pointing to the webapp and changing the
parameters_xxx.py file to the port that the web app should be using.
So now I have a regular site and a https site pointing to the port
that the app uses. I don't think wf
I just updated latest.
I see this.
S'Traceback (most recent call last):\n File
/apps/www/web2py.trunk/gluon/restricted.py, line 204, in
restricted\nexec ccode in environment\n File
/apps/www/web2py.trunk/applications/app/controllers/default.py, line
348, in module\n File
Hi Niphlod,
This is amazing - The below code did the trick. I am thrilled
with these settings. I need to go back and do my homework right (study
the web2py book with new features) - Also need to learn new database
skills, I agree with you completely that leaving joins to db or rather
the
On Tue, Feb 7, 2012 at 7:08 AM, amiroff amir...@gmail.com wrote:
Hello crowd!
I'm relatively new to web2py and being impressed with its feature set
to build our intranet apps I am currently through my way into reading
docs. However some major questions to common functionality we
currently
It was me.
Sorry :)
On 2/7/12 6:53 AM, David wrote:
I just updated latest.
I see this.
S'Traceback (most recent call last):\n File
/apps/www/web2py.trunk/gluon/restricted.py, line 204, in
restricted\nexec ccode in environment\n File
Johann, there were no views in the example.
On Tue, Feb 7, 2012 at 6:35 AM, Johann Spies johann.sp...@gmail.com wrote:
On 7 February 2012 09:27, Bruce Wade bruce.w...@gmail.com wrote:
You are using a for loop with 10 inserts it is the for loop holding
you up not web2py. Plus who in their
I haven't heard of them before, but I have learned a quick lesson about VPS
providers: most of them are one-man operations that only last for a few
months. I have done a LOT of research on VPS providers over the last couple
of weeks and the one site I always end up turning to for advice on
no problem, as web2py borns with an educational angle, someone will
always help you in this group.
I for myself learned a lot just kidding with the framework.
Bye.
Yes, David. That's a point.
But, I'd like to say if somebody needs to retrieve 100k lines through
a single query in an online application, something sounds bad.
I'm used to work on tables with millions rows. If you don't elaborate
a good queries and indexes to minimize traffic between db server
Ok, I was a little unclear. There's no need to change any regex in DAL
code.
Let's say we have a database named bbb, on localhost, port 5432, username
hello and password password.
DB URI will be : postgres://hello:password@localhost:5432/bbb
Now, the decode_credential part. With the regex,
PS : final DAL initiation code is
db = DAL('postgres://hello:p%40ssword@localhost:5432/bbb',
decode_credentials=True)
oh yeah, I tested it :D
Now I'm planning a move towards running uwsgi in emperor mode and keeping
the emperor process alive and kicking with upstart
http://projects.unbit.it/uwsgi/wiki/Emperor
Summary : Just point the emperor to a folder with config files, it thinks
at all the rest.
Same problem here. Using both Firefox 9.0.1 and IE 8 on Windows 7 work
PC behind a firewall. Cookies are enabled. Cache cleared. I'm seeing
the same loop as Wikus describes. Initially I thought the demo site
was down till I saw this thread...
Going directly to
Good day
Using the classic web2py db example - dogs and owners and implementing
a many-to-many relationship using a table we'll call dog_owners, I'd
like to know how to always link to a specific dog / owner when viewing
the dog_owners table using smartgrid?
E.g. viewing the dog_owners table -
Hi
I need to setup a prototype for a web application which will expose a REST
api to manage zipped sqlite db files, representing a mobile application
project storage. I'm considering web2py because it seems agile and very
well suited, but I would like to know if its batteries included can
This made the news it italy:
http://www.repubblica.it/tecnologia/2012/02/05/news/hacker_anti_corruzione-29393382/
Repubblica is the main national newspaper.
Congratulations to the authors!
Massimo
On Feb 6, 11:34 pm, guruyaya guruy...@gmail.com wrote:
This is beutiful. Just beutiful
On Feb
I need this too.
On Feb 7, 2:56 am, Ashraf Mansour ad...@aqar-riyadh.com wrote:
I am having the same interest...
On Jan 19, 3:02 am, António Ramos ramstei...@gmail.com wrote:
is it dificult to do something like this in web2py?
Let me understand you setup. Do you use a wf proxy and run web2py
locally? Can you access admin both from http and https? If you access
your app remotely, can you print {{=request.client}}, do you get
localhost or 127.0.0.1?
The problem with proxies is that web2py cannot reliably determine
Are you using trunk or stable. I believe there was an optimization in
trunk in this respect but it was not benchmarks. I would like to know
if it makes things better or worse in your case.
On Feb 7, 7:54 am, Vinicius Assef vinicius...@gmail.com wrote:
Yes, David. That's a point.
But, I'd like
Interrested too!
Richard
On Tue, Feb 7, 2012 at 9:38 AM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
I need this too.
On Feb 7, 2:56 am, Ashraf Mansour ad...@aqar-riyadh.com wrote:
I am having the same interest...
On Jan 19, 3:02 am, António Ramos ramstei...@gmail.com wrote:
+1 I would like to have it, lets start coding?
http://zerp.ly/rochacbruno
Em 18/01/2012 22:02, António Ramos ramstei...@gmail.com escreveu:
is it dificult to do something like this in web2py?
http://blog.aizatto.com/2009/12/07/ruby-on-rails-finite-state-machine-plugin-workflow/
It will work if you have values inside the IS_IN_SET validators in
your controller, e.g.
IS_IN_SET([1,2,3,4],multiple='multiple')
Hello,
I have attached the screenshot of the page rendered, and there is some
debugging information.
How can I disable it?
regards
Praveen
attachment: 1.JPG
You are using generic views.
Better to create your own views.
But, if you want to disabled that, you need to edit the views/generic.html
and remove the {{=response.toolbar()}}
On Tue, Feb 7, 2012 at 1:05 PM, Praveen Bhat praveenbha...@gmail.comwrote:
Hello,
I have attached the screenshot of
Removing {{=response.toolbar()}} just prevents it from showing, or does it
actually disable it from being called in the background and assigned to the
response object?
On Tue, Feb 7, 2012 at 7:25 AM, Bruno Rocha rochacbr...@gmail.com wrote:
You are using generic views.
Better to create your
Thank you,
Would there be any harm in adding environ['QUERY_STRING'] httpserver.log as
a change in your main.py source code ? This would solve my issue and
perhaps help others by giving a little more detail in the logs which for
REST type applications will be very useful.
One line added and
Hi all,
I'm starting a new project in which I'm using Postgresql, but I have
some problems.
I have defined a couple of tables in models/db.py. I can see and
manipulate those tables through web2py's admin interface, but when I
try to use DAL I'm facing some problems. I can connect without
problem,
python web2py/web2py.py -S courier
add -M
python web2py/web2py.py -S courier -M
mic
2012/2/7 Calycé welcome.to.dev.n...@gmail.com:
Hi all,
I'm starting a new project in which I'm using Postgresql, but I have
some problems.
I have defined a couple of tables in models/db.py. I can see and
Just tried it - same results.
FYI, I'm only using the interactive python shell to illustrate the
problem I face I my app...
On Feb 7, 4:56 pm, Michele Comitini michele.comit...@gmail.com
wrote:
python web2py/web2py.py -S courier
add -M
python web2py/web2py.py -S courier -M
mic
2012/2/7
Hello,
I would like to know if there is a way in web2py to have virtual
table (mean subset of columns from a existing table) access
controlled with the web2py built-in RBAC ??
I mean I have to denormalize to improve speed of an app that use to
have many table that are all using the same pattern.
What do you expect to see in db.tables?
Tables defined in model(s) or tables on database?
On Tue, Feb 7, 2012 at 5:03 PM, Calycé welcome.to.dev.n...@gmail.comwrote:
Just tried it - same results.
FYI, I'm only using the interactive python shell to illustrate the
problem I face I my app...
check the GAE data console (locally for me that is at
127.0.0.1:8080/_ah/admin/datastore) and see what the datatype of of the
image is and how much data is stored. i thought that a blob type could be
up to 1MB.
for what it's worth, i use blobstore to store my images (does not have the
1mb
May be web2py need a password to be define to acces model in shell??
So use -a parameter to set a pwd here my start command, notice I am not
sure but have auto after the -M that maybe required?? :
python web2py.py -a '12345' -i 127.0.0.1 -p 8001 -S apllication_name -M
auto'
Richard
On Tue,
Excellent piece of information Ross! Thank you very much!
On Tue, Feb 7, 2012 at 11:11 AM, Ross Peoples ross.peop...@gmail.comwrote:
I haven't heard of them before, but I have learned a quick lesson about
VPS providers: most of them are one-man operations that only last for a few
months. I
Hi, By the end of the week I will release Movuca Social CMS Beta 0.1
(for release I just need to finish installation page, admin dashboard and
web2py scheduler notification worker)
But, I want to hear your feedback about it!
*Main Changes:*
- Now it defaults to bootstrap theme (but basic the is
This library is small and easy to use:
http://www.hforge.org/itools/docs/workflow/
Hello Bruce,
Thanks for your quick reply.
But I do not find any generic.html view file as I am using the Windows
Webpy.
Regards,
Praveen
On Tue, Feb 7, 2012 at 9:01 PM, Bruce Wade bruce.w...@gmail.com wrote:
Removing {{=response.toolbar()}} just prevents it from showing, or does it
actually
I know it in french, I didn't find it in english :
http://fr.wikipedia.org/wiki/Liste_des_moteurs_de_workflow
And what about XPDL? http://en.wikipedia.org/wiki/XPDL
Richard
On Tue, Feb 7, 2012 at 11:27 AM, omicron jacques.bouss...@gmail.com wrote:
This library is small and easy to use:
- License changed to AGPL3 (Gnu Afferro GPL)
If I understand AGPL3 correctly, if someone deploys Movuca on a server,
they will be required to allow all users of their website to download the
entire source code of the site, including any customizations they make to
the Movuca code in order
There is only ONE week left for submissions.
If you plan to submit an application for the Web2py Application
Exhibition, please send me an e-mail indicating your interest so I can
have an idea of how many submissions to expect.
Thanks!
Mr.NetAdmn
On Tue, Feb 7, 2012 at 2:56 PM, Anthony abasta...@gmail.com wrote:
- License changed to AGPL3 (Gnu Afferro GPL)
If I understand AGPL3 correctly, if someone deploys Movuca on a server,
they will be required to allow all users of their website to download the
entire source code of the site,
On Tuesday, February 7, 2012 11:32:21 AM UTC-5, Praveen Bhat wrote:
Hello Bruce,
Thanks for your quick reply.
But I do not find any generic.html view file as I am using the Windows
Webpy.
generic.html should be in /web2py/application/your_app/views (even in the
Windows distribution).
On Tuesday, February 7, 2012 10:31:39 AM UTC-5, Detectedstealth wrote:
Removing {{=response.toolbar()}} just prevents it from showing, or does it
actually disable it from being called in the background and assigned to the
response object?
.toolbar() is a method that is called to generate
Massimo, if this question was to me, I don't face this situation with
web2py yet.
This is my experience, no matter what tools I use.
--
Vinicius Assef
On Tue, Feb 7, 2012 at 12:51 PM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
Are you using trunk or stable. I believe there was an
I agree with Anthony, I think this type of license will limit the adoption
greatly. Honestly I probably wont even look at the code now, not because I
wasn't interested. Instead because 99% of my clients require to keep the
code that makes their system unique and profitable.
--
Regards,
Bruce
On
Finally got it to work...
There was a problem with the init of DTs particularly this option :
http://datatables.net/release-datatables/extras/FixedColumns/server-side-processing.html
*fnInitComplete*
*
*
*
*
It's not solving my speed problem as I expect it could do... So I will put
it on hold,
On Tue, Feb 7, 2012 at 3:15 PM, Bruce Wade bruce.w...@gmail.com wrote:
I agree with Anthony, I think this type of license will limit the adoption
greatly. Honestly I probably wont even look at the code now, not because I
wasn't interested. Instead because 99% of my clients require to keep the
Just tried it - same results.
FYI, I'm only using the interactive python shell to illustrate the
problem I face I my app...
When you use the -M option to load your models, are you then still doing
this in your shell session:
db = DAL('postgres://postgres:@localhost/courier')
The magic keyword is distribute, both the GPL and LGPL would
prevent proprietary closed forks (binary only releases).
But, if you want that every site that uses your app would have to publish
the source code, AGPL.
Best regards
Mariano Reingart
http://www.sistemasagiles.com.ar
On Tuesday, February 7, 2012 2:36:14 AM UTC-5, LightOfMooN wrote:
I'm using loop for 10 inserts just one time to insert 100k records
in database.
All next time I just try to get response.
And now in our project we have much more than 100k records, that can
be filtered and sorted by
Hello.
I have this model:
db = DAL('sqlite://storage.sqlite')
db.define_table('customers',
Field('name'),
Field('age'),
format = '%(name)s'
)
db.define_table('purchases',
Field('name',db.customers),
Field('cart')
)
db.purchases.name.requires =
Why not use represent?
http://web2py.com/books/default/chapter/29/6?search=represent#Record-representation
Richard
On Tue, Feb 7, 2012 at 12:37 PM, shartha m.mirghorb...@gmail.com wrote:
Hello.
I have this model:
db = DAL('sqlite://storage.sqlite')
db.define_table('customers',
LGPL would probably be the best choice, meaning they can use the code for
commercial however need to submit/supply source code changes that they make
to the CMS directly, but allows them to keep their own unique code built on
top of the CMS closed if they want.
On Tue, Feb 7, 2012 at 9:29 AM,
OK, I am going to change it to LGPL3 (the same of web2py)
--
Bruno Rocha
[http://rochacbruno.com.br]
- License changed to AGPL3 (Gnu Afferro GPL)
If I understand AGPL3 correctly, if someone deploys Movuca on a server,
they will be required to allow all users of their website to download the
entire source code of the site, including any customizations they make to
the Movuca code in
Hello,
The form and records words appear even after taking off
{{=response.toolbar()}} line from generic.html..
regards,
Pravene
On Tuesday, February 7, 2012 11:54:59 AM UTC-5, Praveen Bhat wrote:
Hello,
The form and records words appear even after taking off
{{=response.toolbar()}} line from generic.html..
Your controller is returning a dict containing form and records keys --
the following generic.html code
Cool stuff.
I like the thought behind it, too.
On Feb 7, 9:38 am, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
This made the news it
italy:http://www.repubblica.it/tecnologia/2012/02/05/news/hacker_anti_corru...
Repubblica is the main national newspaper.
Congratulations to the
Hi!! I have a lot of apps running with Windows LDAP and web2py (1.8)
and everything works just fine. Now I'm trying to build an app from
scratch using the same auth method with web2py 1.99.4. But it doesn't
work. When I try to log in (after typing pass and username) I get a
ticket this is what it
How can I get the buttons to stick to the right side of my index
table?
My code looks something like this, after a couple of hours of reverse
engineering.
query = db.tbl.blah
rows = db(query).select(db.tbl.id, db.tbl.f1, db.tbl.f2)
thead = THEAD(TR(TH('Col1'), TH('Col2'), TH()))
tbody = []
for
What is the problem in your app?
Do you have the same problem if you use SQLite?
On Feb 7, 12:26 pm, Anthony abasta...@gmail.com wrote:
Just tried it - same results.
FYI, I'm only using the interactive python shell to illustrate the
problem I face I my app...
When you use the -M option
Hi group,
I am trying to build the simple image blog from the web2py book
chapter 3. As far as I can see I have reentered the example code to
the letter - but still I get an error (which I think stems from
layout.html?) (using latest web2py on mac)
Traceback (most recent call last):
File
I want to set username (Not id) to table when the record is created
using import_from_csv_file.
The following model cause error because when you open the website
auth.user_id is None.
Can we set if statement says auth.user_id !=none,
dba.auth_user(auth.user_id).username.upper() else ?
Model
Can you paste the code in your controllers/default/index.html? Also, you
should be able to scroll down near the bottom of the ticket to see the line
of code in the view that triggers the issue.
Sorry, I meant views/default/index.html, not controllers/default/index.html.
I usually do this:
default = auth.user.username.upper() if auth.user else None
you are missing {{ or }} somewhere in view
On Tue, Feb 7, 2012 at 5:26 PM, Andreas Christoffersen
achristoffer...@gmail.com wrote:
Hi group,
I am trying to build the simple image blog from the web2py book chapter 3. As
far as I can see I have reentered the example code to the letter -
db.IQWAGFTY.TYUUSR.default=dba.auth_user(auth.user_id).username.upper()
On Feb 7, 1:31 pm, Omi Chiba ochib...@gmail.com wrote:
I want to set username (Not id) to table when the record is created
using import_from_csv_file.
The following model cause error because when you open the website
Thank you both !!
It works perfectly.
On Feb 7, 1:36 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
db.IQWAGFTY.TYUUSR.default=dba.auth_user(auth.user_id).username.upper()
On Feb 7, 1:31 pm, Omi Chiba ochib...@gmail.com wrote:
I want to set username (Not id) to table when the
Thanks Mariano for answers,
On Feb 7, 2:11 pm, Mariano Reingart reing...@gmail.com wrote:
You can have your shared settings in a common python module, and then
import it in your model:
from shared_settings import DB_URI
db=DAL(DBURI)
This is obvious, what I was looking for was a web2py way
Bruno's work is given for free, and if you don't share your changes back,
keep it secret behind the server, it doesn't help the Movuca project. So
for Bruno the GPL or even AGPL is a good option, as it keeps the code free
(as in freedom).
CMS is very different to a framework like web2py, which
It's known issue and fixed version is in trunk.
http://code.google.com/p/web2py/issues/detail?id=565can=1q=ldap
On Feb 7, 12:53 pm, Ialejandro ialejandr...@gmail.com wrote:
Hi!! I have a lot of apps running with Windows LDAP and web2py (1.8)
and everything works just fine. Now I'm trying to
That is exactly what I had in mind, now I dont know if I stay with AGPL or
change to LGPL..
I chosen AGPL because I saw another related projetct using it (
http://noosfero.org/Site/About)
On Tue, Feb 7, 2012 at 5:59 PM, Wikus van de Merwe
dupakrop...@googlemail.com wrote:
Bruno's work is
On Tue, Feb 7, 2012 at 4:50 PM, amiroff amir...@gmail.com wrote:
Thanks Mariano for answers,
On Feb 7, 2:11 pm, Mariano Reingart reing...@gmail.com wrote:
You can have your shared settings in a common python module, and then
import it in your model:
from shared_settings import DB_URI
Did you remove the line in layout.html that links to an external
FaceBook service? Things like this take time.
On Feb 7, 1:24 am, LightOfMooN vladsale...@yandex.ru wrote:
Hi
Just download web2py, run it and go to edit welcome app.
in db.py:
Bruno's work is given for free, and if you don't share your changes back,
keep it secret behind the server, it doesn't help the Movuca project. So
for Bruno the GPL or even AGPL is a good option, as it keeps the code free
(as in freedom).
Under a more permissive license, a smaller
For example, I have two tables, request and result. I want user to
download all open request (status=1) from request table and upload
with the result to result table.
What's the easy way to do ?
db.define_table('request',
Field('subject'),
Field('status', default=1),
Field('result))
I have following code in grid and smartgrid:
deletable = auth.has_permission('management'),
The button Delete shows in grid, but not in smartgrid. Is there a
difference between the two, or I should dig deeper in possible permissions
messup?
Thanks,
ADnan
Do you have to let the user do that copy/paste because they add result to
kind of empty CSV/Excel spreadsheet to feed your system or you only want to
move data around once?
In later case you can make a request at DB level or in web2py shell...
Richard
On Tue, Feb 7, 2012 at 3:48 PM, Omi Chiba
I don't think there should be difference about that... Smartgrid supposed
to be much the same as grid except that it follow link between tables
referenced by the shown table...
Would show more code to help list member to better help you?
Richard
On Tue, Feb 7, 2012 at 4:02 PM, Adi
I'm not sure how much my opinion matters here, but a lot of times, I am not
allowed to touch GPL code, especially AGPL code for a business project. The
legal department avoids (A)GPL like the plague. There are just too many
gotchas with it, whether real or imaginary. They much prefer I use MIT
solved!
TD(blah, _style='text-align:right;')
applies palm to forehead
On Feb 7, 2:06 pm, Cliff cjk...@gmail.com wrote:
How can I get the buttons to stick to the right side of my index
table?
My code looks something like this, after a couple of hours of reverse
engineering.
query =
How to use this in web2py ?
dummies tutorial?
2012/2/7 omicron jacques.bouss...@gmail.com
This library is small and easy to use:
http://www.hforge.org/itools/docs/workflow/
I think my case is the former. Like Sales support team prepare the
reply for the open request at the end of the day and upload. In the
evening, I have scheduled job on my AS400 do the upgrade from result
to request table with other information.
Insert each rows takes long time compared to update
I was missing a paranthesis... sorry for the confusion - and thanks for the
help... Sometimes taking a walk and comming back to the editor is the best
way to handle errors.
I had:
{{=LI(A(image.title, _href=URL(show, args=image.id))}}$
but should have had:
{{=LI(A(image.title, _href=URL(show,
There is no ubuntu official package as far as I can see, so you will have
to follow the installation information explain into the tar ball available
here : http://www.hforge.org/itools/
Then :
from itools.workflow import Workflow
And the rest is explained in the docs :
Hi Mariano,
what do you mean by permanently importing the data in a module ?
As far as I know, every request will reload ALL the models and module
again... and again... and again
in the mean time I'm reading about mmap as suggested by Michele... even is
it looks like (I have not studied it
I don't know workflow engines in the general sense that well. I once
created a full documentation management system where each document couple
have a workflow assigned to it. The workflow (predefined, or created
on-the-fly) would push the document around from person to person, ensuring
that
Glad you figured it out!
1 - 100 of 130 matches
Mail list logo
