Coder Social home page Coder Social logo

dataintegrationalliance / data_integration_celery Goto Github PK

View Code? Open in Web Editor NEW
282.0 17.0 120.0 1.29 MB

通过celery定期执行更相关任务,将万得wind,同花顺ifind,东方财富choice、Tushrae、JQDataSDK、pytdx、CMC等数据终端的数据进行整合,清洗,一致化,供其他系统数据分析使用

License: GNU General Public License v3.0

Python 99.38% Batchfile 0.05% Shell 0.08% Jupyter Notebook 0.49%

data_integration_celery's Issues

stock.py 出错

sqlalchemy.exc.ProgrammingError: (mysql_exceptions.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{table_name} (wind_code, trade_code, sec_name, ipo_date, delist_date, mkt, exch' at line 1") [SQL: 'REPLACE INTO {table_name} (wind_code, trade_code, sec_name, ipo_date, delist_date, mkt, exch_city, exch_eng, prename) values (%s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: (('000686.SZ', '000686', '东北证券', '1997-02-27', None, '主板', '深圳', 'SZSE', '锦州六陆;S锦六陆'), ('002293.SZ', '002293', '罗莱生活', '2009-09-10', None, '中小企业板', '深圳', 'SZSE', '罗莱家纺'), ('002171.SZ', '002171', '楚江新材', '2007-09-21', None, '中小企业板', '深圳', 'SZSE', '精诚铜业'), ('603233.SH', '603233', '大参林', '2017-07-31', None, '主板', '上海', 'SSE', None), ('300739.SZ', '300739', '明阳电路', '2018-02-01', None, '创业板', '深圳', 'SZSE', None), ('603056.SH', '603056', '德邦股份', '2018-01-16', None, '主板', '上海', 'SSE', None), ('000807.SZ', '000807', '云铝股份', '1998-04-08', None, '主板', '深圳', 'SZSE', '云铝股份;G云铝'), ('002286.SZ', '002286', '保龄宝', '2009-08-28', None, '中小企业板', '深圳', 'SZSE', None) ... displaying 10 of 3536 total bound parameter sets ... ('603889.SH', '603889', '新澳股份', '2014-12-31', None, '主板', '上海', 'SSE', None), ('300290.SZ', '300290', '荣科科技', '2012-02-16', None, '创业板', '深圳', 'SZSE', None))] (Background on this error at: http://sqlalche.me/e/f405)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.