lazzyfu / yasql Goto Github PK
View Code? Open in Web Editor NEW集MySQL数据库工单和数据查询的Web平台
License: MIT License
集MySQL数据库工单和数据查询的Web平台
License: MIT License
工单系统执行 sql出现 语法错误,在服务器端及 Navicat 都可以运行成功。
sql如下:
55 (SELECT b.*
56 FROM um AS b
57 join
58 (select um_no
59 from um_d where license_status ='01' limit 2290010,10) a on a.um_no=b.um_no
时间:2019/9/23 上午10:16:58
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 '' at line 59
正在执行导出SQL: select * from pay_package_deals_details p where p.trader_type='一般纳税人' and p.invoice_type='增值税专用发票'
正在处理并生成CSV数据
正在压缩文件: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv -> export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv.zip
7-Zip (a) [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,2 CPUs Intel(R) Xeon(R) CPU E7-4830 v2 @ 2.20GHz (306E7),ASM,AES-NI)
Scanning the drive:
1 file, 17177 bytes (17 KiB)
Creating archive: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv.zip
Items to compress: 1
Files read from disk: 1
Archive size: 2980 bytes (3 KiB)
Everything is Ok
删除临时文件: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv
删除临时文件: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv.zip
执行耗时: 0.059
该系统支持配置https支持,需要手动修改如下代码:
https流程:
web --> https(自己部署的ssl证书) --> docker(nginx)
vim static/c_websocket.js
let socket = new WebSocket('ws://' + window.location.host + '/ws/');
修改为:
let socket = new WebSocket('wss://' + window.location.host + '/ws/');
vim templates/sqlquery/sql_query.html
let socket = new WebSocket('ws://' + window.location.host + '/ws/');
修改为:
let socket = new WebSocket('wss://' + window.location.host + '/ws/');
vim templates/webshell/webshell.html
sock = new WebSocket('ws://' + window.location.host + '/ssh/'),
修改为:
sock = new WebSocket('wss://' + window.location.host + '/ssh/'),
請問如何正確重啟Incecption?
kill -9 inception
./opt/inception/bin/Inception --defaults-file=/etc/inception.cnf &
AUTH_LDAP_BIND_DN = "uid=root,cn=root,cn=root,dc=xinchanedu,dc=com"
这两个cn是写原来DEMO里的,还是写UID的,我的一直不行
一次提交了9K多条dml语句,语法检查报错413
你这块角色权限是需要手动插入数据吧,默认没有角色权限数据,后台管理我看你代码也是关了着的
2019-05-22 14:48:31,344 [uWSGIWorker4Core0:140672907941952] [django.request:228] [log:log_response] [WARNING]- Forbidden (Permission denied): /admin/query/mysqlusergroupmap/add/
Traceback (most recent call last):
File "/venv_py36/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/venv_py36/lib/python3.6/site-packages/django/core/handlers/base.py", line 126, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/venv_py36/lib/python3.6/site-packages/django/core/handlers/base.py", line 124, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 604, in wrapper
return self.admin_site.admin_view(view)(*args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
response = view_func(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/sites.py", line 223, in inner
return view(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 1637, in add_view
return self.changeform_view(request, None, form_url, extra_context)
File "/venv_py36/lib/python3.6/site-packages/django/utils/decorators.py", line 45, in _wrapper
return bound_method(*args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 1525, in changeform_view
return self._changeform_view(request, object_id, form_url, extra_context)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 1542, in _changeform_view
raise PermissionDenied
django.core.exceptions.PermissionDenied
Hello,请问此平台可以mac本地安装开发环境么,是否有相应文档呢
作者鼓励二开,但是我看协议是gpLv3,使用担心有污染风险 公司内部不允许使用。
docker部署的文档怎么了,能否提供docker部署的
(auditsql) [root@devops opsql]# celery worker -A opsql --loglevel=INFO --time-limit=7200 --concurrency=10 --uid=nginx
Traceback (most recent call last):
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/kombu/utils/objects.py", line 42, in __get__
KeyError: 'Worker'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/root/.virtualenvs/auditsql/bin/celery", line 10, in <module>
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/__main__.py", line 16, in main
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 322, in main
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 496, in execute_from_commandline
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/base.py", line 275, in execute_from_commandline
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 488, in handle_argv
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 420, in execute
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/worker.py", line 223, in run_from_argv
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/base.py", line 238, in __call__
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/worker.py", line 252, in run
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/kombu/utils/objects.py", line 44, in __get__
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/app/base.py", line 1100, in Worker
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/app/base.py", line 1026, in subclass_with_self
File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/kombu/utils/imports.py", line 56, in symbol_by_name
File "/root/.virtualenvs/auditsql/lib/python3.6/importlib/__init__.py", line 126, in import_module
File "<frozen importlib._bootstrap>", line 994, in _gcd_import
File "<frozen importlib._bootstrap>", line 971, in _find_and_load
File "<frozen importlib._bootstrap>", line 941, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "<frozen importlib._bootstrap>", line 994, in _gcd_import
File "<frozen importlib._bootstrap>", line 971, in _find_and_load
File "<frozen importlib._bootstrap>", line 953, in _find_and_load_unlocked
ModuleNotFoundError: No module named 'celery.apps'
(auditsql) [root@devops opsql]# pwd
/data/web/opsql
(auditsql) [root@devops opsql]#
(auditsql) [root@devops opsql]# python -m pip freeze
aioredis==1.2.0
amqp==2.4.2
asgiref==2.3.2
asn1crypto==0.24.0
astroid==2.2.5
async-timeout==3.0.1
attrs==19.1.0
autobahn==19.2.1
Automat==0.7.0
bcrypt==3.1.6
billiard==3.5.0.5
celery==4.2.1
certifi==2019.3.9
cffi==1.12.2
channels==2.1.7
channels-redis==2.3.3
chardet==3.0.4
constantly==15.1.0
cryptography==2.6.1
daphne==2.2.5
DingtalkChatbot==1.3.0
Django==2.2.3
django-auth-ldap==1.7.0
django-celery-beat==1.4.0
django-celery-results==1.0.4
django-redis==4.10.0
django-stubs==1.0.2
django-timezone-field==3.0
djangorestframework==3.9.2
djangorestframework-stubs==0.3.0
et-xmlfile==1.0.1
gevent==1.4.0
greenlet==0.4.15
hiredis==1.0.0
humanfriendly==4.18
hyperlink==18.0.0
idna==2.8
incremental==17.5.0
isort==4.3.20
jdcal==1.4
kombu==4.4.0
lazy-object-proxy==1.4.1
mccabe==0.6.1
meld3==1.0.2
msgpack==0.6.1
mypy==0.720
mypy-extensions==0.4.1
mysql-replication==0.18
mysqlclient==1.3.13
openpyxl==2.6.1
paramiko==2.4.2
Pillow==5.4.1
pyasn1==0.4.5
pyasn1-modules==0.2.4
pycparser==2.19
PyHamcrest==1.9.0
pylint==2.3.1
PyMySQL==0.9.3
PyNaCl==1.3.0
python-crontab==2.3.6
python-dateutil==2.8.0
python-ldap==3.2.0
pytz==2018.9
redis==3.2.0
requests==2.21.0
simplejson==3.16.0
six==1.12.0
sqlparse==0.3.0
supervisor==4.0.4
Twisted==19.2.1
txaio==18.8.1
typed-ast==1.3.5
typing-extensions==3.7.4
urllib3==1.24.2
uWSGI==2.0.18
vine==1.2.0
wrapt==1.11.1
zope.interface==4.6.0
请问这个可以用windows的pycharm开发工具运行吗?或者有没用教程呢,我运行不起来
DML语句执行成功,备份一直不可以。这个具体还需要怎么配置,他备份的的sql或者文件是存在那里
(yasql) [root@10-77-10-166 yasql]# python3 manage.py migrate
段错误(吐核)
开发者,您好,可以支持一下postgresql吗?
这是非常伟大的一款产品,但希望可以支持一下postgresql,谢谢
執行gh-ost遇到註解為中文的報錯問題
'ascii' codec can't encode characters in position 343-348: ordinal not in range(128)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.