Awesome kupy created by ryanzhang
Project description
先创建一个数据库sandbox
创建表
create schema kupy;
CREATE TABLE IF NOT EXISTS kupy.sync_status (
id BIGINT NOT NULL,
table_name VARCHAR(255),
rc boolean,
update_time TIMESTAMP,
comment VARCHAR(255),
PRIMARY KEY (id)
);
create table kupy.fund (
id bigint not null,
sec_id varchar(255),
ticker varchar(255),
sec_short_name varchar(255),
trade_abbr_name varchar(255),
category varchar(255),
operation_mode varchar(255),
index_fund varchar(255),
etf_lof varchar(255),
is_qdii boolean,
is_fof boolean,
is_guar_fund boolean,
guar_period float,
guar_ratio float,
exchange_cd varchar(255),
list_status_cd varchar(255),
manager_name varchar(255),
status varchar(255),
establish_date date,
list_date date,
delist_date date,
expire_date date,
management_company integer,
management_full_name varchar(255),
custodian integer,
custodian_full_name varchar(255),
invest_field varchar(3072),
invest_target varchar(2048),
perf_benchmark varchar(255),
circulation_shares float,
is_class integer,
idx_id varchar(255),
idx_ticker varchar(255),
idx_short_name varchar(255),
management_short_name varchar(255),
custodian_short_name varchar(255),
sec_full_name varchar(255),
class_name varchar(255),
primary key (id)
);
CREATE SEQUENCE IF NOT EXISTS kupy.fund_id_seq START WITH 1 INCREMENT BY 1;
CREATE UNIQUE INDEX IF NOT EXISTS fund_idx ON kupy.fund(sec_id);
INSERT INTO kupy.sync_status(id, table_name) VALUES(1, 'equity');
INSERT INTO kupy.sync_status(id, table_name) VALUES(2, 'equity_industry');
INSERT INTO kupy.sync_status(id, table_name) VALUES(3, 'equ_share');
INSERT INTO kupy.sync_status(id, table_name) VALUES(4, 'fund');
INSERT INTO kupy.sync_status(id, table_name) VALUES(5, 'fund_day');
INSERT INTO kupy.sync_status(id, table_name) VALUES(6, 'idx');
INSERT INTO kupy.sync_status(id, table_name) VALUES(7, 'mkt_equ_day');
INSERT INTO kupy.sync_status(id, table_name) VALUES(8, 'mkt_idx_day');
INSERT INTO kupy.sync_status(id, table_name) VALUES(9, 'trade_calendar');
insert into kupy.fund(id, sec_id, ticker, sec_short_
name, list_status_cd) values(1, '000001.XSHE', '000001', '
平安基金', 'L');
insert into kupy.fund(id, sec_id, ticker, sec_short_
name, list_status_cd) values(2, '501216.XSHE', '501216', '
测试基金', 'UN');
Grant permission on user
GRANT CONNECT ON DATABASE sandbox TO "user";
GRANT USAGE ON SCHEMA kupy TO "user";
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA kupy TO "user";
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
kupy-0.1.5.tar.gz
(20.6 kB
view hashes)
Built Distribution
kupy-0.1.5-py2-none-any.whl
(8.3 kB
view hashes)