added alasql query in editor query panel

lowcoder-org · FalkWolsky · Jan 22, 2025 · Jan 20, 2025 · Jan 22, 2025 · Jan 22, 2025
commit 3a4ab7c1dc13d1305fb8557b8b5a1036d121fcb1
diff --git a/client/packages/lowcoder/src/components/ResCreatePanel.tsx b/client/packages/lowcoder/src/components/ResCreatePanel.tsx
@@ -169,6 +169,13 @@ const ResButton = (props: {
         compType: "streamApi",
       },
     },
+    alasql: {
+      label: trans("query.quickAlasql"),
+      type: BottomResTypeEnum.Query,
+      extra: {
+        compType: "alasql",
+      },
+    },
     graphql: {
       label: trans("query.quickGraphql"),
       type: BottomResTypeEnum.Query,
@@ -319,6 +326,7 @@ export function ResCreatePanel(props: ResCreateModalProps) {
               <DataSourceListWrapper $placement={placement}>
                 <ResButton size={buttonSize} identifier={"restApi"} onSelect={onSelect} />
                 <ResButton size={buttonSize} identifier={"streamApi"} onSelect={onSelect} />
+                <ResButton size={buttonSize} identifier={"alasql"} onSelect={onSelect} />
                 <ResButton size={buttonSize} identifier={"graphql"} onSelect={onSelect} />
                 {datasource.map((i) => (
                   <ResButton size={buttonSize} key={i.id} identifier={i} onSelect={onSelect} />

diff --git a/client/packages/lowcoder/src/comps/queries/queryComp/queryPropertyView.tsx b/client/packages/lowcoder/src/comps/queries/queryComp/queryPropertyView.tsx
@@ -734,6 +734,7 @@ function useDatasourceStatus(datasourceId: string, datasourceType: ResourceType)
       datasourceType === "js" ||
       datasourceType === "streamApi" ||
       datasourceType === "libraryQuery" ||
+      datasourceType === "alasql" ||
       datasourceId === QUICK_REST_API_ID ||
       datasourceId === QUICK_GRAPHQL_ID
     ) {

diff --git a/client/packages/lowcoder/src/comps/queries/resourceDropdown.tsx b/client/packages/lowcoder/src/comps/queries/resourceDropdown.tsx
@@ -102,6 +102,11 @@ const QuickGraphqlValue: ResourceOptionValue = {
   type: "graphql",
 };
 
+const QuickAlasqlValue: ResourceOptionValue = {
+  id: "",
+  type: "alasql",
+};
+
 interface ResourceDropdownProps {
   changeResource: (datasourceId: string, value: string) => void;
   selectedResource: ResourceOptionValue;
@@ -265,6 +270,17 @@ export const ResourceDropdown = (props: ResourceDropdownProps) => {
             <SelectOptionLabel>{trans("query.quickStreamAPI")} </SelectOptionLabel>
           </SelectOptionContains>
         </SelectOption>
+
+        <SelectOption
+          key={JSON.stringify(QuickAlasqlValue)}
+          label={trans("query.quickAlasql")}
+          value={JSON.stringify(QuickAlasqlValue)}
+        >
+          <SelectOptionContains>
+            {getBottomResIcon("restApi")}
+            <SelectOptionLabel>{trans("query.quickAlasql")} </SelectOptionLabel>
+          </SelectOptionContains>
+        </SelectOption>
 
         <SelectOption
           key={JSON.stringify(QuickGraphqlValue)}

diff --git a/client/packages/lowcoder/src/comps/queries/sqlQuery/SQLQuery.tsx b/client/packages/lowcoder/src/comps/queries/sqlQuery/SQLQuery.tsx
@@ -255,6 +255,7 @@ export const NOT_SUPPORT_GUI_SQL_QUERY: string[] = [
   "snowflake",
   "tdengine",
   "dameng",
+  "alasql",
 ];
 const SUPPORT_UPSERT_SQL_QUERY: string[] = [
   "mysql",

diff --git a/client/packages/lowcoder/src/constants/datasourceConstants.ts b/client/packages/lowcoder/src/constants/datasourceConstants.ts
@@ -15,6 +15,7 @@ export const databasePlugins: Partial<DatasourceType>[] = [
   "clickHouse",
   "snowflake",
   "mariadb",
+  "alasql",
 ];
 
 export const apiPluginsForQueryLibrary: Partial<DatasourceType>[] = [

diff --git a/client/packages/lowcoder/src/constants/queryConstants.ts b/client/packages/lowcoder/src/constants/queryConstants.ts
@@ -13,6 +13,7 @@ import { GraphqlQuery } from "../comps/queries/httpQuery/graphqlQuery";
 import { toPluginQuery } from "comps/queries/pluginQuery/pluginQuery";
 import { MultiCompConstructor } from "lowcoder-core";
 import { DataSourcePluginMeta } from "lowcoder-sdk/dataSource";
+import { AlaSqlQuery } from "@lowcoder-ee/comps/queries/httpQuery/alasqlQuery";
 
 export type DatasourceType =
   | "mysql"
@@ -29,13 +30,15 @@ export type DatasourceType =
   | "googleSheets"
   | "graphql"
   | "snowflake"
-  | "mariadb";
+  | "mariadb"
+  | "alasql";
 
 export type ResourceType = DatasourceType | "js" | "libraryQuery" | "view";
 
 export const QueryMap = {
   js: JSQuery,
   mysql: SQLQuery,
+  alasql: AlaSqlQuery,
   restApi: HttpQuery,
   streamApi: StreamQuery,
   mongodb: MongoQuery,

diff --git a/client/packages/lowcoder/src/i18n/locales/en.ts b/client/packages/lowcoder/src/i18n/locales/en.ts
@@ -731,6 +731,9 @@ export const en = {
     "quickRestAPI": "REST Query",
     "quickStreamAPI": "Stream Query",
     "quickGraphql": "GraphQL Query",
+    "quickAlasql": "Local SQL Query",
+    "databaseType": "Database Type",
+    "chooseDatabase": "Choose Database",
     "lowcoderAPI": "Lowcoder API",
     "executeJSCode": "Run JavaScript Code",
     "importFromQueryLibrary": "Import from Query Library",