-
Notifications
You must be signed in to change notification settings - Fork 28
Expand file tree
/
Copy pathdatabase.ts
More file actions
117 lines (90 loc) · 2.95 KB
/
database.ts
File metadata and controls
117 lines (90 loc) · 2.95 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
export interface DatabaseType {
name: string,
dialect: string;
logo: string;
small_logo?: string
comming? : boolean
}
export enum DatabaseDialect {
MYSQL = "mysql",
POSTGRES = "postgres",
SQLITE = "sqlite",
MARIADB = "mariadb",
SQL_SERVER = "sql_server",
ORACLE = "oracle"
};
export const DBTypes: DatabaseType[] = [
{
name: "Postgresql",
dialect: DatabaseDialect.POSTGRES,
logo: "/postgresql_logo.png",
small_logo: "/postgresql_logo_small.png"
}, {
name: "MySQL",
dialect: DatabaseDialect.MYSQL,
logo: "/mysql_logo.png",
small_logo: "/mysql_logo_small.png"
},
{
name: "Sqlite",
dialect: DatabaseDialect.SQLITE,
logo: "/sqlite_logo.png",
small_logo: "/sqlite_logo_small.png"
},
{
name: "MariaDB",
dialect: DatabaseDialect.MARIADB,
logo: "/mariadb_logo.png",
small_logo: "/mariadb_logo_small.png"
},
{
name: "SQL Server",
dialect: DatabaseDialect.SQL_SERVER,
logo: "/sql_server_logo_small.png",
small_logo: "/sql_server_logo_small.png" ,
comming : true
},
{
name: "Oracle",
dialect: DatabaseDialect.ORACLE,
logo: "/oracle_logo_small.png",
small_logo: "/oracle_logo_small.png" ,
comming : true
},
]
export const getDatabaseByDialect = (dialect: DatabaseDialect): DatabaseType => {
const dbType: DatabaseType | undefined = DBTypes.find((dbType: DatabaseType) => dbType.dialect == dialect);
return dbType ? dbType : DBTypes[0];
}
export enum ImportMethodType {
DUMP = "DUMP",
DB_CLIENT = "DB_CLIENT",
}
export interface ImportDatabaseMethod {
id: string;
name: string;
logo?: string;
icon?: React.ReactNode;
instruction?: string;
example?: string;
type: ImportMethodType;
numberOfInstructions?: number;
}
export interface ImportDatabaseOption {
dialect: DatabaseDialect,
methods: ImportDatabaseMethod[] ;
docUrl? : string ;
}
export const PG_DUMP_INSTRUCTIONS = "pg_dump -U [username] -d [database_name] -f [output_file.sql]";
export const PG_DUMP_EXAMPLE = "pg_dump -U root -d example_db -f example_db.sql";
export const MYSQL_DUMP_INSTRUCTIONS = "mysqldump -u [username] -p --no-data [database_name] > [output_file.sql]";
export const MYSQL_DUMP_EXAMPLE = "mysqldump -u root -p --no-data example_db > example_db.sql";
export const MARIADB_DUMP_INSTRUCTIONS = "mariadb-dump -u [username] -p --no-data [database_name] > [output_file.sql]";
export const MARIADB_DUMP_EXAMPLE = "mariadb-dump -u root -p --no-data example_db > example_db.sql";
export const SQLITE_DUMP_INSRUCTION = "sqlite3 [daabase_path] .schema > [output_file.sql]";
export const SQLITE_DUMP_EXAMPLE = "sqlite3 example_db.sqlite .schema > example_db.sql";
export enum CardinalityStyle {
HIDDEN = "HIDDEN" ,
NUMERIC = "NUMERIC" ,
SYMBOLIC = "SYMBOLIC"
}