-
Notifications
You must be signed in to change notification settings - Fork 0
/
TIPS.txt
33 lines (24 loc) · 1.46 KB
/
TIPS.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
=== Useful SQLs ===
CREATE TABLE objects (name TEXT, id TEXT, field TEXT, value TEXT);
CREATE INDEX i_objects ON objects (name, id, field);
=== Packages to install ===
cpanm Mojolicious Crypt::SaltedHash Data::UUID DBI DBD::SQLite List::MoreUtils \
Hash::Merge::Simple Locale::Currency::Format Mojolicious::Plugin::RenderFile \
Hash::Merge::Simple Text::CSV_XS Test::Most Test::Deep Test::NoWarnings CHI EV \
Spreadsheet::WriteExcel WWW::Telegram::BotAPI Mojolicious::Plugin::AdditionalValidationChecks
OR just:
cpm install -g
=== Documents and business transactions ===
Documents contains sum ammont
=== find some text ===
find templates/ -type f -print | xargs grep "is_admin"
=== dump sqlte database files between servers ===
echo '.dump' | sqlite3 db/main.db | gzip -c > db/dump/main.db.dump.gz
zcat db/dump/main.db.dump.gz | sqlite3 db/main.db
echo '.dump' | sqlite3 db/clients/2013.05.08\ 15\:52\:30\ C36993F0.db | gzip -c > db/dump/2013.05.08\ 15\:52\:30\ C36993F0.db.dump.gz
echo '.dump' | sqlite3 db/clients/2013.05.08\ 15\:48\:32\ 359B6B84.db | gzip -c > db/dump/2013.05.08\ 15\:48\:32\ 359B6B84.db.dump.gz
zcat db/dump/2013.05.08\ 15\:52\:30\ C36993F0.db.dump.gz | sqlite3 db/clients/2013.05.08\ 15\:52\:30\ C36993F0.db
zcat db/dump/2013.05.08\ 15\:48\:32\ 359B6B84.db.dump.gz | sqlite3 db/clients/2013.05.08\ 15\:48\:32\ 359B6B84.db
=== TBot ===
[TBot:ColvirTextD72Links]
https://api.telegram.org/bot6938590791:AAFOkQDDcOiq6LUZ1vHniC06jUlWIYxpgTE/getWebHookInf