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)