Re: [web2py] Re: Custom Auth module

Great! The second part about defining (not recommend) is what I need However, I will be interfacing with external applications and predefined tables, so that should work out just fine. I can add the rest of the "Auth" tables to my external definitions (Postgres) *Ben Duncan* D

[web2py] Custom Auth module

I need to have a custom authentication module - mainly pointing to and using my own auth_user and auth_group tables Which modules from the base (welcome) do I need to change or what documentation do i need to read up on on how to do this ... Thanks *Ben Duncan* DBA / Chief Software Architect

Re: [web2py] Issues using pydal

Ok, thanks ... JUST figured that out Is there any OTHER classes I need to include or just those 2 ? Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Nov 5, 2018 at 11:52 AM Roberto Perdomo wrote: > You for

[web2py] Issues using pydal

e=False) sys.exit(0); Any ideas on what is going on? thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com - ht

Re: [web2py] Re: off topic: pg_dump syntax for pythonanywhere

/pgdump.sql ${PGDATABASENAME} There are myriad ways to do pg_dump - local host, server to server ...etc.. IF you can tell me exactly what you are trying to do, I can help ... Ben Duncan DBA / Chief Software Architect Ms State Supreme Court On Sun, Nov 4, 2018 at 7:25 PM Alex Glaros wrote

[web2py] Which is correct in DAL?

this: db.define_table('gl_chart', Field('company_number', type='reference company', ondelete='CASCADE'), Field('gl_account_num', type='string', length=20), Which is correct just the 'reference xyz' or the type='reference xyz' ? Thanks ... Ben Duncan -- Resources: - http

Re: [web2py] Re: DAL and DB VIEWS

Ok, found the answer ... https://groups.google.com/forum/#!topic/web2py/DCsnCkQnIoA On Mon, Oct 29, 2018 at 12:27 PM Ben Duncan wrote: > I'm thinking it should be no different than defining a table, since these > are all external / predefined tables. > The difference is that Postgre

Re: [web2py] Re: DAL and DB VIEWS

I'm thinking it should be no different than defining a table, since these are all external / predefined tables. The difference is that Postgres handles the sql and I'm guessing with DAL, it's just data returned. Ben Duncan On Mon, Oct 29, 2018 at 12:14 PM 黄祥 wrote: > had you try DAL's exec

[web2py] DAL and DB VIEWS

Is it possible to use predefined Postgres views inside of DAL? By views i mean (SQL code) CREATE VIEW myview AS select .. from tablea, tableb WHERE .. ); Thanks Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

Re: [web2py] Help needed with web2py-book app

Also found this: http://python-future.org/compatible_idioms.html On Thu, Oct 11, 2018 at 10:30 AM Ben Duncan wrote: > Try These suggestions: > > > https://stackoverflow.com/questions/491921/unicode-utf-8-reading-and-writing-to-files-in-python/83 > http://www.evanjones.ca/p

Re: [web2py] Help needed with web2py-book app

hile on PY3 it is mandatory. > > I'm still learning, too ;-) > Nico > > > Il giorno gio 11 ott 2018 alle ore 16:16 Ben Duncan > ha scritto: > >> Exactly what are you running into? >> >> I ran into this with my rewrite of of extract extract_pgsql_models.py:

Re: [web2py] Help needed with web2py-book app

e. The changes work across Python 2.7 and 3.6 seamlessly now ... FWIW, I'm just making the transition to Python 3,6 so I'm learning things the hard way ... Ben Duncan On Wed, Oct 10, 2018 at 4:02 PM Nico Zanferrari wrote: > Hello, > > I'm playing with the web2py-book app, in order to

[web2py] GITHUB and my updates

project. In the coming days/weeks/months i will be uploading a TOTAL ERP Postgres Template layout for tables that meets or exceeds GAPP requirements. I's based upon the 40+ years of commercial and open source systems that i've worked on. That is if anyone is interested. Thanks Ben Duncan

[web2py] Foreign Keyes and DAL .. again.

as they occur . IS this a correct line of reasoning ? Thanks Ben Duncan -- 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 messag

Re: [web2py] Re: DAL with multiple foreign keyes

Ok, thanks .. will think of another way to do this .. On Mon, Sep 24, 2018 at 4:58 PM Leonel Câmara wrote: > Nope the DAL and web2py does not support this. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > -

Re: [web2py] Re: DAL with multiple foreign keyes

It's more about optimization of underlying key structure and the btree access. Having the Primary key "company + customer" are faster because the optimizer can have a start point. I could do secondary key with COMPANY , but then the optimizer has to go thru a different set of routines. In this

[web2py] DAL with multiple foreign keyes

on only fk. Is this true? Is there some way to work around this if it is true? Thanks Ben Duncan -- 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) ---

[web2py] DAL and Foreign Keyes

will DAL allow multiple foreign keys on a legacy database table? i.e. : Table called item_purchased needs to have a FK to customer table as well as item table and even possibly GL COA table Thanks ... Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Submitting fixes

I've found some errors in extract_pgsql_models.py and have fixed them. How to do I go about submitting the updated program for inclusion repos (asking for etiquette sake )? I'm not quite thru with the update yet, since I need to fix it to handle FK's with multiple key parts. Thanks Ben Duncan

[web2py] Using DAL / existing Databases

this be automated as well? Thanks In advance - Ben Duncan Sample - Accounts Receivable Open Item File: # Generator Parameters: # : = End Type of field , '|' = Field seperators # # FILE = Table Name to generate # ENDFILE - End of Table Defination # DESC - Descriptive Information for Documentor

Re: [web2py] Re: Changing Login Defaults

t; On Wednesday, August 8, 2018 at 11:30:26 AM UTC-4, Ben Duncan wrote: >> >> I've been doing some playing around with the sample applications. >> >> I've notices they all use tables "auth_user", "auth_group", etc. >> >> We have our own authentic

[web2py] Changing Login Defaults

r own authentication methods. Is it possible to modify and where/how would we do this to change the "login" methods? Thanks Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web

Re: [web2py] Re: web2py 2.17.1

Installed it and it's up whilst I learn it ... On Tue, Aug 7, 2018 at 9:29 AM 黄祥 wrote: > configuration.take() no longer worked > *e.g.* > *private/appconfig.ini* > [app] > toolbar = false > > *models/db.py* > response.show_toolbar = configuration.take('app.toolbar') # not worked > while in

Re: [web2py] Re: Issues getting web2py to work.

gt; On Tuesday, July 24, 2018 at 4:03:13 PM UTC-4, Ben Duncan wrote: >> >> Redhack 6.9 >> Python 2.6.6 >> >> Installed web2py source. >> Ran the command: >> >python web2py.py >> got the message: >> >> Traceback (most recent call last): &g

[web2py] Issues getting web2py to work.

kages/dal/pydal/objects.py", line 385 return [{key: noncallable(getattr(field, key)) for key in keys} Any Ideas ? Thanks Ben Duncan ^ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/we

<    1   2