[web2py] Setting a default reference value as that of a specific group the logging in user is a member of

2020-02-24 Thread mostwanted
I have 2 tables about a hotel, one table registers the hotel itself & the 
other is about meals that are offered at the hotel but the idea is that 
only group members of each hotel have to & can only register meals for 
their hotels. So to avoid mistakes & prevent malicious intentions I was 
wondering if its possible to have the referencing field in the meals table 
pre-selected appropriately for the logged in user with their correct hotel 
name as per the group they belong to. I hope I make sense:

*MODEL CODE*
db.define_table('hotel_profile',
Field('hotel_name'),
Field('logo', 'upload'),
Field('tel1'),
Field('email_address'),
Field('directions', 'text', requires=IS_LENGTH(500)),
Field('google_directions'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False),
Field('groups', 'reference auth_group', default=get_group(), 
readable=False, writable=False),
format='%(hotel_name)s'
   )


db.define_table('meals',
Field('hotel', 'reference hotel_profile'),
Field('supper_price'),
Field('supper_details', 'text', requires=IS_LENGTH(200)),
Field('lunch_price'),
Field('lunch_details', 'text', requires=IS_LENGTH(200)),
Field('breakfast_price'),
Field('breakfast_details', 'text', requires=IS_LENGTH(200)),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False),
Field('groups', 'reference auth_group', default=get_group(), 
readable=False, writable=False)
   )

Regards;

Mostwanted

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/be138b98-8d67-4a8d-bb77-b4410434f882%40googlegroups.com.


[web2py] Re: unexpected end of stream - py4web

2020-02-24 Thread Dave S


On Sunday, February 23, 2020 at 11:26:50 PM UTC-8, Edoardo Torrini wrote:
>
> Hi,
> I will attach you some part of code:
>
>
>
>
> this is the task of my app:
>
> [image: task prd - py4web.png]
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> I am still surprised by that last line.
>

Wouldn't the return exit produzione() while evaluating object_list and 
before actually calling the json.dumps() ?

/dps

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/dee3cad1-f72c-493f-a165-4b956cd82c84%40googlegroups.com.


Re: [web2py] Re: LOAD in py4web

2020-02-24 Thread António Ramos
I think LOAD should be gone and we should move this kind of interaction to
the client part.
Also py4web should stick with server stuff and let client stuff integrate
better an in a more independent way.
For me FORM / smartgrid should also be gone. Vuetify and buefy tables are
awesome. dont try to compete with that because your are competing with the
power of vuejs. Just ease the connection between the 2.
The problem i see with vuejs is working with vue components. Without the
need for vue components maybe a simpler tool like
https://github.com/alpinejs/alpine  should be enough



Regards
António




Em seg., 24 de fev. de 2020 às 06:31, Massimo Di Pierro <
massimo.dipie...@gmail.com> escreveu:

> We can add it in utils. But before we do. Do other peopl find it useful?
> Is that a pattern we should encourage vs, for example, vue.js?
>
> On Sunday, 23 February 2020 10:18:51 UTC-8, RHC wrote:
>>
>> HI,
>>
>> I am beginning to experiment with py4web, I like the sound of it and I am
>> looking to convert a web2py project to py4web to see how they compare.
>>
>> It appears that the LOAD (helper?) that was available in web2py templates
>> is not available in py4web. I was using this to populate part of a web
>> page, I liked the way you had the option to use LOAD to call a separate URL
>> (within the same app) and insert the result into your page before returning
>> the page to the client.
>>
>> What is the reason for the absence of LOAD in py4web? is there a
>> recommended alternative method of achieving the same effect? I have used a
>> mixture of ajax=True and ajax=False options for this feature.
>>
>> Thanks,
>>
>> Richard.
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/7cfaf6be-8be3-41dc-8745-ab59716f68af%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAEM0BxO6k7M-Yfk-r3Oc2B2zvScvxSQ%2BLC%3DXPtXWttSGnO0irA%40mail.gmail.com.


[web2py] off topic - Alpine JS as an alternative to vuejs/react

2020-02-24 Thread António Ramos
vuejs is awesome but for simple stuff maybe alpine js is simpler.
Just asking your thoughts if any...
https://github.com/alpinejs/alpine

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAEM0BxMgKVVLr%2BQN7ouJM7S_qYm-b1dmcYX-bAP3w0YxJE_tZA%40mail.gmail.com.


[web2py] Re: PY4WEB request.vars error

2020-02-24 Thread Ruslan Gareev
Hi!

Now in py4web it will be (if POST vars): 
request.forms.message or request.POST.message

or if GET vars:
request.query.message or request.GET.message


понедельник, 24 февраля 2020 г., 20:11:02 UTC+5 пользователь Maurice Waka 
написал:
>
> Hi 
> I can't make a head or tail out of this.
> What changed from e.g. 'request.vars.messag'?
> DO you have any example I can use?
> Regards
>
> On Monday, February 24, 2020 at 2:17:22 AM UTC+3, Val K wrote:
>>
>> p4web `request` is bottle request, see 
>> https://bottlepy.org/docs/dev/api.html#bottle.Request 
>>
>> On Monday, February 24, 2020 at 12:30:29 AM UTC+3, Maurice Waka wrote:
>>>
>>> New issue with py4web.
>>>
>>> Whats the new code for request.vars??
>>>
>>> I get this error:
>>>
>>>
>>> Traceback (most recent call last):
>>>  File "/home/maurice/.local/lib/python3.6/site-packages/bottle.py", 
>>> line 1397, in __getattr__
>>>  var = self.environ['bottle.request.ext.%s'%name]
>>> KeyError: 'bottle.request.ext.vars'
>>>
>>> During handling of the above exception, another exception occurred:
>>>
>>> Traceback (most recent call last):
>>>  File "/home/maurice/py4web/py4web/core.py", line 551, in wrapper
>>>  ret = func(*func_args, **func_kwargs)
>>>  File "/home/maurice/py4web/py4web/core.py", line 512, in wrapper
>>>  ret = func(*args, **kwargs)
>>>  File "apps/_scaffolds/controllers.py", line 86, in index
>>>  if request.vars:
>>>  File "/home/maurice/.local/lib/python3.6/site-packages/bottle.py", 
>>> line 1400, in __getattr__
>>>  raise AttributeError('Attribute %r not defined.' % name)
>>> AttributeError: Attribute 'vars' not defined.
>>>
>>>
>>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/74846e2b-48a6-4cd6-9c1d-d9af401cd631%40googlegroups.com.


[web2py] Re: PY4WEB request.vars error

2020-02-24 Thread Maurice Waka
Hi 
I can't make a head or tail out of this.
What changed from e.g. 'request.vars.messag'?
DO you have any example I can use?
Regards

On Monday, February 24, 2020 at 2:17:22 AM UTC+3, Val K wrote:
>
> p4web `request` is bottle request, see 
> https://bottlepy.org/docs/dev/api.html#bottle.Request 
>
> On Monday, February 24, 2020 at 12:30:29 AM UTC+3, Maurice Waka wrote:
>>
>> New issue with py4web.
>>
>> Whats the new code for request.vars??
>>
>> I get this error:
>>
>>
>> Traceback (most recent call last):
>>  File "/home/maurice/.local/lib/python3.6/site-packages/bottle.py", line 
>> 1397, in __getattr__
>>  var = self.environ['bottle.request.ext.%s'%name]
>> KeyError: 'bottle.request.ext.vars'
>>
>> During handling of the above exception, another exception occurred:
>>
>> Traceback (most recent call last):
>>  File "/home/maurice/py4web/py4web/core.py", line 551, in wrapper
>>  ret = func(*func_args, **func_kwargs)
>>  File "/home/maurice/py4web/py4web/core.py", line 512, in wrapper
>>  ret = func(*args, **kwargs)
>>  File "apps/_scaffolds/controllers.py", line 86, in index
>>  if request.vars:
>>  File "/home/maurice/.local/lib/python3.6/site-packages/bottle.py", line 
>> 1400, in __getattr__
>>  raise AttributeError('Attribute %r not defined.' % name)
>> AttributeError: Attribute 'vars' not defined.
>>
>>
>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/db188b1c-838d-4294-9c9f-eb94dc2394da%40googlegroups.com.


[web2py] Re: Py4web: ¿Practical example step by step?

2020-02-24 Thread Yuver Parra
Good morning Massimo.
Does the promised step-by-step manual already exist?

El miércoles, 22 de enero de 2020, 1:25:05 (UTC-5), Massimo Di Pierro 
escribió:
>
> I am preparing one. It will be done in 2 weeks. Promise.
>
> On Tuesday, 21 January 2020 01:15:27 UTC-8, Dave S wrote:
>>
>>
>>
>> On Monday, January 20, 2020 at 4:55:33 AM UTC-8, Yuver Parra wrote:
>>>
>>>
>>> Good morning and thanks in advance for sharing your knowledge in this 
>>> group.
>>> Do any of you have a practical example where you can follow step by step 
>>> learning from the installation of py4web to the setting up of a site?
>>>
>>> Thanks for the reply.
>>>
>>
>> When posting a new euqestion, please don't check "show at the top" --- 
>> save that for messages that need to be displayed long-term,
>> like etiquette or policy.
>>
>> Have you looked at README.md at
>> https://github.com/web2py/py4web> ?
>>
>> This should make a small stand-alone server and one or more sample 
>> applications.
>>
>> If you have looked at that introduction, what questions do you still have?
>>
>> Also, look at the py4web documentation at
>> 
>>
>> I haven't heard of any training videos yet (the older framework, web2py, 
>> has several, but those wouldn't be useful for py4web).
>>
>> If you need to learn more about setting up a front-end server, such as 
>> NginX, you should consult the NginX website.  
>> (the web2py position on Apache is that if you don't have it already, you 
>> should consider NginX or other easier-to-use front ends.)
>>
>> Good luck!
>>
>> /dps
>>
>>
>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/afb0132e-2e65-453e-a319-f953cacf2221%40googlegroups.com.


[web2py] Py4Web "tags" should be SCOPES

2020-02-24 Thread Kevin Keller
Hey, 

I would like to suggest, that if Py4Web is supposed to be an API first 
framework that it adheres to 
modern auth standards right out of the gate. 

Apart from having the ability to provide JWT access tokens and more Oauth2 
plugins then just facebook and google ( all things I started to work on)
I think we need to to think in terms of scopes when it comes to access 
management instead of "tags" for access authorization. 

It is pretty much the same thing, but using the the term scopes and 
adhering to the oauth2 terms and philosophy will make it 
easier for programmers to understand how to secure APIs created with py4web 
faster. 

We also need to the ability to properly parse JWT tokens so that scopes 
included in the token can be matched to what is now called py4web "tags" 
for data authorization. Also, we should be easily able to validate JWT 
tokens offline.

Plus py4web, if it wants to play the API game, needs to be able to extract 
claims from a JWT token in order to contextualize an API call easily. 

I think I have my work cut out for me, but just putting it out there, in 
the hope I can garner some support and understanding for this idea/approach
and maybe someone wants to also help out with this who understands API 
design and OIDC/Oauth2. 

Maybe we can use some library the is there i.e.:

https://requests-oauthlib.readthedocs.io/en/latest/index.html

and if want to mint our own JWT tokens for prototyping:

https://github.com/Refinitiv/bottle-oauthlib

I ll look into that, unless you have a better idea. 




-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/3a8a0f6a-f64e-4941-892b-9adfaac8216a%40googlegroups.com.


Re: [web2py] Re: p4web auth issues

2020-02-24 Thread Maurice Waka
Working now.

I had to reinstall the app.
Regards

On Monday, February 24, 2020 at 12:58:10 PM UTC+3, Val K wrote:
>
> get_user(), not get.user()

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/c2b68a80-9035-4086-af4e-a56737401bcc%40googlegroups.com.


Re: [web2py] Re: p4web auth issues

2020-02-24 Thread Val K
get_user(), not get.user()

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/01ce9f84-c876-43f1-912a-901d7d4355dc%40googlegroups.com.


Re: [web2py] Re: p4web auth issues

2020-02-24 Thread Maurice Waka
Something is not right...
Now I get this error:


Traceback (most recent call last):
 File "/home/maurice/py4web/py4web/core.py", line 551, in wrapper
 ret = func(*func_args, **func_kwargs)
 File "/home/maurice/py4web/py4web/core.py", line 512, in wrapper
 ret = func(*args, **kwargs)
 File "apps/_scaffolds/controllers.py", line 74, in index
 user = auth.get.user()['first_name']
AttributeError: 'Auth' object has no attribute 'get'



On Monday, February 24, 2020 at 6:14:24 AM UTC+3, Scott Hunter wrote:
>
> user = auth.get.user()['first_name']
>
> On Sunday, February 23, 2020 at 9:23:06 PM UTC-5, Lovedie JC wrote:
>>
>> Thanks.
>> Before you replied I had tried :
>> user = auth.get.user()[first_name]
>>
>> With an error.. 'first_name' is not defined
>> Regards 
>>
>> On Mon, Feb 24, 2020, 02:02 Val K  wrote:
>>
>>> `auth` in py4web is no the same as in web2py
>>> to get user-record you should
>>> ...
>>> def index():
>>> user = auth.get_user()
>>>
>>>
>>>
>>> On Sunday, February 23, 2020 at 8:47:46 PM UTC+3, Maurice Waka wrote:


 import os
 import datetime as dt
 from datetime import datetime, timedelta, date 
 from .common import db, session, T, cache, auth, logger, authenticated, 
 unauthenticated
 from py4web import action, request, DAL, Field, Session, Cache, 
 user_in, abort, redirect, URL, Field
 from py4web.utils.auth import Auth
 from py4web import action, request, abort, redirect, URL, Field
 from py4web.utils.form import Form, FormStyleBulma
 from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
 from pydal.validators import IS_NOT_EMPTY, IS_INT_IN_RANGE, IS_IN_SET, 
 IS_IN_DB, IS_EMAIL, IS_MATCH
 from yatl.helpers import INPUT, H1, HTML, BODY, A
 from pydal.validators import *

 db.define_table('answers',
 Field('author', 'reference auth_user', 
 default=auth.user_id, readable=False, writable=False),
 Field('userId','reference 
 auth_user',unique=True,readable=False,writable=False),
 Field('quest', 'text', requires=IS_NOT_EMPTY(),),
 auth.signature
 )
 db.define_table('posts',
 Field('author', 'reference auth_user', 
 default=auth.user_id, writable=False, readable=False),
 Field("message", 'text', requires=IS_NOT_EMPTY(), 
 notnull=False),
 auth.signature
 )

 @authenticated()
 def index():
 codes = []
 del codes[:]
 r = []
 yesterday = dt.datetime.utcnow() - dt.timedelta(days=1)
 db(db.answers.modified_on < yesterday).delete()
 """Avoid an empty table"""
 user = db(db.posts.author== auth.user_id).select(db.posts.id, 
 db.posts.author, orderby=~db.posts.id, limitby=(0,1)).first()
 if user.author if user else None == auth.user_id:
 pass
 else:
 db.posts.insert(message="Welcome "+auth_user.first_name+'.'+' 
 Thank you for signing in with us. Blah blah blah.', author=auth.user_id, 
 created_by=auth.user_id, modified_by=auth.user_id)
 db.commit()
 On Sunday, February 23, 2020 at 8:28:28 PM UTC+3, Val K wrote:
>
> Show your code, please

 -- 
>>> 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 web...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/web2py/19c4dd56-ffc3-40bb-9067-e5525ffafcf7%40googlegroups.com
>>>  
>>> 
>>> .
>>>
>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/534856e5-40b7-49d4-9353-d5b853b0541b%40googlegroups.com.


[web2py] Re: Future of web2py

2020-02-24 Thread Jörg Schneider
Hello Massimo,

at first I want to give you a thousands thanks for creating and promoting 
web2py! I've learnt a lot from your Vimeo tutorials 5 years ago and was 
able to built helpful internal web based tools for non-profit organisations 
or choirs without great effort. With other words: I really appreciate 
web2py and the work of this community.

I understand, that the development of py4web is a necessary move and I 
really hope that I'm able to move my apps to the next level of web 
frameworks with your help. :-)


Am Freitag, 21. Februar 2020 04:51:18 UTC+1 schrieb Massimo Di Pierro:
>
> It will continue fix bugs. I will add new features as long the same 
> features overlap with py4web.
> Honestly web2py has not needed much attention in a while.
> I do recommend that people move their apps to py4web simply because I 
> believe the latter is better.
>
> On Tuesday, 18 February 2020 07:36:24 UTC-8, Clemens wrote:
>
>> Hello Massimo,
>>
>> I've understood, that py4web is the future. But I have one important 
>> question: Will web2py further maintained? And how long will it be 
>> maintained? I'm asking, because I've developed an application on web2py and 
>> I need to plan when it has to be migrated/re-implemented. And what do you 
>> think will be a factor (e.g. in percentage of the original implementation 
>> effort) to switch an application from web2py to py4web?
>>
>> Thanks in advance for a short answer!
>>
>> Best regards
>> Clemens
>>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ba58555b-6ada-4467-b97e-ae0e390f7cc8%40googlegroups.com.


[web2py] Re: Many records in one transaction

2020-02-24 Thread Константин Комков
*Villas*, I can explain why I need to delete many records. I have template 
of timetable (example upper in my post). There is templates for each group 
for each faculty in university. ~40 groups = 40 templates for each faculty.
When I do timetable I need to do next operations:

   - Select all active groups for faculty (1 query);
   - Select holidays from production calendar (directory table in database, 
   1 query);
   - Get template for each group (start cycle, no query becouse get from 
   sessions);
   - Delete previous timetable becouse I don't know what is new in template 
   and I don't know it is new template or old (~400 record);
   - Select all subjects, hours for subjects and schedule of educational 
   process in a group (1 procedure);
   - Find period of teoretical occupations in a schedule;
   - There is two check of template and correct it if it is necessary 
   (updating rule in template ~2 rows);
   - Insert lesson to database in cycle start with first date of teoretical 
   occupations if date corresponds all rules in a template and not holidays 
   and hours for a subject > 0 (~400 record);
   - Create report about group (see picture).

As result we have 40 * 400 = 16000 rows for deleting and 16000 rows for 
inserting. But there is fuculty with 56 groups then ~22400 rows for delete 
and insert. Becouse I told 25000 rows it is max.
Let's talk about *IIS* settings, becouse if I do that on *Rocket *server 
all work. But on IIS without deleting at all I have problem with inserting 
5000 rows.
Thank you for attention!

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/00095928-cb3b-4694-a3d2-9f0cca0b8961%40googlegroups.com.