git.schokokeks.org
Repositories
Help
Report an Issue
fs-words.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
9815a42
Branches
Tags
develop-client_server
master
typescript
fs-words.git
source
repositories
concept-tags.ts
[add] typescript logic
Christian Fraß
commited
9815a42
at 2021-03-03 00:27:18
concept-tags.ts
Blame
History
Raw
namespace repositories { /** */ export var concept_tags : helpers.repository_sqltable = { "setup": function () { return helpers.database.query_do_named("concept.setup-tags"); }, "teardown": function () { throw (new Error("not implemented")); }, "create": function (row) { return helpers.database.query_put_free ( "INSERT INTO concept_tags(concept_id, tag_id) VALUES (:concept_id, :tag_id);", { "concept_id": row["concept_id"], "tag_id": row["tag_id"], } ); }, "update": function (concept_tag_id, row) { return helpers.database.query_do_free ( "UPDATE concept_tags SET concept_id = :concept_id, tag_id = :tag_id WHERE (id = :id)", { "id": concept_tag_id, "concept_id": row["concept_id"], "tag_id": row["tag_id"], } ); }, "delete": function (concept_tag_id) { return helpers.database.query_do_free ( "DELETE FROM concept_tags WHERE (id = :id)", { "id": concept_tag_id, } ); }, "read": async function (concept_tag_id) { return ( helpers.database.query_get_free ( "SELECT concept_id,tag_id FROM concept_tags WHERE (id = :id)", { "id": concept_tag_id, } ) .then ( (rows) => ( (rows.length === 1) ? Promise.resolve<type_row>(rows[0]) : Promise.reject<type_row>(new Error("not found")) ) ) ); }, "purge": async function (column, value) { return helpers.database.query_do_free ( "DELETE FROM concept_tags WHERE (" + column + " = :value)", { "value": value, } ); }, "take": async function (column, value) { return await helpers.database.query_get_free ( "SELECT concept_id,tag_id FROM concept_tags WHERE (" + column + " = :value)", { "value": value, } ); }, }; }