Advertisement
furas

Python - SQLite - executemany

Jun 11th, 2017
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 3.34 KB | None | 0 0
  1. import sqlite3
  2.  
  3. data = [
  4.     (1, 'H', 1, '1'),
  5.     (2, 'He', 1, '18'),
  6.     (3, 'Li', 2, '1'),
  7.     (4, 'Be', 2, '2'),
  8.     (5, 'B', 2, '13'),
  9.     (6, 'C', 2, '14'),
  10.     (7, 'N', 2, '15'),
  11.     (8, 'O', 2, '16'),
  12.     (9, 'F', 2, '17'),
  13.     (10, 'Ne', 2, '18'),
  14.     (11, 'Na', 3, '1'),
  15.     (12, 'Mg', 3, '2'),
  16.     (13, 'Al', 3, '13'),
  17.     (14, 'Si', 3, '14'),
  18.     (15, 'P', 3, '15'),
  19.     (16, 'S', 3, '16'),
  20.     (17, 'Cl', 3, '17'),
  21.     (18, 'Ar', 3, '18'),
  22.     (19, 'K', 4, '1'),
  23.     (20, 'Ca', 4, '2'),
  24.     (21, 'Sc', 4, '3'),
  25.     (22, 'Ti', 4, '4'),
  26.     (23, 'V', 4, '5'),
  27.     (24, 'Cr', 4, '6'),
  28.     (25, 'Mn', 4, '7'),
  29.     (26, 'Fe', 4, '8'),
  30.     (27, 'Co', 4, '9'),
  31.     (28, 'Ni', 4, '10'),
  32.     (29, 'Cu', 4, '11'),
  33.     (30, 'Zn', 4, '12'),
  34.     (31, 'Ga', 4, '13'),
  35.     (32, 'Ge', 4, '14'),
  36.     (33, 'As', 4, '15'),
  37.     (34, 'Se', 4, '16'),
  38.     (35, 'Br', 4, '17'),
  39.     (36, 'Kr', 4, '18'),
  40.     (37, 'Rb', 5, '1'),
  41.     (38, 'Sr', 5, '2'),
  42.     (39, 'Y', 5, '3'),
  43.     (40, 'Zr', 5, '4'),
  44.     (41, 'Nb', 5, '5'),
  45.     (42, 'Mo', 5, '6'),
  46.     (43, 'Tc', 5, '7'),
  47.     (44, 'Ru', 5, '8'),
  48.     (45, 'Rh', 5, '9'),
  49.     (46, 'Pd', 5, '10'),
  50.     (47, 'Ag', 5, '11'),
  51.     (48, 'Cd', 5, '12'),
  52.     (49, 'In', 5, '13'),
  53.     (50, 'Sn', 5, '14'),
  54.     (51, 'Sb', 5, '15'),
  55.     (52, 'Te', 5, '16'),
  56.     (53, 'I', 5, '17'),
  57.     (54, 'Xe', 5, '18'),
  58.     (55, 'Cs', 6, '1'),
  59.     (56, 'Ba', 6, '2'),
  60.     (72, 'Hf', 6, '4'),
  61.     (73, 'Ta', 6, '5'),
  62.     (74, 'W', 6, '6'),
  63.     (75, 'Re', 6, '7'),
  64.     (76, 'Os', 6, '8'),
  65.     (77, 'Ir', 6, '9'),
  66.     (78, 'Pt', 6, '10'),
  67.     (79, 'Au', 6, '11'),
  68.     (80, 'Hg', 6, '12'),
  69.     (81, 'Tl', 6, '13'),
  70.     (82, 'Pb', 6, '14'),
  71.     (83, 'Bi', 6, '15'),
  72.     (84, 'Po', 6, '16'),
  73.     (85, 'At', 6, '17'),
  74.     (86, 'Rn', 6, '18'),
  75.     (87, 'Fr', 7, '1'),
  76.     (88, 'Ra', 7, '2'),
  77.     (104, 'Rf', 7, '4'),
  78.     (105, 'Db', 7, '5'),
  79.     (106, 'Sg', 7, '6'),
  80.     (107, 'Bh', 7, '7'),
  81.     (108, 'Hs', 7, '8'),
  82.     (109, 'Mt', 7, '9'),
  83.     (110, 'Ds', 7, '10'),
  84.     (111, 'Rg', 7, '11'),
  85.     (112, 'Cn', 7, '12'),
  86.     (113, 'Nh', 7, '13'),
  87.     (114, 'Fl', 7, '14'),
  88.     (115, 'Mc', 7, '15'),
  89.     (116, 'Lv', 7, '16'),
  90.     (117, 'Ts', 7, '17'),
  91.     (118, 'Og', 7, '18'),
  92.     (57, 'La', 9, '4'),
  93.     (58, 'Ce', 9, '5'),
  94.     (59, 'Pr', 9, '6'),
  95.     (60, 'Nd', 9, '7'),
  96.     (61, 'Pm', 9, '8'),
  97.     (62, 'Sm', 9, '9'),
  98.     (63, 'Eu', 9, '10'),
  99.     (64, 'Gd', 9, '11'),
  100.     (65, 'Tb', 9, '12'),
  101.     (66, 'Dy', 9, '13'),
  102.     (67, 'Ho', 9, '14'),
  103.     (68, 'Er', 9, '15'),
  104.     (69, 'Tm', 9, '16'),
  105.     (70, 'Yb', 9, '17'),
  106.     (71, 'Lu', 9, '18'),
  107.     (89, 'Ac', 10, '4'),
  108.     (90, 'Th', 10, '5'),
  109.     (91, 'Pa', 10, '6'),
  110.     (92, 'U', 10, '7'),
  111.     (93, 'Np', 10, '8'),
  112.     (94, 'Pu', 10, '9'),
  113.     (95, 'Am', 10, '10'),
  114.     (96, 'Cm', 10, '11'),
  115.     (97, 'Bk', 10, '12'),
  116.     (98, 'Cf', 10, '13'),
  117.     (99, 'Es', 10, '14'),
  118.     (100, 'Fm', 10, '15'),
  119.     (101, 'Md', 10, '16'),
  120.     (102, 'No', 10, '17'),
  121.     (103, 'Lr', 10, '18'),
  122. ]
  123.  
  124. conn = sqlite3.connect('RAMAN.db')
  125.  
  126. c = conn.cursor()
  127.  
  128. c.execute('CREATE TABLE IF NOT EXISTS element (id integer, name char(2), a integer, b char(2));')
  129. conn.commit()
  130.  
  131. #for row in data:
  132. #    c.execute("INSERT INTO element VALUES (?, ?, ?, ?)",  row);
  133.  
  134. c.executemany("INSERT INTO element VALUES (?, ?, ?, ?)",  data);
  135. conn.commit()
  136.  
  137. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement