Re: [web2py] Accessing MySQL data without define tables
Thanks Ben,
I'll try what you suggest.
Regards, Jon.
On Tue, Feb 12, 2019 at 2:17 PM Ben Duncan wrote:
> Here is the TOP of what I use.
> You will need the migrate commands in your connections tring
>
>
> --
>
>
> import os, sys, string, copy, time
> import getopt
> from types import *
>
> from pydal import DAL, Field
>
> db = DAL("postgres://postgres:postgres@localhost:7103/ac03303_live",
> pool_size=10, migrate_enabled=False, fake_migrate_all=True )
> print db._uri
> print db._dbname
>
>
> db.define_table('company',
> Field('company_number', type='integer'),
> Field('company_name', type='string', length=255),
> Field('address_1', type='string', length=255),
> Field('address_2', type='string', length=255),
> Field('city', type='string', length=255),
> Field('state', type='string', length=20),
> Field('zip', type='string', length=10),
> .
>
>
> *Ben Duncan*
> DBA / Chief Software Architect
> Mississippi State Supreme Court
> Electronic Filing Division
>
>
> On Tue, Feb 12, 2019 at 4:26 AM Jon Subscripted <
> jonsubscripti...@gmail.com> wrote:
>
>> Hi,
>> BTW I was checking "sql.log" file just in case I had unintentionally
>> messed up redefining the fen field twice and saw that every execution of
>> the script in my previous email led to a CREATE TABLE (see below). There's
>> more than one (one per each test I performed with the script).
>>
>> Is this normal? Should the table definition in the script outside
>> web2py-app lead to a CREATE TABLE?
>>
>> I also realized that the original CREATE TABLE statement created by
>> web2py (at the very top of the "sql.log" file, right after auth tables are
>> created) does have a different length VARCHAR( `fen` VARCHAR(512),).
>>
>> Can this kind of length difference lead to MySQL to create a duplicated
>> field?
>>
>> Thanks in advance.
>> Regards, Jon.
>>
>> timestamp: 2019-02-11T16:33:57.499000
>> CREATE TABLE problem(
>> id INT AUTO_INCREMENT NOT NULL,
>> question_hint VARCHAR(255),
>> fen VARCHAR(255),
>> solutionSAN LONGTEXT,
>> solutionUCI LONGTEXT,
>> solordered CHAR(1),
>> pcomment VARCHAR(255),
>> previousFEN VARCHAR(255),
>> previousSAN VARCHAR(255),
>> previousUCI VARCHAR(255),
>> game_control VARCHAR(255),
>> ply_control INT,
>> PRIMARY KEY(id)
>> ) ENGINE=InnoDB CHARACTER SET utf8;
>>
>> On Tue, Feb 12, 2019 at 10:49 AM Jon Subscripted <
>> jonsubscripti...@gmail.com> wrote:
>>
>>> Thanks Ben,
>>> I did what you suggested and somehow I think I moved on.
>>>
>>> Still I got a weird error: InternalError: (1060, u"Duplicate column name
>>> 'fen__tmp'")
>>>
>>> import sys
>>>
>>> sys.path.append(r'C:\Users\Jon\Downloads\web2py_src\web2py\gluon')
>>>
>>> from gluon import DAL,Field
>>> from gluon import *
>>>
>>> dbpath =
>>> r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
>>> problemsuri = 'mysql://root:web2py@localhost/xakemate'
>>> posFEN = 'rnb2rk1/pp4pp/1qpbp3/3p4/4P3/3P1NP1/PPPN1RBP/R1BQ3K b - - 0 13'
>>>
>>>
>>> db = DAL(problemsuri)#,folder=dbpath)#,auto_import=True)
>>>
>>> db.define_table(
>>> "problem",
>>> Field("question_hint",type="string"),
>>>
>>> Field("fen",type="string"),#,requires=(IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'problem.fen'))),
>>> Field("solutionSAN",type="list:string",requires=IS_NOT_EMPTY()),
>>> Field("solutionUCI",type="list:string",requires=IS_NOT_EMPTY()),
>>> Field("solordered",type="boolean",default=True),
>>> Field("pcomment",type="string"),
>>> Field("previousSAN",type="string",default=''),
>>> Field("previousUCI",type="string",default=''),
>>> Field("previousFEN",type="string",default=''),
>>> Field("game_control",type="string",default=''),
>>> Field("ply_control",type="integer",default=0)
>>> )
>>>
>>> query = (db.problem.fen == posFEN)
>>> problem = db(query).select(orderby=db.problem.id).first()
>>>
>>> No handlers could be found for logger "web2py"
>>> WARNING:root:Unable to import plural rules: No module named plural_rules
>>>
>>> Traceback (most recent call last):
>>> File "C:\Python27\withoutdefine.py", line 27, in
>>> Field("ply_control",type="integer",default=0)
>>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7085, in
>>> define_table
>>> table = self.lazy_define_table(tablename,*fields,**args)
>>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7117, in
>>> lazy_define_table
>>> polymodel=polymodel)
>>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 948, in
>>> create_table
>>> fake_migrate=fake_migrate)
>>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1054, in
>>> migrate_table
>>> self.execute(sub_query)
>>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1693, in
>>> execute
>>> return self.log_execute(*a, **b)
>>> File
Re: [web2py] Accessing MySQL data without define tables
Here is the TOP of what I use.
You will need the migrate commands in your connections tring
--
import os, sys, string, copy, time
import getopt
from types import *
from pydal import DAL, Field
db = DAL("postgres://postgres:postgres@localhost:7103/ac03303_live",
pool_size=10, migrate_enabled=False, fake_migrate_all=True )
print db._uri
print db._dbname
db.define_table('company',
Field('company_number', type='integer'),
Field('company_name', type='string', length=255),
Field('address_1', type='string', length=255),
Field('address_2', type='string', length=255),
Field('city', type='string', length=255),
Field('state', type='string', length=20),
Field('zip', type='string', length=10),
.
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Tue, Feb 12, 2019 at 4:26 AM Jon Subscripted
wrote:
> Hi,
> BTW I was checking "sql.log" file just in case I had unintentionally
> messed up redefining the fen field twice and saw that every execution of
> the script in my previous email led to a CREATE TABLE (see below). There's
> more than one (one per each test I performed with the script).
>
> Is this normal? Should the table definition in the script outside
> web2py-app lead to a CREATE TABLE?
>
> I also realized that the original CREATE TABLE statement created by web2py
> (at the very top of the "sql.log" file, right after auth tables are
> created) does have a different length VARCHAR( `fen` VARCHAR(512),).
>
> Can this kind of length difference lead to MySQL to create a duplicated
> field?
>
> Thanks in advance.
> Regards, Jon.
>
> timestamp: 2019-02-11T16:33:57.499000
> CREATE TABLE problem(
> id INT AUTO_INCREMENT NOT NULL,
> question_hint VARCHAR(255),
> fen VARCHAR(255),
> solutionSAN LONGTEXT,
> solutionUCI LONGTEXT,
> solordered CHAR(1),
> pcomment VARCHAR(255),
> previousFEN VARCHAR(255),
> previousSAN VARCHAR(255),
> previousUCI VARCHAR(255),
> game_control VARCHAR(255),
> ply_control INT,
> PRIMARY KEY(id)
> ) ENGINE=InnoDB CHARACTER SET utf8;
>
> On Tue, Feb 12, 2019 at 10:49 AM Jon Subscripted <
> jonsubscripti...@gmail.com> wrote:
>
>> Thanks Ben,
>> I did what you suggested and somehow I think I moved on.
>>
>> Still I got a weird error: InternalError: (1060, u"Duplicate column name
>> 'fen__tmp'")
>>
>> import sys
>>
>> sys.path.append(r'C:\Users\Jon\Downloads\web2py_src\web2py\gluon')
>>
>> from gluon import DAL,Field
>> from gluon import *
>>
>> dbpath =
>> r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
>> problemsuri = 'mysql://root:web2py@localhost/xakemate'
>> posFEN = 'rnb2rk1/pp4pp/1qpbp3/3p4/4P3/3P1NP1/PPPN1RBP/R1BQ3K b - - 0 13'
>>
>>
>> db = DAL(problemsuri)#,folder=dbpath)#,auto_import=True)
>>
>> db.define_table(
>> "problem",
>> Field("question_hint",type="string"),
>>
>> Field("fen",type="string"),#,requires=(IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'problem.fen'))),
>> Field("solutionSAN",type="list:string",requires=IS_NOT_EMPTY()),
>> Field("solutionUCI",type="list:string",requires=IS_NOT_EMPTY()),
>> Field("solordered",type="boolean",default=True),
>> Field("pcomment",type="string"),
>> Field("previousSAN",type="string",default=''),
>> Field("previousUCI",type="string",default=''),
>> Field("previousFEN",type="string",default=''),
>> Field("game_control",type="string",default=''),
>> Field("ply_control",type="integer",default=0)
>> )
>>
>> query = (db.problem.fen == posFEN)
>> problem = db(query).select(orderby=db.problem.id).first()
>>
>> No handlers could be found for logger "web2py"
>> WARNING:root:Unable to import plural rules: No module named plural_rules
>>
>> Traceback (most recent call last):
>> File "C:\Python27\withoutdefine.py", line 27, in
>> Field("ply_control",type="integer",default=0)
>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7085, in
>> define_table
>> table = self.lazy_define_table(tablename,*fields,**args)
>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7117, in
>> lazy_define_table
>> polymodel=polymodel)
>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 948, in
>> create_table
>> fake_migrate=fake_migrate)
>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1054, in
>> migrate_table
>> self.execute(sub_query)
>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1693, in execute
>> return self.log_execute(*a, **b)
>> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1687, in
>> log_execute
>> ret = self.cursor.execute(*a, **b)
>> File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 170, in
>> execute
>> result = self._query(query)
>> File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 328,
Re: [web2py] Accessing MySQL data without define tables
Hi,
BTW I was checking "sql.log" file just in case I had unintentionally messed
up redefining the fen field twice and saw that every execution of the
script in my previous email led to a CREATE TABLE (see below). There's more
than one (one per each test I performed with the script).
Is this normal? Should the table definition in the script outside
web2py-app lead to a CREATE TABLE?
I also realized that the original CREATE TABLE statement created by web2py
(at the very top of the "sql.log" file, right after auth tables are
created) does have a different length VARCHAR( `fen` VARCHAR(512),).
Can this kind of length difference lead to MySQL to create a duplicated
field?
Thanks in advance.
Regards, Jon.
timestamp: 2019-02-11T16:33:57.499000
CREATE TABLE problem(
id INT AUTO_INCREMENT NOT NULL,
question_hint VARCHAR(255),
fen VARCHAR(255),
solutionSAN LONGTEXT,
solutionUCI LONGTEXT,
solordered CHAR(1),
pcomment VARCHAR(255),
previousFEN VARCHAR(255),
previousSAN VARCHAR(255),
previousUCI VARCHAR(255),
game_control VARCHAR(255),
ply_control INT,
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
On Tue, Feb 12, 2019 at 10:49 AM Jon Subscripted
wrote:
> Thanks Ben,
> I did what you suggested and somehow I think I moved on.
>
> Still I got a weird error: InternalError: (1060, u"Duplicate column name
> 'fen__tmp'")
>
> import sys
>
> sys.path.append(r'C:\Users\Jon\Downloads\web2py_src\web2py\gluon')
>
> from gluon import DAL,Field
> from gluon import *
>
> dbpath =
> r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
> problemsuri = 'mysql://root:web2py@localhost/xakemate'
> posFEN = 'rnb2rk1/pp4pp/1qpbp3/3p4/4P3/3P1NP1/PPPN1RBP/R1BQ3K b - - 0 13'
>
>
> db = DAL(problemsuri)#,folder=dbpath)#,auto_import=True)
>
> db.define_table(
> "problem",
> Field("question_hint",type="string"),
>
> Field("fen",type="string"),#,requires=(IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'problem.fen'))),
> Field("solutionSAN",type="list:string",requires=IS_NOT_EMPTY()),
> Field("solutionUCI",type="list:string",requires=IS_NOT_EMPTY()),
> Field("solordered",type="boolean",default=True),
> Field("pcomment",type="string"),
> Field("previousSAN",type="string",default=''),
> Field("previousUCI",type="string",default=''),
> Field("previousFEN",type="string",default=''),
> Field("game_control",type="string",default=''),
> Field("ply_control",type="integer",default=0)
> )
>
> query = (db.problem.fen == posFEN)
> problem = db(query).select(orderby=db.problem.id).first()
>
> No handlers could be found for logger "web2py"
> WARNING:root:Unable to import plural rules: No module named plural_rules
>
> Traceback (most recent call last):
> File "C:\Python27\withoutdefine.py", line 27, in
> Field("ply_control",type="integer",default=0)
> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7085, in
> define_table
> table = self.lazy_define_table(tablename,*fields,**args)
> File "C:\Python27\lib\site-packages\gluon\dal.py", line 7117, in
> lazy_define_table
> polymodel=polymodel)
> File "C:\Python27\lib\site-packages\gluon\dal.py", line 948, in
> create_table
> fake_migrate=fake_migrate)
> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1054, in
> migrate_table
> self.execute(sub_query)
> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1693, in execute
> return self.log_execute(*a, **b)
> File "C:\Python27\lib\site-packages\gluon\dal.py", line 1687, in
> log_execute
> ret = self.cursor.execute(*a, **b)
> File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 170, in
> execute
> result = self._query(query)
> File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 328, in
> _query
> conn.query(q)
> File "C:\Python27\lib\site-packages\pymysql\connections.py", line 517,
> in query
> self._affected_rows = self._read_query_result(unbuffered=unbuffered)
> File "C:\Python27\lib\site-packages\pymysql\connections.py", line 732,
> in _read_query_result
> result.read()
> File "C:\Python27\lib\site-packages\pymysql\connections.py", line 1075,
> in read
> first_packet = self.connection._read_packet()
> File "C:\Python27\lib\site-packages\pymysql\connections.py", line 684,
> in _read_packet
> packet.check_error()
> File "C:\Python27\lib\site-packages\pymysql\protocol.py", line 220, in
> check_error
> err.raise_mysql_exception(self._data)
> File "C:\Python27\lib\site-packages\pymysql\err.py", line 109, in
> raise_mysql_exception
> raise errorclass(errno, errval)
> InternalError: (1060, u"Duplicate column name 'fen__tmp'")
>
> I'm not aware of defining the 'fen' field twice, so I do not understande
> where did this come from.
> What does this mean?
> Regards, Jon.
>
>
> On Mon, Feb 11, 2019 at 6:08 PM Ben Duncan wrote:
>
>> No , all you need is the db.define for the table you are going to access,
>> unless there is foreign
Re: [web2py] Accessing MySQL data without define tables
Thanks Ben,
I did what you suggested and somehow I think I moved on.
Still I got a weird error: InternalError: (1060, u"Duplicate column name
'fen__tmp'")
import sys
sys.path.append(r'C:\Users\Jon\Downloads\web2py_src\web2py\gluon')
from gluon import DAL,Field
from gluon import *
dbpath =
r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
problemsuri = 'mysql://root:web2py@localhost/xakemate'
posFEN = 'rnb2rk1/pp4pp/1qpbp3/3p4/4P3/3P1NP1/PPPN1RBP/R1BQ3K b - - 0 13'
db = DAL(problemsuri)#,folder=dbpath)#,auto_import=True)
db.define_table(
"problem",
Field("question_hint",type="string"),
Field("fen",type="string"),#,requires=(IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'problem.fen'))),
Field("solutionSAN",type="list:string",requires=IS_NOT_EMPTY()),
Field("solutionUCI",type="list:string",requires=IS_NOT_EMPTY()),
Field("solordered",type="boolean",default=True),
Field("pcomment",type="string"),
Field("previousSAN",type="string",default=''),
Field("previousUCI",type="string",default=''),
Field("previousFEN",type="string",default=''),
Field("game_control",type="string",default=''),
Field("ply_control",type="integer",default=0)
)
query = (db.problem.fen == posFEN)
problem = db(query).select(orderby=db.problem.id).first()
No handlers could be found for logger "web2py"
WARNING:root:Unable to import plural rules: No module named plural_rules
Traceback (most recent call last):
File "C:\Python27\withoutdefine.py", line 27, in
Field("ply_control",type="integer",default=0)
File "C:\Python27\lib\site-packages\gluon\dal.py", line 7085, in
define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "C:\Python27\lib\site-packages\gluon\dal.py", line 7117, in
lazy_define_table
polymodel=polymodel)
File "C:\Python27\lib\site-packages\gluon\dal.py", line 948, in
create_table
fake_migrate=fake_migrate)
File "C:\Python27\lib\site-packages\gluon\dal.py", line 1054, in
migrate_table
self.execute(sub_query)
File "C:\Python27\lib\site-packages\gluon\dal.py", line 1693, in execute
return self.log_execute(*a, **b)
File "C:\Python27\lib\site-packages\gluon\dal.py", line 1687, in
log_execute
ret = self.cursor.execute(*a, **b)
File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 170, in
execute
result = self._query(query)
File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 328, in
_query
conn.query(q)
File "C:\Python27\lib\site-packages\pymysql\connections.py", line 517, in
query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "C:\Python27\lib\site-packages\pymysql\connections.py", line 732, in
_read_query_result
result.read()
File "C:\Python27\lib\site-packages\pymysql\connections.py", line 1075,
in read
first_packet = self.connection._read_packet()
File "C:\Python27\lib\site-packages\pymysql\connections.py", line 684, in
_read_packet
packet.check_error()
File "C:\Python27\lib\site-packages\pymysql\protocol.py", line 220, in
check_error
err.raise_mysql_exception(self._data)
File "C:\Python27\lib\site-packages\pymysql\err.py", line 109, in
raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (1060, u"Duplicate column name 'fen__tmp'")
I'm not aware of defining the 'fen' field twice, so I do not understande
where did this come from.
What does this mean?
Regards, Jon.
On Mon, Feb 11, 2019 at 6:08 PM Ben Duncan wrote:
> 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 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
Re: [web2py] Accessing MySQL data without define tables
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
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 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 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 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 -*-
>
> #
>
Re: [web2py] Accessing MySQL data without define tables
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 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 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 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
Re: [web2py] Accessing MySQL data without define tables
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
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 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 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
Re: [web2py] Accessing MySQL data without define tables
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 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 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,
Re: [web2py] Accessing MySQL data without define tables
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 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 )
>
> #
Re: [web2py] Accessing MySQL data without define tables
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
Re: [web2py] Accessing MySQL data without define tables
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 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
> 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 "", line 1, in
>> 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.
>>
>>
>>
>> Libre
>> de virus. www.avast.com
>>
>> <#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.
Re: [web2py] Accessing MySQL data without define tables
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
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 "", line 1, in
> 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.
>
>
>
> Libre
> de virus. www.avast.com
>
> <#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.
