No , all you need is the db.define for the table you are going to access,
unless there is foreign keyes involved.
Then include the PARENT table if these are child tables.
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Mon, Feb 11, 2019 at 9:27 AM Jon Subscripted <jonsubscripti...@gmail.com>
wrote:
> Thanks Ben,
> Should I include just the define_table for that very table (there are
> more, but will not be accessed)?
> Regards, Jon.
>
> On Mon, Feb 11, 2019 at 4:26 PM Ben Duncan <linux...@gmail.com> wrote:
>
>> If this script is being run OUTSIDE the web2py environment then you will
>> need to include the define inside the python program itself.
>>
>> *Ben Duncan*
>> DBA / Chief Software Architect
>> Mississippi State Supreme Court
>> Electronic Filing Division
>>
>>
>> On Mon, Feb 11, 2019 at 9:01 AM Jon Subscripted <
>> jonsubscripti...@gmail.com> wrote:
>>
>>> Thanks Ben,
>>> Honestly I do not know if I understood what you suggest, sorry... it's
>>> actually my fault as I'm still trying to learn web2py (reading the manual,
>>> etc.).
>>>
>>> My web2py-app is actually working, but I still have lost of data to load
>>> in the DB. Most of the data to populate de DB is created outside the app
>>> itself (this may change in the future, but unfortunatelly it is like that
>>> now).
>>>
>>> As this data creation is done outside my web2py-app I wanted the scripts
>>> creating this data to check which data has already been uploaded to the
>>> web2py-app database. In order to do so I wrote a python script which is
>>> meant to be run apart from the web2py-app to check if the data is already
>>> in the DB (calling the snippet below), if it's not create it and then load
>>> it.
>>>
>>> problemsuri = 'mysql://root:web2py@localhost/xakemate'
>>> dbpath =
>>> r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
>>>
>>> def checkproblem(posFEN):
>>> print "checking",posFEN
>>> dbproblems = DAL(problemsuri,folder=dbpath,auto_import=True)
>>>
>>> query = (dbproblems.problem.fen == posFEN)
>>> problem = dbproblems(query).select(orderby=dbproblems.problem.id
>>> ).first()
>>> print "DUPLICATED problem",problem
>>> return problem
>>>
>>> But when I do run the code I get an error telling me "AttributeError:
>>> 'DAL' object has no attribute 'problem'".
>>>
>>> Do I need to define the table I'm trying to access again ('cause it's
>>> already defined in models folder, but not in this script)?
>>> If I do need to define the table again, How should I do it?
>>> Regards, Jon.
>>>
>>>
>>>
>>> On Mon, Feb 11, 2019 at 3:43 PM Ben Duncan <linux...@gmail.com> wrote:
>>>
>>>> Oh yeah. One thing I missed explaining is that I spend the end of last
>>>> year creating a python library that would take file layouts I've gleaned
>>>> from a 4GL, old cobol systems and an Informix database, and some Oracle
>>>> Financials.
>>>>
>>>> I've create a "layout template" that the library will generate the
>>>> create table, primary keyes, secondary keyes, foreign keyes, grants and
>>>> views.
>>>> As part of the library it will generate the pydal "define" statements
>>>> as well.
>>>>
>>>>
>>>> *Ben Duncan*
>>>> DBA / Chief Software Architect
>>>> Mississippi State Supreme Court
>>>> Electronic Filing Division
>>>>
>>>>
>>>> On Mon, Feb 11, 2019 at 8:36 AM Ben Duncan <linux...@gmail.com> wrote:
>>>>
>>>>> I'm not sure what your statement means, however i will give it my best
>>>>> shot to explain> I'm new to web2py myself.
>>>>> Her goes:
>>>>>
>>>>> In my models folder i have several different sub folders:
>>>>> ar, ap ,gl ...etc...
>>>>>
>>>>> Each has the definition. For example under ar there is the
>>>>> dbf_arfiles_dal.py which starts likes this:
>>>>>
>>>>> db.define_table('ar_cusmas_billing_info',
>>>>> Field('company_number', type='reference client.company_number',
>>>>> ondelete='CASCADE'),
>>>>> Field('client_number', type='reference client.client_number',
>>>>> ondelete='CASCADE'),
>>>>> Field('bank_name', type='string', length=30),
>>>>> Field('bank_route', type='integer'),
>>>>> Field('bank_acct', type='integer'),
>>>>> Field('cc', type='string', length=2),
>>>>> Field('ccno', type='integer'),
>>>>> Field('exp1', type='date'),
>>>>> Field('holder1', type='string', length=50),
>>>>> Field('cc2', type='string', length=2),
>>>>> Field('ccno2', type='integer'),
>>>>> Field('exp2', type='date'),
>>>>> Field('holder2', type='string', length=50),
>>>>> primarykey=['company_number','client_number'],
>>>>> migrate=False)
>>>>>
>>>>> db.define_table('ar_cusmas_pclass',
>>>>> Field('company_number', type='reference client.company_number',
>>>>> ondelete='CASCADE'),
>>>>> ......... and so one.
>>>>>
>>>>> In 0.py , I start it off as:
>>>>>
>>>>> --------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>
>>>>> # -*- coding: utf-8 -*-
>>>>>
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> # AppConfig configuration made easy. Look inside private/appconfig.ini
>>>>> # Auth is for authenticaiton and access control
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> import datetime
>>>>> from gluon.contrib.appconfig import AppConfig
>>>>> from gluon.settings import global_settings
>>>>> from gluon import current
>>>>> from gluon.tools import Crud, Service
>>>>> # from gluon.tools import Auth
>>>>>
>>>>> from gluon.storage import *
>>>>> from pydal.contrib import portalocker
>>>>> from pydal._compat import basestring, StringIO, integer_types, xrange,
>>>>> BytesIO, to_bytes, long
>>>>> from gluon.storage import Messages, Settings, Storage
>>>>> from gluon.utils import web2py_uuid
>>>>>
>>>>> from gluon.validators import CLEANUP, CRYPT, IS_ALPHANUMERIC,
>>>>> IS_DATE_IN_RANGE, IS_DATE, \
>>>>> IS_DATETIME_IN_RANGE, IS_DATETIME, IS_DECIMAL_IN_RANGE, \
>>>>> IS_EMAIL, IS_EMPTY_OR, IS_EXPR, IS_FLOAT_IN_RANGE, IS_IMAGE, \
>>>>> IS_IN_DB, IS_IN_SET, IS_INT_IN_RANGE, IS_IPV4, IS_LENGTH, \
>>>>> IS_LIST_OF, IS_LOWER, IS_MATCH, IS_EQUAL_TO, IS_NOT_EMPTY, \
>>>>> IS_NOT_IN_DB, IS_NULL_OR, IS_SLUG, IS_STRONG, IS_TIME, \
>>>>> IS_UPLOAD_FILENAME, IS_UPPER, IS_URL
>>>>>
>>>>> # from gluon.validators import CRYPT, IS_EMAIL, IS_EQUAL_TO,
>>>>> IS_INT_IN_RANGE, IS_LOWER, IS_MATCH, IS_NOT_EMPTY, \
>>>>> # IS_NOT_IN_DB
>>>>> from pydal.objects import Table, Field, Row
>>>>>
>>>>> ........ (and so on till I get to the bottom)
>>>>>
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> # Local application settings
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>>
>>>>> settings = Storage()
>>>>>
>>>>> settings.migrate = False
>>>>> settings.title = request.application
>>>>> settings.subtitle = T('Ben Duncan')
>>>>> settings.author = 'Ben Duncan'
>>>>> settings.author_email = 'y...@example.com'
>>>>> settings.keywords = 'Ben Duncan'
>>>>> settings.description = 'Ben Duncan'
>>>>> settings.layout_theme = 'Default'
>>>>> settings.database_uri = 'postgres://
>>>>> web2py:web2py@10.13.70.47:7103/ac03303_live'
>>>>> settings.security_key = 'c4d5c7ec-97b4-474b-98d3-9c1582dad510'
>>>>> settings.email_server = 'localhost'
>>>>> settings.email_sender = 'y...@example.com'
>>>>> settings.email_login = ''
>>>>> settings.login_method = 'local'
>>>>> settings.login_config = ''
>>>>> settings.plugins = []
>>>>> session.is_logged_in = 'NO'
>>>>>
>>>>> --------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>
>>>>> Then in db.py I have:
>>>>>
>>>>> # -*- coding: utf-8 -*-
>>>>>
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> # Database model
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>>
>>>>> db = DAL(settings.database_uri, pool_size=10, migrate_enabled=False,
>>>>> fake_migrate_all=True )
>>>>>
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> # Here is sample code if you need for
>>>>> # - email capabilities
>>>>> # - authentication (registration, login, logout, ... )
>>>>> # - authorization (role based authorization)
>>>>> # - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
>>>>> # - old style crud actions
>>>>> # (more options discussed in gluon/tools.py)
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> # host names must be a list of allowed host names (glob syntax allowed)
>>>>> # auth = Auth(db, host_names=configuration.get('host.names'))
>>>>> # auth = Auth(db, secure=True)
>>>>> #
>>>>> -------------------------------------------------------------------------
>>>>> #auth = Auth(db,signature=False)
>>>>> crud = Crud(db)
>>>>>
>>>>> ...... (every thing else is commented out as well. this is because I
>>>>> am doing my own custome authentication and other
>>>>> things - which MAYBE the grief I'm causing myself. ..)
>>>>>
>>>>> --------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>
>>>>>
>>>>> Hopefully this should get you going
>>>>>
>>>>> If I've missed anything, Anthony can you fill in ?
>>>>>
>>>>> Good Luck ...
>>>>>
>>>>>
>>>>> *Ben Duncan*
>>>>> DBA / Chief Software Architect
>>>>> Mississippi State Supreme Court
>>>>> Electronic Filing Division
>>>>>
>>>>>
>>>>> On Sat, Feb 9, 2019 at 10:56 AM Jon Subscripted <
>>>>> jonsubscripti...@gmail.com> wrote:
>>>>>
>>>>>> Hi Ben,
>>>>>> Inside my app folder I do have the table defined, but not in my
>>>>>> script (accessing the db outside web2py).
>>>>>> I thought that the folder path reference solved this (*).
>>>>>> Should i add the define table in my script?
>>>>>> Thanks and regards, Jon.
>>>>>>
>>>>>> (*) I guess that’s why .table files are kept even when SQLite is no
>>>>>> longer usted.
>>>>>>
>>>>>> El El vie, 8 feb 2019 a las 14:28, Ben Duncan <linux...@gmail.com>
>>>>>> escribió:
>>>>>>
>>>>>>> Did you set up the db_define table for the database in models.
>>>>>>>
>>>>>>> For example, the accounting package I am working on for our Supreme
>>>>>>> Court has and external postgres database.
>>>>>>> From the DDL, I've created, for example, the "ship to code" file (we
>>>>>>> reuse for something else)
>>>>>>>
>>>>>>> ---------------------------------------------------------------------------------------------------------------------
>>>>>>> db.define_table('ar_ship_code',
>>>>>>> Field('company_number', type='reference company.company_number',
>>>>>>> ondelete='CASCADE'),
>>>>>>> Field('code', type='string', length=10),
>>>>>>> Field('short_desc', type='string', length=20),
>>>>>>> Field('description', type='string', length=255),
>>>>>>> Field('notes', type='text'),
>>>>>>> primarykey=['company_number','code'],
>>>>>>> migrate=False)
>>>>>>>
>>>>>>> ---------------------------------------------------------------------------------------------------------------------------
>>>>>>>
>>>>>>> For each table you want to access, you will need a "db.define_table"
>>>>>>> entry in the model directory.
>>>>>>>
>>>>>>> Hope this helps
>>>>>>> *Ben Duncan*
>>>>>>> DBA / Chief Software Architect
>>>>>>> Mississippi State Supreme Court
>>>>>>> Electronic Filing Division
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Feb 8, 2019 at 7:17 AM Jon Subscripted <
>>>>>>> jonsubscripti...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi everyone,
>>>>>>>> I'm trying to access the data stored in my app db from a different
>>>>>>>> piece of software (apart from my web2py app). But I get an error
>>>>>>>> AttributeError.
>>>>>>>>
>>>>>>>> Based on the manual:
>>>>>>>>
>>>>>>>>
>>>>>>>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Using-DAL-without-define-tables
>>>>>>>>
>>>>>>>> I used the code below (from IDLE):
>>>>>>>>
>>>>>>>> import sys
>>>>>>>>
>>>>>>>> sys.path.append(r'C:\Users\Jon\Downloads\web2py_src\web2py\gluon')
>>>>>>>>
>>>>>>>> from gluon import DAL
>>>>>>>>
>>>>>>>> dbpath =
>>>>>>>> r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
>>>>>>>> problemsuri = 'mysql://root:web2py@localhost/xakemate'
>>>>>>>> pos = 'test_position'
>>>>>>>>
>>>>>>>> db = DAL(problemsuri,folder=dbpath,auto_import=True)
>>>>>>>> query = (db.problem.fen == pos)
>>>>>>>> problem = db(query).select(orderby=db.problem.id).first()
>>>>>>>>
>>>>>>>> I get the following error:
>>>>>>>>
>>>>>>>> Traceback (most recent call last):
>>>>>>>> File "<pyshell#33>", line 1, in <module>
>>>>>>>> query = (dbproblems.problem.fen == posFEN)
>>>>>>>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7150, in
>>>>>>>> __getattr__
>>>>>>>> return ogetattr(self, key)
>>>>>>>> AttributeError: 'DAL' object has no attribute 'problem'
>>>>>>>>
>>>>>>>> From what I understood the tables should be auto-imported and thus
>>>>>>>> known to my code. Why is it not finding the table?
>>>>>>>>
>>>>>>>> In addition to that I've got a couple of questions:
>>>>>>>>
>>>>>>>> 1st Should I import PYDAL (from pydal import DAL) or GLUON.DAL (as
>>>>>>>> I did)?
>>>>>>>>
>>>>>>>> 2nd Even when using the db different from SQLite should we point to
>>>>>>>> "applications/myapp/databases"?
>>>>>>>>
>>>>>>>> Thanks in advance, Jon.
>>>>>>>>
>>>>>>>>
>>>>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>>>>>>> Libre
>>>>>>>> de virus. www.avast.com
>>>>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>>>>>>> <#m_3277063011711644748_m_1193084186208716646_m_538018860577941037_m_-719463918673358794_m_6847217380560436693_m_-8586355468110605202_m_-6215750885323799383_m_5787271047422858639_m_-5898545075541849496_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>>>>>>
>>>>>>>> --
>>>>>>>> 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 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 https://groups.google.com/d/optout.
>>>>>>>>
>>>>>>> --
>>>>>>> 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 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 https://groups.google.com/d/optout.
>>>>>>>
>>>>>> --
>>>>>> 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 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 https://groups.google.com/d/optout.
>>>>>>
>>>>> --
>>>> 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 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 https://groups.google.com/d/optout.
>>>>
>>> --
>>> 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 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 https://groups.google.com/d/optout.
>>>
>> --
>> 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 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 https://groups.google.com/d/optout.
>>
> --
> 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 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 https://groups.google.com/d/optout.
>
--
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 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 https://groups.google.com/d/optout.
