w s i K ' ' ) ) 2 24;3G3I3L M M
%'' CFA CFDr$ c t j | j j | j j j j }t || j j j j d t || j j j j d d S )Nr& r' ) r r5 r- r. r r r6 r7 r r8 r r r9 s r" test_via_col_objectz RowFetchTest.test_via_col_objectF s i K ' ' ) ) 2 24;3G3I3L M M
%'' C $&) *A... C $&+ ,d33333r$ c t j t | j j j j | j j j j d g | j j j j
}| }t |
ddg t |d d S )Nr )r' r' )r r5 r- r r. r r7 r labelr6 r r8 r keys)r: resultr; s r" test_row_with_dupe_namesz%RowFetchTest.test_row_with_dupe_namesN s "" K(*/K(*/55f==
ht{+-011
llnn FKKMMFF+,,, C r$ c | j j }t | d j j g }t |j j | d g }t j
| }t |d t j dddddd dS )ztest that a scalar select as a column is returned as such
and that type conversion works OK.
(this is half a SQLAlchemy Core test and half to catch database
backends that may have unusual behavior with scalar selects.)
x somelabelr* r+ r, r N)r. r r aliasr7 r as_scalarr rB r r5 r- r8 r r0 )r: datetabless2r; s r" test_row_w_scalar_selectz%RowFetchTest.test_row_w_scalar_select\ s K) IOOC((*01 2 2 < < > >
Y[^QWW[%9%9:
;
;i ##))++ C h /aRA F FGGGGGr$ N)__name__
__module__ __qualname__ __backend__ classmethodr# r2 r< r> r@ r %duplicate_names_in_cursor_descriptionrE rN r$ r" r r s K
[
[
4 4 4 7 87
H
H
H
H
Hr$ r c B e Zd ZdZdZdZed Zd Zd Z d Z
dS ) PercentSchemaNamesTestztests using percent signs, spaces in table and column names.
This is a very fringe use case, doesn't work for MySQL
or PostgreSQL. the requirement, "percent_schema_names",
is marked "skip" by default.
)percent_schema_namesTc t d|t dt t dt | j _ t j dt j d t j d | j _ d S )Nz
percent%tablepercent%spaces % more spaces) r
r r r.
percent_tabler tablecolumnlightweight_percent_tabler s r" r# z$PercentSchemaNamesTest.define_tablesy ss #( :w ' ' )7 3 3 $
$
03y Jz " " J- . .0
0
,,,r$ c | j j }ddddddddddddfD ]4}t j | | 5| d S Nr+ r, )rZ r[
r. r\ r r5 r- r/
_assert_table)r: r\ paramss r" test_single_roundtripz,PercentSchemaNamesTest.test_single_roundtrip s 1
B 7 7B 7 7B 7 7Q 7 7
> >F
I m 2 2 4 4f = = = = r$ c , | j j }t j | ddd t j | dddddddddg | d S ra rf )r: r\ s r" test_executemany_roundtripz1PercentSchemaNamesTest.test_executemany_roundtrip s 1
" "B$O$O
" " ;; ;; ;;
r$ c
| j j }| j j }|| || fD ]}t t t j |
|j d g d t t t j | |j d
ddg
|j d ddg t j |
|j d }t |d d t |d d t ||j d d t ||j d d t j | |j d d
i t t t j |
|j d g d d S ) NrZ ))r+ r, )rb rc rd re rc rd r[ rd re rm rn r+ r, ))r+ ro )rb ro )rd ro )rc ro )r. r\ r_ rI r listr r5 r- r r6 r7 wherein_r8 updatevalues)r: r\ r_ r] r; s r" rg z$PercentSchemaNamesTest._assert_table s 1
$(K$I!
! ! % % + + - -
! : ! :E
I%% //
0CDD
544
I%% uw'= > B BAr7 K KLL!%'*"566 '"
)## ''
(;<< egg
J # # # *+R 0 0 0 EGJ'(! , , , EG 234b 9 9 9 9 " " ) ) !78"=
!!!((**33%
3
2 1 1
r$ N) rO rP rQ __doc__ __requires__rR rS r# ri rk rg rU r$ r" rW rW l sp -LK
[
6
6
6
6
6
r$ rW c e Zd ZdZdZd Zd Zd Z ej ddd e
d dfd d e d
g dfd d e
d d fd
d e d
g d dfdd e d
g d d fdd e d
g
dfddd e
d d fdd e
d d dfdd d Zd Zd Zd Zej d Zd S ) ServerSideCursorsTest)server_side_cursorsTc P | j j j dk rt |j S | j j j dk r)t d j j }t || S | j j j dk r)t d j j }t || S dS )Npsycopg2pymysqlzpymysql.cursorsmysqldbzMySQLdb.cursorsF) enginedialectdriverboolname
__import__cursorsSSCursor
isinstance)r: cursorsscursors r" _is_server_sidez%ServerSideCursorsTest._is_server_side s ; % 3 3 $$ $
[
'9
4
4!"344<EH fh// /
[
'9
4
4!"344<EH fh// /5r$ c H t j d|i | _ | j S )Nry )options)r testing_enginer~ )r: ry s r" _fixturez ServerSideCursorsTest._fixture s. ,*,?@
{r$ c t t j | j d S N)r testing_reaper close_allr~ dispose)r: s r" tearDownz ServerSideCursorsTest.tearDown s1 ((*** r$ )
global_stringTselect 1T global_textr global_exprr& global_off_explicitF stmt_optionstream_resultsstmt_option_disabledfor_update_expr)for_update_stringTzSELECT 1 FOR UPDATET
text_no_ssz select 42text_ss_optioniaaaz*engine_ss_arg, statement, cursor_ss_status)id_argnamesc , | | }| 5 }| | }t | |j | | d d d d S # 1 swxY w Y d S r )r beginr- r r r close)r:
engine_ss_arg statementcursor_ss_statusr~ connrD s r" test_ss_cursor_statusz+ServerSideCursorsTest.test_ss_cursor_status s @ }--
\\^^ t\\),,F $$V]335E F F F LLNNN s AB B
B
c | d }| d d }| |j sJ d S )NFTr r )r connectexecution_optionsr- r r )r: r~ rD s r" test_conn_optionz&ServerSideCursorsTest.test_conn_option si u%%
NN
d
3
3
WZ
##FM2222222r$ c & | d }t dg d }| d | }| |j rJ d S )NFr& Tr )r r r r r- r r )r: r~ rL rD s r" &test_stmt_enabled_conn_option_disabledz >
NN . .e . D D L LQ O O ''
6666666r$ c | d }t dg d }| 5 }| | }| |j sJ | d d d n # 1 swxY w Y t dg| }| 5 }| | }| |j rJ | d d d d S # 1 swxY w Y d S )NFr& Tr )from_obj) r r r rI r r- r r r )r: r~ s1r rD rM s r" test_aliases_and_ssz)ServerSideCursorsTest.test_aliases_and_ss4 s u%%
QC[[
*
*$
*
?
?
E
E
G
G
\\^^ t\\"%%F''
66 6 66 LLNNN QC"
%
%
%
\\^^ t\\"%%F++FM:: : :: LLNNN s& AB22B69B6#AD66D:=D:c | j }| d t d|t dt d t dt d }| d | d | d
t |
|j j
d d g | |j j
d
k |j j dz t |
|j j
d dg | t t t) j d g | d d S )NT
test_tabler r r r )
checkfirstdata1)r data2)r& r )r r r z updated)r z
data2 updated*r )r! r r
r r r creater/ r- r r r6 r7 r fetchallrs rq rt r deleter
count select_fromscalar)r: mdr s r" test_roundtripz$ServerSideCursorsTest.test_roundtripD s
]
d 4d 3 3 3 66":: & &
T***###111###111 ( ( 9 9 A A C C L L N N
< (
!!*,/Q"677>> "Z/ ?
'))) ( ( 9 9 A A C C L L N N
/ 0
##%%% FDJsOO$ % % 1 1* = = D D F FJJJJJr$ N)rO rP rQ rv rR r r r r combinationsr r r with_for_updater r r r provide_metadatar rU r$ r" rx rx s ,LK
W1 dd: . .5 ffaSkk40 ttJ'7'7? FA3KK ) ) ) > >
# FA3KK ) ) ) ? ?
D&&!++"="="?"?F@ udd; / /7 D / /t / D D
=7 : ; : 3 3 3 7 7 7
K K K K Kr$ rx )r0 r r r
assertionsr r schemar r
r r
r r r r r r
TablesTestr rW TestBaseAssertsExecutionResultsrx rU r$ r" r s ! ! ! ! ! ! UH UH UH UH UH8& UH UH UHpk
k
k
k
k
X 0 k
k
k
\DK DK DK DK DK w6DK DK DK DK DKr$