SPB Git

Repository Public

databases.py 12.3 KB 146 lines python

1#!/usr/bin/env python32# SP Notes Core3# File: Scripts/recorders/databases.py4# Description: Records the fixtures of the database routes (2.x + client ids of 3.0): databases, properties, views,5#              rows, query, templates, duplicate, CSV import / export, row restore, and their rows in the entity feed.6#7# Author: Simon-Pierre Boucher8# Contact: contact@spboucher.ai9from _parity_support import ParityRecorder, new_id1011r = ParityRecorder("databases")12head = r.call("GET", "/api/sync?since=0&limit=1").json["head"]1314r.call("GET", "/api/databases/templates", save="templates")1516# A database is born with its host page; its object appears the first time it is opened.17host = r.page("Biens", type="database", section="databases")18db = r.call("GET", "/api/databases/" + host["id"], save="db-get-new").json19dbid = db["id"]20title_prop = db["properties"][0]["id"]21default_view = db["views"][0]["id"]22r.call("PATCH", "/api/databases/" + dbid, {"name": "Fixture · Biens immobiliers", "description": "Parc locatif", "icon": "🏠"}, save="db-patch")23r.call("DELETE", "/api/databases/" + dbid, save="db-delete-not-allowed")24r.call("GET", "/api/databases/" + new_id(), save="db-not-found")25r.call("GET", "/api/databases/not-a-uuid", save="db-bad-id")2627# Second database: the target of a relation.28host2 = r.page("Villes", type="database", section="databases")29db2 = r.call("GET", "/api/databases/" + host2["id"]).json30db2id = db2["id"]31pop = r.call("POST", "/api/databases/%s/properties" % db2id, {"id": new_id(), "name": "Population", "type": "number", "config": {"format": "integer"}}).json3233# Properties.34status_id = new_id()35opts = [{"id": "optaaaa1", "name": "Loué", "color": "green"}, {"id": "optaaaa2", "name": "Vacant", "color": "red"}]36r.call("POST", "/api/databases/%s/properties" % dbid, {"id": status_id, "name": "État", "type": "select", "config": {"options": opts}, "width": 160}, save="prop-create")37r.call("POST", "/api/databases/%s/properties" % dbid, {"id": status_id, "name": "Autre nom", "type": "text"}, save="prop-create-again")38price = r.call("POST", "/api/databases/%s/properties" % host["id"], {"id": new_id(), "name": "Prix", "type": "number", "config": {"format": "currency"}}, save="prop-create-number").json39date = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Achat", "type": "date"}).json40done = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Inspecté", "type": "checkbox"}).json41tags = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Étiquettes", "type": "multi_select", "config": {"options": [{"id": "tagaaaa1", "name": "duplex", "color": "blue"}, {"id": "tagaaaa2", "name": "centre", "color": "purple"}]}}).json42link = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Annonce", "type": "url"}).json43note = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Note", "type": "text"}).json44rel = r.call("POST", "/api/databases/%s/properties" % dbid, {"id": new_id(), "name": "Ville", "type": "relation", "config": {"targetDatabaseId": db2id, "twoWay": True}}, save="prop-create-relation").json45roll = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Population ville", "type": "rollup", "config": {"relationPropertyId": rel["id"], "targetPropertyId": pop["id"], "aggregate": "sum"}}, save="prop-create-rollup").json46formula = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Prix double", "type": "formula", "config": {"expression": "prop(\"Prix\") * 2"}}, save="prop-create-formula").json47bad_formula = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Cassée", "type": "formula", "config": {"expression": "prop(\"Inconnue\") +"}}).json48created = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Créé", "type": "created_time"}).json49edited = r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Modifié", "type": "last_edited_time"}).json50r.call("PATCH", "/api/databases/%s/properties" % dbid, {"id": note["id"], "name": "Remarque", "width": 320}, save="prop-patch")51r.call("PATCH", "/api/databases/%s/properties" % dbid, {"id": note["id"], "type": "url"}, save="prop-patch-type")52r.call("PATCH", "/api/databases/%s/properties" % dbid, {"order": [price["id"], status_id, date["id"]]}, save="prop-reorder")53r.call("PATCH", "/api/databases/%s/properties" % dbid, {"name": "sans id"}, save="prop-patch-no-id")54r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "Second titre", "type": "title"}, save="prop-title-refused")55r.call("POST", "/api/databases/%s/properties" % dbid, {"name": "x", "type": "unicorn"}, save="prop-validation")56r.call("POST", "/api/databases/%s/properties" % db2id, {"id": status_id, "name": "x", "type": "text"}, save="prop-id-taken")57r.call("DELETE", "/api/databases/%s/properties?id=%s" % (dbid, link["id"]), save="prop-delete")58r.call("DELETE", "/api/databases/%s/properties?id=%s" % (dbid, link["id"]), save="prop-delete-not-found")59r.call("DELETE", "/api/databases/%s/properties?id=%s" % (dbid, title_prop), save="prop-delete-title")6061# Views.62board_id = new_id()63board_config = {"groupBy": status_id, "sorts": [{"property": price["id"], "dir": "desc"}], "filter": {"and": [{"property": price["id"], "op": "gt", "value": 100000}]}, "hidden": [note["id"]]}64r.call("POST", "/api/databases/%s/views" % dbid, {"id": board_id, "name": "Par état", "type": "board", "config": board_config}, save="view-create")65r.call("POST", "/api/databases/%s/views" % dbid, {"id": board_id, "name": "Autre", "type": "list"}, save="view-create-again")66cal = r.call("POST", "/api/databases/%s/views" % dbid, {"name": "Calendrier", "type": "calendar", "config": {"dateProperty": date["id"]}}).json67r.call("PATCH", "/api/databases/%s/views" % dbid, {"id": board_id, "name": "Tableau par état", "isDefault": True, "position": 3}, save="view-patch")68r.call("GET", "/api/databases/%s/views" % dbid, save="view-list")69r.call("DELETE", "/api/databases/%s/views?id=%s" % (dbid, cal["id"]), save="view-delete")70r.call("DELETE", "/api/databases/%s/views?id=%s" % (dbid, cal["id"]), save="view-delete-not-found")71r.call("DELETE", "/api/databases/%s/views?id=%s" % (db2id, db2["views"][0]["id"]), save="view-delete-last")72r.call("POST", "/api/databases/%s/views" % dbid, {"name": "x", "type": "pivot"}, save="view-validation")7374# Rows.75city = r.call("POST", "/api/databases/%s/rows" % db2id, {"id": new_id(), "pageId": new_id(), "title": "Gatineau", "values": {pop["id"]: 291000}}).json76city2 = r.call("POST", "/api/databases/%s/rows" % db2id, {"title": "Québec", "values": {pop["id"]: 549000}}).json77row_id, row_page = new_id(), new_id()78values = {status_id: "optaaaa1", price["id"]: 425000, date["id"]: "2026-03-15", done["id"]: True, tags["id"]: ["tagaaaa1", "tagaaaa2"],79          note["id"]: "https://example.org/annonce", rel["id"]: [city["id"], city2["id"]]}80r.call("POST", "/api/databases/%s/rows" % dbid, {"id": row_id, "pageId": row_page, "title": "255, rue Laurel", "values": values, "icon": "🏠"}, save="row-create")81r.call("POST", "/api/databases/%s/rows" % dbid, {"id": row_id, "pageId": row_page, "title": "Retry"}, save="row-create-again")82bulk = r.call("POST", "/api/databases/%s/rows" % dbid, {"rows": [{"title": "99, rue de Magog", "values": {price["id"]: 447000, status_id: "optaaaa2"}}, {"title": "252, montée Dalton", "values": {price["id"]: 560000}}, {"title": "Terrain", "values": {price["id"]: 80000}}]}, save="row-create-bulk").json83r.call("POST", "/api/databases/%s/rows" % db2id, {"id": row_id, "title": "x"}, save="row-id-taken")84r.call("POST", "/api/databases/%s/rows" % dbid, {"id": new_id(), "pageId": host["id"], "title": "x"}, save="row-page-id-taken")85r.call("POST", "/api/databases/%s/rows" % dbid, {"title": "x", "unknown": 1}, save="row-validation")86r.call("PATCH", "/api/databases/%s/rows" % dbid, {"id": row_id, "values": {price["id"]: 430000, title_prop: "255, rue Laurel (révisé)", done["id"]: None}}, save="row-patch")87r.call("PATCH", "/api/databases/%s/rows" % dbid, {"updates": [{"id": bulk[0]["id"], "values": {status_id: "optaaaa1"}}, {"id": bulk[1]["id"], "values": {"Prix": 565000}}]}, save="row-patch-bulk")88r.call("PATCH", "/api/databases/%s/rows" % dbid, {"order": [bulk[1]["id"], row_id, bulk[0]["id"]]}, save="row-reorder")89r.call("PATCH", "/api/databases/%s/rows" % dbid, {"id": new_id(), "values": {}}, save="row-patch-not-found")90r.call("PATCH", "/api/databases/%s/rows" % dbid, {"values": {}}, save="row-patch-no-id")91r.call("GET", "/api/databases/%s/rows" % dbid, save="row-refs")92r.call("GET", "/api/databases/%s/rows?q=laurel&limit=5" % dbid, save="row-refs-search")93r.call("GET", "/api/databases/%s/rows?full=1&limit=2&offset=1" % dbid, save="row-list-full")9495# Query.96r.call("POST", "/api/databases/%s/query" % dbid, {}, save="query-all")97r.call("POST", "/api/databases/%s/query" % dbid, {"filter": {"and": [{"property": price["id"], "op": "gte", "value": 430000}, {"or": [{"property": status_id, "op": "eq", "value": "optaaaa1"}, {"property": status_id, "op": "empty"}]}]},98                                                  "sorts": [{"property": price["id"], "dir": "desc"}], "limit": 2, "offset": 0}, save="query-filter-sort")99r.call("POST", "/api/databases/%s/query" % dbid, {"viewId": board_id}, save="query-view")100r.call("POST", "/api/databases/%s/query" % dbid, {"search": "dalton", "filter": None}, save="query-search")101r.call("POST", "/api/databases/%s/query" % dbid, {"limit": 0}, save="query-validation")102r.call("GET", "/api/databases/%s/query?viewId=%s" % (dbid, board_id), save="query-get-view")103r.call("GET", "/api/databases/%s/query?format=csv" % dbid, save="query-csv")104r.call("GET", "/api/databases/%s?format=csv&viewId=%s" % (dbid, board_id), save="db-csv-view")105r.call("POST", "/api/databases/%s/query" % db2id, {}, save="query-two-way")106107# Delete / restore rows.108r.track(bulk[1]["pageId"])  # rows deleted on their own are trashed separately from their database: purge them too109r.track(bulk[2]["pageId"])110r.call("DELETE", "/api/databases/%s/rows?id=%s" % (dbid, bulk[2]["id"]), save="row-delete")111r.call("DELETE", "/api/databases/%s/rows?id=%s" % (dbid, bulk[2]["id"]), save="row-delete-again")112r.call("POST", "/api/databases/%s/rows" % dbid, {"id": bulk[2]["id"], "title": "revient ?"}, save="row-deleted")113r.call("POST", "/api/databases/%s/rows/restore" % dbid, {"ids": [bulk[2]["id"]]}, save="row-restore")114r.call("POST", "/api/databases/%s/rows/restore" % dbid, {"ids": [bulk[2]["id"]]}, save="row-restore-again")115r.call("DELETE", "/api/databases/%s/rows?ids=%s,%s" % (dbid, bulk[2]["id"], bulk[1]["id"]), save="row-delete-many")116r.call("DELETE", "/api/databases/%s/rows?id=nope" % dbid, save="row-delete-bad-id")117118# Full object, list, templates, duplicate, CSV import.119r.call("GET", "/api/databases/" + dbid, save="db-get")120r.call("GET", "/api/databases", save="db-list")121host3 = r.page("Lectures", type="database", section="databases")122r.call("POST", "/api/databases/%s/apply-template" % host3["id"], {"template": "reading-list"}, save="template-apply")123r.call("GET", "/api/databases/" + host3["id"], save="template-db")124r.call("POST", "/api/databases/%s/apply-template" % host3["id"], {"template": "unicorn"}, save="template-unknown")125dup = r.call("POST", "/api/databases/%s/duplicate" % dbid, {"withRows": True, "title": "Fixture · Biens (copie)"}, save="db-duplicate").json126if dup and dup.get("pageId"):127    r.track(dup["pageId"])128tpl = r.call("POST", "/api/databases/%s/duplicate" % dbid, {"asTemplate": True}, save="db-duplicate-template").json129if tpl and tpl.get("pageId"):130    r.track(tpl["pageId"])131csv = "Name,Prix,Quartier\nImport A,100000,Hull\nImport B,200000,Aylmer\n".encode("utf-8")132r.form("POST", "/api/databases/%s/import" % dbid, {}, "file", "biens.csv", csv, "text/csv", save="csv-import")133r.form("POST", "/api/databases/%s/import" % dbid, {}, save="csv-import-no-file")134135# The same objects in the entity feed (API-NEXT §3.1), then the soft delete of a database.136kinds = "database,database_property,database_view,database_row,reference"137r.call("GET", "/api/sync?kinds=%s&since=%d&limit=500" % (kinds, head), save="feed")138r.call("DELETE", "/api/pages/" + host3["id"])139r.call("GET", "/api/databases/" + host3["id"], save="db-get-trashed")140r.call("GET", "/api/sync?kinds=database&since=%d&limit=500" % head, save="feed-database-trashed")141r.call("DELETE", "/api/pages/" + host2["id"])142r.fresh()143r.call("DELETE", "/api/pages/" + host2["id"] + "?purge=1")144r.call("GET", "/api/sync?kinds=database,database_property,database_view,database_row&since=%d&limit=500" % head, save="feed-database-purged")145r.finish()146
Files main
Menu

Theme