On 23 August 2012 16:50, Gerald Klein j...@zognet.com wrote:
Hi all, I was wondering if anyone could direct me to a resource that will
outline the techniques used to grant external access to an internal ip,
along the lines of NetMeeting. I have tried to google and not getting a lot
of
The ones I want to measure are anonymous.
On Thursday, August 23, 2012 5:06:16 PM UTC+8, Khalil KHAMLICHI wrote:
are your users logged-in or anonymous ?
On Thu, Aug 23, 2012 at 5:48 AM, weheh richard...@verizon.netjavascript:
wrote:
Let me add a little more to this. Clearly, one could
I am using version Version 1.99.4 (2011-12-14 14:46:14) stable
The whole traceback msg is
Traceback (most recent call last):
File C:\workspaces\Python\portal_iUrnik_web2py\gluon\restricted.py, line
204, in restricted
exec ccode in environment
File
On 26 August 2012 20:33, Anthony abasta...@gmail.com wrote:
the second method is the only way to keep the referenced table lazy (the
first method will trigger the table to be defined).
Does that mean that the lazy table option will not work for a system using
a uuid-based reference in stead
On 26 August 2012 23:05, apps in tables ad...@aqar-riyadh.com wrote:
Hi,
where can i find tree example(file system) built by web2py ?
In the Web2py directory tree?
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
+1
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
We just added it a couple days ago. If you get a chance to try it, let us
know if there are any problems.
Anthony
On Sunday, August 26, 2012 8:55:52 PM UTC-4, Andrew wrote:
Thanks Anthony, Wasn't aware of that one, and it looks quite useful.
On Monday, August 27, 2012 6:29:55 AM UTC+12,
Hi Simon
I found that the best way of getting the data out of the table was to use a
WITH RECURSIVE query. Hope that is of interest.
Regards, D
On Tuesday, April 3, 2012 1:21:12 AM UTC+1, Simon Ashley wrote:
Pretty new to this and stumbling a little.
We need to generate a Treeview
Not sure what you mean. Can you show your code?
On Monday, August 27, 2012 4:22:18 AM UTC-4, Johann Spies wrote:
On 26 August 2012 20:33, Anthony abas...@gmail.com javascript: wrote:
the second method is the only way to keep the referenced table lazy (the
first method will trigger the table
OK, I have downloaded the latest trunk from Git and have imported a simple
application: A copy of my site at http://www.ec2scripts.com, which is based
on Plugin_Wiki and seems to (mostly) work.
On the page which is the equivalent of
Hello, we have a small issue with trying to pass an argument/variable to
one of our function. It seems the solution should be simple, but we just
can't figure it out!
The idea is simple: we have an input field for a userID and when you submit
is would pull data with the users other attributes
Works well!
Just wondering are we keeping the ability to embed template code with
the new auth.wiki?
It would be handy to be able to {{=include.things}} using nothing more than
the wiki form (for advanced users). Or do we always need to use LOAD now or
something?
The menu makes sense to
I'be been testing the wiki for a while and have some random comments.
-I created .wiki() in the model and used it in a given function, but it
doesn't add by default the menu entries
-Doing auth.wiki() in any function is not apt for lazyness. i'd add the
option to decorate them:
@auth.wikify()
El lunes, 27 de agosto de 2012 08:06:00 UTC-3, Alan Etkin escribió:I'be
been testing the wiki for a while and have some random
comments.
Wouldn't be better to separate the Wiki class setup and plugging phases?
For example, set welcome by default with something like:
# model
wiki =
Not sure whether this would help...
I've had something similar before. I found that if I was logged in and
re-visited the url it would then give more complete info.
Rgds, D
On Monday, August 27, 2012 11:54:02 AM UTC+1, duncan macneil wrote:
OK, I have downloaded the latest trunk from Git
Hi,
I have created one html file with list of records, each records are there
in a row of table in
html and there is one corresponding button (type as button) for each record
so when user clicks
on it , it should take the id of that record from the html call controller
function which will
On 27 August 2012 12:55, Anthony abasta...@gmail.com wrote:
Not sure what you mean. Can you show your code?
On Monday, August 27, 2012 4:22:18 AM UTC-4, Johann Spies wrote:
On 26 August 2012 20:33, Anthony abas...@gmail.com wrote:
the second method is the only way to keep the referenced
Another mistake is here:
http://web2py.com/books/default/chapter/29/6#Copy-data-from-one-db-into-another
hocalhost - localhost (multiple times)
And I also thing that this is wrong:
postgresql:// - postgres:// (multiple times)
-rif
miercuri, 15 august 2012, 16:33:18 UTC+3, Anthony a scris:
I am referring to this type of code (from the book):
db.define_table('person',
Field('uuid', length=64, default=lambda:str(uuid.uuid4())),
Field('modified_on', 'datetime', default=now),
Field('name'),
format='%(name)s')
db.define_table('dog',
Field('uuid',
The onclick property of an HTML element must be Javascript. You cannot call
a server-side Python function directly from the browser. If you want the
button to work like a regular link and simply load a new page in place of
the current page, you can do:
Button type=button name =seeting_button
Massimo- Just tried testing with latest trunk DAL- it still fails silently
and returns None results when trying to execute multiple statements with a
single call
On Saturday, August 25, 2012 4:39:23 PM UTC-4, Massimo Di Pierro wrote:
Exately. On top of this until yesterday executesql had a
Hello
I want to shorten url's and use hyphens in my paths. I also want to get a
404 if the user tries an invalid url. I have played with routes.py but the
effect I get is shorter url's (good), hyphens in url's translated to
underscores in function and view (good) , but all invalid url's route
Once I call a stored procedure through the DAL, any subsequent calls are
returning None results.
*Basic stored procedure:*
BEGIN
SELECT * FROM people;
END
*Works:*
def test():
sql = CALL GetPeople();
sproc_results = db_test.executesql(sql)
return str(sproc_results)
*Works:*
def
The following code is broken in trunk:
db = DAL('sqlite://test.sqlite')
db.define_table('t',Field('x'))
db.t.insert(x=1)
db(db.t).select(db.t.id,db.t.x+1).first()(db.t.id)
Throws AttributeError: 'Row' object has no attribute 'id'
The point seems to be the _extra entry created in the row object
if you are doing GEO stuff i would highly recommend postrgres with
postgis! then you can just ask for a point, point in polygon, polygon
contains point etc.
On Sunday, August 26, 2012 8:54:40 PM UTC-7, Andrew Evans wrote:
nvm just found acos cos and such are not available in Dal or sqlite
you need to have a different FB app for test and for production. on
facebook you set the valid domain for an app, and that is the only domain
that it will accept redirect_uri to. (unless FB has improved and you can
set multiple domains per appbut in either case you have to login to FB
On 27 Aug 2012, at 7:30 AM, jc j-cl...@lineone.net wrote:
I want to shorten url's and use hyphens in my paths. I also want to get a 404
if the user tries an invalid url. I have played with routes.py but the effect
I get is shorter url's (good), hyphens in url's translated to underscores in
WE NEED INDEPENDENT BENCHMARKS AGAINST 1.99.7. Here is the code to
benchmark:
-
import time
db=DAL()
db.define_table('person',Field('name'))
db.test.insert(name='one')
db.person.insert(name='one')
n = 10
t0 = time.time()
for k in range(n):
y = db.person.name
That is very helpful, thank you.
--
Hello
My problem is that my app has to go to specific database on postgres to
check for users.
you can visit my app on http://portal.iurnik.si/
You can see that the user select a value from popup and then the app goes
to a specific database to read data.
After that I want to create a login
After placing gLib.py module into directory models web2py (versions 2.0
and 1.99.7 on Windows and Ubuntu) fails:
Traceback (most recent call last):
File /home/aabelyakov/MyPython/web2py/gluon/main.py, line 528, in wsgibase
session._try_store_on_disk(request, response)
File
Maybe try something simple and build on that.
For example, you could make simple form to submit the ref with a get
variable...
form = SQLFORM.factory(Field('ref',length=10,label='Test Ref'),
_method = 'GET',
_action=URL())
Then you can test to see whether the variable
Tryin to use the example shown in Validators between classical and
professional usage http://web2py.wordpress.com/category/web2py-validators/to
change the values and widget for an SQLFORM.grid.
I need to display an Assign Trainers page with an SQLFORM.grid (or
something similar) of new dogs
Pretty desperate on this one- brought everything to a screeching halt. We
need to be able to call more than one stored procedure per request. Anybody
got any ideas?
On Monday, August 27, 2012 10:37:45 AM UTC-4, Yarin wrote:
Once I call a stored procedure through the DAL, any subsequent calls
Just a thought - does db.commit() help?
Rgds, D
On Monday, August 27, 2012 3:37:45 PM UTC+1, Yarin wrote:
Once we call a stored procedure through the DAL, any subsequent DAL calls
are returning None results.
*Basic stored procedure:*
BEGIN
SELECT * FROM people;
END
*Works:*
def
Villas- Thanks but no it doesn't- tried that..
On Monday, August 27, 2012 1:53:32 PM UTC-4, villas wrote:
Just a thought - does db.commit() help?
Rgds, D
On Monday, August 27, 2012 3:37:45 PM UTC+1, Yarin wrote:
Once we call a stored procedure through the DAL, any subsequent DAL calls
Hey David, thanks for taking the time! Actually we have solved it by
embedding our form in the form.accept part, so if the user types in a
valid username into the first form (just an input field and a submit
button) then the second form is called.
On Monday, 27 August 2012 19:03:49 UTC+2,
Hello,
If I resume correctly you want to assign a trainer to a dog only if the
trainer haven't been assign to any dogs yet?
So, what you have to do it to build a set instead of only define an simple
IS_IN_DB()...
I would do something like this (not tested) :
not_assign_yet_trainer_set =
Please check agin. there is no more try-except in there.
On Monday, 27 August 2012 09:01:26 UTC-5, Yarin wrote:
Massimo- Just tried testing with latest trunk DAL- it still fails silently
and returns None results when trying to execute multiple statements with a
single call
On Saturday,
Thanks. This confirms my results.
There is also a better
db(...).select(cache=(cache.rame,3600))
It should be much faster than before.
On Monday, 27 August 2012 09:55:49 UTC-5, Daniel Haag wrote:
WE NEED INDEPENDENT BENCHMARKS AGAINST 1.99.7. Here is the code to
benchmark:
If this is a new app you may want to replace
auth = Auth(baza, hmac_key=Auth.get_or_create_key())
with
auth = Auth(baza)
as it will be faster and same security because latest Auth has built-in
salting.
About your problem. You cannot complete let the user specify it. You must
have a
gLib.py is probably a module, not a model. I would put it there. Why it
fails I cannot say, I do not know what it does.
On Monday, 27 August 2012 11:22:31 UTC-5, aabelyakov wrote:
After placing gLib.py module into directory models web2py (versions 2.0
and 1.99.7 on Windows and Ubuntu) fails:
I do not think this is a DAL issue. This looks database issue or a driver
issue. Web2py does not do another else but pass your SQL to the driver and
fetch responses.
Is this SQLITE? In any case, I suggest you try the native driver APIs.
On Monday, 27 August 2012 09:37:45 UTC-5, Yarin wrote:
Try this...
Model
db.define_table('trainer',
Field('name'),
Field('specialty'),
auth.signature,
format='%(name)s',
migrate=True,
)
db.define_table('dogs',
Field('name'),
Field('bites', 'boolean'),
Field('trainer', 'reference trainer'),
auth.signature,
This is MySQL using the default driver, whatever that is. I'm going to test
on other drivers/dbs and will report back..
On Monday, August 27, 2012 3:03:15 PM UTC-4, Massimo Di Pierro wrote:
I do not think this is a DAL issue. This looks database issue or a driver
issue. Web2py does not do
Thank you David,
I'll try it as soon as I finish my current round of debugging.
-Bill
On Monday, August 27, 2012 2:05:24 PM UTC-5, villas wrote:
Try this...
Model
db.define_table('trainer',
Field('name'),
Field('specialty'),
auth.signature,
format='%(name)s',
Thank you Richard,
I'll try it as soon as I finish my current round of debugging.
-Bill
On Monday, August 27, 2012 1:20:49 PM UTC-5, Richard wrote:
Hello,
If I resume correctly you want to assign a trainer to a dog only if the
trainer haven't been assign to any dogs yet?
So, what you
Try use mysqldb too. The default pymysql has some problems. We even have to
monkeypatch it for security.
Massimo
On Monday, 27 August 2012 14:20:00 UTC-5, Yarin wrote:
This is MySQL using the default driver, whatever that is. I'm going to
test on other drivers/dbs and will report back..
FYI, in trunk, response.toolbar() now includes a new db tables button,
which shows the tables that were fully defined (i.e., those that did not
remain lazy) during the request. You can use this to verify which tables
are getting defined and which are remaining lazy depending on the URL being
This is an issue with
pymsql: http://code.google.com/p/pymysql/issues/detail?id=72,
https://github.com/petehunt/PyMySQL/blob/master/pymysql/cursors.py
Running against pymysql's api directly, I can execute sproc calls on on two
different connections, but not on the same connection.
So...
-
Previously, you could use the .elements() method to find matching elements
nested within an HTML helper object (such as a form), and you could mutuate
the matched elements (e.g., add attributes and insert components), but you
could not completely replace or remove the matched elements. The only
The existing adapter should work with mysqldb. Try:
import mysqldb
from gluon.dal import MySQLAdapter
MySQLAdapter.driver = mysqldb
db=DAL('mysql://')
Anthony
On Monday, August 27, 2012 4:37:42 PM UTC-4, Yarin wrote:
This is an issue with pymsql:
i am running both web2py and shellinabox (
http://code.google.com/p/shellinabox/ ) on my vps. i am running
shellinabox so that i uses the https port to keep it secure.
currently web2py is running on its own built-in web server and i just
navigate to the ip address of my vps @ port 80. i'd
How can I escape the data submitted by my form to prevent SQL Injection. I
read using request.post_vars does not escape the data, I am using a form
built in HTML and submitting the data passing request.post_vars as
variables to my SQL Query.
Any ideas
*cheers
--
I am trying to figure out why executesql is not returning any results in
this query. I am using mysql, any suggestions would be greatly
appreciated. There are no errors just an empty view
*cheers
Code Below
*Controller*
def location():
current_lat = request.post_vars[lat]
current_lon
Nvm I got it to work my latitude and longitude were in the wrong entries :D
On Mon, Aug 27, 2012 at 7:12 AM, Andrew Evans dj.setili...@gmail.comwrote:
I am trying to figure out why executesql is not returning any results in
this query. I am using mysql, any suggestions would be greatly
hey thanks I was able to get it to working using that MySQL query and
Web2py's executesql method
*cheers
On Mon, Aug 27, 2012 at 7:46 AM, howesc how...@umich.edu wrote:
if you are doing GEO stuff i would highly recommend postrgres with
postgis! then you can just ask for a point, point in
Is there a reason you can't use the DAL to do the insert?
On Monday, August 27, 2012 4:32:09 PM UTC-4, Andrew Evans wrote:
How can I escape the data submitted by my form to prevent SQL Injection. I
read using request.post_vars does not escape the data, I am using a form
built in HTML and
yes I have a peculiar SQL query that is using ACOS(), COS() etc for
geolocation. I would love to use DAL but it is for a mobile device :D
*cheers
On Mon, Aug 27, 2012 at 2:11 PM, Anthony abasta...@gmail.com wrote:
Is there a reason you can't use the DAL to do the insert?
On Monday,
I am not sure I fully understand the reason for these suggestions. You seem
to need access to the Wiki object in more then one controller. Why?
I can see why one may want to define the wiki outside of an action to
benefit from the menu (if you delete models/menu.py) all actions will have
the
Okay, but do I leave everything else alone? All I want to do is make it
www.mysite.com/equipment/id/title
currently, title is set up as slug in the DB. What am I doing wrong.
In my view:
equipment_id = request.args(0)
equipment_slug = request.args(1)
query = (db.equipment.id ==
I don't know if you picked this up, but you don't seem to have row.id as
part of the sqlfrom url.
Perhaps try:
links = [lambda row: A('Details',_href=URL('default','equipment',
args=[row.id, row.slug]))]
On Tuesday, August 28, 2012 10:28:39 AM UTC+12, SeamusSeamus wrote:
Okay, but do
ah, yes, all is well now...however, this is strange.
Now, when I click the link on the table to take me to the
'equipment.html' page (I renamed it from details.html), it shows the
controller in the URL:
www.mysite.com/default/equipment/id/title
how do I make it so the 'default' does not
nevermind I fixed it. Not sure why, but if it was named 'equipment' the
controller showed up...any other name it doesnt. I just renamed
On Monday, August 27, 2012 5:05:44 PM UTC-6, SeamusSeamus wrote:
ah, yes, all is well now...however, this is strange.
Now, when I click the link on the
On 27 Aug 2012, at 4:56 PM, SeamusSeamus morrisjamespatr...@gmail.com wrote:
nevermind I fixed it. Not sure why, but if it was named 'equipment' the
controller showed up...any other name it doesnt. I just renamed
Because you also have an application named 'equipment', so some URLs are
Thanks Anthony, this really helped confirm the lazy_tables=True is working
as expected. On average I am using 8 to 10 tables out of 30 total per
request depending on the URL visited. Here is the relevant output from
httpserver.log when I ran the application through a sequence of operations.
...no trainers are being returned. I even tried moving
unassignedtrainers = (~db.trainer.id.belongs(db()._select(db.dogs.trainer)))
db.dogs.trainer.requires = IS_IN_DB(db(unassignedtrainers), 'trainer.id',
'%(name)s',zero=T('choose one'))
to the controller. No luck.
The drop down boxes do not
Given a simple table like:
db.define_table(
'foo',
Field('bar', requires=IS_IN_SET([1,2,3,4,'fzr',6,7,8,9, 'Other'])
# If other is picked, display text-box with IS_ALPHANUMERIC validator)
How do I add this option? - I'm guessing it would be solved best using
SQLFORM.factory.
Thanks Anthony- ill give it a try
On Monday, August 27, 2012 4:58:01 PM UTC-4, Anthony wrote:
The existing adapter should work with mysqldb. Try:
import mysqldb
from gluon.dal import MySQLAdapter
MySQLAdapter.driver = mysqldb
db=DAL('mysql://')
Anthony
On Monday, August 27, 2012
Possible Issue, this might be due to the dal changes (or it could be me?):
I'm running a variation of Bruno's Modelless App (and I tried his out of
the box) https://github.com/rochacbruno/web2py_model_less_app
, and I get:
AttributeError: 'DataBase' object has no attribute '_LAZY_TABLES'
On
*Thanks* Massimo...
I didn't know you could do it without modifying the .py file, I'll try some
things out.
Rob
--
To solve this issue include in the line 88 of myapp.py
https://github.com/rochacbruno/web2py_model_less_app/blob/master/modules/myapp.py#L88
self._LAZY_TABLES = []
On Mon, Aug 27, 2012 at 11:33 PM, Andrew awillima...@gmail.com wrote:
Possible Issue, this might be due to the dal changes (or
Thanks very much for a quick response,
and add the next line too :
self._LAZY_TABLES = []
self._tables = []
On Tuesday, August 28, 2012 2:53:01 PM UTC+12, rochacbruno wrote:
To solve this issue include in the line 88 of myapp.py
model
db.define_table('trainer',
Field('name'),
Field('specialty'),
auth.signature,
format='%(name)s',
migrate=True,
)
db.trainer.is_active.default=False
db.define_table('dogs',
Field('name'),
Field('bites', 'boolean'),
Field('trainer', 'reference trainer',
gLib.py - this is a common library of functions and procedures. It uses
global variables attached to the session.
понедельник, 27 августа 2012 г., 23:00:37 UTC+4 пользователь Massimo Di
Pierro написал:
gLib.py is probably a module, not a model. I would put it there. Why it
fails I cannot
I am wanting to create large amounts of content that needs to be
translated. Is the Lazy T() way the best for this?
Whole pages of text will need to be translated.
BR,
Jason Brower
--
hi,
I have to send the arguments value from redirect to the target function,
for e.g:
redirect(URL(r=request,f='record_config'))
def record_config(record_id):
I have to send the value of record_id from the redirect() to the
record_config() function OR is it some other way to send value of
77 matches
Mail list logo