7f1e47e6.0077838b.js

(window.webpackJsonp=window.webpackJsonp||[]).push([[72],{147:function(e,t,n){"use strict";n.r(t),n.d(t,"frontMatter",(function(){return s})),n.d(t,"metadata",(function(){return c})),n.d(t,"rightToc",(function(){return d})),n.d(t,"default",(function(){return u}));var a=n(3),i=n(7),o=(n(0),n(216)),r=n(219),s={id:"actions-database",title:"Database actions"},c={unversionedId:"actions-database",id:"actions-database",isDocsHomePage:!1,title:"Database actions",description:"- Drivers: pyodbc(ODBC)",source:"@site/docs\\actions-database.md",slug:"/actions-database",permalink:"/docs/actions-database",version:"current",sidebar:"docs",previous:{title:"Performance Actions",permalink:"/docs/actions-performance"},next:{title:"Mac actions",permalink:"/docs/actions-mac"}},d=[{value:"Examples of Database actions",id:"examples-of-database-actions",children:[{value:"1. Connect to DB",id:"1-connect-to-db",children:[]},{value:"2. Delete from db",id:"2-delete-from-db",children:[]},{value:"3. Insert into db",id:"3-insert-into-db",children:[]},{value:"4. Run Insert Update or Delete Query",id:"4-run-insert-update-or-delete-query",children:[]},{value:"5. Run Select Query",id:"5-run-select-query",children:[]},{value:"6. Select from db",id:"6-select-from-db",children:[]},{value:"7. Update into db",id:"7-update-into-db",children:[]},{value:"8. Connect to Mongodb",id:"8-connect-to-mongodb",children:[]},{value:"9. Delete many into Mongodb",id:"9-delete-many-into-mongodb",children:[]},{value:"10. Delete one into Mongodb",id:"10-delete-one-into-mongodb",children:[]},{value:"11. Find from Mongodb",id:"11-find-from-mongodb",children:[]},{value:"12. Find one from Mongodb",id:"12-find-one-from-mongodb",children:[]},{value:"13. Insert many into Mongodb",id:"13-insert-many-into-mongodb",children:[]},{value:"14. Insert one into Mongodb",id:"14-insert-one-into-mongodb",children:[]},{value:"15. Update many into Mongodb",id:"15-update-many-into-mongodb",children:[]},{value:"16. Update one into Mongodb",id:"16-update-one-into-mongodb",children:[]}]}],l={rightToc:d};function u(e){var t=e.components,n=Object(i.a)(e,["components"]);return Object(o.b)("wrapper",Object(a.a)({},l,n,{components:t,mdxType:"MDXLayout"}),Object(o.b)("div",{className:"admonition admonition-tip alert alert--success"},Object(o.b)("div",Object(a.a)({parentName:"div"},{className:"admonition-heading"}),Object(o.b)("h5",{parentName:"div"},Object(o.b)("span",Object(a.a)({parentName:"h5"},{className:"admonition-icon"}),Object(o.b)("svg",Object(a.a)({parentName:"span"},{xmlns:"http://www.w3.org/2000/svg",width:"12",height:"16",viewBox:"0 0 12 16"}),Object(o.b)("path",Object(a.a)({parentName:"svg"},{fillRule:"evenodd",d:"M6.5 0C3.48 0 1 2.19 1 5c0 .92.55 2.25 1 3 1.34 2.25 1.78 2.78 2 4v1h5v-1c.22-1.22.66-1.75 2-4 .45-.75 1-2.08 1-3 0-2.81-2.48-5-5.5-5zm3.64 7.48c-.25.44-.47.8-.67 1.11-.86 1.41-1.25 2.06-1.45 3.23-.02.05-.02.11-.02.17H5c0-.06 0-.13-.02-.17-.2-1.17-.59-1.83-1.45-3.23-.2-.31-.42-.67-.67-1.11C2.44 6.78 2 5.65 2 5c0-2.2 2.02-4 4.5-4 1.22 0 2.36.42 3.22 1.19C10.55 2.94 11 3.94 11 5c0 .66-.44 1.78-.86 2.48zM4 14h5c-.23 1.14-1.3 2-2.5 2s-2.27-.86-2.5-2z"})))),"tip")),Object(o.b)("div",Object(a.a)({parentName:"div"},{className:"admonition-content"}),Object(o.b)("ul",{parentName:"div"},Object(o.b)("li",{parentName:"ul"},Object(o.b)("strong",{parentName:"li"},"Drivers"),": pyodbc(ODBC)")))),Object(o.b)("p",null,"These actions help you automate database systems easily and combine them with other categories of actions like ",Object(o.b)(r.a,{to:"/docs/actions-rest-api",mdxType:"Link"},"REST/API")," to validate data. You can compare and test between different database systems across multiple remote locations. "),Object(o.b)("h2",{id:"examples-of-database-actions"},"Examples of Database actions"),Object(o.b)("h3",{id:"1-connect-to-db"},"1. Connect to DB"),Object(o.b)("p",null,"Defining a connection to a database is a preparatory step in systems like ",Object(o.b)("strong",{parentName:"p"},"Lorust")," that sets up the necessary configuration for subsequent database operations. This action does not establish an immediate connection to the database but instead stores essential connection details, such as the database type, host, port, username, password, and database name. These details are referenced later to simplify and streamline database interactions, avoiding the need to redefine the connection repeatedly. The actual connection to the database occurs only when a specific operation, such as querying or updating data, is performed, reducing unnecessary overhead during initialization. By seperating the configuration step from the connection itself, this approach ensures efficient resource usage and supports flexibility in managing database interactions."),Object(o.b)("h3",{id:"2-delete-from-db"},"2. Delete from db"),Object(o.b)("p",null,"Performing an arbitrary delete query involves executing a custom SQL ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE")," operation to remove records from a database based on specific criteria and storing the result, typically the number of rows affected, in a variable. This stored result can be used for validation, logging, or subsequent operations. For example, a query like ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE FROM users WHERE status = 'inactive'")," might delete 10 rows, with the result captured in a variable for further use. This approach is useful for dynamic scenarios where deletion criteria are determined at runtime."),Object(o.b)("h3",{id:"3-insert-into-db"},"3. Insert into db"),Object(o.b)("p",null,"Performing an insert query to store values in a table and capturing its result in a variable involves executing an SQL ",Object(o.b)("inlineCode",{parentName:"p"},"INSERT")," operation to add new records to a database table and storing the outcome, such as the number of rows inserted or an auto-generated identifier. The user specifies an ",Object(o.b)("inlineCode",{parentName:"p"},"INSERT")," query, like `INSERT INTO users (name, email) VALUES ('John Doe', '",Object(o.b)("a",Object(a.a)({parentName:"p"},{href:"mailto:john@example.com"}),"john@example.com"),"'), which is executed against the database to add the specified values. The result of this operation is stored in a variable for further use, such as confirming the success of the insertion, referencing the inserted record, or triggering additional actions. This approach ensures the insertion process is efficient and its outcome is readily available for validation or subsequent logic."),Object(o.b)("h3",{id:"4-run-insert-update-or-delete-query"},"4. Run Insert Update or Delete Query"),Object(o.b)("p",null,"The ",Object(o.b)("strong",{parentName:"p"},"insert, update, and delete query action"),' "non-query" operations on a database, such as ',Object(o.b)("inlineCode",{parentName:"p"},"INSERT"),", ",Object(o.b)("inlineCode",{parentName:"p"},"UPDATE"),", and ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE"),", which modify the database state without returning rows of data. Instead, they provide a result indicating the number of rows affected, which can be stored in a variable for validation or further processing. For example, an ",Object(o.b)("inlineCode",{parentName:"p"},"INSERT")," query might return ",Object(o.b)("inlineCode",{parentName:"p"},"1")," to confirm one row was added, an ",Object(o.b)("inlineCode",{parentName:"p"},"UPDATE")," query might return ",Object(o.b)("inlineCode",{parentName:"p"},"3")," if three rows were modified, and a ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE")," query might return ",Object(o.b)("inlineCode",{parentName:"p"},"0")," if no rows matched the condition. This return value is particularly useful for verifying the success of the operation, such as ensuring data was properly inserted, updated, or deleted. For instance, a ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE")," query that returns ",Object(o.b)("inlineCode",{parentName:"p"},"1")," or more confirms successful removal of records. In a framework like ",Object(o.b)("strong",{parentName:"p"},"Lorust"),", this type of query enables efficient validation of database changes without retrieving additional data."),Object(o.b)("h3",{id:"5-run-select-query"},"5. Run Select Query"),Object(o.b)("p",null,"Performing an arbitrary ",Object(o.b)("inlineCode",{parentName:"p"},"SELECT")," query retrieves data from a database based on specified conditions and stores the result in a variable for further use. The query defines the table, columns, and filters, such as ",Object(o.b)("inlineCode",{parentName:"p"},"SELECT * FROM users WHERE status = 'active'")," Upon execution, the application fetches the matching data, which can include multiple rows or specific results, and stores it in a variable for processing, validation, or display. This approach is essential for dynamically accessing and utilizing database records in real-time operations."),Object(o.b)("h3",{id:"6-select-from-db"},"6. Select from db"),Object(o.b)("p",null,"Performing an arbitrary ",Object(o.b)("inlineCode",{parentName:"p"},"SELECT")," query and storing its result in a variable involves executing a user-defined SQL ",Object(o.b)("inlineCode",{parentName:"p"},"SELECT")," statement to retrieve data from a database and capturing the returned data for subsequent use. This action allows the application to fetch specific records or data subsets based on the provided query conditions."),Object(o.b)("p",null,"The query typically specifies the table, columns, and any filtering criteria, such as ",Object(o.b)("inlineCode",{parentName:"p"},"SELECT name, email FROM users WHERE status = 'active'"),". Upon execution, the database returns the requested data, which is then stored in a variable. This variable holds the result, whether it is a single row, multiple rows, or aggregated values, and makes it accessible for further operations like data validation, display, or additional computations. This method is especially useful in dynamic scenarios where the query conditions or returned data depend on runtime requirements."),Object(o.b)("h3",{id:"7-update-into-db"},"7. Update into db"),Object(o.b)("p",null,"Performing an arbitrary ",Object(o.b)("inlineCode",{parentName:"p"},"UPDATE")," query and storing its result in a variable involves executing a user-defined SQL ",Object(o.b)("inlineCode",{parentName:"p"},"UPDATE")," statement to modify records in a database and capturing the outcome for validation or further use. This action updates specific fields in a table based on the conditions provided in the query."),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"UPDATE")," query defines the target table, the fields to be updated, and any conditions to limit the scope, such as ",Object(o.b)("inlineCode",{parentName:"p"},"UPDATE users SET status = 'inactive' WHERE last_login < '2023-01-01'"),". Upon execution, the database processes the query and returns the number of rows affected, which is stored in a variable. This result can be used to confirm the success of the operation, log changes, or trigger additional logic. For example, if the query affects 5 rows, the variable stores this value, enabling validation that the intended updates occurred. This approach ensures precise and efficient modifications to database records."),Object(o.b)("h3",{id:"8-connect-to-mongodb"},"8. Connect to Mongodb"),Object(o.b)("p",null,"Connecting to MongoDB establishes a connection between an application and a MongoDB server, allowing the application to perform various database operations such as reading, writing, updating, and deleting data. This connection is initiated using a connection string, which includes details like the server address, database name, and optional authentication credentials, for example, ",Object(o.b)("inlineCode",{parentName:"p"},"mongodb://username:password@localhost:27017//database_name"),". A MongoDB client or driver is used to initialize the connection, which then establishes communication with the database server. Once connected, the application obtains a session or client instance that facilitates operations on collections, enabling efficient and secure management of the database. This connection is a fundamental step for applications that need to interact with MongoDB for dynamic data processing."),Object(o.b)("h3",{id:"9-delete-many-into-mongodb"},"9. Delete many into Mongodb"),Object(o.b)("p",null,"Performing an arbitrary delete action based on a query and storing its result in a variable involves executing a user-defined ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE")," operation in a database to remove records that meet specific conditions and capturing the result for validation or further use."),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE")," query specifies the target table and the conditions for identifying records to be removed, such as ",Object(o.b)("inlineCode",{parentName:"p"},"DELETE FROM orders WHERE status = 'canceled'"),". Once executed, the database removes the matching records and returns the number of rows affected. This result is then stored in a variable, allowing the application to verify the operation's success or use the value in subsequent processes. For example, if the query affects 3 rows, the variable holds the value ",Object(o.b)("inlineCode",{parentName:"p"},"3"),", confirming that the intended records were deleted. This action is particularly useful for scenarios requiring dynamic deletions and validation of the changes."),Object(o.b)("h3",{id:"10-delete-one-into-mongodb"},"10. Delete one into Mongodb"),Object(o.b)("p",null,"The ",Object(o.b)("strong",{parentName:"p"},"delete one")," action in MongoDB is used to remove a single document from a collection that matches a specified query. This operation ensures that only the first matching document is deleted, even if multiple documents satisfy the query conditions. The user provides a query, such as ",Object(o.b)("inlineCode",{parentName:"p"},'{ "status": "inactive" }'),", to identify the target document. Upon execution of the ",Object(o.b)("inlineCode",{parentName:"p"},"deleteOne")," method, MongoDB searches the collection for the first document matching the criteria and deletes it if found. If no matching document exists, no action is taken. The operation returns a result object that includes the number of documents deleted, typically ",Object(o.b)("inlineCode",{parentName:"p"},"1")," if successful. This result can be used for validation or logging. For example, a ",Object(o.b)("inlineCode",{parentName:"p"},"deleteOne")," query on a ",Object(o.b)("inlineCode",{parentName:"p"},"users")," collection with a status filter deletes the first inactive user and confirms the action by reporting the affected document count. This approach ensures controlled and efficient deletion of specific records."),Object(o.b)("h3",{id:"11-find-from-mongodb"},"11. Find from Mongodb"),Object(o.b)("p",null,"Performing a finding action and storing its result in a variable involves executing a query to retrieve documents from a database that match specified conditions and saving the result for further use. This action is essential for retrieving data dynamically based on application needs."),Object(o.b)("p",null,"The query specifies the criteria for selecting records, such as ",Object(o.b)("inlineCode",{parentName:"p"},'{ "status": "active" }'),", and can also include options to limit the fields returned or sort the results. The database processes the query and returns all matching documents, which are stored in a variable. This variable acts as a container for the retrieved data and can hold a single record, multiple records, or an empty result set if no matches are found. The stored data can then be used for display, analysis, or additional operations. For instance, querying a ",Object(o.b)("inlineCode",{parentName:"p"},"users")," collection for active users might return a list of documents that is saved in a variable for rendering in an application or processing business logic. This action ensures efficient access to relevant data in real-time scenarios."),Object(o.b)("h3",{id:"12-find-one-from-mongodb"},"12. Find one from Mongodb"),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"findOne")," operation in MongoDB retrieves the first document from a collection that matches a specified query filter. It is efficient because it stops searching after after finding the first match, making it ideal when only one document is needed. The method accepts a query filter to define the search criteria and an optional projection to include or exclude specific fields in the result. For example, ",Object(o.b)("inlineCode",{parentName:"p"},'db.users.findOne({ name: "John" })')," fetches the first document where the ",Object(o.b)("inlineCode",{parentName:"p"},"name")," is ",Object(o.b)("inlineCode",{parentName:"p"},'"John"'),". Common use cases include fetching user profiles, retrieving configuration settings, or verifying the existence of a document."),Object(o.b)("h3",{id:"13-insert-many-into-mongodb"},"13. Insert many into Mongodb"),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"insertMany")," operation in MongoDB allows multiple documents to be inserted into a collection in a single operation, making it efficient for batch processing. It accepts an array of documents to be inserted, and if any document lacks the ",Object(o.b)("inlineCode",{parentName:"p"},"_id")," field, MongoDB automatically assigns a unique identifier. By default, the insertion is ordered, meaning MongoDB stops at the first error encountered, but this behavior can be changed by setting the ",Object(o.b)("inlineCode",{parentName:"p"},"ordered")," option to ",Object(o.b)("inlineCode",{parentName:"p"},"false"),", allowing the process to continue despite errors. For instance, to add multiple users, ",Object(o.b)("inlineCode",{parentName:"p"},'db.users.insertMany([{ name: "Alice", age: 25}, { name: "Bob", age: 30}])'),"can be used. This method is particularly useful for bulk loading data, adding multiple records efficiently, or initializing a database with predefined data. The ",Object(o.b)("inlineCode",{parentName:"p"},"insertMany")," operation reduces overhead and ensures all valid documents are inserted in one batch."),Object(o.b)("h3",{id:"14-insert-one-into-mongodb"},"14. Insert one into Mongodb"),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"insertOne")," operation in MongoDB is used to insert a single document into a collection, making it ideal for adding one record at a time. If the document does not include the ",Object(o.b)("inlineCode",{parentName:"p"},"_id")," field, MongoDB automatically assigns a unique identifier. The method returns a result object containing the inserted document's ",Object(o.b)("inlineCode",{parentName:"p"},"_id")," for reference. For example, using ",Object(o.b)("inlineCode",{parentName:"p"},'db.users.insertOne({ name: "John", age: 30})')," adds a document to the ",Object(o.b)("inlineCode",{parentName:"p"},"users")," collection and generates an ",Object(o.b)("inlineCode",{parentName:"p"},"_id")," if not provided. This operation is commonly used for tasks like adding a new user profile, inserting product details, or creating entries during development and testing. The ",Object(o.b)("inlineCode",{parentName:"p"},"insertOne")," method ensures reliable insertion with minimal complexity."),Object(o.b)("h3",{id:"15-update-many-into-mongodb"},"15. Update many into Mongodb"),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"updateMany")," operation in MongoDB modifies multiple documents within a collection that match a specified filter, making it ideal for bulk updates. It requires a filter to identify target documents and an update parameter using operators like ",Object(o.b)("inlineCode",{parentName:"p"},"$set"),", ",Object(o.b)("inlineCode",{parentName:"p"},"$inc"),", or ",Object(o.b)("inlineCode",{parentName:"p"},"$unset")," to define the changes. For instance, ",Object(o.b)("inlineCode",{parentName:"p"},'db.users.updateMany({ age: { $gt: 25} }, { $set: { status: "active"} })')," updates all users whose age is greater than 25, setting their ",Object(o.b)("inlineCode",{parentName:"p"},"status")," field to ",Object(o.b)("inlineCode",{parentName:"p"},"active"),". This operation returns details about the number of matched and modified documents and supports options like ",Object(o.b)("inlineCode",{parentName:"p"},"upsert")," to insert a document if no matches are found. The ",Object(o.b)("inlineCode",{parentName:"p"},"updateMany")," method is an efficient way to apply changes to multiple documents in a single execution, making it valuable for tasks like bulk data updates or standardizing records."),Object(o.b)("h3",{id:"16-update-one-into-mongodb"},"16. Update one into Mongodb"),Object(o.b)("p",null,"The ",Object(o.b)("inlineCode",{parentName:"p"},"updateOne")," operation in MongoDB modifies a single document in a collection that matches a specified filter, making it ideal for precise updates. It updates only the first matching document, even if multiple documents meet the criteria. The operation requires a filter to identify the target document and an update parameter using operators like ",Object(o.b)("inlineCode",{parentName:"p"},"$set"),", ",Object(o.b)("inlineCode",{parentName:"p"},"$inc"),", or ",Object(o.b)("inlineCode",{parentName:"p"},"$unset")," to define the changes. For example, ",Object(o.b)("inlineCode",{parentName:"p"},'db.users.updateOne({ age: { $gt: 25 } }, { $set: { status: "active" } })')," updates the ",Object(o.b)("inlineCode",{parentName:"p"},"status")," field to ",Object(o.b)("inlineCode",{parentName:"p"},'"active"')," for the first user with an ",Object(o.b)("inlineCode",{parentName:"p"},"age")," greater than 25. It also returns information about whether a document was matched and modified and supports options like ",Object(o.b)("inlineCode",{parentName:"p"},"upsert")," to insert a document if no match is found. The ",Object(o.b)("inlineCode",{parentName:"p"},"updateOne")," method is efficient for targeted updates, making it suitable for tasks like updating specific user profiles or modifying single configuration settings."))}u.isMDXComponent=!0},216:function(e,t,n){"use strict";n.d(t,"a",(function(){return u})),n.d(t,"b",(function(){return m}));var a=n(0),i=n.n(a);function o(e,t,n){return t in e?Object.defineProperty(e,t,{value:n,enumerable:!0,configurable:!0,writable:!0}):e[t]=n,e}function r(e,t){var n=Object.keys(e);if(Object.getOwnPropertySymbols){var a=Object.getOwnPropertySymbols(e);t&&(a=a.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),n.push.apply(n,a)}return n}function s(e){for(var t=1;t<arguments.length;t++){var n=null!=arguments[t]?arguments[t]:{};t%2?r(Object(n),!0).forEach((function(t){o(e,t,n[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(n)):r(Object(n)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(n,t))}))}return e}function c(e,t){if(null==e)return{};var n,a,i=function(e,t){if(null==e)return{};var n,a,i={},o=Object.keys(e);for(a=0;a<o.length;a++)n=o[a],t.indexOf(n)>=0||(i[n]=e[n]);return i}(e,t);if(Object.getOwnPropertySymbols){var o=Object.getOwnPropertySymbols(e);for(a=0;a<o.length;a++)n=o[a],t.indexOf(n)>=0||Object.prototype.propertyIsEnumerable.call(e,n)&&(i[n]=e[n])}return i}var d=i.a.createContext({}),l=function(e){var t=i.a.useContext(d),n=t;return e&&(n="function"==typeof e?e(t):s(s({},t),e)),n},u=function(e){var t=l(e.components);return i.a.createElement(d.Provider,{value:t},e.children)},b={inlineCode:"code",wrapper:function(e){var t=e.children;return i.a.createElement(i.a.Fragment,{},t)}},p=i.a.forwardRef((function(e,t){var n=e.components,a=e.mdxType,o=e.originalType,r=e.parentName,d=c(e,["components","mdxType","originalType","parentName"]),u=l(n),p=a,m=u["".concat(r,".").concat(p)]||u[p]||b[p]||o;return n?i.a.createElement(m,s(s({ref:t},d),{},{components:n})):i.a.createElement(m,s({ref:t},d))}));function m(e,t){var n=arguments,a=t&&t.mdxType;if("string"==typeof e||a){var o=n.length,r=new Array(o);r[0]=p;var s={};for(var c in t)hasOwnProperty.call(t,c)&&(s[c]=t[c]);s.originalType=e,s.mdxType="string"==typeof e?e:a,r[1]=s;for(var d=2;d<o;d++)r[d]=n[d];return i.a.createElement.apply(null,r)}return i.a.createElement.apply(null,n)}p.displayName="MDXCreateElement"},218:function(e,t,n){"use strict";function a(e){return!0===/^(\w*:|\/\/)/.test(e)}function i(e){return void 0!==e&&!a(e)}n.d(t,"b",(function(){return a})),n.d(t,"a",(function(){return i}))},219:function(e,t,n){"use strict";var a=n(0),i=n.n(a),o=n(11),r=n(218),s=n(12);const c=Object(a.createContext)({collectLink:()=>{}});var d=n(220),l=function(e,t){var n={};for(var a in e)Object.prototype.hasOwnProperty.call(e,a)&&t.indexOf(a)<0&&(n[a]=e[a]);if(null!=e&&"function"==typeof Object.getOwnPropertySymbols){var i=0;for(a=Object.getOwnPropertySymbols(e);i<a.length;i++)t.indexOf(a[i])<0&&Object.prototype.propertyIsEnumerable.call(e,a[i])&&(n[a[i]]=e[a[i]])}return n};t.a=function(e){var t,{isNavLink:n,to:u,href:b,activeClassName:p,isActive:m,"data-noBrokenLinkCheck":h}=e,f=l(e,["isNavLink","to","href","activeClassName","isActive","data-noBrokenLinkCheck"]);const{withBaseUrl:g}=Object(d.b)(),O=Object(a.useContext)(c),v=u||b,y=Object(r.a)(v),j=null==v?void 0:v.replace("pathname://",""),w=void 0!==j?(e=>e.startsWith("/"))(N=j)?g(N):N:void 0;var N;const C=Object(a.useRef)(!1),T=n?o.e:o.c,E=s.a.canUseIntersectionObserver;let D;Object(a.useEffect)((()=>(!E&&y&&window.docusaurus.prefetch(w),()=>{E&&D&&D.disconnect()})),[w,E,y]);const q=null!==(t=null==w?void 0:w.startsWith("#"))&&void 0!==t&&t,k=!w||!y||q;return w&&y&&!q&&!h&&O.collectLink(w),k?i.a.createElement("a",Object.assign({href:w},v&&!y&&{target:"_blank",rel:"noopener noreferrer"},f)):i.a.createElement(T,Object.assign({},f,{onMouseEnter:()=>{C.current||(window.docusaurus.preload(w),C.current=!0)},innerRef:e=>{var t,n;E&&e&&y&&(t=e,n=()=>{window.docusaurus.prefetch(w)},D=new window.IntersectionObserver((e=>{e.forEach((e=>{t===e.target&&(e.isIntersecting||e.intersectionRatio>0)&&(D.unobserve(t),D.disconnect(),n())}))})),D.observe(t))},to:w||""},n&&{isActive:m,activeClassName:p}))}},220:function(e,t,n){"use strict";n.d(t,"b",(function(){return o})),n.d(t,"a",(function(){return r}));var a=n(24),i=n(218);function o(){const{siteConfig:{baseUrl:e="/",url:t}={}}=Object(a.default)();return{withBaseUrl:(n,a)=>function(e,t,n,{forcePrependBaseUrl:a=!1,absolute:o=!1}={}){if(!n)return n;if(n.startsWith("#"))return n;if(Object(i.b)(n))return n;if(a)return t+n;const r=n.startsWith(t)?n:t+n.replace(/^\//,"");return o?e+r:r}(t,e,n,a)}}function r(e,t={}){const{withBaseUrl:n}=o();return n(e,t)}}}]);