[web2py] Re: pyDAL looks abandoned?
Yes, peewee is cool but too verbose, almost like pure SQL. -- 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/f408eca2-dc3b-4976-94b4-60ac0f1aaa79o%40googlegroups.com.
[web2py] Re: Migrate web2py sqlite application to mssql
Wonderful! I will test. Thank you so much Il giorno mercoledì 12 agosto 2020 17:17:17 UTC+2, villas ha scritto: > > Here are some notes which you may find helpful... > > The basic idea is this: > >- Create a new DB using your preferred MSSQL management tool. >- Change your DAL connection string and run the app. >- Check that the new DB has all the tables. >- Migrate your data > > Please read the following resources before you start. > > *See this section in the book:* > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another > The utility script is here: web2py/scripts/cpdb.py > > *Check out this thread: * > https://groups.google.com/forum/#!topic/web2py/mQk2hoRf7gw > > > *Appadmin* > The appadmin allows you to export your data from your old DB. > > > *Be aware of this method:*db.import_from_csv_file() > > > -- 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/861f6e7f-10d9-4c71-aab7-d23ad155c7e2o%40googlegroups.com.
[web2py] Re: pyDAL looks abandoned?
FWIW there's nothing stopping you from using peewee inside web2py instead of DAL, if you desire. It's kind of an advanced topic, but it's possible. I notice peewee relies on cascaded message sends. Being an old Smalltalker I actually like cascaded message sends, but I recall that pypy really does not like them. They can leave chains of objects that are harder for pypy's storage reclamation to deal with (unless that's changed in pypy -- It moves pretty fast). On Monday, May 11, 2020 at 3:27:14 PM UTC-5, Val K wrote: > > > There are 131 issues on pyDAL-GitHub, but the problem is not in the amount > but in that more than half of them without any response. Look at peewee > that has 7.5k stars and only 2 open issues!... yes, this is impolite > comparision - sorry. > I've just need to implement CTE + WITH RECURSIVE (like this > http://docs.peewee-orm.com/en/latest/peewee/querying.html#recursive-ctes) > and I wasted 2 days to figure out how I can do very simple thing like '1 > AS foo' in right way that is (as I suppose): > Expression(db, '1', type='integer').with_alias('foo') > > So, the question is: why is there nothing about that in the book? > Why does pyDAL have no that very simple but very necessary method which > allows to do cool things like: > db(...).select( > ..., > db.exp( >'max(product.price) OVER(PARTITION BY product.category)', >type = 'decimal(n, m)' # the same as Field(..., type = 'decimal(n, > m)') > ).with_alias('most_expensive_in_category') > ) > > here is used WINDOW-function that allows to get products list with > 'most_expensive_in_category' in *one* plain query > *without using subquery* with GRUOP BY product.category + join > > Also there is my PR on web2py book > https://github.com/web2py/web2py-book/pull/424 > it hangs for almost a year - it is just a book, not code > I'm sad > -- 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/ce42fcb5-0e14-459a-af80-da635d5ef173o%40googlegroups.com.
[web2py] Re: Tip - Using multiple web2py templates
Doesn't this have an unfortunate negative effect on "compiled" views? To be compiled, everything about the view needs to be known ahead of time and your dynamic use of templates seems to defeat that. I suspect when you choose to "compile" the application from the web2py admin interface, these views will remain interpreted, defeating the purpose of compiling the app. But I could be wrong. On Monday, June 1, 2020 at 4:44:16 PM UTC-5, Rodrigo Attique wrote: > > After a lot of brainstorming I found a way to allow web2py to use multiple > templates. Perhaps for the elderly it is not a novelty, but for the > youngest ... This will be a hand in the wheel. > > Link: > > https://web2pymania.blogspot.com/2020/06/using-multiple-web2py-templates.html > -- 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/d067224a-e081-432b-b1cc-a8806b163eb2o%40googlegroups.com.
[web2py] Re: Migrate web2py sqlite application to mssql
Here are some notes which you may find helpful... The basic idea is this: - Create a new DB using your preferred MSSQL management tool. - Change your DAL connection string and run the app. - Check that the new DB has all the tables. - Migrate your data Please read the following resources before you start. *See this section in the book:* http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another The utility script is here: web2py/scripts/cpdb.py *Check out this thread: * https://groups.google.com/forum/#!topic/web2py/mQk2hoRf7gw *Appadmin* The appadmin allows you to export your data from your old DB. *Be aware of this method:*db.import_from_csv_file() -- 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/9406ce55-a8eb-43db-9064-b3ed45217d3do%40googlegroups.com.
[web2py] Migrate web2py sqlite application to mssql
Hello, can anyone tell me how to migrate a web2py application with simple sqlite database to a MSSQL 2016 database? Only change the DAL? the system create itself all the tables and database? Thank you very much to who can answer me! -- 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/e52da628-f13d-4891-bd4e-5cf44c287934o%40googlegroups.com.