[web2py] Re: how to create a readonly connection to remote db
even if you just read a table and you want to read that table with a DAL select, you need to code the model in your application. just set migrate=False on the table definitions if tables are already there, and DAL will be happy to work with them On Tuesday, July 30, 2013 7:42:54 AM UTC+2, Monika Yadav wrote: > > > > On Monday, July 29, 2013 7:33:21 PM UTC+5:30, Niphlod wrote: >> >> there's no default "read-only" in client-side libraries that connects to >> a database. What do you need specifically ? >> >> On Monday, July 29, 2013 1:49:11 PM UTC+2, Monika Yadav wrote: >>> >>> how to create a readonly connection to remote db without using >>> executesql...i want to use the dal properties >>> >> > > > we are creating a automated testing framework to test a user interface of > a website.for that purpose we are given read only rights to that mysql > database from which we want to fetch data and put a check. > > i have created a DAL object for that say db1. > but when i run db1.(db1.table_name.attribute=something).select > > it says that the DAL object has no attribute table_name > but with the help of this DAL object i am able to run the raw sql query > using executesql method > -- --- 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/groups/opt_out.
[web2py] Re: how to create a readonly connection to remote db
On Monday, July 29, 2013 7:33:21 PM UTC+5:30, Niphlod wrote: > > there's no default "read-only" in client-side libraries that connects to a > database. What do you need specifically ? > > On Monday, July 29, 2013 1:49:11 PM UTC+2, Monika Yadav wrote: >> >> how to create a readonly connection to remote db without using >> executesql...i want to use the dal properties >> > we are creating a automated testing framework to test a user interface of a website.for that purpose we are given read only rights to that mysql database from which we want to fetch data and put a check. i have created a DAL object for that say db1. but when i run db1.(db1.table_name.attribute=something).select it says that the DAL object has no attribute table_name but with the help of this DAL object i am able to run the raw sql query using executesql method -- --- 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/groups/opt_out.
[web2py] Re: how to create a readonly connection to remote db
there's no default "read-only" in client-side libraries that connects to a database. What do you need specifically ? On Monday, July 29, 2013 1:49:11 PM UTC+2, Monika Yadav wrote: > > how to create a readonly connection to remote db without using > executesql...i want to use the dal properties > -- --- 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/groups/opt_out.