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_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.
