e dZddlZddlZddlmZmZmZejdZdZ ejjejdk(xrexrejdd d Zy) z Test QtSql.N)PYSIDE2PYSIDE_VERSIONQtSqlc#rKtjjd}||jyw)zCreate a database connectionQSQLITEN)r QSqlDatabase addDatabaseclose) connections 7/usr/lib/python3/dist-packages/qtpy/tests/test_qtsql.pydatabase_connectionr s0##// :J s57ctjJtjJtjJtjJtj Jtj JtjJtjJtjJtjJtjJtjJtjJtjJy)zTest the qtpy.QtSql namespaceN)rrQSqlDriverCreatorBase QSqlDriver QSqlError QSqlField QSqlIndex QSqlQuery QSqlRecord QSqlResultQSqlQueryModelQSqlRelationalDelegate QSqlRelationQSqlRelationalTableModelQSqlTableModelr test_qtsqlrs    )) )  & & 22 2    '' ' ?? && & ?? && & ?? && & ?? && &    '' '    '' '    ++ +  ' ' 33 3    )) )  ) ) 55 5    ++ +rwin32z5.13z7SQLite driver unavailable on PySide 5.13.2 with Windows)reasoncjtjjJtjjJtjjJ|j sJ|j dtjj|dt|jdk(sJtj}|jdsJtj}|jd|j|j}|jrJy)z Test aliased methods over qtpy.QtSql members including: * qtpy.QtSql.QSqlDatabase.exec_ * qtpy.QtSql.QSqlQuery.exec_ * qtpy.QtSql.QSqlResult.exec_ Nz test.sqlitez CREATE TABLE test ( id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL, name VARCHAR(40) NOT NULL ) zR INSERT INTO test (name) VALUES ( "TESTING" ) z$ SELECT * FROM test ) rrexec_rropensetDatabaseNamelentablespreparerecordisEmpty)r insert_table_queryselect_table_queryr)s r test_qtsql_members_aliasesr-'s     # # // / ?? ,, ,    ! ! -- -  # # %% %'' 6   "))+ , 11 1*  # #   *    & & (F~~ r)__doc__syspytestqtpyrrrfixturer rmarkskipifplatform startswithr-rrr r7s //,*LLGMM,EN,E,Ef,M D, , r