execute (" SELECT ▁* ▁FROM ▁products ▁WHERE ▁name ▁= ▁% s ", ▁params ) ▁▁▁▁ ▁print ( cursor . fetch all () [ 0 ][ 1 ]) ▁finally : ▁▁▁▁ ▁if ▁cursor ▁is ▁not ▁None : ▁▁▁▁▁▁▁▁ ▁cursor . close () ▁▁▁▁ ▁if ▁conn ▁is ▁not ▁None : ▁▁▁▁▁▁▁▁ ▁conn . close () ▁ ▁Magic ▁Direct ▁SQL ▁ ▁This ▁example ▁uses ▁Direct ▁SQL ▁from ▁Four th ▁generation ▁language ▁like ▁e Develop er , ▁un i P aa S ▁and ▁magic ▁X PA ▁from ▁Magic ▁Software ▁Enter pr ises ▁▁ ▁Virtual ▁username ▁ ▁Al pha ▁ 2 0 ▁▁ ▁init : ▁' s ister ' ▁ ▁Virtual ▁password ▁ ▁Al pha ▁ 2 0 ▁▁ ▁init : ▁' yellow ' ▁▁▁ ▁SQL ▁Command : ▁▁ ▁SELECT ▁* ▁FROM ▁users ▁WHERE ▁US ER NAME = : 1 ▁AND ▁PA SS WORD = : 2 ▁▁▁ ▁Input ▁Arg uments : ▁▁▁ 1 : ▁ ▁username ▁▁ 2 : ▁ ▁password ▁ ▁P ure Basic ▁ ▁P ure Basic ▁( since ▁v 5 . 4 0 ▁L TS ) ▁can ▁manage ▁ 7 ▁types ▁of ▁link ▁with ▁the ▁following ▁commands ▁ ▁Set Database B lob , ▁Set Database Double , ▁Set Database Float , ▁Set Database Long , ▁Set Database Null , ▁Set Database Qu ad , ▁Set Database String ▁ ▁There ▁are ▁ 2 ▁different ▁methods ▁depending ▁on ▁the ▁type ▁of ▁database ▁ ▁For ▁SQLite , ▁O DBC , ▁Maria DB / M ys ql ▁use : ▁? ▁▁▁▁▁ ▁Set Database String ( # Database ,