FEAPDER 管道扩展

简介

此模块为feapder的pipelines扩展，感谢广大开发者对feapder的贡献

随着feapder支持的pipelines越来越多，为减少feapder的体积，特将pipelines提出，使用者可按需安装

管道

PostgreSQL

贡献者：沈瑞祥

联系方式：ruixiang.shen@outlook.com

安装

pip install feapder_pipelines[pgsql]

使用

在feapder项目的setting.py中使用如下配置

# PostgreSQL
PGSQL_IP = 
PGSQL_PORT = 
PGSQL_DB = 
PGSQL_USER_NAME = 
PGSQL_USER_PASS = 

ITEM_PIPELINES = [
    "feapder_pipelines.pipelines.pgsql_pipeline.PgsqlPipeline"
]

细节

注：入库时 ON CONFLICT(key) 默认为id或通过如下sql查出来的第一个值

select column_names from(
        select
            t.relname as table_name,
            i.relname as index_name,
            array_to_string(array_agg(a.attname), ', ') as column_names
        from
            pg_class t,
            pg_class i,
            pg_index ix,
            pg_attribute a
        where
            t.oid = ix.indrelid
            and i.oid = ix.indexrelid
            and a.attrelid = t.oid
            and a.attnum = ANY(ix.indkey)
            and t.relkind = 'r'
            and t.relname like '%'
        group by
            t.relname,
            i.relname
        order by
            t.relname,
            i.relname) as res
    where table_name = 'table_name';

Metadata

Release files for feapder-pipelines 1.0.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for feapder-pipelines 1.0.3
File	Size	Uploaded	Provenance	Actions
feapder_pipelines-1.0.3.tar.gz	9.2 kB	Dec 22, 2021	Without provenance	Details for feapder_pipelines-1.0.3.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for feapder-pipelines 1.0.3
File	Interpreter	ABI	Platform	Actions Reset
feapder_pipelines-1.0.3-py3-none-any.whl 9.6 kB Dec 22, 2021 Without provenance	Python 3	none	any	Details for feapder_pipelines-1.0.3-py3-none-any.whl

Total release size: 18.8 kB

Release files / feapder_pipelines-1.0.3.tar.gz

Download URL	feapder_pipelines-1.0.3.tar.gz
Size	9.2 kB
Tags	Source
SHA-256 checksum How to use checksums	`1e01dbf820c154215ca253c367d465b5c3f4c4ae5472daa4a007bcf42da823c6`
BLAKE2b-256 checksum How to use checksums	`6364239e82780a6c72a710728b6e8f74da4d9ee4b5c531de7d149c4437261a0f`
Upload date	Dec 22, 2021
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7`

Release files / feapder_pipelines-1.0.3-py3-none-any.whl

Download URL	feapder_pipelines-1.0.3-py3-none-any.whl
Size	9.6 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`ace076e28c937634db755bab512571f4aa1f2739c60ae892ab844efe436e9390`
BLAKE2b-256 checksum How to use checksums	`f785489b0ba081da694bda7f1bea9b97253a716ec9356a592442f227e2b4acb3`
Upload date	Dec 22, 2021
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.7.1 importlib_metadata/4.10.0 pkginfo/1.8.2 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7`

Security for feapder-pipelines 1.0.3

Report project as malware

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.