예제 #1
0
void table_delete(const std::string &table_name, mysql::Row_of_fields &fields) {

    std::cout << "DELETE FROM "
    << table_name
    << " WHERE ";

    mysql::Row_of_fields::iterator field_it = fields.begin();
    int field_id = 0;
    mysql::Converter converter;
    do {

        std::string str;
        converter.to(str, *field_it);
        if (is_text_field(*field_it))
            std::cout << field_id << "= " << '\'' << str << '\'';
        else
            std::cout << field_id << "= " << str;

        ++field_it;
        ++field_id;
        if (field_it != fields.end())
            std::cout << " AND ";
    } while (field_it != fields.end());
    std::cout << " LIMIT 1" << std::endl;
}
예제 #2
0
void table_insert(const std::string &table_name, mysql::Row_of_fields &fields) {

    std::cout << "INSERT INTO "
    << table_name
    << " VALUES (";

    mysql::Row_of_fields::iterator field_it = fields.begin();
    mysql::Converter converter;
    do {
        /*
         Each row contains a vector of Value objects. The converter
         allows us to transform the value into another
         representation.
        */
        std::string str;
        converter.to(str, *field_it);
        if (is_text_field(*field_it))
            std::cout << '\'' << str << '\'';
        else
            std::cout << str;

        ++field_it;
        if (field_it != fields.end())
            std::cout << ", ";
    } while (field_it != fields.end());
    std::cout << ")" << std::endl;
}
void table_update(const std::string& table_name,
                  mysql::Row_of_fields &old_fields, mysql::Row_of_fields &new_fields)
{
  std::cout << "UPDATE "
           << table_name
           << " SET ";

  int field_id= 0;
  mysql::Row_of_fields::iterator field_it= new_fields.begin();
  mysql::Converter converter;
  do {
    std::string str;
    converter.to(str, *field_it);
    std::cout << field_id << "= ";
    if (is_text_field(*field_it))
      std::cout << '\'';
    std::cout << str;
    if (is_text_field(*field_it))
      std::cout << '\'';
    ++field_it;
    ++field_id;
    if (field_it != new_fields.end())
      std::cout << ", ";
  } while(field_it != new_fields.end());
  std::cout << " WHERE ";
  field_it= old_fields.begin();
  field_id= 0;
  do {
    std::string str;
    converter.to(str, *field_it);
    std::cout << field_id << "= ";
    if (is_text_field(*field_it))
      std::cout << '\'';
    std::cout << str;
    if (is_text_field(*field_it))
      std::cout << '\'';
    ++field_it;
    ++field_id;
    if (field_it != old_fields.end())
      std::cout << " AND ";
  } while(field_it != old_fields.end());
  std::cout << " LIMIT 1" << std::endl;

}
void RowEvent::proc0(mysql::Row_of_fields &fields, VALUE rb_fields) {
  mysql::Row_of_fields::iterator itor = fields.begin();

  do {
    VALUE rval = Qnil;

    if (itor->is_null()) {
      rb_ary_push(rb_fields, rval);
      continue;
    }

    switch(itor->type()) {
      case mysql::system::MYSQL_TYPE_FLOAT:
        rval = rb_float_new(itor->as_float());
        break;

      case mysql::system::MYSQL_TYPE_DOUBLE:
        rval = rb_float_new(itor->as_double());
        break;

      case mysql::system::MYSQL_TYPE_TINY:
        rval = UINT2NUM(itor->as_int8());
        break;

      case mysql::system::MYSQL_TYPE_SHORT:
        rval = UINT2NUM((boost::uint16_t)(itor->as_int16()));
        break;

      case mysql::system::MYSQL_TYPE_INT24: {
        const unsigned char* buf = (const unsigned char*) itor->storage();
//      if (buf[2] & 0x80) {
//        rval = INT2NUM((0xff << 24) | (buf[2] << 16) | (buf[1] << 8) | (buf[0] << 0));
//      } else {
          rval = UINT2NUM((buf[2] << 16) | (buf[1] << 8) | (buf[0] << 0));
//      }
      } break;

      case mysql::system::MYSQL_TYPE_LONG:
        rval = INT2NUM(itor->as_int32());
        break;

      case mysql::system::MYSQL_TYPE_LONGLONG:
        rval = LL2NUM(itor->as_int64());
        break;

      case mysql::system::MYSQL_TYPE_BIT: {
        const unsigned char* buf = (const unsigned char*) itor->storage();
	int len = (itor->metadata() >> 8U) & 0xff;
        if (itor->metadata() & 0xff) len++;

        boost::uint64_t result = 0;
        for(int i = 0; i < len; i++) {
          result |= buf[len - i - 1] << (i * 8);
        }

        rval = INT2NUM(result);
      } break;

      case mysql::system::MYSQL_TYPE_VAR_STRING:
        rval = rb_str_new(itor->storage(), itor->length());
        break;

      case mysql::system::MYSQL_TYPE_TIMESTAMP:
        rval = INT2NUM((boost::uint32_t)itor->as_int32());
        break;

      case mysql::system::MYSQL_TYPE_NEWDECIMAL: {
        std::string s = decimal2str(*itor);
        VALUE BigDecimal = rb_const_get(rb_cObject, rb_intern("BigDecimal"));
        rval = rb_funcall(BigDecimal, rb_intern("new"), 1, rb_str_new(s.c_str(), s.length()));
      } break;

      case mysql::system::MYSQL_TYPE_DATE: {
        const char* storage = itor->storage();
        unsigned int date = (storage[0] & 0xff) + ((storage[1] & 0xff) << 8) + ((storage[2] & 0xff) << 16);
        unsigned int year = date >> 9;
        date-= (year << 9);
        unsigned int month = date >> 5;
        unsigned int day = date - (month << 5);

        VALUE Date = rb_const_get(rb_cObject, rb_intern("Date"));
        rval = rb_funcall(Date, rb_intern("new"), 3, UINT2NUM(year), UINT2NUM(month), UINT2NUM(day));
      } break;

      case mysql::system::MYSQL_TYPE_TIME: {
        const char* storage = itor->storage();
        unsigned int time = (storage[0] & 0xff) + ((storage[1] & 0xff) << 8) + ((storage[2] & 0xff) << 16);
        unsigned int sec = time % 100;
        time -= sec;
        unsigned int min = (time % 10000) / 100;
        unsigned int hour = (time - min) / 10000;

        VALUE Time = rb_const_get(rb_cObject, rb_intern("Time"));
        rval = rb_funcall(Time, rb_intern("utc"), 6, 2000, 1, 1, UINT2NUM(hour), UINT2NUM(min), UINT2NUM(sec));
      } break;

      case mysql::system::MYSQL_TYPE_YEAR: {
        const char* storage = itor->storage();
        unsigned int year = (storage[0] & 0xff);
        rval = INT2NUM(year > 0 ? (year + 1900) : 0);
      } break;

      case mysql::system::MYSQL_TYPE_DATETIME: {
        boost::uint64_t timestamp = itor->as_int64();
        unsigned long d = timestamp / 1000000;
        unsigned long t = timestamp % 1000000;

        VALUE DateTime = rb_const_get(rb_cObject, rb_intern("DateTime"));
        rval = rb_funcall(DateTime, rb_intern("new"), 6,
            INT2FIX(d / 10000), INT2FIX((d % 10000) / 100), INT2FIX(d % 100),
            INT2FIX(t / 10000), INT2FIX((t % 10000) / 100), INT2FIX(t % 100));
      } break;

      case mysql::system::MYSQL_TYPE_STRING:
      case mysql::system::MYSQL_TYPE_VARCHAR: {
        unsigned long size;
        char *ptr = itor->as_c_str(size);
        rval = rb_str_new(ptr, size);
      } break;

      case mysql::system::MYSQL_TYPE_TINY_BLOB:
      case mysql::system::MYSQL_TYPE_MEDIUM_BLOB:
      case mysql::system::MYSQL_TYPE_LONG_BLOB:
      case mysql::system::MYSQL_TYPE_BLOB: {
        unsigned long size;
        unsigned char *ptr = itor->as_blob(size);
        rval = rb_str_new((const char *)ptr, size);
      } break;

      default: break;
    }

    rb_ary_push(rb_fields, rval);
  } while(++itor != fields.end());
}