flyly0755
flyly0755
**Describe the bug** from sqlalchemy_utils import create_view with this method, i can create clickhouse normal view but with from sqlalchemy_utils importcreate_materialized_view, create clickhouse meterialized view failed with error as below...
We have a destop application, which backend uses django. Every time provide a new version will package a software pack. Now I want to introduce django-q to our project for...
I have one model with a field which is self related, ```python class zi(models.Model): """汉字数据模型""" chszi = models.CharField(max_length=1, null=False, blank=False, verbose_name="汉字", unique=True) relatedzi = models.ManyToManyField("self", null=True, blank=True, related_name="rzi", symmetrical=True, verbose_name='关联字')...
**Describe the bug** ```python from sqlalchemy import Column, create_engine from clickhouse_sqlalchemy import engines, types from clickhouse_sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker from sqlalchemy import insert as sainsert ChBase =...
**Describe the bug** With flask-sqlalchemy, ORM class showed as below, inherit db.Model where db come from SQLAlchemy(app) ```python from flask import Flask from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config["SQLALCHEMY_DATABASE_URI"]...
Usually, create a ORM class as below: ```python from sqlalchemy import Column from clickhouse_sqlalchemy.ext.declarative import declarative_base ChBase = declarative_base() class TbFile(ChBase): __tablename__ = 'tb_file' __table_args__ = {'comment': 'File Info Table...
**Describe the bug** clickhouse-sqlalchemy support 2 kinds of uri uri = 'clickhouse+native://localhost/default' with native tcp port(9000) uri = 'clickhouse://localhost/default' with http port(8123) with http mode, for example, I have a...
I use database as broker, so with table django_q_task to store task info. But after some times, get so many data record, and how to periodically auto-delete old data record?...
Use orm, we doesn't need to write raw sql to do crud operation, instead of using sqlalchemy package to deal with database. Usually, with one orm class to map one...
Usually parents-child relationship with 3 nodes(father, mather, child): fatherX---father-child_relation--->childX, MatherX---mather-child_relation--->childX, FatherX---huaband-wife_relation--->MatherX, Is there super node-set conception or similar function which can combine sub-nodes? For example: super node-set ParentX with sub-nodes...