[web2py] Re: Radio Buttons basic inline editing in SQLFORM.grid

Hi jacob, i am trying to do the same thing, did you find a solution for this? On Saturday, April 27, 2019 at 4:20:10 AM UTC+2 Jacob wrote: > Thank you for the response it appears that they do have the same name . > I'm sorry I'm still new to programming in general, I've read around about > how

[web2py] SQL grid groupby work around using posgres

Hi all I have recently moved from SQLite to Postgres, I've had to change all the 'groupby' to 'distinct'. However, I'm also using the 'groupby; command in the SQLgrids, but this does not have a distinct option. Does anyone know of a workaround? Example code below def re_standardise_taxon():

[web2py] Select_or_add

Hi all Anyone using this feature with the current version of web2py. I tried to get the feature working using the code from the link below but it isnt working propery i.e. can´t close pop up box, form doesn't refesh when i insert a new entry. I still have to learn Jquery and javascript https:/

[web2py] Re: Object not found

Looks like you are not sending/recieving your args properly ( For example You need to send args=Customer.id , from a button or redirect for example You then need to request the Customer.id in the 'Client_Update' function So you'd need def Client_Update(): client=request.args(0,cast=int)

Re: [web2py] Re: default search string in SQL.grid

thanks that worked a treat! So was that done using jquery? I still have to learn about it On Thu, Sep 13, 2018 at 5:39 PM Anthony wrote: > On Thursday, September 13, 2018 at 8:36:11 AM UTC-4, Marcelo Huerta wrote: >> >> El jueves, 13 de septiembre de 2018, 8:10:48 (UTC-3),

Re: [web2py] Re: default search string in SQL.grid

great, thanks all i´ll give that a go tomorrow! On Thu, Sep 13, 2018 at 5:39 PM Anthony wrote: > On Thursday, September 13, 2018 at 8:36:11 AM UTC-4, Marcelo Huerta wrote: >> >> El jueves, 13 de septiembre de 2018, 8:10:48 (UTC-3), Matthew J Watts >> escribió: >>>

[web2py] default search string in SQL.grid

Hello all Is there a way to pre populate the 'search field' of the SQLFORM.grid? For example i can populate fields in an SQLFORM with variables using something like db.study_data.taxon.default = request.get_vars.tax_species However, could i do something like? grid.search.default = reques

Re: [web2py] Re: update_or_insert doesn't always return the corresponding row id

rd.id # <- Here is the only code modification you > need > else: > newid = self.insert(**values) > return newid > > for example you can define it and call it passing the table to update or > insert into as _first argument_ > > > On 01/08/2018 17:20,

Re: [web2py] Re: update multiple tables from one csv and get row id after update_or_insert

Many thanks for your help all, i'm slowly getting my head around it. I'll post the code once it's finished in case anyone needs it in future cheers Matt On Wed, Aug 1, 2018 at 7:41 AM, sandeep patel wrote: > @Mattew J Watts, > #Model > > db.define_table('person', > Field('n

[web2py] Re: update_or_insert doesn't always return the corresponding row id

Hi all I'm having the same problem, i'm trying to return an ID after an 'update_or_insert', but I need the ID whether it inserts or updates to add as a forign key to a related table. Does anyone have a work around, someone mentioned that you could just 'db(condition).select(table.id) after th

[web2py] Re: update multiple tables from one csv and get row id after update_or_insert

ps - i'm getting the file locally as i havent worked out the .retrieve: method yet On Tuesday, July 31, 2018 at 6:51:41 PM UTC+2, Matthew J Watts wrote: > > Hello all > > I'm trying to build a .csv data upload facility which will update two > tables in sequence. So,

[web2py] update multiple tables from one csv and get row id after update_or_insert

Hello all I'm trying to build a .csv data upload facility which will update two tables in sequence. So, i have my 'person' table which has a one to many relationship with the 'thing' table i.e. one person can own many different things. What i need to do is get the primary key from a 'person'

Re: [web2py] Re: Send args from a button in views

Great thanks Sandeep! On Sat, May 26, 2018 at 3:47 PM, Sandeep Patel wrote: > @Matthew J Watts > That is my fault, I apologized for my mistake > > If you are trying to redirect one view to another view page. > > you can try this > > > > Cancle > > >

Re: [web2py] Re: Send args from a button in views

May 26, 2018 at 8:21 AM, Sandeep Patel wrote: > @Matthew J Watts > You can try this > grid = SQLFORM.grid(query,selectable=[('Name',lambda ids > :redirect(URL('default','func',args=ids)))]) > > > best > sandeep > > On Fri, May 25, 2018 at 4

[web2py] Send args from a button in views

Hi all How do i send args via a button from views. For example, i'd like to send variables to the 'my_collections URL' {{=A( 'Finish',_href=URL('my_collections'),_class="btn btn-primary")}} I can do something similar from the grid in a controller, however i cant find the right way to it from

Re: [web2py] python anywhere deployment issues

/AdminIsDisabledBecauseInsecureChannel/ On Wed, May 2, 2018 at 2:09 PM, 'Matthew J Watts' via web2py-users < web2py@googlegroups.com> wrote: > Hi everyone > > > I am trying to deploy an app, built with version 2.16.1, on the python > anywhere server using version 2.14.6 > >

[web2py] python anywhere deployment issues

ideas what's up, or how i can work around this? Thanks Matthew -- 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 yo

Re: [web2py] Re: Help with cascading drop down list

n with a rich UI, you > have to study javascript much deeper, after that you won't have any > questions about which library/framework you'd better use (D3, Vue, > Angular, React, Backbone, Knockout, Ember ...+tons of others) > > > On Saturday, March 3, 2018 at

Re: [web2py] Re: Help with cascading drop down list

M, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > what do you want to do exctely? call a Java function from web2py? > > > On Monday, 12 February 2018 11:56:59 UTC-6, Matthew J Watts wrote: >> >> Can anyone point me in the right direction with this, any good tut

[web2py] Re: Help with cascading drop down list

Can anyone point me in the right direction with this, any good tutorial out there on how i can integrate java and web2py? On Friday, February 9, 2018 at 12:05:32 PM UTC+1, Matthew J Watts wrote: > > Thanks for your reponse David! > > On Thursday, February 8, 2018 at 8:56:19 PM U

[web2py] Re: Help with cascading drop down list

Thanks for your reponse David! On Thursday, February 8, 2018 at 8:56:19 PM UTC+1, Dave S wrote: > > > > On Thursday, February 8, 2018 at 9:55:25 AM UTC-8, Matthew J Watts wrote: >> >> Hi community >> >> I'm having a few problems trying to understand how cr

[web2py] Help with cascading drop down list

Hi community I'm having a few problems trying to understand how create a cascading drop down list. I've followed this tutorial - http://www.web2pyslices.com/slice/show/1526/cascading-drop-down-lists-with-ajax-2 i've managed to adapt it slightly, but i'm having trouble trying to add more tables

Re: [web2py] Re: Is Web2py suitable for my project

t the project never progressed so I can’t help you with > web2py and Bokeh. > > Eric > > On Nov 25, 2017, at 5:53 AM, 'Matthew J Watts' via web2py-users < > web2py@googlegroups.com> wrote: > > Hi Eric > > Did you end up using web2py for this project? > >

[web2py] Re: Is Web2py suitable for my project

Hi Eric Did you end up using web2py for this project? Like you i'm a Biologist trying to use Web2py by to query, process and visualize data, I was wondering if you could show me an example of how you integrated Bokeh into web2py Thanks Matt On Saturday, January 24, 2015 at 5:23:22 PM UTC+1,

Re: [web2py] Re: Update database (multiple tables) with CSV in sequence

great, thanks for your help Dave. I'll have a go and if i have any luck will post my code for future reference On Mon, Oct 23, 2017 at 10:02 PM, Dave S wrote: > > > On Saturday, October 21, 2017 at 2:25:47 PM UTC-7, Matthew J Watts wrote: >> >> Hi all >> >

[web2py] Update database (multiple tables) with CSV in sequence

Hi all I'm pretty new to web2py and web development in general. I'm really stuck with something and haven't been able to find a tutorial which can help me out etc. I was wondering if some one could point me in the right direction. I have three tables. I want to upload a csv, and update each ta

[web2py] select_or_add_widget - can't get recipes, tutorials and example app to work

Hi there, does anyone know how to get this working with the latest version of web2py - i can't get it working, not even in the sample app below https://github.com/mdipierro/web2py-recipes-source/blob/master/apps/05_adding_ajax_effects/web2py.app.select_or_add_widget.w2p thanks Matt -- Resourc

Re: [web2py] Re: Help - Grid with left joins and sending arguments/variables to other functions

Is that correct. > > I've never done that, but I don't see how it would change anything other > than the 'left' setup. > > -Jim > > On Fri, Jul 21, 2017 at 5:54 AM, 'Matthew J Watts' via web2py-users < > web2py@googlegroups.com> wrote: &

Re: [web2py] Re: Help - Grid with left joins and sending arguments/variables to other functions

b2py is the community and the friendly help you can get on this group. > > -Jim > > On Wednesday, July 19, 2017 at 9:26:08 AM UTC-5, Matthew J Watts wrote: >> >> Great thanks Jim, that did it for me - it's hard being a beginner!! >> >> On Wed, Jul 19, 2017 a

Re: [web2py] Re: Help - Grid with left joins and sending arguments/variables to other functions

t;,args=[ids.id]))] > > to this: > > links = [lambda ids: A('Download data set',_href=URL("default","down > load_dataset.csv",args=[ids.MAIN.id <http://ids.id/>]))] > > When you add the LEFT join you then need to specify which table to get the

[web2py] Help - Grid with left joins and sending arguments/variables to other functions

Hi all I'm having some problems trying to achieve the following I have a grid with left joins which selects a subset of entries in my database -(query between 3 tables) Once i get the desired result, i want to be able to set up links within the table that then send the id from each row (MA

[web2py] Re: Grid - limit searches to specified fields not whole tables

Ok thanks Antony i'll look into it, this looks like it could take some time!! On Friday, July 7, 2017 at 2:42:37 PM UTC+2, Matthew J Watts wrote: > > Hi all > > > > I’m having problems trying to tailor the grid to my needs > > I've set up a grid to que

[web2py] Grid - limit searches to specified fields not whole tables

Hi all I’m having problems trying to tailor the grid to my needs I've set up a grid to query my db and it retrieves the data successfully, great! Example: def gridquery(): grid = SQLFORM.grid((db.MAIN.TaxonID == db.TAXON.TaxonID), field_id = db.MAIN.MainID, fields=[db.TAXON.Ta

[web2py] Re: Limit the field to search in sqlgrid?

I'm trying to do the same, can anyone help? On Friday, June 28, 2013 at 3:03:12 AM UTC+2, fun man wrote: > > Hi all, > > I have a couple tables joined in the sqlform.grid. They both have around > 20 fields. I am only displaying around 10~15 fields for a particular > purpose. > > When I click

Re: [web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

thanks Peter, as for the grid i'm currently trying to work out how to customize it, but yes i think the "buttons_placement = 'right' " puts the buttons on the right On Wednesday, July 5, 2017 at 4:39:17 AM UTC+2, Peter wrote: > > > Glad you got something out of it Matt! > > I decided to try an

Re: [web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

Thanks Peter - that was very helpful indeed. I didn't manage to get a 'download to CSV from checkboxes' function working, don't quite get why as i managed to set up a 'download links from rows ' function in the SQLFORM.grid. Here is the code for you just in case it is any help for you in the fut

Re: [web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

thanks for your help Peter! Actually, i've been playing around with it but need some into on the functions/views too! 'The report_functions should point to valid report functions/views that you have created (I can provide some info on this if needed)' On Tue, Jul 4, 2017 at 4:37 AM, Peter

[web2py] SQLFORM.grid with selectable checkboxes that export CSV files on submit

Hi all I'm trying to modify an SQLFORM.grid so it has selectable check boxes, which allow the user to download selected queries as CSV files once the submit button has been clicked. Can anyone help me with this? Thanks in advance Matt -- Resources: - http://web2py.com - http://web2py.com

Re: [web2py] Re: Editing an SQLFORM.grid - use check boxes to select downloads.

Ok great thanks , i will check it out On Tue, May 23, 2017 at 1:53 AM, 黄祥 wrote: > i think you can use widget to show checkbox : SQLFORM.widgets.checkboxes. > widget > ref: > http://web2py.com/books/default/chapter/29/07/forms-and-validators#Widgets > and use record representation for download >

[web2py] Editing an SQLFORM.grid - use check boxes to select downloads.

Hi all I'm new to web2py and i'm stuck on the following issue. I am trying to Edit an SQLFORM.grid so that I can use the check boxes (selectable) to select which rows to download. Can anyone give me a few pointers on this. Thanks Matt -- Resources: - http://web2py.com - http://web2py

[web2py] Re: exporting selected rows from a grid

hello, did you ever find a better solution for this? I want to do the same thing On Monday, September 30, 2013 at 11:33:57 AM UTC+2, step wrote: > > I want to use SQLFORM.grid with selectable checkboxes to serve a custom > export function. Unlike web2py's default exportformats manager, which >

Re: [web2py] Re: Help with building query functions in a web app - links to tutorials etc

fine_table and queries dal.. > > What you already done? > > Em sábado, 29 de abril de 2017 14:09:13 UTC-3, Matthew J Watts escreveu: >> >> Hi there everyone! >> >> I'm new to Web2py, i'm really enjoying using the framework so far. >> >> I am t

[web2py] Help with building query functions in a web app - links to tutorials etc

Hi there everyone! I'm new to Web2py, i'm really enjoying using the framework so far. I am trying to rebuild a legacy database. I want to produce a web app that can query data from multiple tables using drop down boxes e.g. locations, species etc.. I want to be able to select info using drop

[web2py] Re: Resetting the database

I had to log out of my webapp before deleting the database data, otherwise i would get an error message cheers On Monday, November 14, 2011 at 1:38:15 AM UTC+1, Archibald Linx wrote: > > Dear Web2py users, > > How can I reset the database of my Web2py project ? > > Thanks, > Archibald -- Re

[web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

gluon/tools.py somewhere else? > > > On Saturday, 14 September 2013 18:55:08 UTC-5, Matthew Spence wrote: >> >> Hi guys- >> >> I just tried a fresh install of web2py on PythonAnywhere. (So, only the >> "stock" applications of welcome, admin, and exam

[web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

ave multiple domains you must do it for > every domain. > > Massimo > > > On Saturday, 14 September 2013 18:55:08 UTC-5, Matthew Spence wrote: >> >> Hi guys- >> >> I just tried a fresh install of web2py on PythonAnywhere. (So, only the >> "stock&qu

[web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

Hi guys- I just tried a fresh install of web2py on PythonAnywhere. (So, only the "stock" applications of welcome, admin, and examples.) It auto-installs with 2.5.1, so I hit the button to upgrade to 2.6.2. It looks like it starts to install, but then I get "Internal Error" again. I pasted the

Re: [web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

Hi Massimo- I took a look through the error file and I suspect the relevant line is: from gluon.tools import Config\nImportError: cannot import name Config\n' Let me know if you want the whole error file. Thanks! -Matt On Sep 14, 2013, at 9:14 AM, Massimo Di Pierro wrote: > I need to s

[web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

Hi all- I'm very excited about the upgrade. I'm deployed on PythonAnywhere, and when I clicked on the button to "upgrade now to Version 2.6.1", it looks like it downloads, but then suddenly I get "Internal error. Ticket issued admin/" and now my admin interface does not work. (The site stil

[web2py] Re: alternates to pyjamas/pyjs?

Please do shae--i have issues myself. On Wednesday, May 30, 2012 11:37:05 AM UTC-7, stefaan wrote: > > > > solved some of the issues...time to get crackin'! > > > Glad to hear it :) > > I have found the "inspect element" tool in chromium to be very valuable > in diagnosing trouble with my appl

[web2py] Re: Question about Human-readable forms + REST CRUD APIs.

I'v been fiddling with these ideas. They are very similar to the flask/sqlalchemy solutions I've seen in my other queries. Thanks a ton for the suggestions. This is a pretty nice community. On Sunday, July 29, 2012 11:16:53 PM UTC-6, Anthony wrote: > > - if you define your models carefully w

[web2py] Re: Question about Human-readable forms + REST CRUD APIs.

> In my view there is no simple solution to this problem and it is easier to > actually implement html forms and rest services separately. If you have any > advice on how to built a better system, I would like to hear your ideas. It > could help make web2py better. > > massimo

[web2py] Can web2py serve REST data of many-to-may tables via parse_as_rest?

I'm posting this question here as well as on stackoverflow. So hopefully the extra exposure will help me out! I need to serve REST data about a many-to-many relationship. I've been

[web2py] Question about Human-readable forms + REST CRUD APIs.

A quick question about basic CRUD for both humans (basic HTML) and computers (REST) I'm trying to pick a solid python framework for a project at work. We have a lot of situations where we need to expose datbase tables for data CRUD. I'm trying to pick between Flask and Web2py at this time, but

Re: [web2py] How do I aggregate accounts using OAuth & web2py?

Thank you, Mic!

[web2py] Re: haml and sass

I've used HamlPy before: https://github.com/jessemiller/HamlPy. It works really well for those familiar with Python syntax. All you have to do is "listen" on a directory, or set up an Eclipse job that executes a script every time you save a file. If anyone is interested, I could dig back and find

[web2py] How do I aggregate accounts using OAuth & web2py?

te tutorials or best practices documented. Does anyone know of any? Thanks, Matthew

[web2py] Re: Default field value with lambda

+ r['id'] or 'Node'), I understand that *default* does not take arguments, but *compute* did not work for me either. Can you include an example so I am sure to try the exact syntax you're suggesting? Thanks, Matthew

[web2py] Default field value with lambda

parate counter field? Thanks, Matthew

[web2py] Re: Navigation links with Plugin & CRUD

Any example out there with the different > > > options? > > > > thanks > > > > Dan > > > > On Oct 20, 7:35 pm, Massimo Di Pierro > > > wrote: > > > > > Do not use crud.select. use SQLFORM.grid instead. So much better. > > &

[web2py] Re: SyntaxError: Set: no tables selected on select statement.

y goes with the db() not > the select().  Second, the reference to room is via room.id rather > than room.name.  So you could try: > > reservations = db(db.reservation.room==room.id).select() > > On Nov 8, 8:49 am, Matthew Young wrote: > > > > > > > > > Hello I

[web2py] SyntaxError: Set: no tables selected on select statement.

Hello I am using the Version 1.99.3 (2011-11-07 17:41:19) dev version of web2py. I am having an issue with this view function: def check_room_availability(): room = db.room(request.args(0)) or redirect(URL('view_rooms')) reservations = db().select(db.reservation.room.name==room.name) r

[web2py] Navigation links with Plugin & CRUD

g them. http://img6.imagebanana.com/img/aw2vsbdl/pTZ6ZW0mVK.png Thanks, Matthew

[web2py] Re: Plugin files disappearing during editing

Thank you! On Oct 20, 7:47 pm, Anthony wrote: > Plugin files are shown separately -- scroll to the bottom of the page, and > you should see the plugins listed in the Plugins section. Click on one, and > you'll get a separate page for the plugin files.

[web2py] Plugin files disappearing during editing

I am trying to create a plugin. Is there any reason that files prefixed with "plugin_" do not show up when you restart web2py to edit them again? http://img7.imagebanana.com/img/wcibbzg2/Selection_010.png Thanks, Matthew

[web2py] Re: Cannot see Plugins listed in Wizard

Per Massimo's advice, I created an issue for this here: http://code.google.com/p/web2py/issues/detail?id=478 Please star it if you are experiencing the same issue. On Oct 19, 4:00 pm, Matthew wrote: > Here is a screenshot to illustrate,http://bit.ly/qL7VjAand a > previous thread ab

[web2py] Question about crud forms and foreign keys

Currently, I have a table that has a field that represents a different table in my database (ex: Field('thing', db.thing)). If I make a crud form of the table that has a field referring to a foreign table, I am able to select items from the second table in a drop down menu. Is there a way I can tel

[web2py] Re: Cannot see Plugins listed in Wizard

Here is a screenshot to illustrate, http://bit.ly/qL7VjA and a previous thread about testing the wizard, http://groups.google.com/group/web2py/browse_thread/thread/6c368ee2723bb3b9/deb78bbc76b4d299?lnk=gst&q=plugins+wizard#deb78bbc76b4d299

[web2py] Cannot see Plugins listed in Wizard

I am trying to use the plugins dropdown, but I can't see any choices at all. I've tried this on both Chrome and Firefox, and am using Ubuntu 10.04. Thanks for your help, Matthew

[web2py] Error when @auth.requires_login() decorator is used on a method in controllers/default.py

Hi everyone I am using the following python/web2y versions: web2py™ (1, 99, 3, datetime.datetime(2011, 10, 18, 17, 10, 12), 'dev') Python Python 2.7: /usr/bin/python I am running web2py from source under linux. I have the following method in my default controller file: @auth.requires_log

[web2py] Database drivers lost

"/home/matthew/dev/projects/poprop_cameron/project/src/gluon/ restricted.py", line 192, in restricted exec ccode in environment File "/home/matthew/.local/share/Trash/files/src.3/applications/ welcome/models/db.py", line 17, in db = DAL('sqlite://storage.sqlite

[web2py] "No module named pickle" when started in App Engine

I tried to start web2py 1.98.1 using dev_appserver.py, but it cannot find the "pickle" module. Traceback (most recent call last): File "/home/matthew/dev/sdks/google_appengine_1.5.2/google/appengine/ tools/dev_appserver.py", line 4144, in _HandleRequest self._Dispatch(di

[web2py] Re: Not getting proper Janrain choices

I see it now, thank you. I didn't realize it was at the bottom of the file. Thanks! On Aug 2, 2:20 pm, Anthony wrote: > On Tuesday, August 2, 2011 1:45:52 PM UTC-4, Matthew wrote: > > > 1. Yes, I completed those steps and the code was not inserted. > > Hmm, I just tried

[web2py] Re: Not getting proper Janrain choices

1. Yes, I completed those steps and the code was not inserted. 2. Version 1.98.1 3. I will submit the recommended example/language to this group. On Aug 2, 8:51 am, Anthony wrote: > On Tuesday, August 2, 2011 8:12:01 AM UTC-4, Matthew wrote: > > > Thank you! That bit of code

[web2py] Re: Not getting proper Janrain choices

ute to the documentation? I'd like to point out that "domain" is not actually the full domain as defined by Janrain's documentation, but your domain's application name. Thanks again, Matthew On Jul 31, 10:57 pm, Anthony wrote: > On Sunday, July 31, 2011 7:20:

[web2py] Re: Not getting proper Janrain choices

_account import RPXAccount auth.settings.actions_disabled = \ ['register','change_password','request_reset_password'] auth.settings.login_form = RPXAccount(request, api_key='xx',domain='x', url = "http://loca

[web2py] Re: Not getting proper Janrain choices

> Anthony > > > > > > > > On Sunday, July 31, 2011 3:00:50 PM UTC-4, Matthew wrote: > > I just tried to link a new web2py application with my Janrain account, > > but I am still seeing the default Janrain options on the /default/user/ > > login. My models/db.py has

[web2py] Not getting proper Janrain choices

"settings.login_method = 'janrain'" and "settings.login_config = 'domain:api_key'". Am I missing anything? I am using the layout plugin and a layout - is there another spot to alter in layouts? Thanks, Matthew

[web2py] Re: LIKE is slow on RDBS; true for GAE also?

Right, which is why this syntax is used: rows = db(buyer.id>0).select().find(lambda row:row.name.startswith('C')) I was just wondering how efficient this really is since it grabs the whole table. I'm going to try it on GAE, I was just wondering if anyone else had yet. On Jun 4, 2:21 am, Álvaro J

[web2py] LIKE is slow on RDBS; true for GAE also?

d is rather monotonous, does anyone know that the speed on GAE is much faster with the syntax above? Reference: http://www.web2pyslices.com/main/slices/take_slice/16 Thanks, Matthew

[web2py] Re: Running a script with Google App Engine

eb2py/browse_thread/thread/93d3dad8474735e0/0e5bc2a69f0767d6?lnk=gst&q=bulk+insert#0e5bc2a69f0767d6, does that mean they're only possible from within the application itself (not via script)? Thanks, Matthew On May 10, 7:04 pm, howesc wrote: > everything on GAE must be called via a

[web2py] Running a script with Google App Engine

You can run a script with Postgres or MySQL using this syntax: python web2py.py -S myapp -M -R applications/myapp/modules/ myscript.py Can a script be run in this way using App Engine as the datastore?

[web2py] Re: Service returns invalid function message

I did delete it accidentally. Thank you for the quick spot. On May 7, 12:12 am, mdipierro wrote: > works for me with 1.77.3 > > did you delete > > def call(): return service() > > On May 6, 11:08 pm, Matthew wrote: > > > I have a simple service running in we

[web2py] Service returns invalid function message

def hello(): return 'Hello!' And here is how I call refer to it from the HTML page: {{=URL(r=request, f='call/json/hello')}} Is there a change between how services are called? The documentation http://web2py.com/book/default/section/9/2?search=services looks the same. Thanks, Matthew

[web2py] Re: Different results in console vs. script

I figured it out (stupid mistake on my part). Part of the instructions at http://web2py.com/AlterEgo/default/show/260 include creating a test database. I dutifully followed those instructions, but neglected to change my DAL connection string to my actual database :P A great thanks to the community

[web2py] Re: Web2py Utilities

This is excellent! I know that the documentation is in its early stages, but are there any examples you can point to where this has been used? On Apr 29, 10:15 pm, muybay wrote: > Fantastic contribution Thadeus, I hope to contribute back a fraction > of what you have already done, many thanks! >

[web2py] Re: Different results in console vs. script

Note that I've renamed my root web2py folder to 'app' as you'll see below. >From console: >>> os.getcwd() '/home/matthew/dev/projects/mywebapp/src/app' >>> request.env.web2py_path >>> Print statements from search_test.py: /home/ma

[web2py] Re: Different results in console vs. script

what is in db._folder? > > On May 4, 9:27 pm, mdipierro wrote: > > > > > Perhpas something is causing the test script to pick up the wrong > > database. What is in request.folder from console? > > > On May 4, 8:44 pm, Matthew wrote: > > > > Thanks f

[web2py] Re: Different results in console vs. script

records in the db > already or are they stored by the unit_test? > > On May 4, 8:12 pm, Matthew wrote: > > > > > I'm attempting to unit test a method by > > followinghttp://web2py.com/AlterEgo/default/show/260. If I run the query > > inside > > the consol

[web2py] Different results in console vs. script

or.id>0).select().\ find(lambda row:row.name.startswith(term)) WORKS (17 results): python web2py.py -S myapp -M DOES NOT WORK (0 results): python web2py.py -S myapp -M -R applications/myapp/tests/test_search.py Thanks, Matthew

[web2py] Unit Testing - exec not adding controller to globals

I'm following the instructions from this post http://web2py.com/AlterEgo/default/show/260 but cannot get my methods recognized globally. ERROR MESSAGE: ERROR: test_suggest_performer (__builtin__.TestSearch) -- Traceback (most re

[web2py] Re: Database migration does not work

ine_table('performer', __performer, __audit,fake_migrate=True or > False) > db.define_table('performer_audit_trail', __performer, > __audit_trail,fake_migrate=True or False) > > On Apr 24, 10:07 am, Matthew wrote: > > > Here are the relevant parts of t

[web2py] Re: Database migration does not work

g new field __web_resource) db.define_table('performer', __performer, __audit) db.define_table('performer_audit_trail', __performer, __audit_trail) On Apr 24, 10:46 am, mdipierro wrote: > hmmm. I guess I need to the model then. fake_migrate was suppo

[web2py] Re: Database migration does not work

offending new field __performance_resource, __web_resource) db.define_table('performer', __performer, __audit) db.define_table('performer_audit_trail', __performer, __audit_trail) On Apr 24, 10:46 am, mdipierro wrote: > hmmm. I guess I

[web2py] Re: Database migration does not work

1.76.5 On Apr 24, 10:35 am, mdipierro wrote: > you must have a very old web2py version. > > On Apr 24, 9:25 am, Matthew wrote: > > > I'm including previously-defined tables in other tables to reduce > > maintenance. For example, I have "__web_resource"

[web2py] Re: Database migration does not work

I'm including previously-defined tables in other tables to reduce maintenance. For example, I have "__web_resource" table that has Wikipedia IDs, etc that I'm using in other tables. When I tried your suggestion, I got the following error: File "/home/matthew/de

[web2py] Re: Database migration does not work

>>> perf = db(db.performer.id > 0).first() Traceback (most recent call last): File "", line 1, in AttributeError: 'Set' object has no attribute 'first' >>> perf = db(db.performer.id > 0).select().first() Traceback (most recent call l

[web2py] Database migration does not work

0, but I don't think it's related to my issue. Thanks, Matthew

[web2py] Re: Can't use db in InteractiveConsole

Thanks! I've added this to my notes. On Mar 28, 11:23 am, mdipierro wrote: > python web2py.py -S myapp  -M > > On Mar 28, 10:05 am, Matthew wrote: > > > > > I'm trying to use web2py in the interactive console, but I'm getting > > NameErrors when acc

[web2py] Can't use db in InteractiveConsole

I'm trying to use web2py in the interactive console, but I'm getting NameErrors when accessing 'db'. The strange thing is, just a few days ago I was able to do this. Here is what I'm running: python web2py.py -S myapp >>> from gluon.sql import * >>> rows = db(db.mytable.id > 0) Traceback (most rec

  1   2   >