[web2py] Re: web2py 2.15.4 is OUT
gluon.contrib.feedparser is using for Python 2.7 On Saturday, September 2, 2017 at 11:10:30 AM UTC+7, Massimo Di Pierro wrote: > > Includes a few bug-fixes (thanks to Anthony and Leonel in particular) and > it is tracking the latest python (thanks Giovanni). > > Please report any outstanding problem so we can continue make web2py > better. > > Massimo > > > > -- 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] Teste Softwares
already in discussion https://groups.google.com/d/topic/web2py/4HdkjbnlhBU/discussion 2017-10-02 19:06 GMT+01:00 Gelzieny rezende martins : > Como fazer teste Softwares com web2py > > -- > 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] Teste Softwares
example app with pytest https://github.com/jredrejo/bancal/tree/master/web2py/applications/bancal 2017-10-03 9:32 GMT+01:00 António Ramos : > already in discussion > > https://groups.google.com/d/topic/web2py/4HdkjbnlhBU/discussion > > > > > 2017-10-02 19:06 GMT+01:00 Gelzieny rezende martins : > >> Como fazer teste Softwares com web2py >> >> -- >> 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] Re: Google AMP - benefits with web2py?
People should use a tool to minimize js and css files. Grunt or Gulp for ex... 2017-09-29 23:34 GMT+01:00 Dave S : > > > On Friday, September 29, 2017 at 2:25:30 PM UTC-7, Leonel Câmara wrote: >> >> AMP will also change the URL of your webpages to have google in them. >> Frankly I don't like AMP at all. What you should be doing is making sure >> your website is light and fast instead of wasting your effort by enabling >> AMP and making changes specifically for it. There's nothing more annoying >> than getting the mobile version or AMP version of any site. Websites should >> be responsive and light by default. >> >> iOS11 quite correctly in my opinion already strips AMP links to the >> original version. >> > > > That invites asking you for your recommendations on how to be responsive > and light by default. > > (One approach, of course, is to limit the use of javascript and images > that need to be rendered, but that is a serious restiction, too. Another > thing that that AMP addresses [or claims to] is having the rendering of > your page held up by waiting for 3rd party resources to load ... which > usually, AIUI, involves advertising displays. Not having ads works for > some sites, but not all.) > > /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. > 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.
[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload
Would it be easier to create a name field instead of a file and then just
reference the name ID, and pull the file from the associated table?
On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote:
>
> Still receiving same error...
>
> This is my html code:
>
> I'm taking values from jstree and then putting them into a database
> (trying to at least)
>
>
> In view
>
> $("#btn").click(function () {
> var checked = $('#tree').jstree(true).get_selected();
> var testid = $('#test_id').val();
>
> console.log(checked)
> ajax('{{=URL('test_1')}}' +'?checked=' + checked +
> '?test_id='+testid, [], ':eval');
> });
> }
>
>
> and my test_1 function
> controller
>
> def test_1():
> value = request.vars.checked
> record_ids = [long(s) for s in re.findall('var_([0-9]*)', value)]
> test_id = re.findall('\?test_id=(.*)', value)[0]
>
> file_ids = [x.id for x in s if int(x) in record_ids]
>
> db.file_groups.insert(group_name=test_id, filename=file_ids)
> session.test = file_ids, test_id
>
> # handle the variable
> redirect(URL('run', args=value), client_side=True)
>
> On Monday, October 2, 2017 at 8:48:13 PM UTC-4, LoveWeb2py wrote:
>>
>> Okay, just delete the table and then set migrate=True ?
>>
>> On Monday, October 2, 2017 at 8:46:21 PM UTC-4, Anthony wrote:
>>>
>>> On Monday, October 2, 2017 at 7:57:19 PM UTC-4, LoveWeb2py wrote:
Yes... I believe so.
On Monday, October 2, 2017 at 7:53:13 PM UTC-4, Anthony wrote:
>
> Was that field originally a regular reference field and then you
> changed it to a list:reference field?
>
>>> I think that's the problem. Try re-creating the table (save the data to
>>> re-import).
>>>
>>> Anthony
>>>
>>
--
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.
[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload
On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote: > > Still receiving same error... > Maybe you didn't properly delete the table. No foreign key constraint is set for a list:reference field, so if you are getting that error, that means the database still has a foreign key constraint on the field, which implies the table was not deleted and re-created. Anthony -- 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.
[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload
I tried just renaming both databases and still received the same error. On Tuesday, October 3, 2017 at 11:27:53 AM UTC-4, Anthony wrote: > > On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote: >> >> Still receiving same error... >> > > Maybe you didn't properly delete the table. No foreign key constraint is > set for a list:reference field, so if you are getting that error, that > means the database still has a foreign key constraint on the field, which > implies the table was not deleted and re-created. > > Anthony > -- 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.
[web2py] Re: Insert into reference:list not working - FOREIGN KEY constraint failed field:upload
I moved all of the table files to an archive directory and let everything rebuild and it worked great. Thanks, Anthony! Really appreciate the time you take to help us all. On Tuesday, October 3, 2017 at 11:42:47 AM UTC-4, LoveWeb2py wrote: > > I tried just renaming both databases and still received the same error. > > On Tuesday, October 3, 2017 at 11:27:53 AM UTC-4, Anthony wrote: >> >> On Monday, October 2, 2017 at 9:24:29 PM UTC-4, LoveWeb2py wrote: >>> >>> Still receiving same error... >>> >> >> Maybe you didn't properly delete the table. No foreign key constraint is >> set for a list:reference field, so if you are getting that error, that >> means the database still has a foreign key constraint on the field, which >> implies the table was not deleted and re-created. >> >> Anthony >> > -- 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.
[web2py] Upcoming birthdays
Hopefully I'm missing something obvious.
I have a birth date in my employee table. I want to build a DAL query to
show people who will have a birthday in the next month.
db.define_table('employee',
Field('id', 'id', readable=False),
Field('first_name', length=25, required=True),
Field('last_name', length=25, required=True),
Field('dob', 'date', label='Date of Birth'),
format='%(last_name)s, %(first_name)s')
How do I write a query to show the employees with birthdays in the next 30
days?
-Jim
--
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.
[web2py] Re: Upcoming birthdays
perhaps you can use python datetime module. e.g. import datetime print (datetime.date.today() + datetime.timedelta(1*365/12)).isoformat() or from datetime import date from dateutil.relativedelta import relativedelta six_months = date.today() + relativedelta(months=+1) The advantage of the latest approach is that it takes care of issues with 28, 30, 31 days etc. best regards, stifan -- 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.
[web2py] Re: Upcoming birthdays
Stifan I use that method to build dates quite often. However, I don't know how to translate that into a DAL query. -Jim On Tuesday, October 3, 2017 at 4:18:30 PM UTC-5, 黄祥 wrote: > > perhaps you can use python datetime module. > e.g. > import datetime > print (datetime.date.today() + datetime.timedelta(1*365/12)).isoformat() > > or > > from datetime import date > from dateutil.relativedelta import relativedelta > six_months = date.today() + relativedelta(months=+1) > > The advantage of the latest approach is that it takes care of issues with > 28, 30, 31 days etc. > > best regards, > stifan > -- 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.
[web2py] Re: Upcoming birthdays
On Tuesday, October 3, 2017 at 2:38:38 PM UTC-7, Jim S wrote: > > Stifan > > I use that method to build dates quite often. However, I don't know how > to translate that into a DAL query. > > -Jim > > I have an example, but it's at home. /dps > On Tuesday, October 3, 2017 at 4:18:30 PM UTC-5, 黄祥 wrote: >> >> perhaps you can use python datetime module. >> e.g. >> import datetime >> print (datetime.date.today() + datetime.timedelta(1*365/12)).isoformat() >> >> or >> >> from datetime import date >> from dateutil.relativedelta import relativedelta >> six_months = date.today() + relativedelta(months=+1) >> >> The advantage of the latest approach is that it takes care of issues with >> 28, 30, 31 days etc. >> >> best regards, >> stifan >> > -- 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] Re: Upcoming birthdays
I don't think that will do it. The date stored in the database would be 10/15/1980, or 10/21/1993. Those should both show a birthday in the month of August. But, I don't want just a matching month. I want it for the next 30 days. So, on December 15th I should see all birthdays between December 15th and January 15th regardless of what year the birthday is in. Jim On Oct 3, 2017 6:22 PM, "Limedrop" wrote: > It just works. For example: > > import datetime > now = datetime.datetime.now() > last_date = now + datetime.timedelta(days=settings.days_to_include) > query = (db.person.interview_datetime < last_date) > rows = db(query).select() > > > On Wednesday, 4 October 2017 10:38:38 UTC+13, Jim S wrote: >> >> Stifan >> >> I use that method to build dates quite often. However, I don't know how >> to translate that into a DAL query. >> >> -Jim >> >> On Tuesday, October 3, 2017 at 4:18:30 PM UTC-5, 黄祥 wrote: >>> >>> perhaps you can use python datetime module. >>> e.g. >>> import datetime >>> print (datetime.date.today() + datetime.timedelta(1*365/12)).isoformat() >>> >>> or >>> >>> from datetime import date >>> from dateutil.relativedelta import relativedelta >>> six_months = date.today() + relativedelta(months=+1) >>> >>> The advantage of the latest approach is that it takes care of issues >>> with 28, 30, 31 days etc. >>> >>> best regards, >>> stifan >>> >> -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/web2py/-mKujQj0oB4/unsubscribe. > To unsubscribe from this group and all its topics, 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] Re: Upcoming birthdays
On Tuesday, October 3, 2017 at 4:48:52 PM UTC-7, Jim S wrote: > > I don't think that will do it. The date stored in the database would be > 10/15/1980, or 10/21/1993. > > Those should both show a birthday in the month of August. > Er, October? > But, I don't want just a matching month. I want it for the next 30 days. > > So, on December 15th I should see all birthdays between December 15th and > January 15th regardless of what year the birthday is in. > > Jim > > It's not too much more. You identify the current day and month, and the day and month of 30 days from now, and do 2 selects: First for the bdays whose month matches the current and whose day is greater than today. Second for the bdays whose month matches the successor month and whose day is less than the +30 day. (My example covers years from 1600 to present, for composers. i also have getting everybody in any single calendar month, which is just one query. Results for October: Paul Abraham Dukas 1865-10-01 Stephen Michael Reich 1936-10-03 Louis Ferdinand Gottschalk 1864-10-07 Toru Takemitsu 1930-10-08 Giulio Romolo Caccini 1551-10-08 Charles-Camille Saint-Saëns 1835-10-09 Einojuhani Rautavaara 1928-10-09 Giuseppe Fortunino Francesco Verdi 1813-10-10 Ralph Vaughan Williams 1872-10-12 Sylvius Leopold Weiss 1687-10-12 Healey Willan 1880-10-12 Ciprian Porumbescu 1853-10-14 Dag Ivar Wirén 1905-10-15 Jan Dismas Zelenka 1679-10-16 Albert Franz Doppler 1821-10-16 Domenico Zipoli 1688-10-17 Herbert Norman Howells 1892-10-17 Baldassare Galuppi 1706-10-18 Howard Leslie Shore 1946-10-18 Charles Edward Ives 1874-10-20 Sir Malcolm Henry Arnold 1921-10-21 Joseph Canteloube 1879-10-21 Franz Liszt 1811-10-22 Ned Rorem 1923-10-23 Johann Baptist (II) Strauss 1825-10-25 Georges Bizet 1838-10-25 Peter Lieberson 1946-10-25 Giuseppe Domenico Scarlatti 1685-10-26 Niccolò Paganini 1782-10-27 Carl Davis 1936-10-28 Peter Warlock 1894-10-30 Unico Wilhelm van Wassenaer 1692-10-30 ) /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. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Re: Upcoming birthdays
Thanks everyone. Time for me to call it a night. I'll give it a run tomorrow morning. -Jim On Tue, Oct 3, 2017 at 9:46 PM, Limedrop wrote: > What about something like this... > > import datetime > now = datetime.datetime.now() > the_future = now + datetime.timedelta(days=30) > query = ((db.employee.dob.month() == now.month()) & > (db.employee.dob.day() > now.day())) > query |= ((db.employee.dob.month() == the_future.month()) & > (db.employee.dob.day() < the_future.day())) > rows = db(query).select() > > A bit rough and not tested, but the point is that you can use > datetime.month() as part of the DAL query. > > > On Wednesday, 4 October 2017 12:48:52 UTC+13, Jim S wrote: >> >> I don't think that will do it. The date stored in the database would be >> 10/15/1980, or 10/21/1993. >> >> Those should both show a birthday in the month of August. But, I don't >> want just a matching month. I want it for the next 30 days. >> >> So, on December 15th I should see all birthdays between December 15th and >> January 15th regardless of what year the birthday is in. >> >> Jim >> >> >> On Oct 3, 2017 6:22 PM, "Limedrop" wrote: >> >>> It just works. For example: >>> >>> import datetime >>> now = datetime.datetime.now() >>> last_date = now + datetime.timedelta(days=settings.days_to_include) >>> query = (db.person.interview_datetime < last_date) >>> rows = db(query).select() >>> >>> >>> On Wednesday, 4 October 2017 10:38:38 UTC+13, Jim S wrote: Stifan I use that method to build dates quite often. However, I don't know how to translate that into a DAL query. -Jim On Tuesday, October 3, 2017 at 4:18:30 PM UTC-5, 黄祥 wrote: > > perhaps you can use python datetime module. > e.g. > import datetime > print (datetime.date.today() + datetime.timedelta(1*365/12)). > isoformat() > > or > > from datetime import date > from dateutil.relativedelta import relativedelta > six_months = date.today() + relativedelta(months=+1) > > The advantage of the latest approach is that it takes care of issues > with 28, 30, 31 days etc. > > best regards, > stifan > -- >>> 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 a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>> pic/web2py/-mKujQj0oB4/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+un...@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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/web2py/-mKujQj0oB4/unsubscribe. > To unsubscribe from this group and all its topics, 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.
