DokuWiki

Site Tools

Trace: • autossh • echecker
Hotfix release available: 2025-05-14b "Librarian". upgrade now! [56.2] (what's this?)
Hotfix release available: 2025-05-14a "Librarian". upgrade now! [56.1] (what's this?)
New release available: 2025-05-14 "Librarian". upgrade now! [56] (what's this?)
Hotfix release available: 2024-02-06b "Kaos". upgrade now! [55.2] (what's this?)
nnn:lager

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
nnn:lager [2012/02/15 15:10] – 172.22.1.222nnn:lager [2024/04/15 00:43] (current) – external edit 127.0.0.1
Line 8: Line 8:
   - python manage.py syncdb   - python manage.py syncdb
   - ns@s222:~/sw/lager/lv$ python manage.py startapp lager   - ns@s222:~/sw/lager/lv$ python manage.py startapp lager
 +
 +====== sqlite3 DB======
 +===== Backup =====
 +  - DUMP:$  echo ".dump" |sqlite3 lv.db >lv.sql
 +  - RESTORE: cat lv.sql | sqlite3 lv.db
 +===== Unique ändern =====
 +  - dump datenbank
 +  - gvim lv.sql - UNIQUE in CREATE Table ändern/entfernen
 +  - mv lv.db lvzz.db (sichern oder entfernen)
 +  - RESTORE
 +  - ggf. unque in django/models anpassen
 +   
 +===== Feld bzw. Column hinzufügen =====
 +ALTER TABLE {tableName} ADD COLUMN COLNew {type};
 + 
 ====== Programmierung ====== ====== Programmierung ======
 ===== manage.py ===== ===== manage.py =====
Line 14: Line 29:
   - weitere Befehle: python manage.py help   - weitere Befehle: python manage.py help
  
 +==== Datenbank löschen ====
 +  - Löschkommandos anzeigen: python manage.py sqlclear lager
 +  - DB-shell aufrufen:  python manage.py dbshell
 +  - mit copy+paste löschkommandos in shell übertragen und ausführen
 +  - dbshell mit .quit verlassen (sql3)
 +  - Neue DB anlegen:  python manage.py sql lager
 +  - und synchronisieren: python manage.py syncdb
  
  
  
nnn/lager.1329315041.txt.gz · Last modified: 2024/04/15 00:43 (external edit)