Python中文网 - 问答频道, 解决您学习工作中的Python难题和Bug
Python常见问题
我对python和javascript的基本知识还不熟悉编程。我需要以下方面的帮助。你知道吗
我在web服务器上有一个python脚本。脚本输出一个“.csv”文件。（请在下面找到脚本）
任何通过链接访问web服务器的用户都需要在web服务器中触发python脚本。一旦在web服务器中生成了csv文件，用户就可以单击链接中的按钮在其本地计算机中下载csv文件。这将在内部网中使用。你知道吗
问题：我已经设置了一个apacheweb服务器。但是我也不能在web服务器上从浏览器运行python脚本。请帮忙。你知道吗
Apache日志：[2016年11月5日星期六01:14:23.341480][cgi:错误][pid 9572:tid 936]（9）错误的文件描述符：[client 127.0.0.1:49729]AH01222:不知道如何生成子进程：C:/Users/dasa17/mywebsite/花名册.py你知道吗
独立的python脚本运行良好，提供了所需的输出。请找到下面的脚本：
import os
import csv
import pymysql
import pymysql.cursors
from datetime import date
import calendar
d=date.today()
num_days = calendar.monthrange(d.year,d.month)[1]
days = [(d.year,d.month,day) for day in range(1, num_days+1)]
dayssl=["%s-%s-%s" %z for z in days] #Create a list of strings for the CSV output header
IT = pymysql.connect(host='xxxxxxx', user='xxxxx', password='xxxx',
db='xxxx')#Connect to the IT database
Others = pymysql.connect(host='xxxxx', user='xxxx', password='xxxx',
db='xxxx')#Connect to the non IT database
a=IT.cursor() # Open Cursor for IT database
b=Others.cursor()#Open Cursor for non-IT database
# Create a string to query the IT database
u='''select e.mgrntid,
(case when e.verticalorg = 27 then 'HR'
when e.verticalorg = 2 then 'IT'
when e.verticalorg = 30 then 'GBS'
when e.verticalorg = 4 then 'GBS - Technical'
when e.verticalorg = 5 then 'DPAS'
when e.verticalorg = 6 then 'VIPR'
when e.verticalorg = 6 then 'VMAX'
when e.verticalorg = 6 then 'ASD+ SRM'
when e.verticalorg = 6 then 'VNX'
end) as verticalorg,s.employee_id,
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-01') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-01',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-02') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-02',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-03') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-03',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-04') as DATE)THEN s.forecasted_shift ELSE NULL END) AS '2016-10-04' ,
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-05') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-05',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-06') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-06',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-07') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-07',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-08') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-08',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-09') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-09',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-10') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-10',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-11') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-11',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-12') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-12',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-13') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-13',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-14') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-14',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-15') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-15',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-16') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-16',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-17') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-17',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-18') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-18',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-19') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-19',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-20') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-20',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-21') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-21',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-22') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-22',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-23') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-23',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-24') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-24',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-25') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-25',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-26') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-26',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-27') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-27',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-28') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-28',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-29') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-29',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-30') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-30',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-31') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-31'
from shift_roster s LEFT JOIN tbl_employeedetails e on s.employee_id=e.empntid where s.shift_date >= CAST(DATE_FORMAT(NOW() ,'%Y-%m- 01') as DATE) GROUP BY s.employee_id ORDER BY e.verticalorg'''
a.execute(u)#Execute the query in the database
#Create a string for non IT database
v='''select e.mgrntid,
(case when e.verticalorg = 18 then 'CS'
when e.verticalorg = 19 then 'PS'
when e.verticalorg = 25 then 'MS'
when e.verticalorg = 26 then 'PE'
when e.verticalorg = 27 then 'HR'
when e.verticalorg = 28 then 'RSA'
end) as verticalorg,s.employee_id,
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-01') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-01',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-02') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-02',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-03') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-03',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-04') as DATE)THEN s.forecasted_shift ELSE NULL END) AS '2016-10-04' ,
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-05') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-05',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-06') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-06',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-07') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-07',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-08') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-08',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-09') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-09',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-10') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-10',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-11') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-11',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-12') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-12',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-13') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-13',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-14') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-14',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-15') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-15',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-16') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-16',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-17') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-17',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-18') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-18',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-19') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-19',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-20') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-20',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-21') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-21',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-22') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-22',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-23') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-23',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-24') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-24',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-25') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-25',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-26') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-26',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-27') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-27',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-28') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-28',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-29') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-29',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-30') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-30',
MAX(CASE WHEN s.shift_date=CAST(DATE_FORMAT(NOW() ,'%Y-%m-31') as DATE) THEN s.forecasted_shift ELSE NULL END) AS '2016-10-31'
from shift_roster s LEFT JOIN tbl_employeedetails e on s.employee_id=e.empntid where s.shift_date >= CAST(DATE_FORMAT(NOW() ,'%Y-%m- 01') as DATE) GROUP BY s.employee_id ORDER BY e.verticalorg'''
b.execute(v) #Execute the query in the non-IT database
result_IT=a.fetchall() #Fetch all data from Curor for IT database
result_Others=b.fetchall()#Fetch all data from Curor for non IT database
Filename = os.getenv("HOMEDRIVE") + os.getenv("HOMEPATH") + "\\Desktop\RosterUnified.csv" # Create/write a CSV file in the user's desktop
d=open(Filename, 'w',newline='\n') #Format for CSV input
c = csv.writer(d)
c.writerow(["Manager NT ID"," Vertical Org","Employee ID" ]+ dayssl)# Write the header list of strings in the first row
for row in result_IT:
c.writerow(row)#Write output for IT to csv
d.close()
e=open(Filename, 'a',newline='\n')
f= csv.writer(e)
for row in result_Others:
f.writerow(row)# Append to the existing CSV file with non IT data
e.close()#Close the CSV file
a.close()#Close IT cursor
b.close()#Close non IT cursor
Tags： formatdateshiftasnullelsenowmax
热门问题
- 是什么导致导入库时出现这种延迟？
- 是什么导致导入时提交大内存
- 是什么导致导入错误：“没有名为modules的模块”？
- 是什么导致局部变量引用错误？
- 是什么导致循环中的属性错误以及如何解决此问题
- 是什么导致我使用kivy的代码内存泄漏？
- 是什么导致我在python2.7中的代码中出现这种无意的无限循环？
- 是什么导致我的ATLAS工具在尝试构建时失败？
- 是什么导致我的Brainfuck transpiler的输出C文件中出现中止陷阱？
- 是什么导致我的Django文件上载代码内存峰值？
- 是什么导致我的json文件在添加kivy小部件后重置？
- 是什么导致我的python 404检查脚本崩溃/冻结？
- 是什么导致我的Python脚本中出现这种无效语法错误？
- 是什么导致我的while循环持续时间延长到12分钟？
- 是什么导致我的代码膨胀文本文件的大小？
- 是什么导致我的函数中出现“ValueError:cannot convert float NaN to integer”
- 是什么导致我的安跑的时间大大减少了？
- 是什么导致我的延迟触发，除了添加回调、启动反应器和连接端点之外什么都没做？
- 是什么导致我的条件[Python]中出现缩进错误
- 是什么导致我的游戏有非常低的fps
热门文章
- Python覆盖写入文件
- 怎样创建一个 Python 列表？
- Python3 List append()方法使用
- 派森语言
- Python List pop()方法
- Python Django Web典型模块开发实战
- Python input() 函数
- Python3 列表(list) clear()方法
- Python游戏编程入门
- 如何创建一个空的set?
- python如何定义(创建)一个字符串
- Python标准库 [The Python Standard Library by Ex
- Python网络数据爬取及分析从入门到精通（分析篇）
- Python3 for 循环语句
- Python List insert() 方法
- Python 字典(Dictionary) update()方法
- Python编程无师自通 专业程序员的养成
- Python3 List count()方法
- Python 网络爬虫实战 [Web Crawler With Python]
- Python Cookbook（第2版）中文版
目前没有回答
相关问题 更多 >
编程相关推荐