Hi All, Massimo
I am receiving a dictionary of records from a webservice like below
(sample single record with just a few fields here) . Now I want to parse
all the records and insert the data in my table (Currently SQLite and later
it would be POSTGRE) . What is the best way to insert data
I'm attempting to process through record sets from DAL queries that can
sometimes return hundreds of thousands of records. To try to keep memory
usage under control I wanted to use iterselect() instead of a plain DAL
select(). However, the problem I'm running into is that as I process each
reco
Have you tried enabling the Multiple Active Result Sets option? I think you
can do so by adding the following to the connection string:
DAL('mssql4://username:password@localhost/test?MARS_Connection=yes', ...)
Note, it may need to be all caps -- MARS_CONNECTION.
Anthony
On Wednesday, January 1
If you can make the field names in the DAL model match exactly, you can
simply do:
db.mytable.insert(**db.mytable._filter_fields(record_dict))
If you can't change the field names in the database itself but are
comfortable changing the names within your DAL models, you can use the
"rname" optio
sqlform.factory() if you have 2 tables like now and SQLFORM() if you recude
this 2 table into 1.
Richard
On Tue, Jan 9, 2018 at 7:33 AM, Dragan Matic
wrote:
> I would like to have an icon or image picker in form where user could
> choose from a set of predefined icons.
> Form would contain a fe
Thank you Anthony, that works!
Only issue is that while using iterselect() you apparently can't do your
own db.commit() or else you'll get "Function sequence error (0) (SQLFetch)"
I suspect that it may be closing the result set that your'e trying to
iterate over. :\
On Wednesday, January 10,
On Wednesday, January 10, 2018 at 2:48:34 PM UTC-5, Brian M wrote:
>
> Thank you Anthony, that works!
>
> Only issue is that while using iterselect() you apparently can't do your
> own db.commit() or else you'll get "Function sequence error (0) (SQLFetch)"
> I suspect that it may be closing the r
Yes, I thought of a different DAL instance but for my situation it isn't
really necessary since I can move when I do the commit() or just store that
data elsewhere (the commit was really just to store a "I made it through
this datetime" checkpoint record). I was more mentioning it for the next
Hi
In a multi user environment , it is possible that 2 users are accessing the
database using the wizard form grid
or form smart grid . Suppose that the 2 users open in the edit window the
same row .
How a collision can be avoided ? That means i would like the a user will be
blocked for update
9 matches
Mail list logo
