def unpack_csv(line):
csv = line.split(";")
csv_1 = csv[0]
csv_2 = csv[1]
...
return csv_1, csv_2, csv_3, csv_4, csv_5
db = pymysql.connect(host='', user='', passwd='', db='', charset='utf8')
cursor = db.cursor()
file = open('test.csv', 'r')
for line in file:
number, date, fio, email, about = unpack_csv(line)
sql = """INSERT INTO mydb(number, date, fio, email, about)
VALUES ('%s','%s', '%s', '%s', '%s')
""", (number, date, fio, email, about)
cursor.execute(sql)
db.commit()
db.close()
file.close()
.rotate(@degrees,@size) {
-moz-transform: rotate(~"@{degrees}deg") translate(@size, 0px);
-o-transform: rotate(~"@{degrees}deg") translate(@size, 0px);
-webkit-transform: rotate(~"@{degrees}deg") translate(@size, 0px);
transform: rotate(~"@{degrees}deg") translate(@size, 0px);
}
var from= new Date(2013, 5, 12);
var to= new Date(2016, 2, 25);
getRange(from, to);
function getRange(dateFrom, dateTo) {
var dayRange = (dateTo - dateFrom)/(1000 * 60 * 60 * 24);
var result = {};
for(var i = 0; i < dayRange; i++) {
if (typeof result[dateFrom.getFullYear()] == "undefined")
result[dateFrom.getFullYear()] = {};
if (typeof result[dateFrom.getFullYear()][dateFrom.getMonth()+1] == "undefined")
result[dateFrom.getFullYear()][dateFrom.getMonth()+1] = [];
result[dateFrom.getFullYear()][dateFrom.getMonth()+1].push(dateFrom.getDate());
dateFrom.setDate(dateFrom.getDate() + 1);
}
return result;
}