configuration $=$ AppConfig$($reload$=$True$)$

if not request.env.web$2$py$\_$runtime$\_$gae:

#

# if NOT running on Google App Engine use SQLite or other DB

H

db $=$ DAL$("$mysql:$//$root:root@localhost$/$test$?$set$\_$encoding$=$utf$8$mb$4",$

migrate$\_$enabled$=$False$)$

else:

#

# connect to Google BigTable $($optional 'google:datastore:$//$namespace$\text{'})$

#

db $=$ DAL$(\text{'}$google:datastore$+$ndb$\text{'})$

# store sessions and tickets there

#

session. connect $($request$,$ response, $db=db)$

# # or store session in Memcache, Redis, etc.

# from gluon.contrib. memdb import MEMDB

# from google.appengine.api.memcache import client

# session.connect$($request$,$ response, Client$()))$

#

db$.$ define$\_$table$(\text{'}$authors$\text{'},$

Field$(\text{'}$id$\text{'},$ 'integer'$),$

Field$(\text{'}$name$\text{'},$ requires$=$IS$\_$NOT$\_$EMPTY$()),$

field$(\text{'}$bio$\text{'},$ 'text'$),$

field$(\text{'}$email$\text{'},$ requires$=$IS$\_$EMAIL$()),$

db$.$ define$\_$table$(\text{'}$books$\text{'},$

field'$(\text{'}$id$\text{'},$ 'integer'$),$

field$(\text{'}$titie$\text{'},$ requires$=$IS$\_$NOT EMPTY$()),$

Field$(\text{'}$author$\text{'},$ 'reference authors'$),$

field$(\text{'}$publication$\_$year', 'integer',$\text{'}$ requires$=$IS$\_$INT$\_$IN$\_$RANGE$(1000,3000)),$

Using DAL $,$ how would you select all books authored by author "Ahmed" who has id$"10$