Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat:Added support for exporting SQL as OracleDB SQL #192

Open
wants to merge 1 commit into
base: main
Choose a base branch
from
Open

feat:Added support for exporting SQL as OracleDB SQL #192

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Binary file added src/assets/oraclesql-icon.png
View file
Open in desktop
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Binary file added src/assets/oraclesql.png
View file
Open in desktop
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
17 changes: 17 additions & 0 deletions src/components/EditorHeader/ControlPanel.jsx
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -29,6 +29,7 @@ import {
jsonToSQLite,
jsonToMariaDB,
jsonToSQLServer,
jsonToOracleSQL,
} from "../../utils/exportSQL/generic";
import {
ObjectType,
Expand Down Expand Up @@ -882,6 +883,22 @@ export default function ControlPanel({
}));
},
},
{
OracleSQL: () => {
setModal(MODAL.CODE);
const src = jsonToOracleSQL({
tables: tables,
references: relationships,
types: types,
database: database,
});
setExportData((prev) => ({
...prev,
data: src,
extension: "sql",
}));
},
},
],
}),
function: () => {
Expand Down
1 change: 1 addition & 0 deletions src/data/constants.js
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -112,5 +112,6 @@ export const DB = {
MSSQL: "transactsql",
SQLITE: "sqlite",
MARIADB: "mariadb",
ORACLESQL: "oraclesql",
GENERIC: "generic",
};
9 changes: 9 additions & 0 deletions src/data/databases.js
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -3,6 +3,7 @@ import postgresImage from "../assets/postgres-icon.png";
import sqliteImage from "../assets/sqlite-icon.png";
import mariadbImage from "../assets/mariadb-icon.png";
import mssqlImage from "../assets/mssql-icon.png";
import oraclesqlImage from "../assets/oraclesql-icon.png";
import i18n from "../i18n/i18n";
import { DB } from "./constants";

Expand Down Expand Up @@ -40,6 +41,14 @@ export const databases = new Proxy(
image: mssqlImage,
hasTypes: false,
},
[DB.ORACLESQL]: {
name: "Oracle SQL",
label: DB.ORACLESQL,
image: oraclesqlImage,
hasTypes: false,
hasEnums: false,
hasArrays: false,
},
[DB.GENERIC]: {
name: i18n.t("generic"),
label: DB.GENERIC,
Expand Down
190 changes: 190 additions & 0 deletions src/data/datatypes.js
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -55,6 +55,16 @@ const defaultTypesBase = {
isSized: false,
hasPrecision: true,
},
NUMBER: {
type: "NUMBER",
checkDefault: (field) => {
return /^-?\d+(\.\d+)?$/.test(field.default);
},
hasCheck: true,
isSized: false,
hasPrecision: true,
canIncrement: false,
},
FLOAT: {
type: "FLOAT",
checkDefault: (field) => {
Expand Down Expand Up @@ -110,6 +120,20 @@ const defaultTypesBase = {
defaultSize: 255,
hasQuotes: true,
},
VARCHAR2: {
type: "VARCHAR2",
checkDefault: (field) => {
if (strHasQuotes(field.default)) {
return field.default.length - 2 <= field.size;
}
return field.default.length <= field.size;
},
hasCheck: true,
isSized: true,
hasPrecision: false,
defaultSize: 225,
hasQuotes: true,
},
TEXT: {
type: "TEXT",
checkDefault: (field) => true,
Expand Down Expand Up @@ -223,6 +247,22 @@ const defaultTypesBase = {
hasPrecision: false,
noDefault: true,
},
CLOB: {
type: "CLOB",
checkDefault: (field) => true,
isSized: false,
hasCheck: false,
hasPrecision: false,
noDefault: true,
},
NCLOB: {
type: "NCLOB",
checkDefault: (field) => true,
isSized: false,
hasCheck: false,
hasPrecision: false,
noDefault: true,
},
JSON: {
type: "JSON",
checkDefault: (field) => true,
Expand Down Expand Up @@ -1616,13 +1656,163 @@ export const mssqlTypes = new Proxy(mssqlTypesBase, {
get: (target, prop) => (prop in target ? target[prop] : false),
});

const oraclesqlTypesBase = {
NUMBER: {
type: "NUMBER",
checkDefault: (field) => {
return /^-?\d+(\.\d+)?$/.test(field.default);
},
hasCheck: true,
isSized: false,
hasPrecision: true,
canIncrement: false,
},
VARCHAR2: {
type: "VARCHAR2",
checkDefault: (field) => {
if (strHasQuotes(field.default)) {
return field.default.length - 2 <= field.size;
}
return field.default.length <= field.size;
},
hasCheck: true,
isSized: true,
hasPrecision: false,
defaultSize: 4000,
hasQuotes: true,
},
CHAR: {
type: "CHAR",
checkDefault: (field) => {
if (strHasQuotes(field.default)) {
return field.default.length - 2 <= field.size;
}
return field.default.length <= field.size;
},
hasCheck: true,
isSized: true,
hasPrecision: false,
defaultSize: 1,
hasQuotes: true,
},
CLOB: {
type: "CLOB",
checkDefault: (field) => true,
isSized: false,
hasCheck: false,
hasPrecision: false,
noDefault: true,
},
NCLOB: {
type: "NCLOB",
checkDefault: (field) => true,
isSized: false,
hasCheck: false,
hasPrecision: false,
noDefault: true,
},
BLOB: {
type: "BLOB",
checkDefault: (field) => true,
isSized: false,
hasCheck: false,
hasPrecision: false,
noDefault: true,
},
DATE: {
type: "DATE",
checkDefault: (field) => {
return /^\d{4}-\d{2}-\d{2}$/.test(field.default);
},
hasCheck: false,
isSized: false,
hasPrecision: false,
hasQuotes: true,
},
TIMESTAMP: {
type: "TIMESTAMP",
checkDefault: (field) => {
if (field.default.toUpperCase() === "CURRENT_TIMESTAMP") {
return true;
}
return /^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}(?:\.\d+)?$/.test(
field.default,
);
},
hasCheck: false,
isSized: false,
hasPrecision: true,
hasQuotes: true,
},
INTERVAL: {
type: "INTERVAL",
checkDefault: (field) => {
return /^INTERVAL\s'\d+'(\s+DAY|HOUR|MINUTE|SECOND)?$/.test(
field.default,
);
},
hasCheck: false,
isSized: false,
hasPrecision: false,
hasQuotes: true,
},
FLOAT: {
type: "FLOAT",
checkDefault: (field) => {
return /^-?\d+(\.\d+)?$/.test(field.default);
},
hasCheck: true,
isSized: false,
hasPrecision: true,
},
DOUBLE: {
type: "DOUBLE",
checkDefault: (field) => {
return /^-?\d+(\.\d+)?$/.test(field.default);
},
hasCheck: true,
isSized: false,
hasPrecision: true,
},
BOOLEAN: {
type: "BOOLEAN",
checkDefault: (field) => {
return (
field.default === "0" ||
field.default === "1" ||
field.default.toUpperCase() === "TRUE" ||
field.default.toUpperCase() === "FALSE"
);
},
hasCheck: false,
isSized: false,
hasPrecision: false,
},
RAW: {
type: "RAW",
checkDefault: (field) => {
return /^[0-9A-Fa-f]+$/.test(field.default);
},
hasCheck: false,
isSized: true,
hasPrecision: false,
defaultSize: 2000,
hasQuotes: false,
},
};

export const oraclesqlTypes = new Proxy(oraclesqlTypesBase, {
get: (target, prop) => (prop in target ? target[prop] : false),
});

const dbToTypesBase = {
[DB.GENERIC]: defaultTypes,
[DB.MYSQL]: mysqlTypes,
[DB.POSTGRES]: postgresTypes,
[DB.SQLITE]: sqliteTypes,
[DB.MSSQL]: mssqlTypes,
[DB.MARIADB]: mysqlTypes,
[DB.ORACLESQL]: oraclesqlTypes,
};

export const dbToTypes = new Proxy(dbToTypesBase, {
Expand Down
7 changes: 6 additions & 1 deletion src/pages/LandingPage.jsx
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -9,6 +9,7 @@ import mysql_icon from "../assets/mysql.png";
import postgres_icon from "../assets/postgres.png";
import sqlite_icon from "../assets/sqlite.png";
import mariadb_icon from "../assets/mariadb.png";
import oraclesql_icon from "../assets/oraclesql.png";
import sql_server_icon from "../assets/sql-server.png";
import discord from "../assets/discord.png";
import github from "../assets/github.png";
Expand Down Expand Up @@ -178,7 +179,7 @@ export default function LandingPage() {
<div className="text-center text-2xl font-bold mb-4">
We support these DBMS
</div>
<div className="grid grid-cols-5 place-items-center items-baseline sm:grid-cols-1 sm:gap-4">
<div className="grid grid-cols-3 grid-rows-2 gap-y-[4rem] place-items-center items-baseline sm:grid-cols-1 sm:grid-rows-1 sm:gap-10">
<img
src={mysql_icon}
className="opacity-70 hover:opacity-100 transition-all duration-300 h-20"
Expand All @@ -199,6 +200,10 @@ export default function LandingPage() {
src={sql_server_icon}
className="opacity-70 hover:opacity-100 transition-all duration-300 h-16"
/>
<img
src={oraclesql_icon}
className="opacity-70 hover:opacity-100 transition-all duration-300 h-16 scale-[300%]"
/>
</div>
<div className="mt-16 mb-2 text-2xl font-bold text-center">
Reach out to us
Expand Down
Loading