[web2py] Re: PostgreSQL replication

2010-11-11 Thread ron_m
Thanks for the pointers from both of you, I appreciate that. It would be best to have multiple master but that will be very difficult. Bucardo has multiple master but only for 2 masters once you get into the docs for it. The MySQL scheme I mentioned used primary key skipping on autonumbers so if th

[web2py] Re: plugin_matplotlib

2010-11-11 Thread mart
so tried a few things, and my conclusion (unless someone knows a trick, which I would love to know): the current matplotlib does not install on Mac OS X 10.6 :(. I'll try again later on Linux (or maybe even dust off my windows laptop ;) ) Mart :) On Nov 11, 10:39 pm, mart wrote: > ah.. then w

Re: [web2py] Re: Pagination [Web2py Utils] returns None

2010-11-11 Thread Thadeus Burgess
Mind sending me a patch? -- Thadeus On Thu, Nov 11, 2010 at 6:02 PM, Andrew Evans wrote: > hey thanks for the tips > > I have it working now > > *cheers > > Andrew >

[web2py] how to use ExtendedLoginForm ?

2010-11-11 Thread Bruno Rocha
Hi, I am trying to have both default login form and RPX working. Looking for login_methods on gluon.contrib I found ExtendedLoginForm """ ExtendedLoginForm is used to extend normal login form in web2py with one more login method. So user can choose the built-in login or extended login methods. ""

[web2py] Re: plugin_matplotlib

2010-11-11 Thread mart
ah.. then will get numpy (though I thought i had that... maybe for the move to 2.7...) Mart :) On Nov 11, 10:05 pm, mdipierro wrote: > This plugin works with web2py source and assumes you have numpy > +matplotlib installed. Sorry I did not clarify. > > On Nov 11, 8:35 pm, mart wrote: > > > Hey,

[web2py] Re: plugin_matplotlib

2010-11-11 Thread mdipierro
This plugin works with web2py source and assumes you have numpy +matplotlib installed. Sorry I did not clarify. On Nov 11, 8:35 pm, mart wrote: > Hey, > > I don't see any responses, so not sure if this was meant for anybody > in particular but tried it anyways. I got this error: > > Traceback

[web2py] Re: Importing SQL script.

2010-11-11 Thread mdipierro
yes and no you can run db.executesql(""" your script """) you can also run scripts/extract_mysql_models.py or scripts/ extract_pgsql_models.py to generate models from you from the tables in the database. The problem is that web2py needs more info than the data in your script (validators, fie

[web2py] Re: How do I construct my query to handle a multiple select?

2010-11-11 Thread mdipierro
sorry I do not understand the question. On Nov 11, 6:12 pm, Lorin Rivers wrote: > I have a form using this: >   options=[str(my_macaddr[i].MacAddr) for i in range(len(my_macaddr))] >   form=FORM(SELECT(*options,_name='MacAddrSelect',_multiple='multiple'),INPUT >   (_type='submit')) > >   records

[web2py] Re: web2py 1.88.1 is OUT

2010-11-11 Thread mdipierro
This was fixed in trunk. On Nov 11, 5:49 pm, mattynoce wrote: > i'm seeing appadmin break for my auth_user table with a picture. when > i have a photo, update works fine. when the photo is not there, i get > an error: > > KeyError: 'picture_blob' > > and from top to bottomw: > gluon/restricted.py

Re: [web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread Bruno Rocha
PROBLEM SOLVED! I created 2 instances of Auth() rpxauth = Auth(globals(),store) auth = Auth(globals(),store) and 2 times defined tables auth.define_tables() rpxauth.define_tables(migrate=False) Working now! Thanks 2010/11/11 rochacbruno > I did it, registration is working, but login for

[web2py] Re: plugin_matplotlib

2010-11-11 Thread mart
Hey, I don't see any responses, so not sure if this was meant for anybody in particular but tried it anyways. I got this error: Traceback (most recent call last): File "/Users/mart/web/latest/8_nov/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/U

[web2py] Re: web2py as a cross-platform mobile application platform

2010-11-11 Thread mindsynch
I think I narrowed the problem down to activesync. import tools worked fine, and I was able to actually import from gluon.tools in web2py. But I happened to notice that when I disconnect the pda from my laptop, browse to a couple pages in our web2py project, then reconnect, errors start occuring. S

[web2py] Re: simple table div

2010-11-11 Thread Lance
I like it:) On 11월11일, 오전7시08분, "Martin.Mulone" wrote: > I decided to start to make my own implementation of table maker. The > diference with sqltable or TABLE(), it use div (more flexible), accept > web2py helpers as values and is very simple to use. > > Example: > > http://web2pytesting.appspo

Re: [web2py] FYI - Google Refine - transforms messy data

2010-11-11 Thread Manu
This is an amazing app ! On Fri, Nov 12, 2010 at 12:48 AM, mikech wrote: > Just in case you didn't see this impressive piece of software, here is > the link: http://code.google.com/p/google-refine/ > > The videos are well worth watching, and the app is a desktop program > so you don't have to sha

[web2py] Re: Importing SQL script.

2010-11-11 Thread Crim
The sql script is just a sql script that creates a sql db basically i was hoping i could import the script in to the natively supported db's that web2py supports. On Nov 11, 3:31 pm, mdipierro wrote: > what DB are we talking about? What does the SQL script do? > > On Nov 11, 3:25 pm, Richard Véz

Re: [web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread rochacbruno
I did it, registration is working, but login form was replaced with janrain, I am trying to get both login forms. Otherwise I will create a custom form and a controller for that. Tks Enviado via iPhone Em 11/11/2010, às 21:49, Albert Abril escreveu: > I guess you should comment second lin

[web2py] How do I construct my query to handle a multiple select?

2010-11-11 Thread Lorin Rivers
I have a form using this: options=[str(my_macaddr[i].MacAddr) for i in range(len(my_macaddr))] form=FORM(SELECT(*options,_name='MacAddrSelect',_multiple='multiple'),INPUT (_type='submit')) records = db4((db4.data_table.MacAddr==request.vars.MacAddrSelect) & (db4.data_table.ReqTime>='2010-

Re: [web2py] Re: Pagination [Web2py Utils] returns None

2010-11-11 Thread Andrew Evans
hey thanks for the tips I have it working now *cheers Andrew

Re: [web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread Albert Abril
I guess you should comment second line of the janrain auth in db.py As said at http://web2py.com/book/default/chapter/08#Integration-with-OpenID,-Facebook 1. 2. 3. 4. 5. 6. from gluon.contrib.login_methods.rpx_account import RPXAccount auth.settings.actions_disabled=['register','change_password'

[web2py] Re: web2py 1.88.1 is OUT

2010-11-11 Thread mattynoce
i'm seeing appadmin break for my auth_user table with a picture. when i have a photo, update works fine. when the photo is not there, i get an error: KeyError: 'picture_blob' and from top to bottomw: gluon/restricted.py line 188 init/controllers/appadmin.py:update line 410 gluon/globals.py line 9

[web2py] FYI - Google Refine - transforms messy data

2010-11-11 Thread mikech
Just in case you didn't see this impressive piece of software, here is the link: http://code.google.com/p/google-refine/ The videos are well worth watching, and the app is a desktop program so you don't have to share your data. In the 2nd video he demonstrates how to turn a wiki list into a table

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread mdipierro
Now I get it source=os.path.join(request.folder,'uploads/Image.image.a278723.jpg') dest=os.path.join(request.folder,'uploads/advertisement.jpg') shutil.copy(source,dist) On Nov 11, 4:38 pm, CesarBustios wrote: > shutil.copy("uploads/Image.image.a278723.jpg", "uploads/ > advertisement.jpg") > > I

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread CesarBustios
shutil.copy("uploads/Image.image.a278723.jpg", "uploads/ advertisement.jpg") I need the correct path, is it the whole path /home/cesar/web2py/ applications/bluetooth/uploads/image1.jpg i tried different ways but im still getting that error. On 11 nov, 17:36, CesarBustios wrote: > I have like 20

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread CesarBustios
I have like 20 images in the uploads directory, they are all advertising images, if i want to send, say image1 first, i need to make a copy in the same directory with the name "advertisement", if i need to send imag16 i have to do the same thing and rename it to "advertisement". Im sending via blue

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread mdipierro
You call: shutil.copy(path, destination) if path and destination are the same value there is nothing to copy. shutil.copy(path, destination) path and destination must be different filenames. On Nov 11, 4:12 pm, CesarBustios wrote: > path and destination are in fact the same directory (uploads

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread mdipierro
Not at all. It just happened that I have been monitoring today and I know the people who filled the form, so I approved them. You specifically have been a contributing member of this community for some time. I will not be so prompt and may need to be reminded. For now I will handle approval. When

Re: [web2py] flow charts

2010-11-11 Thread José Ignacio Hurtado
Thanks Michele, i did not know it. 2010/11/10 Michele Comitini > Hi mart, > > Not a flowchart app, a library, but you can make very nice charts if > you need to show them with web2py: > > > http://morrisonpitt.com/jsPlumb/html/jquery/demo.html > > mic > > 2010/11/10 mart : > > Hey, > > > > Anyb

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread CesarBustios
path and destination are in fact the same directory (uploads) i'm just trying to make a copy. Thanks On 11 nov, 11:12, mdipierro wrote: > what are path and destination? > > On Nov 11, 9:20 am, CesarBustios wrote: > > > > > I'm using the whole path, i'm trying everything but i can't copy the > >

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread GoldenTiger
I did login at www.experts4solutions.com and now I appears at "our experts", then anyone can be an expert? Before appearing as expert, I want to make merit :) On 11 nov, 22:21, José Ignacio Hurtado wrote: > Sounds interesting. > > 2010/11/11 Branko Vukelic > > > > > On Thu, Nov 11, 2010 at 9:31

Re: [web2py] web2py organization - important for consultants !!!

2010-11-11 Thread Michele Comitini
Simply great! +1 mic 2010/11/11 mdipierro : > This is important. Please read! > > These days I am getting a lot of private requests from people/ > businesses who need consulting development jobs in web2py. This is > more than can I can handle. I need to keep track who is available and > who is ca

Re: [web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread Bruno Rocha
Somebody knows how can I use RPX and Normal Login form in the same way that web2pyslices are using here: http://web2pyslices.com/main/default/user/login ??? 2010/11/11 Bruno Rocha > It is a commom mistake, so I think is a good idea to include a note in > /book and in db.py for scaffold app. >

[web2py] Re: Importing SQL script.

2010-11-11 Thread mdipierro
what DB are we talking about? What does the SQL script do? On Nov 11, 3:25 pm, Richard Vézina wrote: > First you have to define your legacy database model in web2py model then you > will be able to make query a la web2py or raw sql query. > > Richard > > On Thu, Nov 11, 2010 at 10:26 AM, Crim wr

[web2py] Re: web2py as a cross-platform mobile application platform

2010-11-11 Thread mdipierro
Now I am very confused. can you now try simply import tools.py? If you still get the Memory error can you comment: urllib2.install_opener(urllib2.build_opener(urllib2.HTTPCookieProcessor())) in tools and try import it again? On Nov 11, 3:23 pm, mindsynch wrote: > I just ran these commands fro

Re: [web2py] Importing SQL script.

2010-11-11 Thread Richard Vézina
First you have to define your legacy database model in web2py model then you will be able to make query a la web2py or raw sql query. Richard On Thu, Nov 11, 2010 at 10:26 AM, Crim wrote: > So im working on a webapp that will access a database.. which isnt > overly hard but i want to import som

[web2py] Re: web2py as a cross-platform mobile application platform

2010-11-11 Thread mindsynch
I just ran these commands from pythonce's idle, and they all worked. The only hiccup was when running 'from storage import Storage, StorageList, Settings, Messages', it said 'No handlers could be found for logger "web2py"', but it still seemed to import it. On Nov 11, 12:48 am, mdipierro wrote: >

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread GoldenTiger
Massimo, It's great! I hope to soon make good contributions to web2py, When I discovered web2py, I turned to learn, thanks to that I now work as a freelancer creating websites in web2py, and I'm messing with the risks of several different servers, and learning which are the most typical problems.

Re: [web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread José Ignacio Hurtado
Sounds interesting. 2010/11/11 Branko Vukelic > On Thu, Nov 11, 2010 at 9:31 PM, VP wrote: > > I truly hope so. Currently, the book and this mailing list are two > > sources for learning about web2py. I hope this new venture is not > > diminishing future improvements of both of these. > >

Re: [web2py] Re: readable=False not working with crud.select(db.table)

2010-11-11 Thread Richard Vézina
I don't following you.. On Thu, Nov 11, 2010 at 9:44 AM, andrej burja wrote: > i'm using WebGrid for Web2py > > making a filed not readable (and writable) doesn't show them in edit > or view > but in grid, the fields are shown > Is grid and WebGrid the samething?? This issue have been fix in

Re: [web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread Bruno Rocha
It is a commom mistake, so I think is a good idea to include a note in /book and in db.py for scaffold app. 2010/11/11 Albert Abril > hehe.. it happens to me too. > > you should write only the name of the subdomain. > if you have http://web2pyapp.rpxnow.com , you have to write only > 'web2pyap

Re: [web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread Albert Abril
hehe.. it happens to me too. you should write only the name of the subdomain. if you have http://web2pyapp.rpxnow.com , you have to write only 'web2pyapp' . I hope this help to others. Regards! On Thu, Nov 11, 2010 at 10:02 PM, Bruno Rocha wrote: > SOLVED! > > It was an error on configuration,

[web2py] Re: Problem with RPX - janrain engage

2010-11-11 Thread Bruno Rocha
SOLVED! It was an error on configuration, domain parameter on RPXAccount expect just a domainname, I was providing full URL. Thanks 2010/11/11 Bruno Rocha > HI, > > I am trying to activate janrain as the loggin method, and I want to keep > the normal login method too. > > but I am getting this

Re: [web2py] Re: PostgreSQL replication

2010-11-11 Thread Michele Comitini
There are some good news for postgresql 9.0: http://www.postgresql.org/docs/9.0/interactive/warm-standby.html some of those features above are possible on 8.4 with some difficult configuration tricks, see wiki.postgresql.org. mic 2010/11/11 mdipierro : > Hi Ron, > I do not much about this topi

[web2py] Re: radio button issue

2010-11-11 Thread mattynoce
okay, i think i figured out the problem, but i don't know about a long- term solution. based on my experience, plus these threads: - http://groups.google.com/group/web2py/browse_thread/thread/1a59a8995a270f71/fa2ffa0cdaa286c4?hl=en&lnk=gst&q=boolean+radio#fa2ffa0cdaa286c4 - http://groups.google.co

[web2py] Problem with RPX - janrain engage

2010-11-11 Thread Bruno Rocha
HI, I am trying to activate janrain as the loggin method, and I want to keep the normal login method too. but I am getting this error: "This frame was blocked because it contains insecure content." http://natalanimal.com.br/init/default/user/login Any idea?

[web2py] Re: radio button issue

2010-11-11 Thread mattynoce
unfortunately, that didn't work either. both your version and mine show the proper thing online: o Yes o No but neither version will allow me to click on No and have it register as False in the database. i even made it simpler: Field('isComplete', 'boolean', widget=SQLFORM.widgets.radio.widget,

Re: [web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Branko Vukelic
On Thu, Nov 11, 2010 at 9:31 PM, VP wrote: > I truly hope so.  Currently, the book and this mailing list are two > sources for learning about web2py.   I hope this new venture is not > diminishing future improvements of both of these. Oh, that's just silly. I don't see how experts4solutions could

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread VP
>experts4solutions is not a discussion group and will not affect this mailing list. I truly hope so. Currently, the book and this mailing list are two sources for learning about web2py. I hope this new venture is not diminishing future improvements of both of these.

[web2py] Re: Web2py Application Exhibition ( Version 2.0 )

2010-11-11 Thread GoldenTiger
I'll be there, actually I am devoting most of my time studying web2py. I hope to do a nice application. :) On 8 nov, 20:20, Mr admin wrote: > Sure! > > Plugins are just miniature applications right?  :-) > > Mr.NetAdmin > > On Mon, Nov 8, 2010 at 1:13 PM, mr.freeze wrote: > > Can we submit be a

[web2py] Re: Web2py Application Exhibition ( Version 2.0 )

2010-11-11 Thread GoldenTiger
I'll be there, actually I am devoting most of my time studying web2py. I hope to do a nice application. :) On 8 nov, 20:20, Mr admin wrote: > Sure! > > Plugins are just miniature applications right?  :-) > > Mr.NetAdmin > > On Mon, Nov 8, 2010 at 1:13 PM, mr.freeze wrote: > > Can we submit be a

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Luther Goh Lu Feng
Nice. I hope to improve myself enough so I can join. On Nov 12, 4:05 am, mdipierro wrote: > LOL > > On Nov 11, 1:42 pm, Branko Vukelic wrote: > > > > > > > > > Massimo, you need to make another service offering proof-reading. > > These guys are really good. :D > > > On Thu, Nov 11, 2010 at 8:35

[web2py] Re: Custom JSON-RPC error codes

2010-11-11 Thread Matt
Thanks Massimo :) Will check it out. Matt > Ok. In trunk. > Please give this a try > > raise service.JsonRpcException(100,"info") > > On Nov 10, 10:07 pm, Matt wrote: > > Hi there, > > > > (This is probably more or a small request that a question.) > > > > The JSON-RPC service by default always

[web2py] Re: PostgreSQL replication

2010-11-11 Thread mdipierro
Hi Ron, I do not much about this topic. Will single master be enough? You may want to look into these tools as well. http://www.slony.info/ http://www.sistemasagiles.com.ar/trac/wiki/PyReplicaEn https://public.commandprompt.com/projects/replicator On Nov 11, 1:51 pm, ron_m wrote: > Any of you

Re: [web2py] Re: DAL() unusable ?

2010-11-11 Thread Mariano Reingart
2010/11/11 Mirek Zvolský : > Oh no!,no!,no! please no! > I still hope it's my mistake only. I simple cannot believe, that this > is behaviour of web2py data model. Are we in year 1960? > Friends, take a look to the oldest database implementations older as > SQL language, in MS-DOS times, f.e. dBase

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread mdipierro
LOL On Nov 11, 1:42 pm, Branko Vukelic wrote: > Massimo, you need to make another service offering proof-reading. > These guys are really good. :D > > > > On Thu, Nov 11, 2010 at 8:35 PM, Stefaan Himpe > wrote: > > Some more typos in the guidelines page... > > > faled prototypes can be minimize

[web2py] PostgreSQL replication

2010-11-11 Thread ron_m
Any of you have experience with Bucardo or pgpool-II as a replication add-on? Some background: I switched from MySQL to PostgreSQL very cleanly using web2py as the vehicle. Sort description to document the process: Made a copy of the app, removed the content of the databases directory, added the p

Re: [web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Branko Vukelic
Massimo, you need to make another service offering proof-reading. These guys are really good. :D On Thu, Nov 11, 2010 at 8:35 PM, Stefaan Himpe wrote: > Some more typos in the guidelines page... > > faled prototypes can be minimized by > => failed prototypes can be minimized [also remove the word

[web2py] Re: flow charts

2010-11-11 Thread mart
yes... noticed that ... although, the "graffles" diagram-ish look and feel about it seems well for the task as well, in that once the view finds the raphael js files (and the css), using it becomes very insinuative (i mean easy - meaning even I can use it ;) )... that said, I wonder if its ease of

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Stefaan Himpe
Some more typos in the guidelines page... faled prototypes can be minimized by => failed prototypes can be minimized [also remove the word "by"] it is not as an alternative to executing the full project project. => [it mentions project twice at the end of the sentence] mjor contributor => major

[web2py] Re: DAL() unusable ?

2010-11-11 Thread mdipierro
True. On Nov 11, 1:23 pm, Thadeus Burgess wrote: > I still do not agree. > > If you run into this issue you can always offset the created_by fields... > > db.define_table('audit_table', > > Field('tablename'), Field('record_id', 'integer'), > > Field('created_by', db.auth_user), > > ) > > If you

Re: [web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Bruno Rocha
There's a typo on page title 2010/11/11 Stefaan Himpe > Still looks very slick :) > > But there's a second typo on > http://www.experts4solutions.com/e4s/default/guidelines > > In the first sentence of the RAD section it says "but a belief" where I > expected something like "by a belief"... > >

Re: [web2py] Re: DAL() unusable ?

2010-11-11 Thread Thadeus Burgess
I still do not agree. If you run into this issue you can always offset the created_by fields... db.define_table('audit_table', Field('tablename'), Field('record_id', 'integer'), Field('created_by', db.auth_user), ) If you ever did need to audit, just look it up in this table. Then you don't h

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Stefaan Himpe
Still looks very slick :) But there's a second typo on http://www.experts4solutions.com/e4s/default/guidelines In the first sentence of the RAD section it says "but a belief" where I expected something like "by a belief"... Best regards, Stefaan.

[web2py] Re: Renaming a column in the database web2py?

2010-11-11 Thread mdipierro
Than the way to go is to allow customization of headers in datatable. You should be able to easily moify the way the table are build and use a db.table.field.label as header, On Nov 11, 12:48 pm, Marcelo Martinez wrote: > The reason for wanting to rename the column is because I am using the plugi

[web2py] Re: web2py organization - important for consultants !!!

2010-11-11 Thread Stefaan Himpe
-- http://www.experts4solutions.com -- Looks very slick :) There's a typo on http://www.experts4solutions.com/e4s/default/companies (it says "conact" instead of "contact") Best regards, Stefaan.

Re: [web2py] simple table div

2010-11-11 Thread Bruno Rocha
Martin, Your CSS Table mixed with inline editing http://web2pyslices.com/main/slices/take_slice/23 will be a solution that I was looking for. Thank you. 2010/11/11 Martín Mulone > yes, all is in simpletable.py > > 2010/11/11 Bruno Rocha > > The whole implementation is in "simpletable.py" or i

Re: [web2py] Re: Renaming a column in the database web2py?

2010-11-11 Thread Marcelo Martinez
The reason for wanting to rename the column is because I am using the plugin web2py.plugin.datatable.w2p and make the query as: rows = db (db.accountcode.id_clientes == session.cliente_id). select (Db.accountcode.ani) I get the title of the column and I want to show accountcode.ani annex the title.

Re: [web2py] web2py organization - important for consultants !!!

2010-11-11 Thread Branko Vukelic
On Thu, Nov 11, 2010 at 3:52 PM, mdipierro wrote: >    http://www.experts4solutions.com Nice! > I love working with you guys. web2py is what today keeps us together > but web2py is a tool and one day (2100?) it will be replaced by a > better one. Yes, it's called web3py. \(^o^)/ -- Branko V

[web2py] Re: Can´t do redirect

2010-11-11 Thread yamandu
One thing that could have to do with this is that I downgrade Python recently from 2.5 to 2.5 On Nov 9, 2:30 pm, yamandu wrote: > After upgraded I got exception when try toredirectusingredirect(URL()). > > I used to do : > returnredirect(URL(r=request, f='modelo')) > > but it works no more, gives

[web2py] Re: DAL() unusable ?

2010-11-11 Thread mdipierro
I agree with you that using a link table is better. This was my original argument. Yet often the need to sign tables (created_by) will suddenly cause a duplication of tables because lots of link tables have to be added and queries changed. This is what I meant by good case. Massimo On Nov 11, 12

Re: [web2py] Re: Renaming a column in the database web2py?

2010-11-11 Thread Thadeus Burgess
To rename a column: #Let web2py use migration to create a new column db.define_table('table', Field('oldcolumn'), Field('newcolumn')) #Update the data, copy the old column into the new column db(db.table.id > 0).update(db.table.newcolumn = db.table.oldcolumn) #Save the changes db.commit() #Rem

Re: [web2py] Re: DAL() unusable ?

2010-11-11 Thread Thadeus Burgess
WRong. cr2 is a really really bad design. Database 101, any many to many relationship must be defined through a link table. Redesign CR2 like so... db.define_table('person', created_by('person')) db.define_table('company',...created_by('company')) db.define_table('person_company', id_perso

[web2py] Re: DAL() unusable ?

2010-11-11 Thread mdipierro
Ok. Your crm2jpg makes a good case. You proved me wrong. I will try add this by the week-end. Massimo On Nov 11, 11:24 am, Mirek Zvolský wrote: > -> mdipierro > I have prepared 2 pictures, and in this time there is new post from > you about company/author. Interesting that my pictures are about

[web2py] Re: DAL() unusable ?

2010-11-11 Thread Mirek Zvolský
-> mdipierro I have prepared 2 pictures, and in this time there is new post from you about company/author. Interesting that my pictures are about the same :-) Model of your CRM application application is here: http://zvolsky.alwaysdata.net/crm1.jpg Such model can be implemented in web2py, but orde

[web2py] Re: Authentication and multiple logon sessions

2010-11-11 Thread mdipierro
Short answer no. Yet I found this: http://www.fusioncube.net/index.php/multiple-sessions-firefox I did not try it. On Nov 11, 11:14 am, Alex wrote: > Hello, > > I have a question regarding how the authentication defines each unique > user session.  I am working on an app that uses the authentic

Re: [web2py] Re: Learning Management System survey

2010-11-11 Thread José Ignacio Hurtado
How many people are interested in contributing to this project? We will need: 1. *Expert users* who have the knowledge and experience of using an LMS and know the *needs* that future users will have. They will help initially *defining the functions and elements* of the project and helpin

[web2py] Re: DAL() unusable ?

2010-11-11 Thread DenesL
Wasn't this a no-no?. I got wrist slapped once for suggesting it. :) On Nov 11, 11:53 am, mdipierro wrote: > BTW. This is possible: > > db.define_table('company', > Field('name'), > Field('created_by', 'integer')) > db.define_table('person', > Field('last_name'), > Field('compan

[web2py] Authentication and multiple logon sessions

2010-11-11 Thread Alex
Hello, I have a question regarding how the authentication defines each unique user session. I am working on an app that uses the authentication and was trying to test with multiple users logged onto my site. My test is opening IE and logging onto the site as one user, then opening a new IE insta

Re: [web2py] DAL() unusable ?

2010-11-11 Thread rams anu
also me.. On 11/11/2010, Mirek Zvolský wrote: > I have simplest model: > > db.define_table('company', > Field('name'), > Field('created_by', 'reference person')) > db.define_table('person', > Field('last_name'), > Field('company_id', 'reference company')) > > but I receive error:

[web2py] Re: DAL() unusable ?

2010-11-11 Thread mdipierro
BTW. This is possible: db.define_table('company', Field('name'), Field('created_by', 'integer')) db.define_table('person', Field('last_name'), Field('company_id', 'reference company')) db.company.created_by.requires=IS_IN_DB(db,'person.id','% (last_name)s') although my object sta

[web2py] Re: DAL() unusable ?

2010-11-11 Thread DenesL
I was thinking of scripted table creation and keeping things simple but I understand what you are saying (or reiterating since it has been said before). If no valid case is made then I could change the manual to explain why it is not supported. Pros/Cons? Denes. On Nov 11, 11:18 am, mdipierro

[web2py] Re: DAL() unusable ?

2010-11-11 Thread mdipierro
>From a syntactical point of view it would not take much to support multi-table circular references in web2py. That is not why they are not implemented, They are not implemented because they are bad design practice. If this is a 1-1 relation, there is no need to table A to refer to B and B to A. I

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread mdipierro
what are path and destination? On Nov 11, 9:20 am, CesarBustios wrote: > I'm using the whole path, i'm trying everything but i can't copy the > file. Any thoughts? > > On 10 nov, 20:18, CesarBustios wrote: > > > Hi, i'm trying to make a copy of an image inside my "uploads" folder. I > > ´m using

[web2py] Re: Renaming a column in the database web2py?

2010-11-11 Thread mdipierro
In web2py you cannot rename a column. Why do you want to do it? On Nov 11, 9:04 am, mmartinez wrote: > Good afternoon, everyone. > > Well I need to do is to rename the name of a column > web2py the sql, sql language-I would do as follows when: > select animals as "Annex" from WHERE accountcode >

[web2py] Re: DAL() unusable ?

2010-11-11 Thread David Marko
Yes its the point. When you simply switch the definition order to person table first, web2py will raise the same error with company table doesnt exist yet. David On 11 lis, 17:05, DenesL wrote: > Some of you have missed Mirek's point, and he has a very valid one. > The problem is circular refere

[web2py] Re: DAL() unusable ?

2010-11-11 Thread DenesL
Some of you have missed Mirek's point, and he has a very valid one. The problem is circular references. There are ways around it but no elegant solution yet. There was discussion some time ago about lazy evaluation of tables. I also would like to see this solved in web2py. Denes. On Nov 11, 1

Re: [web2py] Re: Pagination [Web2py Utils] returns None

2010-11-11 Thread Thadeus Burgess
There are two alternatives. Have the generate_links function assume args when creating the url. This could be based on the existing args in request. URL(r=self.r, args=self.r.args) Or patch get_set to allow passing args as part of the function declaration, it would in turn pass these args to the

[web2py] Importing SQL script.

2010-11-11 Thread Crim
So im working on a webapp that will access a database.. which isnt overly hard but i want to import some SQL script for my database... can this be done? Could some one point me in the right direction or possibly give me a line of code to help? -I should mention im fairly new to web2py and thanks f

Re: [web2py] Re: DAL() unusable ?

2010-11-11 Thread Thadeus Burgess
Your error seems to be coming from the fact you do not have defined a person model. Since web2py is a functional designed you must define person table before you can reference it. I use the following self-referential table and have never had a problem. db.define_table('participant', #... lots of

[web2py] Re: DAL() unusable ?

2010-11-11 Thread Mirek Zvolský
>> Here's a link to the section in the book: >> http://www.web2py.com/book/default/chapter/06#Self-Reference-and-Aliases Yes, I know this, and from that reason I always use 'reference..' style syntax. However this is about very special foreign keys, which targets to same table (to the primary key

[web2py] Re: Can I use redirect to pass hash variable?

2010-11-11 Thread Tom Chang
great!!! Let me try that. Thanks a lot for your help!! Cheers, Tom On Nov 11, 8:58 am, selecta wrote: > you can pass it as var with a json dict then convert it back to a > python dict > from gluon.contrib import simplejson > a = {'a': 'foo', 'b': 'bar'} > redirect(URL(r=request, > f='scmView.htm

[web2py] Re: DAL() unusable ?

2010-11-11 Thread Mirek Zvolský
Oh no!,no!,no! please no! I still hope it's my mistake only. I simple cannot believe, that this is behaviour of web2py data model. Are we in year 1960? Friends, take a look to the oldest database implementations older as SQL language, in MS-DOS times, f.e. dBase III, FoxBase, Clipper. And earlier o

[web2py] Re: Help with "No such file or directory" error

2010-11-11 Thread CesarBustios
I'm using the whole path, i'm trying everything but i can't copy the file. Any thoughts? On 10 nov, 20:18, CesarBustios wrote: > Hi, i'm trying to make a copy of an image inside my "uploads" folder. I > ´m using the shutil module: > > import shutil > shutil.copy(path, destination) > > But i get "

[web2py] Renaming a column in the database web2py?

2010-11-11 Thread mmartinez
Good afternoon, everyone. Well I need to do is to rename the name of a column web2py the sql, sql language-I would do as follows when: select animals as "Annex" from WHERE accountcode accountcode.id_clientes = session.cliente_id; and web2py do so: rows = db (db.accountcode.id_clientes == session

[web2py] web2py organization - important for consultants !!!

2010-11-11 Thread mdipierro
This is important. Please read! These days I am getting a lot of private requests from people/ businesses who need consulting development jobs in web2py. This is more than can I can handle. I need to keep track who is available and who is capable so that I can refer those jobs to them. Long ago w

[web2py] Re: readable=False not working with crud.select(db.table)

2010-11-11 Thread andrej burja
i'm using WebGrid for Web2py making a filed not readable (and writable) doesn't show them in edit or view but in grid, the fields are shown i know i can hide them by defining fields is this problem connected to that bug? On 22 okt., 15:07, Richard Vézina wrote: > ;-) > > Thank you! > > Richard

[web2py] Re: linked tables and dropdown display

2010-11-11 Thread andrej burja
tank you that solves my problem andrej On 10 nov., 21:00, mdipierro wrote: > db.define.table('advanced' >                 Field('name1',requires=IS_IN_DB(db,'basic.name1')), > > On Nov 10, 1:49 pm, andrej burja wrote: > > > hi > > > is it possible to create a text field in table 'advandced' con

Re: [web2py] Help in web2py shell

2010-11-11 Thread Soumya Mandi
Hi Bruno Lot of thanks and respect :). It worked :) Greetings from Soumya On Thu, Nov 11, 2010 at 7:36 PM, Bruno Rocha wrote: > ahhm sorry, > > If you already defined the model, > > you need to start web2py with -M in shell > > #python web2py.py -S appname -M > > -M execute the model > > 2010/1

[web2py] Re: Command-line support

2010-11-11 Thread mdipierro
Yes. I am interested! One thing I use a lot is scripts/cpplugin.py and that too shuld have an exmposed api. web2py.py takes some time to starup. Perhaps we should use another script like web2py_manage.py On Nov 11, 6:05 am, blackthorne wrote: > Thank you once more, > > My goal with this topic wa

Re: [web2py] Help in web2py shell

2010-11-11 Thread Bruno Rocha
ahhm sorry, If you already defined the model, you need to start web2py with -M in shell #python web2py.py -S appname -M -M execute the model 2010/11/11 noPE > I have create a database 'new' for one of my applicaiton. And also > added some tables and records to it via the administrative inter

Re: [web2py] Help in web2py shell

2010-11-11 Thread Bruno Rocha
For each table you have in MySQL db, you need to define the model (usually in db.py) db.define('table',Field('field1'),Field('field2'),migrate=False) note "migrate=False" because you already have db created outside web2py. If you want to extract the model from the existing db, you can use http:/

  1   2   >