def relation_list(): engine = create_engine("postgresql://*****:*****@localhost/metadata", encoding='utf-8') Base.metadata.create_all(engine) Session_class = sessionmaker(bind=engine) session = Session_class() re = relation.Relation(session) print(re.list())
def relation_delete(): engine = create_engine("postgresql://*****:*****@localhost/metadata", encoding='utf-8') Base.metadata.create_all(engine) Session_class = sessionmaker(bind=engine) session = Session_class() re = relation.Relation(session) re.delete("operator_skill")
def relation_update(): engine = create_engine("postgresql://*****:*****@localhost/metadata", encoding='utf-8') Base.metadata.create_all(engine) Session_class = sessionmaker(bind=engine) session = Session_class() with open("operator_skill_test.json", 'r') as fp: data = load_json(fp) re = relation.Relation(session) re.update(data) print(data["name"]) print(re.read(data["name"]))
def create(session): with open("skill.json", 'r') as fp: skill = load_json(fp) entity.Entity(session).create("skill", skill) with open("operator.json", 'r') as fp: operator = load_json(fp) entity.Entity(session).create("operator", operator) with open("operator_skill.json", 'r') as fp: data = load_json(fp) relation.Relation(session).create("operator_skill", data)
#!/usr/bin/env python3 #-*- coding: UTF-8 -*- from generator import entity, relation, field from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker engine = create_engine("postgresql://*****:*****@localhost/metadata", encoding='utf-8') Session_class = sessionmaker(bind=engine) session = Session_class() re = relation.Relation(session) def create_relation(name, body) -> str: return re.create(name, body) def delete_relation(name) -> str: return re.delete(name) def get_relation(name) -> str: return re.read(name) def list_relation() -> str: return re.list() def update_relation(name, body) -> str: return re.update(name, body)