[web2py] Re: How to keep project separate from web2py itself?

2016-01-29 Thread Niphlod
PS: didn't have time to read through all, but did you consider using web2py.py -f /path/to/applications_directory ? I just fixed a couple of issues in trunk but it works fine. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source co

[web2py] class 'psycopg2.ProgrammingError'> relation "auth_user" already exists

2016-01-29 Thread Tom Campbell
App is on pythonanywhere, using Postgres. Connect string is: db = DAL('postgres://web2pydbadmin:mypassw...@memberable-96.postgres.pythonanywhere-services.com:10096/mydatabase') Existing topics like https://groups.google.com/forum/#!topic/web2py/p740UJkR3Ao do not seem to have helpful info.

[web2py] Re: class 'psycopg2.ProgrammingError'> relation "auth_user" already exists

2016-01-29 Thread Niphlod
web2py doesn't do database introspection. it basically works like this. whooo, someone defined a table in the model. are migrations turned on ? if yes is there a corresponding .table file ? if yes inspect the file and see if it matches table definition

[web2py] Re: examples using ADFS

2016-01-29 Thread Jason Solack
Thank you for the reply! I will be chatting with our clients today, i will let you know if this works out! On Tuesday, January 26, 2016 at 12:56:36 PM UTC-5, Massimo Di Pierro wrote: > > we support SAML2. I think ADFS can be accessed via SAML. would that work? > > On Tuesday, 26 January 2016 11:

[web2py] Re: web2py built-in autocomplete widget

2016-01-29 Thread Anthony
See answer on Stack Overflow: http://stackoverflow.com/a/35086859/440323 On Thursday, January 28, 2016 at 4:52:11 PM UTC-5, Steven Zhou wrote: > > need a hint on web2py built-in autocomplete widget. > > in controller: db.otc_products.counterparty.widget = > SQLFORM.widgets.autocomplete(request, d

[web2py] Re: How to keep project separate from web2py itself?

2016-01-29 Thread Anthony
On Friday, January 29, 2016 at 3:00:47 AM UTC-5, Niphlod wrote: > > PS: didn't have time to read through all, but did you consider using > web2py.py -f /path/to/applications_directory ? I just fixed a couple of > issues in trunk but it works fine. > I think he wants to be able to put each indivi

[web2py] Re: Problem with sqlite3 and WAL

2016-01-29 Thread peter
I am restating my problem with all that I now know. > I have a version of sqlite3 that is 3.7... > > I have been having problems with the database being locked. > > So I tried > db.executesql("PRAGMA journal_mode=WAL;") > > (just once) > > I then cannot access the application without getting

[web2py] Re: Problem with sqlite3 and WAL

2016-01-29 Thread Niphlod
file permissions should be the issue because those files are not usual ones. On Friday, January 29, 2016 at 3:45:09 PM UTC+1, peter wrote: > > I am restating my problem with all that I now know. > > >> I have a version of sqlite3 that is 3.7... >> >> I have been having problems with the databa

[web2py] Re: Problem with sqlite3 and WAL

2016-01-29 Thread peter
The strange thing is that it works okay with another app. So what I can I do about permissions. The permissions for the databases folder are okay. If I change the permissions on those files the changes are non persistent. So I am stuck. On Friday, 29 January 2016 14:58:26 UTC, Niphlod wrote: >

[web2py] Re: Where to find "old issues" that were in google code?

2016-01-29 Thread Anthony
On Thursday, January 28, 2016 at 11:24:16 PM UTC-5, Dave wrote: > > Actually, maybe this is a bug. (or maybe just something that is not > supposed to work the way I am trying to use it...) > > If I turn off lazy_table support, everything works. I get a multi-select > box with the file_name pop

Re: [web2py] Re: How do I make my web2py app able to use the device hardwares like camera?

2016-01-29 Thread Jason (spot) Brower
Actually you can record video and take picture by using the right kind of html tags. It will involve the camera app and have it ready to upload. Do it in one of my apps all the time. On Fri, Jan 22, 2016, 11:51 Dave S wrote: > On Sunday, January 17, 2016 at 9:05:50 AM UTC-8, henryj...@gmail.com

Re: [web2py] Re: How do I make my web2py app able to use the device hardwares like camera?

2016-01-29 Thread Dave S
On Friday, January 29, 2016 at 10:02:58 AM UTC-8, Encompass solutions wrote: > > Actually you can record video and take picture by using the right kind of > html tags. It will involve the camera app and have it ready to upload. Do > it in one of my apps all the time. > Ooooh, I was assuming "cam

[web2py] Re: web2py built-in autocomplete widget

2016-01-29 Thread Dave S
On Friday, January 29, 2016 at 6:26:05 AM UTC-8, Anthony wrote: > > See answer on Stack Overflow: http://stackoverflow.com/a/35086859/440323 > That would make a good sidebar in the book. (The book doesn't presently include any sidebars, does it? Perhaps a "tips and tricks" chapter, then.) /dps

[web2py] Re: How to keep project separate from web2py itself?

2016-01-29 Thread Dave S
On Friday, January 29, 2016 at 6:27:36 AM UTC-8, Anthony wrote: > > On Friday, January 29, 2016 at 3:00:47 AM UTC-5, Niphlod wrote: >> >> PS: didn't have time to read through all, but did you consider using >> web2py.py -f /path/to/applications_directory ? I just fixed a couple of >> issues in

[web2py] Re: SQLFORM changing the column of record

2016-01-29 Thread Dave S
On Thursday, January 28, 2016 at 8:36:47 AM UTC-8, Lucas Schreiber wrote: > > Hi, > ist there a way to change the column of the record in an SQLFORM? > > For example, my code looks like this: > > module > dba.define_table('test_table', > Field('field_1', 'integer'), > Field('field_2', 'integer'))

[web2py] Re: Problem with sqlite3 and WAL

2016-01-29 Thread Dave S
On Friday, January 29, 2016 at 7:34:57 AM UTC-8, peter wrote: > > The strange thing is that it works okay with another app. So what I can I > do about permissions. The permissions for the databases folder are okay. If > I change the permissions on those files the changes are non persistent. So

[web2py] Re: class 'psycopg2.ProgrammingError'> relation "auth_user" already exists

2016-01-29 Thread Dave S
On Friday, January 29, 2016 at 2:11:38 AM UTC-8, Niphlod wrote: > > web2py doesn't do database introspection. > it basically works like this. > > whooo, someone defined a table in the model. are migrations turned on > ? > if yes > is there a corresponding .table file ? >if

[web2py] Re: SQLFORM changing the column of record

2016-01-29 Thread Anthony
So just to clarify, the "record" argument to SQLFORM can either be the id of the desired record, or it can be a Row object containing the record (i.e., the result of querying the database to retrieve the record). record = db(db.test_table.field_1 == request.args(0)).select() > We want a Row obj

[web2py] Re: SQLFORM changing the column of record

2016-01-29 Thread Dave S
On Friday, January 29, 2016 at 12:11:07 PM UTC-8, Anthony wrote: > > So just to clarify, the "record" argument to SQLFORM can either be the id > of the desired record, or it can be a Row object containing the record > (i.e., the result of querying the database to retrieve the record). > Ah, I

[web2py] Re: Problem with sqlite3 and WAL

2016-01-29 Thread peter
I imagine it is sqlite3 itself that is creating them. How one can get it to change the way it does things I do not know. As I say it seems to work ok with another app that is in the same setup. So why sqlite should behave in an app specific way I do not know. Peter -- Resources: - http://web2

[web2py] How to move Postgres apps?

2016-01-29 Thread Alex Glaros
I move my app back and forth between different development PCs and when I pack the app on site #1 and upload to site #2 there is no data in it. Transferring worked with sqLite as the database but I can't get PostGres version to work. Tried many combinations of migrate, fake_migrate, true, false

[web2py] Re: How to move Postgres apps?

2016-01-29 Thread Niphlod
set migrate=False. do a backup (pgdump) on #1 do a restore on #2 live happy. On Friday, January 29, 2016 at 10:07:02 PM UTC+1, Alex Glaros wrote: > > I move my app back and forth between different development PCs and when I > pack the app on site #1 and upload to site #2 there is no data in it. >

[web2py] Re: class 'psycopg2.ProgrammingError'> relation "auth_user" already exists

2016-01-29 Thread Niphlod
Thanks pal, it's not my first, probably won't be not my last, and surely it's not my best. The book has http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Migration-control-summary . This is one of the areas that I can't explain better probably because to me it's s

[web2py] Re: Login App engine

2016-01-29 Thread Charles tenorio
cool it was the *tbl(tbl auth_event, aut_group, auth_membership, auth_user)* tbl were created but were not created (auth_cas, auth_permission) ? when I try to log of this error Traceback (most recent call last): File "/base/data/home/apps/s~jogosweb-1188/1.390332252053968354/gluon/main.py",

[web2py] Re: How to move Postgres apps?

2016-01-29 Thread Anthony
Keep in mind that when using SQLite, the database moves with the app because the SQLite database file is stored in the app's /databases folder. This is not the case for any other databases. Anthony On Friday, January 29, 2016 at 4:07:02 PM UTC-5, Alex Glaros wrote: > > I move my app back and fo

[web2py] Re: Good Practices - Custom Auth (default table) VS. Defining Own Auth Tables (for different user level)

2016-01-29 Thread Ron Chatterjee
Is there an example of how to split the auth_user in two tables that allows people to sign up using the same way but allowing in creating two profiles (lets say one for seller and one as a buyer)? Anyone did something like that? On Saturday, February 28, 2015 at 8:07:03 AM UTC-5, Jon M. wrote

[web2py] Re: How to move Postgres apps?

2016-01-29 Thread Alex Glaros
worked! your last line sums up my feelings :-) -- 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 subscribed to

Re: [web2py] Re: Good Practices - Custom Auth (default table) VS. Defining Own Auth Tables (for different user level)

2016-01-29 Thread Marcelo Theodoro
See [1]. I'm working on a project that needs seller/buyer logins, where the seller needs to input information about the store and the buyer must provide and address. But instead of be using the auth_user table to store that information, I'm using db.store and db.address, and then after the user(se

Re: [web2py] Re: Good Practices - Custom Auth (default table) VS. Defining Own Auth Tables (for different user level)

2016-01-29 Thread Ron Chatterjee
Thank you. Web2py group rocks! On Friday, January 29, 2016 at 5:37:02 PM UTC-5, Marcelo Theodoro wrote: > > See [1]. > I'm working on a project that needs seller/buyer logins, where the seller > needs to input information about the store and the buyer must provide and > address. But instead of

[web2py] Form created using helper - load image

2016-01-29 Thread isi_jca
Hi!!! I have a form created using Helper HTML, It is has manye field form = FORM(TABLE( TR(TD(LABEL("Foto 1:",_class="label_foto5"), INPUT(_class="upload",_id="foto5",_name="foto5", _type="file", _onchange="leerarchivobin('foto5','

[web2py] Re: Where to find "old issues" that were in google code?

2016-01-29 Thread Dave S
On Thursday, January 28, 2016 at 7:19:31 PM UTC-8, Dave wrote: > > Thanks Anthony. I looked for the issue number from the original poster, > but the ticket that came up wasn't related to list: reference... There > doesn't seem to be any other context in the post. Any idea what else I can > sea

[web2py] Re: Where to find "old issues" that were in google code?

2016-01-29 Thread Dave
Thanks Anthony. Yes, actually I am looking now and I see that it was late and Yes, it started working when I set lazy_tables to True, not False. And omitting requires= was a mistake. I will test it without the entire IS_IN_DB string now. I expect it will work just fine. Sometimes it's hard