li(ddlmZddlmZ ddZy))utils)RowNc |r |r td||}g}t|d} tj|} |(t t t |j} n| r |jD cgc] } ||  } } n`| rA|D cgc]} |j| }} t|Dcgc]}|jc}} n|j|j} t|d}tj|}|(t t t |j}n|r |jD cgc] } ||  }} n|rs|D cgc]} |j| }} t|Dcgc]}|jc}}|D cgc]'} |jjj| )}} n;|j|}|j}|jj|g}t|j}t|j}t!|jD]p\}}|j"}|s|||vr|||vr"||j$vr|j'd|zn|j'||j'|j(r|0|s.|j+|jDcgc] }||vs| c}}i}t!|D]/\}}||vrg||<||j'|j|1g}|j,|sg}nd}t!| D]_\}}|j/|d} |r| td|z| r| D]}!t|j|}"t!|!D]\}#}$||#|vr|s|"j'|$!|j't1|"||j,p|rs|j'|j,||rt|j|}"t!|jD]\}#}$||#|vr|s|"j'd!|j't1|"||j,>|rB|j'|j,|b|rpt3| }%t!|D]W\}&}'|'|%vr dgt |jzt|j4|&z}"|j't1|"|Y|j7||||Scc} wcc} wcc}wcc} wcc} wcc}wcc} wcc}w)aq Create a new table by joining two table's on common values. This method implements most varieties of SQL join, in addition to some unique features. If :code:`left_key` and :code:`right_key` are both :code:`None` then this method will perform a "sequential join", which is to say it will join on row number. The :code:`inner` and :code:`full_outer` arguments will determine whether dangling left-hand and right-hand rows are included, respectively. If :code:`left_key` is specified, then a "left outer join" will be performed. This will combine columns from the :code:`right_table` anywhere that :code:`left_key` and :code:`right_key` are equal. Unmatched rows from the left table will be included with the right-hand columns set to :code:`None`. If :code:`inner` is :code:`True` then an "inner join" will be performed. Unmatched rows from either table will be left out. If :code:`full_outer` is :code:`True` then a "full outer join" will be performed. Unmatched rows from both tables will be included, with the columns in the other table set to :code:`None`. In all cases, if :code:`right_key` is :code:`None` then it :code:`left_key` will be used for both tables. If :code:`left_key` and :code:`right_key` are column names, the right-hand identifier column will not be included in the output table. If :code:`require_match` is :code:`True` unmatched rows will raise an exception. This is like an "inner join" except any row that doesn't have a match will raise an exception instead of being dropped. This is useful for enforcing expectations about datasets that should match. Column names from the right table which also exist in this table will be suffixed "2" in the new table. A subset of columns from the right-hand table can be included in the joined table using the :code:`columns` argument. :param right_table: The "right" table to join to. :param left_key: Either the name of a column from the this table to join on, the index of a column, a sequence of such column identifiers, a :class:`function` that takes a row and returns a value to join on, or :code:`None` in which case the tables will be joined on row number. :param right_key: Either the name of a column from :code:table` to join on, the index of a column, a sequence of such column identifiers, or a :class:`function` that takes a ow and returns a value to join on. If :code:`None` then :code:`left_key` will be used for both. If :code:`left_key` is :code:`None` then this value is ignored. :param inner: Perform a SQL-style "inner join" instead of a left outer join. Rows which have no match for :code:`left_key` will not be included in the output table. :param full_outer: Perform a SQL-style "full outer" join rather than a left or a right. May not be used in combination with :code:`inner`. :param require_match: If true, an exception will be raised if there is a left_key with no matching right_key. :param columns: A sequence of column names from :code:`right_table` to include in the final output table. Defaults to all columns not in :code:`right_key`. Ignored when :code:`full_outer` is :code:`True`. :returns: A new :class:`.Table`. z0A join can not be both "inner" and "full_outer".N__call__z%s2z1Left key "%s" does not have a matching right key.) row_names) ValueErrorhasattrr issequencetuplerangelen_rows_columnszipvalues_keysindexlist _column_names _column_types enumeratename column_namesappend data_typeselect _row_namesgetrsetrows_fork)(self right_tableleft_key right_keyinner full_outer require_matchcolumnsright_key_indicesleft_key_is_funcleft_key_is_sequence left_datarowkey left_columnscolumnright_key_is_funcright_key_is_sequence right_data right_columns right_columnr column_typesirn right_hashvaluer r left_index left_value matching_rows right_rownew_rowkvleft_set right_index right_values( U/var/www/html/strategist-ai/venv_dbt/lib/python3.12/site-packages/agate/table/join.pyjoinrGs=N KLL x4 ++H5%DJJ01 .2jj9sXc]9 9 6>?s c*? ? Ef&--/EF MM(+224  :6!,,Y75[%6%6!789 0;0A0ABinB B >GHs--c2H HGv6==?GH NWXs[1177==cBXX#++I6 !((* (1177 EF**+L**+L{334. 6{{1(9#9"t7': 4$$ $    -    %F,,-.":!(([5N5N)_RSW^R^!)_` Jj)75  " "Ju 5  !2!21!56 7 D ":  #,I"6"> J"z48 ]2PS]]^ ^ * B tzz*56%i0&DAq10A+A* NN1% &  C67??.z$$T__Z%@A B4::j12G!+";";< %1?q,='=jt$  % KKG\2 3*:  !<=E">Jy>(1*(= 4 $Kh&vDMM 22d;;K;KK;X6YYG KKG\2 3  4 ::dL,): LLm:@ECIGX:*`s61T- T2*T7>T<U7U,U  UU)NNFFFN)agater agate.rowsrrGrFrLsinNMrK