| Search.setIndex({"docnames": ["_api/airflow/providers/mysql/hooks/index", "_api/airflow/providers/mysql/hooks/mysql/index", "_api/airflow/providers/mysql/index", "_api/airflow/providers/mysql/operators/index", "_api/airflow/providers/mysql/operators/mysql/index", "_api/airflow/providers/mysql/transfers/index", "_api/airflow/providers/mysql/transfers/presto_to_mysql/index", "_api/airflow/providers/mysql/transfers/s3_to_mysql/index", "_api/airflow/providers/mysql/transfers/trino_to_mysql/index", "_api/airflow/providers/mysql/transfers/vertica_to_mysql/index", "_api/tests/system/providers/mysql/example_mysql/index", "_api/tests/system/providers/mysql/index", "commits", "connections/mysql", "index", "installing-providers-from-sources", "operators"], "filenames": ["_api/airflow/providers/mysql/hooks/index.rst", "_api/airflow/providers/mysql/hooks/mysql/index.rst", "_api/airflow/providers/mysql/index.rst", "_api/airflow/providers/mysql/operators/index.rst", "_api/airflow/providers/mysql/operators/mysql/index.rst", "_api/airflow/providers/mysql/transfers/index.rst", "_api/airflow/providers/mysql/transfers/presto_to_mysql/index.rst", "_api/airflow/providers/mysql/transfers/s3_to_mysql/index.rst", "_api/airflow/providers/mysql/transfers/trino_to_mysql/index.rst", "_api/airflow/providers/mysql/transfers/vertica_to_mysql/index.rst", "_api/tests/system/providers/mysql/example_mysql/index.rst", "_api/tests/system/providers/mysql/index.rst", "commits.rst", "connections/mysql.rst", "index.rst", "installing-providers-from-sources.rst", "operators.rst"], "titles": ["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.hooks</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.hooks.mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.operators</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.operators.mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.presto_to_mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.s3_to_mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.trino_to_mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.vertica_to_mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.mysql.example_mysql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.mysql</span></code>", "Package apache-airflow-providers-mysql", "MySQL Connection", "<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-mysql</span></code>", "Installing from sources", "MySqlOperator"], "terms": {"3": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16], "1": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16], "0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16], "2": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16], "4": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], "dev0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], "thi": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], "an": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], "experiment": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], "featur": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16], "allow": [1, 6, 8, 9], "connect": [1, 4, 6, 7, 8, 9, 12, 14], "databas": [1, 4, 6, 8, 9, 13, 16], "mysqlconnectiontyp": 1, "sourc": [1, 4, 6, 7, 8, 9, 10, 14, 16], "mysqlhook": [1, 12], "arg": [1, 9, 12], "kwarg": [1, 4, 6, 7, 8, 9], "base": [1, 4, 6, 7, 8, 9], "common": [1, 12, 14], "sql": [1, 4, 6, 8, 9, 12, 14, 16], "dbapihook": [1, 12, 14], "interact": 1, "you": [1, 7, 13, 14, 15, 16], "can": [1, 4, 7, 13, 14, 15, 16], "specifi": [1, 7, 12, 13, 14], "charset": [1, 13], "extra": [1, 9, 13, 14], "field": [1, 12, 13, 14], "your": [1, 14, 16], "utf8": [1, 13], "also": [1, 13, 15, 16], "choos": [1, 7, 13, 15], "cursor": [1, 13], "sscursor": [1, 13], "refer": [1, 4, 6, 7, 8, 9, 12], "mysqldb": [1, 13], "more": [1, 4, 6, 8, 9, 12, 14], "detail": [1, 12, 13, 14, 15], "note": [1, 6, 8, 12, 13], "For": [1, 4, 12, 13, 14, 15], "aw": [1, 12], "iam": 1, "authent": 1, "us": [1, 4, 6, 8, 9, 10, 12, 13, 14, 15], "paramet": [1, 4, 6, 7, 8, 9, 12, 13, 14, 16], "set": [1, 13, 16], "true": [1, 4, 9, 13], "leav": 1, "password": [1, 13, 16], "empti": 1, "aws_default": [1, 7], "get": [1, 15], "temporari": [1, 15], "token": 1, "unless": 1, "overrid": 1, "exampl": [1, 10, 12, 13, 14, 15, 16], "aws_conn_id": [1, 7], "my_aws_conn": 1, "schema": [1, 13, 16], "The": [1, 7, 13, 14, 15], "id": [1, 4, 6, 7, 8, 9, 15], "credenti": [1, 7], "conn_name_attr": [1, 12, 14], "mysql_conn_id": [1, 4, 6, 7, 8, 9, 16], "default_conn_nam": 1, "mysql_default": [1, 4, 6, 7, 8, 9], "conn_typ": 1, "hook_nam": 1, "supports_autocommit": 1, "set_autocommit": 1, "self": [1, 4, 6, 7, 8, 9, 15], "conn": 1, "autocommit": [1, 4, 12, 14], "mysqlclient": [1, 13, 14], "client": [1, 12, 13], "method": [1, 4, 6, 8, 9], "rather": 1, "than": 1, "properti": 1, "bool": [1, 4, 9], "return": 1, "type": [1, 12, 13, 14], "none": [1, 4, 6, 7, 8, 9, 15], "get_autocommit": 1, "from": [1, 6, 7, 8, 9, 12, 14], "get_conn": 1, "establish": 1, "extract": 1, "configur": 1, "By": [1, 15], "default": [1, 4, 12, 13, 16], "via": [1, 14, 15], "librari": [1, 12], "But": 1, "connector": [1, 12, 13, 14], "python": [1, 12, 13, 14, 15], "which": [1, 4], "let": 1, "through": [1, 14], "ssl": [1, 13], "without": 1, "ani": [1, 15], "further": 1, "requir": [1, 9, 13], "object": 1, "bulk_load": [1, 9], "tabl": [1, 6, 7, 8, 9, 16], "tmp_file": 1, "load": [1, 6, 7, 8, 9, 13], "tab": [1, 9], "delimit": [1, 9], "file": [1, 4, 7, 9, 12, 14, 15, 16], "bulk_dump": 1, "dump": 1, "get_iam_token": 1, "awshook": 1, "retriev": 1, "port": [1, 16], "If": [1, 13, 14, 15], "3306": [1, 13], "bulk_load_custom": 1, "duplicate_key_handl": 1, "ignor": [1, 7], "extra_opt": 1, "A": [1, 12, 14], "wai": 1, "local": [1, 9, 13, 15], "data": [1, 6, 7, 8, 9, 12, 13], "accord": 1, "doc": [1, 7, 12, 13], "function": 1, "secur": 1, "risk": 1, "want": [1, 14, 15], "anywai": 1, "do": [1, 15], "so": [1, 6, 8, 16], "side": 1, "server": [1, 13, 14, 15], "option": [1, 4, 6, 7, 8, 9, 12, 13], "depend": [1, 12], "str": [1, 4, 6, 7, 8, 9], "were": 1, "name": [1, 4, 12, 13], "contain": [1, 7, 13, 15], "what": [1, 7], "should": [1, 6, 7, 8, 12, 13, 15], "happen": [1, 7], "duplic": [1, 7], "either": [1, 7], "replac": [1, 7], "http": [1, 7, 14, 15], "dev": [1, 7, 12], "com": [1, 7, 14, 15], "refman": [1, 7], "8": [1, 7, 12, 14], "en": [1, 7], "html": [1, 7], "kei": [1, 7, 13, 15], "handl": [1, 7], "exactli": [1, 7], "how": [1, 4, 7, 15], "hook": [2, 12, 14], "oper": [2, 6, 7, 8, 9, 10, 12, 14], "transfer": [2, 12], "presto_to_mysql": [2, 5], "s3_to_mysql": [2, 5], "trino_to_mysql": [2, 5], "vertica_to_mysql": [2, 5, 12, 14], "mysqloper": [4, 12, 14], "fals": [4, 9], "model": [4, 6, 7, 8, 9], "baseoper": [4, 6, 7, 8, 9], "execut": [4, 6, 7, 8, 9, 16], "code": [4, 12, 15], "specif": [4, 6, 8, 9, 12, 13], "inform": [4, 12], "take": 4, "look": 4, "guid": [4, 12, 15], "union": 4, "list": [4, 12, 14], "receiv": 4, "repres": 4, "statement": [4, 6, 8, 9], "templat": [4, 6, 8, 9, 12, 14], "ar": [4, 12, 13, 14, 15], "recogn": 4, "end": 4, "map": 4, "iter": 4, "render": [4, 6, 8, 9, 12, 14], "queri": [4, 6, 8, 9], "json": [4, 13], "each": 4, "command": [4, 9, 12, 16], "automat": [4, 14], "commit": [4, 12], "valu": 4, "overwrit": 4, "defin": [4, 13], "one": [4, 13, 15], "template_field": [4, 6, 7, 8, 9, 12], "sequenc": [4, 6, 7, 8, 9, 12], "template_fields_render": [4, 6, 8, 9, 12, 14], "template_ext": [4, 6, 7, 8, 9], "ui_color": [4, 6, 7, 8, 9], "eded": 4, "prepare_templ": 4, "pars": [4, 12, 14], "attribut": 4, "context": [4, 6, 7, 8, 9, 12], "main": [4, 6, 8, 9, 14, 15], "deriv": [4, 6, 8, 9], "when": [4, 6, 7, 8, 9, 13, 14], "creat": [4, 6, 8, 9, 15], "same": [4, 6, 8, 9, 16], "dictionari": [4, 6, 8, 9, 13], "jinja": [4, 6, 8, 9], "get_template_context": [4, 6, 8, 9], "prestotomysqloper": 6, "mysql_tabl": [6, 7, 8, 9], "presto_conn_id": 6, "presto_default": 6, "mysql_preoper": [6, 8, 9], "move": [6, 8, 9, 12, 14], "presto": [6, 14], "now": [6, 8, 12], "memori": [6, 8, 12, 14], "befor": [6, 8, 12], "being": [6, 7, 8], "push": [6, 8], "smallish": [6, 8], "amount": [6, 8], "against": [6, 8, 9], "target": [6, 8, 9], "dot": [6, 8, 9], "notat": [6, 8, 9, 13], "run": [6, 8, 9, 14, 15], "prior": [6, 8, 9], "import": [6, 8, 9, 12, 14, 15], "typic": [6, 8, 9], "truncat": [6, 8, 9], "delet": [6, 8, 9], "place": [6, 8, 9], "come": [6, 8, 9, 12], "task": [6, 8, 9], "idempot": [6, 8, 9], "twice": [6, 8, 9], "won": [6, 8, 9], "t": [6, 8, 9], "doubl": [6, 8, 9, 12], "a0e08c": [6, 8, 9], "s3tomysqloper": 7, "s3_source_kei": 7, "mysql_duplicate_key_handl": 7, "mysql_extra_opt": 7, "s3": [7, 12], "path": 7, "where": [7, 13, 16], "sent": 7, "bucket": 7, "f4a460": 7, "util": 7, "trinotomysqloper": 8, "trino_conn_id": 8, "trino_default": 8, "trino": [8, 12, 14], "mysql_render": 9, "verticatomysqloper": 9, "vertica_conn_id": 9, "vertica_default": 9, "mysql_postoper": 9, "vertica": [9, 14], "after": [9, 12], "stage": 9, "product": 9, "issu": 9, "cleanup": [9, 12], "flag": 9, "directli": 9, "text": 9, "infil": [9, 13], "destin": 9, "local_infil": [9, 13], "relat": 10, "env_id": 10, "dag_id": 10, "drop_table_mysql_task": [10, 16], "test_run": 10, "example_mysql": [11, 16], "chang": 12, "version": [12, 14, 15], "high": 12, "level": [12, 16], "changelog": 12, "see": [12, 13, 14], "includ": 12, "latest": 12, "2022": 12, "07": 12, "subject": 12, "46bbfdade0": 12, "all": [12, 13, 14], "class": [12, 13, 14], "24836": [12, 14], "0de31bd73a": 12, "06": 12, "29": 12, "insid": 12, "folder": [12, 15, 16], "24672": 12, "510a6bab45": 12, "28": 12, "remov": [12, 14, 15], "yaml": 12, "24702": 12, "55b16444ad": 12, "20": 12, "close": [12, 14], "onc": [12, 14, 15], "done": [12, 14], "24508": [12, 14], "09": 12, "dcdcf3a2b8": 12, "updat": [12, 14], "releas": [12, 14], "rc2": 12, "mai": 12, "24307": 12, "717a7588bc": 12, "descript": 12, "min": 12, "24292": 12, "aeabe994b3": 12, "prepar": 12, "s": [12, 13, 15], "24231": 12, "027b707d21": 12, "05": 12, "add": [12, 14], "explanatori": 12, "contributor": 12, "about": [12, 15], "24229": 12, "3df8ff7407": 12, "03": 12, "migrat": [12, 14], "dag": [12, 14, 16], "new": [12, 14], "design": 12, "22453": 12, "24142": 12, "22": [12, 13], "d7dbfb7e26": 12, "document": [12, 14], "bugfix": 12, "22383": 12, "14": 12, "16adc035b1": 12, "classifi": [12, 14], "march": 12, "22226": 12, "f5b96315fe": 12, "feb": 12, "22056": 12, "59c450ee54": 12, "02": 12, "25": 12, "make": [12, 14], "get_uri": [12, 14], "21764": [12, 14], "68da4d84ef": 12, "19": 12, "21434": [12, 14], "08": 12, "d94fa37830": 12, "fix": 12, "januari": 12, "delai": 12, "21439": 12, "8f81b9a01c": 12, "condit": [12, 14], "check": [12, 13, 14, 15], "lexer": [12, 14], "21403": [12, 14], "6c3a67d4fc": 12, "2021": [12, 15], "21257": 12, "39e395f981": 12, "04": 12, "21237": [12, 14], "602abe8394": 12, "01": 12, "line": 12, "sphinx": 12, "autoapi": 12, "support": [12, 13, 14], "typehint": 12, "20951": 12, "919ff4567d": 12, "refactor": [12, 14], "mypi": [12, 14], "friendli": [12, 14], "20618": [12, 14], "f77417eb0d": 12, "12": [12, 14, 15], "31": 12, "k8": 12, "pypi": [12, 14], "compat": 12, "20614": 12, "97496ba2b4": 12, "decemb": 12, "20523": 12, "83f8e178ba": 12, "even": 12, "ext": 12, "20608": 12, "d56e7b56bb": 12, "30": 12, "have": [12, 14], "20571": 12, "a0821235fb": 12, "everywher": 12, "20565": 12, "853576d901": 12, "11": [12, 14, 15], "novemb": 12, "19882": 12, "d9567eb106": 12, "10": [12, 14], "octob": 12, "19321": 12, "86a2a19ad2": 12, "17": 12, "f": 12, "string": [12, 13, 16], "18855": 12, "840ea3efb9": 12, "septemb": 12, "18613": 12, "ef037e7021": 12, "static": 12, "start_dat": 12, "misc": 12, "18597": 12, "0a68588479": 12, "august": 12, "17890": 12, "be75dcd39c": 12, "23": 12, "meta": 12, "76ed2a49c6": 12, "lazili": 12, "individu": 12, "manag": [12, 15], "17682": 12, "4dae4ec9a4": 12, "annot": 12, "17388": 12, "26": 12, "87f408b1e7": 12, "juli": 12, "17116": 12, "0dbd0f420c": 12, "default_arg": 12, "pattern": 12, "miscellan": 12, "16872": 12, "a1d3b271": 12, "17080": [12, 14], "d02ded65ea": 12, "15": 12, "wrongli": 12, "escap": 12, "charact": 12, "amazon": [12, 14], "17020": 12, "b916b75079": 12, "17015": 12, "6ab00bfcfd": 12, "extend": [12, 14], "16987": [12, 14], "c3b8212b6e": 12, "ad": [12, 14], "16914": [12, 14], "866a601b76": 12, "pylint": 12, "our": 12, "toolchain": 12, "16682": 12, "18": 12, "bbc627a3da": 12, "16501": 12, "cbf8001d76": 12, "16": 12, "synchron": 12, "buggfix": 12, "16464": 12, "1fba5402bb": 12, "june": 12, "16405": 12, "9c94b72d44": 12, "16294": 12, "37681bca00": 12, "auto": [12, 14], "appli": [12, 14], "apply_default": [12, 14], "decor": [12, 14], "15667": [12, 14], "807ad32ce5": 12, "pip": [12, 14, 15], "21": 12, "15576": 12, "bf2b48174a": 12, "27": 12, "15499": 12, "4b031d39e1": 12, "15534": 12, "71c673e427": 12, "docstr": 12, "modul": 12, "miss": 12, "param": 12, "15391": 12, "042be2e4e0": 12, "april": 12, "15236": 12, "eae22cec9c": 12, "lower": [12, 14], "footprint": [12, 14], "test": [12, 14, 16], "15187": [12, 14], "9b76b94c94": 12, "bunch": [12, 14], "addit": [12, 14], "15130": [12, 14], "9b428bbbdf": 12, "call": [12, 14], "14869": [12, 14], "68e4c4dcb0": 12, "backport": 12, "14886": 12, "589d6dec92": 12, "next": 12, "wave": 12, "14487": 12, "cdc20904a5": 12, "respect": [12, 14], "14240": [12, 14], "10343ec29f": 12, "correct": [12, 15], "tool": 12, "rc": 12, "14082": 12, "88bdcfa0df": 12, "14013": 12, "ac2f72c98d": 12, "implement": 12, "13767": 12, "a9ac2b040b": 12, "switch": 12, "flynt": 12, "13732": 12, "3fd5ef3555": 12, "logo": 12, "integr": 12, "13717": 12, "295d66f914": 12, "2020": 12, "grammar": 12, "warn": [12, 15], "13380": 12, "0d214575a1": 12, "setup": 12, "py": [12, 16], "better": 12, "reflect": 12, "13314": 12, "6cf76d7ac0": 12, "typo": 12, "upgrad": [12, 14], "13148": 12, "6bf9acb90f": 12, "core": 12, "13060": 12, "32971a1a2d": 12, "12955": 12, "b40dffa085": 12, "renam": 12, "rema": 12, "match": [12, 13, 15], "aip": 12, "12917": 12, "9b39f24780": 12, "dynam": 12, "form": 12, "per": 12, "12558": 12, "bd90136aaf": 12, "12681": 12, "2037303eef": 12, "discoveri": 12, "12466": 12, "c34ef853c8": 12, "separ": 12, "out": 12, "build": [12, 15], "12444": 12, "0080354502": 12, "readm": [12, 14], "0b2": 12, "batch": 12, "12449": 12, "ae7cb4a1e2": 12, "wrong": 12, "hash": 12, "12390": 12, "6889a333cf": 12, "improv": 12, "ref": 12, "12366": 12, "7825e8f590": 12, "13": 12, "instal": 12, "12304": 12, "85a18e13d9": 12, "point": 12, "project": 12, "page": [12, 15], "cross": 12, "12212": 12, "59eb5de78c": 12, "up": 12, "0beta1": 12, "12206": 12, "b2a28d1590": 12, "script": [12, 15, 16], "12082": 12, "75f229601e": 12, "howto": 12, "12077": 12, "41bf172c1d": 12, "simplifi": 12, "express": 12, "12093": 12, "4e8f9cc8d0": 12, "enabl": [12, 13], "black": 12, "formmatt": 12, "9550": 12, "8c42cf1b00": 12, "pyupgrad": 12, "6": [12, 14], "11447": 12, "5a439e84eb": 12, "2a1": 12, "11855": 12, "872b1566a1": 12, "gener": 12, "11826": 12, "349b0811c3": 12, "d200": 12, "pydocstyl": 12, "11688": 12, "16e7129719": 12, "11487": 12, "0a0e1af800": 12, "broken": 12, "markdown": 12, "link": [12, 15], "toc": 12, "11249": 12, "ca4238eb4d": 12, "month": 12, "11242": 12, "5220e4c384": 12, "11238": 12, "f3e87c5030": 12, "d202": 12, "11032": 12, "fdd9b6f65b": 12, "10543": 12, "d1bce91bb2": 12, "d403": 12, "capit": 12, "first": [12, 14], "word": 12, "10530": 12, "3696c34c28": 12, "24": 12, "10528": 12, "ee7ca128a1": 12, "refernc": 12, "10483": 12, "01f37967c9": 12, "coverag": 12, "10095": 12, "cdec301254": 12, "signatur": [12, 14, 15], "sensor": 12, "10205": 12, "24c8e4c2d6": 12, "constructor": 12, "argument": [12, 16], "10163": 12, "aeea71274d": 12, "10097": 12, "d0e7db4024": 12, "number": 12, "fresh": 12, "9408": 12, "12af6a0800": 12, "final": 12, "23rc1": 12, "9404": 12, "c7e5bce57f": 12, "candid": 12, "9370": 12, "f6bd817a3a": 12, "introduc": 12, "9320": 12, "0b0e4f7a4c": 12, "rc3": 12, "relas": 12, "9026": 12, "00642a46d0": 12, "remain": 12, "8994": 12, "1d36b0303b": 12, "8984": 12, "375d1ca229": 12, "8898": 12, "12c5e5d8a": 12, "8891": 12, "f3521fb0e3": 12, "regener": 12, "8886": 12, "92585ca4cb": 12, "autom": 12, "8807": 12, "68d1714f29": 12, "6822": 12, "cach": 12, "boto3": 12, "7541": 12, "329e6a5f72": 12, "5907": 12, "6578": 12, "4bde99f132": 12, "7802": 12, "b39468d287": 12, "5922": 12, "6576": 12, "9cbd7de6d1": 12, "6792": 12, "_oper": 12, "_hook": 12, "_sensor": 12, "7412": 12, "94fccca970": 12, "xxxx": 12, "pre": 12, "utf": 12, "encod": [12, 13], "7347": 12, "97a429f9d0": 12, "6714": 12, "magic": 12, "comment": 12, "7338": 12, "1e576f1234": 12, "6680": 12, "last": 12, "7301": 12, "057f3ae3a4": 12, "6670": 12, "6669": 12, "contrib": 12, "7286": 12, "82c0e5aff6": 12, "6655": 12, "7271": 12, "eee34ee808": 12, "4204": 12, "super": 12, "7248": 12, "059eda05f8": 12, "6610": 12, "softwar": [12, 15], "7231": 12, "provid": [13, 15, 16], "host": [13, 16], "login": [13, 16], "user": [13, 15, 16], "follow": [13, 15, 16], "dictcursor": 13, "ssdictcursor": 13, "control": 13, "capabl": 13, "permit": 13, "unix_socket": 13, "unix": 13, "socket": 13, "instead": 13, "those": [13, 14, 15], "ca": 13, "cert": 13, "capath": 13, "cipher": 13, "url": 13, "might": [13, 14], "var": 13, "tmp": 13, "pem": 13, "uri": 13, "airflow_conn_": 13, "conn_id": 13, "variabl": 13, "standard": 13, "syntax": 13, "db": [13, 14], "pass": [13, 16], "compon": 13, "export": 13, "airflow_conn_mysql_default": 13, "mysql_us": 13, "xxxxxxxxxxxx": 13, "7b": 13, "22cert": 13, "3a": 13, "2ftmp": 13, "2fclient": 13, "2c": 13, "22ca": 13, "2fserver": 13, "22kei": 13, "7d": 13, "encount": 13, "unicodedecodeerror": 13, "while": 13, "work": 13, "allow_local_infil": 13, "whether": 13, "api": 14, "repositori": 14, "top": [14, 15], "exist": 14, "below": [14, 15], "minimum": 14, "platform_machin": 14, "aarch64": 14, "need": 14, "order": 14, "them": 14, "verifi": 14, "checksum": [14, 15], "site": 14, "sdist": [14, 15], "asc": [14, 15], "sha512": [14, 15], "wheel": 14, "ha": 14, "5": 14, "exact": 14, "upper": 14, "bound": 14, "onli": 14, "7": 14, "avail": [14, 15], "explain": 14, "polici": 14, "github": 14, "blob": 14, "md": 14, "mistakenli": 14, "install_requir": 14, "22382": 14, "trove": 14, "framework": 14, "optimis": 14, "due": 14, "least": 14, "otherwis": 14, "manual": 14, "complet": 14, "initi": 14, "describ": 15, "download": 15, "apach": 15, "airflow": 15, "mysql": 15, "offici": 15, "most": 15, "differ": 15, "select": 15, "drop": [15, 16], "down": 15, "left": 15, "whl": 15, "origin": 15, "foundat": 15, "abov": 15, "pgp": 15, "It": 15, "essenti": 15, "sha": 15, "gpg": 15, "pleas": 15, "well": 15, "relev": 15, "distribut": 15, "recommend": 15, "directori": 15, "mirror": 15, "i": 15, "pgpk": 15, "ka": 15, "To": 15, "binari": 15, "pgpv": 15, "tar": 15, "gz": 15, "made": 15, "sat": 15, "sep": 15, "49": 15, "54": 15, "bst": 15, "rsa": 15, "cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f": 15, "issuer": 15, "kaxilnaik": 15, "org": 15, "good": 15, "kaxil": 15, "naik": 15, "unknown": 15, "aka": 15, "gmail": 15, "certifi": 15, "trust": 15, "There": 15, "indic": 15, "belong": 15, "owner": 15, "primari": 15, "fingerprint": 15, "cde1": 15, "5c6e": 15, "4d3a": 15, "8ec4": 15, "ecf4": 15, "ba4b": 15, "6674": 15, "e08a": 15, "d7de": 15, "406f": 15, "worri": 15, "certif": 15, "sign": 15, "why": 15, "previou": 15, "step": 15, "know": 15, "valid": 15, "alreadi": [15, 16], "sum": 15, "shasum": 15, "512": 15, "diff": 15, "bin": 15, "bash": 15, "package_vers": 15, "package_nam": 15, "provider_download_dir": 15, "mktemp": 15, "d": 15, "dep": 15, "dest": 15, "curl": 15, "apache_airflow_providers_mysql": 15, "py3": 15, "l": 15, "o": 15, "echo": 15, "ls": 15, "la": 15, "instruct": 15, "chapter": 15, "instanc": 16, "structur": 16, "input": 16, "hostnam": 16, "int": 16, "usag": 16, "system": 16, "task_id": 16, "drop_table_mysql": 16, "r": 16, "table_nam": 16, "extern": 16, "must": 16, "mysql_task": 16, "drop_table_mysql_external_fil": 16, "drop_tabl": 16, "onto": 16, "given": 16, "prioriti": 16, "over": 16, "forth": 16}, "objects": {"airflow.providers": [[2, 0, 0, "-", "mysql"]], "airflow.providers.mysql": [[0, 0, 0, "-", "hooks"], [3, 0, 0, "-", "operators"], [5, 0, 0, "-", "transfers"]], "airflow.providers.mysql.hooks": [[1, 0, 0, "-", "mysql"]], "airflow.providers.mysql.hooks.mysql": [[1, 1, 1, "", "MySQLConnectionTypes"], [1, 2, 1, "", "MySqlHook"]], "airflow.providers.mysql.hooks.mysql.MySqlHook": [[1, 3, 1, "", "bulk_dump"], [1, 3, 1, "", "bulk_load"], [1, 3, 1, "", "bulk_load_custom"], [1, 4, 1, "", "conn_name_attr"], [1, 4, 1, "", "conn_type"], [1, 4, 1, "", "default_conn_name"], [1, 3, 1, "", "get_autocommit"], [1, 3, 1, "", "get_conn"], [1, 3, 1, "", "get_iam_token"], [1, 4, 1, "", "hook_name"], [1, 3, 1, "", "set_autocommit"], [1, 4, 1, "", "supports_autocommit"]], "airflow.providers.mysql.operators": [[4, 0, 0, "-", "mysql"]], "airflow.providers.mysql.operators.mysql": [[4, 2, 1, "", "MySqlOperator"]], "airflow.providers.mysql.operators.mysql.MySqlOperator": [[4, 3, 1, "", "execute"], [4, 3, 1, "", "prepare_template"], [4, 4, 1, "", "template_ext"], [4, 4, 1, "", "template_fields"], [4, 4, 1, "", "template_fields_renderers"], [4, 4, 1, "", "ui_color"]], "airflow.providers.mysql.transfers": [[6, 0, 0, "-", "presto_to_mysql"], [7, 0, 0, "-", "s3_to_mysql"], [8, 0, 0, "-", "trino_to_mysql"], [9, 0, 0, "-", "vertica_to_mysql"]], "airflow.providers.mysql.transfers.presto_to_mysql": [[6, 2, 1, "", "PrestoToMySqlOperator"]], "airflow.providers.mysql.transfers.presto_to_mysql.PrestoToMySqlOperator": [[6, 3, 1, "", "execute"], [6, 4, 1, "", "template_ext"], [6, 4, 1, "", "template_fields"], [6, 4, 1, "", "template_fields_renderers"], [6, 4, 1, "", "ui_color"]], "airflow.providers.mysql.transfers.s3_to_mysql": [[7, 2, 1, "", "S3ToMySqlOperator"]], "airflow.providers.mysql.transfers.s3_to_mysql.S3ToMySqlOperator": [[7, 3, 1, "", "execute"], [7, 4, 1, "", "template_ext"], [7, 4, 1, "", "template_fields"], [7, 4, 1, "", "ui_color"]], "airflow.providers.mysql.transfers.trino_to_mysql": [[8, 2, 1, "", "TrinoToMySqlOperator"]], "airflow.providers.mysql.transfers.trino_to_mysql.TrinoToMySqlOperator": [[8, 3, 1, "", "execute"], [8, 4, 1, "", "template_ext"], [8, 4, 1, "", "template_fields"], [8, 4, 1, "", "template_fields_renderers"], [8, 4, 1, "", "ui_color"]], "airflow.providers.mysql.transfers.vertica_to_mysql": [[9, 1, 1, "", "MYSQL_RENDERER"], [9, 2, 1, "", "VerticaToMySqlOperator"]], "airflow.providers.mysql.transfers.vertica_to_mysql.VerticaToMySqlOperator": [[9, 3, 1, "", "execute"], [9, 4, 1, "", "template_ext"], [9, 4, 1, "", "template_fields"], [9, 4, 1, "", "template_fields_renderers"], [9, 4, 1, "", "ui_color"]], "tests.system.providers": [[11, 0, 0, "-", "mysql"]], "tests.system.providers.mysql": [[10, 0, 0, "-", "example_mysql"]], "tests.system.providers.mysql.example_mysql": [[10, 1, 1, "", "DAG_ID"], [10, 1, 1, "", "ENV_ID"], [10, 1, 1, "", "drop_table_mysql_task"], [10, 1, 1, "", "test_run"]]}, "objtypes": {"0": "py:module", "1": "py:data", "2": "py:class", "3": "py:method", "4": "py:attribute"}, "objnames": {"0": ["py", "module", "Python module"], "1": ["py", "data", "Python data"], "2": ["py", "class", "Python class"], "3": ["py", "method", "Python method"], "4": ["py", "attribute", "Python attribute"]}, "titleterms": {"airflow": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 14, 16], "provid": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14], "mysql": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16], "hook": [0, 1], "submodul": [0, 3, 5, 11], "modul": [1, 4, 6, 7, 8, 9, 10], "content": [1, 4, 6, 7, 8, 9, 10, 14], "class": [1, 4, 6, 7, 8, 9], "attribut": [1, 9], "subpackag": 2, "oper": [3, 4, 16], "transfer": [5, 6, 7, 8, 9], "presto_to_mysql": 6, "s3_to_mysql": 7, "trino_to_mysql": 8, "vertica_to_mysql": 9, "test": [10, 11], "system": [10, 11], "example_mysql": 10, "packag": [12, 14, 15], "apach": [12, 14], "3": [12, 14], "1": [12, 14], "0": [12, 14], "2": [12, 14], "connect": [13, 16], "configur": 13, "guid": 14, "refer": 14, "resourc": 14, "commit": 14, "instal": [14, 15], "requir": 14, "cross": 14, "depend": 14, "download": 14, "offici": 14, "changelog": 14, "featur": 14, "bug": 14, "fix": 14, "break": 14, "chang": 14, "misc": 14, "from": 15, "sourc": 15, "releas": 15, "integr": 15, "verifi": 15, "pypi": 15, "mysqloper": 16, "us": 16, "metadata": 16}, "envversion": {"sphinx.domains.c": 2, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 6, "sphinx.domains.index": 1, "sphinx.domains.javascript": 2, "sphinx.domains.math": 2, "sphinx.domains.python": 3, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx.ext.viewcode": 1, "sphinx.ext.intersphinx": 1, "sphinx": 56}}) |