Re: [web2py] Re: web2py -> py4web

2024-07-16 Thread Carlos Correia
://groups.google.com/d/msgid/web2py/864dbbf4-e98e-4efe-a225-e28546e071afn%40googlegroups.com?utm_medium=email&utm_source=footer>. -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal) e-mail:ge...@memoriapersistente.pt URL:http://

Re: [web2py] How to perform a DB migration from outside the app where DB is defined?

2023-11-28 Thread Carlos Correia
n the case theres is also data changes associated. Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal) e-mail:ge...@memoriapersistente.pt URL:http://www.memoriapersistente.pt -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

Re: [web2py] Response flash message after email sent not working

2022-03-07 Thread Carlos Correia
messages.email_sent = flash.get(request.args(0), auth.messages.email_sent) use: response.flash = 'Reset password email sent' http://web2py.com/books/default/chapter/29/07/forms-and-validators#Forms-and-redirection -- Com os melhores cumprimentos, Carlos Correia ===

Re: [web2py] DAL how to increment column value

2021-05-25 Thread Carlos Correia
he record first in other to get the value to be incremented. But, if there are many users it might lead to corrupted values due to concurrency. As far as I know, the latest is the only sane approach to solve your problem. Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917

Re: [web2py] Changes to sqlhtml.py are not detected on linux server.

2021-05-25 Thread Carlos Correia
catch those modifications. Any idea what may be going on? Sorry for the bad translation. Thanks. Hi, Have you deleted sqlhtml.pyc before restarting the server? Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal, WhatsApp) e-mail: ge...@memoriapersistente.p

Re: [web2py] How to pass variables to db.executesql?

2020-11-20 Thread Carlos Correia
ble where id = %(id)s', placeholders=dict( id=someWeb2PyVariable ) ) Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal, WhatsApp) e-mail: ge...@memoriapersistente.pt URL: http://www.memoriapersistente.pt XMPP (Jabber): car...@memoriapersistente.

Re: [web2py] Login via an link/URL

2020-11-18 Thread Carlos Correia
sh, then use Auth.login_user() to authenticate the user. Having said that, please note that it is a (very) bad idea, since a "man in the middle" could easily intercept the mail and hack the session. Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146

Re: [web2py] Re: Object type None error

2020-10-15 Thread Carlos Correia
    response.flash = 'please fill the form'     # Note: no form instance is passed to the view     ## record passed to set the id value in view.     rows = db(db.cont_overheads.id == record).select() rowsconlab = db.executesql("exec usr_getconla

Re: [web2py] Problem starting a distributed transaction

2020-07-04 Thread Carlos Correia
Às 14:40 de 03/07/20, Carlos Correia escreveu: Hi, I have this piece of code in a controller to test a distributed transaction but it fails with: "ValueError: need more than 0 values to unpack". def index(): response.flash = T("Hello World") db0 = DAL('

Re: [web2py] Re: two Database syncrho

2020-07-04 Thread Carlos Correia
Às 13:28 de 04/07/20, Carlos Correia escreveu: Às 06:14 de 01/07/20, Massimo Di Pierro escreveu: Yes. Only on PostgreSQL, MySQL and Firebird. Assuming the feature has not been broken over time, I do not know of anybody who used it. On Thursday, 11 June 2020 12:51:48 UTC-7, Ari Lion BR Sp

Re: [web2py] Re: two Database syncrho

2020-07-04 Thread Carlos Correia
;http://trane:8000/admin/default/edit/welcome/controllers/default.py>, line 12, in index DAL.distributed_transaction_begin( db0, db1 ) File ".../web2py/gluon/packages/dal/pydal/base.py", line 341, in distributed_transaction_begin keys = ['%s.%i' % (thread_key, i) for (i, db)

[web2py] Problem starting a distributed transaction

2020-07-03 Thread Carlos Correia
on_begin( db0, db1 ) File ".../web2py/gluon/packages/dal/pydal/base.py", line 341, in distributed_transaction_begin keys = ['%s.%i' % (thread_key, i) for (i, db) in instances] What I am doing wrong? Thanks, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Sign

Re: [web2py] Re: Why would new code be ignored and old code be executed?

2020-03-06 Thread Carlos Correia
wrote: To track module changes try this from gluon.custom_import import track_changes; track_changes(True) Also, your problem looks like you have more then one web2py server running Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 e-mail: ge

Re: [web2py] Re: Many records in one transaction

2020-03-02 Thread Carlos Correia
2py one. Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 e-mail: ge...@memoriapersistente.pt URL: http://www.memoriapersistente.pt XMPP (Jabber): car...@memoriapersistente.pt GnuPG: wwwkeys.eu.pgp.net -- Resources: - http://web2py.com - http://web2py.com/b

Re: [web2py] blob fields with PostGres

2020-01-15 Thread Carlos Correia
Às 05:45 de 15/01/20, Dave S escreveu: On Sunday, January 12, 2020 at 9:36:14 AM UTC-8, Carlos Correia wrote: Às 22:51 de 10/01/20, Dave S escreveu: > For web2py/pydal when the backend is PostGres, are blob fields translated to > bytea or to large object? > &

Re: [web2py] blob fields with PostGres

2020-01-12 Thread Carlos Correia
)? Psycopg2 (not Web2py) maps blobs to bytea, but has the 1GB limit. This thread explains how to deal with that (using lo_import and lo_export): https://postgresrocks.enterprisedb.com/t5/EDB-Postgres/problems-with-writing-reading-a-data-bytea/td-p/2095 , Regards, Carlos Correia

Re: [web2py] Re: Cookies and redirect

2018-08-22 Thread Carlos Correia
Às 03:28 de 22-08-2018, Anthony escreveu: > On Tuesday, August 21, 2018 at 12:37:16 PM UTC-4, Carlos Correia wrote: > > Hi, > > > Is it possible to set a cookie and redirect to another page in the same > controller? > > If yes, how? I tried this simpl

Re: [web2py] custom form web2py not work when i use selectpicker

2018-08-21 Thread Carlos Correia
Às 20:41 de 21-08-2018, Rodrigo Gomes escreveu: > thanks, but the problem is not adding the selectpicker in the selects, the > problem is that by adding it to any select it does not recognize the input > data > > terça-feira, 21 de Agosto de 2018 às 14:17:48 UTC-3, Carlos C

Re: [web2py] custom form web2py not work when i use selectpicker

2018-08-21 Thread Carlos Correia
blic_place ':' ',' '' '' '' '' '' > '' '' '' '' 'cities': None, 'address_type': None, 'person': 4}> > -- > Resources: > - http://web2p

[web2py] Cookies and redirect

2018-08-21 Thread Carlos Correia
me ] = cookie_value response.cookies[ cookie_name ][ 'expires' ] = 24 * 3600 response.cookies[ cookie_name ][ 'path' ] = '/' response.cookies[ cookie_name ][ 'secure' ] = True redirect( URL( c='test', f='cookie_result' ) ) Thanks, C

Re: [web2py] New table fields don't show

2018-05-16 Thread Carlos Correia
Now: > > db.define_table('mercado', >     Field('cod_m',   type='integer'), >     Field('nome',    type='string'), >     Field('regiao',  type='integer'), >     Field('tipo',    type='integer&

Re: [web2py] Web2py Postgresql Groupby issue

2017-05-12 Thread Carlos Correia
p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email > to web2py+unsubscr...@googlegrou

[web2py] Re: How to use Let's Encrypt with Web2Py on Apache

2017-01-31 Thread Carlos Correia
How did you do it? I'm facing the same problem... Thanks -- 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 subsc

Re: [web2py] Re: How active and 'professional' is web2py?

2016-07-22 Thread Carlos Correia
t in other apps (support system, surveys) without any problems. These ones I expect to publish as soon as possible (probably, during the holiday s). So I would say you should (at least) give it a good try ;-) Also, the mailing list is very helpful to any question you may have. Regards, Carlos Correi

Re: [web2py] Re: Progress bars and session

2016-02-17 Thread Carlos Correia
te a field in some db table and use it instead of session. Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841 (NOVO) GSM: 917 157 146 e-mail: ge...@memoriapersistente.pt URL: http://www.memoriapersistente.pt XMPP (Jabber): car...@memoriapersistente.pt (NOVO) GnuPG: wwwk

Re: [web2py] IMPORTANT - WEB2PY CONSULTING

2016-02-10 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Please add me. URL: http://memoriapersistente.pt Country: Portugal The page is a bit outdated and shall be updated soon... Thanks, Carlos Correia On 15-02-2015 22:21, Massimo Di Pierro wrote: > We need to update the list of companies t

Re: [web2py] how to get old version

2016-01-05 Thread Carlos Correia
/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit

Re: [web2py] Re: Bug on checkboxes

2015-12-14 Thread Carlos Correia
ter's name should be 'value', not '_value' and '_checked' is not needed: INPUT(_type="checkbox",_name=field.name,_class="checkbox",value="on") Cheers, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841

Re: [web2py] PyCharm license for web2py dev - who wants?

2015-10-15 Thread Carlos Correia
e@googlegroups .com>. > For more options, visit https://groups.google.com/d/optout. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841 (NOVO) GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memo

[web2py] One app to authenticate them all?

2014-12-05 Thread Carlos Correia
access to (a + c). She chooses 'app_c' and is redirected to app without the need to login (again) in the app. Is there any way to avoid the (second) login in the targeted app? I know I could use a different database for Auth(), but don't know if it's even possible to avoid the la

Re: [web2py] Re: Support for MS Access?

2014-10-22 Thread Carlos Correia
* (though I would suggest PostgreSQL). Here is how to do it for PG: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriaper

Re: [web2py] Re: Version 2.9.6 indeed breaks backward compat for some users

2014-09-23 Thread Carlos Correia
_sensitive_like=True ) with the default value being set to False? - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jab

Re: [web2py] Re: Help in server config

2014-08-31 Thread Carlos Correia
controllers. All the other apps are working fine. > - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.or

[web2py] Re: Help in server config

2014-08-31 Thread Carlos Correia
:25:08 UTC+1, Carlos Correia escreveu: > > Hi, > > After migrating a web2py tree with several apps from one server to the > other, I found that in the new server I had to put a symbolic link in > admin/static to itself with the release name prefixed by an underscore in > o

[web2py] Help in server config

2014-08-30 Thread Carlos Correia
Hi, After migrating a web2py tree with several apps from one server to the other, I found that in the new server I had to put a symbolic link in admin/static to itself with the release name prefixed by an underscore in order to get a "normal" (css/js) admin interface, i.e., in applications/adm

Re: [web2py] Re: IS_IN_SET options list separator

2014-06-25 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 24-06-2014 18:48, Massimo Di Pierro escreveu: > There is no syntax to do this. > Thanks for the answer. I'll try to fix it through javascript, ten. > On Monday, 23 June 2014 12:49:21 UTC-5, Carlos Correia wrote: > > Hi, &g

[web2py] IS_IN_SET options list separator

2014-06-23 Thread Carlos Correia
es something like this? First _ Second Third Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt J

Re: [web2py] orderby / case

2014-06-14 Thread Carlos Correia
case approach or a left join, as described in here: http://stackoverflow.com/questions/6332043/sql-order-by-multiple-values-in-specific-order - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: g

Re: [web2py] Database help

2014-05-27 Thread Carlos Correia
> To unsubscribe from this group and stop receiving emails from it, send an > email > to web2py+unsubscr...@googlegroups.com > <mailto:web2py+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout. - -- Com os melhores cumprimentos, C

Re: [web2py] Re: Hide actions in navbar

2014-05-06 Thread Carlos Correia
gt; > | > navbar_dict =auth.navbar(mode='bare') > | > > which gives you a dictionary from which you can build your own navbar. > > Anthony > Thank you, Anthony, Both solve my problem, at least, by now. Meanwhile, I'll try to submit a patch from trunk on

[web2py] Re: Hide actions in navbar

2014-05-05 Thread Carlos Correia
Hi, It seems no one is interested on this subject... Is there any kind of workaround that survives upgrades? Best regards, Carlos Quinta-feira, 16 de Maio de 2013 8:17:28 UTC+1, Carlos Correia escreveu: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, >

Re: [web2py][Javascript] Massimo here searching for some javascript devs ready to port web2py in JS

2014-04-02 Thread Carlos Correia
ogle Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email > to web2py+unsubscr...@googlegroups.com > <mailto:web2py+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/o

Re: [web2py] Which Postgresql version?

2014-02-27 Thread Carlos Correia
on admin tools for linux for postgresql? Nothing special... psql is enough for must purposes. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersiste

Re: [web2py] New to Web2Py: Large Model

2014-02-14 Thread Carlos Correia
an follow this approach: http://www.web2pyslices.com/slice/show/1479/model-less-apps-using-data-models-and-modules-in-web2py Basicly, you move table defenitions from models to modules, only defining tables as needed. - -- Com os melhores cumprimentos, Carlos Correia =

Re: [web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Carlos Correia
for web app > which should muliple users at once? > > > Sincerely, > Gour > - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL:

Re: [web2py] diffrence between web2py and django framework...

2013-08-17 Thread Carlos Correia
web2py for a beginner developer"). Have fun, - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@

Re: [web2py] reference db.auth_user from other Database..

2013-08-14 Thread Carlos Correia
ible to cross reference the databases? If so, how? > Since you're using Postgresql, you can try dblink (http://www.postgresql.org/docs/8.3/static/dblink.html), as suggested here: http://stackoverflow.com/questions/46324/possible-to-perform-cross-database-queries-with-postgres - -- Com os

Re: [web2py] Help needed in obscure bug (only on server)

2013-08-08 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 21:56, Michele Comitini escreveu: > Is BizDoc pickable? > Yes. Otherwise Web2py would raise an exception (I think). > > 2013/8/8 Carlos Correia <mailto:car...@memoriapersistente.pt>> > > Em 08-08-2

Re: [web2py] Help needed in obscure bug (only on server)

2013-08-08 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 22:05, Ricardo Pedroso escreveu: > > On Thu, Aug 8, 2013 at 9:22 PM, Carlos Correia <mailto:car...@memoriapersistente.pt>> wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > >

Re: [web2py] Help needed in obscure bug (only on server)

2013-08-08 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 20:23, Ricardo Pedroso escreveu: > On Thu, Aug 8, 2013 at 2:36 PM, Carlos Correia <mailto:car...@memoriapersistente.pt>> wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, >

Re: [web2py] Help needed in obscure bug (only on server)

2013-08-08 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Clarifying the question: what kind of bug in my code may be causing the session to expire? Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511

[web2py] Help needed in obscure bug (only on server)

2013-08-08 Thread Carlos Correia
The BIG (and difficult) question is: where should I look to track a bug like this, without reverting all changes and applying them one by one? Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÃ?RIA PERSISTENTE Tel.: 219 291 591 - GSM: 917

[web2py] Hide actions in navbar

2013-05-16 Thread Carlos Correia
I've added an extra parameter to Auth.navbar() that accepts an array of actions to hide. I attach the patch from [Version 2.3.2 (2012-12-17 08:59:58) stable] with the changes. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591

Re: [web2py] apache backdoor?

2013-04-29 Thread Carlos Correia
replace httpd bin why wouldn't "they" do the same with any other binary in the system? Seems to be a c-panel issue, not apache's. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762

Re: [web2py] postgres getting started ("hello world")

2013-03-08 Thread Carlos Correia
> > > invalid function (default/TestPostgres) > > no ticket or anything > > I also tried changing the md5 |in pg_hba.conf > | > > |# "local" is for Unix domain socket connections only > #local all all

Re: [web2py] DAL Keys

2012-09-23 Thread Carlos Correia
lters':['first_name','Country','Age'], > } > else: > > badmin_tables[table]={ > 'columns':db[table].fields[:3], > 'filters':[], > } > >

Re: [web2py] Re: Possible regression in DAL?

2012-09-03 Thread Carlos Correia
12 16:02:49 UTC-5, Carlos Correia wrote: > > Hi, > > It fixed the issue, indeed. > > So I assume I'll have to review all the executesql's calls in order to add the > fetch parameter to the ones that need it, which, in this case won't be a > simple > ta

Re: [web2py] Re: Possible regression in DAL?

2012-09-03 Thread Carlos Correia
.. except in there that would have caused more problems. > > Check out latest trunk and try: > >db.executesql('truncate auth_event',fetch=False) > > else it expect the query to return something. > > On Monday, 3 September 2012 14:01:57 UTC-5, Carlos Correia wr

[web2py] Possible regression in DAL?

2012-09-03 Thread Carlos Correia
cursor.fetchall() 7250 if fields or colnames: 7251 fields = [] if fields is None else fields ProgrammingError: no results to fetch Before the upgrade, I was using Version 2.00.0 (2012-08-03 09:01:00) dev Thanks, - -- Com os melhores cumprimentos, Carlos Corre

Re: [web2py] Complex query in DAL?

2012-08-20 Thread Carlos Correia
t the LEFT JOINs > and > COUNTs working? > > -- > > > Usually I use something like this to address that problem: from gluon.storage import Storage rows = db.executesql(..., as_dict=True) list = [] for r in rows: list.append( Storage( r ) return list - -- Com os melhores cu

Re: [web2py] Re: data source configuration

2012-04-02 Thread Carlos Correia
t could be added in the > future? I > think that I read somewhere that web2py developers don't think this is > necessary but I really don't understand why. > > Is there a workaround for me? I have some ideas but nothing seems to > be > opti