Here's a sketched example of a generator, made based on your own diagram structure
var diagram = {
"3559740f-4fc7-4a58-8088-a6813e22696b": {
table_name: "ies_group",
widthTable: 213,
heightTable: 0,
point: { x: 356, y: 95 },
coloumns: {
coloumn_car_id_885ddad7_c509_4d5e_ab2e_dc5cb06d0e35: {
coloumn_name: "id_ies_group",
comment: "",
dataType: "INTEGER",
default: "",
primaryKey: true,
notNull: false,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: true,
style: { shadowBlur: 0, shadowColor: "#00D2FF" },
association_belong_id: null,
association_has_id: ["assoc_Source_bca2a6ca-cddd-4765-b8cb-617c6a1bbb6f"],
},
"614a69f3-56bd-483e-bf86-bfc5da481587": {
coloumn_name: "ies_group_name",
comment: "",
dataType: "TEXT",
default: "",
primaryKey: false,
notNull: false,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
},
association: {
"assoc_Source_bca2a6ca-cddd-4765-b8cb-617c6a1bbb6f": {
connector_id: "conn_car_number_driver_idb26b82c8-d673-4590-90c5-89b19fb4ab5c",
type: "has",
table: "c0661ebf-848c-4cb9-9631-5fd79f1ed8b1",
table_id: "c0661ebf-848c-4cb9-9631-5fd79f1ed8b1",
foreignKey: "0cb79ff1-382b-4fea-bb9b-c41eb3f59e34",
foreignKey_id: "0cb79ff1-382b-4fea-bb9b-c41eb3f59e34",
sourceKey: "id",
sourceKey_id: "coloumn_car_id_885ddad7_c509_4d5e_ab2e_dc5cb06d0e35",
point: { x: 0, y: 40 },
},
},
},
"c0661ebf-848c-4cb9-9631-5fd79f1ed8b1": {
table_name: "ies_user",
widthTable: 199,
heightTable: 0,
point: { x: 26, y: 50 },
coloumns: {
coloumn_car_id_885ddad7_c509_4d5e_ab2e_dc5cb06d0e35: {
coloumn_name: "id_ies_user",
comment: "",
dataType: "INTEGER",
default: "",
primaryKey: true,
notNull: false,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: true,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
"a7d702a1-a0a7-4872-9263-264f1251bf04": {
coloumn_name: "surname",
comment: "",
dataType: "TEXT",
default: "",
primaryKey: false,
notNull: false,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
"058ca8d5-5167-4040-81af-0f5c6a1d9934": {
coloumn_name: "name",
comment: "",
dataType: "TEXT",
default: "",
primaryKey: false,
notNull: false,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
"590d2d29-4ce7-495a-beb0-3d019a473253": {
coloumn_name: "patronymic",
comment: "",
dataType: "TEXT",
default: "",
primaryKey: false,
notNull: false,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
"0cb79ff1-382b-4fea-bb9b-c41eb3f59e34": {
coloumn_name: "id_ies_group",
comment: "",
dataType: "INTEGER",
default: "",
primaryKey: false,
notNull: false,
unique: false,
foreignKey: true,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "#00D2FF" },
association_belong_id: "assoc_Foreign_a9cc4bb3-f08c-45d7-9652-725be4f61767",
association_has_id: [],
},
"cc88f304-7d7b-49b8-9f84-d32ef3141d7c": {
coloumn_name: "user_name",
comment: "",
dataType: "TEXT",
default: "",
primaryKey: false,
notNull: true,
unique: true,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
"44fac1ae-e045-4602-9741-a5ea07e42ef9": {
coloumn_name: "password",
comment: "",
dataType: "TEXT",
default: "",
primaryKey: false,
notNull: true,
unique: false,
foreignKey: false,
unsigned: false,
zeroFill: false,
autoIncrement: false,
style: { shadowBlur: 0, shadowColor: "green" },
association_belong_id: null,
association_has_id: [],
},
},
association: {
"assoc_Foreign_a9cc4bb3-f08c-45d7-9652-725be4f61767": {
connector_id: "conn_car_number_driver_idb26b82c8-d673-4590-90c5-89b19fb4ab5c",
type: "belong",
table: "3559740f-4fc7-4a58-8088-a6813e22696b",
table_id: "3559740f-4fc7-4a58-8088-a6813e22696b",
foreignKey: "0cb79ff1-382b-4fea-bb9b-c41eb3f59e34",
foreignKey_id: "0cb79ff1-382b-4fea-bb9b-c41eb3f59e34",
targetKey: "coloumn_car_id_885ddad7_c509_4d5e_ab2e_dc5cb06d0e35",
targetKey_id: "coloumn_car_id_885ddad7_c509_4d5e_ab2e_dc5cb06d0e35",
point: { x: 0, y: 120 },
},
},
},
};
console.log(toSQLite(diagram));
/******************************************************************
CREATE TABLE ies_group (
id_ies_group INTEGER PRIMARY KEY AUTOINCREMENT,
ies_group_name TEXT
);
CREATE TABLE ies_user (
id_ies_user INTEGER PRIMARY KEY AUTOINCREMENT,
surname TEXT ,
name TEXT ,
patronymic TEXT ,
id_ies_group INTEGER ,
user_name TEXT NOT NULL UNIQUE,
password TEXT NOT NULL,
CONSTRAINT fk_ies_user_ies_group_1 FOREIGN KEY (id_ies_group) REFERENCES ies_group (id_ies_group)
);
*/