<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="et">
	<id>http://www.lambda.ee/w/index.php?action=history&amp;feed=atom&amp;title=Salvesta.py</id>
	<title>Salvesta.py - Redigeerimiste ajalugu</title>
	<link rel="self" type="application/atom+xml" href="http://www.lambda.ee/w/index.php?action=history&amp;feed=atom&amp;title=Salvesta.py"/>
	<link rel="alternate" type="text/html" href="http://www.lambda.ee/w/index.php?title=Salvesta.py&amp;action=history"/>
	<updated>2026-11-19T04:44:03Z</updated>
	<subtitle>Selle lehekülje redigeerimiste ajalugu</subtitle>
	<generator>MediaWiki 1.43.11</generator>
	<entry>
		<id>http://www.lambda.ee/w/index.php?title=Salvesta.py&amp;diff=8278&amp;oldid=prev</id>
		<title>Irve – 26. märts 2012, kell 18:43</title>
		<link rel="alternate" type="text/html" href="http://www.lambda.ee/w/index.php?title=Salvesta.py&amp;diff=8278&amp;oldid=prev"/>
		<updated>2012-03-26T18:43:31Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;et&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;←Vanem redaktsioon&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Redaktsioon: 26. märts 2012, kell 20:43&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l5&quot;&gt;5. rida:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;5. rida:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;import sqlite3 as sqlite&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;import sqlite3 as sqlite&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;databasefile = &#039;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;/tmp/&lt;/del&gt;data.db&#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;databasefile = &#039;data.db&#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;tables = [&amp;#039;t0&amp;#039;,&amp;#039;t1&amp;#039;,&amp;#039;t2&amp;#039;,&amp;#039;t3&amp;#039;,&amp;#039;t4&amp;#039;]&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;tables = [&amp;#039;t0&amp;#039;,&amp;#039;t1&amp;#039;,&amp;#039;t2&amp;#039;,&amp;#039;t3&amp;#039;,&amp;#039;t4&amp;#039;]&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;fields = [&amp;#039;salvestaja&amp;#039;,&amp;#039;f0&amp;#039;,&amp;#039;f1&amp;#039;,&amp;#039;f2&amp;#039;,&amp;#039;f3&amp;#039;,&amp;#039;f4&amp;#039;,&amp;#039;f5&amp;#039;,&amp;#039;f6&amp;#039;,&amp;#039;f7&amp;#039;,&amp;#039;f8&amp;#039;,&amp;#039;f9&amp;#039;,&amp;#039;f10&amp;#039;,&amp;#039;f11&amp;#039;,&amp;#039;f12&amp;#039;,&amp;#039;f13&amp;#039;,&amp;#039;f14&amp;#039;,&amp;#039;f15&amp;#039;,&amp;#039;f16&amp;#039;,&amp;#039;f17&amp;#039;,&amp;#039;f18&amp;#039;,&amp;#039;f19&amp;#039;]&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;fields = [&amp;#039;salvestaja&amp;#039;,&amp;#039;f0&amp;#039;,&amp;#039;f1&amp;#039;,&amp;#039;f2&amp;#039;,&amp;#039;f3&amp;#039;,&amp;#039;f4&amp;#039;,&amp;#039;f5&amp;#039;,&amp;#039;f6&amp;#039;,&amp;#039;f7&amp;#039;,&amp;#039;f8&amp;#039;,&amp;#039;f9&amp;#039;,&amp;#039;f10&amp;#039;,&amp;#039;f11&amp;#039;,&amp;#039;f12&amp;#039;,&amp;#039;f13&amp;#039;,&amp;#039;f14&amp;#039;,&amp;#039;f15&amp;#039;,&amp;#039;f16&amp;#039;,&amp;#039;f17&amp;#039;,&amp;#039;f18&amp;#039;,&amp;#039;f19&amp;#039;]&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;

&lt;!-- diff cache key lambdadb:diff:1.41:old-6744:rev-8278:php=table --&gt;
&lt;/table&gt;</summary>
		<author><name>Irve</name></author>
	</entry>
	<entry>
		<id>http://www.lambda.ee/w/index.php?title=Salvesta.py&amp;diff=6744&amp;oldid=prev</id>
		<title>Tammet – 19. märts 2009, kell 16:18</title>
		<link rel="alternate" type="text/html" href="http://www.lambda.ee/w/index.php?title=Salvesta.py&amp;diff=6744&amp;oldid=prev"/>
		<updated>2009-03-19T16:18:55Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Uus lehekülg&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;br /&gt;
#!/usr/bin/python&lt;br /&gt;
import sys&lt;br /&gt;
import cgi&lt;br /&gt;
import sqlite3 as sqlite&lt;br /&gt;
&lt;br /&gt;
databasefile = &amp;#039;/tmp/data.db&amp;#039;&lt;br /&gt;
tables = [&amp;#039;t0&amp;#039;,&amp;#039;t1&amp;#039;,&amp;#039;t2&amp;#039;,&amp;#039;t3&amp;#039;,&amp;#039;t4&amp;#039;]&lt;br /&gt;
fields = [&amp;#039;salvestaja&amp;#039;,&amp;#039;f0&amp;#039;,&amp;#039;f1&amp;#039;,&amp;#039;f2&amp;#039;,&amp;#039;f3&amp;#039;,&amp;#039;f4&amp;#039;,&amp;#039;f5&amp;#039;,&amp;#039;f6&amp;#039;,&amp;#039;f7&amp;#039;,&amp;#039;f8&amp;#039;,&amp;#039;f9&amp;#039;,&amp;#039;f10&amp;#039;,&amp;#039;f11&amp;#039;,&amp;#039;f12&amp;#039;,&amp;#039;f13&amp;#039;,&amp;#039;f14&amp;#039;,&amp;#039;f15&amp;#039;,&amp;#039;f16&amp;#039;,&amp;#039;f17&amp;#039;,&amp;#039;f18&amp;#039;,&amp;#039;f19&amp;#039;]&lt;br /&gt;
    &lt;br /&gt;
print &amp;#039;Content-type: text/plain&amp;#039;&lt;br /&gt;
print&lt;br /&gt;
&lt;br /&gt;
try:&lt;br /&gt;
  form = cgi.FieldStorage()&lt;br /&gt;
  &lt;br /&gt;
  if form.has_key(&amp;#039;table&amp;#039;) and form[&amp;#039;table&amp;#039;].value in tables:&lt;br /&gt;
    tablename=form[&amp;#039;table&amp;#039;].value&lt;br /&gt;
  else:&lt;br /&gt;
    print &amp;quot;0&amp;quot;&lt;br /&gt;
    sys.exit(0) &lt;br /&gt;
  &lt;br /&gt;
  query=&amp;quot;insert into %s&amp;quot; % tablename&lt;br /&gt;
&lt;br /&gt;
  flds=&amp;quot;&amp;quot;&lt;br /&gt;
  vals=&amp;quot;&amp;quot;  &lt;br /&gt;
  for el in fields:&lt;br /&gt;
    if form.has_key(el):&lt;br /&gt;
      flds=flds+&amp;quot; &amp;quot;+el+&amp;quot;,&amp;quot;&lt;br /&gt;
      vals=vals+&amp;quot; &amp;#039;&amp;quot;+form[el].value.replace(&amp;#039;&amp;quot;&amp;#039;, &amp;#039; &amp;#039;).replace(&amp;quot;&amp;#039;&amp;quot;, &amp;quot; &amp;quot;)+&amp;quot;&amp;#039;,&amp;quot;  &lt;br /&gt;
  if not flds:&lt;br /&gt;
    print &amp;quot;0&amp;quot;&lt;br /&gt;
&lt;br /&gt;
  else:&lt;br /&gt;
    if flds[len(flds)-1]==&amp;quot;,&amp;quot;:&lt;br /&gt;
      flds=flds[0:len(flds)-1]&lt;br /&gt;
    if vals[len(vals)-1]==&amp;quot;,&amp;quot;:&lt;br /&gt;
      vals=vals[0:len(vals)-1]    &lt;br /&gt;
    query=query+&amp;quot;(&amp;quot;+flds+&amp;quot;) values (&amp;quot;+vals+&amp;quot;)&amp;quot;   &lt;br /&gt;
&lt;br /&gt;
    #print query # uncomment for debugging&lt;br /&gt;
&lt;br /&gt;
    con = sqlite.connect(databasefile)&lt;br /&gt;
    cur = con.cursor()&lt;br /&gt;
    cur.execute(query)&lt;br /&gt;
    con.commit()&lt;br /&gt;
    print &amp;quot;1&amp;quot;&lt;br /&gt;
except Exception, e:&lt;br /&gt;
  #print e # uncommment for debugging&lt;br /&gt;
  print &amp;quot;0&amp;quot;&lt;br /&gt;
  &lt;br /&gt;
&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Tammet</name></author>
	</entry>
</feed>