Skip to content

Instantly share code, notes, and snippets.

@ErDmKo
ErDmKo / xml2json.py
Last active February 25, 2023 07:58
simple convert xml to json with lxml
from lxml import etree
root = etree.fromstring(xml_str)
def xml2json(self, root):
children = root.findall('ResponseData/ResponseDataObject')[0]
def recusiv(children):
out = {}
for child in list(children):
if len(list(child)):
@ErDmKo
ErDmKo / .vimrc
Last active August 16, 2022 12:56
vim settings
colorscheme desert
set smartindent
set tabstop=4
set ruler
set nu
syntax on
set backupcopy=yes
set shiftwidth=4
set laststatus=2
set expandtab
@ErDmKo
ErDmKo / row_numbers.py
Created October 22, 2013 16:00
Django extra row number column for mySQL ROW_NUMBER()
Obj.objects.extra(select={'num': "(select @f2 := @f2 +1 from (select @f2 := 0) as t )"})
@ErDmKo
ErDmKo / new_database
Last active July 20, 2018 11:42
Sql create new database and create user.
CREATE DATABASE <BDname> CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON <BDname>.* to <user_name>@localhost identified by '<user_password>';
for crone:
mysqldump -u <user_name> '-p<user_password>' <oldBDname> | gzip > ~/$(date +/var/sqlDump/<oldBDname>.sql.%Y%m%d.gz)
gunzip < `date +/var/sqlDump/<oldBDname>.sql.%Y%m%d.gz` | mysql -u <user_name> '-p<user_password>' <BDname>
CREATE USER <un> WITH PASSWORD '<up>';
CREATE DATABASE sales ENCODING 'utf8' OWNER <un>;
<div id="d3">
sdf
<p>
1231
<a>
asdfasdf
<div id="d1">
1
</div>
</a>
@ErDmKo
ErDmKo / date_group.sql
Created January 24, 2014 12:08
Group elements by date and get elements id list from group.
SELECT DATE_FORMAT(d, "%Y%m") as month_year, GROUP_CONCAT(id SEPARATOR ',') as ids FROM events_event GROUP BY month_year LIMIT 100
@ErDmKo
ErDmKo / me.conf
Last active January 3, 2016 08:09
mysql config
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
collation_server=utf8_unicode_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
@ErDmKo
ErDmKo / loader.js
Created December 4, 2013 17:21
Image loader even caller
var onLoader = function onloader(call, selector)
{
var loaderTimer = setInterval(function()
{
if (
!$(selector).filter(function()
{
return !this.complete
}).length
)
data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==
@ErDmKo
ErDmKo / content_type.py
Created October 11, 2013 15:49
Python content_type get from django datebase field
import magic
with magic.Magic(flags=magic.MAGIC_MIME_TYPE) as m:
content_type = m.id_filename(self.file._get_path())