basic.py 1.2 KB

123456789101112131415161718192021222324252627
  1. #!/usr/bin/env python
  2. # Licensed to the Apache Software Foundation (ASF) under one or more
  3. # contributor license agreements. See the NOTICE file distributed with
  4. # this work for additional information regarding copyright ownership.
  5. # The ASF licenses this file to You under the Apache License, Version 2.0
  6. # (the "License"); you may not use this file except in compliance with
  7. # the License. You may obtain a copy of the License at
  8. #
  9. # http://www.apache.org/licenses/LICENSE-2.0
  10. #
  11. # Unless required by applicable law or agreed to in writing, software
  12. # distributed under the License is distributed on an "AS IS" BASIS,
  13. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. # See the License for the specific language governing permissions and
  15. # limitations under the License.
  16. import phoenixdb
  17. with phoenixdb.connect('http://localhost:8765/', autocommit=True) as connection:
  18. with connection.cursor() as cursor:
  19. cursor.execute("DROP TABLE IF EXISTS test")
  20. cursor.execute("CREATE TABLE test (id INTEGER PRIMARY KEY, text VARCHAR)")
  21. cursor.executemany("UPSERT INTO test VALUES (?, ?)", [[1, 'hello'], [2, 'world']])
  22. cursor.execute("SELECT * FROM test ORDER BY id")
  23. for row in cursor:
  24. print(row)